PREVIEW / futures_1hour / 2021-01-17
file: by_date/futures_1hour/2021/2021-01-17.parquet size: 17 KB rows: 349
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-17 18:00:00 | ES | Futures | 4210.0 | 4221.22 | 4206.07 | 4209.72 | 13921.0 |
| 2021-01-17 19:00:00 | ES | Futures | 4209.43 | 4218.14 | 4199.33 | 4217.57 | 15213.0 |
| 2021-01-17 20:00:00 | ES | Futures | 4217.57 | 4218.7 | 4208.59 | 4213.64 | 10673.0 |
| 2021-01-17 21:00:00 | ES | Futures | 4213.64 | 4216.45 | 4210.0 | 4213.93 | 7499.0 |
| 2021-01-17 22:00:00 | ES | Futures | 4214.21 | 4216.17 | 4210.0 | 4214.77 | 4449.0 |
| 2021-01-17 23:00:00 | ES | Futures | 4214.77 | 4215.33 | 4210.56 | 4214.49 | 3024.0 |
| 2021-01-17 18:00:00 | NQ | Futures | 14789.2 | 14814.38 | 14741.44 | 14757.65 | 6670.0 |
| 2021-01-17 19:00:00 | NQ | Futures | 14756.2 | 14792.09 | 14734.49 | 14790.35 | 5851.0 |
| 2021-01-17 20:00:00 | NQ | Futures | 14790.35 | 14795.85 | 14756.78 | 14774.15 | 4728.0 |
| 2021-01-17 21:00:00 | NQ | Futures | 14774.15 | 14785.72 | 14768.36 | 14780.51 | 2174.0 |
| 2021-01-17 22:00:00 | NQ | Futures | 14779.93 | 14784.28 | 14762.86 | 14779.07 | 1982.0 |
| 2021-01-17 23:00:00 | NQ | Futures | 14779.35 | 14783.41 | 14769.22 | 14780.51 | 912.0 |
| 2021-01-17 18:00:00 | YM | Futures | 33972.4 | 34084.5 | 33969.1 | 34006.8 | 2512.0 |
| 2021-01-17 19:00:00 | YM | Futures | 34009.0 | 34071.1 | 33946.9 | 34066.7 | 2851.0 |
| 2021-01-17 20:00:00 | YM | Futures | 34068.9 | 34075.6 | 33996.8 | 34040.1 | 2263.0 |
| 2021-01-17 21:00:00 | YM | Futures | 34040.1 | 34062.3 | 34010.1 | 34035.7 | 1473.0 |
| 2021-01-17 22:00:00 | YM | Futures | 34034.5 | 34051.2 | 34012.4 | 34036.8 | 798.0 |
| 2021-01-17 23:00:00 | YM | Futures | 34036.8 | 34042.3 | 34007.9 | 34029.0 | 601.0 |
| 2021-01-17 18:00:00 | CL | Futures | 35.19 | 35.45 | 35.16 | 35.33 | 5543.0 |
| 2021-01-17 19:00:00 | CL | Futures | 35.34 | 35.39 | 35.27 | 35.38 | 3593.0 |
| 2021-01-17 20:00:00 | CL | Futures | 35.38 | 35.4 | 35.07 | 35.17 | 6760.0 |
| 2021-01-17 21:00:00 | CL | Futures | 35.16 | 35.26 | 35.14 | 35.23 | 3661.0 |
| 2021-01-17 22:00:00 | CL | Futures | 35.23 | 35.23 | 35.16 | 35.18 | 2042.0 |
| 2021-01-17 23:00:00 | CL | Futures | 35.19 | 35.23 | 35.15 | 35.23 | 1360.0 |
| 2021-01-17 18:00:00 | GC | Futures | 2216.5 | 2217.9 | 2182.6 | 2193.9 | 11427.0 |
| 2021-01-17 19:00:00 | GC | Futures | 2193.9 | 2207.4 | 2193.2 | 2205.7 | 6136.0 |
| 2021-01-17 20:00:00 | GC | Futures | 2205.9 | 2212.9 | 2203.0 | 2210.8 | 6300.0 |
| 2021-01-17 21:00:00 | GC | Futures | 2210.7 | 2219.8 | 2209.8 | 2215.0 | 5686.0 |
| 2021-01-17 22:00:00 | GC | Futures | 2215.0 | 2216.0 | 2212.5 | 2214.4 | 1919.0 |
| 2021-01-17 23:00:00 | GC | Futures | 2214.3 | 2215.6 | 2212.6 | 2215.3 | 1550.0 |
| 2021-01-17 18:00:00 | ZN | Futures | 137.179337 | 137.241954 | 137.163682 | 137.194991 | 12001.0 |
| 2021-01-17 19:00:00 | ZN | Futures | 137.179337 | 137.210645 | 137.148028 | 137.163682 | 9106.0 |
| 2021-01-17 20:00:00 | ZN | Futures | 137.179337 | 137.194991 | 137.163682 | 137.194991 | 6401.0 |
| 2021-01-17 21:00:00 | ZN | Futures | 137.179337 | 137.210645 | 137.179337 | 137.194991 | 6831.0 |
| 2021-01-17 22:00:00 | ZN | Futures | 137.179337 | 137.210645 | 137.179337 | 137.194991 | 5537.0 |
| 2021-01-17 23:00:00 | ZN | Futures | 137.210645 | 137.2263 | 137.194991 | 137.2263 | 3967.0 |
> showing 36 of 349 rows — these rows as CSV