PREVIEW / futures_1hour / 2021-04-06
file: by_date/futures_1hour/2021/2021-04-06.parquet size: 62 KB rows: 1,900
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 |
|---|---|---|---|---|---|---|---|
| 2021-04-06 00:00:00 | ES | Futures | 4562.94 | 4564.91 | 4561.54 | 4562.38 | 4705.0 |
| 2021-04-06 01:00:00 | ES | Futures | 4562.66 | 4564.91 | 4560.98 | 4564.35 | 6079.0 |
| 2021-04-06 02:00:00 | ES | Futures | 4564.35 | 4566.88 | 4561.26 | 4564.63 | 11526.0 |
| 2021-04-06 03:00:00 | ES | Futures | 4564.91 | 4566.31 | 4554.23 | 4561.26 | 27716.0 |
| 2021-04-06 04:00:00 | ES | Futures | 4561.54 | 4567.72 | 4555.64 | 4563.22 | 20225.0 |
| 2021-04-06 05:00:00 | ES | Futures | 4563.22 | 4564.35 | 4560.13 | 4561.82 | 14428.0 |
| 2021-04-06 06:00:00 | ES | Futures | 4561.82 | 4564.63 | 4558.73 | 4560.69 | 9564.0 |
| 2021-04-06 07:00:00 | ES | Futures | 4560.69 | 4566.03 | 4560.69 | 4565.75 | 12724.0 |
| 2021-04-06 08:00:00 | ES | Futures | 4565.75 | 4570.25 | 4560.13 | 4563.5 | 33688.0 |
| 2021-04-06 09:00:00 | ES | Futures | 4563.78 | 4577.27 | 4561.54 | 4575.87 | 189666.0 |
| 2021-04-06 10:00:00 | ES | Futures | 4575.87 | 4580.64 | 4573.34 | 4576.43 | 200992.0 |
| 2021-04-06 11:00:00 | ES | Futures | 4576.43 | 4580.92 | 4573.06 | 4580.36 | 105271.0 |
| 2021-04-06 12:00:00 | ES | Futures | 4580.64 | 4580.92 | 4574.46 | 4576.43 | 77744.0 |
| 2021-04-06 13:00:00 | ES | Futures | 4576.43 | 4576.71 | 4565.75 | 4574.46 | 106195.0 |
| 2021-04-06 14:00:00 | ES | Futures | 4574.18 | 4576.71 | 4570.53 | 4573.9 | 92966.0 |
| 2021-04-06 15:00:00 | ES | Futures | 4573.9 | 4575.3 | 4560.98 | 4568.0 | 230070.0 |
| 2021-04-06 16:00:00 | ES | Futures | 4568.28 | 4570.53 | 4566.31 | 4570.25 | 43322.0 |
| 2021-04-06 18:00:00 | ES | Futures | 4570.81 | 4574.46 | 4568.56 | 4572.49 | 4652.0 |
| 2021-04-06 19:00:00 | ES | Futures | 4572.78 | 4575.87 | 4571.65 | 4575.3 | 3656.0 |
| 2021-04-06 20:00:00 | ES | Futures | 4575.3 | 4575.59 | 4570.25 | 4573.06 | 7986.0 |
| 2021-04-06 21:00:00 | ES | Futures | 4573.06 | 4573.34 | 4565.75 | 4566.59 | 11255.0 |
| 2021-04-06 22:00:00 | ES | Futures | 4566.59 | 4569.97 | 4564.91 | 4565.75 | 8377.0 |
| 2021-04-06 23:00:00 | ES | Futures | 4565.75 | 4569.69 | 4565.47 | 4568.56 | 4441.0 |
| 2021-04-06 00:00:00 | NQ | Futures | 15719.3 | 15732.62 | 15715.83 | 15723.36 | 2099.0 |
| 2021-04-06 01:00:00 | NQ | Futures | 15723.65 | 15733.2 | 15714.96 | 15730.02 | 2607.0 |
| 2021-04-06 02:00:00 | NQ | Futures | 15729.44 | 15743.91 | 15703.09 | 15713.22 | 6344.0 |
| 2021-04-06 03:00:00 | NQ | Futures | 15712.94 | 15713.8 | 15660.83 | 15678.49 | 12261.0 |
| 2021-04-06 04:00:00 | NQ | Futures | 15679.06 | 15711.78 | 15661.69 | 15693.25 | 7288.0 |
| 2021-04-06 05:00:00 | NQ | Futures | 15691.8 | 15699.91 | 15679.35 | 15692.09 | 4939.0 |
| 2021-04-06 06:00:00 | NQ | Futures | 15692.09 | 15703.38 | 15673.27 | 15687.17 | 4639.0 |
| 2021-04-06 07:00:00 | NQ | Futures | 15688.04 | 15721.91 | 15679.35 | 15719.88 | 6037.0 |
| 2021-04-06 08:00:00 | NQ | Futures | 15719.01 | 15755.2 | 15716.99 | 15732.91 | 14487.0 |
| 2021-04-06 09:00:00 | NQ | Futures | 15732.91 | 15745.94 | 15677.62 | 15744.78 | 62954.0 |
| 2021-04-06 10:00:00 | NQ | Futures | 15744.78 | 15770.26 | 15706.57 | 15756.07 | 75178.0 |
| 2021-04-06 11:00:00 | NQ | Futures | 15755.78 | 15812.23 | 15740.73 | 15807.89 | 52432.0 |
| 2021-04-06 12:00:00 | NQ | Futures | 15807.89 | 15809.63 | 15761.28 | 15766.49 | 33646.0 |
| 2021-04-06 13:00:00 | NQ | Futures | 15766.2 | 15769.97 | 15686.01 | 15740.44 | 48181.0 |
| 2021-04-06 14:00:00 | NQ | Futures | 15740.44 | 15768.23 | 15730.59 | 15755.49 | 34255.0 |
| 2021-04-06 15:00:00 | NQ | Futures | 15755.2 | 15762.73 | 15685.14 | 15715.54 | 56487.0 |
| 2021-04-06 16:00:00 | NQ | Futures | 15716.12 | 15730.59 | 15714.09 | 15729.15 | 6959.0 |
| 2021-04-06 18:00:00 | NQ | Futures | 15725.96 | 15744.2 | 15720.17 | 15737.25 | 2048.0 |
| 2021-04-06 19:00:00 | NQ | Futures | 15737.54 | 15746.23 | 15736.96 | 15742.46 | 1521.0 |
| 2021-04-06 20:00:00 | NQ | Futures | 15741.6 | 15745.94 | 15723.36 | 15737.83 | 4900.0 |
| 2021-04-06 21:00:00 | NQ | Futures | 15737.83 | 15741.31 | 15694.99 | 15699.04 | 5172.0 |
| 2021-04-06 22:00:00 | NQ | Futures | 15698.75 | 15716.12 | 15688.91 | 15693.54 | 3641.0 |
| 2021-04-06 23:00:00 | NQ | Futures | 15694.12 | 15705.99 | 15690.35 | 15703.67 | 2463.0 |
| 2021-04-06 00:00:00 | YM | Futures | 37126.9 | 37141.4 | 37115.8 | 37123.6 | 954.0 |
| 2021-04-06 01:00:00 | YM | Futures | 37124.7 | 37152.5 | 37113.5 | 37145.8 | 1462.0 |
| 2021-04-06 02:00:00 | YM | Futures | 37142.5 | 37181.5 | 37123.6 | 37168.1 | 2793.0 |
| 2021-04-06 03:00:00 | YM | Futures | 37165.9 | 37202.6 | 37083.5 | 37178.1 | 6569.0 |
> showing 50 of 1,900 rows — these rows as CSV