PREVIEW / futures_1hour / 2024-05-20
file: by_date/futures_1hour/2024/2024-05-20.parquet size: 65 KB rows: 2,055
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-05-20 00:00:00 | ES | Futures | 5660.88 | 5661.94 | 5660.08 | 5661.15 | 2058.0 |
| 2024-05-20 01:00:00 | ES | Futures | 5661.41 | 5662.47 | 5660.61 | 5662.21 | 3073.0 |
| 2024-05-20 02:00:00 | ES | Futures | 5661.94 | 5661.94 | 5658.23 | 5658.49 | 6339.0 |
| 2024-05-20 03:00:00 | ES | Futures | 5658.49 | 5659.55 | 5656.64 | 5658.49 | 9021.0 |
| 2024-05-20 04:00:00 | ES | Futures | 5658.23 | 5660.08 | 5656.37 | 5658.23 | 7818.0 |
| 2024-05-20 05:00:00 | ES | Futures | 5658.23 | 5660.08 | 5656.64 | 5659.82 | 5662.0 |
| 2024-05-20 06:00:00 | ES | Futures | 5659.82 | 5661.41 | 5658.49 | 5661.15 | 4674.0 |
| 2024-05-20 07:00:00 | ES | Futures | 5661.15 | 5663.53 | 5659.29 | 5662.47 | 9666.0 |
| 2024-05-20 08:00:00 | ES | Futures | 5662.47 | 5663.8 | 5654.51 | 5655.84 | 27568.0 |
| 2024-05-20 09:00:00 | ES | Futures | 5655.84 | 5672.02 | 5652.66 | 5670.96 | 135267.0 |
| 2024-05-20 10:00:00 | ES | Futures | 5670.96 | 5674.68 | 5666.19 | 5672.29 | 132653.0 |
| 2024-05-20 11:00:00 | ES | Futures | 5672.02 | 5675.47 | 5667.51 | 5669.37 | 106136.0 |
| 2024-05-20 12:00:00 | ES | Futures | 5669.63 | 5672.02 | 5665.66 | 5671.49 | 83736.0 |
| 2024-05-20 13:00:00 | ES | Futures | 5671.76 | 5672.55 | 5659.29 | 5661.15 | 98867.0 |
| 2024-05-20 14:00:00 | ES | Futures | 5661.15 | 5663.27 | 5649.47 | 5657.17 | 115161.0 |
| 2024-05-20 15:00:00 | ES | Futures | 5657.43 | 5662.74 | 5653.45 | 5659.55 | 160732.0 |
| 2024-05-20 16:00:00 | ES | Futures | 5659.29 | 5662.21 | 5655.57 | 5657.96 | 48338.0 |
| 2024-05-20 18:00:00 | ES | Futures | 5657.96 | 5659.55 | 5655.57 | 5656.37 | 3202.0 |
| 2024-05-20 19:00:00 | ES | Futures | 5656.64 | 5657.96 | 5656.1 | 5657.7 | 2031.0 |
| 2024-05-20 20:00:00 | ES | Futures | 5657.7 | 5660.61 | 5657.17 | 5659.29 | 4682.0 |
| 2024-05-20 21:00:00 | ES | Futures | 5659.29 | 5659.82 | 5656.37 | 5657.17 | 4503.0 |
| 2024-05-20 22:00:00 | ES | Futures | 5657.17 | 5659.02 | 5656.9 | 5657.7 | 2940.0 |
| 2024-05-20 23:00:00 | ES | Futures | 5657.7 | 5659.29 | 5657.7 | 5658.49 | 2391.0 |
| 2024-05-20 00:00:00 | NQ | Futures | 19976.93 | 19981.75 | 19974.53 | 19978.81 | 1358.0 |
| 2024-05-20 01:00:00 | NQ | Futures | 19978.81 | 19986.56 | 19977.2 | 19984.96 | 2054.0 |
| 2024-05-20 02:00:00 | NQ | Futures | 19984.42 | 19984.42 | 19968.64 | 19971.85 | 3486.0 |
| 2024-05-20 03:00:00 | NQ | Futures | 19972.12 | 19975.86 | 19960.88 | 19968.37 | 4750.0 |
| 2024-05-20 04:00:00 | NQ | Futures | 19967.57 | 19977.74 | 19960.62 | 19967.84 | 4281.0 |
| 2024-05-20 05:00:00 | NQ | Futures | 19967.57 | 19979.34 | 19959.81 | 19978.0 | 3179.0 |
| 2024-05-20 06:00:00 | NQ | Futures | 19978.0 | 19986.3 | 19971.85 | 19984.16 | 3304.0 |
| 2024-05-20 07:00:00 | NQ | Futures | 19984.69 | 19998.07 | 19975.86 | 19990.04 | 6099.0 |
| 2024-05-20 08:00:00 | NQ | Futures | 19990.31 | 19995.93 | 19948.58 | 19954.46 | 12695.0 |
| 2024-05-20 09:00:00 | NQ | Futures | 19954.73 | 20066.81 | 19940.02 | 20062.27 | 82845.0 |
| 2024-05-20 10:00:00 | NQ | Futures | 20062.53 | 20086.34 | 20043.27 | 20055.85 | 62685.0 |
| 2024-05-20 11:00:00 | NQ | Futures | 20056.11 | 20076.18 | 20040.87 | 20054.24 | 43000.0 |
| 2024-05-20 12:00:00 | NQ | Futures | 20054.24 | 20110.42 | 20053.44 | 20106.94 | 43629.0 |
| 2024-05-20 13:00:00 | NQ | Futures | 20106.94 | 20109.62 | 20047.29 | 20057.99 | 47298.0 |
| 2024-05-20 14:00:00 | NQ | Futures | 20058.25 | 20081.26 | 20016.79 | 20061.46 | 53468.0 |
| 2024-05-20 15:00:00 | NQ | Futures | 20061.46 | 20099.18 | 20052.9 | 20080.19 | 61021.0 |
| 2024-05-20 16:00:00 | NQ | Futures | 20079.92 | 20089.02 | 20049.96 | 20057.72 | 14686.0 |
| 2024-05-20 18:00:00 | NQ | Futures | 20058.52 | 20067.35 | 20054.78 | 20058.52 | 2212.0 |
| 2024-05-20 19:00:00 | NQ | Futures | 20057.99 | 20065.48 | 20055.85 | 20064.67 | 1357.0 |
| 2024-05-20 20:00:00 | NQ | Futures | 20064.41 | 20072.97 | 20060.66 | 20069.76 | 1841.0 |
| 2024-05-20 21:00:00 | NQ | Futures | 20069.22 | 20070.02 | 20053.17 | 20056.65 | 2582.0 |
| 2024-05-20 22:00:00 | NQ | Futures | 20055.85 | 20067.62 | 20055.04 | 20062.27 | 2205.0 |
| 2024-05-20 23:00:00 | NQ | Futures | 20062.0 | 20065.74 | 20060.66 | 20064.14 | 1292.0 |
| 2024-05-20 00:00:00 | YM | Futures | 42650.7 | 42658.1 | 42642.2 | 42649.6 | 407.0 |
| 2024-05-20 01:00:00 | YM | Futures | 42648.6 | 42657.1 | 42644.3 | 42657.1 | 457.0 |
| 2024-05-20 02:00:00 | YM | Futures | 42653.9 | 42653.9 | 42628.4 | 42631.6 | 1104.0 |
| 2024-05-20 03:00:00 | YM | Futures | 42631.6 | 42647.5 | 42626.3 | 42641.2 | 1130.0 |
> showing 50 of 2,055 rows — these rows as CSV