PREVIEW / futures_30min / 2013-10-20
file: by_date/futures_30min/2013/2013-10-20.parquet size: 19 KB rows: 492
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-10-20 18:00:00 | ES | Futures | 1793.34 | 1793.86 | 1791.54 | 1793.86 | 4720.0 |
| 2013-10-20 18:30:00 | ES | Futures | 1793.86 | 1794.11 | 1792.31 | 1793.34 | 1581.0 |
| 2013-10-20 19:00:00 | ES | Futures | 1793.34 | 1794.11 | 1792.31 | 1793.34 | 1194.0 |
| 2013-10-20 19:30:00 | ES | Futures | 1793.6 | 1794.37 | 1793.34 | 1794.37 | 1521.0 |
| 2013-10-20 20:00:00 | ES | Futures | 1794.11 | 1795.15 | 1793.6 | 1793.86 | 4209.0 |
| 2013-10-20 20:30:00 | ES | Futures | 1793.86 | 1793.86 | 1793.08 | 1793.34 | 1823.0 |
| 2013-10-20 21:00:00 | ES | Futures | 1793.34 | 1793.6 | 1792.31 | 1793.34 | 2742.0 |
| 2013-10-20 21:30:00 | ES | Futures | 1793.34 | 1794.11 | 1792.82 | 1793.34 | 1525.0 |
| 2013-10-20 22:00:00 | ES | Futures | 1793.34 | 1793.6 | 1793.08 | 1793.34 | 458.0 |
| 2013-10-20 22:30:00 | ES | Futures | 1793.34 | 1793.34 | 1792.31 | 1792.82 | 970.0 |
| 2013-10-20 23:00:00 | ES | Futures | 1792.82 | 1793.34 | 1792.82 | 1793.08 | 423.0 |
| 2013-10-20 23:30:00 | ES | Futures | 1793.34 | 1794.11 | 1793.34 | 1793.6 | 1099.0 |
| 2013-10-20 18:00:00 | NQ | Futures | 3885.7 | 3887.44 | 3883.08 | 3887.44 | 681.0 |
| 2013-10-20 18:30:00 | NQ | Futures | 3887.44 | 3887.73 | 3884.83 | 3887.15 | 134.0 |
| 2013-10-20 19:00:00 | NQ | Futures | 3886.86 | 3888.02 | 3885.41 | 3887.15 | 139.0 |
| 2013-10-20 19:30:00 | NQ | Futures | 3887.73 | 3889.47 | 3887.73 | 3889.47 | 221.0 |
| 2013-10-20 20:00:00 | NQ | Futures | 3889.47 | 3891.21 | 3888.89 | 3889.18 | 406.0 |
| 2013-10-20 20:30:00 | NQ | Futures | 3889.18 | 3889.18 | 3887.15 | 3887.73 | 206.0 |
| 2013-10-20 21:00:00 | NQ | Futures | 3888.02 | 3888.02 | 3885.41 | 3887.15 | 369.0 |
| 2013-10-20 21:30:00 | NQ | Futures | 3886.86 | 3888.31 | 3885.7 | 3887.44 | 327.0 |
| 2013-10-20 22:00:00 | NQ | Futures | 3887.15 | 3887.44 | 3886.57 | 3886.86 | 51.0 |
| 2013-10-20 22:30:00 | NQ | Futures | 3886.57 | 3886.86 | 3885.7 | 3886.57 | 173.0 |
| 2013-10-20 23:00:00 | NQ | Futures | 3886.86 | 3887.44 | 3886.28 | 3887.15 | 71.0 |
| 2013-10-20 23:30:00 | NQ | Futures | 3887.44 | 3888.31 | 3887.15 | 3887.73 | 188.0 |
| 2013-10-20 18:00:00 | YM | Futures | 15652.7 | 15661.8 | 15643.5 | 15660.8 | 613.0 |
| 2013-10-20 18:30:00 | YM | Futures | 15660.8 | 15663.9 | 15652.7 | 15658.8 | 455.0 |
| 2013-10-20 19:00:00 | YM | Futures | 15657.8 | 15663.9 | 15652.7 | 15662.9 | 205.0 |
| 2013-10-20 19:30:00 | YM | Futures | 15660.8 | 15665.9 | 15660.8 | 15665.9 | 124.0 |
| 2013-10-20 20:00:00 | YM | Futures | 15667.0 | 15673.1 | 15662.9 | 15664.9 | 420.0 |
| 2013-10-20 20:30:00 | YM | Futures | 15663.9 | 15665.9 | 15658.8 | 15660.8 | 318.0 |
| 2013-10-20 21:00:00 | YM | Futures | 15661.8 | 15663.9 | 15653.7 | 15660.8 | 387.0 |
| 2013-10-20 21:30:00 | YM | Futures | 15661.8 | 15667.0 | 15657.8 | 15662.9 | 342.0 |
| 2013-10-20 22:00:00 | YM | Futures | 15662.9 | 15662.9 | 15659.8 | 15661.8 | 102.0 |
| 2013-10-20 22:30:00 | YM | Futures | 15660.8 | 15660.8 | 15656.7 | 15659.8 | 269.0 |
| 2013-10-20 23:00:00 | YM | Futures | 15660.8 | 15662.9 | 15658.8 | 15661.8 | 127.0 |
| 2013-10-20 23:30:00 | YM | Futures | 15661.8 | 15664.9 | 15661.8 | 15663.9 | 137.0 |
| 2013-10-20 18:00:00 | CL | Futures | 160.54 | 160.64 | 160.37 | 160.56 | 430.0 |
| 2013-10-20 18:30:00 | CL | Futures | 160.54 | 160.61 | 160.51 | 160.61 | 118.0 |
| 2013-10-20 19:00:00 | CL | Futures | 160.59 | 160.59 | 160.46 | 160.5 | 193.0 |
| 2013-10-20 19:30:00 | CL | Futures | 160.48 | 160.58 | 160.46 | 160.58 | 61.0 |
| 2013-10-20 20:00:00 | CL | Futures | 160.58 | 160.77 | 160.5 | 160.72 | 426.0 |
| 2013-10-20 20:30:00 | CL | Futures | 160.7 | 160.73 | 160.67 | 160.67 | 117.0 |
| 2013-10-20 21:00:00 | CL | Futures | 160.67 | 160.75 | 160.51 | 160.7 | 433.0 |
| 2013-10-20 21:30:00 | CL | Futures | 160.72 | 160.85 | 160.67 | 160.78 | 414.0 |
| 2013-10-20 22:00:00 | CL | Futures | 160.77 | 160.8 | 160.61 | 160.65 | 159.0 |
| 2013-10-20 22:30:00 | CL | Futures | 160.67 | 160.7 | 160.56 | 160.65 | 157.0 |
| 2013-10-20 23:00:00 | CL | Futures | 160.64 | 160.69 | 160.59 | 160.69 | 127.0 |
| 2013-10-20 23:30:00 | CL | Futures | 160.67 | 160.72 | 160.58 | 160.59 | 135.0 |
| 2013-10-20 18:00:00 | GC | Futures | 1803.9 | 1804.5 | 1798.4 | 1800.1 | 576.0 |
| 2013-10-20 18:30:00 | GC | Futures | 1800.0 | 1804.1 | 1799.5 | 1802.6 | 321.0 |
> showing 50 of 492 rows — these rows as CSV