PREVIEW / futures_1hour / 2022-09-14
file: by_date/futures_1hour/2022/2022-09-14.parquet size: 65 KB rows: 2,005
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-09-14 00:00:00 | ES | Futures | 4462.38 | 4466.32 | 4460.12 | 4464.07 | 5314.0 |
| 2022-09-14 01:00:00 | ES | Futures | 4464.63 | 4467.45 | 4453.64 | 4454.48 | 9975.0 |
| 2022-09-14 02:00:00 | ES | Futures | 4454.2 | 4468.3 | 4450.25 | 4464.07 | 20198.0 |
| 2022-09-14 03:00:00 | ES | Futures | 4464.35 | 4477.88 | 4457.02 | 4471.68 | 31671.0 |
| 2022-09-14 04:00:00 | ES | Futures | 4471.96 | 4487.18 | 4469.99 | 4482.11 | 31302.0 |
| 2022-09-14 05:00:00 | ES | Futures | 4482.11 | 4483.8 | 4471.4 | 4474.78 | 20230.0 |
| 2022-09-14 06:00:00 | ES | Futures | 4474.78 | 4480.42 | 4468.86 | 4472.81 | 14354.0 |
| 2022-09-14 07:00:00 | ES | Futures | 4473.09 | 4473.65 | 4445.74 | 4446.59 | 37347.0 |
| 2022-09-14 08:00:00 | ES | Futures | 4446.59 | 4470.55 | 4445.46 | 4466.6 | 82202.0 |
| 2022-09-14 09:00:00 | ES | Futures | 4466.6 | 4482.67 | 4453.07 | 4476.75 | 287309.0 |
| 2022-09-14 10:00:00 | ES | Futures | 4476.75 | 4483.52 | 4438.7 | 4480.98 | 403477.0 |
| 2022-09-14 11:00:00 | ES | Futures | 4480.7 | 4489.16 | 4467.17 | 4471.4 | 224020.0 |
| 2022-09-14 12:00:00 | ES | Futures | 4471.68 | 4483.24 | 4464.35 | 4478.16 | 150699.0 |
| 2022-09-14 13:00:00 | ES | Futures | 4478.16 | 4483.24 | 4449.41 | 4453.64 | 170401.0 |
| 2022-09-14 14:00:00 | ES | Futures | 4453.64 | 4461.81 | 4444.33 | 4447.72 | 192837.0 |
| 2022-09-14 15:00:00 | ES | Futures | 4448.0 | 4474.22 | 4430.24 | 4469.99 | 380027.0 |
| 2022-09-14 16:00:00 | ES | Futures | 4470.27 | 4482.39 | 4467.45 | 4480.7 | 66286.0 |
| 2022-09-14 18:00:00 | ES | Futures | 4478.73 | 4484.36 | 4475.62 | 4481.54 | 6595.0 |
| 2022-09-14 19:00:00 | ES | Futures | 4481.54 | 4481.83 | 4474.78 | 4477.32 | 5799.0 |
| 2022-09-14 20:00:00 | ES | Futures | 4477.6 | 4478.16 | 4472.24 | 4477.03 | 7000.0 |
| 2022-09-14 21:00:00 | ES | Futures | 4477.03 | 4483.8 | 4469.42 | 4483.8 | 10602.0 |
| 2022-09-14 22:00:00 | ES | Futures | 4483.52 | 4484.36 | 4476.75 | 4478.73 | 6665.0 |
| 2022-09-14 23:00:00 | ES | Futures | 4479.01 | 4481.26 | 4474.22 | 4475.06 | 5215.0 |
| 2022-09-14 00:00:00 | NQ | Futures | 13943.93 | 13959.44 | 13935.31 | 13951.97 | 2786.0 |
| 2022-09-14 01:00:00 | NQ | Futures | 13953.12 | 13966.62 | 13910.31 | 13912.89 | 4943.0 |
| 2022-09-14 02:00:00 | NQ | Futures | 13912.03 | 13969.21 | 13903.13 | 13953.41 | 7187.0 |
| 2022-09-14 03:00:00 | NQ | Futures | 13953.69 | 14005.99 | 13924.96 | 13977.83 | 14349.0 |
| 2022-09-14 04:00:00 | NQ | Futures | 13978.12 | 14044.2 | 13972.37 | 14019.2 | 14130.0 |
| 2022-09-14 05:00:00 | NQ | Futures | 14018.63 | 14027.82 | 13982.14 | 13996.79 | 7554.0 |
| 2022-09-14 06:00:00 | NQ | Futures | 13995.64 | 14017.48 | 13974.67 | 13989.04 | 6812.0 |
| 2022-09-14 07:00:00 | NQ | Futures | 13989.61 | 13991.91 | 13883.87 | 13892.78 | 15532.0 |
| 2022-09-14 08:00:00 | NQ | Futures | 13892.49 | 13996.51 | 13888.18 | 13977.83 | 31058.0 |
| 2022-09-14 09:00:00 | NQ | Futures | 13978.12 | 14037.59 | 13905.14 | 14014.32 | 88013.0 |
| 2022-09-14 10:00:00 | NQ | Futures | 14013.75 | 14052.53 | 13899.1 | 14039.03 | 103804.0 |
| 2022-09-14 11:00:00 | NQ | Futures | 14038.46 | 14082.42 | 14003.69 | 14032.71 | 63634.0 |
| 2022-09-14 12:00:00 | NQ | Futures | 14033.28 | 14074.37 | 13997.94 | 14052.53 | 44867.0 |
| 2022-09-14 13:00:00 | NQ | Futures | 14052.82 | 14075.81 | 13947.66 | 13962.89 | 50163.0 |
| 2022-09-14 14:00:00 | NQ | Futures | 13962.89 | 13997.66 | 13927.26 | 13949.67 | 55042.0 |
| 2022-09-14 15:00:00 | NQ | Futures | 13950.25 | 14055.12 | 13898.24 | 14041.62 | 82166.0 |
| 2022-09-14 16:00:00 | NQ | Futures | 14042.19 | 14080.98 | 14035.58 | 14078.97 | 17705.0 |
| 2022-09-14 18:00:00 | NQ | Futures | 14060.58 | 14100.52 | 14060.58 | 14090.46 | 3515.0 |
| 2022-09-14 19:00:00 | NQ | Futures | 14089.89 | 14090.75 | 14065.46 | 14076.67 | 2712.0 |
| 2022-09-14 20:00:00 | NQ | Futures | 14076.1 | 14076.96 | 14050.81 | 14066.61 | 3492.0 |
| 2022-09-14 21:00:00 | NQ | Futures | 14066.9 | 14088.45 | 14035.29 | 14088.16 | 5399.0 |
| 2022-09-14 22:00:00 | NQ | Futures | 14086.73 | 14091.04 | 14056.56 | 14063.45 | 3135.0 |
| 2022-09-14 23:00:00 | NQ | Futures | 14064.6 | 14072.07 | 14051.1 | 14054.83 | 2275.0 |
| 2022-09-14 00:00:00 | YM | Futures | 35095.6 | 35120.3 | 35079.9 | 35106.8 | 592.0 |
| 2022-09-14 01:00:00 | YM | Futures | 35103.5 | 35119.2 | 35026.0 | 35029.4 | 1063.0 |
| 2022-09-14 02:00:00 | YM | Futures | 35027.2 | 35122.5 | 35002.5 | 35094.5 | 2185.0 |
| 2022-09-14 03:00:00 | YM | Futures | 35092.2 | 35184.3 | 35035.0 | 35131.5 | 4038.0 |
> showing 50 of 2,005 rows — these rows as CSV