PREVIEW / futures_1hour / 2021-12-10
file: by_date/futures_1hour/2021/2021-12-10.parquet size: 53 KB rows: 1,550
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-12-10 00:00:00 | ES | Futures | 5270.88 | 5272.57 | 5266.08 | 5267.49 | 3252.0 |
| 2021-12-10 01:00:00 | ES | Futures | 5267.49 | 5272.86 | 5266.93 | 5272.57 | 3732.0 |
| 2021-12-10 02:00:00 | ES | Futures | 5272.86 | 5274.83 | 5270.03 | 5273.7 | 5935.0 |
| 2021-12-10 03:00:00 | ES | Futures | 5273.99 | 5283.3 | 5272.86 | 5283.02 | 10877.0 |
| 2021-12-10 04:00:00 | ES | Futures | 5283.02 | 5283.58 | 5277.94 | 5283.3 | 6214.0 |
| 2021-12-10 05:00:00 | ES | Futures | 5283.02 | 5284.14 | 5280.48 | 5283.3 | 2806.0 |
| 2021-12-10 06:00:00 | ES | Futures | 5283.3 | 5292.89 | 5283.3 | 5290.64 | 7081.0 |
| 2021-12-10 07:00:00 | ES | Futures | 5290.35 | 5290.92 | 5283.02 | 5284.99 | 10083.0 |
| 2021-12-10 08:00:00 | ES | Futures | 5284.99 | 5312.93 | 5281.89 | 5306.72 | 67547.0 |
| 2021-12-10 09:00:00 | ES | Futures | 5306.72 | 5310.96 | 5288.94 | 5292.05 | 147059.0 |
| 2021-12-10 10:00:00 | ES | Futures | 5291.48 | 5304.75 | 5279.91 | 5287.25 | 156130.0 |
| 2021-12-10 11:00:00 | ES | Futures | 5287.25 | 5297.97 | 5270.32 | 5295.15 | 113822.0 |
| 2021-12-10 12:00:00 | ES | Futures | 5295.43 | 5299.67 | 5286.68 | 5297.13 | 62524.0 |
| 2021-12-10 13:00:00 | ES | Futures | 5297.13 | 5303.34 | 5294.87 | 5301.64 | 47844.0 |
| 2021-12-10 14:00:00 | ES | Futures | 5301.36 | 5305.31 | 5293.46 | 5294.87 | 46681.0 |
| 2021-12-10 15:00:00 | ES | Futures | 5294.87 | 5319.7 | 5292.05 | 5317.73 | 107637.0 |
| 2021-12-10 16:00:00 | ES | Futures | 5317.73 | 5319.99 | 5314.91 | 5319.42 | 39037.0 |
| 2021-12-10 00:00:00 | NQ | Futures | 18735.23 | 18744.21 | 18712.91 | 18715.52 | 2516.0 |
| 2021-12-10 01:00:00 | NQ | Futures | 18715.81 | 18740.45 | 18713.2 | 18740.16 | 2667.0 |
| 2021-12-10 02:00:00 | NQ | Futures | 18740.45 | 18740.45 | 18718.71 | 18733.49 | 3873.0 |
| 2021-12-10 03:00:00 | NQ | Futures | 18733.49 | 18783.05 | 18728.56 | 18781.31 | 7559.0 |
| 2021-12-10 04:00:00 | NQ | Futures | 18781.02 | 18782.47 | 18747.11 | 18781.6 | 4305.0 |
| 2021-12-10 05:00:00 | NQ | Futures | 18781.89 | 18784.79 | 18761.6 | 18779.28 | 2609.0 |
| 2021-12-10 06:00:00 | NQ | Futures | 18778.41 | 18811.45 | 18775.8 | 18799.28 | 3487.0 |
| 2021-12-10 07:00:00 | NQ | Futures | 18798.7 | 18802.18 | 18749.14 | 18762.47 | 5797.0 |
| 2021-12-10 08:00:00 | NQ | Futures | 18763.05 | 18907.67 | 18739.58 | 18874.92 | 25918.0 |
| 2021-12-10 09:00:00 | NQ | Futures | 18874.92 | 18926.22 | 18780.44 | 18801.6 | 61061.0 |
| 2021-12-10 10:00:00 | NQ | Futures | 18801.02 | 18908.83 | 18737.26 | 18786.53 | 61229.0 |
| 2021-12-10 11:00:00 | NQ | Futures | 18786.24 | 18854.92 | 18703.35 | 18836.67 | 43714.0 |
| 2021-12-10 12:00:00 | NQ | Futures | 18837.83 | 18854.63 | 18787.11 | 18847.97 | 26719.0 |
| 2021-12-10 13:00:00 | NQ | Futures | 18847.1 | 18874.63 | 18827.1 | 18856.66 | 22200.0 |
| 2021-12-10 14:00:00 | NQ | Futures | 18856.08 | 18866.23 | 18812.9 | 18822.46 | 13473.0 |
| 2021-12-10 15:00:00 | NQ | Futures | 18822.46 | 18937.52 | 18806.24 | 18925.64 | 21820.0 |
| 2021-12-10 16:00:00 | NQ | Futures | 18925.35 | 18926.8 | 18907.67 | 18922.16 | 6754.0 |
| 2021-12-10 00:00:00 | YM | Futures | 40062.4 | 40070.2 | 40015.2 | 40033.1 | 571.0 |
| 2021-12-10 01:00:00 | YM | Futures | 40030.9 | 40063.5 | 40030.9 | 40063.5 | 627.0 |
| 2021-12-10 02:00:00 | YM | Futures | 40061.2 | 40091.6 | 40046.6 | 40074.7 | 1146.0 |
| 2021-12-10 03:00:00 | YM | Futures | 40074.7 | 40142.1 | 40061.2 | 40136.5 | 2195.0 |
| 2021-12-10 04:00:00 | YM | Futures | 40138.8 | 40139.9 | 40102.8 | 40128.7 | 1025.0 |
| 2021-12-10 05:00:00 | YM | Futures | 40127.5 | 40142.1 | 40117.4 | 40139.9 | 855.0 |
| 2021-12-10 06:00:00 | YM | Futures | 40141.0 | 40217.4 | 40134.3 | 40201.7 | 1731.0 |
| 2021-12-10 07:00:00 | YM | Futures | 40201.7 | 40211.8 | 40166.9 | 40170.2 | 1904.0 |
| 2021-12-10 08:00:00 | YM | Futures | 40169.1 | 40326.4 | 40153.4 | 40295.0 | 6134.0 |
| 2021-12-10 09:00:00 | YM | Futures | 40296.1 | 40304.0 | 40183.7 | 40202.8 | 12812.0 |
| 2021-12-10 10:00:00 | YM | Futures | 40199.5 | 40248.9 | 40099.4 | 40129.8 | 15448.0 |
| 2021-12-10 11:00:00 | YM | Futures | 40126.4 | 40162.4 | 40020.8 | 40142.1 | 11862.0 |
| 2021-12-10 12:00:00 | YM | Futures | 40144.4 | 40171.4 | 40097.2 | 40164.6 | 6780.0 |
| 2021-12-10 13:00:00 | YM | Futures | 40163.5 | 40224.2 | 40159.0 | 40207.3 | 4900.0 |
| 2021-12-10 14:00:00 | YM | Futures | 40207.3 | 40257.9 | 40171.4 | 40181.5 | 5031.0 |
| 2021-12-10 15:00:00 | YM | Futures | 40182.6 | 40325.3 | 40165.7 | 40313.0 | 9511.0 |
> showing 50 of 1,550 rows — these rows as CSV