PREVIEW / futures_1hour / 2024-04-17
file: by_date/futures_1hour/2024/2024-04-17.parquet size: 68 KB rows: 2,098
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-17 00:00:00 | ES | Futures | 5416.81 | 5417.87 | 5414.95 | 5417.6 | 2747.0 |
| 2024-04-17 01:00:00 | ES | Futures | 5417.34 | 5417.34 | 5399.56 | 5402.48 | 11028.0 |
| 2024-04-17 02:00:00 | ES | Futures | 5402.48 | 5404.07 | 5386.3 | 5396.65 | 25378.0 |
| 2024-04-17 03:00:00 | ES | Futures | 5396.91 | 5412.83 | 5396.11 | 5411.5 | 25338.0 |
| 2024-04-17 04:00:00 | ES | Futures | 5411.5 | 5424.5 | 5409.11 | 5421.32 | 22404.0 |
| 2024-04-17 05:00:00 | ES | Futures | 5421.58 | 5424.77 | 5414.15 | 5424.5 | 17691.0 |
| 2024-04-17 06:00:00 | ES | Futures | 5424.5 | 5430.07 | 5422.11 | 5425.3 | 17172.0 |
| 2024-04-17 07:00:00 | ES | Futures | 5425.3 | 5427.42 | 5418.4 | 5419.2 | 21150.0 |
| 2024-04-17 08:00:00 | ES | Futures | 5419.46 | 5425.56 | 5413.62 | 5423.17 | 35839.0 |
| 2024-04-17 09:00:00 | ES | Futures | 5422.91 | 5433.79 | 5419.2 | 5422.38 | 212659.0 |
| 2024-04-17 10:00:00 | ES | Futures | 5422.38 | 5422.91 | 5388.69 | 5396.11 | 225212.0 |
| 2024-04-17 11:00:00 | ES | Futures | 5396.38 | 5408.32 | 5375.95 | 5383.65 | 212601.0 |
| 2024-04-17 12:00:00 | ES | Futures | 5383.38 | 5384.44 | 5355.79 | 5364.28 | 234198.0 |
| 2024-04-17 13:00:00 | ES | Futures | 5364.54 | 5393.2 | 5362.16 | 5391.07 | 206026.0 |
| 2024-04-17 14:00:00 | ES | Futures | 5391.07 | 5408.85 | 5379.14 | 5382.58 | 203361.0 |
| 2024-04-17 15:00:00 | ES | Futures | 5382.58 | 5384.71 | 5369.05 | 5370.38 | 283778.0 |
| 2024-04-17 16:00:00 | ES | Futures | 5370.65 | 5371.97 | 5365.34 | 5371.18 | 67410.0 |
| 2024-04-17 18:00:00 | ES | Futures | 5372.77 | 5375.69 | 5371.71 | 5374.89 | 4908.0 |
| 2024-04-17 19:00:00 | ES | Futures | 5374.89 | 5377.01 | 5372.77 | 5376.22 | 4069.0 |
| 2024-04-17 20:00:00 | ES | Futures | 5376.48 | 5379.14 | 5374.36 | 5377.54 | 5980.0 |
| 2024-04-17 21:00:00 | ES | Futures | 5377.81 | 5380.73 | 5376.75 | 5380.46 | 5679.0 |
| 2024-04-17 22:00:00 | ES | Futures | 5380.73 | 5385.5 | 5379.67 | 5383.91 | 6493.0 |
| 2024-04-17 23:00:00 | ES | Futures | 5383.91 | 5387.89 | 5383.91 | 5387.09 | 4114.0 |
| 2024-04-17 00:00:00 | NQ | Futures | 19184.85 | 19191.54 | 19178.43 | 19190.74 | 1520.0 |
| 2024-04-17 01:00:00 | NQ | Futures | 19189.94 | 19190.2 | 19090.96 | 19107.55 | 9746.0 |
| 2024-04-17 02:00:00 | NQ | Futures | 19107.28 | 19113.16 | 19022.75 | 19073.04 | 17438.0 |
| 2024-04-17 03:00:00 | NQ | Futures | 19072.5 | 19137.51 | 19068.22 | 19129.75 | 14139.0 |
| 2024-04-17 04:00:00 | NQ | Futures | 19129.75 | 19176.83 | 19113.16 | 19166.4 | 12231.0 |
| 2024-04-17 05:00:00 | NQ | Futures | 19166.93 | 19185.12 | 19134.56 | 19185.12 | 10224.0 |
| 2024-04-17 06:00:00 | NQ | Futures | 19184.85 | 19199.03 | 19169.61 | 19176.29 | 9678.0 |
| 2024-04-17 07:00:00 | NQ | Futures | 19176.56 | 19193.95 | 19158.1 | 19163.45 | 10202.0 |
| 2024-04-17 08:00:00 | NQ | Futures | 19163.19 | 19195.29 | 19145.8 | 19184.59 | 17787.0 |
| 2024-04-17 09:00:00 | NQ | Futures | 19184.59 | 19226.58 | 19126.0 | 19143.66 | 90747.0 |
| 2024-04-17 10:00:00 | NQ | Futures | 19144.73 | 19147.14 | 19007.23 | 19047.89 | 122817.0 |
| 2024-04-17 11:00:00 | NQ | Futures | 19048.43 | 19099.79 | 18967.37 | 18990.38 | 105346.0 |
| 2024-04-17 12:00:00 | NQ | Futures | 18989.84 | 18992.79 | 18848.6 | 18878.56 | 100891.0 |
| 2024-04-17 13:00:00 | NQ | Futures | 18878.56 | 18990.11 | 18871.34 | 18984.23 | 81704.0 |
| 2024-04-17 14:00:00 | NQ | Futures | 18983.96 | 19042.54 | 18924.3 | 18942.5 | 87468.0 |
| 2024-04-17 15:00:00 | NQ | Futures | 18942.5 | 18953.73 | 18884.18 | 18890.33 | 96297.0 |
| 2024-04-17 16:00:00 | NQ | Futures | 18890.6 | 18907.18 | 18873.48 | 18899.96 | 19266.0 |
| 2024-04-17 18:00:00 | NQ | Futures | 18906.92 | 18923.77 | 18906.92 | 18917.35 | 3555.0 |
| 2024-04-17 19:00:00 | NQ | Futures | 18917.08 | 18926.98 | 18910.66 | 18923.77 | 3379.0 |
| 2024-04-17 20:00:00 | NQ | Futures | 18924.3 | 18939.82 | 18916.81 | 18935.01 | 4560.0 |
| 2024-04-17 21:00:00 | NQ | Futures | 18935.81 | 18944.64 | 18930.46 | 18943.3 | 3361.0 |
| 2024-04-17 22:00:00 | NQ | Futures | 18944.1 | 18965.23 | 18940.89 | 18959.62 | 4185.0 |
| 2024-04-17 23:00:00 | NQ | Futures | 18960.69 | 18975.67 | 18960.42 | 18971.12 | 2631.0 |
| 2024-04-17 00:00:00 | YM | Futures | 40478.5 | 40483.8 | 40467.8 | 40479.5 | 1083.0 |
| 2024-04-17 01:00:00 | YM | Futures | 40481.6 | 40481.6 | 40394.6 | 40409.5 | 1754.0 |
| 2024-04-17 02:00:00 | YM | Futures | 40408.4 | 40416.9 | 40318.1 | 40376.5 | 3766.0 |
| 2024-04-17 03:00:00 | YM | Futures | 40375.5 | 40477.4 | 40371.2 | 40470.0 | 3813.0 |
> showing 50 of 2,098 rows — these rows as CSV