PREVIEW / futures_1hour / 2021-02-14
file: by_date/futures_1hour/2021/2021-02-14.parquet size: 18 KB rows: 372
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-02-14 18:00:00 | ES | Futures | 4419.37 | 4423.3 | 4417.41 | 4419.37 | 9698.0 |
| 2021-02-14 19:00:00 | ES | Futures | 4419.37 | 4430.6 | 4418.53 | 4427.51 | 11645.0 |
| 2021-02-14 20:00:00 | ES | Futures | 4427.23 | 4429.76 | 4425.27 | 4427.79 | 4709.0 |
| 2021-02-14 21:00:00 | ES | Futures | 4427.79 | 4431.16 | 4427.79 | 4428.63 | 3789.0 |
| 2021-02-14 22:00:00 | ES | Futures | 4428.63 | 4432.28 | 4427.51 | 4431.16 | 3525.0 |
| 2021-02-14 23:00:00 | ES | Futures | 4431.44 | 4433.69 | 4429.48 | 4430.32 | 4056.0 |
| 2021-02-14 18:00:00 | NQ | Futures | 16010.9 | 16027.68 | 15988.32 | 16006.84 | 3527.0 |
| 2021-02-14 19:00:00 | NQ | Futures | 16006.26 | 16049.97 | 16003.37 | 16043.89 | 5330.0 |
| 2021-02-14 20:00:00 | NQ | Futures | 16043.6 | 16054.02 | 16030.58 | 16038.1 | 2955.0 |
| 2021-02-14 21:00:00 | NQ | Futures | 16038.1 | 16043.31 | 16031.16 | 16032.02 | 1985.0 |
| 2021-02-14 22:00:00 | NQ | Futures | 16032.31 | 16038.97 | 16030.0 | 16036.37 | 1907.0 |
| 2021-02-14 23:00:00 | NQ | Futures | 16036.37 | 16042.73 | 16032.31 | 16034.92 | 1494.0 |
| 2021-02-14 18:00:00 | YM | Futures | 34856.5 | 34907.5 | 34853.1 | 34866.4 | 1826.0 |
| 2021-02-14 19:00:00 | YM | Futures | 34866.4 | 34962.9 | 34863.1 | 34929.7 | 2861.0 |
| 2021-02-14 20:00:00 | YM | Futures | 34930.8 | 34951.8 | 34927.4 | 34950.7 | 1066.0 |
| 2021-02-14 21:00:00 | YM | Futures | 34950.7 | 34979.6 | 34947.4 | 34958.5 | 1218.0 |
| 2021-02-14 22:00:00 | YM | Futures | 34958.5 | 34989.6 | 34949.6 | 34981.8 | 1081.0 |
| 2021-02-14 23:00:00 | YM | Futures | 34982.9 | 35007.3 | 34974.0 | 34979.6 | 1103.0 |
| 2021-02-14 18:00:00 | CL | Futures | 40.58 | 41.06 | 40.55 | 40.83 | 2683.0 |
| 2021-02-14 19:00:00 | CL | Futures | 40.83 | 40.94 | 40.78 | 40.9 | 859.0 |
| 2021-02-14 20:00:00 | CL | Futures | 40.9 | 41.2 | 40.9 | 41.14 | 2381.0 |
| 2021-02-14 21:00:00 | CL | Futures | 41.15 | 41.22 | 41.04 | 41.12 | 1858.0 |
| 2021-02-14 22:00:00 | CL | Futures | 41.11 | 41.15 | 41.02 | 41.12 | 943.0 |
| 2021-02-14 23:00:00 | CL | Futures | 41.13 | 41.15 | 41.08 | 41.1 | 499.0 |
| 2021-02-14 18:00:00 | GC | Futures | 2208.7 | 2209.1 | 2201.6 | 2202.5 | 2713.0 |
| 2021-02-14 19:00:00 | GC | Futures | 2202.8 | 2205.7 | 2201.4 | 2204.9 | 2240.0 |
| 2021-02-14 20:00:00 | GC | Futures | 2205.2 | 2210.0 | 2203.4 | 2209.8 | 2991.0 |
| 2021-02-14 21:00:00 | GC | Futures | 2209.9 | 2209.9 | 2206.4 | 2207.5 | 2001.0 |
| 2021-02-14 22:00:00 | GC | Futures | 2207.5 | 2209.4 | 2205.9 | 2208.8 | 1562.0 |
| 2021-02-14 23:00:00 | GC | Futures | 2208.9 | 2209.3 | 2203.0 | 2204.3 | 2283.0 |
| 2021-02-14 18:00:00 | ZN | Futures | 136.709705 | 136.72536 | 136.537507 | 136.58447 | 62296.0 |
| 2021-02-14 19:00:00 | ZN | Futures | 136.58447 | 136.600125 | 136.537507 | 136.600125 | 23116.0 |
| 2021-02-14 20:00:00 | ZN | Futures | 136.600125 | 136.615779 | 136.568816 | 136.58447 | 6812.0 |
| 2021-02-14 21:00:00 | ZN | Futures | 136.58447 | 136.58447 | 136.506198 | 136.521853 | 16821.0 |
| 2021-02-14 22:00:00 | ZN | Futures | 136.521853 | 136.537507 | 136.459235 | 136.490544 | 29774.0 |
| 2021-02-14 23:00:00 | ZN | Futures | 136.474889 | 136.474889 | 136.443581 | 136.474889 | 14443.0 |
> showing 36 of 372 rows — these rows as CSV