PREVIEW / futures_1hour / 2021-05-16
file: by_date/futures_1hour/2021/2021-05-16.parquet size: 18 KB rows: 389
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-05-16 18:00:00 | ES | Futures | 4685.44 | 4696.4 | 4684.88 | 4689.38 | 9334.0 |
| 2021-05-16 19:00:00 | ES | Futures | 4689.38 | 4692.19 | 4685.73 | 4687.13 | 6821.0 |
| 2021-05-16 20:00:00 | ES | Futures | 4687.13 | 4687.97 | 4673.64 | 4677.86 | 20669.0 |
| 2021-05-16 21:00:00 | ES | Futures | 4677.86 | 4686.01 | 4675.33 | 4680.11 | 14857.0 |
| 2021-05-16 22:00:00 | ES | Futures | 4680.39 | 4683.76 | 4673.36 | 4680.11 | 11313.0 |
| 2021-05-16 23:00:00 | ES | Futures | 4680.11 | 4681.51 | 4670.55 | 4672.52 | 9798.0 |
| 2021-05-16 18:00:00 | NQ | Futures | 15494.08 | 15573.11 | 15490.31 | 15525.92 | 7298.0 |
| 2021-05-16 19:00:00 | NQ | Futures | 15526.5 | 15542.42 | 15501.02 | 15510.0 | 4937.0 |
| 2021-05-16 20:00:00 | NQ | Futures | 15509.71 | 15512.03 | 15449.78 | 15475.26 | 8055.0 |
| 2021-05-16 21:00:00 | NQ | Futures | 15474.1 | 15515.21 | 15463.68 | 15486.55 | 5891.0 |
| 2021-05-16 22:00:00 | NQ | Futures | 15486.55 | 15501.6 | 15455.28 | 15481.92 | 5046.0 |
| 2021-05-16 23:00:00 | NQ | Futures | 15481.05 | 15491.18 | 15447.76 | 15458.47 | 4208.0 |
| 2021-05-16 18:00:00 | YM | Futures | 38226.2 | 38286.4 | 38222.9 | 38244.1 | 1823.0 |
| 2021-05-16 19:00:00 | YM | Futures | 38243.0 | 38257.4 | 38207.3 | 38227.4 | 1644.0 |
| 2021-05-16 20:00:00 | YM | Futures | 38225.1 | 38236.3 | 38116.0 | 38139.4 | 4395.0 |
| 2021-05-16 21:00:00 | YM | Futures | 38138.3 | 38193.9 | 38112.6 | 38151.6 | 2485.0 |
| 2021-05-16 22:00:00 | YM | Futures | 38152.7 | 38177.2 | 38100.4 | 38153.8 | 1945.0 |
| 2021-05-16 23:00:00 | YM | Futures | 38153.8 | 38161.6 | 38077.0 | 38094.8 | 1682.0 |
| 2021-05-16 18:00:00 | CL | Futures | 44.35 | 44.51 | 44.32 | 44.43 | 993.0 |
| 2021-05-16 19:00:00 | CL | Futures | 44.43 | 44.46 | 44.39 | 44.41 | 524.0 |
| 2021-05-16 20:00:00 | CL | Futures | 44.41 | 44.41 | 44.18 | 44.28 | 2666.0 |
| 2021-05-16 21:00:00 | CL | Futures | 44.29 | 44.47 | 44.16 | 44.4 | 2643.0 |
| 2021-05-16 22:00:00 | CL | Futures | 44.41 | 44.53 | 44.37 | 44.51 | 1774.0 |
| 2021-05-16 23:00:00 | CL | Futures | 44.51 | 44.53 | 44.33 | 44.35 | 1112.0 |
| 2021-05-16 18:00:00 | GC | Futures | 2229.9 | 2234.5 | 2224.1 | 2230.0 | 4307.0 |
| 2021-05-16 19:00:00 | GC | Futures | 2229.8 | 2232.6 | 2229.0 | 2231.7 | 1667.0 |
| 2021-05-16 20:00:00 | GC | Futures | 2231.6 | 2231.7 | 2227.5 | 2228.2 | 3116.0 |
| 2021-05-16 21:00:00 | GC | Futures | 2228.2 | 2238.7 | 2227.6 | 2236.0 | 12726.0 |
| 2021-05-16 22:00:00 | GC | Futures | 2236.0 | 2237.3 | 2232.8 | 2236.1 | 5452.0 |
| 2021-05-16 23:00:00 | GC | Futures | 2236.1 | 2238.1 | 2235.1 | 2236.3 | 4646.0 |
| 2021-05-16 18:00:00 | ZN | Futures | 133.769538 | 133.785322 | 133.73797 | 133.73797 | 5056.0 |
| 2021-05-16 19:00:00 | ZN | Futures | 133.73797 | 133.785322 | 133.722186 | 133.753754 | 8262.0 |
| 2021-05-16 20:00:00 | ZN | Futures | 133.753754 | 133.785322 | 133.753754 | 133.769538 | 4414.0 |
| 2021-05-16 21:00:00 | ZN | Futures | 133.785322 | 133.848458 | 133.753754 | 133.848458 | 22856.0 |
| 2021-05-16 22:00:00 | ZN | Futures | 133.832674 | 133.864242 | 133.81689 | 133.81689 | 16343.0 |
| 2021-05-16 23:00:00 | ZN | Futures | 133.81689 | 133.89581 | 133.81689 | 133.880026 | 13162.0 |
> showing 36 of 389 rows — these rows as CSV