Missunderstanding of data processing

i am trying to get familiar with influx, so I am trying to save data into the influxdb using the line format:
“public-trades,direction=sell,instrument_name=BTC-PERPETUAL,tick_direction=1 trade_seq=30970259,trade_id=49052298,price=9560.0,mark_price=9558.45,index_price=9556.15,amount=10 1592281484599”

when I query the data, i can not get the whole “line” or data point. Everyting is splitted into several tables which look like this:

Do i save the data wrong way or I query the data the worng way? I want to just get the trades back - one trade one row.


Hello @Frantisek_Falta,
It looks like all that data in your picture is part of the same table: table 0 This means that your data in that table has the same series group key.
I think this documentation will be helpful to you:

Can you give me a little bit more information? What are you visualizing right now, and what do you expect to see as the output with your query? Can you please share your query? Thank you!!

Just a guess, but does this query give you what you want?

from(bucket: "my-bucket")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "public-trades")
  |> filter(fn: (r) => r["_field"] == "mark-price")
  |> filter(fn: (r) => r["instrument_name"] == "BTC-PERPETUAL")

Also, try adding a group() on the end as well.