PREVIEW / futures_30min / 2023-06-11
file: by_date/futures_30min/2023/2023-06-11.parquet size: 25 KB rows: 711
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-06-11 18:00:00 | ES | Futures | 4777.69 | 4783.51 | 4776.3 | 4782.13 | 3074.0 |
| 2023-06-11 18:30:00 | ES | Futures | 4782.4 | 4783.51 | 4781.3 | 4782.13 | 932.0 |
| 2023-06-11 19:00:00 | ES | Futures | 4782.4 | 4785.46 | 4781.85 | 4782.4 | 1213.0 |
| 2023-06-11 19:30:00 | ES | Futures | 4782.4 | 4783.51 | 4779.91 | 4782.4 | 2016.0 |
| 2023-06-11 20:00:00 | ES | Futures | 4782.13 | 4783.79 | 4780.46 | 4783.51 | 2484.0 |
| 2023-06-11 20:30:00 | ES | Futures | 4783.79 | 4785.46 | 4783.51 | 4784.35 | 1754.0 |
| 2023-06-11 21:00:00 | ES | Futures | 4784.35 | 4785.46 | 4782.68 | 4782.68 | 937.0 |
| 2023-06-11 21:30:00 | ES | Futures | 4782.96 | 4783.51 | 4781.57 | 4782.13 | 1969.0 |
| 2023-06-11 22:00:00 | ES | Futures | 4782.4 | 4784.07 | 4781.57 | 4782.96 | 1503.0 |
| 2023-06-11 22:30:00 | ES | Futures | 4783.24 | 4783.51 | 4780.74 | 4781.85 | 968.0 |
| 2023-06-11 23:00:00 | ES | Futures | 4781.85 | 4783.51 | 4781.57 | 4783.51 | 620.0 |
| 2023-06-11 23:30:00 | ES | Futures | 4783.24 | 4783.51 | 4780.74 | 4781.3 | 780.0 |
| 2023-06-11 18:00:00 | NQ | Futures | 16397.93 | 16452.27 | 16391.17 | 16432.56 | 2649.0 |
| 2023-06-11 18:30:00 | NQ | Futures | 16431.43 | 16442.7 | 16425.24 | 16439.32 | 925.0 |
| 2023-06-11 19:00:00 | NQ | Futures | 16439.32 | 16451.71 | 16433.4 | 16433.4 | 1025.0 |
| 2023-06-11 19:30:00 | NQ | Futures | 16434.53 | 16439.32 | 16424.4 | 16433.12 | 715.0 |
| 2023-06-11 20:00:00 | NQ | Futures | 16432.0 | 16437.35 | 16424.68 | 16435.09 | 909.0 |
| 2023-06-11 20:30:00 | NQ | Futures | 16435.38 | 16442.13 | 16432.28 | 16437.07 | 827.0 |
| 2023-06-11 21:00:00 | NQ | Futures | 16437.63 | 16437.63 | 16428.34 | 16428.9 | 664.0 |
| 2023-06-11 21:30:00 | NQ | Futures | 16429.18 | 16437.91 | 16427.77 | 16436.78 | 849.0 |
| 2023-06-11 22:00:00 | NQ | Futures | 16435.94 | 16444.67 | 16432.28 | 16439.6 | 976.0 |
| 2023-06-11 22:30:00 | NQ | Futures | 16439.88 | 16442.7 | 16432.56 | 16434.53 | 579.0 |
| 2023-06-11 23:00:00 | NQ | Futures | 16434.81 | 16441.57 | 16434.53 | 16439.6 | 350.0 |
| 2023-06-11 23:30:00 | NQ | Futures | 16439.6 | 16439.6 | 16426.65 | 16428.62 | 565.0 |
| 2023-06-11 18:00:00 | YM | Futures | 37456.7 | 37489.6 | 37451.2 | 37481.9 | 617.0 |
| 2023-06-11 18:30:00 | YM | Futures | 37480.8 | 37496.1 | 37477.5 | 37485.2 | 292.0 |
| 2023-06-11 19:00:00 | YM | Futures | 37485.2 | 37512.6 | 37485.2 | 37495.0 | 337.0 |
| 2023-06-11 19:30:00 | YM | Futures | 37495.0 | 37500.5 | 37475.3 | 37490.7 | 307.0 |
| 2023-06-11 20:00:00 | YM | Futures | 37488.5 | 37496.1 | 37475.3 | 37492.8 | 531.0 |
| 2023-06-11 20:30:00 | YM | Futures | 37493.9 | 37504.9 | 37491.7 | 37496.1 | 414.0 |
| 2023-06-11 21:00:00 | YM | Futures | 37496.1 | 37507.1 | 37487.4 | 37487.4 | 235.0 |
| 2023-06-11 21:30:00 | YM | Futures | 37487.4 | 37493.9 | 37477.5 | 37480.8 | 309.0 |
| 2023-06-11 22:00:00 | YM | Futures | 37480.8 | 37490.7 | 37476.4 | 37477.5 | 292.0 |
| 2023-06-11 22:30:00 | YM | Futures | 37477.5 | 37479.7 | 37463.3 | 37470.9 | 222.0 |
| 2023-06-11 23:00:00 | YM | Futures | 37470.9 | 37480.8 | 37468.7 | 37480.8 | 145.0 |
| 2023-06-11 23:30:00 | YM | Futures | 37478.6 | 37478.6 | 37465.5 | 37470.9 | 220.0 |
| 2023-06-11 18:00:00 | CL | Futures | 57.17 | 57.22 | 56.91 | 56.97 | 1588.0 |
| 2023-06-11 18:30:00 | CL | Futures | 56.98 | 56.98 | 56.87 | 56.88 | 512.0 |
| 2023-06-11 19:00:00 | CL | Futures | 56.89 | 56.91 | 56.87 | 56.88 | 261.0 |
| 2023-06-11 19:30:00 | CL | Futures | 56.88 | 56.95 | 56.82 | 56.93 | 790.0 |
| 2023-06-11 20:00:00 | CL | Futures | 56.93 | 56.94 | 56.8 | 56.86 | 894.0 |
| 2023-06-11 20:30:00 | CL | Futures | 56.86 | 56.93 | 56.81 | 56.92 | 855.0 |
| 2023-06-11 21:00:00 | CL | Futures | 56.91 | 56.92 | 56.59 | 56.6 | 3935.0 |
| 2023-06-11 21:30:00 | CL | Futures | 56.6 | 56.65 | 56.39 | 56.42 | 3673.0 |
| 2023-06-11 22:00:00 | CL | Futures | 56.4 | 56.54 | 56.38 | 56.47 | 2091.0 |
| 2023-06-11 22:30:00 | CL | Futures | 56.47 | 56.52 | 56.41 | 56.43 | 1254.0 |
| 2023-06-11 23:00:00 | CL | Futures | 56.43 | 56.47 | 56.36 | 56.42 | 1168.0 |
| 2023-06-11 23:30:00 | CL | Futures | 56.43 | 56.47 | 56.41 | 56.45 | 761.0 |
| 2023-06-11 18:00:00 | GC | Futures | 2250.5 | 2250.7 | 2248.6 | 2249.3 | 682.0 |
| 2023-06-11 18:30:00 | GC | Futures | 2249.3 | 2249.3 | 2247.7 | 2248.0 | 445.0 |
> showing 50 of 711 rows — these rows as CSV