PREVIEW / futures_1hour / 2022-05-19
file: by_date/futures_1hour/2022/2022-05-19.parquet size: 70 KB rows: 2,064
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 |
|---|---|---|---|---|---|---|---|
| 2022-05-19 00:00:00 | ES | Futures | 4455.68 | 4459.08 | 4450.86 | 4454.55 | 7936.0 |
| 2022-05-19 01:00:00 | ES | Futures | 4454.83 | 4458.23 | 4437.26 | 4441.51 | 14973.0 |
| 2022-05-19 02:00:00 | ES | Futures | 4441.79 | 4448.03 | 4436.69 | 4439.52 | 14556.0 |
| 2022-05-19 03:00:00 | ES | Futures | 4439.81 | 4440.66 | 4391.06 | 4412.03 | 52683.0 |
| 2022-05-19 04:00:00 | ES | Futures | 4412.03 | 4413.73 | 4383.12 | 4384.25 | 38889.0 |
| 2022-05-19 05:00:00 | ES | Futures | 4384.25 | 4389.92 | 4371.78 | 4376.88 | 36187.0 |
| 2022-05-19 06:00:00 | ES | Futures | 4377.17 | 4403.53 | 4374.62 | 4402.96 | 30020.0 |
| 2022-05-19 07:00:00 | ES | Futures | 4402.68 | 4419.97 | 4390.77 | 4413.73 | 45913.0 |
| 2022-05-19 08:00:00 | ES | Futures | 4413.73 | 4415.43 | 4390.21 | 4398.99 | 52807.0 |
| 2022-05-19 09:00:00 | ES | Futures | 4398.71 | 4444.91 | 4392.19 | 4409.48 | 279899.0 |
| 2022-05-19 10:00:00 | ES | Futures | 4408.91 | 4446.61 | 4400.41 | 4416.85 | 344674.0 |
| 2022-05-19 11:00:00 | ES | Futures | 4416.57 | 4462.48 | 4404.94 | 4446.04 | 249428.0 |
| 2022-05-19 12:00:00 | ES | Futures | 4446.33 | 4458.8 | 4411.46 | 4423.93 | 187384.0 |
| 2022-05-19 13:00:00 | ES | Futures | 4423.93 | 4450.01 | 4405.51 | 4444.34 | 207888.0 |
| 2022-05-19 14:00:00 | ES | Futures | 4444.06 | 4460.5 | 4424.5 | 4456.53 | 201279.0 |
| 2022-05-19 15:00:00 | ES | Futures | 4456.81 | 4470.99 | 4413.45 | 4418.27 | 344764.0 |
| 2022-05-19 16:00:00 | ES | Futures | 4417.98 | 4424.5 | 4410.05 | 4419.68 | 64690.0 |
| 2022-05-19 18:00:00 | ES | Futures | 4422.23 | 4429.89 | 4419.68 | 4424.79 | 6253.0 |
| 2022-05-19 19:00:00 | ES | Futures | 4424.79 | 4433.57 | 4420.82 | 4430.74 | 6887.0 |
| 2022-05-19 20:00:00 | ES | Futures | 4431.3 | 4445.19 | 4430.74 | 4437.82 | 13138.0 |
| 2022-05-19 21:00:00 | ES | Futures | 4437.82 | 4455.68 | 4436.41 | 4450.86 | 15480.0 |
| 2022-05-19 22:00:00 | ES | Futures | 4451.15 | 4453.13 | 4439.81 | 4452.28 | 9959.0 |
| 2022-05-19 23:00:00 | ES | Futures | 4452.28 | 4452.85 | 4444.34 | 4447.18 | 7603.0 |
| 2022-05-19 00:00:00 | NQ | Futures | 13847.47 | 13861.39 | 13821.66 | 13839.06 | 4173.0 |
| 2022-05-19 01:00:00 | NQ | Futures | 13840.22 | 13854.72 | 13779.61 | 13799.33 | 6340.0 |
| 2022-05-19 02:00:00 | NQ | Futures | 13799.04 | 13823.69 | 13781.06 | 13799.91 | 7620.0 |
| 2022-05-19 03:00:00 | NQ | Futures | 13800.2 | 13802.52 | 13624.48 | 13702.19 | 30784.0 |
| 2022-05-19 04:00:00 | NQ | Futures | 13703.64 | 13712.05 | 13612.01 | 13618.1 | 16245.0 |
| 2022-05-19 05:00:00 | NQ | Futures | 13618.1 | 13639.27 | 13575.47 | 13600.99 | 16150.0 |
| 2022-05-19 06:00:00 | NQ | Futures | 13602.73 | 13701.9 | 13595.19 | 13695.81 | 14390.0 |
| 2022-05-19 07:00:00 | NQ | Futures | 13693.78 | 13755.84 | 13654.34 | 13736.99 | 18024.0 |
| 2022-05-19 08:00:00 | NQ | Futures | 13736.12 | 13740.47 | 13656.08 | 13707.99 | 22590.0 |
| 2022-05-19 09:00:00 | NQ | Futures | 13707.41 | 13894.15 | 13681.31 | 13795.85 | 113174.0 |
| 2022-05-19 10:00:00 | NQ | Futures | 13794.69 | 13929.53 | 13766.86 | 13863.42 | 127707.0 |
| 2022-05-19 11:00:00 | NQ | Futures | 13862.84 | 14007.82 | 13806.0 | 13952.73 | 84730.0 |
| 2022-05-19 12:00:00 | NQ | Futures | 13953.02 | 13987.24 | 13789.76 | 13839.93 | 65018.0 |
| 2022-05-19 13:00:00 | NQ | Futures | 13839.64 | 13909.52 | 13745.69 | 13891.25 | 72825.0 |
| 2022-05-19 14:00:00 | NQ | Futures | 13889.8 | 13961.72 | 13808.61 | 13933.3 | 68837.0 |
| 2022-05-19 15:00:00 | NQ | Futures | 13933.3 | 13978.54 | 13754.68 | 13775.26 | 93132.0 |
| 2022-05-19 16:00:00 | NQ | Futures | 13775.26 | 13817.31 | 13743.37 | 13800.78 | 16672.0 |
| 2022-05-19 18:00:00 | NQ | Futures | 13800.49 | 13836.45 | 13798.75 | 13812.96 | 3100.0 |
| 2022-05-19 19:00:00 | NQ | Futures | 13814.99 | 13848.92 | 13797.01 | 13841.67 | 3173.0 |
| 2022-05-19 20:00:00 | NQ | Futures | 13843.7 | 13896.47 | 13842.54 | 13868.06 | 5558.0 |
| 2022-05-19 21:00:00 | NQ | Futures | 13867.48 | 13929.53 | 13862.55 | 13916.77 | 6397.0 |
| 2022-05-19 22:00:00 | NQ | Futures | 13916.48 | 13919.96 | 13872.41 | 13915.03 | 4488.0 |
| 2022-05-19 23:00:00 | NQ | Futures | 13913.58 | 13916.48 | 13886.9 | 13897.34 | 2757.0 |
| 2022-05-19 00:00:00 | YM | Futures | 35507.5 | 35529.0 | 35485.0 | 35509.8 | 904.0 |
| 2022-05-19 01:00:00 | YM | Futures | 35504.2 | 35527.8 | 35379.0 | 35411.7 | 2083.0 |
| 2022-05-19 02:00:00 | YM | Futures | 35404.9 | 35450.0 | 35365.5 | 35380.1 | 2123.0 |
| 2022-05-19 03:00:00 | YM | Futures | 35380.1 | 35395.9 | 35034.1 | 35196.4 | 8452.0 |
> showing 50 of 2,064 rows — these rows as CSV