PREVIEW / futures_1hour / 2019-03-17
file: by_date/futures_1hour/2019/2019-03-17.parquet size: 16 KB rows: 333
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 |
|---|---|---|---|---|---|---|---|
| 2019-03-17 18:00:00 | ES | Futures | 3065.62 | 3067.52 | 3064.0 | 3064.54 | 4822.0 |
| 2019-03-17 19:00:00 | ES | Futures | 3064.81 | 3066.44 | 3063.73 | 3065.35 | 4896.0 |
| 2019-03-17 20:00:00 | ES | Futures | 3065.35 | 3066.71 | 3064.0 | 3064.0 | 6439.0 |
| 2019-03-17 21:00:00 | ES | Futures | 3064.0 | 3064.54 | 3062.37 | 3064.0 | 6590.0 |
| 2019-03-17 22:00:00 | ES | Futures | 3064.27 | 3070.23 | 3064.0 | 3069.96 | 6845.0 |
| 2019-03-17 23:00:00 | ES | Futures | 3069.69 | 3070.23 | 3067.79 | 3069.69 | 4601.0 |
| 2019-03-17 18:00:00 | NQ | Futures | 8546.01 | 8551.25 | 8540.19 | 8541.06 | 2094.0 |
| 2019-03-17 19:00:00 | NQ | Futures | 8541.06 | 8548.92 | 8537.86 | 8545.43 | 1725.0 |
| 2019-03-17 20:00:00 | NQ | Futures | 8545.72 | 8549.22 | 8539.61 | 8539.9 | 2161.0 |
| 2019-03-17 21:00:00 | NQ | Futures | 8539.9 | 8541.94 | 8534.95 | 8540.19 | 3011.0 |
| 2019-03-17 22:00:00 | NQ | Futures | 8540.19 | 8559.7 | 8539.9 | 8557.66 | 3638.0 |
| 2019-03-17 23:00:00 | NQ | Futures | 8557.95 | 8559.11 | 8550.96 | 8556.49 | 2170.0 |
| 2019-03-17 18:00:00 | YM | Futures | 28129.2 | 28154.3 | 28116.2 | 28120.5 | 1058.0 |
| 2019-03-17 19:00:00 | YM | Futures | 28123.8 | 28146.7 | 28112.9 | 28134.7 | 1061.0 |
| 2019-03-17 20:00:00 | YM | Futures | 28135.8 | 28148.8 | 28121.6 | 28122.7 | 1286.0 |
| 2019-03-17 21:00:00 | YM | Futures | 28122.7 | 28129.2 | 28103.1 | 28126.0 | 1816.0 |
| 2019-03-17 22:00:00 | YM | Futures | 28124.9 | 28186.9 | 28124.9 | 28180.4 | 1788.0 |
| 2019-03-17 23:00:00 | YM | Futures | 28181.5 | 28184.7 | 28160.8 | 28177.1 | 1232.0 |
| 2019-03-17 18:00:00 | CL | Futures | 52.64 | 52.75 | 52.6 | 52.69 | 2396.0 |
| 2019-03-17 19:00:00 | CL | Futures | 52.7 | 52.7 | 52.63 | 52.65 | 1133.0 |
| 2019-03-17 20:00:00 | CL | Futures | 52.64 | 52.65 | 52.53 | 52.54 | 2826.0 |
| 2019-03-17 21:00:00 | CL | Futures | 52.55 | 52.55 | 52.4 | 52.52 | 6156.0 |
| 2019-03-17 22:00:00 | CL | Futures | 52.51 | 52.62 | 52.49 | 52.61 | 3771.0 |
| 2019-03-17 23:00:00 | CL | Futures | 52.61 | 52.62 | 52.5 | 52.52 | 2464.0 |
| 2019-03-17 18:00:00 | GC | Futures | 1678.9 | 1679.6 | 1678.5 | 1679.2 | 1269.0 |
| 2019-03-17 19:00:00 | GC | Futures | 1679.2 | 1679.3 | 1676.9 | 1676.9 | 1975.0 |
| 2019-03-17 20:00:00 | GC | Futures | 1676.9 | 1677.3 | 1675.2 | 1675.3 | 5025.0 |
| 2019-03-17 21:00:00 | GC | Futures | 1675.2 | 1676.0 | 1673.8 | 1675.4 | 5424.0 |
| 2019-03-17 22:00:00 | GC | Futures | 1675.3 | 1675.3 | 1674.2 | 1674.9 | 4487.0 |
| 2019-03-17 23:00:00 | GC | Futures | 1674.9 | 1675.8 | 1674.2 | 1674.8 | 3382.0 |
| 2019-03-17 18:00:00 | ZN | Futures | 123.611086 | 123.626795 | 123.595377 | 123.626795 | 2859.0 |
| 2019-03-17 19:00:00 | ZN | Futures | 123.626795 | 123.626795 | 123.595377 | 123.595377 | 6010.0 |
| 2019-03-17 20:00:00 | ZN | Futures | 123.595377 | 123.611086 | 123.56396 | 123.579669 | 7507.0 |
| 2019-03-17 21:00:00 | ZN | Futures | 123.595377 | 123.611086 | 123.579669 | 123.579669 | 11132.0 |
| 2019-03-17 22:00:00 | ZN | Futures | 123.579669 | 123.595377 | 123.56396 | 123.56396 | 9882.0 |
| 2019-03-17 23:00:00 | ZN | Futures | 123.56396 | 123.579669 | 123.56396 | 123.56396 | 2443.0 |
> showing 36 of 333 rows — these rows as CSV