PREVIEW / futures_30min / 2024-01-21
file: by_date/futures_30min/2024/2024-01-21.parquet size: 29 KB rows: 824
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-01-21 18:00:00 | ES | Futures | 5234.83 | 5242.08 | 5234.83 | 5236.71 | 7619.0 |
| 2024-01-21 18:30:00 | ES | Futures | 5236.44 | 5239.13 | 5236.17 | 5236.98 | 3647.0 |
| 2024-01-21 19:00:00 | ES | Futures | 5236.98 | 5239.67 | 5235.91 | 5239.67 | 3654.0 |
| 2024-01-21 19:30:00 | ES | Futures | 5239.67 | 5250.14 | 5239.13 | 5249.33 | 10395.0 |
| 2024-01-21 20:00:00 | ES | Futures | 5249.07 | 5250.95 | 5245.31 | 5247.99 | 9674.0 |
| 2024-01-21 20:30:00 | ES | Futures | 5247.99 | 5248.53 | 5244.5 | 5246.11 | 5442.0 |
| 2024-01-21 21:00:00 | ES | Futures | 5246.11 | 5248.26 | 5244.5 | 5244.5 | 3685.0 |
| 2024-01-21 21:30:00 | ES | Futures | 5244.77 | 5246.11 | 5242.62 | 5244.77 | 3248.0 |
| 2024-01-21 22:00:00 | ES | Futures | 5245.04 | 5245.57 | 5243.16 | 5244.23 | 2886.0 |
| 2024-01-21 22:30:00 | ES | Futures | 5244.5 | 5246.38 | 5243.16 | 5244.5 | 2606.0 |
| 2024-01-21 23:00:00 | ES | Futures | 5244.5 | 5246.65 | 5244.23 | 5245.31 | 2493.0 |
| 2024-01-21 23:30:00 | ES | Futures | 5245.31 | 5245.57 | 5244.5 | 5245.31 | 1616.0 |
| 2024-01-21 18:00:00 | NQ | Futures | 18947.51 | 18983.85 | 18947.51 | 18962.43 | 6432.0 |
| 2024-01-21 18:30:00 | NQ | Futures | 18962.43 | 18977.88 | 18956.73 | 18967.04 | 2962.0 |
| 2024-01-21 19:00:00 | NQ | Futures | 18967.58 | 18981.68 | 18962.7 | 18981.41 | 2384.0 |
| 2024-01-21 19:30:00 | NQ | Futures | 18981.68 | 19052.74 | 18980.05 | 19045.69 | 8643.0 |
| 2024-01-21 20:00:00 | NQ | Futures | 19045.41 | 19059.25 | 19034.02 | 19049.48 | 7892.0 |
| 2024-01-21 20:30:00 | NQ | Futures | 19048.94 | 19056.8 | 19030.5 | 19036.46 | 4241.0 |
| 2024-01-21 21:00:00 | NQ | Futures | 19037.28 | 19051.65 | 19031.58 | 19035.65 | 2869.0 |
| 2024-01-21 21:30:00 | NQ | Futures | 19036.46 | 19042.97 | 19025.07 | 19038.36 | 2708.0 |
| 2024-01-21 22:00:00 | NQ | Futures | 19038.63 | 19040.53 | 19027.24 | 19032.94 | 1709.0 |
| 2024-01-21 22:30:00 | NQ | Futures | 19033.48 | 19043.79 | 19030.23 | 19035.11 | 1823.0 |
| 2024-01-21 23:00:00 | NQ | Futures | 19035.38 | 19044.33 | 19035.38 | 19039.99 | 1393.0 |
| 2024-01-21 23:30:00 | NQ | Futures | 19039.72 | 19044.06 | 19034.02 | 19041.35 | 920.0 |
| 2024-01-21 18:00:00 | YM | Futures | 40866.5 | 40938.5 | 40866.5 | 40894.4 | 1131.0 |
| 2024-01-21 18:30:00 | YM | Futures | 40893.4 | 40915.9 | 40893.4 | 40905.2 | 710.0 |
| 2024-01-21 19:00:00 | YM | Futures | 40904.1 | 40919.1 | 40893.4 | 40915.9 | 555.0 |
| 2024-01-21 19:30:00 | YM | Futures | 40915.9 | 40975.0 | 40913.8 | 40970.7 | 1848.0 |
| 2024-01-21 20:00:00 | YM | Futures | 40969.6 | 40983.6 | 40934.2 | 40950.3 | 1298.0 |
| 2024-01-21 20:30:00 | YM | Futures | 40951.4 | 40951.4 | 40928.8 | 40941.7 | 538.0 |
| 2024-01-21 21:00:00 | YM | Futures | 40939.5 | 40952.4 | 40932.0 | 40932.0 | 374.0 |
| 2024-01-21 21:30:00 | YM | Futures | 40932.0 | 40937.4 | 40917.0 | 40931.0 | 422.0 |
| 2024-01-21 22:00:00 | YM | Futures | 40931.0 | 40936.3 | 40920.2 | 40932.0 | 368.0 |
| 2024-01-21 22:30:00 | YM | Futures | 40932.0 | 40943.8 | 40920.2 | 40929.9 | 454.0 |
| 2024-01-21 23:00:00 | YM | Futures | 40929.9 | 40939.5 | 40926.7 | 40928.8 | 330.0 |
| 2024-01-21 23:30:00 | YM | Futures | 40929.9 | 40931.0 | 40922.4 | 40926.7 | 210.0 |
| 2024-01-21 18:00:00 | CL | Futures | 61.56 | 61.63 | 61.13 | 61.24 | 2504.0 |
| 2024-01-21 18:30:00 | CL | Futures | 61.24 | 61.26 | 61.15 | 61.21 | 824.0 |
| 2024-01-21 19:00:00 | CL | Futures | 61.21 | 61.25 | 61.1 | 61.12 | 982.0 |
| 2024-01-21 19:30:00 | CL | Futures | 61.12 | 61.18 | 61.0 | 61.08 | 1885.0 |
| 2024-01-21 20:00:00 | CL | Futures | 61.08 | 61.23 | 60.97 | 61.11 | 2182.0 |
| 2024-01-21 20:30:00 | CL | Futures | 61.11 | 61.13 | 61.01 | 61.06 | 1218.0 |
| 2024-01-21 21:00:00 | CL | Futures | 61.05 | 61.07 | 60.97 | 61.02 | 957.0 |
| 2024-01-21 21:30:00 | CL | Futures | 61.03 | 61.18 | 60.98 | 61.18 | 1215.0 |
| 2024-01-21 22:00:00 | CL | Futures | 61.18 | 61.39 | 61.13 | 61.33 | 1912.0 |
| 2024-01-21 22:30:00 | CL | Futures | 61.33 | 61.36 | 61.21 | 61.23 | 1045.0 |
| 2024-01-21 23:00:00 | CL | Futures | 61.23 | 61.23 | 61.07 | 61.08 | 820.0 |
| 2024-01-21 23:30:00 | CL | Futures | 61.08 | 61.09 | 60.99 | 61.03 | 652.0 |
| 2024-01-21 18:00:00 | GC | Futures | 2247.8 | 2248.2 | 2244.6 | 2245.2 | 1684.0 |
| 2024-01-21 18:30:00 | GC | Futures | 2245.2 | 2245.5 | 2244.5 | 2245.0 | 541.0 |
> showing 50 of 824 rows — these rows as CSV