PREVIEW / futures_1hour / 2024-03-11
file: by_date/futures_1hour/2024/2024-03-11.parquet size: 61 KB rows: 1,937
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-11 00:00:00 | ES | Futures | 5499.93 | 5499.93 | 5496.71 | 5498.59 | 3527.0 |
| 2024-03-11 01:00:00 | ES | Futures | 5498.59 | 5505.57 | 5497.24 | 5505.3 | 3659.0 |
| 2024-03-11 02:00:00 | ES | Futures | 5505.57 | 5507.72 | 5503.42 | 5506.64 | 3722.0 |
| 2024-03-11 03:00:00 | ES | Futures | 5506.64 | 5509.33 | 5499.93 | 5503.42 | 8438.0 |
| 2024-03-11 04:00:00 | ES | Futures | 5503.15 | 5506.38 | 5486.23 | 5498.32 | 36471.0 |
| 2024-03-11 05:00:00 | ES | Futures | 5498.32 | 5505.3 | 5498.05 | 5501.54 | 26314.0 |
| 2024-03-11 06:00:00 | ES | Futures | 5501.54 | 5507.45 | 5494.02 | 5505.03 | 9105.0 |
| 2024-03-11 07:00:00 | ES | Futures | 5505.03 | 5506.38 | 5492.95 | 5495.9 | 10775.0 |
| 2024-03-11 08:00:00 | ES | Futures | 5496.17 | 5496.17 | 5482.2 | 5488.38 | 22013.0 |
| 2024-03-11 09:00:00 | ES | Futures | 5488.38 | 5499.66 | 5483.28 | 5483.55 | 117421.0 |
| 2024-03-11 10:00:00 | ES | Futures | 5483.55 | 5497.51 | 5473.61 | 5495.63 | 114409.0 |
| 2024-03-11 11:00:00 | ES | Futures | 5495.9 | 5499.39 | 5481.13 | 5498.86 | 80085.0 |
| 2024-03-11 12:00:00 | ES | Futures | 5498.86 | 5502.35 | 5489.45 | 5500.74 | 50617.0 |
| 2024-03-11 13:00:00 | ES | Futures | 5500.74 | 5507.45 | 5491.87 | 5501.0 | 50485.0 |
| 2024-03-11 14:00:00 | ES | Futures | 5501.27 | 5510.4 | 5497.24 | 5507.45 | 42958.0 |
| 2024-03-11 15:00:00 | ES | Futures | 5507.18 | 5507.45 | 5495.63 | 5503.69 | 69227.0 |
| 2024-03-11 16:00:00 | ES | Futures | 5503.69 | 5510.4 | 5502.35 | 5509.6 | 18775.0 |
| 2024-03-11 18:00:00 | ES | Futures | 5510.4 | 5518.73 | 5510.14 | 5516.05 | 3735.0 |
| 2024-03-11 19:00:00 | ES | Futures | 5516.05 | 5519.0 | 5514.7 | 5518.46 | 1672.0 |
| 2024-03-11 20:00:00 | ES | Futures | 5518.19 | 5521.42 | 5515.78 | 5516.05 | 3988.0 |
| 2024-03-11 21:00:00 | ES | Futures | 5516.05 | 5519.54 | 5515.24 | 5517.39 | 2897.0 |
| 2024-03-11 22:00:00 | ES | Futures | 5517.66 | 5519.27 | 5516.31 | 5518.73 | 1705.0 |
| 2024-03-11 23:00:00 | ES | Futures | 5518.73 | 5520.88 | 5518.73 | 5519.81 | 1384.0 |
| 2024-03-11 00:00:00 | NQ | Futures | 19519.75 | 19522.19 | 19498.33 | 19510.26 | 2727.0 |
| 2024-03-11 01:00:00 | NQ | Futures | 19509.72 | 19550.67 | 19507.28 | 19548.5 | 2746.0 |
| 2024-03-11 02:00:00 | NQ | Futures | 19548.5 | 19561.79 | 19538.19 | 19559.08 | 1993.0 |
| 2024-03-11 03:00:00 | NQ | Futures | 19558.26 | 19579.42 | 19539.01 | 19553.11 | 4936.0 |
| 2024-03-11 04:00:00 | NQ | Futures | 19552.84 | 19571.28 | 19460.36 | 19539.55 | 13932.0 |
| 2024-03-11 05:00:00 | NQ | Futures | 19540.09 | 19582.94 | 19537.38 | 19555.82 | 6842.0 |
| 2024-03-11 06:00:00 | NQ | Futures | 19555.82 | 19580.5 | 19513.24 | 19563.69 | 4875.0 |
| 2024-03-11 07:00:00 | NQ | Futures | 19564.23 | 19569.11 | 19494.53 | 19507.01 | 6035.0 |
| 2024-03-11 08:00:00 | NQ | Futures | 19507.28 | 19508.63 | 19441.65 | 19474.19 | 13623.0 |
| 2024-03-11 09:00:00 | NQ | Futures | 19474.46 | 19528.16 | 19416.42 | 19417.78 | 56551.0 |
| 2024-03-11 10:00:00 | NQ | Futures | 19418.05 | 19551.48 | 19408.02 | 19528.16 | 50515.0 |
| 2024-03-11 11:00:00 | NQ | Futures | 19527.89 | 19546.6 | 19439.2 | 19526.53 | 32513.0 |
| 2024-03-11 12:00:00 | NQ | Futures | 19525.99 | 19527.35 | 19469.04 | 19515.14 | 21406.0 |
| 2024-03-11 13:00:00 | NQ | Futures | 19515.96 | 19534.94 | 19462.26 | 19499.41 | 21493.0 |
| 2024-03-11 14:00:00 | NQ | Futures | 19500.23 | 19554.2 | 19481.51 | 19529.25 | 18998.0 |
| 2024-03-11 15:00:00 | NQ | Futures | 19528.7 | 19529.25 | 19470.12 | 19494.53 | 23683.0 |
| 2024-03-11 16:00:00 | NQ | Futures | 19495.07 | 19543.89 | 19491.55 | 19525.99 | 6343.0 |
| 2024-03-11 18:00:00 | NQ | Futures | 19538.19 | 19578.88 | 19526.53 | 19562.6 | 1959.0 |
| 2024-03-11 19:00:00 | NQ | Futures | 19562.06 | 19581.86 | 19559.08 | 19579.69 | 997.0 |
| 2024-03-11 20:00:00 | NQ | Futures | 19578.6 | 19598.4 | 19565.32 | 19570.2 | 2005.0 |
| 2024-03-11 21:00:00 | NQ | Futures | 19571.01 | 19587.55 | 19566.4 | 19576.16 | 1083.0 |
| 2024-03-11 22:00:00 | NQ | Futures | 19577.25 | 19583.22 | 19569.38 | 19581.86 | 525.0 |
| 2024-03-11 23:00:00 | NQ | Futures | 19581.32 | 19591.89 | 19580.5 | 19584.84 | 730.0 |
| 2024-03-11 00:00:00 | YM | Futures | 41545.5 | 41545.5 | 41525.3 | 41533.8 | 565.0 |
| 2024-03-11 01:00:00 | YM | Futures | 41533.8 | 41574.1 | 41527.4 | 41574.1 | 559.0 |
| 2024-03-11 02:00:00 | YM | Futures | 41574.1 | 41586.9 | 41557.2 | 41569.9 | 931.0 |
| 2024-03-11 03:00:00 | YM | Futures | 41572.0 | 41584.8 | 41522.1 | 41552.9 | 1970.0 |
> showing 50 of 1,937 rows — these rows as CSV