PREVIEW / futures_30min / 2018-05-13
file: by_date/futures_30min/2018/2018-05-13.parquet size: 21 KB rows: 555
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.89 | 8519.0 |
| 2018-05-13 18:30:00 | ES | Futures | 2985.61 | 2986.71 | 2984.52 | 2985.07 | 1474.0 |
| 2018-05-13 19:00:00 | ES | Futures | 2985.07 | 2985.89 | 2984.8 | 2985.34 | 1393.0 |
| 2018-05-13 19:30:00 | ES | Futures | 2985.61 | 2987.25 | 2985.34 | 2986.98 | 2421.0 |
| 2018-05-13 20:00:00 | ES | Futures | 2986.71 | 2987.8 | 2986.16 | 2987.25 | 3712.0 |
| 2018-05-13 20:30:00 | ES | Futures | 2987.25 | 2987.8 | 2986.98 | 2987.8 | 2576.0 |
| 2018-05-13 21:00:00 | ES | Futures | 2987.52 | 2988.62 | 2986.98 | 2988.34 | 2856.0 |
| 2018-05-13 21:30:00 | ES | Futures | 2988.07 | 2989.43 | 2986.71 | 2988.89 | 3312.0 |
| 2018-05-13 22:00:00 | ES | Futures | 2989.16 | 2989.98 | 2988.62 | 2989.71 | 2093.0 |
| 2018-05-13 22:30:00 | ES | Futures | 2989.71 | 2990.8 | 2989.16 | 2989.43 | 3614.0 |
| 2018-05-13 23:00:00 | ES | Futures | 2989.43 | 2989.71 | 2988.07 | 2988.89 | 1209.0 |
| 2018-05-13 23:30:00 | ES | Futures | 2989.16 | 2990.53 | 2988.34 | 2989.71 | 1835.0 |
| 2018-05-13 18:00:00 | NQ | Futures | 8225.55 | 8254.51 | 8224.96 | 8248.3 | 2205.0 |
| 2018-05-13 18:30:00 | NQ | Futures | 8248.01 | 8250.08 | 8243.28 | 8244.46 | 372.0 |
| 2018-05-13 19:00:00 | NQ | Futures | 8244.16 | 8249.78 | 8243.87 | 8249.19 | 359.0 |
| 2018-05-13 19:30:00 | NQ | Futures | 8248.89 | 8255.99 | 8248.89 | 8254.21 | 946.0 |
| 2018-05-13 20:00:00 | NQ | Futures | 8254.51 | 8259.83 | 8254.51 | 8257.76 | 1406.0 |
| 2018-05-13 20:30:00 | NQ | Futures | 8258.05 | 8261.01 | 8257.17 | 8260.12 | 1113.0 |
| 2018-05-13 21:00:00 | NQ | Futures | 8259.83 | 8263.67 | 8257.46 | 8261.9 | 914.0 |
| 2018-05-13 21:30:00 | NQ | Futures | 8261.9 | 8262.78 | 8256.28 | 8261.6 | 987.0 |
| 2018-05-13 22:00:00 | NQ | Futures | 8261.9 | 8264.56 | 8260.71 | 8263.37 | 668.0 |
| 2018-05-13 22:30:00 | NQ | Futures | 8263.37 | 8266.33 | 8262.19 | 8263.97 | 539.0 |
| 2018-05-13 23:00:00 | NQ | Futures | 8263.67 | 8264.56 | 8257.76 | 8260.12 | 718.0 |
| 2018-05-13 23:30:00 | NQ | Futures | 8260.42 | 8262.78 | 8257.76 | 8261.01 | 483.0 |
| 2018-05-13 18:00:00 | YM | Futures | 26945.3 | 27036.5 | 26945.3 | 27026.8 | 2079.0 |
| 2018-05-13 18:30:00 | YM | Futures | 27028.9 | 27032.2 | 27015.9 | 27020.3 | 413.0 |
| 2018-05-13 19:00:00 | YM | Futures | 27022.4 | 27030.0 | 27018.1 | 27023.5 | 279.0 |
| 2018-05-13 19:30:00 | YM | Futures | 27024.6 | 27042.0 | 27021.3 | 27033.3 | 567.0 |
| 2018-05-13 20:00:00 | YM | Futures | 27035.5 | 27051.8 | 27033.3 | 27045.2 | 1059.0 |
| 2018-05-13 20:30:00 | YM | Futures | 27046.3 | 27059.4 | 27043.1 | 27055.0 | 962.0 |
| 2018-05-13 21:00:00 | YM | Futures | 27055.0 | 27063.7 | 27046.3 | 27060.4 | 648.0 |
| 2018-05-13 21:30:00 | YM | Futures | 27059.4 | 27067.0 | 27046.3 | 27062.6 | 621.0 |
| 2018-05-13 22:00:00 | YM | Futures | 27063.7 | 27078.9 | 27059.4 | 27072.4 | 1396.0 |
| 2018-05-13 22:30:00 | YM | Futures | 27073.5 | 27081.1 | 27067.0 | 27072.4 | 406.0 |
| 2018-05-13 23:00:00 | YM | Futures | 27072.4 | 27073.5 | 27060.4 | 27064.8 | 523.0 |
| 2018-05-13 23:30:00 | YM | Futures | 27065.9 | 27075.6 | 27060.4 | 27070.2 | 365.0 |
| 2018-05-13 18:00:00 | CL | Futures | 63.05 | 63.1 | 62.94 | 63.08 | 3043.0 |
| 2018-05-13 18:30:00 | CL | Futures | 63.08 | 63.19 | 63.07 | 63.15 | 1897.0 |
| 2018-05-13 19:00:00 | CL | Futures | 63.15 | 63.17 | 63.13 | 63.17 | 549.0 |
| 2018-05-13 19:30:00 | CL | Futures | 63.17 | 63.17 | 63.09 | 63.15 | 1034.0 |
| 2018-05-13 20:00:00 | CL | Futures | 63.15 | 63.2 | 63.12 | 63.15 | 2130.0 |
| 2018-05-13 20:30:00 | CL | Futures | 63.14 | 63.23 | 63.13 | 63.21 | 2162.0 |
| 2018-05-13 21:00:00 | CL | Futures | 63.21 | 63.21 | 63.02 | 63.05 | 4934.0 |
| 2018-05-13 21:30:00 | CL | Futures | 63.04 | 63.05 | 62.86 | 63.01 | 7070.0 |
| 2018-05-13 22:00:00 | CL | Futures | 63.01 | 63.03 | 62.95 | 63.03 | 2743.0 |
| 2018-05-13 22:30:00 | CL | Futures | 63.02 | 63.05 | 62.97 | 62.99 | 2170.0 |
| 2018-05-13 23:00:00 | CL | Futures | 62.99 | 63.0 | 62.96 | 62.97 | 1159.0 |
| 2018-05-13 23:30:00 | CL | Futures | 62.98 | 62.99 | 62.96 | 62.97 | 1104.0 |
| 2018-05-13 18:00:00 | GC | Futures | 1736.9 | 1737.7 | 1736.4 | 1737.7 | 1054.0 |
| 2018-05-13 18:30:00 | GC | Futures | 1737.6 | 1738.2 | 1737.5 | 1737.9 | 556.0 |
> showing 50 of 555 rows — these rows as CSV