PREVIEW / futures_1hour / 2021-04-22
file: by_date/futures_1hour/2021/2021-04-22.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-22 00:00:00 | ES | Futures | 4674.49 | 4677.3 | 4672.8 | 4677.3 | 4473.0 |
| 2021-04-22 01:00:00 | ES | Futures | 4677.3 | 4679.54 | 4674.49 | 4679.26 | 7251.0 |
| 2021-04-22 02:00:00 | ES | Futures | 4679.26 | 4683.2 | 4677.3 | 4677.58 | 10797.0 |
| 2021-04-22 03:00:00 | ES | Futures | 4677.58 | 4681.23 | 4675.61 | 4676.17 | 14119.0 |
| 2021-04-22 04:00:00 | ES | Futures | 4676.17 | 4680.95 | 4675.05 | 4675.61 | 11124.0 |
| 2021-04-22 05:00:00 | ES | Futures | 4675.89 | 4679.26 | 4674.49 | 4678.98 | 7496.0 |
| 2021-04-22 06:00:00 | ES | Futures | 4678.7 | 4679.54 | 4673.36 | 4675.33 | 9564.0 |
| 2021-04-22 07:00:00 | ES | Futures | 4675.05 | 4677.3 | 4673.64 | 4675.05 | 12842.0 |
| 2021-04-22 08:00:00 | ES | Futures | 4674.77 | 4682.07 | 4674.21 | 4678.14 | 24123.0 |
| 2021-04-22 09:00:00 | ES | Futures | 4678.14 | 4682.07 | 4665.21 | 4671.68 | 209070.0 |
| 2021-04-22 10:00:00 | ES | Futures | 4671.4 | 4681.79 | 4663.25 | 4678.14 | 225947.0 |
| 2021-04-22 11:00:00 | ES | Futures | 4678.14 | 4684.88 | 4676.45 | 4680.67 | 143789.0 |
| 2021-04-22 12:00:00 | ES | Futures | 4680.95 | 4688.25 | 4677.02 | 4687.97 | 90454.0 |
| 2021-04-22 13:00:00 | ES | Futures | 4688.25 | 4688.54 | 4628.97 | 4632.62 | 534931.0 |
| 2021-04-22 14:00:00 | ES | Futures | 4632.62 | 4651.17 | 4625.04 | 4646.11 | 246964.0 |
| 2021-04-22 15:00:00 | ES | Futures | 4646.11 | 4651.17 | 4632.06 | 4638.52 | 277046.0 |
| 2021-04-22 16:00:00 | ES | Futures | 4638.52 | 4641.89 | 4634.87 | 4641.61 | 49239.0 |
| 2021-04-22 18:00:00 | ES | Futures | 4640.49 | 4644.42 | 4639.93 | 4643.58 | 7163.0 |
| 2021-04-22 19:00:00 | ES | Futures | 4643.58 | 4644.42 | 4639.37 | 4641.33 | 6769.0 |
| 2021-04-22 20:00:00 | ES | Futures | 4641.61 | 4645.83 | 4639.37 | 4644.98 | 11023.0 |
| 2021-04-22 21:00:00 | ES | Futures | 4644.7 | 4649.48 | 4643.3 | 4647.79 | 12023.0 |
| 2021-04-22 22:00:00 | ES | Futures | 4647.79 | 4649.48 | 4645.27 | 4647.23 | 6034.0 |
| 2021-04-22 23:00:00 | ES | Futures | 4647.51 | 4650.32 | 4647.23 | 4648.36 | 5686.0 |
| 2021-04-22 00:00:00 | NQ | Futures | 16099.12 | 16107.52 | 16087.25 | 16106.65 | 2238.0 |
| 2021-04-22 01:00:00 | NQ | Futures | 16106.94 | 16119.97 | 16093.62 | 16117.36 | 3348.0 |
| 2021-04-22 02:00:00 | NQ | Futures | 16117.36 | 16139.94 | 16111.28 | 16114.75 | 4808.0 |
| 2021-04-22 03:00:00 | NQ | Futures | 16115.33 | 16139.07 | 16108.39 | 16118.23 | 5667.0 |
| 2021-04-22 04:00:00 | NQ | Futures | 16118.23 | 16129.52 | 16110.99 | 16113.6 | 4446.0 |
| 2021-04-22 05:00:00 | NQ | Futures | 16112.73 | 16121.41 | 16099.41 | 16111.57 | 3937.0 |
| 2021-04-22 06:00:00 | NQ | Futures | 16111.57 | 16114.47 | 16076.25 | 16096.52 | 6598.0 |
| 2021-04-22 07:00:00 | NQ | Futures | 16095.94 | 16104.91 | 16076.83 | 16086.09 | 6070.0 |
| 2021-04-22 08:00:00 | NQ | Futures | 16085.23 | 16114.18 | 16073.94 | 16097.67 | 12035.0 |
| 2021-04-22 09:00:00 | NQ | Futures | 16097.96 | 16112.44 | 16044.41 | 16074.8 | 71147.0 |
| 2021-04-22 10:00:00 | NQ | Futures | 16074.52 | 16147.76 | 16046.14 | 16123.73 | 86533.0 |
| 2021-04-22 11:00:00 | NQ | Futures | 16123.44 | 16132.7 | 16090.15 | 16103.46 | 51213.0 |
| 2021-04-22 12:00:00 | NQ | Futures | 16103.75 | 16143.41 | 16085.23 | 16139.94 | 35207.0 |
| 2021-04-22 13:00:00 | NQ | Futures | 16139.94 | 16144.28 | 15882.58 | 15901.98 | 134831.0 |
| 2021-04-22 14:00:00 | NQ | Futures | 15901.98 | 15970.59 | 15866.37 | 15935.56 | 81813.0 |
| 2021-04-22 15:00:00 | NQ | Futures | 15935.85 | 15963.35 | 15890.69 | 15922.82 | 72716.0 |
| 2021-04-22 16:00:00 | NQ | Futures | 15923.11 | 15937.87 | 15902.55 | 15935.56 | 11957.0 |
| 2021-04-22 18:00:00 | NQ | Futures | 15930.35 | 15947.14 | 15920.21 | 15941.93 | 3772.0 |
| 2021-04-22 19:00:00 | NQ | Futures | 15941.64 | 15948.58 | 15924.27 | 15932.66 | 2666.0 |
| 2021-04-22 20:00:00 | NQ | Futures | 15933.53 | 15946.56 | 15925.14 | 15943.95 | 3386.0 |
| 2021-04-22 21:00:00 | NQ | Futures | 15943.37 | 15959.01 | 15922.82 | 15947.14 | 5566.0 |
| 2021-04-22 22:00:00 | NQ | Futures | 15947.14 | 15954.09 | 15935.56 | 15948.58 | 2819.0 |
| 2021-04-22 23:00:00 | NQ | Futures | 15948.87 | 15968.27 | 15946.27 | 15953.51 | 2897.0 |
| 2021-04-22 00:00:00 | YM | Futures | 37849.8 | 37876.5 | 37837.5 | 37876.5 | 908.0 |
| 2021-04-22 01:00:00 | YM | Futures | 37876.5 | 37885.4 | 37854.2 | 37882.1 | 1168.0 |
| 2021-04-22 02:00:00 | YM | Futures | 37883.2 | 37913.3 | 37867.6 | 37870.9 | 2492.0 |
| 2021-04-22 03:00:00 | YM | Futures | 37872.1 | 37897.7 | 37854.2 | 37855.3 | 2897.0 |
> showing 50 of 1,918 rows — these rows as CSV