PREVIEW / futures_30min / 2024-09-29
file: by_date/futures_30min/2024/2024-09-29.parquet size: 29 KB rows: 823
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-09-29 18:00:00 | ES | Futures | 6004.33 | 6014.2 | 5999.14 | 6013.16 | 8459.0 |
| 2024-09-29 18:30:00 | ES | Futures | 6013.16 | 6014.45 | 6012.64 | 6014.45 | 2103.0 |
| 2024-09-29 19:00:00 | ES | Futures | 6014.45 | 6017.57 | 6013.42 | 6016.01 | 2386.0 |
| 2024-09-29 19:30:00 | ES | Futures | 6016.01 | 6022.76 | 6014.45 | 6020.94 | 4293.0 |
| 2024-09-29 20:00:00 | ES | Futures | 6020.94 | 6023.8 | 6018.35 | 6018.87 | 6344.0 |
| 2024-09-29 20:30:00 | ES | Futures | 6019.13 | 6020.94 | 6018.09 | 6018.87 | 2533.0 |
| 2024-09-29 21:00:00 | ES | Futures | 6018.87 | 6018.87 | 6011.86 | 6015.23 | 6932.0 |
| 2024-09-29 21:30:00 | ES | Futures | 6015.23 | 6016.79 | 6007.71 | 6010.56 | 6408.0 |
| 2024-09-29 22:00:00 | ES | Futures | 6010.56 | 6010.56 | 6005.89 | 6008.75 | 3865.0 |
| 2024-09-29 22:30:00 | ES | Futures | 6008.75 | 6012.64 | 6005.89 | 6012.12 | 2899.0 |
| 2024-09-29 23:00:00 | ES | Futures | 6012.38 | 6015.23 | 6012.12 | 6014.97 | 2879.0 |
| 2024-09-29 23:30:00 | ES | Futures | 6014.97 | 6016.79 | 6013.42 | 6016.01 | 2666.0 |
| 2024-09-29 18:00:00 | NQ | Futures | 21080.15 | 21121.37 | 21037.88 | 21116.94 | 3582.0 |
| 2024-09-29 18:30:00 | NQ | Futures | 21117.2 | 21128.94 | 21112.24 | 21128.16 | 1170.0 |
| 2024-09-29 19:00:00 | NQ | Futures | 21128.42 | 21139.12 | 21120.85 | 21135.99 | 1231.0 |
| 2024-09-29 19:30:00 | NQ | Futures | 21135.46 | 21167.82 | 21124.24 | 21158.68 | 2625.0 |
| 2024-09-29 20:00:00 | NQ | Futures | 21161.29 | 21172.51 | 21137.81 | 21140.16 | 3077.0 |
| 2024-09-29 20:30:00 | NQ | Futures | 21142.25 | 21150.07 | 21126.85 | 21131.03 | 1840.0 |
| 2024-09-29 21:00:00 | NQ | Futures | 21131.29 | 21131.55 | 21084.06 | 21097.37 | 3858.0 |
| 2024-09-29 21:30:00 | NQ | Futures | 21098.67 | 21104.68 | 21054.58 | 21073.11 | 3723.0 |
| 2024-09-29 22:00:00 | NQ | Futures | 21073.37 | 21073.63 | 21040.49 | 21052.49 | 2105.0 |
| 2024-09-29 22:30:00 | NQ | Futures | 21053.28 | 21072.58 | 21033.19 | 21070.24 | 1706.0 |
| 2024-09-29 23:00:00 | NQ | Futures | 21071.02 | 21093.98 | 21065.02 | 21093.98 | 1952.0 |
| 2024-09-29 23:30:00 | NQ | Futures | 21093.72 | 21105.72 | 21088.24 | 21102.33 | 1478.0 |
| 2024-09-29 18:00:00 | YM | Futures | 44386.0 | 44404.7 | 44320.4 | 44392.2 | 812.0 |
| 2024-09-29 18:30:00 | YM | Futures | 44397.5 | 44404.7 | 44393.3 | 44398.5 | 169.0 |
| 2024-09-29 19:00:00 | YM | Futures | 44398.5 | 44409.9 | 44390.2 | 44397.5 | 391.0 |
| 2024-09-29 19:30:00 | YM | Futures | 44397.5 | 44447.4 | 44391.2 | 44429.7 | 1109.0 |
| 2024-09-29 20:00:00 | YM | Futures | 44431.8 | 44455.7 | 44413.1 | 44413.1 | 865.0 |
| 2024-09-29 20:30:00 | YM | Futures | 44416.2 | 44428.7 | 44415.1 | 44421.4 | 367.0 |
| 2024-09-29 21:00:00 | YM | Futures | 44420.3 | 44425.6 | 44395.4 | 44416.2 | 618.0 |
| 2024-09-29 21:30:00 | YM | Futures | 44415.1 | 44423.5 | 44368.3 | 44388.1 | 703.0 |
| 2024-09-29 22:00:00 | YM | Futures | 44386.0 | 44396.4 | 44373.5 | 44394.3 | 311.0 |
| 2024-09-29 22:30:00 | YM | Futures | 44392.2 | 44411.0 | 44380.8 | 44411.0 | 155.0 |
| 2024-09-29 23:00:00 | YM | Futures | 44411.0 | 44417.2 | 44403.7 | 44412.0 | 369.0 |
| 2024-09-29 23:30:00 | YM | Futures | 44413.1 | 44416.2 | 44402.7 | 44412.0 | 179.0 |
| 2024-09-29 18:00:00 | CL | Futures | 61.55 | 61.55 | 60.87 | 60.97 | 3866.0 |
| 2024-09-29 18:30:00 | CL | Futures | 60.97 | 61.04 | 60.91 | 60.97 | 784.0 |
| 2024-09-29 19:00:00 | CL | Futures | 60.97 | 61.16 | 60.94 | 61.15 | 946.0 |
| 2024-09-29 19:30:00 | CL | Futures | 61.15 | 61.29 | 61.11 | 61.25 | 709.0 |
| 2024-09-29 20:00:00 | CL | Futures | 61.25 | 61.37 | 61.22 | 61.23 | 1406.0 |
| 2024-09-29 20:30:00 | CL | Futures | 61.22 | 61.37 | 61.14 | 61.35 | 882.0 |
| 2024-09-29 21:00:00 | CL | Futures | 61.35 | 61.87 | 61.35 | 61.66 | 6188.0 |
| 2024-09-29 21:30:00 | CL | Futures | 61.66 | 61.7 | 61.07 | 61.2 | 2919.0 |
| 2024-09-29 22:00:00 | CL | Futures | 61.21 | 61.32 | 61.11 | 61.3 | 1375.0 |
| 2024-09-29 22:30:00 | CL | Futures | 61.3 | 61.64 | 61.3 | 61.53 | 1824.0 |
| 2024-09-29 23:00:00 | CL | Futures | 61.54 | 61.59 | 61.46 | 61.57 | 1182.0 |
| 2024-09-29 23:30:00 | CL | Futures | 61.57 | 61.57 | 61.35 | 61.38 | 1025.0 |
| 2024-09-29 18:00:00 | GC | Futures | 2822.5 | 2827.7 | 2821.2 | 2825.8 | 2730.0 |
| 2024-09-29 18:30:00 | GC | Futures | 2825.7 | 2827.5 | 2824.8 | 2826.7 | 898.0 |
> showing 50 of 823 rows — these rows as CSV