PREVIEW / futures_1hour / 2024-02-20
file: by_date/futures_1hour/2024/2024-02-20.parquet size: 66 KB rows: 2,077
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-02-20 00:00:00 | ES | Futures | 5377.18 | 5378.53 | 5374.23 | 5378.26 | 4987.0 |
| 2024-02-20 01:00:00 | ES | Futures | 5377.99 | 5382.82 | 5377.72 | 5380.14 | 5412.0 |
| 2024-02-20 02:00:00 | ES | Futures | 5380.41 | 5384.7 | 5378.53 | 5383.09 | 8173.0 |
| 2024-02-20 03:00:00 | ES | Futures | 5382.82 | 5384.97 | 5371.54 | 5379.87 | 19592.0 |
| 2024-02-20 04:00:00 | ES | Futures | 5379.87 | 5384.97 | 5373.96 | 5377.18 | 15901.0 |
| 2024-02-20 05:00:00 | ES | Futures | 5377.18 | 5377.45 | 5369.13 | 5371.54 | 16928.0 |
| 2024-02-20 06:00:00 | ES | Futures | 5371.54 | 5376.38 | 5365.63 | 5376.11 | 18115.0 |
| 2024-02-20 07:00:00 | ES | Futures | 5375.84 | 5379.87 | 5372.62 | 5375.84 | 18744.0 |
| 2024-02-20 08:00:00 | ES | Futures | 5375.84 | 5379.87 | 5371.27 | 5374.5 | 35298.0 |
| 2024-02-20 09:00:00 | ES | Futures | 5374.5 | 5381.75 | 5356.77 | 5362.41 | 213738.0 |
| 2024-02-20 10:00:00 | ES | Futures | 5362.41 | 5366.17 | 5352.47 | 5366.17 | 214930.0 |
| 2024-02-20 11:00:00 | ES | Futures | 5365.9 | 5369.13 | 5351.4 | 5352.2 | 130465.0 |
| 2024-02-20 12:00:00 | ES | Futures | 5352.47 | 5352.74 | 5337.7 | 5349.52 | 145914.0 |
| 2024-02-20 13:00:00 | ES | Futures | 5349.25 | 5354.62 | 5341.46 | 5354.09 | 103871.0 |
| 2024-02-20 14:00:00 | ES | Futures | 5354.09 | 5364.02 | 5346.56 | 5362.95 | 114290.0 |
| 2024-02-20 15:00:00 | ES | Futures | 5363.22 | 5364.83 | 5345.49 | 5363.75 | 259193.0 |
| 2024-02-20 16:00:00 | ES | Futures | 5363.75 | 5364.29 | 5357.04 | 5360.53 | 49987.0 |
| 2024-02-20 18:00:00 | ES | Futures | 5361.07 | 5364.56 | 5357.85 | 5359.46 | 9187.0 |
| 2024-02-20 19:00:00 | ES | Futures | 5359.46 | 5362.14 | 5355.43 | 5355.7 | 5917.0 |
| 2024-02-20 20:00:00 | ES | Futures | 5355.7 | 5355.97 | 5351.4 | 5355.16 | 8791.0 |
| 2024-02-20 21:00:00 | ES | Futures | 5355.43 | 5356.5 | 5351.94 | 5353.82 | 4088.0 |
| 2024-02-20 22:00:00 | ES | Futures | 5353.82 | 5355.7 | 5352.2 | 5355.16 | 2641.0 |
| 2024-02-20 23:00:00 | ES | Futures | 5355.43 | 5356.5 | 5354.62 | 5355.43 | 2459.0 |
| 2024-02-20 00:00:00 | NQ | Futures | 19181.56 | 19188.34 | 19167.19 | 19185.36 | 3742.0 |
| 2024-02-20 01:00:00 | NQ | Futures | 19185.09 | 19214.65 | 19183.19 | 19207.32 | 4708.0 |
| 2024-02-20 02:00:00 | NQ | Futures | 19207.6 | 19228.21 | 19198.1 | 19218.44 | 6440.0 |
| 2024-02-20 03:00:00 | NQ | Futures | 19218.17 | 19222.24 | 19131.93 | 19174.24 | 16162.0 |
| 2024-02-20 04:00:00 | NQ | Futures | 19174.51 | 19217.36 | 19152.81 | 19163.93 | 13058.0 |
| 2024-02-20 05:00:00 | NQ | Futures | 19163.39 | 19163.93 | 19113.76 | 19123.25 | 13193.0 |
| 2024-02-20 06:00:00 | NQ | Futures | 19123.79 | 19153.63 | 19108.06 | 19151.46 | 10945.0 |
| 2024-02-20 07:00:00 | NQ | Futures | 19151.73 | 19185.36 | 19145.22 | 19175.05 | 12529.0 |
| 2024-02-20 08:00:00 | NQ | Futures | 19175.32 | 19200.82 | 19154.17 | 19172.07 | 19504.0 |
| 2024-02-20 09:00:00 | NQ | Futures | 19172.88 | 19227.39 | 19031.31 | 19052.47 | 125312.0 |
| 2024-02-20 10:00:00 | NQ | Futures | 19052.19 | 19068.2 | 18964.87 | 19065.21 | 129135.0 |
| 2024-02-20 11:00:00 | NQ | Futures | 19064.94 | 19090.98 | 18989.0 | 18990.9 | 79727.0 |
| 2024-02-20 12:00:00 | NQ | Futures | 18991.44 | 19001.75 | 18932.86 | 18988.19 | 75875.0 |
| 2024-02-20 13:00:00 | NQ | Futures | 18988.46 | 19020.19 | 18958.36 | 19018.56 | 56636.0 |
| 2024-02-20 14:00:00 | NQ | Futures | 19018.84 | 19067.65 | 18990.09 | 19060.33 | 63408.0 |
| 2024-02-20 15:00:00 | NQ | Futures | 19061.14 | 19108.61 | 19017.75 | 19106.44 | 96528.0 |
| 2024-02-20 16:00:00 | NQ | Futures | 19106.16 | 19108.06 | 19065.75 | 19073.89 | 19155.0 |
| 2024-02-20 18:00:00 | NQ | Futures | 19063.59 | 19082.03 | 19053.55 | 19058.43 | 4896.0 |
| 2024-02-20 19:00:00 | NQ | Futures | 19058.97 | 19074.43 | 19045.41 | 19046.5 | 3890.0 |
| 2024-02-20 20:00:00 | NQ | Futures | 19047.31 | 19054.09 | 19026.16 | 19053.28 | 5668.0 |
| 2024-02-20 21:00:00 | NQ | Futures | 19053.28 | 19056.8 | 19035.38 | 19043.24 | 3737.0 |
| 2024-02-20 22:00:00 | NQ | Futures | 19043.52 | 19051.65 | 19035.65 | 19050.02 | 2000.0 |
| 2024-02-20 23:00:00 | NQ | Futures | 19050.3 | 19055.72 | 19042.97 | 19043.79 | 1692.0 |
| 2024-02-20 00:00:00 | YM | Futures | 41443.3 | 41453.0 | 41431.5 | 41448.7 | 770.0 |
| 2024-02-20 01:00:00 | YM | Futures | 41448.7 | 41474.4 | 41447.6 | 41458.3 | 664.0 |
| 2024-02-20 02:00:00 | YM | Futures | 41458.3 | 41483.0 | 41454.0 | 41468.0 | 1304.0 |
| 2024-02-20 03:00:00 | YM | Futures | 41468.0 | 41492.7 | 41418.6 | 41482.0 | 2852.0 |
> showing 50 of 2,077 rows — these rows as CSV