PREVIEW / futures_30min / 2013-08-04
file: by_date/futures_30min/2013/2013-08-04.parquet size: 19 KB rows: 491
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 |
|---|---|---|---|---|---|---|---|
| 2013-08-04 18:00:00 | ES | Futures | 1760.61 | 1761.64 | 1759.06 | 1760.87 | 2859.0 |
| 2013-08-04 18:30:00 | ES | Futures | 1761.13 | 1761.13 | 1760.35 | 1760.35 | 530.0 |
| 2013-08-04 19:00:00 | ES | Futures | 1760.35 | 1760.87 | 1759.83 | 1760.61 | 1223.0 |
| 2013-08-04 19:30:00 | ES | Futures | 1760.35 | 1760.87 | 1760.09 | 1760.35 | 981.0 |
| 2013-08-04 20:00:00 | ES | Futures | 1760.35 | 1760.61 | 1759.57 | 1760.09 | 1396.0 |
| 2013-08-04 20:30:00 | ES | Futures | 1759.83 | 1759.83 | 1759.06 | 1759.32 | 1865.0 |
| 2013-08-04 21:00:00 | ES | Futures | 1759.32 | 1760.35 | 1759.06 | 1760.35 | 1567.0 |
| 2013-08-04 21:30:00 | ES | Futures | 1760.35 | 1760.35 | 1759.32 | 1759.32 | 1265.0 |
| 2013-08-04 22:00:00 | ES | Futures | 1759.57 | 1760.35 | 1759.32 | 1759.83 | 900.0 |
| 2013-08-04 22:30:00 | ES | Futures | 1760.09 | 1760.09 | 1759.83 | 1760.09 | 364.0 |
| 2013-08-04 23:00:00 | ES | Futures | 1760.09 | 1760.35 | 1759.57 | 1760.09 | 675.0 |
| 2013-08-04 23:30:00 | ES | Futures | 1759.83 | 1760.35 | 1759.57 | 1760.09 | 770.0 |
| 2013-08-04 18:00:00 | NQ | Futures | 3666.1 | 3666.39 | 3662.59 | 3665.81 | 543.0 |
| 2013-08-04 18:30:00 | NQ | Futures | 3665.81 | 3665.81 | 3664.64 | 3664.64 | 69.0 |
| 2013-08-04 19:00:00 | NQ | Futures | 3664.35 | 3665.22 | 3663.47 | 3664.93 | 136.0 |
| 2013-08-04 19:30:00 | NQ | Futures | 3665.22 | 3665.51 | 3664.05 | 3664.64 | 86.0 |
| 2013-08-04 20:00:00 | NQ | Futures | 3664.64 | 3664.64 | 3662.88 | 3663.76 | 188.0 |
| 2013-08-04 20:30:00 | NQ | Futures | 3663.47 | 3663.47 | 3661.72 | 3662.3 | 302.0 |
| 2013-08-04 21:00:00 | NQ | Futures | 3662.3 | 3664.35 | 3661.72 | 3663.47 | 188.0 |
| 2013-08-04 21:30:00 | NQ | Futures | 3663.47 | 3663.76 | 3662.3 | 3662.88 | 319.0 |
| 2013-08-04 22:00:00 | NQ | Futures | 3662.88 | 3664.35 | 3662.59 | 3664.05 | 212.0 |
| 2013-08-04 22:30:00 | NQ | Futures | 3664.05 | 3664.05 | 3663.18 | 3664.05 | 110.0 |
| 2013-08-04 23:00:00 | NQ | Futures | 3664.05 | 3664.35 | 3663.47 | 3664.05 | 66.0 |
| 2013-08-04 23:30:00 | NQ | Futures | 3664.05 | 3665.22 | 3663.47 | 3664.64 | 213.0 |
| 2013-08-04 18:00:00 | YM | Futures | 15829.4 | 15834.5 | 15817.2 | 15831.4 | 238.0 |
| 2013-08-04 18:30:00 | YM | Futures | 15829.4 | 15832.4 | 15825.3 | 15825.3 | 93.0 |
| 2013-08-04 19:00:00 | YM | Futures | 15825.3 | 15827.4 | 15821.3 | 15826.3 | 85.0 |
| 2013-08-04 19:30:00 | YM | Futures | 15827.4 | 15831.4 | 15825.3 | 15829.4 | 97.0 |
| 2013-08-04 20:00:00 | YM | Futures | 15827.4 | 15827.4 | 15821.3 | 15823.3 | 192.0 |
| 2013-08-04 20:30:00 | YM | Futures | 15823.3 | 15823.3 | 15817.2 | 15818.2 | 351.0 |
| 2013-08-04 21:00:00 | YM | Futures | 15819.2 | 15826.3 | 15818.2 | 15824.3 | 283.0 |
| 2013-08-04 21:30:00 | YM | Futures | 15824.3 | 15824.3 | 15817.2 | 15820.3 | 281.0 |
| 2013-08-04 22:00:00 | YM | Futures | 15820.3 | 15825.3 | 15819.2 | 15821.3 | 165.0 |
| 2013-08-04 22:30:00 | YM | Futures | 15823.3 | 15825.3 | 15820.3 | 15825.3 | 108.0 |
| 2013-08-04 23:00:00 | YM | Futures | 15824.3 | 15824.3 | 15820.3 | 15821.3 | 56.0 |
| 2013-08-04 23:30:00 | YM | Futures | 15820.3 | 15825.3 | 15818.2 | 15823.3 | 139.0 |
| 2013-08-04 18:00:00 | CL | Futures | 167.94 | 168.08 | 167.55 | 167.96 | 578.0 |
| 2013-08-04 18:30:00 | CL | Futures | 167.96 | 168.0 | 167.89 | 167.93 | 129.0 |
| 2013-08-04 19:00:00 | CL | Futures | 167.94 | 167.96 | 167.63 | 167.69 | 334.0 |
| 2013-08-04 19:30:00 | CL | Futures | 167.66 | 167.69 | 167.58 | 167.64 | 373.0 |
| 2013-08-04 20:00:00 | CL | Futures | 167.66 | 167.66 | 166.64 | 167.08 | 2368.0 |
| 2013-08-04 20:30:00 | CL | Futures | 167.09 | 167.28 | 167.0 | 167.01 | 667.0 |
| 2013-08-04 21:00:00 | CL | Futures | 167.0 | 167.38 | 166.98 | 167.19 | 709.0 |
| 2013-08-04 21:30:00 | CL | Futures | 167.2 | 167.94 | 167.11 | 167.74 | 1200.0 |
| 2013-08-04 22:00:00 | CL | Futures | 167.72 | 168.35 | 167.72 | 168.08 | 1472.0 |
| 2013-08-04 22:30:00 | CL | Futures | 168.11 | 168.18 | 168.05 | 168.08 | 260.0 |
| 2013-08-04 23:00:00 | CL | Futures | 168.11 | 168.18 | 167.96 | 167.97 | 266.0 |
| 2013-08-04 23:30:00 | CL | Futures | 167.96 | 168.55 | 167.96 | 168.44 | 831.0 |
| 2013-08-04 18:00:00 | GC | Futures | 1798.7 | 1801.7 | 1796.5 | 1800.9 | 652.0 |
| 2013-08-04 18:30:00 | GC | Futures | 1800.9 | 1801.2 | 1799.8 | 1800.6 | 194.0 |
> showing 50 of 491 rows — these rows as CSV