PREVIEW / futures_1hour / 2024-10-25
file: by_date/futures_1hour/2024/2024-10-25.parquet size: 56 KB rows: 1,658
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-10-25 00:00:00 | ES | Futures | 6069.99 | 6070.25 | 6067.4 | 6068.7 | 2951.0 |
| 2024-10-25 01:00:00 | ES | Futures | 6068.7 | 6073.37 | 6066.88 | 6072.33 | 4516.0 |
| 2024-10-25 02:00:00 | ES | Futures | 6072.33 | 6076.48 | 6072.07 | 6072.33 | 4904.0 |
| 2024-10-25 03:00:00 | ES | Futures | 6072.33 | 6084.27 | 6071.29 | 6084.01 | 11210.0 |
| 2024-10-25 04:00:00 | ES | Futures | 6083.75 | 6084.27 | 6075.96 | 6081.41 | 11501.0 |
| 2024-10-25 05:00:00 | ES | Futures | 6081.15 | 6087.64 | 6081.15 | 6086.08 | 10884.0 |
| 2024-10-25 06:00:00 | ES | Futures | 6086.08 | 6088.68 | 6084.27 | 6085.3 | 7613.0 |
| 2024-10-25 07:00:00 | ES | Futures | 6085.05 | 6090.75 | 6081.15 | 6088.16 | 11503.0 |
| 2024-10-25 08:00:00 | ES | Futures | 6087.9 | 6095.69 | 6087.64 | 6094.91 | 19353.0 |
| 2024-10-25 09:00:00 | ES | Futures | 6095.17 | 6115.15 | 6093.09 | 6112.55 | 140523.0 |
| 2024-10-25 10:00:00 | ES | Futures | 6113.07 | 6125.53 | 6109.96 | 6114.63 | 195505.0 |
| 2024-10-25 11:00:00 | ES | Futures | 6114.63 | 6118.78 | 6095.69 | 6100.36 | 148742.0 |
| 2024-10-25 12:00:00 | ES | Futures | 6100.36 | 6107.36 | 6096.2 | 6099.06 | 84915.0 |
| 2024-10-25 13:00:00 | ES | Futures | 6099.06 | 6099.06 | 6062.21 | 6068.95 | 215725.0 |
| 2024-10-25 14:00:00 | ES | Futures | 6069.21 | 6082.97 | 6057.28 | 6079.85 | 157796.0 |
| 2024-10-25 15:00:00 | ES | Futures | 6080.11 | 6080.37 | 6062.47 | 6068.18 | 179101.0 |
| 2024-10-25 16:00:00 | ES | Futures | 6067.92 | 6069.99 | 6062.21 | 6064.02 | 63203.0 |
| 2024-10-25 00:00:00 | NQ | Futures | 21264.62 | 21265.4 | 21253.66 | 21261.22 | 2160.0 |
| 2024-10-25 01:00:00 | NQ | Futures | 21261.74 | 21286.01 | 21256.27 | 21279.75 | 2609.0 |
| 2024-10-25 02:00:00 | NQ | Futures | 21280.01 | 21297.23 | 21271.14 | 21276.88 | 3355.0 |
| 2024-10-25 03:00:00 | NQ | Futures | 21276.62 | 21331.15 | 21272.7 | 21330.36 | 6467.0 |
| 2024-10-25 04:00:00 | NQ | Futures | 21330.1 | 21336.37 | 21288.1 | 21312.1 | 6679.0 |
| 2024-10-25 05:00:00 | NQ | Futures | 21310.8 | 21338.19 | 21310.27 | 21325.93 | 4630.0 |
| 2024-10-25 06:00:00 | NQ | Futures | 21326.45 | 21336.37 | 21317.58 | 21321.75 | 3053.0 |
| 2024-10-25 07:00:00 | NQ | Futures | 21321.23 | 21349.93 | 21300.88 | 21337.93 | 6692.0 |
| 2024-10-25 08:00:00 | NQ | Futures | 21337.41 | 21388.55 | 21335.32 | 21386.2 | 13689.0 |
| 2024-10-25 09:00:00 | NQ | Futures | 21386.46 | 21559.71 | 21384.63 | 21550.84 | 91647.0 |
| 2024-10-25 10:00:00 | NQ | Futures | 21550.57 | 21611.11 | 21520.83 | 21557.36 | 99340.0 |
| 2024-10-25 11:00:00 | NQ | Futures | 21557.62 | 21578.75 | 21502.57 | 21520.31 | 63679.0 |
| 2024-10-25 12:00:00 | NQ | Futures | 21520.31 | 21566.75 | 21508.31 | 21539.88 | 37243.0 |
| 2024-10-25 13:00:00 | NQ | Futures | 21540.4 | 21543.27 | 21377.59 | 21405.77 | 82637.0 |
| 2024-10-25 14:00:00 | NQ | Futures | 21406.03 | 21459.52 | 21353.06 | 21439.69 | 61945.0 |
| 2024-10-25 15:00:00 | NQ | Futures | 21440.21 | 21441.25 | 21376.02 | 21389.85 | 55055.0 |
| 2024-10-25 16:00:00 | NQ | Futures | 21389.85 | 21399.25 | 21365.59 | 21369.76 | 15283.0 |
| 2024-10-25 00:00:00 | YM | Futures | 44320.4 | 44326.7 | 44309.0 | 44314.2 | 310.0 |
| 2024-10-25 01:00:00 | YM | Futures | 44315.2 | 44334.0 | 44295.5 | 44329.8 | 530.0 |
| 2024-10-25 02:00:00 | YM | Futures | 44330.8 | 44352.7 | 44318.4 | 44318.4 | 753.0 |
| 2024-10-25 03:00:00 | YM | Futures | 44320.4 | 44383.9 | 44316.3 | 44383.9 | 1509.0 |
| 2024-10-25 04:00:00 | YM | Futures | 44385.0 | 44397.5 | 44348.5 | 44391.2 | 1621.0 |
| 2024-10-25 05:00:00 | YM | Futures | 44388.1 | 44440.1 | 44387.0 | 44425.6 | 1658.0 |
| 2024-10-25 06:00:00 | YM | Futures | 44425.6 | 44454.7 | 44411.0 | 44415.1 | 1437.0 |
| 2024-10-25 07:00:00 | YM | Futures | 44415.1 | 44452.6 | 44394.3 | 44429.7 | 1635.0 |
| 2024-10-25 08:00:00 | YM | Futures | 44429.7 | 44475.5 | 44421.4 | 44466.1 | 2448.0 |
| 2024-10-25 09:00:00 | YM | Futures | 44465.1 | 44548.4 | 44429.7 | 44472.4 | 14473.0 |
| 2024-10-25 10:00:00 | YM | Futures | 44474.5 | 44555.6 | 44423.5 | 44431.8 | 13254.0 |
| 2024-10-25 11:00:00 | YM | Futures | 44431.8 | 44454.7 | 44207.0 | 44246.5 | 14234.0 |
| 2024-10-25 12:00:00 | YM | Futures | 44246.5 | 44301.7 | 44196.6 | 44241.3 | 7871.0 |
| 2024-10-25 13:00:00 | YM | Futures | 44242.4 | 44243.4 | 43973.9 | 44029.0 | 15047.0 |
| 2024-10-25 14:00:00 | YM | Futures | 44030.1 | 44143.5 | 43966.6 | 44124.8 | 11980.0 |
| 2024-10-25 15:00:00 | YM | Futures | 44126.9 | 44138.3 | 44008.2 | 44042.6 | 12614.0 |
> showing 50 of 1,658 rows — these rows as CSV