PREVIEW / futures_30min / 2016-03-13
file: by_date/futures_30min/2016/2016-03-13.parquet size: 20 KB rows: 529
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 |
|---|---|---|---|---|---|---|---|
| 2016-03-13 18:00:00 | ES | Futures | 2170.36 | 2172.24 | 2168.48 | 2171.17 | 1812.0 |
| 2016-03-13 18:30:00 | ES | Futures | 2170.9 | 2171.17 | 2168.21 | 2168.75 | 1111.0 |
| 2016-03-13 19:00:00 | ES | Futures | 2168.75 | 2169.83 | 2167.94 | 2168.75 | 1442.0 |
| 2016-03-13 19:30:00 | ES | Futures | 2169.02 | 2170.09 | 2167.68 | 2169.83 | 1424.0 |
| 2016-03-13 20:00:00 | ES | Futures | 2170.09 | 2170.36 | 2167.94 | 2167.94 | 920.0 |
| 2016-03-13 20:30:00 | ES | Futures | 2167.94 | 2169.56 | 2167.94 | 2169.29 | 957.0 |
| 2016-03-13 21:00:00 | ES | Futures | 2169.29 | 2170.63 | 2169.29 | 2169.83 | 1500.0 |
| 2016-03-13 21:30:00 | ES | Futures | 2169.56 | 2169.56 | 2166.87 | 2168.75 | 2004.0 |
| 2016-03-13 22:00:00 | ES | Futures | 2168.75 | 2169.56 | 2167.94 | 2169.29 | 386.0 |
| 2016-03-13 22:30:00 | ES | Futures | 2169.56 | 2171.17 | 2169.29 | 2170.63 | 1048.0 |
| 2016-03-13 23:00:00 | ES | Futures | 2170.36 | 2170.9 | 2169.83 | 2170.63 | 269.0 |
| 2016-03-13 23:30:00 | ES | Futures | 2170.36 | 2170.9 | 2168.48 | 2169.02 | 823.0 |
| 2016-03-13 18:00:00 | NQ | Futures | 5169.87 | 5175.22 | 5166.31 | 5173.14 | 124.0 |
| 2016-03-13 18:30:00 | NQ | Futures | 5171.36 | 5172.25 | 5165.71 | 5166.61 | 82.0 |
| 2016-03-13 19:00:00 | NQ | Futures | 5166.61 | 5168.68 | 5166.01 | 5167.2 | 116.0 |
| 2016-03-13 19:30:00 | NQ | Futures | 5166.31 | 5171.06 | 5163.93 | 5171.06 | 65.0 |
| 2016-03-13 20:00:00 | NQ | Futures | 5170.17 | 5170.47 | 5164.53 | 5165.12 | 61.0 |
| 2016-03-13 20:30:00 | NQ | Futures | 5164.82 | 5168.39 | 5164.53 | 5168.39 | 84.0 |
| 2016-03-13 21:00:00 | NQ | Futures | 5170.17 | 5172.25 | 5168.98 | 5169.87 | 121.0 |
| 2016-03-13 21:30:00 | NQ | Futures | 5168.98 | 5169.28 | 5162.75 | 5167.2 | 159.0 |
| 2016-03-13 22:00:00 | NQ | Futures | 5168.09 | 5170.47 | 5165.71 | 5169.57 | 60.0 |
| 2016-03-13 22:30:00 | NQ | Futures | 5170.47 | 5174.33 | 5170.47 | 5172.84 | 55.0 |
| 2016-03-13 23:00:00 | NQ | Futures | 5173.43 | 5173.43 | 5170.76 | 5170.76 | 18.0 |
| 2016-03-13 23:30:00 | NQ | Futures | 5172.54 | 5172.84 | 5166.01 | 5167.5 | 38.0 |
| 2016-03-13 18:00:00 | YM | Futures | 18295.1 | 18309.0 | 18280.1 | 18293.0 | 200.0 |
| 2016-03-13 18:30:00 | YM | Futures | 18296.2 | 18296.2 | 18279.0 | 18282.3 | 80.0 |
| 2016-03-13 19:00:00 | YM | Futures | 18280.1 | 18284.4 | 18279.0 | 18284.4 | 205.0 |
| 2016-03-13 19:30:00 | YM | Futures | 18284.4 | 18291.9 | 18275.8 | 18288.7 | 158.0 |
| 2016-03-13 20:00:00 | YM | Futures | 18289.8 | 18293.0 | 18274.8 | 18275.8 | 247.0 |
| 2016-03-13 20:30:00 | YM | Futures | 18278.0 | 18285.5 | 18273.7 | 18285.5 | 160.0 |
| 2016-03-13 21:00:00 | YM | Futures | 18286.5 | 18298.3 | 18286.5 | 18288.7 | 374.0 |
| 2016-03-13 21:30:00 | YM | Futures | 18288.7 | 18288.7 | 18269.4 | 18281.2 | 390.0 |
| 2016-03-13 22:00:00 | YM | Futures | 18282.3 | 18289.8 | 18275.8 | 18288.7 | 217.0 |
| 2016-03-13 22:30:00 | YM | Futures | 18290.8 | 18301.5 | 18288.7 | 18299.4 | 282.0 |
| 2016-03-13 23:00:00 | YM | Futures | 18301.5 | 18302.6 | 18291.9 | 18297.2 | 136.0 |
| 2016-03-13 23:30:00 | YM | Futures | 18298.3 | 18299.4 | 18282.3 | 18288.7 | 206.0 |
| 2016-03-13 18:00:00 | CL | Futures | 44.12 | 44.82 | 44.12 | 44.39 | 1206.0 |
| 2016-03-13 18:30:00 | CL | Futures | 44.38 | 44.38 | 44.18 | 44.23 | 750.0 |
| 2016-03-13 19:00:00 | CL | Futures | 44.23 | 44.46 | 44.23 | 44.43 | 1440.0 |
| 2016-03-13 19:30:00 | CL | Futures | 44.43 | 44.45 | 44.33 | 44.36 | 751.0 |
| 2016-03-13 20:00:00 | CL | Futures | 44.36 | 44.43 | 44.36 | 44.39 | 621.0 |
| 2016-03-13 20:30:00 | CL | Futures | 44.39 | 44.4 | 44.32 | 44.35 | 493.0 |
| 2016-03-13 21:00:00 | CL | Futures | 44.35 | 44.39 | 44.28 | 44.3 | 804.0 |
| 2016-03-13 21:30:00 | CL | Futures | 44.31 | 44.33 | 44.19 | 44.31 | 968.0 |
| 2016-03-13 22:00:00 | CL | Futures | 44.31 | 44.36 | 44.26 | 44.33 | 678.0 |
| 2016-03-13 22:30:00 | CL | Futures | 44.34 | 44.42 | 44.33 | 44.39 | 782.0 |
| 2016-03-13 23:00:00 | CL | Futures | 44.4 | 44.45 | 44.35 | 44.39 | 716.0 |
| 2016-03-13 23:30:00 | CL | Futures | 44.38 | 44.4 | 44.36 | 44.38 | 342.0 |
| 2016-03-13 18:00:00 | GC | Futures | 1707.6 | 1709.5 | 1704.6 | 1707.5 | 1687.0 |
| 2016-03-13 18:30:00 | GC | Futures | 1707.3 | 1710.1 | 1707.3 | 1708.7 | 513.0 |
> showing 50 of 529 rows — these rows as CSV