PREVIEW / futures_30min / 2024-07-15
file: by_date/futures_30min/2024/2024-07-15.parquet size: 106 KB rows: 3,880
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2024-07-15 00:00:00 | ES | Futures | 5951.65 | 5952.17 | 5950.86 | 5951.65 | 636.0 |
| 2024-07-15 00:30:00 | ES | Futures | 5951.65 | 5953.48 | 5951.38 | 5952.69 | 1400.0 |
| 2024-07-15 01:00:00 | ES | Futures | 5952.69 | 5954.01 | 5952.17 | 5954.01 | 1557.0 |
| 2024-07-15 01:30:00 | ES | Futures | 5954.01 | 5956.63 | 5953.48 | 5955.58 | 2567.0 |
| 2024-07-15 02:00:00 | ES | Futures | 5955.58 | 5957.41 | 5954.01 | 5955.84 | 4223.0 |
| 2024-07-15 02:30:00 | ES | Futures | 5955.58 | 5957.94 | 5955.58 | 5957.68 | 2655.0 |
| 2024-07-15 03:00:00 | ES | Futures | 5957.68 | 5959.25 | 5956.36 | 5958.72 | 8292.0 |
| 2024-07-15 03:30:00 | ES | Futures | 5958.72 | 5960.82 | 5957.94 | 5960.3 | 6531.0 |
| 2024-07-15 04:00:00 | ES | Futures | 5960.56 | 5964.75 | 5960.3 | 5963.44 | 8028.0 |
| 2024-07-15 04:30:00 | ES | Futures | 5963.44 | 5965.8 | 5963.44 | 5965.54 | 4224.0 |
| 2024-07-15 05:00:00 | ES | Futures | 5965.54 | 5966.85 | 5964.49 | 5966.59 | 4144.0 |
| 2024-07-15 05:30:00 | ES | Futures | 5966.59 | 5967.11 | 5965.02 | 5965.28 | 3980.0 |
| 2024-07-15 06:00:00 | ES | Futures | 5965.02 | 5966.07 | 5962.66 | 5964.75 | 4508.0 |
| 2024-07-15 06:30:00 | ES | Futures | 5965.02 | 5966.33 | 5964.49 | 5966.07 | 2678.0 |
| 2024-07-15 07:00:00 | ES | Futures | 5966.07 | 5970.0 | 5965.8 | 5969.47 | 9241.0 |
| 2024-07-15 07:30:00 | ES | Futures | 5969.47 | 5971.83 | 5963.97 | 5964.75 | 13924.0 |
| 2024-07-15 08:00:00 | ES | Futures | 5965.02 | 5967.38 | 5960.56 | 5965.8 | 12346.0 |
| 2024-07-15 08:30:00 | ES | Futures | 5965.8 | 5967.64 | 5961.08 | 5962.92 | 13385.0 |
| 2024-07-15 09:00:00 | ES | Futures | 5963.18 | 5968.42 | 5962.39 | 5967.11 | 18355.0 |
| 2024-07-15 09:30:00 | ES | Futures | 5967.38 | 5975.24 | 5959.77 | 5965.54 | 186853.0 |
| 2024-07-15 10:00:00 | ES | Futures | 5965.54 | 5974.72 | 5965.54 | 5974.19 | 99906.0 |
| 2024-07-15 10:30:00 | ES | Futures | 5974.19 | 5985.73 | 5973.41 | 5984.42 | 89122.0 |
| 2024-07-15 11:00:00 | ES | Futures | 5984.42 | 5997.0 | 5983.63 | 5985.2 | 107374.0 |
| 2024-07-15 11:30:00 | ES | Futures | 5984.94 | 5989.66 | 5978.91 | 5985.73 | 109845.0 |
| 2024-07-15 12:00:00 | ES | Futures | 5985.47 | 5985.73 | 5968.16 | 5976.29 | 128037.0 |
| 2024-07-15 12:30:00 | ES | Futures | 5976.03 | 5979.44 | 5969.21 | 5972.88 | 83811.0 |
| 2024-07-15 13:00:00 | ES | Futures | 5972.88 | 5972.88 | 5959.77 | 5962.92 | 109399.0 |
| 2024-07-15 13:30:00 | ES | Futures | 5962.92 | 5963.44 | 5952.96 | 5956.89 | 99595.0 |
| 2024-07-15 14:00:00 | ES | Futures | 5956.89 | 5965.28 | 5952.69 | 5964.49 | 62377.0 |
| 2024-07-15 14:30:00 | ES | Futures | 5964.75 | 5972.36 | 5962.92 | 5969.74 | 71976.0 |
| 2024-07-15 15:00:00 | ES | Futures | 5969.74 | 5972.88 | 5966.07 | 5967.64 | 63770.0 |
| 2024-07-15 15:30:00 | ES | Futures | 5967.64 | 5970.26 | 5941.68 | 5962.13 | 203144.0 |
| 2024-07-15 16:00:00 | ES | Futures | 5961.87 | 5964.75 | 5958.72 | 5963.44 | 48129.0 |
| 2024-07-15 16:30:00 | ES | Futures | 5963.44 | 5966.33 | 5963.18 | 5965.02 | 8139.0 |
| 2024-07-15 18:00:00 | ES | Futures | 5965.54 | 5971.83 | 5964.75 | 5971.57 | 3187.0 |
| 2024-07-15 18:30:00 | ES | Futures | 5971.57 | 5971.57 | 5968.42 | 5969.47 | 2327.0 |
| 2024-07-15 19:00:00 | ES | Futures | 5969.47 | 5970.52 | 5968.95 | 5970.26 | 982.0 |
| 2024-07-15 19:30:00 | ES | Futures | 5970.26 | 5971.05 | 5968.95 | 5969.21 | 1411.0 |
| 2024-07-15 20:00:00 | ES | Futures | 5969.21 | 5970.0 | 5967.9 | 5968.95 | 2898.0 |
| 2024-07-15 20:30:00 | ES | Futures | 5968.95 | 5969.21 | 5966.33 | 5967.64 | 2036.0 |
| 2024-07-15 21:00:00 | ES | Futures | 5967.64 | 5968.95 | 5965.8 | 5967.11 | 3182.0 |
| 2024-07-15 21:30:00 | ES | Futures | 5967.11 | 5968.42 | 5966.85 | 5967.9 | 1914.0 |
| 2024-07-15 22:00:00 | ES | Futures | 5967.9 | 5970.0 | 5967.9 | 5970.0 | 2331.0 |
| 2024-07-15 22:30:00 | ES | Futures | 5970.26 | 5970.78 | 5969.21 | 5970.52 | 1129.0 |
| 2024-07-15 23:00:00 | ES | Futures | 5970.52 | 5971.57 | 5968.69 | 5971.31 | 1857.0 |
| 2024-07-15 23:30:00 | ES | Futures | 5971.05 | 5971.31 | 5969.74 | 5969.74 | 1066.0 |
| 2024-07-15 00:00:00 | NQ | Futures | 21726.29 | 21730.25 | 21723.65 | 21728.66 | 572.0 |
| 2024-07-15 00:30:00 | NQ | Futures | 21728.66 | 21743.18 | 21727.87 | 21740.54 | 1368.0 |
| 2024-07-15 01:00:00 | NQ | Futures | 21739.49 | 21750.31 | 21737.9 | 21748.99 | 1383.0 |
| 2024-07-15 01:30:00 | NQ | Futures | 21748.99 | 21766.41 | 21748.2 | 21761.66 | 1766.0 |
> showing 50 of 3,880 rows — these rows as CSV