PREVIEW / futures_30min / 2024-08-04
file: by_date/futures_30min/2024/2024-08-04.parquet size: 33 KB rows: 866
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-08-04 18:00:00 | ES | Futures | 5589.34 | 5597.46 | 5580.16 | 5597.2 | 22212.0 |
| 2024-08-04 18:30:00 | ES | Futures | 5597.2 | 5605.59 | 5596.15 | 5596.94 | 7858.0 |
| 2024-08-04 19:00:00 | ES | Futures | 5596.68 | 5597.99 | 5582.52 | 5587.24 | 9676.0 |
| 2024-08-04 19:30:00 | ES | Futures | 5587.24 | 5588.02 | 5571.51 | 5583.04 | 16664.0 |
| 2024-08-04 20:00:00 | ES | Futures | 5583.04 | 5583.57 | 5556.04 | 5574.92 | 31154.0 |
| 2024-08-04 20:30:00 | ES | Futures | 5574.92 | 5576.75 | 5560.24 | 5562.07 | 17121.0 |
| 2024-08-04 21:00:00 | ES | Futures | 5562.07 | 5564.69 | 5544.51 | 5551.06 | 26223.0 |
| 2024-08-04 21:30:00 | ES | Futures | 5550.8 | 5562.86 | 5549.75 | 5562.07 | 15025.0 |
| 2024-08-04 22:00:00 | ES | Futures | 5562.07 | 5573.08 | 5553.94 | 5566.79 | 13267.0 |
| 2024-08-04 22:30:00 | ES | Futures | 5566.79 | 5569.67 | 5553.16 | 5560.76 | 11904.0 |
| 2024-08-04 23:00:00 | ES | Futures | 5561.02 | 5565.74 | 5554.47 | 5555.25 | 7695.0 |
| 2024-08-04 23:30:00 | ES | Futures | 5555.52 | 5558.4 | 5548.96 | 5549.22 | 12054.0 |
| 2024-08-04 18:00:00 | NQ | Futures | 19418.55 | 19418.55 | 19291.05 | 19371.04 | 11019.0 |
| 2024-08-04 18:30:00 | NQ | Futures | 19371.3 | 19414.86 | 19366.81 | 19373.15 | 3862.0 |
| 2024-08-04 19:00:00 | NQ | Futures | 19373.15 | 19384.5 | 19293.95 | 19314.02 | 4706.0 |
| 2024-08-04 19:30:00 | NQ | Futures | 19316.66 | 19321.14 | 19232.18 | 19284.19 | 5084.0 |
| 2024-08-04 20:00:00 | NQ | Futures | 19284.45 | 19296.06 | 19184.14 | 19252.51 | 8422.0 |
| 2024-08-04 20:30:00 | NQ | Futures | 19252.51 | 19267.29 | 19177.54 | 19192.06 | 7138.0 |
| 2024-08-04 21:00:00 | NQ | Futures | 19191.26 | 19199.45 | 19078.54 | 19126.59 | 9363.0 |
| 2024-08-04 21:30:00 | NQ | Futures | 19125.8 | 19163.81 | 19090.69 | 19143.48 | 6872.0 |
| 2024-08-04 22:00:00 | NQ | Futures | 19145.33 | 19193.38 | 19112.33 | 19156.95 | 5429.0 |
| 2024-08-04 22:30:00 | NQ | Futures | 19155.1 | 19169.35 | 19097.02 | 19126.32 | 4262.0 |
| 2024-08-04 23:00:00 | NQ | Futures | 19126.06 | 19153.51 | 19073.53 | 19078.81 | 3881.0 |
| 2024-08-04 23:30:00 | NQ | Futures | 19081.71 | 19092.01 | 19030.5 | 19035.51 | 4640.0 |
| 2024-08-04 18:00:00 | YM | Futures | 41633.0 | 41717.0 | 41561.5 | 41716.0 | 1504.0 |
| 2024-08-04 18:30:00 | YM | Futures | 41716.0 | 41766.4 | 41714.9 | 41718.1 | 965.0 |
| 2024-08-04 19:00:00 | YM | Futures | 41719.1 | 41734.9 | 41670.8 | 41681.3 | 1403.0 |
| 2024-08-04 19:30:00 | YM | Futures | 41682.4 | 41683.4 | 41595.2 | 41657.2 | 1911.0 |
| 2024-08-04 20:00:00 | YM | Futures | 41654.0 | 41663.5 | 41464.9 | 41597.3 | 2870.0 |
| 2024-08-04 20:30:00 | YM | Futures | 41597.3 | 41598.3 | 41516.4 | 41543.7 | 2319.0 |
| 2024-08-04 21:00:00 | YM | Futures | 41541.6 | 41562.6 | 41481.7 | 41506.9 | 2118.0 |
| 2024-08-04 21:30:00 | YM | Futures | 41506.9 | 41618.3 | 41505.8 | 41606.7 | 1628.0 |
| 2024-08-04 22:00:00 | YM | Futures | 41607.8 | 41693.9 | 41554.2 | 41659.3 | 1369.0 |
| 2024-08-04 22:30:00 | YM | Futures | 41659.3 | 41684.5 | 41578.4 | 41630.9 | 1097.0 |
| 2024-08-04 23:00:00 | YM | Futures | 41629.8 | 41658.2 | 41597.3 | 41614.1 | 960.0 |
| 2024-08-04 23:30:00 | YM | Futures | 41619.3 | 41642.4 | 41600.4 | 41600.4 | 1267.0 |
| 2024-08-04 18:00:00 | CL | Futures | 64.42 | 64.64 | 63.96 | 64.15 | 5499.0 |
| 2024-08-04 18:30:00 | CL | Futures | 64.15 | 64.23 | 64.1 | 64.14 | 1326.0 |
| 2024-08-04 19:00:00 | CL | Futures | 64.15 | 64.33 | 64.12 | 64.17 | 1263.0 |
| 2024-08-04 19:30:00 | CL | Futures | 64.17 | 64.22 | 64.05 | 64.22 | 1113.0 |
| 2024-08-04 20:00:00 | CL | Futures | 64.22 | 64.24 | 63.68 | 63.86 | 3918.0 |
| 2024-08-04 20:30:00 | CL | Futures | 63.87 | 63.92 | 63.3 | 63.56 | 6917.0 |
| 2024-08-04 21:00:00 | CL | Futures | 63.55 | 63.98 | 63.33 | 63.85 | 6135.0 |
| 2024-08-04 21:30:00 | CL | Futures | 63.86 | 64.08 | 63.82 | 63.92 | 2440.0 |
| 2024-08-04 22:00:00 | CL | Futures | 63.93 | 64.12 | 63.81 | 64.05 | 1805.0 |
| 2024-08-04 22:30:00 | CL | Futures | 64.05 | 64.25 | 64.01 | 64.16 | 1825.0 |
| 2024-08-04 23:00:00 | CL | Futures | 64.16 | 64.23 | 64.02 | 64.05 | 1676.0 |
| 2024-08-04 23:30:00 | CL | Futures | 64.05 | 64.06 | 63.9 | 63.94 | 1336.0 |
| 2024-08-04 18:00:00 | GC | Futures | 2622.2 | 2622.3 | 2611.5 | 2612.3 | 4053.0 |
| 2024-08-04 18:30:00 | GC | Futures | 2612.2 | 2615.0 | 2611.8 | 2615.0 | 725.0 |
> showing 50 of 866 rows — these rows as CSV