PREVIEW / futures_30min / 2019-02-17
file: by_date/futures_30min/2019/2019-02-17.parquet size: 21 KB rows: 572
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-02-17 18:00:00 | ES | Futures | 3016.76 | 3022.74 | 3015.95 | 3016.22 | 12087.0 |
| 2019-02-17 18:30:00 | ES | Futures | 3016.22 | 3019.75 | 3016.22 | 3018.66 | 2178.0 |
| 2019-02-17 19:00:00 | ES | Futures | 3018.39 | 3018.66 | 3014.59 | 3014.86 | 5241.0 |
| 2019-02-17 19:30:00 | ES | Futures | 3014.86 | 3016.49 | 3013.77 | 3014.59 | 3085.0 |
| 2019-02-17 20:00:00 | ES | Futures | 3014.86 | 3018.12 | 3013.77 | 3015.13 | 5252.0 |
| 2019-02-17 20:30:00 | ES | Futures | 3015.4 | 3017.58 | 3014.32 | 3016.76 | 3113.0 |
| 2019-02-17 21:00:00 | ES | Futures | 3017.03 | 3018.12 | 3016.22 | 3017.85 | 2408.0 |
| 2019-02-17 21:30:00 | ES | Futures | 3017.85 | 3018.39 | 3017.03 | 3018.12 | 1347.0 |
| 2019-02-17 22:00:00 | ES | Futures | 3018.12 | 3020.56 | 3018.12 | 3018.93 | 2269.0 |
| 2019-02-17 22:30:00 | ES | Futures | 3018.66 | 3020.02 | 3017.58 | 3017.58 | 2110.0 |
| 2019-02-17 23:00:00 | ES | Futures | 3017.85 | 3018.12 | 3016.22 | 3017.03 | 1768.0 |
| 2019-02-17 23:30:00 | ES | Futures | 3017.03 | 3018.12 | 3016.49 | 3017.3 | 1083.0 |
| 2019-02-17 18:00:00 | NQ | Futures | 8255.81 | 8273.63 | 8249.67 | 8251.43 | 2825.0 |
| 2019-02-17 18:30:00 | NQ | Futures | 8251.43 | 8263.99 | 8249.97 | 8259.02 | 1074.0 |
| 2019-02-17 19:00:00 | NQ | Futures | 8259.02 | 8259.02 | 8247.34 | 8249.09 | 2098.0 |
| 2019-02-17 19:30:00 | NQ | Futures | 8248.5 | 8254.93 | 8246.75 | 8250.26 | 1835.0 |
| 2019-02-17 20:00:00 | NQ | Futures | 8250.26 | 8262.82 | 8248.21 | 8254.64 | 2722.0 |
| 2019-02-17 20:30:00 | NQ | Futures | 8254.64 | 8263.41 | 8252.01 | 8261.36 | 1593.0 |
| 2019-02-17 21:00:00 | NQ | Futures | 8261.95 | 8267.5 | 8256.1 | 8265.74 | 2255.0 |
| 2019-02-17 21:30:00 | NQ | Futures | 8265.45 | 8268.67 | 8264.28 | 8267.79 | 1076.0 |
| 2019-02-17 22:00:00 | NQ | Futures | 8267.79 | 8277.43 | 8266.91 | 8269.54 | 1596.0 |
| 2019-02-17 22:30:00 | NQ | Futures | 8269.54 | 8271.3 | 8263.41 | 8263.99 | 984.0 |
| 2019-02-17 23:00:00 | NQ | Futures | 8263.99 | 8266.04 | 8258.73 | 8261.95 | 1238.0 |
| 2019-02-17 23:30:00 | NQ | Futures | 8261.65 | 8265.74 | 8260.78 | 8262.24 | 764.0 |
| 2019-02-17 18:00:00 | YM | Futures | 28104.6 | 28174.1 | 28102.4 | 28113.3 | 1992.0 |
| 2019-02-17 18:30:00 | YM | Futures | 28112.2 | 28150.2 | 28110.0 | 28140.4 | 1063.0 |
| 2019-02-17 19:00:00 | YM | Futures | 28139.3 | 28139.3 | 28092.7 | 28100.3 | 1358.0 |
| 2019-02-17 19:30:00 | YM | Futures | 28099.2 | 28122.0 | 28089.4 | 28106.8 | 965.0 |
| 2019-02-17 20:00:00 | YM | Futures | 28105.7 | 28137.2 | 28091.6 | 28103.5 | 1621.0 |
| 2019-02-17 20:30:00 | YM | Futures | 28104.6 | 28129.6 | 28097.0 | 28125.2 | 950.0 |
| 2019-02-17 21:00:00 | YM | Futures | 28126.3 | 28138.3 | 28115.5 | 28130.7 | 704.0 |
| 2019-02-17 21:30:00 | YM | Futures | 28131.7 | 28138.3 | 28123.1 | 28132.8 | 472.0 |
| 2019-02-17 22:00:00 | YM | Futures | 28133.9 | 28158.9 | 28132.8 | 28144.8 | 857.0 |
| 2019-02-17 22:30:00 | YM | Futures | 28143.7 | 28157.8 | 28130.7 | 28130.7 | 694.0 |
| 2019-02-17 23:00:00 | YM | Futures | 28130.7 | 28133.9 | 28114.4 | 28122.0 | 634.0 |
| 2019-02-17 23:30:00 | YM | Futures | 28122.0 | 28133.9 | 28114.4 | 28131.7 | 769.0 |
| 2019-02-17 18:00:00 | CL | Futures | 50.59 | 50.81 | 50.55 | 50.67 | 3373.0 |
| 2019-02-17 18:30:00 | CL | Futures | 50.67 | 50.77 | 50.67 | 50.76 | 1176.0 |
| 2019-02-17 19:00:00 | CL | Futures | 50.75 | 50.75 | 50.66 | 50.74 | 1333.0 |
| 2019-02-17 19:30:00 | CL | Futures | 50.74 | 50.76 | 50.65 | 50.69 | 1527.0 |
| 2019-02-17 20:00:00 | CL | Futures | 50.69 | 50.93 | 50.65 | 50.72 | 9204.0 |
| 2019-02-17 20:30:00 | CL | Futures | 50.72 | 50.82 | 50.64 | 50.75 | 3678.0 |
| 2019-02-17 21:00:00 | CL | Futures | 50.75 | 50.76 | 50.56 | 50.65 | 4624.0 |
| 2019-02-17 21:30:00 | CL | Futures | 50.65 | 50.72 | 50.6 | 50.67 | 2800.0 |
| 2019-02-17 22:00:00 | CL | Futures | 50.68 | 50.73 | 50.61 | 50.64 | 2439.0 |
| 2019-02-17 22:30:00 | CL | Futures | 50.64 | 50.67 | 50.6 | 50.61 | 1480.0 |
| 2019-02-17 23:00:00 | CL | Futures | 50.6 | 50.66 | 50.59 | 50.65 | 1010.0 |
| 2019-02-17 23:30:00 | CL | Futures | 50.64 | 50.68 | 50.62 | 50.67 | 984.0 |
| 2019-02-17 18:00:00 | GC | Futures | 1708.6 | 1708.6 | 1707.0 | 1707.2 | 1314.0 |
| 2019-02-17 18:30:00 | GC | Futures | 1707.2 | 1707.9 | 1707.0 | 1707.7 | 1566.0 |
> showing 50 of 572 rows — these rows as CSV