PREVIEW / futures_1hour / 2019-04-28
file: by_date/futures_1hour/2019/2019-04-28.parquet size: 15 KB rows: 329
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-04-28 18:00:00 | ES | Futures | 3187.35 | 3190.6 | 3187.35 | 3189.52 | 6019.0 |
| 2019-04-28 19:00:00 | ES | Futures | 3189.52 | 3189.79 | 3188.16 | 3188.7 | 3083.0 |
| 2019-04-28 20:00:00 | ES | Futures | 3188.7 | 3190.87 | 3188.43 | 3189.52 | 5511.0 |
| 2019-04-28 21:00:00 | ES | Futures | 3189.52 | 3191.42 | 3188.7 | 3189.25 | 5292.0 |
| 2019-04-28 22:00:00 | ES | Futures | 3189.52 | 3191.14 | 3189.25 | 3190.6 | 3569.0 |
| 2019-04-28 23:00:00 | ES | Futures | 3190.87 | 3191.14 | 3190.06 | 3190.33 | 3089.0 |
| 2019-04-28 18:00:00 | NQ | Futures | 9127.45 | 9136.19 | 9124.83 | 9127.16 | 2442.0 |
| 2019-04-28 19:00:00 | NQ | Futures | 9126.87 | 9129.78 | 9125.12 | 9126.0 | 1287.0 |
| 2019-04-28 20:00:00 | NQ | Futures | 9126.0 | 9134.73 | 9125.7 | 9128.91 | 2490.0 |
| 2019-04-28 21:00:00 | NQ | Futures | 9128.91 | 9134.73 | 9127.16 | 9128.91 | 3038.0 |
| 2019-04-28 22:00:00 | NQ | Futures | 9128.91 | 9134.15 | 9128.32 | 9132.98 | 2168.0 |
| 2019-04-28 23:00:00 | NQ | Futures | 9133.27 | 9137.64 | 9130.65 | 9135.02 | 2333.0 |
| 2019-04-28 18:00:00 | YM | Futures | 28823.2 | 28853.6 | 28822.1 | 28842.8 | 1401.0 |
| 2019-04-28 19:00:00 | YM | Futures | 28842.8 | 28844.9 | 28827.5 | 28834.1 | 683.0 |
| 2019-04-28 20:00:00 | YM | Futures | 28834.1 | 28861.2 | 28833.0 | 28847.1 | 1378.0 |
| 2019-04-28 21:00:00 | YM | Futures | 28847.1 | 28863.4 | 28836.2 | 28841.7 | 1264.0 |
| 2019-04-28 22:00:00 | YM | Futures | 28843.8 | 28858.0 | 28841.7 | 28855.8 | 901.0 |
| 2019-04-28 23:00:00 | YM | Futures | 28856.9 | 28862.3 | 28850.4 | 28856.9 | 614.0 |
| 2019-04-28 18:00:00 | CL | Futures | 56.28 | 56.34 | 56.16 | 56.22 | 6077.0 |
| 2019-04-28 19:00:00 | CL | Futures | 56.23 | 56.3 | 56.13 | 56.18 | 3289.0 |
| 2019-04-28 20:00:00 | CL | Futures | 56.17 | 56.29 | 56.17 | 56.26 | 3255.0 |
| 2019-04-28 21:00:00 | CL | Futures | 56.27 | 56.42 | 56.23 | 56.25 | 9982.0 |
| 2019-04-28 22:00:00 | CL | Futures | 56.24 | 56.33 | 56.21 | 56.3 | 4878.0 |
| 2019-04-28 23:00:00 | CL | Futures | 56.3 | 56.34 | 56.27 | 56.28 | 2942.0 |
| 2019-04-28 18:00:00 | GC | Futures | 1654.1 | 1654.3 | 1652.9 | 1653.1 | 1489.0 |
| 2019-04-28 19:00:00 | GC | Futures | 1653.1 | 1654.0 | 1652.7 | 1652.9 | 2377.0 |
| 2019-04-28 20:00:00 | GC | Futures | 1652.7 | 1653.4 | 1651.5 | 1651.8 | 3201.0 |
| 2019-04-28 21:00:00 | GC | Futures | 1651.7 | 1652.9 | 1651.6 | 1652.4 | 3519.0 |
| 2019-04-28 22:00:00 | GC | Futures | 1652.4 | 1653.6 | 1652.1 | 1653.5 | 4138.0 |
| 2019-04-28 23:00:00 | GC | Futures | 1653.5 | 1653.6 | 1652.4 | 1652.7 | 2966.0 |
| 2019-04-28 18:00:00 | ZN | Futures | 124.333682 | 124.349391 | 124.317974 | 124.333682 | 5528.0 |
| 2019-04-28 19:00:00 | ZN | Futures | 124.333682 | 124.349391 | 124.333682 | 124.349391 | 1393.0 |
| 2019-04-28 20:00:00 | ZN | Futures | 124.349391 | 124.349391 | 124.317974 | 124.333682 | 4326.0 |
| 2019-04-28 21:00:00 | ZN | Futures | 124.349391 | 124.349391 | 124.317974 | 124.333682 | 5201.0 |
| 2019-04-28 22:00:00 | ZN | Futures | 124.333682 | 124.349391 | 124.317974 | 124.349391 | 745.0 |
| 2019-04-28 23:00:00 | ZN | Futures | 124.333682 | 124.349391 | 124.317974 | 124.333682 | 3390.0 |
> showing 36 of 329 rows — these rows as CSV