PREVIEW / futures_1hour / 2024-04-16
file: by_date/futures_1hour/2024/2024-04-16.parquet size: 68 KB rows: 2,097
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-04-16 00:00:00 | ES | Futures | 5404.87 | 5406.46 | 5399.83 | 5405.13 | 6066.0 |
| 2024-04-16 01:00:00 | ES | Futures | 5405.4 | 5412.56 | 5404.6 | 5410.18 | 8241.0 |
| 2024-04-16 02:00:00 | ES | Futures | 5410.18 | 5411.5 | 5400.36 | 5403.81 | 15651.0 |
| 2024-04-16 03:00:00 | ES | Futures | 5403.81 | 5413.89 | 5401.69 | 5413.09 | 34844.0 |
| 2024-04-16 04:00:00 | ES | Futures | 5413.36 | 5415.48 | 5408.85 | 5412.83 | 23793.0 |
| 2024-04-16 05:00:00 | ES | Futures | 5412.83 | 5415.75 | 5400.36 | 5408.58 | 28769.0 |
| 2024-04-16 06:00:00 | ES | Futures | 5408.58 | 5414.95 | 5399.3 | 5413.89 | 32877.0 |
| 2024-04-16 07:00:00 | ES | Futures | 5414.15 | 5433.52 | 5412.3 | 5431.13 | 51991.0 |
| 2024-04-16 08:00:00 | ES | Futures | 5430.87 | 5433.26 | 5415.48 | 5425.03 | 59769.0 |
| 2024-04-16 09:00:00 | ES | Futures | 5425.03 | 5429.01 | 5398.24 | 5414.42 | 265318.0 |
| 2024-04-16 10:00:00 | ES | Futures | 5414.42 | 5423.17 | 5392.4 | 5399.56 | 243097.0 |
| 2024-04-16 11:00:00 | ES | Futures | 5399.83 | 5423.97 | 5397.18 | 5412.03 | 172368.0 |
| 2024-04-16 12:00:00 | ES | Futures | 5412.03 | 5421.05 | 5403.54 | 5415.22 | 136300.0 |
| 2024-04-16 13:00:00 | ES | Futures | 5415.22 | 5420.52 | 5389.48 | 5408.32 | 273221.0 |
| 2024-04-16 14:00:00 | ES | Futures | 5408.58 | 5436.7 | 5394.26 | 5428.75 | 288512.0 |
| 2024-04-16 15:00:00 | ES | Futures | 5429.01 | 5429.54 | 5401.16 | 5403.54 | 261197.0 |
| 2024-04-16 16:00:00 | ES | Futures | 5403.81 | 5406.99 | 5399.3 | 5406.2 | 55141.0 |
| 2024-04-16 18:00:00 | ES | Futures | 5408.05 | 5413.36 | 5407.52 | 5410.97 | 6041.0 |
| 2024-04-16 19:00:00 | ES | Futures | 5410.71 | 5419.46 | 5408.58 | 5418.93 | 9194.0 |
| 2024-04-16 20:00:00 | ES | Futures | 5418.93 | 5418.93 | 5404.87 | 5409.91 | 13536.0 |
| 2024-04-16 21:00:00 | ES | Futures | 5409.91 | 5414.42 | 5407.79 | 5413.09 | 15579.0 |
| 2024-04-16 22:00:00 | ES | Futures | 5412.83 | 5417.34 | 5411.5 | 5416.28 | 5193.0 |
| 2024-04-16 23:00:00 | ES | Futures | 5416.54 | 5418.13 | 5415.22 | 5416.81 | 3207.0 |
| 2024-04-16 00:00:00 | NQ | Futures | 19096.58 | 19096.85 | 19070.09 | 19093.1 | 3184.0 |
| 2024-04-16 01:00:00 | NQ | Futures | 19093.64 | 19126.0 | 19090.16 | 19114.77 | 5510.0 |
| 2024-04-16 02:00:00 | NQ | Futures | 19113.7 | 19118.25 | 19077.58 | 19095.51 | 7799.0 |
| 2024-04-16 03:00:00 | NQ | Futures | 19095.78 | 19127.61 | 19089.35 | 19126.0 | 13808.0 |
| 2024-04-16 04:00:00 | NQ | Futures | 19126.0 | 19135.63 | 19105.14 | 19118.78 | 9166.0 |
| 2024-04-16 05:00:00 | NQ | Futures | 19117.71 | 19128.41 | 19070.09 | 19093.64 | 10553.0 |
| 2024-04-16 06:00:00 | NQ | Futures | 19093.9 | 19111.02 | 19037.73 | 19108.35 | 15589.0 |
| 2024-04-16 07:00:00 | NQ | Futures | 19109.15 | 19173.08 | 19101.66 | 19162.12 | 18497.0 |
| 2024-04-16 08:00:00 | NQ | Futures | 19162.12 | 19172.28 | 19116.11 | 19146.33 | 25314.0 |
| 2024-04-16 09:00:00 | NQ | Futures | 19145.53 | 19164.79 | 19069.83 | 19150.88 | 102990.0 |
| 2024-04-16 10:00:00 | NQ | Futures | 19150.61 | 19186.99 | 19083.2 | 19114.5 | 101772.0 |
| 2024-04-16 11:00:00 | NQ | Futures | 19114.23 | 19192.34 | 19101.39 | 19143.12 | 63538.0 |
| 2024-04-16 12:00:00 | NQ | Futures | 19143.12 | 19186.19 | 19113.16 | 19167.2 | 52212.0 |
| 2024-04-16 13:00:00 | NQ | Futures | 19167.73 | 19185.12 | 19065.55 | 19141.52 | 105042.0 |
| 2024-04-16 14:00:00 | NQ | Futures | 19141.79 | 19247.45 | 19095.51 | 19207.06 | 97900.0 |
| 2024-04-16 15:00:00 | NQ | Futures | 19207.06 | 19211.87 | 19125.47 | 19128.14 | 71512.0 |
| 2024-04-16 16:00:00 | NQ | Futures | 19127.88 | 19148.47 | 19123.86 | 19146.87 | 14312.0 |
| 2024-04-16 18:00:00 | NQ | Futures | 19150.08 | 19170.68 | 19149.54 | 19161.31 | 3109.0 |
| 2024-04-16 19:00:00 | NQ | Futures | 19161.05 | 19196.09 | 19151.95 | 19191.54 | 4561.0 |
| 2024-04-16 20:00:00 | NQ | Futures | 19192.08 | 19192.08 | 19142.86 | 19164.79 | 8174.0 |
| 2024-04-16 21:00:00 | NQ | Futures | 19164.26 | 19187.53 | 19157.84 | 19179.5 | 5659.0 |
| 2024-04-16 22:00:00 | NQ | Futures | 19178.97 | 19190.74 | 19169.87 | 19185.92 | 3352.0 |
| 2024-04-16 23:00:00 | NQ | Futures | 19186.19 | 19193.68 | 19180.84 | 19184.32 | 2217.0 |
| 2024-04-16 00:00:00 | YM | Futures | 40253.4 | 40256.6 | 40221.5 | 40253.4 | 716.0 |
| 2024-04-16 01:00:00 | YM | Futures | 40252.3 | 40305.4 | 40248.1 | 40292.7 | 1258.0 |
| 2024-04-16 02:00:00 | YM | Futures | 40291.6 | 40301.2 | 40221.5 | 40241.7 | 2479.0 |
| 2024-04-16 03:00:00 | YM | Futures | 40241.7 | 40315.0 | 40225.8 | 40303.3 | 4459.0 |
> showing 50 of 2,097 rows — these rows as CSV