PREVIEW / futures_1hour / 2024-03-19
file: by_date/futures_1hour/2024/2024-03-19.parquet size: 66 KB rows: 2,092
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-19 00:00:00 | ES | Futures | 5526.64 | 5530.88 | 5524.78 | 5529.03 | 5626.0 |
| 2024-03-19 01:00:00 | ES | Futures | 5529.03 | 5531.68 | 5525.84 | 5530.62 | 4127.0 |
| 2024-03-19 02:00:00 | ES | Futures | 5530.88 | 5531.68 | 5524.78 | 5527.44 | 4539.0 |
| 2024-03-19 03:00:00 | ES | Futures | 5527.44 | 5531.42 | 5525.05 | 5526.91 | 8661.0 |
| 2024-03-19 04:00:00 | ES | Futures | 5526.91 | 5538.58 | 5522.13 | 5531.95 | 22041.0 |
| 2024-03-19 05:00:00 | ES | Futures | 5532.21 | 5533.8 | 5520.01 | 5521.07 | 19591.0 |
| 2024-03-19 06:00:00 | ES | Futures | 5521.33 | 5526.91 | 5518.68 | 5521.33 | 16148.0 |
| 2024-03-19 07:00:00 | ES | Futures | 5521.07 | 5521.07 | 5506.48 | 5510.99 | 28106.0 |
| 2024-03-19 08:00:00 | ES | Futures | 5511.25 | 5517.09 | 5503.29 | 5516.56 | 44766.0 |
| 2024-03-19 09:00:00 | ES | Futures | 5516.82 | 5525.05 | 5513.11 | 5518.68 | 181350.0 |
| 2024-03-19 10:00:00 | ES | Futures | 5518.68 | 5528.76 | 5513.64 | 5524.52 | 170322.0 |
| 2024-03-19 11:00:00 | ES | Futures | 5524.52 | 5537.78 | 5523.72 | 5534.6 | 109206.0 |
| 2024-03-19 12:00:00 | ES | Futures | 5534.6 | 5556.09 | 5532.74 | 5551.05 | 142411.0 |
| 2024-03-19 13:00:00 | ES | Futures | 5551.31 | 5559.54 | 5547.6 | 5554.23 | 120447.0 |
| 2024-03-19 14:00:00 | ES | Futures | 5554.23 | 5558.21 | 5548.93 | 5553.17 | 96437.0 |
| 2024-03-19 15:00:00 | ES | Futures | 5552.9 | 5565.64 | 5546.01 | 5563.25 | 236708.0 |
| 2024-03-19 16:00:00 | ES | Futures | 5563.25 | 5564.84 | 5559.27 | 5560.07 | 67492.0 |
| 2024-03-19 18:00:00 | ES | Futures | 5560.33 | 5561.39 | 5559.01 | 5560.6 | 3725.0 |
| 2024-03-19 19:00:00 | ES | Futures | 5560.6 | 5561.66 | 5559.01 | 5559.01 | 2878.0 |
| 2024-03-19 20:00:00 | ES | Futures | 5559.01 | 5559.27 | 5556.62 | 5557.15 | 4747.0 |
| 2024-03-19 21:00:00 | ES | Futures | 5557.15 | 5557.95 | 5553.17 | 5554.76 | 4425.0 |
| 2024-03-19 22:00:00 | ES | Futures | 5554.76 | 5556.88 | 5553.97 | 5556.88 | 3510.0 |
| 2024-03-19 23:00:00 | ES | Futures | 5556.88 | 5557.15 | 5555.29 | 5556.88 | 2052.0 |
| 2024-03-19 00:00:00 | NQ | Futures | 19452.89 | 19474.03 | 19445.14 | 19463.33 | 3682.0 |
| 2024-03-19 01:00:00 | NQ | Futures | 19463.06 | 19481.25 | 19446.21 | 19474.29 | 3878.0 |
| 2024-03-19 02:00:00 | NQ | Futures | 19474.83 | 19480.18 | 19446.47 | 19457.44 | 3720.0 |
| 2024-03-19 03:00:00 | NQ | Futures | 19457.44 | 19474.56 | 19441.12 | 19452.36 | 5628.0 |
| 2024-03-19 04:00:00 | NQ | Futures | 19451.56 | 19530.74 | 19430.69 | 19498.9 | 14806.0 |
| 2024-03-19 05:00:00 | NQ | Futures | 19499.17 | 19509.34 | 19442.46 | 19449.42 | 10337.0 |
| 2024-03-19 06:00:00 | NQ | Futures | 19449.95 | 19475.63 | 19439.52 | 19454.77 | 8500.0 |
| 2024-03-19 07:00:00 | NQ | Futures | 19453.96 | 19453.96 | 19371.57 | 19387.89 | 18888.0 |
| 2024-03-19 08:00:00 | NQ | Futures | 19388.42 | 19404.21 | 19343.48 | 19400.73 | 24343.0 |
| 2024-03-19 09:00:00 | NQ | Futures | 19400.46 | 19423.47 | 19317.27 | 19357.13 | 107260.0 |
| 2024-03-19 10:00:00 | NQ | Futures | 19356.86 | 19417.31 | 19332.78 | 19384.41 | 99668.0 |
| 2024-03-19 11:00:00 | NQ | Futures | 19384.14 | 19441.12 | 19372.11 | 19430.16 | 60088.0 |
| 2024-03-19 12:00:00 | NQ | Futures | 19429.89 | 19547.86 | 19417.58 | 19521.11 | 72153.0 |
| 2024-03-19 13:00:00 | NQ | Futures | 19521.11 | 19566.31 | 19508.27 | 19542.77 | 60155.0 |
| 2024-03-19 14:00:00 | NQ | Futures | 19543.31 | 19569.79 | 19518.7 | 19544.91 | 46913.0 |
| 2024-03-19 15:00:00 | NQ | Futures | 19544.91 | 19564.44 | 19491.95 | 19549.19 | 70937.0 |
| 2024-03-19 16:00:00 | NQ | Futures | 19548.66 | 19567.12 | 19540.63 | 19552.4 | 13357.0 |
| 2024-03-19 18:00:00 | NQ | Futures | 19553.47 | 19561.5 | 19547.05 | 19558.02 | 2171.0 |
| 2024-03-19 19:00:00 | NQ | Futures | 19558.02 | 19564.71 | 19547.05 | 19547.59 | 2026.0 |
| 2024-03-19 20:00:00 | NQ | Futures | 19547.59 | 19547.59 | 19524.32 | 19529.13 | 3350.0 |
| 2024-03-19 21:00:00 | NQ | Futures | 19529.67 | 19533.41 | 19503.72 | 19509.34 | 3921.0 |
| 2024-03-19 22:00:00 | NQ | Futures | 19509.6 | 19525.65 | 19505.32 | 19524.85 | 2503.0 |
| 2024-03-19 23:00:00 | NQ | Futures | 19524.32 | 19526.99 | 19516.29 | 19523.78 | 1396.0 |
| 2024-03-19 00:00:00 | YM | Futures | 41623.0 | 41647.4 | 41615.5 | 41636.8 | 615.0 |
| 2024-03-19 01:00:00 | YM | Futures | 41637.8 | 41650.6 | 41621.9 | 41649.5 | 772.0 |
| 2024-03-19 02:00:00 | YM | Futures | 41649.5 | 41651.6 | 41616.6 | 41642.1 | 755.0 |
| 2024-03-19 03:00:00 | YM | Futures | 41642.1 | 41660.1 | 41629.3 | 41648.5 | 1695.0 |
> showing 50 of 2,092 rows — these rows as CSV