PREVIEW / futures_30min / 2024-04-14
file: by_date/futures_30min/2024/2024-04-14.parquet size: 30 KB rows: 828
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-04-14 18:00:00 | ES | Futures | 5482.6 | 5498.78 | 5480.21 | 5497.99 | 26642.0 |
| 2024-04-14 18:30:00 | ES | Futures | 5497.72 | 5504.89 | 5496.13 | 5499.31 | 9303.0 |
| 2024-04-14 19:00:00 | ES | Futures | 5499.05 | 5501.44 | 5497.46 | 5499.58 | 6476.0 |
| 2024-04-14 19:30:00 | ES | Futures | 5499.58 | 5505.15 | 5498.25 | 5500.11 | 9289.0 |
| 2024-04-14 20:00:00 | ES | Futures | 5500.38 | 5502.23 | 5487.64 | 5497.46 | 15193.0 |
| 2024-04-14 20:30:00 | ES | Futures | 5497.46 | 5499.85 | 5494.8 | 5496.93 | 6416.0 |
| 2024-04-14 21:00:00 | ES | Futures | 5496.66 | 5497.46 | 5488.7 | 5492.95 | 7858.0 |
| 2024-04-14 21:30:00 | ES | Futures | 5493.21 | 5496.4 | 5490.56 | 5495.34 | 5840.0 |
| 2024-04-14 22:00:00 | ES | Futures | 5495.07 | 5498.25 | 5495.07 | 5496.4 | 7930.0 |
| 2024-04-14 22:30:00 | ES | Futures | 5496.66 | 5497.19 | 5494.54 | 5494.8 | 2866.0 |
| 2024-04-14 23:00:00 | ES | Futures | 5495.07 | 5496.4 | 5492.42 | 5496.13 | 3721.0 |
| 2024-04-14 23:30:00 | ES | Futures | 5496.13 | 5500.38 | 5495.87 | 5497.99 | 3276.0 |
| 2024-04-14 18:00:00 | NQ | Futures | 19421.86 | 19491.68 | 19417.31 | 19485.26 | 10770.0 |
| 2024-04-14 18:30:00 | NQ | Futures | 19484.99 | 19520.04 | 19482.59 | 19497.57 | 4856.0 |
| 2024-04-14 19:00:00 | NQ | Futures | 19497.3 | 19517.36 | 19496.5 | 19507.73 | 2690.0 |
| 2024-04-14 19:30:00 | NQ | Futures | 19508.8 | 19533.14 | 19504.79 | 19514.42 | 3816.0 |
| 2024-04-14 20:00:00 | NQ | Futures | 19514.42 | 19524.58 | 19466.27 | 19506.13 | 6581.0 |
| 2024-04-14 20:30:00 | NQ | Futures | 19507.2 | 19515.76 | 19491.15 | 19499.17 | 3159.0 |
| 2024-04-14 21:00:00 | NQ | Futures | 19499.71 | 19503.72 | 19468.41 | 19487.4 | 3558.0 |
| 2024-04-14 21:30:00 | NQ | Futures | 19487.94 | 19504.25 | 19479.91 | 19498.1 | 2358.0 |
| 2024-04-14 22:00:00 | NQ | Futures | 19498.1 | 19509.87 | 19497.3 | 19502.65 | 1959.0 |
| 2024-04-14 22:30:00 | NQ | Futures | 19503.45 | 19505.59 | 19495.96 | 19495.96 | 1054.0 |
| 2024-04-14 23:00:00 | NQ | Futures | 19497.03 | 19502.11 | 19487.13 | 19500.78 | 1733.0 |
| 2024-04-14 23:30:00 | NQ | Futures | 19501.04 | 19520.3 | 19500.78 | 19507.2 | 1960.0 |
| 2024-04-14 18:00:00 | YM | Futures | 40503.9 | 40702.5 | 40502.9 | 40697.2 | 2833.0 |
| 2024-04-14 18:30:00 | YM | Futures | 40695.1 | 40731.1 | 40681.2 | 40688.7 | 1068.0 |
| 2024-04-14 19:00:00 | YM | Futures | 40688.7 | 40698.2 | 40681.2 | 40691.9 | 502.0 |
| 2024-04-14 19:30:00 | YM | Futures | 40692.9 | 40723.7 | 40688.7 | 40695.1 | 646.0 |
| 2024-04-14 20:00:00 | YM | Futures | 40695.1 | 40712.0 | 40621.8 | 40683.4 | 1256.0 |
| 2024-04-14 20:30:00 | YM | Futures | 40683.4 | 40701.4 | 40671.7 | 40675.9 | 610.0 |
| 2024-04-14 21:00:00 | YM | Futures | 40680.2 | 40682.3 | 40619.7 | 40654.7 | 661.0 |
| 2024-04-14 21:30:00 | YM | Futures | 40654.7 | 40675.9 | 40640.9 | 40671.7 | 565.0 |
| 2024-04-14 22:00:00 | YM | Futures | 40670.6 | 40688.7 | 40670.6 | 40679.1 | 534.0 |
| 2024-04-14 22:30:00 | YM | Futures | 40678.1 | 40684.4 | 40663.2 | 40664.3 | 359.0 |
| 2024-04-14 23:00:00 | YM | Futures | 40664.3 | 40673.8 | 40650.5 | 40671.7 | 362.0 |
| 2024-04-14 23:30:00 | YM | Futures | 40673.8 | 40694.0 | 40671.7 | 40684.4 | 386.0 |
| 2024-04-14 18:00:00 | CL | Futures | 71.9 | 72.33 | 71.63 | 71.92 | 2903.0 |
| 2024-04-14 18:30:00 | CL | Futures | 71.91 | 71.91 | 71.63 | 71.76 | 886.0 |
| 2024-04-14 19:00:00 | CL | Futures | 71.75 | 71.96 | 71.73 | 71.93 | 439.0 |
| 2024-04-14 19:30:00 | CL | Futures | 71.93 | 72.01 | 71.92 | 71.94 | 367.0 |
| 2024-04-14 20:00:00 | CL | Futures | 71.93 | 72.04 | 71.89 | 72.02 | 545.0 |
| 2024-04-14 20:30:00 | CL | Futures | 72.05 | 72.08 | 71.63 | 71.78 | 918.0 |
| 2024-04-14 21:00:00 | CL | Futures | 71.8 | 71.82 | 71.36 | 71.71 | 1864.0 |
| 2024-04-14 21:30:00 | CL | Futures | 71.71 | 71.89 | 71.71 | 71.82 | 460.0 |
| 2024-04-14 22:00:00 | CL | Futures | 71.81 | 71.85 | 71.73 | 71.77 | 270.0 |
| 2024-04-14 22:30:00 | CL | Futures | 71.78 | 71.79 | 71.61 | 71.67 | 246.0 |
| 2024-04-14 23:00:00 | CL | Futures | 71.69 | 71.78 | 71.63 | 71.68 | 278.0 |
| 2024-04-14 23:30:00 | CL | Futures | 71.69 | 71.8 | 71.69 | 71.77 | 148.0 |
| 2024-04-14 18:00:00 | GC | Futures | 2571.2 | 2593.1 | 2564.2 | 2574.4 | 16712.0 |
| 2024-04-14 18:30:00 | GC | Futures | 2574.4 | 2581.7 | 2570.6 | 2575.1 | 4302.0 |
> showing 50 of 828 rows — these rows as CSV