PREVIEW / futures_1hour / 2023-08-13
file: by_date/futures_1hour/2023/2023-08-13.parquet size: 19 KB rows: 417
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 |
|---|---|---|---|---|---|---|---|
| 2023-08-13 18:00:00 | ES | Futures | 4924.73 | 4931.87 | 4922.54 | 4929.68 | 8375.0 |
| 2023-08-13 19:00:00 | ES | Futures | 4929.68 | 4931.6 | 4927.48 | 4929.13 | 3350.0 |
| 2023-08-13 20:00:00 | ES | Futures | 4929.4 | 4930.77 | 4921.71 | 4922.54 | 10242.0 |
| 2023-08-13 21:00:00 | ES | Futures | 4922.54 | 4924.73 | 4914.03 | 4919.24 | 14833.0 |
| 2023-08-13 22:00:00 | ES | Futures | 4919.24 | 4919.52 | 4908.54 | 4909.64 | 12829.0 |
| 2023-08-13 23:00:00 | ES | Futures | 4909.36 | 4911.56 | 4902.77 | 4909.09 | 12648.0 |
| 2023-08-13 18:00:00 | NQ | Futures | 16803.57 | 16850.58 | 16799.4 | 16842.51 | 5701.0 |
| 2023-08-13 19:00:00 | NQ | Futures | 16842.51 | 16848.63 | 16832.77 | 16841.4 | 2366.0 |
| 2023-08-13 20:00:00 | NQ | Futures | 16841.4 | 16853.63 | 16809.97 | 16812.75 | 6494.0 |
| 2023-08-13 21:00:00 | NQ | Futures | 16812.47 | 16820.26 | 16764.63 | 16791.89 | 9180.0 |
| 2023-08-13 22:00:00 | NQ | Futures | 16791.89 | 16793.84 | 16737.65 | 16741.83 | 8979.0 |
| 2023-08-13 23:00:00 | NQ | Futures | 16741.27 | 16751.28 | 16710.95 | 16744.05 | 7814.0 |
| 2023-08-13 18:00:00 | YM | Futures | 38772.4 | 38799.8 | 38749.4 | 38771.3 | 1124.0 |
| 2023-08-13 19:00:00 | YM | Futures | 38770.2 | 38788.9 | 38754.9 | 38770.2 | 936.0 |
| 2023-08-13 20:00:00 | YM | Futures | 38770.2 | 38784.5 | 38726.4 | 38735.2 | 1473.0 |
| 2023-08-13 21:00:00 | YM | Futures | 38734.1 | 38751.6 | 38684.8 | 38716.6 | 1963.0 |
| 2023-08-13 22:00:00 | YM | Futures | 38716.6 | 38719.9 | 38646.5 | 38653.0 | 1537.0 |
| 2023-08-13 23:00:00 | YM | Futures | 38651.9 | 38669.5 | 38603.7 | 38647.5 | 1950.0 |
| 2023-08-13 18:00:00 | CL | Futures | 67.57 | 67.58 | 67.32 | 67.33 | 2163.0 |
| 2023-08-13 19:00:00 | CL | Futures | 67.33 | 67.43 | 67.29 | 67.41 | 1013.0 |
| 2023-08-13 20:00:00 | CL | Futures | 67.42 | 67.48 | 67.39 | 67.42 | 1168.0 |
| 2023-08-13 21:00:00 | CL | Futures | 67.4 | 67.57 | 67.3 | 67.53 | 2918.0 |
| 2023-08-13 22:00:00 | CL | Futures | 67.53 | 67.57 | 67.17 | 67.18 | 2781.0 |
| 2023-08-13 23:00:00 | CL | Futures | 67.18 | 67.18 | 67.02 | 67.07 | 2924.0 |
| 2023-08-13 18:00:00 | GC | Futures | 2173.2 | 2174.7 | 2172.2 | 2173.2 | 1405.0 |
| 2023-08-13 19:00:00 | GC | Futures | 2173.0 | 2174.1 | 2171.8 | 2173.2 | 1488.0 |
| 2023-08-13 20:00:00 | GC | Futures | 2173.2 | 2173.3 | 2169.7 | 2170.3 | 2738.0 |
| 2023-08-13 21:00:00 | GC | Futures | 2170.3 | 2172.5 | 2169.4 | 2170.8 | 4288.0 |
| 2023-08-13 22:00:00 | GC | Futures | 2170.7 | 2172.0 | 2169.4 | 2171.2 | 1389.0 |
| 2023-08-13 23:00:00 | GC | Futures | 2171.2 | 2173.2 | 2170.6 | 2172.0 | 1714.0 |
| 2023-08-13 18:00:00 | ZN | Futures | 112.340087 | 112.340087 | 112.117032 | 112.276357 | 21934.0 |
| 2023-08-13 19:00:00 | ZN | Futures | 112.29229 | 112.308222 | 112.260425 | 112.276357 | 4546.0 |
| 2023-08-13 20:00:00 | ZN | Futures | 112.29229 | 112.308222 | 112.196695 | 112.260425 | 17345.0 |
| 2023-08-13 21:00:00 | ZN | Futures | 112.260425 | 112.340087 | 112.212627 | 112.244492 | 14677.0 |
| 2023-08-13 22:00:00 | ZN | Futures | 112.244492 | 112.29229 | 112.22856 | 112.276357 | 8193.0 |
| 2023-08-13 23:00:00 | ZN | Futures | 112.276357 | 112.340087 | 112.260425 | 112.324155 | 8923.0 |
> showing 36 of 417 rows — these rows as CSV