PREVIEW / futures_30min / 2023-01-22
file: by_date/futures_30min/2023/2023-01-22.parquet size: 28 KB rows: 795
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 |
|---|---|---|---|---|---|---|---|
| 2023-01-22 18:00:00 | ES | Futures | 4459.17 | 4462.52 | 4454.69 | 4456.37 | 6485.0 |
| 2023-01-22 18:30:00 | ES | Futures | 4456.65 | 4457.21 | 4452.73 | 4454.97 | 2620.0 |
| 2023-01-22 19:00:00 | ES | Futures | 4454.97 | 4455.53 | 4452.18 | 4454.97 | 4403.0 |
| 2023-01-22 19:30:00 | ES | Futures | 4455.25 | 4457.77 | 4452.73 | 4454.97 | 6440.0 |
| 2023-01-22 20:00:00 | ES | Futures | 4454.97 | 4458.61 | 4454.13 | 4457.49 | 3912.0 |
| 2023-01-22 20:30:00 | ES | Futures | 4457.77 | 4458.05 | 4456.09 | 4456.93 | 1770.0 |
| 2023-01-22 21:00:00 | ES | Futures | 4456.93 | 4459.44 | 4456.65 | 4457.49 | 2027.0 |
| 2023-01-22 21:30:00 | ES | Futures | 4457.49 | 4458.05 | 4454.69 | 4456.09 | 1783.0 |
| 2023-01-22 22:00:00 | ES | Futures | 4455.81 | 4458.05 | 4455.81 | 4456.93 | 1262.0 |
| 2023-01-22 22:30:00 | ES | Futures | 4456.93 | 4457.49 | 4455.81 | 4456.65 | 1207.0 |
| 2023-01-22 23:00:00 | ES | Futures | 4456.65 | 4458.05 | 4454.69 | 4455.25 | 2415.0 |
| 2023-01-22 23:30:00 | ES | Futures | 4455.25 | 4457.49 | 4454.97 | 4457.49 | 1293.0 |
| 2023-01-22 18:00:00 | NQ | Futures | 13287.86 | 13297.54 | 13270.79 | 13273.35 | 3138.0 |
| 2023-01-22 18:30:00 | NQ | Futures | 13273.35 | 13273.92 | 13257.99 | 13266.53 | 2037.0 |
| 2023-01-22 19:00:00 | NQ | Futures | 13266.53 | 13272.79 | 13258.28 | 13268.8 | 1585.0 |
| 2023-01-22 19:30:00 | NQ | Futures | 13270.23 | 13277.91 | 13259.7 | 13266.81 | 1734.0 |
| 2023-01-22 20:00:00 | NQ | Futures | 13266.53 | 13277.62 | 13263.97 | 13273.64 | 1030.0 |
| 2023-01-22 20:30:00 | NQ | Futures | 13274.21 | 13276.2 | 13269.66 | 13271.93 | 572.0 |
| 2023-01-22 21:00:00 | NQ | Futures | 13272.5 | 13283.6 | 13271.93 | 13278.19 | 838.0 |
| 2023-01-22 21:30:00 | NQ | Futures | 13278.48 | 13280.47 | 13269.94 | 13273.92 | 563.0 |
| 2023-01-22 22:00:00 | NQ | Futures | 13273.92 | 13280.75 | 13272.79 | 13277.34 | 508.0 |
| 2023-01-22 22:30:00 | NQ | Futures | 13276.77 | 13278.19 | 13271.65 | 13275.92 | 533.0 |
| 2023-01-22 23:00:00 | NQ | Futures | 13275.92 | 13279.61 | 13267.38 | 13269.09 | 834.0 |
| 2023-01-22 23:30:00 | NQ | Futures | 13268.8 | 13277.05 | 13267.95 | 13276.77 | 1015.0 |
| 2023-01-22 18:00:00 | YM | Futures | 37292.8 | 37309.5 | 37254.9 | 37262.7 | 831.0 |
| 2023-01-22 18:30:00 | YM | Futures | 37264.9 | 37270.5 | 37243.8 | 37260.5 | 572.0 |
| 2023-01-22 19:00:00 | YM | Futures | 37261.6 | 37261.6 | 37225.9 | 37248.2 | 880.0 |
| 2023-01-22 19:30:00 | YM | Futures | 37249.3 | 37268.3 | 37237.1 | 37257.1 | 403.0 |
| 2023-01-22 20:00:00 | YM | Futures | 37256.0 | 37281.6 | 37253.8 | 37273.8 | 406.0 |
| 2023-01-22 20:30:00 | YM | Futures | 37273.8 | 37276.1 | 37261.6 | 37267.2 | 393.0 |
| 2023-01-22 21:00:00 | YM | Futures | 37267.2 | 37282.8 | 37267.2 | 37272.7 | 355.0 |
| 2023-01-22 21:30:00 | YM | Futures | 37273.8 | 37277.2 | 37259.4 | 37268.3 | 329.0 |
| 2023-01-22 22:00:00 | YM | Futures | 37268.3 | 37281.6 | 37267.2 | 37276.1 | 301.0 |
| 2023-01-22 22:30:00 | YM | Futures | 37275.0 | 37279.4 | 37268.3 | 37273.8 | 255.0 |
| 2023-01-22 23:00:00 | YM | Futures | 37272.7 | 37282.8 | 37261.6 | 37268.3 | 309.0 |
| 2023-01-22 23:30:00 | YM | Futures | 37268.3 | 37285.0 | 37267.2 | 37283.9 | 412.0 |
| 2023-01-22 18:00:00 | CL | Futures | 66.71 | 66.79 | 66.25 | 66.28 | 2029.0 |
| 2023-01-22 18:30:00 | CL | Futures | 66.28 | 66.33 | 66.19 | 66.26 | 1472.0 |
| 2023-01-22 19:00:00 | CL | Futures | 66.26 | 66.29 | 66.17 | 66.26 | 1079.0 |
| 2023-01-22 19:30:00 | CL | Futures | 66.26 | 66.39 | 66.25 | 66.39 | 707.0 |
| 2023-01-22 20:00:00 | CL | Futures | 66.39 | 66.48 | 66.3 | 66.3 | 798.0 |
| 2023-01-22 20:30:00 | CL | Futures | 66.3 | 66.31 | 66.25 | 66.3 | 574.0 |
| 2023-01-22 21:00:00 | CL | Futures | 66.3 | 66.36 | 66.29 | 66.32 | 383.0 |
| 2023-01-22 21:30:00 | CL | Futures | 66.32 | 66.34 | 66.18 | 66.28 | 502.0 |
| 2023-01-22 22:00:00 | CL | Futures | 66.29 | 66.34 | 66.29 | 66.3 | 242.0 |
| 2023-01-22 22:30:00 | CL | Futures | 66.3 | 66.38 | 66.25 | 66.34 | 494.0 |
| 2023-01-22 23:00:00 | CL | Futures | 66.34 | 66.38 | 66.3 | 66.32 | 371.0 |
| 2023-01-22 23:30:00 | CL | Futures | 66.32 | 66.43 | 66.32 | 66.41 | 451.0 |
| 2023-01-22 18:00:00 | GC | Futures | 2258.7 | 2259.9 | 2255.1 | 2257.5 | 1209.0 |
| 2023-01-22 18:30:00 | GC | Futures | 2257.5 | 2258.9 | 2257.5 | 2258.8 | 587.0 |
> showing 50 of 795 rows — these rows as CSV