PREVIEW / futures_1hour / 2023-05-19
file: by_date/futures_1hour/2023/2023-05-19.parquet size: 57 KB rows: 1,651
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 |
|---|---|---|---|---|---|---|---|
| 2023-05-19 00:00:00 | ES | Futures | 4680.06 | 4680.89 | 4678.12 | 4679.51 | 4140.0 |
| 2023-05-19 01:00:00 | ES | Futures | 4679.78 | 4680.89 | 4677.01 | 4677.56 | 5748.0 |
| 2023-05-19 02:00:00 | ES | Futures | 4677.84 | 4682.28 | 4675.35 | 4675.62 | 11749.0 |
| 2023-05-19 03:00:00 | ES | Futures | 4675.9 | 4678.12 | 4672.85 | 4677.84 | 18580.0 |
| 2023-05-19 04:00:00 | ES | Futures | 4677.56 | 4683.94 | 4674.79 | 4681.73 | 19545.0 |
| 2023-05-19 05:00:00 | ES | Futures | 4681.45 | 4682.28 | 4677.84 | 4680.06 | 11360.0 |
| 2023-05-19 06:00:00 | ES | Futures | 4679.78 | 4680.34 | 4674.79 | 4676.73 | 19147.0 |
| 2023-05-19 07:00:00 | ES | Futures | 4676.73 | 4687.55 | 4676.73 | 4684.5 | 34603.0 |
| 2023-05-19 08:00:00 | ES | Futures | 4684.22 | 4689.77 | 4680.06 | 4688.94 | 39815.0 |
| 2023-05-19 09:00:00 | ES | Futures | 4689.21 | 4689.21 | 4677.56 | 4686.16 | 182833.0 |
| 2023-05-19 10:00:00 | ES | Futures | 4686.16 | 4688.1 | 4678.4 | 4683.67 | 179870.0 |
| 2023-05-19 11:00:00 | ES | Futures | 4683.67 | 4686.16 | 4650.11 | 4663.14 | 379273.0 |
| 2023-05-19 12:00:00 | ES | Futures | 4663.14 | 4667.86 | 4652.05 | 4665.36 | 165164.0 |
| 2023-05-19 13:00:00 | ES | Futures | 4665.36 | 4669.52 | 4657.04 | 4657.6 | 96961.0 |
| 2023-05-19 14:00:00 | ES | Futures | 4657.87 | 4665.64 | 4651.77 | 4665.08 | 126974.0 |
| 2023-05-19 15:00:00 | ES | Futures | 4665.08 | 4668.97 | 4657.6 | 4664.53 | 193783.0 |
| 2023-05-19 16:00:00 | ES | Futures | 4664.81 | 4665.92 | 4654.82 | 4657.6 | 66731.0 |
| 2023-05-19 00:00:00 | NQ | Futures | 15687.29 | 15688.98 | 15679.41 | 15682.5 | 2413.0 |
| 2023-05-19 01:00:00 | NQ | Futures | 15683.07 | 15683.63 | 15666.74 | 15668.43 | 3574.0 |
| 2023-05-19 02:00:00 | NQ | Futures | 15668.71 | 15683.35 | 15654.91 | 15657.73 | 6279.0 |
| 2023-05-19 03:00:00 | NQ | Futures | 15657.73 | 15667.02 | 15640.83 | 15666.17 | 8595.0 |
| 2023-05-19 04:00:00 | NQ | Futures | 15665.89 | 15690.1 | 15654.91 | 15685.04 | 7627.0 |
| 2023-05-19 05:00:00 | NQ | Futures | 15684.47 | 15686.16 | 15665.05 | 15674.06 | 4440.0 |
| 2023-05-19 06:00:00 | NQ | Futures | 15673.49 | 15679.97 | 15638.86 | 15641.4 | 8394.0 |
| 2023-05-19 07:00:00 | NQ | Futures | 15641.4 | 15675.75 | 15641.11 | 15656.6 | 12846.0 |
| 2023-05-19 08:00:00 | NQ | Futures | 15657.16 | 15672.93 | 15629.01 | 15669.27 | 18862.0 |
| 2023-05-19 09:00:00 | NQ | Futures | 15669.27 | 15687.01 | 15629.85 | 15650.69 | 82766.0 |
| 2023-05-19 10:00:00 | NQ | Futures | 15651.25 | 15668.71 | 15611.27 | 15634.08 | 99205.0 |
| 2023-05-19 11:00:00 | NQ | Futures | 15633.79 | 15653.22 | 15566.78 | 15611.83 | 132000.0 |
| 2023-05-19 12:00:00 | NQ | Futures | 15612.11 | 15627.32 | 15565.94 | 15600.01 | 69298.0 |
| 2023-05-19 13:00:00 | NQ | Futures | 15599.73 | 15626.76 | 15584.8 | 15586.21 | 44671.0 |
| 2023-05-19 14:00:00 | NQ | Futures | 15586.49 | 15599.16 | 15557.78 | 15597.47 | 46762.0 |
| 2023-05-19 15:00:00 | NQ | Futures | 15597.47 | 15616.06 | 15580.3 | 15607.33 | 54834.0 |
| 2023-05-19 16:00:00 | NQ | Futures | 15607.33 | 15610.14 | 15576.64 | 15587.9 | 16032.0 |
| 2023-05-19 00:00:00 | YM | Futures | 37181.5 | 37192.5 | 37172.6 | 37180.4 | 497.0 |
| 2023-05-19 01:00:00 | YM | Futures | 37182.6 | 37187.0 | 37164.9 | 37170.4 | 671.0 |
| 2023-05-19 02:00:00 | YM | Futures | 37169.3 | 37203.6 | 37152.7 | 37153.8 | 1961.0 |
| 2023-05-19 03:00:00 | YM | Futures | 37153.8 | 37181.5 | 37142.8 | 37177.0 | 3030.0 |
| 2023-05-19 04:00:00 | YM | Futures | 37175.9 | 37220.2 | 37159.4 | 37203.6 | 2363.0 |
| 2023-05-19 05:00:00 | YM | Futures | 37204.7 | 37217.9 | 37183.7 | 37196.9 | 1729.0 |
| 2023-05-19 06:00:00 | YM | Futures | 37195.8 | 37198.0 | 37152.7 | 37185.9 | 3234.0 |
| 2023-05-19 07:00:00 | YM | Futures | 37182.6 | 37257.7 | 37180.4 | 37250.0 | 4835.0 |
| 2023-05-19 08:00:00 | YM | Futures | 37250.0 | 37283.2 | 37223.5 | 37272.1 | 5355.0 |
| 2023-05-19 09:00:00 | YM | Futures | 37271.0 | 37271.0 | 37142.8 | 37211.3 | 23421.0 |
| 2023-05-19 10:00:00 | YM | Futures | 37213.5 | 37255.5 | 37169.3 | 37253.3 | 17166.0 |
| 2023-05-19 11:00:00 | YM | Futures | 37252.2 | 37272.1 | 36922.8 | 37013.5 | 44763.0 |
| 2023-05-19 12:00:00 | YM | Futures | 37013.5 | 37069.8 | 36910.7 | 37049.9 | 21009.0 |
| 2023-05-19 13:00:00 | YM | Futures | 37049.9 | 37077.6 | 36965.9 | 36972.6 | 11091.0 |
| 2023-05-19 14:00:00 | YM | Futures | 36972.6 | 37052.1 | 36937.2 | 37051.0 | 12313.0 |
| 2023-05-19 15:00:00 | YM | Futures | 37047.7 | 37056.6 | 36975.9 | 37022.3 | 15767.0 |
> showing 50 of 1,651 rows — these rows as CSV