PREVIEW / futures_1hour / 2021-12-19
file: by_date/futures_1hour/2021/2021-12-19.parquet size: 19 KB rows: 418
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-19 18:00:00 | ES | Futures | 5217.13 | 5227.88 | 5183.76 | 5185.74 | 38413.0 |
| 2021-12-19 19:00:00 | ES | Futures | 5186.02 | 5195.07 | 5172.73 | 5193.09 | 27847.0 |
| 2021-12-19 20:00:00 | ES | Futures | 5193.38 | 5194.51 | 5175.28 | 5176.41 | 17554.0 |
| 2021-12-19 21:00:00 | ES | Futures | 5176.13 | 5176.13 | 5157.18 | 5163.97 | 23667.0 |
| 2021-12-19 22:00:00 | ES | Futures | 5163.68 | 5167.36 | 5160.57 | 5161.42 | 9731.0 |
| 2021-12-19 23:00:00 | ES | Futures | 5161.7 | 5172.17 | 5160.86 | 5167.93 | 7800.0 |
| 2021-12-19 18:00:00 | NQ | Futures | 18327.46 | 18376.44 | 18194.72 | 18209.21 | 17697.0 |
| 2021-12-19 19:00:00 | NQ | Futures | 18209.5 | 18236.45 | 18161.1 | 18232.98 | 12906.0 |
| 2021-12-19 20:00:00 | NQ | Futures | 18235.3 | 18238.77 | 18155.31 | 18159.94 | 8836.0 |
| 2021-12-19 21:00:00 | NQ | Futures | 18159.65 | 18159.65 | 18070.97 | 18098.79 | 13361.0 |
| 2021-12-19 22:00:00 | NQ | Futures | 18097.34 | 18113.57 | 18076.77 | 18084.01 | 7193.0 |
| 2021-12-19 23:00:00 | NQ | Futures | 18083.43 | 18129.51 | 18079.37 | 18119.08 | 6571.0 |
| 2021-12-19 18:00:00 | YM | Futures | 39617.3 | 39701.6 | 39386.9 | 39407.2 | 7760.0 |
| 2021-12-19 19:00:00 | YM | Futures | 39403.8 | 39489.2 | 39329.6 | 39474.6 | 5755.0 |
| 2021-12-19 20:00:00 | YM | Futures | 39476.9 | 39483.6 | 39339.7 | 39346.5 | 3606.0 |
| 2021-12-19 21:00:00 | YM | Futures | 39342.0 | 39363.3 | 39240.9 | 39283.6 | 3864.0 |
| 2021-12-19 22:00:00 | YM | Futures | 39281.3 | 39318.4 | 39271.2 | 39283.6 | 1942.0 |
| 2021-12-19 23:00:00 | YM | Futures | 39284.7 | 39365.6 | 39280.2 | 39319.5 | 1726.0 |
| 2021-12-19 18:00:00 | CL | Futures | 49.68 | 49.75 | 48.88 | 49.24 | 10601.0 |
| 2021-12-19 19:00:00 | CL | Futures | 49.24 | 49.34 | 49.11 | 49.28 | 4110.0 |
| 2021-12-19 20:00:00 | CL | Futures | 49.28 | 49.45 | 49.04 | 49.07 | 6370.0 |
| 2021-12-19 21:00:00 | CL | Futures | 49.06 | 49.12 | 48.96 | 48.99 | 4427.0 |
| 2021-12-19 22:00:00 | CL | Futures | 48.98 | 49.06 | 48.9 | 48.9 | 2545.0 |
| 2021-12-19 23:00:00 | CL | Futures | 48.91 | 48.93 | 48.65 | 48.67 | 4982.0 |
| 2021-12-19 18:00:00 | GC | Futures | 2164.0 | 2166.6 | 2162.6 | 2164.6 | 3034.0 |
| 2021-12-19 19:00:00 | GC | Futures | 2164.6 | 2167.5 | 2163.4 | 2166.0 | 2144.0 |
| 2021-12-19 20:00:00 | GC | Futures | 2165.7 | 2167.2 | 2163.3 | 2166.0 | 2727.0 |
| 2021-12-19 21:00:00 | GC | Futures | 2165.8 | 2167.4 | 2164.6 | 2166.8 | 1953.0 |
| 2021-12-19 22:00:00 | GC | Futures | 2166.8 | 2167.8 | 2166.1 | 2166.6 | 1222.0 |
| 2021-12-19 23:00:00 | GC | Futures | 2166.6 | 2166.7 | 2165.7 | 2166.0 | 718.0 |
| 2021-12-19 18:00:00 | ZN | Futures | 134.732716 | 134.957324 | 134.716672 | 134.925237 | 25457.0 |
| 2021-12-19 19:00:00 | ZN | Futures | 134.925237 | 134.957324 | 134.84502 | 134.861063 | 18416.0 |
| 2021-12-19 20:00:00 | ZN | Futures | 134.861063 | 134.89315 | 134.812933 | 134.89315 | 12951.0 |
| 2021-12-19 21:00:00 | ZN | Futures | 134.89315 | 135.021497 | 134.877106 | 134.98941 | 34715.0 |
| 2021-12-19 22:00:00 | ZN | Futures | 134.98941 | 135.021497 | 134.94128 | 135.005454 | 12873.0 |
| 2021-12-19 23:00:00 | ZN | Futures | 135.005454 | 135.021497 | 134.98941 | 135.005454 | 19351.0 |
> showing 36 of 418 rows — these rows as CSV