PREVIEW / futures_1hour / 2024-05-08
file: by_date/futures_1hour/2024/2024-05-08.parquet size: 65 KB rows: 2,088
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-05-08 00:00:00 | ES | Futures | 5531.42 | 5531.95 | 5529.29 | 5529.56 | 2821.0 |
| 2024-05-08 01:00:00 | ES | Futures | 5529.56 | 5532.21 | 5528.76 | 5531.95 | 3639.0 |
| 2024-05-08 02:00:00 | ES | Futures | 5531.95 | 5533.27 | 5529.56 | 5532.48 | 5436.0 |
| 2024-05-08 03:00:00 | ES | Futures | 5532.21 | 5537.25 | 5531.42 | 5533.27 | 11908.0 |
| 2024-05-08 04:00:00 | ES | Futures | 5533.27 | 5535.66 | 5529.82 | 5530.88 | 11079.0 |
| 2024-05-08 05:00:00 | ES | Futures | 5530.35 | 5534.6 | 5530.09 | 5532.74 | 8460.0 |
| 2024-05-08 06:00:00 | ES | Futures | 5532.48 | 5533.54 | 5526.91 | 5526.91 | 11165.0 |
| 2024-05-08 07:00:00 | ES | Futures | 5527.17 | 5527.97 | 5521.07 | 5522.93 | 22673.0 |
| 2024-05-08 08:00:00 | ES | Futures | 5522.93 | 5523.19 | 5506.21 | 5511.78 | 42567.0 |
| 2024-05-08 09:00:00 | ES | Futures | 5511.78 | 5523.72 | 5508.6 | 5523.19 | 135023.0 |
| 2024-05-08 10:00:00 | ES | Futures | 5523.19 | 5536.46 | 5518.42 | 5532.74 | 157528.0 |
| 2024-05-08 11:00:00 | ES | Futures | 5533.01 | 5535.93 | 5524.78 | 5526.64 | 109780.0 |
| 2024-05-08 12:00:00 | ES | Futures | 5526.37 | 5530.09 | 5520.54 | 5524.52 | 82415.0 |
| 2024-05-08 13:00:00 | ES | Futures | 5524.78 | 5529.82 | 5518.95 | 5529.56 | 80842.0 |
| 2024-05-08 14:00:00 | ES | Futures | 5529.56 | 5533.27 | 5527.44 | 5528.76 | 72821.0 |
| 2024-05-08 15:00:00 | ES | Futures | 5529.03 | 5536.19 | 5523.99 | 5530.62 | 145933.0 |
| 2024-05-08 16:00:00 | ES | Futures | 5530.35 | 5531.15 | 5526.64 | 5528.76 | 40481.0 |
| 2024-05-08 18:00:00 | ES | Futures | 5527.97 | 5531.95 | 5526.64 | 5530.35 | 3992.0 |
| 2024-05-08 19:00:00 | ES | Futures | 5530.35 | 5530.88 | 5528.23 | 5529.03 | 2215.0 |
| 2024-05-08 20:00:00 | ES | Futures | 5529.03 | 5529.82 | 5526.11 | 5528.5 | 4688.0 |
| 2024-05-08 21:00:00 | ES | Futures | 5528.5 | 5530.88 | 5526.64 | 5530.62 | 4084.0 |
| 2024-05-08 22:00:00 | ES | Futures | 5530.62 | 5530.62 | 5527.44 | 5528.5 | 2888.0 |
| 2024-05-08 23:00:00 | ES | Futures | 5528.5 | 5529.29 | 5526.37 | 5526.64 | 1994.0 |
| 2024-05-08 00:00:00 | NQ | Futures | 19467.87 | 19470.82 | 19458.78 | 19459.31 | 1747.0 |
| 2024-05-08 01:00:00 | NQ | Futures | 19459.31 | 19470.55 | 19453.96 | 19468.14 | 2419.0 |
| 2024-05-08 02:00:00 | NQ | Futures | 19468.68 | 19477.5 | 19458.24 | 19471.08 | 3136.0 |
| 2024-05-08 03:00:00 | NQ | Futures | 19471.08 | 19488.74 | 19468.94 | 19475.36 | 5360.0 |
| 2024-05-08 04:00:00 | NQ | Futures | 19475.9 | 19492.22 | 19464.13 | 19466.27 | 6729.0 |
| 2024-05-08 05:00:00 | NQ | Futures | 19466.0 | 19477.5 | 19461.45 | 19467.87 | 3856.0 |
| 2024-05-08 06:00:00 | NQ | Futures | 19468.14 | 19474.29 | 19452.63 | 19454.77 | 5886.0 |
| 2024-05-08 07:00:00 | NQ | Futures | 19455.3 | 19458.24 | 19417.58 | 19423.74 | 12384.0 |
| 2024-05-08 08:00:00 | NQ | Futures | 19423.47 | 19423.47 | 19337.87 | 19359.0 | 25424.0 |
| 2024-05-08 09:00:00 | NQ | Futures | 19358.46 | 19447.28 | 19344.29 | 19440.05 | 72464.0 |
| 2024-05-08 10:00:00 | NQ | Futures | 19440.05 | 19519.5 | 19422.4 | 19494.09 | 73232.0 |
| 2024-05-08 11:00:00 | NQ | Futures | 19494.09 | 19512.01 | 19436.04 | 19447.01 | 55952.0 |
| 2024-05-08 12:00:00 | NQ | Futures | 19447.01 | 19465.2 | 19426.14 | 19440.05 | 34442.0 |
| 2024-05-08 13:00:00 | NQ | Futures | 19440.32 | 19453.7 | 19408.75 | 19451.56 | 40136.0 |
| 2024-05-08 14:00:00 | NQ | Futures | 19451.82 | 19467.87 | 19440.32 | 19444.33 | 31139.0 |
| 2024-05-08 15:00:00 | NQ | Futures | 19445.14 | 19475.9 | 19426.41 | 19456.1 | 47262.0 |
| 2024-05-08 16:00:00 | NQ | Futures | 19456.64 | 19457.71 | 19424.54 | 19432.3 | 14525.0 |
| 2024-05-08 18:00:00 | NQ | Futures | 19432.3 | 19448.35 | 19424.27 | 19440.59 | 2474.0 |
| 2024-05-08 19:00:00 | NQ | Futures | 19439.79 | 19441.93 | 19431.49 | 19433.1 | 1251.0 |
| 2024-05-08 20:00:00 | NQ | Futures | 19433.63 | 19443.26 | 19424.27 | 19438.18 | 2415.0 |
| 2024-05-08 21:00:00 | NQ | Futures | 19438.18 | 19449.42 | 19427.75 | 19446.74 | 2190.0 |
| 2024-05-08 22:00:00 | NQ | Futures | 19447.01 | 19447.81 | 19432.3 | 19436.04 | 1708.0 |
| 2024-05-08 23:00:00 | NQ | Futures | 19436.31 | 19439.25 | 19429.09 | 19431.23 | 1106.0 |
| 2024-05-08 00:00:00 | YM | Futures | 41422.3 | 41425.5 | 41409.6 | 41411.7 | 160.0 |
| 2024-05-08 01:00:00 | YM | Futures | 41410.6 | 41424.4 | 41406.4 | 41424.4 | 378.0 |
| 2024-05-08 02:00:00 | YM | Futures | 41424.4 | 41437.2 | 41414.9 | 41427.6 | 942.0 |
| 2024-05-08 03:00:00 | YM | Futures | 41426.6 | 41464.8 | 41422.3 | 41440.4 | 1537.0 |
> showing 50 of 2,088 rows — these rows as CSV