PREVIEW / futures_30min / 2024-06-30
file: by_date/futures_30min/2024/2024-06-30.parquet size: 29 KB rows: 827
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-06-30 18:00:00 | ES | Futures | 5803.52 | 5805.88 | 5797.49 | 5805.36 | 8486.0 |
| 2024-06-30 18:30:00 | ES | Futures | 5805.36 | 5805.88 | 5803.0 | 5803.52 | 3584.0 |
| 2024-06-30 19:00:00 | ES | Futures | 5803.26 | 5803.52 | 5796.71 | 5801.69 | 5881.0 |
| 2024-06-30 19:30:00 | ES | Futures | 5801.69 | 5802.47 | 5797.76 | 5798.28 | 3084.0 |
| 2024-06-30 20:00:00 | ES | Futures | 5798.54 | 5803.52 | 5795.4 | 5803.0 | 5057.0 |
| 2024-06-30 20:30:00 | ES | Futures | 5803.26 | 5804.83 | 5802.21 | 5804.57 | 3188.0 |
| 2024-06-30 21:00:00 | ES | Futures | 5804.57 | 5805.88 | 5803.52 | 5804.05 | 2525.0 |
| 2024-06-30 21:30:00 | ES | Futures | 5804.31 | 5805.88 | 5803.79 | 5805.62 | 3519.0 |
| 2024-06-30 22:00:00 | ES | Futures | 5805.36 | 5807.46 | 5805.1 | 5806.14 | 2403.0 |
| 2024-06-30 22:30:00 | ES | Futures | 5806.41 | 5807.46 | 5805.62 | 5805.88 | 2393.0 |
| 2024-06-30 23:00:00 | ES | Futures | 5805.88 | 5807.72 | 5805.36 | 5806.14 | 2311.0 |
| 2024-06-30 23:30:00 | ES | Futures | 5806.14 | 5806.41 | 5804.57 | 5805.62 | 2248.0 |
| 2024-06-30 18:00:00 | NQ | Futures | 21086.92 | 21099.59 | 21059.73 | 21096.16 | 4000.0 |
| 2024-06-30 18:30:00 | NQ | Futures | 21095.9 | 21102.23 | 21084.02 | 21090.88 | 1855.0 |
| 2024-06-30 19:00:00 | NQ | Futures | 21089.83 | 21090.88 | 21049.17 | 21079.27 | 3498.0 |
| 2024-06-30 19:30:00 | NQ | Futures | 21079.79 | 21084.28 | 21057.62 | 21061.58 | 1609.0 |
| 2024-06-30 20:00:00 | NQ | Futures | 21061.84 | 21094.31 | 21046.27 | 21090.62 | 2942.0 |
| 2024-06-30 20:30:00 | NQ | Futures | 21091.67 | 21101.44 | 21087.45 | 21100.65 | 1863.0 |
| 2024-06-30 21:00:00 | NQ | Futures | 21099.86 | 21109.1 | 21093.26 | 21102.23 | 1876.0 |
| 2024-06-30 21:30:00 | NQ | Futures | 21101.71 | 21110.94 | 21099.07 | 21108.3 | 1690.0 |
| 2024-06-30 22:00:00 | NQ | Futures | 21108.04 | 21117.81 | 21106.19 | 21112.79 | 1623.0 |
| 2024-06-30 22:30:00 | NQ | Futures | 21112.79 | 21120.98 | 21112.79 | 21115.17 | 1314.0 |
| 2024-06-30 23:00:00 | NQ | Futures | 21115.7 | 21123.88 | 21107.78 | 21111.47 | 1816.0 |
| 2024-06-30 23:30:00 | NQ | Futures | 21111.74 | 21119.66 | 21103.55 | 21114.64 | 1693.0 |
| 2024-06-30 18:00:00 | YM | Futures | 41566.8 | 41566.8 | 41489.0 | 41534.2 | 886.0 |
| 2024-06-30 18:30:00 | YM | Futures | 41532.1 | 41537.4 | 41522.7 | 41526.9 | 314.0 |
| 2024-06-30 19:00:00 | YM | Futures | 41525.8 | 41525.8 | 41496.4 | 41518.5 | 732.0 |
| 2024-06-30 19:30:00 | YM | Futures | 41517.4 | 41522.7 | 41493.2 | 41495.3 | 333.0 |
| 2024-06-30 20:00:00 | YM | Futures | 41496.4 | 41526.9 | 41483.8 | 41524.8 | 749.0 |
| 2024-06-30 20:30:00 | YM | Futures | 41523.7 | 41538.4 | 41518.5 | 41533.2 | 502.0 |
| 2024-06-30 21:00:00 | YM | Futures | 41531.1 | 41534.2 | 41520.6 | 41529.0 | 330.0 |
| 2024-06-30 21:30:00 | YM | Futures | 41530.0 | 41537.4 | 41521.6 | 41530.0 | 320.0 |
| 2024-06-30 22:00:00 | YM | Futures | 41530.0 | 41535.3 | 41525.8 | 41529.0 | 256.0 |
| 2024-06-30 22:30:00 | YM | Futures | 41530.0 | 41535.3 | 41525.8 | 41525.8 | 244.0 |
| 2024-06-30 23:00:00 | YM | Futures | 41526.9 | 41536.3 | 41524.8 | 41532.1 | 316.0 |
| 2024-06-30 23:30:00 | YM | Futures | 41531.1 | 41531.1 | 41521.6 | 41524.8 | 190.0 |
| 2024-06-30 18:00:00 | CL | Futures | 69.66 | 69.86 | 69.6 | 69.75 | 842.0 |
| 2024-06-30 18:30:00 | CL | Futures | 69.75 | 69.76 | 69.64 | 69.68 | 423.0 |
| 2024-06-30 19:00:00 | CL | Futures | 69.69 | 69.84 | 69.67 | 69.84 | 583.0 |
| 2024-06-30 19:30:00 | CL | Futures | 69.85 | 69.99 | 69.84 | 69.9 | 938.0 |
| 2024-06-30 20:00:00 | CL | Futures | 69.89 | 69.93 | 69.81 | 69.89 | 1465.0 |
| 2024-06-30 20:30:00 | CL | Futures | 69.9 | 69.92 | 69.85 | 69.88 | 399.0 |
| 2024-06-30 21:00:00 | CL | Futures | 69.87 | 70.02 | 69.83 | 69.99 | 1065.0 |
| 2024-06-30 21:30:00 | CL | Futures | 69.99 | 70.06 | 69.98 | 70.0 | 476.0 |
| 2024-06-30 22:00:00 | CL | Futures | 70.0 | 70.08 | 69.96 | 70.06 | 717.0 |
| 2024-06-30 22:30:00 | CL | Futures | 70.07 | 70.08 | 70.02 | 70.05 | 295.0 |
| 2024-06-30 23:00:00 | CL | Futures | 70.05 | 70.16 | 70.04 | 70.12 | 844.0 |
| 2024-06-30 23:30:00 | CL | Futures | 70.12 | 70.12 | 70.05 | 70.08 | 533.0 |
| 2024-06-30 18:00:00 | GC | Futures | 2508.7 | 2510.0 | 2505.4 | 2507.2 | 1022.0 |
| 2024-06-30 18:30:00 | GC | Futures | 2507.1 | 2507.5 | 2506.0 | 2507.1 | 362.0 |
> showing 50 of 827 rows — these rows as CSV