PREVIEW / futures_1hour / 2018-05-13
file: by_date/futures_1hour/2018/2018-05-13.parquet size: 15 KB rows: 294
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-13 18:00:00 | ES | Futures | 2977.15 | 2986.71 | 2977.15 | 2985.07 | 9993.0 |
| 2018-05-13 19:00:00 | ES | Futures | 2985.07 | 2987.25 | 2984.8 | 2986.98 | 3814.0 |
| 2018-05-13 20:00:00 | ES | Futures | 2986.71 | 2987.8 | 2986.16 | 2987.8 | 6288.0 |
| 2018-05-13 21:00:00 | ES | Futures | 2987.52 | 2989.43 | 2986.71 | 2988.89 | 6168.0 |
| 2018-05-13 22:00:00 | ES | Futures | 2989.16 | 2990.8 | 2988.62 | 2989.43 | 5707.0 |
| 2018-05-13 23:00:00 | ES | Futures | 2989.43 | 2990.53 | 2988.07 | 2989.71 | 3044.0 |
| 2018-05-13 18:00:00 | NQ | Futures | 8225.55 | 8254.51 | 8224.96 | 8244.46 | 2577.0 |
| 2018-05-13 19:00:00 | NQ | Futures | 8244.16 | 8255.99 | 8243.87 | 8254.21 | 1305.0 |
| 2018-05-13 20:00:00 | NQ | Futures | 8254.51 | 8261.01 | 8254.51 | 8260.12 | 2519.0 |
| 2018-05-13 21:00:00 | NQ | Futures | 8259.83 | 8263.67 | 8256.28 | 8261.6 | 1901.0 |
| 2018-05-13 22:00:00 | NQ | Futures | 8261.9 | 8266.33 | 8260.71 | 8263.97 | 1207.0 |
| 2018-05-13 23:00:00 | NQ | Futures | 8263.67 | 8264.56 | 8257.76 | 8261.01 | 1201.0 |
| 2018-05-13 18:00:00 | YM | Futures | 26945.3 | 27036.5 | 26945.3 | 27020.3 | 2492.0 |
| 2018-05-13 19:00:00 | YM | Futures | 27022.4 | 27042.0 | 27018.1 | 27033.3 | 846.0 |
| 2018-05-13 20:00:00 | YM | Futures | 27035.5 | 27059.4 | 27033.3 | 27055.0 | 2021.0 |
| 2018-05-13 21:00:00 | YM | Futures | 27055.0 | 27067.0 | 27046.3 | 27062.6 | 1269.0 |
| 2018-05-13 22:00:00 | YM | Futures | 27063.7 | 27081.1 | 27059.4 | 27072.4 | 1802.0 |
| 2018-05-13 23:00:00 | YM | Futures | 27072.4 | 27075.6 | 27060.4 | 27070.2 | 888.0 |
| 2018-05-13 18:00:00 | CL | Futures | 63.05 | 63.19 | 62.94 | 63.15 | 4940.0 |
| 2018-05-13 19:00:00 | CL | Futures | 63.15 | 63.17 | 63.09 | 63.15 | 1583.0 |
| 2018-05-13 20:00:00 | CL | Futures | 63.15 | 63.23 | 63.12 | 63.21 | 4292.0 |
| 2018-05-13 21:00:00 | CL | Futures | 63.21 | 63.21 | 62.86 | 63.01 | 12004.0 |
| 2018-05-13 22:00:00 | CL | Futures | 63.01 | 63.05 | 62.95 | 62.99 | 4913.0 |
| 2018-05-13 23:00:00 | CL | Futures | 62.99 | 63.0 | 62.96 | 62.97 | 2263.0 |
| 2018-05-13 18:00:00 | GC | Futures | 1736.9 | 1738.2 | 1736.4 | 1737.9 | 1610.0 |
| 2018-05-13 19:00:00 | GC | Futures | 1737.9 | 1739.6 | 1737.6 | 1739.4 | 2282.0 |
| 2018-05-13 20:00:00 | GC | Futures | 1739.3 | 1742.3 | 1738.9 | 1741.9 | 7593.0 |
| 2018-05-13 21:00:00 | GC | Futures | 1742.1 | 1742.3 | 1740.6 | 1740.9 | 5799.0 |
| 2018-05-13 22:00:00 | GC | Futures | 1740.9 | 1741.1 | 1739.4 | 1740.4 | 4747.0 |
| 2018-05-13 23:00:00 | GC | Futures | 1740.5 | 1740.9 | 1739.3 | 1739.6 | 4353.0 |
| 2018-05-13 18:00:00 | ZN | Futures | 119.742377 | 119.75805 | 119.695358 | 119.726704 | 4641.0 |
| 2018-05-13 19:00:00 | ZN | Futures | 119.726704 | 119.742377 | 119.711031 | 119.726704 | 2585.0 |
| 2018-05-13 20:00:00 | ZN | Futures | 119.726704 | 119.805069 | 119.711031 | 119.789396 | 15370.0 |
| 2018-05-13 21:00:00 | ZN | Futures | 119.789396 | 119.836415 | 119.789396 | 119.820742 | 5830.0 |
| 2018-05-13 22:00:00 | ZN | Futures | 119.820742 | 119.820742 | 119.789396 | 119.805069 | 2666.0 |
| 2018-05-13 23:00:00 | ZN | Futures | 119.805069 | 119.836415 | 119.805069 | 119.805069 | 5426.0 |
> showing 36 of 294 rows — these rows as CSV