PREVIEW / futures_1hour / 2021-04-29
file: by_date/futures_1hour/2021/2021-04-29.parquet size: 62 KB rows: 1,918
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-29 00:00:00 | ES | Futures | 4718.88 | 4722.25 | 4718.6 | 4718.6 | 3264.0 |
| 2021-04-29 01:00:00 | ES | Futures | 4718.88 | 4721.13 | 4718.04 | 4720.0 | 4278.0 |
| 2021-04-29 02:00:00 | ES | Futures | 4720.0 | 4721.69 | 4718.04 | 4721.69 | 6305.0 |
| 2021-04-29 03:00:00 | ES | Futures | 4721.69 | 4723.38 | 4718.88 | 4722.53 | 16812.0 |
| 2021-04-29 04:00:00 | ES | Futures | 4722.53 | 4728.15 | 4722.53 | 4724.22 | 15292.0 |
| 2021-04-29 05:00:00 | ES | Futures | 4724.22 | 4725.34 | 4722.25 | 4724.22 | 9476.0 |
| 2021-04-29 06:00:00 | ES | Futures | 4724.22 | 4728.99 | 4723.66 | 4725.62 | 13295.0 |
| 2021-04-29 07:00:00 | ES | Futures | 4725.62 | 4728.15 | 4723.94 | 4724.5 | 17510.0 |
| 2021-04-29 08:00:00 | ES | Futures | 4724.78 | 4729.84 | 4723.66 | 4729.28 | 26611.0 |
| 2021-04-29 09:00:00 | ES | Futures | 4729.28 | 4732.65 | 4718.6 | 4719.44 | 236337.0 |
| 2021-04-29 10:00:00 | ES | Futures | 4719.72 | 4719.72 | 4696.68 | 4704.55 | 338059.0 |
| 2021-04-29 11:00:00 | ES | Futures | 4704.83 | 4711.57 | 4695.0 | 4696.68 | 179723.0 |
| 2021-04-29 12:00:00 | ES | Futures | 4696.68 | 4704.83 | 4684.32 | 4703.15 | 228211.0 |
| 2021-04-29 13:00:00 | ES | Futures | 4703.15 | 4711.29 | 4699.49 | 4709.05 | 128557.0 |
| 2021-04-29 14:00:00 | ES | Futures | 4709.05 | 4730.4 | 4708.2 | 4724.78 | 177409.0 |
| 2021-04-29 15:00:00 | ES | Futures | 4724.78 | 4729.84 | 4718.88 | 4724.5 | 225463.0 |
| 2021-04-29 16:00:00 | ES | Futures | 4724.5 | 4726.19 | 4719.16 | 4720.28 | 51069.0 |
| 2021-04-29 18:00:00 | ES | Futures | 4721.13 | 4721.97 | 4717.47 | 4718.88 | 5711.0 |
| 2021-04-29 19:00:00 | ES | Futures | 4718.88 | 4720.85 | 4713.54 | 4716.91 | 7183.0 |
| 2021-04-29 20:00:00 | ES | Futures | 4716.91 | 4718.6 | 4713.26 | 4715.51 | 9118.0 |
| 2021-04-29 21:00:00 | ES | Futures | 4715.51 | 4716.07 | 4712.14 | 4713.26 | 7548.0 |
| 2021-04-29 22:00:00 | ES | Futures | 4712.98 | 4712.98 | 4708.48 | 4710.17 | 8585.0 |
| 2021-04-29 23:00:00 | ES | Futures | 4710.17 | 4711.57 | 4707.64 | 4711.29 | 5400.0 |
| 2021-04-29 00:00:00 | NQ | Futures | 16231.71 | 16239.82 | 16229.97 | 16231.71 | 1277.0 |
| 2021-04-29 01:00:00 | NQ | Futures | 16231.42 | 16232.58 | 16220.71 | 16223.32 | 2899.0 |
| 2021-04-29 02:00:00 | NQ | Futures | 16223.89 | 16225.05 | 16207.68 | 16224.47 | 3293.0 |
| 2021-04-29 03:00:00 | NQ | Futures | 16224.47 | 16226.21 | 16203.05 | 16224.18 | 5507.0 |
| 2021-04-29 04:00:00 | NQ | Futures | 16225.05 | 16255.45 | 16224.76 | 16246.76 | 8653.0 |
| 2021-04-29 05:00:00 | NQ | Futures | 16246.76 | 16250.24 | 16234.32 | 16236.92 | 4575.0 |
| 2021-04-29 06:00:00 | NQ | Futures | 16236.63 | 16252.27 | 16229.68 | 16240.11 | 4023.0 |
| 2021-04-29 07:00:00 | NQ | Futures | 16240.4 | 16266.74 | 16235.76 | 16247.34 | 8267.0 |
| 2021-04-29 08:00:00 | NQ | Futures | 16247.63 | 16285.85 | 16239.82 | 16275.71 | 15959.0 |
| 2021-04-29 09:00:00 | NQ | Futures | 16275.71 | 16282.08 | 16153.26 | 16172.36 | 93504.0 |
| 2021-04-29 10:00:00 | NQ | Futures | 16172.36 | 16175.26 | 16076.54 | 16128.36 | 118292.0 |
| 2021-04-29 11:00:00 | NQ | Futures | 16128.36 | 16146.89 | 16035.43 | 16051.07 | 70891.0 |
| 2021-04-29 12:00:00 | NQ | Futures | 16051.64 | 16085.23 | 16001.56 | 16076.54 | 72547.0 |
| 2021-04-29 13:00:00 | NQ | Futures | 16076.83 | 16126.91 | 16054.83 | 16123.15 | 49556.0 |
| 2021-04-29 14:00:00 | NQ | Futures | 16123.15 | 16184.23 | 16112.44 | 16174.1 | 41147.0 |
| 2021-04-29 15:00:00 | NQ | Futures | 16174.1 | 16189.44 | 16144.86 | 16159.63 | 47659.0 |
| 2021-04-29 16:00:00 | NQ | Futures | 16159.92 | 16186.55 | 16139.36 | 16148.34 | 16858.0 |
| 2021-04-29 18:00:00 | NQ | Futures | 16151.81 | 16152.1 | 16125.18 | 16131.84 | 2932.0 |
| 2021-04-29 19:00:00 | NQ | Futures | 16131.55 | 16137.91 | 16105.2 | 16114.18 | 3320.0 |
| 2021-04-29 20:00:00 | NQ | Futures | 16113.89 | 16120.83 | 16086.67 | 16099.12 | 5091.0 |
| 2021-04-29 21:00:00 | NQ | Futures | 16099.41 | 16104.62 | 16084.94 | 16090.15 | 3150.0 |
| 2021-04-29 22:00:00 | NQ | Futures | 16090.15 | 16093.91 | 16079.44 | 16084.36 | 3224.0 |
| 2021-04-29 23:00:00 | NQ | Futures | 16084.07 | 16095.07 | 16080.02 | 16093.33 | 1840.0 |
| 2021-04-29 00:00:00 | YM | Futures | 37658.2 | 37686.0 | 37658.2 | 37661.5 | 771.0 |
| 2021-04-29 01:00:00 | YM | Futures | 37662.7 | 37696.1 | 37659.3 | 37687.2 | 887.0 |
| 2021-04-29 02:00:00 | YM | Futures | 37684.9 | 37705.0 | 37674.9 | 37705.0 | 1208.0 |
| 2021-04-29 03:00:00 | YM | Futures | 37703.9 | 37729.5 | 37678.2 | 37717.2 | 3815.0 |
> showing 50 of 1,918 rows — these rows as CSV