PREVIEW / futures_1hour / 2022-09-26
file: by_date/futures_1hour/2022/2022-09-26.parquet size: 72 KB rows: 2,113
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-26 00:00:00 | ES | Futures | 4159.34 | 4163.0 | 4150.32 | 4151.73 | 8833.0 |
| 2022-09-26 01:00:00 | ES | Futures | 4151.45 | 4155.11 | 4142.99 | 4145.81 | 14645.0 |
| 2022-09-26 02:00:00 | ES | Futures | 4145.53 | 4154.55 | 4141.02 | 4146.65 | 20436.0 |
| 2022-09-26 03:00:00 | ES | Futures | 4146.65 | 4192.6 | 4144.68 | 4170.62 | 60172.0 |
| 2022-09-26 04:00:00 | ES | Futures | 4170.9 | 4184.15 | 4164.7 | 4175.13 | 33518.0 |
| 2022-09-26 05:00:00 | ES | Futures | 4175.13 | 4178.23 | 4139.89 | 4145.81 | 33587.0 |
| 2022-09-26 06:00:00 | ES | Futures | 4146.09 | 4159.34 | 4140.17 | 4150.6 | 27318.0 |
| 2022-09-26 07:00:00 | ES | Futures | 4150.6 | 4158.78 | 4144.68 | 4155.96 | 33311.0 |
| 2022-09-26 08:00:00 | ES | Futures | 4155.96 | 4174.84 | 4146.37 | 4172.87 | 73414.0 |
| 2022-09-26 09:00:00 | ES | Futures | 4172.87 | 4188.38 | 4159.06 | 4186.12 | 293905.0 |
| 2022-09-26 10:00:00 | ES | Futures | 4186.12 | 4206.42 | 4174.0 | 4186.4 | 398817.0 |
| 2022-09-26 11:00:00 | ES | Futures | 4186.4 | 4190.63 | 4150.6 | 4167.8 | 337533.0 |
| 2022-09-26 12:00:00 | ES | Futures | 4167.8 | 4168.36 | 4134.25 | 4153.42 | 270177.0 |
| 2022-09-26 13:00:00 | ES | Futures | 4153.42 | 4153.7 | 4124.1 | 4127.77 | 262559.0 |
| 2022-09-26 14:00:00 | ES | Futures | 4127.77 | 4157.93 | 4126.08 | 4152.86 | 282016.0 |
| 2022-09-26 15:00:00 | ES | Futures | 4152.86 | 4168.64 | 4135.1 | 4139.33 | 475771.0 |
| 2022-09-26 16:00:00 | ES | Futures | 4139.33 | 4144.68 | 4129.18 | 4135.1 | 84728.0 |
| 2022-09-26 18:00:00 | ES | Futures | 4135.94 | 4141.58 | 4131.15 | 4141.02 | 9042.0 |
| 2022-09-26 19:00:00 | ES | Futures | 4141.3 | 4151.73 | 4140.74 | 4148.63 | 9054.0 |
| 2022-09-26 20:00:00 | ES | Futures | 4148.91 | 4169.49 | 4148.35 | 4166.67 | 20997.0 |
| 2022-09-26 21:00:00 | ES | Futures | 4166.39 | 4172.03 | 4162.16 | 4164.7 | 16103.0 |
| 2022-09-26 22:00:00 | ES | Futures | 4164.98 | 4170.62 | 4161.6 | 4165.26 | 11980.0 |
| 2022-09-26 23:00:00 | ES | Futures | 4165.26 | 4169.21 | 4157.65 | 4166.11 | 9156.0 |
| 2022-09-26 00:00:00 | NQ | Futures | 13011.27 | 13020.46 | 12976.79 | 12982.25 | 5144.0 |
| 2022-09-26 01:00:00 | NQ | Futures | 12981.38 | 12996.04 | 12945.47 | 12954.95 | 8992.0 |
| 2022-09-26 02:00:00 | NQ | Futures | 12955.52 | 12984.26 | 12937.14 | 12962.13 | 10710.0 |
| 2022-09-26 03:00:00 | NQ | Futures | 12961.56 | 13127.06 | 12954.95 | 13044.6 | 29092.0 |
| 2022-09-26 04:00:00 | NQ | Futures | 13046.03 | 13112.69 | 13036.26 | 13079.65 | 17529.0 |
| 2022-09-26 05:00:00 | NQ | Futures | 13080.51 | 13091.43 | 12962.99 | 12992.88 | 16341.0 |
| 2022-09-26 06:00:00 | NQ | Futures | 12994.03 | 13033.1 | 12975.64 | 13000.35 | 12442.0 |
| 2022-09-26 07:00:00 | NQ | Futures | 13000.06 | 13018.74 | 12970.75 | 13006.38 | 12638.0 |
| 2022-09-26 08:00:00 | NQ | Futures | 13006.67 | 13084.82 | 12977.94 | 13083.96 | 24548.0 |
| 2022-09-26 09:00:00 | NQ | Futures | 13083.38 | 13212.97 | 13035.4 | 13206.93 | 95560.0 |
| 2022-09-26 10:00:00 | NQ | Futures | 13207.22 | 13260.38 | 13142.86 | 13169.29 | 105080.0 |
| 2022-09-26 11:00:00 | NQ | Futures | 13169.58 | 13185.39 | 13050.92 | 13118.44 | 80428.0 |
| 2022-09-26 12:00:00 | NQ | Futures | 13118.73 | 13119.87 | 12998.34 | 13070.45 | 64894.0 |
| 2022-09-26 13:00:00 | NQ | Futures | 13070.74 | 13074.48 | 12979.09 | 12985.12 | 70091.0 |
| 2022-09-26 14:00:00 | NQ | Futures | 12985.41 | 13100.62 | 12980.23 | 13082.24 | 69473.0 |
| 2022-09-26 15:00:00 | NQ | Futures | 13082.52 | 13110.11 | 12998.05 | 13008.39 | 97927.0 |
| 2022-09-26 16:00:00 | NQ | Futures | 13008.39 | 13028.79 | 12976.5 | 13004.94 | 21647.0 |
| 2022-09-26 18:00:00 | NQ | Futures | 13004.94 | 13017.87 | 12985.12 | 13015.0 | 4554.0 |
| 2022-09-26 19:00:00 | NQ | Futures | 13014.43 | 13052.35 | 13014.43 | 13043.45 | 5056.0 |
| 2022-09-26 20:00:00 | NQ | Futures | 13044.31 | 13122.46 | 13041.43 | 13112.69 | 10966.0 |
| 2022-09-26 21:00:00 | NQ | Futures | 13111.54 | 13127.92 | 13092.87 | 13095.74 | 8464.0 |
| 2022-09-26 22:00:00 | NQ | Futures | 13096.6 | 13119.01 | 13083.38 | 13101.49 | 5435.0 |
| 2022-09-26 23:00:00 | NQ | Futures | 13101.2 | 13115.28 | 13072.75 | 13103.5 | 4931.0 |
| 2022-09-26 00:00:00 | YM | Futures | 33135.1 | 33163.1 | 33079.0 | 33087.9 | 1211.0 |
| 2022-09-26 01:00:00 | YM | Futures | 33087.9 | 33113.7 | 33032.9 | 33056.5 | 1598.0 |
| 2022-09-26 02:00:00 | YM | Futures | 33057.6 | 33122.7 | 33028.5 | 33063.2 | 3194.0 |
| 2022-09-26 03:00:00 | YM | Futures | 33062.1 | 33370.7 | 33047.5 | 33220.4 | 8555.0 |
> showing 50 of 2,113 rows — these rows as CSV