PREVIEW / futures_30min / 2011-07-03
file: by_date/futures_30min/2011/2011-07-03.parquet size: 15 KB rows: 365
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 |
|---|---|---|---|---|---|---|---|
| 2011-07-03 18:00:00 | ES | Futures | 1331.33 | 1331.58 | 1330.58 | 1330.83 | 4465.0 |
| 2011-07-03 18:30:00 | ES | Futures | 1330.83 | 1330.83 | 1330.08 | 1330.83 | 1521.0 |
| 2011-07-03 19:00:00 | ES | Futures | 1330.83 | 1330.83 | 1330.33 | 1330.58 | 1293.0 |
| 2011-07-03 19:30:00 | ES | Futures | 1330.83 | 1330.83 | 1330.33 | 1330.83 | 955.0 |
| 2011-07-03 20:00:00 | ES | Futures | 1330.58 | 1330.83 | 1330.33 | 1330.58 | 1617.0 |
| 2011-07-03 20:30:00 | ES | Futures | 1330.83 | 1330.83 | 1329.83 | 1330.33 | 3450.0 |
| 2011-07-03 21:00:00 | ES | Futures | 1330.08 | 1330.33 | 1329.58 | 1330.08 | 1378.0 |
| 2011-07-03 21:30:00 | ES | Futures | 1330.33 | 1330.33 | 1329.33 | 1329.33 | 2863.0 |
| 2011-07-03 22:00:00 | ES | Futures | 1329.33 | 1329.83 | 1329.33 | 1329.83 | 237.0 |
| 2011-07-03 22:30:00 | ES | Futures | 1330.08 | 1330.83 | 1330.08 | 1330.83 | 1240.0 |
| 2011-07-03 23:00:00 | ES | Futures | 1330.83 | 1331.08 | 1330.33 | 1330.83 | 1194.0 |
| 2011-07-03 23:30:00 | ES | Futures | 1330.83 | 1331.08 | 1330.58 | 1330.83 | 748.0 |
| 2011-07-03 18:00:00 | NQ | Futures | 2710.75 | 2710.75 | 2709.31 | 2709.89 | 344.0 |
| 2011-07-03 18:30:00 | NQ | Futures | 2709.89 | 2712.19 | 2709.31 | 2711.61 | 465.0 |
| 2011-07-03 19:00:00 | NQ | Futures | 2711.61 | 2712.19 | 2710.46 | 2710.46 | 80.0 |
| 2011-07-03 19:30:00 | NQ | Futures | 2711.04 | 2711.32 | 2710.17 | 2710.46 | 42.0 |
| 2011-07-03 20:00:00 | NQ | Futures | 2710.17 | 2711.04 | 2710.17 | 2711.04 | 22.0 |
| 2011-07-03 20:30:00 | NQ | Futures | 2710.75 | 2712.19 | 2710.75 | 2711.61 | 186.0 |
| 2011-07-03 21:00:00 | NQ | Futures | 2711.61 | 2713.05 | 2711.32 | 2713.05 | 146.0 |
| 2011-07-03 21:30:00 | NQ | Futures | 2712.76 | 2713.05 | 2711.61 | 2712.19 | 117.0 |
| 2011-07-03 22:00:00 | NQ | Futures | 2712.19 | 2712.76 | 2712.19 | 2712.48 | 34.0 |
| 2011-07-03 22:30:00 | NQ | Futures | 2712.48 | 2715.64 | 2712.48 | 2715.64 | 151.0 |
| 2011-07-03 23:00:00 | NQ | Futures | 2715.64 | 2715.64 | 2714.49 | 2715.07 | 170.0 |
| 2011-07-03 23:30:00 | NQ | Futures | 2715.07 | 2715.35 | 2714.49 | 2714.78 | 36.0 |
| 2011-07-03 18:00:00 | YM | Futures | 12119.5 | 12150.5 | 12106.0 | 12123.4 | 482.0 |
| 2011-07-03 18:30:00 | YM | Futures | 12123.4 | 12123.4 | 12116.6 | 12116.6 | 20.0 |
| 2011-07-03 19:00:00 | YM | Futures | 12119.5 | 12122.4 | 12117.6 | 12118.6 | 55.0 |
| 2011-07-03 19:30:00 | YM | Futures | 12119.5 | 12121.5 | 12117.6 | 12120.5 | 10.0 |
| 2011-07-03 20:00:00 | YM | Futures | 12119.5 | 12124.4 | 12117.6 | 12121.5 | 52.0 |
| 2011-07-03 20:30:00 | YM | Futures | 12120.5 | 12127.3 | 12117.6 | 12121.5 | 188.0 |
| 2011-07-03 21:00:00 | YM | Futures | 12123.4 | 12128.2 | 12118.6 | 12121.5 | 257.0 |
| 2011-07-03 21:30:00 | YM | Futures | 12121.5 | 12124.4 | 12116.6 | 12117.6 | 219.0 |
| 2011-07-03 22:00:00 | YM | Futures | 12118.6 | 12120.5 | 12117.6 | 12120.5 | 59.0 |
| 2011-07-03 22:30:00 | YM | Futures | 12124.4 | 12135.0 | 12122.4 | 12132.1 | 144.0 |
| 2011-07-03 23:00:00 | YM | Futures | 12132.1 | 12132.1 | 12124.4 | 12128.2 | 123.0 |
| 2011-07-03 23:30:00 | YM | Futures | 12128.2 | 12132.1 | 12127.3 | 12130.2 | 44.0 |
| 2011-07-03 18:00:00 | CL | Futures | 162.72 | 163.27 | 162.32 | 162.87 | 304.0 |
| 2011-07-03 18:30:00 | CL | Futures | 162.87 | 163.03 | 162.77 | 162.96 | 142.0 |
| 2011-07-03 19:00:00 | CL | Futures | 163.01 | 163.2 | 162.94 | 163.01 | 214.0 |
| 2011-07-03 19:30:00 | CL | Futures | 163.01 | 163.23 | 163.01 | 163.16 | 115.0 |
| 2011-07-03 20:00:00 | CL | Futures | 163.13 | 163.25 | 163.03 | 163.25 | 168.0 |
| 2011-07-03 20:30:00 | CL | Futures | 163.2 | 163.23 | 163.08 | 163.15 | 76.0 |
| 2011-07-03 21:00:00 | CL | Futures | 163.09 | 163.27 | 162.99 | 163.25 | 148.0 |
| 2011-07-03 21:30:00 | CL | Futures | 163.23 | 163.23 | 162.8 | 162.87 | 186.0 |
| 2011-07-03 22:00:00 | CL | Futures | 162.89 | 163.03 | 162.87 | 162.91 | 164.0 |
| 2011-07-03 22:30:00 | CL | Futures | 162.99 | 163.33 | 162.94 | 163.32 | 199.0 |
| 2011-07-03 23:00:00 | CL | Futures | 163.32 | 163.33 | 163.06 | 163.15 | 136.0 |
| 2011-07-03 23:30:00 | CL | Futures | 163.15 | 163.23 | 163.11 | 163.16 | 108.0 |
| 2011-07-03 18:00:00 | GC | Futures | 2073.7 | 2075.3 | 2072.9 | 2074.8 | 239.0 |
| 2011-07-03 18:30:00 | GC | Futures | 2074.8 | 2075.7 | 2072.9 | 2075.5 | 225.0 |
> showing 50 of 365 rows — these rows as CSV