PREVIEW / futures_1hour / 2025-06-20
file: by_date/futures_1hour/2025/2025-06-20.parquet size: 56 KB rows: 1,647
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 |
|---|---|---|---|---|---|---|---|
| 2025-06-20 00:00:00 | ES | Futures | 6065.9 | 6070.43 | 6064.39 | 6067.41 | 2693.0 |
| 2025-06-20 01:00:00 | ES | Futures | 6067.16 | 6070.68 | 6062.62 | 6070.68 | 4663.0 |
| 2025-06-20 02:00:00 | ES | Futures | 6070.43 | 6075.97 | 6063.13 | 6066.4 | 10907.0 |
| 2025-06-20 03:00:00 | ES | Futures | 6066.15 | 6074.71 | 6061.62 | 6072.7 | 9873.0 |
| 2025-06-20 04:00:00 | ES | Futures | 6072.95 | 6078.74 | 6056.83 | 6058.09 | 13984.0 |
| 2025-06-20 05:00:00 | ES | Futures | 6058.34 | 6070.43 | 6058.09 | 6068.92 | 7515.0 |
| 2025-06-20 06:00:00 | ES | Futures | 6068.92 | 6070.68 | 6062.88 | 6067.66 | 6955.0 |
| 2025-06-20 07:00:00 | ES | Futures | 6067.66 | 6094.36 | 6066.91 | 6082.02 | 28123.0 |
| 2025-06-20 08:00:00 | ES | Futures | 6082.02 | 6101.16 | 6081.51 | 6098.89 | 36573.0 |
| 2025-06-20 09:00:00 | ES | Futures | 6098.89 | 6116.52 | 6092.85 | 6094.86 | 181046.0 |
| 2025-06-20 10:00:00 | ES | Futures | 6094.86 | 6097.38 | 6060.36 | 6064.39 | 208847.0 |
| 2025-06-20 11:00:00 | ES | Futures | 6064.13 | 6085.04 | 6055.32 | 6067.91 | 147226.0 |
| 2025-06-20 12:00:00 | ES | Futures | 6068.16 | 6077.99 | 6062.88 | 6074.21 | 98533.0 |
| 2025-06-20 13:00:00 | ES | Futures | 6074.21 | 6080.76 | 6048.27 | 6060.86 | 126669.0 |
| 2025-06-20 14:00:00 | ES | Futures | 6060.61 | 6074.21 | 6053.81 | 6056.58 | 95993.0 |
| 2025-06-20 15:00:00 | ES | Futures | 6056.33 | 6069.93 | 6052.3 | 6061.87 | 210888.0 |
| 2025-06-20 16:00:00 | ES | Futures | 6062.12 | 6077.74 | 6058.34 | 6070.18 | 64373.0 |
| 2025-06-20 00:00:00 | NQ | Futures | 22090.99 | 22114.19 | 22085.45 | 22100.58 | 2132.0 |
| 2025-06-20 01:00:00 | NQ | Futures | 22098.81 | 22114.7 | 22080.65 | 22113.69 | 3317.0 |
| 2025-06-20 02:00:00 | NQ | Futures | 22113.69 | 22135.88 | 22088.72 | 22097.3 | 5636.0 |
| 2025-06-20 03:00:00 | NQ | Futures | 22097.55 | 22123.02 | 22083.18 | 22115.71 | 4167.0 |
| 2025-06-20 04:00:00 | NQ | Futures | 22115.96 | 22140.42 | 22049.38 | 22055.44 | 7377.0 |
| 2025-06-20 05:00:00 | NQ | Futures | 22056.19 | 22098.31 | 22054.18 | 22090.74 | 4885.0 |
| 2025-06-20 06:00:00 | NQ | Futures | 22090.24 | 22102.09 | 22073.59 | 22089.48 | 4135.0 |
| 2025-06-20 07:00:00 | NQ | Futures | 22089.48 | 22197.66 | 22086.45 | 22158.58 | 12244.0 |
| 2025-06-20 08:00:00 | NQ | Futures | 22159.33 | 22234.23 | 22156.56 | 22221.37 | 16674.0 |
| 2025-06-20 09:00:00 | NQ | Futures | 22221.62 | 22323.25 | 22202.2 | 22209.77 | 70192.0 |
| 2025-06-20 10:00:00 | NQ | Futures | 22210.02 | 22222.13 | 21989.37 | 22009.29 | 98996.0 |
| 2025-06-20 11:00:00 | NQ | Futures | 22008.53 | 22112.93 | 21965.66 | 22038.79 | 63445.0 |
| 2025-06-20 12:00:00 | NQ | Futures | 22038.79 | 22093.01 | 22023.41 | 22074.85 | 39178.0 |
| 2025-06-20 13:00:00 | NQ | Futures | 22074.85 | 22107.64 | 21954.57 | 22029.71 | 47739.0 |
| 2025-06-20 14:00:00 | NQ | Futures | 22028.71 | 22091.75 | 21997.69 | 22006.01 | 34471.0 |
| 2025-06-20 15:00:00 | NQ | Futures | 22006.51 | 22049.89 | 21983.57 | 22033.24 | 50195.0 |
| 2025-06-20 16:00:00 | NQ | Futures | 22033.24 | 22102.09 | 22028.96 | 22064.51 | 16854.0 |
| 2025-06-20 00:00:00 | YM | Futures | 43311.6 | 43335.1 | 43300.3 | 43322.8 | 486.0 |
| 2025-06-20 01:00:00 | YM | Futures | 43322.8 | 43347.3 | 43287.1 | 43344.3 | 945.0 |
| 2025-06-20 02:00:00 | YM | Futures | 43346.3 | 43382.1 | 43294.2 | 43302.4 | 2053.0 |
| 2025-06-20 03:00:00 | YM | Futures | 43301.4 | 43375.9 | 43280.9 | 43360.6 | 1217.0 |
| 2025-06-20 04:00:00 | YM | Futures | 43359.6 | 43434.2 | 43287.1 | 43291.2 | 2704.0 |
| 2025-06-20 05:00:00 | YM | Futures | 43293.2 | 43384.1 | 43288.1 | 43370.8 | 914.0 |
| 2025-06-20 06:00:00 | YM | Futures | 43366.7 | 43377.0 | 43316.7 | 43357.6 | 649.0 |
| 2025-06-20 07:00:00 | YM | Futures | 43355.5 | 43532.2 | 43338.1 | 43451.5 | 3467.0 |
| 2025-06-20 08:00:00 | YM | Futures | 43450.5 | 43595.6 | 43448.5 | 43563.9 | 3206.0 |
| 2025-06-20 09:00:00 | YM | Futures | 43566.0 | 43681.4 | 43528.2 | 43552.7 | 12136.0 |
| 2025-06-20 10:00:00 | YM | Futures | 43553.7 | 43606.8 | 43440.3 | 43456.6 | 11471.0 |
| 2025-06-20 11:00:00 | YM | Futures | 43449.5 | 43592.5 | 43394.3 | 43478.1 | 8079.0 |
| 2025-06-20 12:00:00 | YM | Futures | 43479.1 | 43536.3 | 43431.1 | 43504.7 | 5895.0 |
| 2025-06-20 13:00:00 | YM | Futures | 43504.7 | 43548.6 | 43318.7 | 43373.9 | 7555.0 |
| 2025-06-20 14:00:00 | YM | Futures | 43373.9 | 43476.1 | 43345.3 | 43373.9 | 4868.0 |
| 2025-06-20 15:00:00 | YM | Futures | 43371.9 | 43493.4 | 43358.6 | 43431.1 | 8265.0 |
> showing 50 of 1,647 rows — these rows as CSV