PREVIEW / futures_1hour / 2021-11-15
file: by_date/futures_1hour/2021/2021-11-15.parquet size: 65 KB rows: 1,996
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-11-15 00:00:00 | ES | Futures | 5283.3 | 5286.12 | 5283.02 | 5284.71 | 4156.0 |
| 2021-11-15 01:00:00 | ES | Futures | 5284.71 | 5284.99 | 5281.32 | 5283.02 | 4237.0 |
| 2021-11-15 02:00:00 | ES | Futures | 5283.02 | 5283.02 | 5279.91 | 5282.73 | 6044.0 |
| 2021-11-15 03:00:00 | ES | Futures | 5283.02 | 5289.51 | 5280.19 | 5289.22 | 11647.0 |
| 2021-11-15 04:00:00 | ES | Futures | 5289.22 | 5292.33 | 5287.53 | 5290.07 | 8250.0 |
| 2021-11-15 05:00:00 | ES | Futures | 5290.07 | 5294.59 | 5290.07 | 5293.74 | 7149.0 |
| 2021-11-15 06:00:00 | ES | Futures | 5293.46 | 5295.43 | 5291.76 | 5293.74 | 7950.0 |
| 2021-11-15 07:00:00 | ES | Futures | 5294.02 | 5294.02 | 5290.92 | 5293.74 | 8505.0 |
| 2021-11-15 08:00:00 | ES | Futures | 5293.74 | 5302.77 | 5293.46 | 5298.26 | 27941.0 |
| 2021-11-15 09:00:00 | ES | Futures | 5298.54 | 5300.23 | 5284.14 | 5294.59 | 151441.0 |
| 2021-11-15 10:00:00 | ES | Futures | 5294.59 | 5294.87 | 5282.45 | 5285.56 | 147642.0 |
| 2021-11-15 11:00:00 | ES | Futures | 5285.56 | 5289.22 | 5268.34 | 5275.68 | 150213.0 |
| 2021-11-15 12:00:00 | ES | Futures | 5275.68 | 5279.91 | 5268.34 | 5279.35 | 94510.0 |
| 2021-11-15 13:00:00 | ES | Futures | 5279.07 | 5283.02 | 5276.24 | 5277.65 | 66179.0 |
| 2021-11-15 14:00:00 | ES | Futures | 5277.65 | 5282.17 | 5272.01 | 5280.19 | 70833.0 |
| 2021-11-15 15:00:00 | ES | Futures | 5280.19 | 5283.58 | 5272.01 | 5281.89 | 154840.0 |
| 2021-11-15 16:00:00 | ES | Futures | 5281.89 | 5285.27 | 5280.76 | 5284.14 | 46630.0 |
| 2021-11-15 18:00:00 | ES | Futures | 5283.86 | 5284.43 | 5281.32 | 5282.45 | 4027.0 |
| 2021-11-15 19:00:00 | ES | Futures | 5282.73 | 5285.84 | 5279.07 | 5283.86 | 8153.0 |
| 2021-11-15 20:00:00 | ES | Futures | 5284.14 | 5290.92 | 5283.02 | 5290.07 | 9857.0 |
| 2021-11-15 21:00:00 | ES | Futures | 5290.07 | 5290.64 | 5286.4 | 5287.25 | 5004.0 |
| 2021-11-15 22:00:00 | ES | Futures | 5287.25 | 5288.66 | 5286.4 | 5286.97 | 2605.0 |
| 2021-11-15 23:00:00 | ES | Futures | 5286.97 | 5286.97 | 5280.76 | 5281.32 | 5019.0 |
| 2021-11-15 00:00:00 | NQ | Futures | 18796.96 | 18818.7 | 18796.96 | 18814.64 | 2300.0 |
| 2021-11-15 01:00:00 | NQ | Futures | 18814.64 | 18821.31 | 18798.7 | 18806.24 | 2622.0 |
| 2021-11-15 02:00:00 | NQ | Futures | 18806.24 | 18807.97 | 18794.35 | 18803.92 | 2031.0 |
| 2021-11-15 03:00:00 | NQ | Futures | 18804.21 | 18821.02 | 18794.64 | 18820.73 | 4640.0 |
| 2021-11-15 04:00:00 | NQ | Futures | 18820.15 | 18825.36 | 18790.87 | 18806.24 | 4580.0 |
| 2021-11-15 05:00:00 | NQ | Futures | 18806.24 | 18823.04 | 18805.08 | 18814.06 | 3555.0 |
| 2021-11-15 06:00:00 | NQ | Futures | 18813.77 | 18822.75 | 18803.63 | 18820.15 | 2793.0 |
| 2021-11-15 07:00:00 | NQ | Futures | 18820.44 | 18822.46 | 18805.37 | 18818.12 | 3767.0 |
| 2021-11-15 08:00:00 | NQ | Futures | 18817.54 | 18868.84 | 18817.25 | 18847.1 | 13098.0 |
| 2021-11-15 09:00:00 | NQ | Futures | 18847.97 | 18852.61 | 18766.53 | 18813.77 | 77462.0 |
| 2021-11-15 10:00:00 | NQ | Futures | 18814.06 | 18816.09 | 18718.13 | 18746.24 | 86531.0 |
| 2021-11-15 11:00:00 | NQ | Futures | 18746.53 | 18773.2 | 18656.11 | 18695.24 | 70045.0 |
| 2021-11-15 12:00:00 | NQ | Futures | 18694.66 | 18722.48 | 18643.65 | 18707.12 | 51226.0 |
| 2021-11-15 13:00:00 | NQ | Futures | 18706.25 | 18735.81 | 18696.1 | 18699.58 | 30981.0 |
| 2021-11-15 14:00:00 | NQ | Futures | 18699.87 | 18756.68 | 18687.99 | 18751.17 | 35498.0 |
| 2021-11-15 15:00:00 | NQ | Futures | 18751.17 | 18774.36 | 18731.75 | 18766.53 | 58378.0 |
| 2021-11-15 16:00:00 | NQ | Futures | 18766.24 | 18779.28 | 18760.15 | 18775.8 | 9668.0 |
| 2021-11-15 18:00:00 | NQ | Futures | 18778.41 | 18779.86 | 18762.76 | 18768.27 | 2261.0 |
| 2021-11-15 19:00:00 | NQ | Futures | 18768.85 | 18779.57 | 18754.94 | 18772.33 | 3825.0 |
| 2021-11-15 20:00:00 | NQ | Futures | 18772.62 | 18810.0 | 18770.3 | 18803.05 | 4812.0 |
| 2021-11-15 21:00:00 | NQ | Futures | 18803.34 | 18804.79 | 18792.03 | 18794.93 | 1917.0 |
| 2021-11-15 22:00:00 | NQ | Futures | 18795.8 | 18803.34 | 18793.19 | 18798.99 | 1311.0 |
| 2021-11-15 23:00:00 | NQ | Futures | 18798.7 | 18799.28 | 18763.34 | 18769.14 | 3087.0 |
| 2021-11-15 00:00:00 | YM | Futures | 40361.6 | 40376.2 | 40356.0 | 40366.1 | 692.0 |
| 2021-11-15 01:00:00 | YM | Futures | 40365.0 | 40369.5 | 40331.4 | 40348.2 | 1033.0 |
| 2021-11-15 02:00:00 | YM | Futures | 40348.2 | 40359.4 | 40313.4 | 40354.9 | 2087.0 |
| 2021-11-15 03:00:00 | YM | Futures | 40353.8 | 40409.8 | 40333.6 | 40407.6 | 2957.0 |
> showing 50 of 1,996 rows — these rows as CSV