PREVIEW / futures_1hour / 2018-05-20
file: by_date/futures_1hour/2018/2018-05-20.parquet size: 15 KB rows: 301
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 |
|---|---|---|---|---|---|---|---|
| 2018-05-20 18:00:00 | ES | Futures | 2978.79 | 2986.98 | 2978.25 | 2978.79 | 20835.0 |
| 2018-05-20 19:00:00 | ES | Futures | 2978.52 | 2981.52 | 2978.52 | 2980.16 | 5477.0 |
| 2018-05-20 20:00:00 | ES | Futures | 2980.16 | 2981.79 | 2979.34 | 2980.43 | 4407.0 |
| 2018-05-20 21:00:00 | ES | Futures | 2980.16 | 2980.97 | 2978.79 | 2979.61 | 7086.0 |
| 2018-05-20 22:00:00 | ES | Futures | 2979.61 | 2980.97 | 2979.34 | 2980.16 | 3040.0 |
| 2018-05-20 23:00:00 | ES | Futures | 2979.88 | 2980.7 | 2979.61 | 2979.88 | 1853.0 |
| 2018-05-20 18:00:00 | NQ | Futures | 8179.15 | 8213.13 | 8179.15 | 8182.1 | 6193.0 |
| 2018-05-20 19:00:00 | NQ | Futures | 8182.1 | 8195.11 | 8181.81 | 8193.92 | 1556.0 |
| 2018-05-20 20:00:00 | NQ | Futures | 8193.33 | 8198.06 | 8185.65 | 8191.56 | 1681.0 |
| 2018-05-20 21:00:00 | NQ | Futures | 8191.86 | 8196.58 | 8189.2 | 8193.33 | 1628.0 |
| 2018-05-20 22:00:00 | NQ | Futures | 8193.63 | 8196.58 | 8192.45 | 8193.63 | 900.0 |
| 2018-05-20 23:00:00 | NQ | Futures | 8193.63 | 8194.81 | 8192.15 | 8192.45 | 423.0 |
| 2018-05-20 18:00:00 | YM | Futures | 26992.0 | 27113.7 | 26992.0 | 27039.8 | 3595.0 |
| 2018-05-20 19:00:00 | YM | Futures | 27038.7 | 27068.0 | 27035.5 | 27052.8 | 1378.0 |
| 2018-05-20 20:00:00 | YM | Futures | 27053.9 | 27067.0 | 27047.4 | 27060.4 | 1145.0 |
| 2018-05-20 21:00:00 | YM | Futures | 27061.5 | 27071.3 | 27043.1 | 27062.6 | 2253.0 |
| 2018-05-20 22:00:00 | YM | Futures | 27063.7 | 27080.0 | 27063.7 | 27074.6 | 1306.0 |
| 2018-05-20 23:00:00 | YM | Futures | 27073.5 | 27077.8 | 27069.1 | 27072.4 | 686.0 |
| 2018-05-20 18:00:00 | CL | Futures | 63.93 | 64.39 | 63.85 | 64.18 | 6161.0 |
| 2018-05-20 19:00:00 | CL | Futures | 64.17 | 64.21 | 64.1 | 64.17 | 2832.0 |
| 2018-05-20 20:00:00 | CL | Futures | 64.17 | 64.2 | 64.13 | 64.18 | 2938.0 |
| 2018-05-20 21:00:00 | CL | Futures | 64.19 | 64.34 | 64.19 | 64.34 | 7879.0 |
| 2018-05-20 22:00:00 | CL | Futures | 64.33 | 64.34 | 64.25 | 64.29 | 3451.0 |
| 2018-05-20 23:00:00 | CL | Futures | 64.28 | 64.31 | 64.25 | 64.25 | 2942.0 |
| 2018-05-20 18:00:00 | GC | Futures | 1700.0 | 1701.5 | 1698.9 | 1699.6 | 2620.0 |
| 2018-05-20 19:00:00 | GC | Futures | 1699.8 | 1701.4 | 1699.2 | 1700.6 | 2967.0 |
| 2018-05-20 20:00:00 | GC | Futures | 1700.4 | 1700.6 | 1697.0 | 1698.5 | 9381.0 |
| 2018-05-20 21:00:00 | GC | Futures | 1698.5 | 1699.8 | 1697.9 | 1698.7 | 6725.0 |
| 2018-05-20 22:00:00 | GC | Futures | 1698.7 | 1698.9 | 1697.3 | 1697.5 | 7027.0 |
| 2018-05-20 23:00:00 | GC | Futures | 1697.4 | 1697.8 | 1696.4 | 1696.6 | 4975.0 |
| 2018-05-20 18:00:00 | ZN | Futures | 119.084107 | 119.09978 | 119.021415 | 119.068434 | 27640.0 |
| 2018-05-20 19:00:00 | ZN | Futures | 119.084107 | 119.131127 | 119.068434 | 119.084107 | 13614.0 |
| 2018-05-20 20:00:00 | ZN | Futures | 119.09978 | 119.178146 | 119.068434 | 119.1468 | 24540.0 |
| 2018-05-20 21:00:00 | ZN | Futures | 119.1468 | 119.225165 | 119.131127 | 119.193819 | 26434.0 |
| 2018-05-20 22:00:00 | ZN | Futures | 119.209492 | 119.240838 | 119.193819 | 119.209492 | 15116.0 |
| 2018-05-20 23:00:00 | ZN | Futures | 119.209492 | 119.225165 | 119.193819 | 119.193819 | 5672.0 |
> showing 36 of 301 rows — these rows as CSV