PREVIEW / futures_1hour / 2021-04-16
file: by_date/futures_1hour/2021/2021-04-16.parquet size: 51 KB rows: 1,552
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-16 00:00:00 | ES | Futures | 4670.55 | 4674.21 | 4669.99 | 4674.21 | 4047.0 |
| 2021-04-16 01:00:00 | ES | Futures | 4673.92 | 4675.61 | 4671.4 | 4674.21 | 6251.0 |
| 2021-04-16 02:00:00 | ES | Futures | 4674.21 | 4674.21 | 4669.71 | 4670.83 | 8007.0 |
| 2021-04-16 03:00:00 | ES | Futures | 4671.12 | 4678.42 | 4668.87 | 4673.92 | 17241.0 |
| 2021-04-16 04:00:00 | ES | Futures | 4673.92 | 4676.17 | 4671.68 | 4675.89 | 9741.0 |
| 2021-04-16 05:00:00 | ES | Futures | 4675.89 | 4684.04 | 4674.77 | 4681.51 | 22611.0 |
| 2021-04-16 06:00:00 | ES | Futures | 4681.23 | 4682.35 | 4679.83 | 4680.95 | 9378.0 |
| 2021-04-16 07:00:00 | ES | Futures | 4680.67 | 4686.01 | 4680.11 | 4685.73 | 15608.0 |
| 2021-04-16 08:00:00 | ES | Futures | 4685.73 | 4690.5 | 4685.16 | 4689.94 | 37545.0 |
| 2021-04-16 09:00:00 | ES | Futures | 4690.22 | 4696.12 | 4679.26 | 4681.51 | 235396.0 |
| 2021-04-16 10:00:00 | ES | Futures | 4681.51 | 4691.63 | 4677.3 | 4687.41 | 181696.0 |
| 2021-04-16 11:00:00 | ES | Futures | 4687.13 | 4691.91 | 4682.63 | 4685.16 | 122659.0 |
| 2021-04-16 12:00:00 | ES | Futures | 4685.16 | 4690.5 | 4684.88 | 4687.41 | 77370.0 |
| 2021-04-16 13:00:00 | ES | Futures | 4687.41 | 4689.38 | 4685.44 | 4686.01 | 58166.0 |
| 2021-04-16 14:00:00 | ES | Futures | 4686.01 | 4697.25 | 4684.88 | 4696.68 | 90374.0 |
| 2021-04-16 15:00:00 | ES | Futures | 4696.4 | 4701.74 | 4692.19 | 4694.72 | 251175.0 |
| 2021-04-16 16:00:00 | ES | Futures | 4694.72 | 4695.56 | 4688.54 | 4689.1 | 55822.0 |
| 2021-04-16 00:00:00 | NQ | Futures | 16178.15 | 16197.26 | 16176.13 | 16197.26 | 1980.0 |
| 2021-04-16 01:00:00 | NQ | Futures | 16196.68 | 16204.5 | 16188.58 | 16198.13 | 3035.0 |
| 2021-04-16 02:00:00 | NQ | Futures | 16197.84 | 16199.29 | 16177.86 | 16187.71 | 3083.0 |
| 2021-04-16 03:00:00 | NQ | Futures | 16186.84 | 16203.05 | 16171.5 | 16179.02 | 5951.0 |
| 2021-04-16 04:00:00 | NQ | Futures | 16179.6 | 16201.31 | 16177.86 | 16182.79 | 4610.0 |
| 2021-04-16 05:00:00 | NQ | Futures | 16182.21 | 16209.42 | 16179.02 | 16203.05 | 8783.0 |
| 2021-04-16 06:00:00 | NQ | Futures | 16203.05 | 16219.26 | 16196.68 | 16214.34 | 3986.0 |
| 2021-04-16 07:00:00 | NQ | Futures | 16213.76 | 16247.92 | 16210.0 | 16245.32 | 9032.0 |
| 2021-04-16 08:00:00 | NQ | Futures | 16245.03 | 16280.64 | 16243.29 | 16271.66 | 18290.0 |
| 2021-04-16 09:00:00 | NQ | Futures | 16271.66 | 16271.66 | 16158.18 | 16169.76 | 94060.0 |
| 2021-04-16 10:00:00 | NQ | Futures | 16170.05 | 16248.21 | 16161.36 | 16215.5 | 87529.0 |
| 2021-04-16 11:00:00 | NQ | Futures | 16215.21 | 16232.0 | 16194.66 | 16219.26 | 59167.0 |
| 2021-04-16 12:00:00 | NQ | Futures | 16219.26 | 16254.29 | 16214.05 | 16239.24 | 43247.0 |
| 2021-04-16 13:00:00 | NQ | Futures | 16238.95 | 16246.76 | 16210.0 | 16210.58 | 30232.0 |
| 2021-04-16 14:00:00 | NQ | Futures | 16210.58 | 16249.66 | 16207.39 | 16246.48 | 30668.0 |
| 2021-04-16 15:00:00 | NQ | Futures | 16246.76 | 16259.21 | 16233.45 | 16247.92 | 54545.0 |
| 2021-04-16 16:00:00 | NQ | Futures | 16248.21 | 16250.24 | 16227.66 | 16239.53 | 10946.0 |
| 2021-04-16 00:00:00 | YM | Futures | 37755.1 | 37774.0 | 37747.3 | 37772.9 | 663.0 |
| 2021-04-16 01:00:00 | YM | Futures | 37771.8 | 37787.4 | 37756.2 | 37775.1 | 1195.0 |
| 2021-04-16 02:00:00 | YM | Futures | 37776.3 | 37776.3 | 37745.1 | 37755.1 | 1403.0 |
| 2021-04-16 03:00:00 | YM | Futures | 37755.1 | 37817.5 | 37740.6 | 37787.4 | 3574.0 |
| 2021-04-16 04:00:00 | YM | Futures | 37787.4 | 37804.1 | 37761.8 | 37803.0 | 2124.0 |
| 2021-04-16 05:00:00 | YM | Futures | 37801.9 | 37860.9 | 37789.6 | 37840.9 | 4355.0 |
| 2021-04-16 06:00:00 | YM | Futures | 37840.9 | 37850.9 | 37828.6 | 37829.7 | 2087.0 |
| 2021-04-16 07:00:00 | YM | Futures | 37829.7 | 37857.6 | 37819.7 | 37855.3 | 2442.0 |
| 2021-04-16 08:00:00 | YM | Futures | 37854.2 | 37884.3 | 37843.1 | 37882.1 | 4354.0 |
| 2021-04-16 09:00:00 | YM | Futures | 37881.0 | 38023.5 | 37864.3 | 37914.4 | 25011.0 |
| 2021-04-16 10:00:00 | YM | Futures | 37918.8 | 37976.8 | 37879.8 | 37923.3 | 14679.0 |
| 2021-04-16 11:00:00 | YM | Futures | 37923.3 | 37941.1 | 37881.0 | 37888.8 | 10764.0 |
| 2021-04-16 12:00:00 | YM | Futures | 37888.8 | 37912.1 | 37873.2 | 37885.4 | 6397.0 |
| 2021-04-16 13:00:00 | YM | Futures | 37885.4 | 37915.5 | 37869.8 | 37899.9 | 5760.0 |
| 2021-04-16 14:00:00 | YM | Futures | 37901.0 | 38002.4 | 37891.0 | 37991.2 | 9057.0 |
| 2021-04-16 15:00:00 | YM | Futures | 37991.2 | 38030.2 | 37948.9 | 37967.8 | 16814.0 |
> showing 50 of 1,552 rows — these rows as CSV