PREVIEW / futures_1hour / 2022-08-04
file: by_date/futures_1hour/2022/2022-08-04.parquet size: 67 KB rows: 2,038
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-08-04 00:00:00 | ES | Futures | 4704.01 | 4706.27 | 4703.44 | 4704.86 | 2903.0 |
| 2022-08-04 01:00:00 | ES | Futures | 4704.86 | 4707.12 | 4702.02 | 4702.87 | 4914.0 |
| 2022-08-04 02:00:00 | ES | Futures | 4702.87 | 4705.42 | 4701.17 | 4701.74 | 6280.0 |
| 2022-08-04 03:00:00 | ES | Futures | 4701.46 | 4712.79 | 4700.04 | 4708.26 | 15682.0 |
| 2022-08-04 04:00:00 | ES | Futures | 4708.54 | 4710.24 | 4703.72 | 4704.86 | 9464.0 |
| 2022-08-04 05:00:00 | ES | Futures | 4704.86 | 4718.45 | 4702.59 | 4715.9 | 11999.0 |
| 2022-08-04 06:00:00 | ES | Futures | 4716.19 | 4728.65 | 4715.05 | 4721.85 | 21243.0 |
| 2022-08-04 07:00:00 | ES | Futures | 4721.57 | 4723.55 | 4709.11 | 4709.67 | 17885.0 |
| 2022-08-04 08:00:00 | ES | Futures | 4709.96 | 4721.29 | 4708.26 | 4719.02 | 31370.0 |
| 2022-08-04 09:00:00 | ES | Futures | 4718.74 | 4719.02 | 4697.77 | 4709.39 | 185138.0 |
| 2022-08-04 10:00:00 | ES | Futures | 4709.67 | 4717.04 | 4686.44 | 4704.29 | 231205.0 |
| 2022-08-04 11:00:00 | ES | Futures | 4704.29 | 4709.67 | 4690.13 | 4707.69 | 151525.0 |
| 2022-08-04 12:00:00 | ES | Futures | 4707.97 | 4711.65 | 4693.53 | 4694.66 | 112228.0 |
| 2022-08-04 13:00:00 | ES | Futures | 4694.94 | 4711.94 | 4694.38 | 4706.27 | 94880.0 |
| 2022-08-04 14:00:00 | ES | Futures | 4706.27 | 4710.24 | 4699.47 | 4706.84 | 92844.0 |
| 2022-08-04 15:00:00 | ES | Futures | 4706.84 | 4715.9 | 4699.47 | 4705.99 | 137069.0 |
| 2022-08-04 16:00:00 | ES | Futures | 4705.71 | 4710.8 | 4703.16 | 4704.29 | 35963.0 |
| 2022-08-04 18:00:00 | ES | Futures | 4704.57 | 4707.41 | 4702.31 | 4705.71 | 2340.0 |
| 2022-08-04 19:00:00 | ES | Futures | 4705.99 | 4710.8 | 4705.99 | 4706.56 | 2880.0 |
| 2022-08-04 20:00:00 | ES | Futures | 4706.56 | 4711.37 | 4705.99 | 4709.96 | 3767.0 |
| 2022-08-04 21:00:00 | ES | Futures | 4709.96 | 4718.74 | 4709.39 | 4717.6 | 6945.0 |
| 2022-08-04 22:00:00 | ES | Futures | 4717.32 | 4720.72 | 4715.9 | 4717.89 | 3388.0 |
| 2022-08-04 23:00:00 | ES | Futures | 4718.17 | 4718.74 | 4714.49 | 4717.04 | 2461.0 |
| 2022-08-04 00:00:00 | NQ | Futures | 15315.79 | 15330.83 | 15315.5 | 15323.02 | 2116.0 |
| 2022-08-04 01:00:00 | NQ | Futures | 15322.73 | 15331.12 | 15313.18 | 15316.08 | 2667.0 |
| 2022-08-04 02:00:00 | NQ | Futures | 15316.65 | 15326.49 | 15310.0 | 15315.21 | 2892.0 |
| 2022-08-04 03:00:00 | NQ | Futures | 15314.34 | 15356.86 | 15305.08 | 15339.79 | 7330.0 |
| 2022-08-04 04:00:00 | NQ | Futures | 15339.21 | 15354.25 | 15325.91 | 15336.61 | 5942.0 |
| 2022-08-04 05:00:00 | NQ | Futures | 15336.9 | 15386.07 | 15323.88 | 15382.6 | 7195.0 |
| 2022-08-04 06:00:00 | NQ | Futures | 15382.6 | 15452.31 | 15378.84 | 15428.01 | 13689.0 |
| 2022-08-04 07:00:00 | NQ | Futures | 15428.3 | 15432.06 | 15354.83 | 15356.57 | 12679.0 |
| 2022-08-04 08:00:00 | NQ | Futures | 15356.86 | 15414.13 | 15349.63 | 15408.63 | 15192.0 |
| 2022-08-04 09:00:00 | NQ | Futures | 15408.05 | 15432.64 | 15324.17 | 15393.01 | 85991.0 |
| 2022-08-04 10:00:00 | NQ | Futures | 15393.59 | 15426.28 | 15254.18 | 15334.88 | 100760.0 |
| 2022-08-04 11:00:00 | NQ | Futures | 15334.59 | 15377.39 | 15269.8 | 15369.87 | 67007.0 |
| 2022-08-04 12:00:00 | NQ | Futures | 15369.58 | 15403.71 | 15322.15 | 15328.8 | 54438.0 |
| 2022-08-04 13:00:00 | NQ | Futures | 15329.09 | 15407.19 | 15327.07 | 15385.49 | 45026.0 |
| 2022-08-04 14:00:00 | NQ | Futures | 15386.07 | 15416.44 | 15354.25 | 15404.58 | 40934.0 |
| 2022-08-04 15:00:00 | NQ | Futures | 15405.16 | 15441.61 | 15377.39 | 15423.09 | 45875.0 |
| 2022-08-04 16:00:00 | NQ | Futures | 15423.38 | 15439.0 | 15414.13 | 15419.91 | 11187.0 |
| 2022-08-04 18:00:00 | NQ | Futures | 15419.04 | 15428.3 | 15407.19 | 15421.36 | 1770.0 |
| 2022-08-04 19:00:00 | NQ | Futures | 15421.07 | 15437.84 | 15421.07 | 15426.28 | 2044.0 |
| 2022-08-04 20:00:00 | NQ | Futures | 15426.28 | 15449.13 | 15425.99 | 15441.61 | 2909.0 |
| 2022-08-04 21:00:00 | NQ | Futures | 15440.16 | 15478.05 | 15437.27 | 15469.08 | 4554.0 |
| 2022-08-04 22:00:00 | NQ | Futures | 15468.79 | 15485.28 | 15462.72 | 15469.37 | 2583.0 |
| 2022-08-04 23:00:00 | NQ | Futures | 15470.24 | 15474.29 | 15454.62 | 15470.82 | 2167.0 |
| 2022-08-04 00:00:00 | YM | Futures | 36957.8 | 36974.7 | 36953.3 | 36970.2 | 469.0 |
| 2022-08-04 01:00:00 | YM | Futures | 36963.4 | 36982.6 | 36945.4 | 36953.3 | 793.0 |
| 2022-08-04 02:00:00 | YM | Futures | 36952.1 | 36969.0 | 36942.0 | 36944.2 | 1203.0 |
| 2022-08-04 03:00:00 | YM | Futures | 36943.1 | 37021.0 | 36936.3 | 36995.0 | 3659.0 |
> showing 50 of 2,038 rows — these rows as CSV