PREVIEW / futures_1hour / 2021-01-10
file: by_date/futures_1hour/2021/2021-01-10.parquet size: 19 KB rows: 395
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-01-10 18:00:00 | ES | Futures | 4283.53 | 4289.42 | 4274.83 | 4277.08 | 13879.0 |
| 2021-01-10 19:00:00 | ES | Futures | 4276.79 | 4281.57 | 4270.62 | 4275.39 | 11681.0 |
| 2021-01-10 20:00:00 | ES | Futures | 4275.11 | 4275.67 | 4264.73 | 4265.85 | 15302.0 |
| 2021-01-10 21:00:00 | ES | Futures | 4265.85 | 4267.25 | 4257.15 | 4266.69 | 15991.0 |
| 2021-01-10 22:00:00 | ES | Futures | 4266.41 | 4266.97 | 4259.39 | 4261.92 | 9621.0 |
| 2021-01-10 23:00:00 | ES | Futures | 4262.2 | 4265.85 | 4255.46 | 4258.27 | 10125.0 |
| 2021-01-10 18:00:00 | NQ | Futures | 15158.51 | 15172.41 | 15132.17 | 15146.65 | 6176.0 |
| 2021-01-10 19:00:00 | NQ | Futures | 15146.36 | 15161.7 | 15110.76 | 15129.57 | 4893.0 |
| 2021-01-10 20:00:00 | NQ | Futures | 15129.28 | 15149.25 | 15104.1 | 15107.28 | 5758.0 |
| 2021-01-10 21:00:00 | NQ | Futures | 15108.73 | 15124.07 | 15075.74 | 15109.6 | 6070.0 |
| 2021-01-10 22:00:00 | NQ | Futures | 15109.6 | 15114.52 | 15080.08 | 15094.84 | 3797.0 |
| 2021-01-10 23:00:00 | NQ | Futures | 15096.0 | 15105.84 | 15076.89 | 15083.84 | 2766.0 |
| 2021-01-10 18:00:00 | YM | Futures | 34351.8 | 34409.5 | 34281.9 | 34297.4 | 2800.0 |
| 2021-01-10 19:00:00 | YM | Futures | 34297.4 | 34338.5 | 34270.8 | 34310.7 | 2021.0 |
| 2021-01-10 20:00:00 | YM | Futures | 34309.6 | 34310.7 | 34219.8 | 34225.3 | 2838.0 |
| 2021-01-10 21:00:00 | YM | Futures | 34225.3 | 34235.3 | 34161.0 | 34223.1 | 2787.0 |
| 2021-01-10 22:00:00 | YM | Futures | 34222.0 | 34224.2 | 34172.1 | 34186.5 | 2019.0 |
| 2021-01-10 23:00:00 | YM | Futures | 34187.6 | 34212.0 | 34131.0 | 34161.0 | 2280.0 |
| 2021-01-10 18:00:00 | CL | Futures | 35.61 | 35.69 | 35.37 | 35.43 | 5252.0 |
| 2021-01-10 19:00:00 | CL | Futures | 35.42 | 35.47 | 35.36 | 35.36 | 3049.0 |
| 2021-01-10 20:00:00 | CL | Futures | 35.36 | 35.48 | 35.19 | 35.29 | 12145.0 |
| 2021-01-10 21:00:00 | CL | Futures | 35.29 | 35.33 | 35.17 | 35.31 | 8316.0 |
| 2021-01-10 22:00:00 | CL | Futures | 35.31 | 35.31 | 35.0 | 35.06 | 6487.0 |
| 2021-01-10 23:00:00 | CL | Futures | 35.06 | 35.13 | 35.04 | 35.07 | 2505.0 |
| 2021-01-10 18:00:00 | GC | Futures | 2241.5 | 2249.5 | 2231.8 | 2235.3 | 7219.0 |
| 2021-01-10 19:00:00 | GC | Futures | 2235.4 | 2241.0 | 2231.0 | 2231.5 | 4739.0 |
| 2021-01-10 20:00:00 | GC | Futures | 2231.3 | 2231.9 | 2202.3 | 2215.4 | 19933.0 |
| 2021-01-10 21:00:00 | GC | Futures | 2215.5 | 2227.9 | 2213.0 | 2224.2 | 7040.0 |
| 2021-01-10 22:00:00 | GC | Futures | 2224.2 | 2224.5 | 2215.9 | 2218.4 | 4708.0 |
| 2021-01-10 23:00:00 | GC | Futures | 2218.4 | 2222.4 | 2213.6 | 2221.6 | 3783.0 |
| 2021-01-10 18:00:00 | ZN | Futures | 136.819286 | 136.866249 | 136.709705 | 136.866249 | 37855.0 |
| 2021-01-10 19:00:00 | ZN | Futures | 136.850595 | 136.866249 | 136.819286 | 136.866249 | 11222.0 |
| 2021-01-10 20:00:00 | ZN | Futures | 136.850595 | 136.866249 | 136.819286 | 136.83494 | 14256.0 |
| 2021-01-10 21:00:00 | ZN | Futures | 136.83494 | 136.897558 | 136.83494 | 136.850595 | 14934.0 |
| 2021-01-10 22:00:00 | ZN | Futures | 136.850595 | 136.866249 | 136.819286 | 136.850595 | 7049.0 |
| 2021-01-10 23:00:00 | ZN | Futures | 136.850595 | 136.928867 | 136.850595 | 136.928867 | 9400.0 |
> showing 36 of 395 rows — these rows as CSV