PREVIEW / futures_1hour / 2022-10-27
file: by_date/futures_1hour/2022/2022-10-27.parquet size: 71 KB rows: 2,104
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-10-27 00:00:00 | ES | Futures | 4354.13 | 4356.95 | 4351.31 | 4355.54 | 6015.0 |
| 2022-10-27 01:00:00 | ES | Futures | 4355.54 | 4361.18 | 4349.05 | 4358.07 | 10445.0 |
| 2022-10-27 02:00:00 | ES | Futures | 4358.07 | 4360.05 | 4341.73 | 4343.13 | 16414.0 |
| 2022-10-27 03:00:00 | ES | Futures | 4343.13 | 4348.77 | 4336.65 | 4340.32 | 28295.0 |
| 2022-10-27 04:00:00 | ES | Futures | 4340.32 | 4352.44 | 4336.65 | 4342.85 | 19644.0 |
| 2022-10-27 05:00:00 | ES | Futures | 4343.13 | 4343.7 | 4331.01 | 4331.01 | 17630.0 |
| 2022-10-27 06:00:00 | ES | Futures | 4331.3 | 4336.09 | 4327.35 | 4328.19 | 20514.0 |
| 2022-10-27 07:00:00 | ES | Futures | 4327.91 | 4337.21 | 4323.68 | 4326.5 | 27913.0 |
| 2022-10-27 08:00:00 | ES | Futures | 4326.5 | 4355.54 | 4323.4 | 4347.36 | 106111.0 |
| 2022-10-27 09:00:00 | ES | Futures | 4347.08 | 4358.92 | 4313.54 | 4320.87 | 290500.0 |
| 2022-10-27 10:00:00 | ES | Futures | 4321.15 | 4364.56 | 4316.92 | 4332.42 | 314851.0 |
| 2022-10-27 11:00:00 | ES | Futures | 4332.42 | 4346.8 | 4317.48 | 4323.12 | 263518.0 |
| 2022-10-27 12:00:00 | ES | Futures | 4323.12 | 4334.96 | 4309.03 | 4325.09 | 178224.0 |
| 2022-10-27 13:00:00 | ES | Futures | 4325.09 | 4339.19 | 4315.79 | 4316.64 | 162963.0 |
| 2022-10-27 14:00:00 | ES | Futures | 4316.64 | 4319.46 | 4305.36 | 4308.74 | 130915.0 |
| 2022-10-27 15:00:00 | ES | Futures | 4308.74 | 4322.56 | 4300.0 | 4307.33 | 280940.0 |
| 2022-10-27 16:00:00 | ES | Futures | 4307.33 | 4311.28 | 4236.86 | 4275.2 | 198298.0 |
| 2022-10-27 18:00:00 | ES | Futures | 4282.81 | 4293.8 | 4278.58 | 4283.94 | 20911.0 |
| 2022-10-27 19:00:00 | ES | Futures | 4283.94 | 4287.6 | 4277.17 | 4279.43 | 9356.0 |
| 2022-10-27 20:00:00 | ES | Futures | 4279.43 | 4285.63 | 4274.35 | 4282.53 | 10885.0 |
| 2022-10-27 21:00:00 | ES | Futures | 4282.81 | 4299.44 | 4282.81 | 4296.62 | 15105.0 |
| 2022-10-27 22:00:00 | ES | Futures | 4296.62 | 4297.75 | 4287.04 | 4291.27 | 9697.0 |
| 2022-10-27 23:00:00 | ES | Futures | 4290.98 | 4293.8 | 4285.91 | 4289.57 | 6877.0 |
| 2022-10-27 00:00:00 | NQ | Futures | 13214.98 | 13223.31 | 13204.35 | 13219.29 | 3342.0 |
| 2022-10-27 01:00:00 | NQ | Futures | 13219.29 | 13236.82 | 13195.44 | 13229.06 | 4496.0 |
| 2022-10-27 02:00:00 | NQ | Futures | 13228.48 | 13234.52 | 13165.85 | 13170.44 | 8532.0 |
| 2022-10-27 03:00:00 | NQ | Futures | 13170.16 | 13190.84 | 13140.85 | 13152.92 | 15690.0 |
| 2022-10-27 04:00:00 | NQ | Futures | 13152.34 | 13180.5 | 13134.53 | 13146.88 | 11129.0 |
| 2022-10-27 05:00:00 | NQ | Futures | 13147.46 | 13150.33 | 13092.58 | 13092.87 | 11102.0 |
| 2022-10-27 06:00:00 | NQ | Futures | 13094.02 | 13112.4 | 13062.7 | 13070.17 | 10585.0 |
| 2022-10-27 07:00:00 | NQ | Futures | 13069.59 | 13110.68 | 13064.71 | 13074.76 | 13214.0 |
| 2022-10-27 08:00:00 | NQ | Futures | 13075.34 | 13170.44 | 13051.2 | 13144.58 | 53278.0 |
| 2022-10-27 09:00:00 | NQ | Futures | 13144.58 | 13175.62 | 12945.47 | 12977.65 | 107626.0 |
| 2022-10-27 10:00:00 | NQ | Futures | 12977.94 | 13162.97 | 12958.97 | 13010.4 | 112093.0 |
| 2022-10-27 11:00:00 | NQ | Futures | 13010.69 | 13079.36 | 12969.03 | 12976.21 | 73104.0 |
| 2022-10-27 12:00:00 | NQ | Futures | 12977.07 | 13021.32 | 12926.79 | 12974.2 | 57664.0 |
| 2022-10-27 13:00:00 | NQ | Futures | 12974.49 | 13030.23 | 12942.59 | 12945.18 | 48468.0 |
| 2022-10-27 14:00:00 | NQ | Futures | 12945.47 | 12956.96 | 12906.39 | 12921.91 | 41074.0 |
| 2022-10-27 15:00:00 | NQ | Futures | 12922.19 | 12969.03 | 12895.47 | 12918.17 | 64885.0 |
| 2022-10-27 16:00:00 | NQ | Futures | 12918.17 | 12930.81 | 12552.12 | 12752.1 | 85370.0 |
| 2022-10-27 18:00:00 | NQ | Futures | 12783.42 | 12860.42 | 12783.42 | 12819.62 | 13735.0 |
| 2022-10-27 19:00:00 | NQ | Futures | 12819.91 | 12827.95 | 12788.59 | 12797.5 | 5392.0 |
| 2022-10-27 20:00:00 | NQ | Futures | 12798.93 | 12823.07 | 12783.99 | 12808.41 | 6174.0 |
| 2022-10-27 21:00:00 | NQ | Futures | 12808.99 | 12859.56 | 12808.99 | 12850.08 | 8158.0 |
| 2022-10-27 22:00:00 | NQ | Futures | 12849.5 | 12856.11 | 12813.01 | 12833.12 | 4838.0 |
| 2022-10-27 23:00:00 | NQ | Futures | 12833.12 | 12840.88 | 12810.71 | 12826.23 | 4578.0 |
| 2022-10-27 00:00:00 | YM | Futures | 35973.2 | 35990.0 | 35953.0 | 35983.3 | 875.0 |
| 2022-10-27 01:00:00 | YM | Futures | 35982.2 | 36017.0 | 35940.7 | 35996.8 | 1635.0 |
| 2022-10-27 02:00:00 | YM | Futures | 35996.8 | 36011.4 | 35886.8 | 35899.1 | 2533.0 |
| 2022-10-27 03:00:00 | YM | Futures | 35898.0 | 35940.7 | 35857.6 | 35886.8 | 3398.0 |
> showing 50 of 2,104 rows — these rows as CSV