PREVIEW / futures_30min / 2013-01-20
file: by_date/futures_30min/2013/2013-01-20.parquet size: 17 KB rows: 434
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-01-20 18:00:00 | ES | Futures | 1516.97 | 1519.02 | 1516.97 | 1519.02 | 4010.0 |
| 2013-01-20 18:30:00 | ES | Futures | 1519.02 | 1520.56 | 1518.76 | 1519.79 | 2861.0 |
| 2013-01-20 19:00:00 | ES | Futures | 1519.79 | 1520.05 | 1518.76 | 1519.53 | 2725.0 |
| 2013-01-20 19:30:00 | ES | Futures | 1519.53 | 1519.53 | 1517.74 | 1518.25 | 3878.0 |
| 2013-01-20 20:00:00 | ES | Futures | 1518.25 | 1518.51 | 1517.74 | 1517.99 | 2729.0 |
| 2013-01-20 20:30:00 | ES | Futures | 1517.99 | 1519.28 | 1517.99 | 1519.02 | 1822.0 |
| 2013-01-20 21:00:00 | ES | Futures | 1518.76 | 1519.79 | 1518.76 | 1519.53 | 1776.0 |
| 2013-01-20 21:30:00 | ES | Futures | 1519.53 | 1520.82 | 1519.53 | 1519.79 | 3633.0 |
| 2013-01-20 22:00:00 | ES | Futures | 1519.79 | 1520.3 | 1519.53 | 1520.3 | 1288.0 |
| 2013-01-20 22:30:00 | ES | Futures | 1520.3 | 1520.56 | 1519.02 | 1519.79 | 1058.0 |
| 2013-01-20 23:00:00 | ES | Futures | 1519.79 | 1519.79 | 1519.28 | 1519.53 | 849.0 |
| 2013-01-20 23:30:00 | ES | Futures | 1519.53 | 1519.79 | 1519.28 | 1519.28 | 676.0 |
| 2013-01-20 18:00:00 | NQ | Futures | 3183.42 | 3186.04 | 3182.84 | 3186.04 | 150.0 |
| 2013-01-20 18:30:00 | NQ | Futures | 3186.33 | 3187.5 | 3186.04 | 3186.33 | 184.0 |
| 2013-01-20 19:00:00 | NQ | Futures | 3186.04 | 3186.33 | 3184.59 | 3184.88 | 301.0 |
| 2013-01-20 19:30:00 | NQ | Futures | 3185.17 | 3185.46 | 3184.0 | 3185.17 | 273.0 |
| 2013-01-20 20:00:00 | NQ | Futures | 3184.88 | 3186.33 | 3184.3 | 3185.17 | 192.0 |
| 2013-01-20 20:30:00 | NQ | Futures | 3185.46 | 3187.5 | 3185.46 | 3186.62 | 153.0 |
| 2013-01-20 21:00:00 | NQ | Futures | 3186.92 | 3187.79 | 3186.62 | 3187.79 | 149.0 |
| 2013-01-20 21:30:00 | NQ | Futures | 3187.5 | 3189.53 | 3187.5 | 3188.37 | 173.0 |
| 2013-01-20 22:00:00 | NQ | Futures | 3188.08 | 3189.83 | 3187.21 | 3189.24 | 194.0 |
| 2013-01-20 22:30:00 | NQ | Futures | 3189.53 | 3189.83 | 3187.79 | 3188.95 | 134.0 |
| 2013-01-20 23:00:00 | NQ | Futures | 3188.95 | 3189.24 | 3188.08 | 3189.24 | 73.0 |
| 2013-01-20 23:30:00 | NQ | Futures | 3188.66 | 3189.24 | 3188.37 | 3188.37 | 48.0 |
| 2013-01-20 18:00:00 | YM | Futures | 13655.8 | 13671.9 | 13648.7 | 13669.9 | 406.0 |
| 2013-01-20 18:30:00 | YM | Futures | 13668.9 | 13686.0 | 13668.9 | 13678.9 | 473.0 |
| 2013-01-20 19:00:00 | YM | Futures | 13678.9 | 13679.9 | 13666.8 | 13671.9 | 349.0 |
| 2013-01-20 19:30:00 | YM | Futures | 13671.9 | 13671.9 | 13657.8 | 13661.8 | 441.0 |
| 2013-01-20 20:00:00 | YM | Futures | 13660.8 | 13663.8 | 13655.8 | 13657.8 | 302.0 |
| 2013-01-20 20:30:00 | YM | Futures | 13658.8 | 13666.8 | 13656.8 | 13663.8 | 152.0 |
| 2013-01-20 21:00:00 | YM | Futures | 13663.8 | 13669.9 | 13662.8 | 13668.9 | 119.0 |
| 2013-01-20 21:30:00 | YM | Futures | 13668.9 | 13673.9 | 13666.8 | 13667.9 | 249.0 |
| 2013-01-20 22:00:00 | YM | Futures | 13667.9 | 13671.9 | 13663.8 | 13669.9 | 140.0 |
| 2013-01-20 22:30:00 | YM | Futures | 13669.9 | 13672.9 | 13662.8 | 13665.8 | 113.0 |
| 2013-01-20 23:00:00 | YM | Futures | 13665.8 | 13668.9 | 13663.8 | 13666.8 | 85.0 |
| 2013-01-20 23:30:00 | YM | Futures | 13665.8 | 13666.8 | 13661.8 | 13664.8 | 71.0 |
| 2013-01-20 18:00:00 | CL | Futures | 152.96 | 153.12 | 152.94 | 153.05 | 252.0 |
| 2013-01-20 18:30:00 | CL | Futures | 153.05 | 153.18 | 153.04 | 153.17 | 192.0 |
| 2013-01-20 19:00:00 | CL | Futures | 153.17 | 153.18 | 152.91 | 153.01 | 235.0 |
| 2013-01-20 19:30:00 | CL | Futures | 152.99 | 153.05 | 152.94 | 152.99 | 261.0 |
| 2013-01-20 20:00:00 | CL | Futures | 153.01 | 153.09 | 152.93 | 153.02 | 378.0 |
| 2013-01-20 20:30:00 | CL | Futures | 153.04 | 153.07 | 152.94 | 153.02 | 237.0 |
| 2013-01-20 21:00:00 | CL | Futures | 153.02 | 153.1 | 152.97 | 153.01 | 203.0 |
| 2013-01-20 21:30:00 | CL | Futures | 153.01 | 153.05 | 152.96 | 153.02 | 191.0 |
| 2013-01-20 22:00:00 | CL | Futures | 153.01 | 153.04 | 152.91 | 152.94 | 316.0 |
| 2013-01-20 22:30:00 | CL | Futures | 152.94 | 152.99 | 152.88 | 152.94 | 218.0 |
| 2013-01-20 23:00:00 | CL | Futures | 152.93 | 152.99 | 152.93 | 152.99 | 133.0 |
| 2013-01-20 23:30:00 | CL | Futures | 153.01 | 153.01 | 152.88 | 152.88 | 351.0 |
| 2013-01-20 18:00:00 | GC | Futures | 2322.7 | 2324.7 | 2320.4 | 2323.8 | 842.0 |
| 2013-01-20 18:30:00 | GC | Futures | 2324.3 | 2326.9 | 2324.3 | 2325.4 | 995.0 |
> showing 50 of 434 rows — these rows as CSV