PREVIEW / futures_30min / 2024-03-24
file: by_date/futures_30min/2024/2024-03-24.parquet size: 29 KB rows: 801
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-03-24 18:00:00 | ES | Futures | 5614.19 | 5617.11 | 5612.33 | 5612.86 | 4680.0 |
| 2024-03-24 18:30:00 | ES | Futures | 5612.86 | 5613.92 | 5610.74 | 5613.13 | 1530.0 |
| 2024-03-24 19:00:00 | ES | Futures | 5612.86 | 5616.31 | 5611.0 | 5615.25 | 6192.0 |
| 2024-03-24 19:30:00 | ES | Futures | 5615.25 | 5617.11 | 5614.72 | 5616.84 | 3440.0 |
| 2024-03-24 20:00:00 | ES | Futures | 5616.84 | 5618.7 | 5616.04 | 5616.84 | 4041.0 |
| 2024-03-24 20:30:00 | ES | Futures | 5617.11 | 5617.64 | 5614.98 | 5615.51 | 4072.0 |
| 2024-03-24 21:00:00 | ES | Futures | 5615.51 | 5617.37 | 5613.92 | 5617.11 | 8059.0 |
| 2024-03-24 21:30:00 | ES | Futures | 5617.11 | 5618.96 | 5616.04 | 5617.11 | 8024.0 |
| 2024-03-24 22:00:00 | ES | Futures | 5617.11 | 5617.11 | 5611.0 | 5613.13 | 5115.0 |
| 2024-03-24 22:30:00 | ES | Futures | 5613.39 | 5614.19 | 5612.33 | 5613.92 | 2122.0 |
| 2024-03-24 23:00:00 | ES | Futures | 5614.19 | 5614.19 | 5611.8 | 5612.86 | 1859.0 |
| 2024-03-24 23:30:00 | ES | Futures | 5612.86 | 5613.39 | 5611.53 | 5613.39 | 1281.0 |
| 2024-03-24 18:00:00 | NQ | Futures | 19866.99 | 19885.71 | 19861.37 | 19862.98 | 3164.0 |
| 2024-03-24 18:30:00 | NQ | Futures | 19864.05 | 19868.06 | 19851.74 | 19860.84 | 1387.0 |
| 2024-03-24 19:00:00 | NQ | Futures | 19860.3 | 19877.96 | 19855.49 | 19872.34 | 1805.0 |
| 2024-03-24 19:30:00 | NQ | Futures | 19872.61 | 19889.46 | 19872.07 | 19886.78 | 1449.0 |
| 2024-03-24 20:00:00 | NQ | Futures | 19887.59 | 19899.62 | 19886.78 | 19891.6 | 2077.0 |
| 2024-03-24 20:30:00 | NQ | Futures | 19891.87 | 19894.54 | 19882.5 | 19884.91 | 1504.0 |
| 2024-03-24 21:00:00 | NQ | Futures | 19885.18 | 19894.54 | 19878.22 | 19892.67 | 2029.0 |
| 2024-03-24 21:30:00 | NQ | Futures | 19892.94 | 19903.64 | 19887.05 | 19892.67 | 2202.0 |
| 2024-03-24 22:00:00 | NQ | Futures | 19892.4 | 19892.94 | 19865.65 | 19873.68 | 2425.0 |
| 2024-03-24 22:30:00 | NQ | Futures | 19874.21 | 19878.76 | 19865.65 | 19878.22 | 1645.0 |
| 2024-03-24 23:00:00 | NQ | Futures | 19877.96 | 19878.22 | 19866.99 | 19872.87 | 1529.0 |
| 2024-03-24 23:30:00 | NQ | Futures | 19872.07 | 19877.15 | 19866.99 | 19876.89 | 853.0 |
| 2024-03-24 18:00:00 | YM | Futures | 42306.7 | 42309.9 | 42262.1 | 42285.5 | 1242.0 |
| 2024-03-24 18:30:00 | YM | Futures | 42286.5 | 42296.1 | 42277.0 | 42291.9 | 307.0 |
| 2024-03-24 19:00:00 | YM | Futures | 42289.7 | 42302.5 | 42280.2 | 42292.9 | 570.0 |
| 2024-03-24 19:30:00 | YM | Futures | 42292.9 | 42298.2 | 42286.5 | 42298.2 | 306.0 |
| 2024-03-24 20:00:00 | YM | Futures | 42299.3 | 42305.7 | 42288.7 | 42290.8 | 539.0 |
| 2024-03-24 20:30:00 | YM | Futures | 42290.8 | 42292.9 | 42282.3 | 42286.5 | 379.0 |
| 2024-03-24 21:00:00 | YM | Futures | 42285.5 | 42287.6 | 42272.7 | 42286.5 | 624.0 |
| 2024-03-24 21:30:00 | YM | Futures | 42285.5 | 42301.4 | 42283.4 | 42286.5 | 596.0 |
| 2024-03-24 22:00:00 | YM | Futures | 42286.5 | 42288.7 | 42258.9 | 42267.4 | 444.0 |
| 2024-03-24 22:30:00 | YM | Futures | 42266.4 | 42275.9 | 42265.3 | 42272.7 | 197.0 |
| 2024-03-24 23:00:00 | YM | Futures | 42272.7 | 42273.8 | 42262.1 | 42264.2 | 174.0 |
| 2024-03-24 23:30:00 | YM | Futures | 42264.2 | 42267.4 | 42252.6 | 42267.4 | 241.0 |
| 2024-03-24 18:00:00 | CL | Futures | 68.03 | 68.08 | 67.81 | 67.95 | 1399.0 |
| 2024-03-24 18:30:00 | CL | Futures | 67.96 | 68.09 | 67.93 | 67.99 | 757.0 |
| 2024-03-24 19:00:00 | CL | Futures | 67.98 | 68.05 | 67.97 | 68.03 | 346.0 |
| 2024-03-24 19:30:00 | CL | Futures | 68.03 | 68.07 | 68.03 | 68.06 | 402.0 |
| 2024-03-24 20:00:00 | CL | Futures | 68.05 | 68.13 | 68.02 | 68.07 | 650.0 |
| 2024-03-24 20:30:00 | CL | Futures | 68.07 | 68.12 | 68.06 | 68.09 | 376.0 |
| 2024-03-24 21:00:00 | CL | Futures | 68.09 | 68.25 | 68.09 | 68.24 | 1723.0 |
| 2024-03-24 21:30:00 | CL | Futures | 68.23 | 68.3 | 68.19 | 68.28 | 1284.0 |
| 2024-03-24 22:00:00 | CL | Futures | 68.27 | 68.29 | 68.25 | 68.27 | 535.0 |
| 2024-03-24 22:30:00 | CL | Futures | 68.27 | 68.35 | 68.25 | 68.32 | 871.0 |
| 2024-03-24 23:00:00 | CL | Futures | 68.32 | 68.39 | 68.26 | 68.35 | 884.0 |
| 2024-03-24 23:30:00 | CL | Futures | 68.34 | 68.35 | 68.27 | 68.31 | 630.0 |
| 2024-03-24 18:00:00 | GC | Futures | 2374.7 | 2377.3 | 2374.4 | 2375.6 | 1242.0 |
| 2024-03-24 18:30:00 | GC | Futures | 2375.5 | 2376.4 | 2374.4 | 2375.9 | 879.0 |
> showing 50 of 801 rows — these rows as CSV