PREVIEW / futures_1hour / 2021-04-07
file: by_date/futures_1hour/2021/2021-04-07.parquet size: 61 KB rows: 1,907
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-07 00:00:00 | ES | Futures | 4568.56 | 4569.69 | 4568.28 | 4568.56 | 2351.0 |
| 2021-04-07 01:00:00 | ES | Futures | 4568.84 | 4569.69 | 4567.16 | 4569.4 | 4412.0 |
| 2021-04-07 02:00:00 | ES | Futures | 4569.69 | 4572.21 | 4568.28 | 4569.97 | 6845.0 |
| 2021-04-07 03:00:00 | ES | Futures | 4569.97 | 4574.18 | 4569.12 | 4572.78 | 15098.0 |
| 2021-04-07 04:00:00 | ES | Futures | 4572.78 | 4573.34 | 4569.69 | 4570.25 | 9267.0 |
| 2021-04-07 05:00:00 | ES | Futures | 4570.53 | 4572.21 | 4564.63 | 4567.44 | 13027.0 |
| 2021-04-07 06:00:00 | ES | Futures | 4567.72 | 4571.93 | 4567.44 | 4569.12 | 7469.0 |
| 2021-04-07 07:00:00 | ES | Futures | 4569.12 | 4570.25 | 4566.31 | 4566.88 | 10588.0 |
| 2021-04-07 08:00:00 | ES | Futures | 4566.88 | 4568.84 | 4559.01 | 4559.29 | 28403.0 |
| 2021-04-07 09:00:00 | ES | Futures | 4559.29 | 4573.9 | 4559.29 | 4570.25 | 129850.0 |
| 2021-04-07 10:00:00 | ES | Futures | 4570.25 | 4578.11 | 4567.72 | 4574.74 | 124429.0 |
| 2021-04-07 11:00:00 | ES | Futures | 4574.74 | 4577.83 | 4562.94 | 4568.0 | 141191.0 |
| 2021-04-07 12:00:00 | ES | Futures | 4567.72 | 4570.81 | 4560.98 | 4568.0 | 143366.0 |
| 2021-04-07 13:00:00 | ES | Futures | 4567.72 | 4573.62 | 4565.75 | 4571.65 | 69124.0 |
| 2021-04-07 14:00:00 | ES | Futures | 4571.93 | 4577.55 | 4571.09 | 4571.93 | 93966.0 |
| 2021-04-07 15:00:00 | ES | Futures | 4571.93 | 4575.87 | 4564.63 | 4573.62 | 188569.0 |
| 2021-04-07 16:00:00 | ES | Futures | 4573.62 | 4580.36 | 4573.34 | 4580.08 | 42656.0 |
| 2021-04-07 18:00:00 | ES | Futures | 4578.96 | 4580.64 | 4577.83 | 4578.4 | 3890.0 |
| 2021-04-07 19:00:00 | ES | Futures | 4578.4 | 4588.79 | 4576.99 | 4585.42 | 10988.0 |
| 2021-04-07 20:00:00 | ES | Futures | 4585.42 | 4585.7 | 4582.05 | 4583.73 | 10203.0 |
| 2021-04-07 21:00:00 | ES | Futures | 4583.73 | 4591.88 | 4582.05 | 4588.51 | 11703.0 |
| 2021-04-07 22:00:00 | ES | Futures | 4588.23 | 4593.01 | 4587.39 | 4592.16 | 8362.0 |
| 2021-04-07 23:00:00 | ES | Futures | 4592.44 | 4595.53 | 4591.6 | 4594.13 | 6832.0 |
| 2021-04-07 00:00:00 | NQ | Futures | 15703.96 | 15707.72 | 15700.49 | 15702.51 | 944.0 |
| 2021-04-07 01:00:00 | NQ | Futures | 15702.22 | 15713.51 | 15694.7 | 15711.78 | 1975.0 |
| 2021-04-07 02:00:00 | NQ | Futures | 15711.78 | 15745.94 | 15711.49 | 15742.75 | 4080.0 |
| 2021-04-07 03:00:00 | NQ | Futures | 15744.2 | 15757.52 | 15728.86 | 15747.1 | 8327.0 |
| 2021-04-07 04:00:00 | NQ | Futures | 15747.39 | 15748.25 | 15719.88 | 15722.2 | 4457.0 |
| 2021-04-07 05:00:00 | NQ | Futures | 15722.2 | 15736.1 | 15699.91 | 15718.44 | 5348.0 |
| 2021-04-07 06:00:00 | NQ | Futures | 15718.73 | 15743.62 | 15714.96 | 15719.3 | 3953.0 |
| 2021-04-07 07:00:00 | NQ | Futures | 15719.01 | 15726.54 | 15702.22 | 15705.12 | 5928.0 |
| 2021-04-07 08:00:00 | NQ | Futures | 15705.7 | 15715.25 | 15667.77 | 15668.64 | 13910.0 |
| 2021-04-07 09:00:00 | NQ | Futures | 15668.64 | 15730.59 | 15647.22 | 15720.75 | 63338.0 |
| 2021-04-07 10:00:00 | NQ | Futures | 15720.46 | 15772.28 | 15709.46 | 15750.28 | 58687.0 |
| 2021-04-07 11:00:00 | NQ | Futures | 15750.28 | 15784.44 | 15706.28 | 15747.39 | 59794.0 |
| 2021-04-07 12:00:00 | NQ | Futures | 15747.1 | 15760.12 | 15703.09 | 15719.88 | 44220.0 |
| 2021-04-07 13:00:00 | NQ | Futures | 15719.59 | 15750.28 | 15707.44 | 15744.2 | 28817.0 |
| 2021-04-07 14:00:00 | NQ | Futures | 15744.49 | 15796.02 | 15741.6 | 15767.94 | 38566.0 |
| 2021-04-07 15:00:00 | NQ | Futures | 15768.23 | 15789.36 | 15717.57 | 15753.75 | 57664.0 |
| 2021-04-07 16:00:00 | NQ | Futures | 15754.04 | 15776.33 | 15752.31 | 15772.86 | 7969.0 |
| 2021-04-07 18:00:00 | NQ | Futures | 15772.57 | 15782.41 | 15769.68 | 15776.62 | 1728.0 |
| 2021-04-07 19:00:00 | NQ | Futures | 15776.62 | 15810.5 | 15766.49 | 15793.13 | 4219.0 |
| 2021-04-07 20:00:00 | NQ | Futures | 15793.42 | 15804.99 | 15781.84 | 15795.73 | 3948.0 |
| 2021-04-07 21:00:00 | NQ | Futures | 15796.31 | 15833.66 | 15790.52 | 15823.52 | 5339.0 |
| 2021-04-07 22:00:00 | NQ | Futures | 15822.65 | 15855.37 | 15819.18 | 15853.63 | 4868.0 |
| 2021-04-07 23:00:00 | NQ | Futures | 15853.34 | 15873.32 | 15851.6 | 15864.63 | 3925.0 |
| 2021-04-07 00:00:00 | YM | Futures | 37145.8 | 37152.5 | 37141.4 | 37144.7 | 450.0 |
| 2021-04-07 01:00:00 | YM | Futures | 37144.7 | 37147.0 | 37128.0 | 37143.6 | 759.0 |
| 2021-04-07 02:00:00 | YM | Futures | 37143.6 | 37159.2 | 37118.0 | 37123.6 | 1669.0 |
| 2021-04-07 03:00:00 | YM | Futures | 37122.5 | 37155.9 | 37111.3 | 37141.4 | 2773.0 |
> showing 50 of 1,907 rows — these rows as CSV