PREVIEW / futures_1hour / 2024-12-20
file: by_date/futures_1hour/2024/2024-12-20.parquet size: 58 KB rows: 1,683
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-12-20 00:00:00 | ES | Futures | 6064.87 | 6068.97 | 6062.82 | 6068.71 | 7029.0 |
| 2024-12-20 01:00:00 | ES | Futures | 6068.46 | 6077.94 | 6064.1 | 6077.69 | 8666.0 |
| 2024-12-20 02:00:00 | ES | Futures | 6077.43 | 6078.97 | 6067.18 | 6073.07 | 10477.0 |
| 2024-12-20 03:00:00 | ES | Futures | 6072.82 | 6073.84 | 6041.79 | 6052.56 | 28605.0 |
| 2024-12-20 04:00:00 | ES | Futures | 6052.56 | 6053.59 | 6032.31 | 6036.41 | 28142.0 |
| 2024-12-20 05:00:00 | ES | Futures | 6036.41 | 6042.82 | 6028.72 | 6038.21 | 23953.0 |
| 2024-12-20 06:00:00 | ES | Futures | 6038.21 | 6043.85 | 6031.8 | 6032.82 | 18897.0 |
| 2024-12-20 07:00:00 | ES | Futures | 6032.56 | 6036.67 | 6015.64 | 6035.64 | 44654.0 |
| 2024-12-20 08:00:00 | ES | Futures | 6035.39 | 6064.1 | 6027.18 | 6053.08 | 89575.0 |
| 2024-12-20 09:00:00 | ES | Futures | 6053.08 | 6083.07 | 6045.64 | 6060.77 | 277891.0 |
| 2024-12-20 10:00:00 | ES | Futures | 6061.28 | 6135.12 | 6061.28 | 6124.6 | 320726.0 |
| 2024-12-20 11:00:00 | ES | Futures | 6124.6 | 6194.85 | 6122.81 | 6189.72 | 271299.0 |
| 2024-12-20 12:00:00 | ES | Futures | 6189.98 | 6205.11 | 6183.83 | 6192.8 | 169413.0 |
| 2024-12-20 13:00:00 | ES | Futures | 6192.8 | 6193.31 | 6164.86 | 6166.91 | 158473.0 |
| 2024-12-20 14:00:00 | ES | Futures | 6166.65 | 6186.65 | 6162.04 | 6170.75 | 116200.0 |
| 2024-12-20 15:00:00 | ES | Futures | 6170.75 | 6175.11 | 6139.99 | 6155.37 | 348422.0 |
| 2024-12-20 16:00:00 | ES | Futures | 6155.37 | 6172.55 | 6140.24 | 6149.47 | 118210.0 |
| 2024-12-20 00:00:00 | NQ | Futures | 21872.15 | 21889.14 | 21863.4 | 21888.36 | 3572.0 |
| 2024-12-20 01:00:00 | NQ | Futures | 21887.59 | 21922.33 | 21860.31 | 21918.99 | 4923.0 |
| 2024-12-20 02:00:00 | NQ | Futures | 21918.47 | 21927.48 | 21881.93 | 21905.86 | 6732.0 |
| 2024-12-20 03:00:00 | NQ | Futures | 21904.58 | 21916.42 | 21771.79 | 21813.22 | 15706.0 |
| 2024-12-20 04:00:00 | NQ | Futures | 21813.73 | 21816.05 | 21727.01 | 21743.99 | 17305.0 |
| 2024-12-20 05:00:00 | NQ | Futures | 21743.48 | 21769.98 | 21715.94 | 21725.21 | 13326.0 |
| 2024-12-20 06:00:00 | NQ | Futures | 21725.21 | 21746.31 | 21690.46 | 21707.71 | 12737.0 |
| 2024-12-20 07:00:00 | NQ | Futures | 21707.19 | 21723.92 | 21623.81 | 21719.29 | 23542.0 |
| 2024-12-20 08:00:00 | NQ | Futures | 21718.52 | 21857.23 | 21689.69 | 21841.27 | 41292.0 |
| 2024-12-20 09:00:00 | NQ | Futures | 21840.24 | 21935.2 | 21782.34 | 21855.42 | 97808.0 |
| 2024-12-20 10:00:00 | NQ | Futures | 21855.42 | 22184.83 | 21855.42 | 22144.94 | 125274.0 |
| 2024-12-20 11:00:00 | NQ | Futures | 22145.97 | 22425.7 | 22135.42 | 22390.19 | 110846.0 |
| 2024-12-20 12:00:00 | NQ | Futures | 22390.96 | 22453.24 | 22366.51 | 22400.74 | 70969.0 |
| 2024-12-20 13:00:00 | NQ | Futures | 22401.0 | 22412.84 | 22291.63 | 22303.98 | 65962.0 |
| 2024-12-20 14:00:00 | NQ | Futures | 22302.95 | 22392.51 | 22285.19 | 22336.41 | 52551.0 |
| 2024-12-20 15:00:00 | NQ | Futures | 22336.66 | 22352.36 | 22150.09 | 22201.3 | 98150.0 |
| 2024-12-20 16:00:00 | NQ | Futures | 22201.56 | 22264.61 | 22144.68 | 22185.86 | 31656.0 |
| 2024-12-20 00:00:00 | YM | Futures | 43935.3 | 43965.1 | 43929.1 | 43965.1 | 604.0 |
| 2024-12-20 01:00:00 | YM | Futures | 43964.1 | 44028.9 | 43941.4 | 44026.9 | 933.0 |
| 2024-12-20 02:00:00 | YM | Futures | 44027.9 | 44040.2 | 43957.9 | 44003.2 | 1317.0 |
| 2024-12-20 03:00:00 | YM | Futures | 44003.2 | 44005.2 | 43787.0 | 43873.5 | 3103.0 |
| 2024-12-20 04:00:00 | YM | Futures | 43871.4 | 43878.6 | 43766.5 | 43817.9 | 3416.0 |
| 2024-12-20 05:00:00 | YM | Futures | 43818.9 | 43839.5 | 43757.2 | 43822.0 | 4599.0 |
| 2024-12-20 06:00:00 | YM | Futures | 43816.9 | 43883.8 | 43808.7 | 43841.6 | 3411.0 |
| 2024-12-20 07:00:00 | YM | Futures | 43839.5 | 43852.9 | 43739.7 | 43839.5 | 5142.0 |
| 2024-12-20 08:00:00 | YM | Futures | 43839.5 | 43981.6 | 43790.1 | 43903.3 | 8014.0 |
| 2024-12-20 09:00:00 | YM | Futures | 43902.3 | 44111.3 | 43853.9 | 44006.3 | 22307.0 |
| 2024-12-20 10:00:00 | YM | Futures | 44011.4 | 44455.0 | 43969.2 | 44388.1 | 21518.0 |
| 2024-12-20 11:00:00 | YM | Futures | 44389.2 | 44842.0 | 44373.7 | 44822.5 | 18278.0 |
| 2024-12-20 12:00:00 | YM | Futures | 44821.5 | 44940.8 | 44787.5 | 44851.3 | 10603.0 |
| 2024-12-20 13:00:00 | YM | Futures | 44850.3 | 44850.3 | 44646.5 | 44666.0 | 10501.0 |
| 2024-12-20 14:00:00 | YM | Futures | 44661.9 | 44811.2 | 44645.4 | 44686.6 | 7589.0 |
| 2024-12-20 15:00:00 | YM | Futures | 44685.6 | 44721.6 | 44511.6 | 44582.7 | 18283.0 |
> showing 50 of 1,683 rows — these rows as CSV