PREVIEW / futures_30min / 2014-02-02
file: by_date/futures_30min/2014/2014-02-02.parquet size: 20 KB rows: 508
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 |
|---|---|---|---|---|---|---|---|
| 2014-02-02 18:00:00 | ES | Futures | 1839.02 | 1844.2 | 1839.02 | 1843.42 | 7651.0 |
| 2014-02-02 18:30:00 | ES | Futures | 1843.68 | 1845.49 | 1842.9 | 1844.46 | 3270.0 |
| 2014-02-02 19:00:00 | ES | Futures | 1844.46 | 1845.23 | 1843.68 | 1843.68 | 4120.0 |
| 2014-02-02 19:30:00 | ES | Futures | 1843.68 | 1843.94 | 1841.87 | 1843.16 | 3589.0 |
| 2014-02-02 20:00:00 | ES | Futures | 1843.16 | 1843.42 | 1841.35 | 1841.61 | 3896.0 |
| 2014-02-02 20:30:00 | ES | Futures | 1841.61 | 1842.65 | 1838.25 | 1838.77 | 6902.0 |
| 2014-02-02 21:00:00 | ES | Futures | 1838.77 | 1840.32 | 1837.47 | 1839.8 | 6526.0 |
| 2014-02-02 21:30:00 | ES | Futures | 1839.54 | 1841.61 | 1838.77 | 1841.09 | 2780.0 |
| 2014-02-02 22:00:00 | ES | Futures | 1841.09 | 1842.65 | 1840.84 | 1841.87 | 1795.0 |
| 2014-02-02 22:30:00 | ES | Futures | 1842.13 | 1842.9 | 1840.32 | 1842.13 | 3322.0 |
| 2014-02-02 23:00:00 | ES | Futures | 1842.39 | 1842.65 | 1840.84 | 1842.13 | 1248.0 |
| 2014-02-02 23:30:00 | ES | Futures | 1842.13 | 1842.39 | 1841.35 | 1842.13 | 614.0 |
| 2014-02-02 18:00:00 | NQ | Futures | 4085.86 | 4100.98 | 4085.86 | 4099.82 | 819.0 |
| 2014-02-02 18:30:00 | NQ | Futures | 4099.82 | 4104.18 | 4097.78 | 4102.14 | 529.0 |
| 2014-02-02 19:00:00 | NQ | Futures | 4101.85 | 4103.31 | 4099.82 | 4100.11 | 179.0 |
| 2014-02-02 19:30:00 | NQ | Futures | 4099.82 | 4100.11 | 4095.75 | 4097.78 | 373.0 |
| 2014-02-02 20:00:00 | NQ | Futures | 4098.07 | 4098.07 | 4091.97 | 4093.13 | 759.0 |
| 2014-02-02 20:30:00 | NQ | Futures | 4092.55 | 4095.75 | 4085.86 | 4086.74 | 783.0 |
| 2014-02-02 21:00:00 | NQ | Futures | 4086.45 | 4090.52 | 4084.41 | 4089.93 | 691.0 |
| 2014-02-02 21:30:00 | NQ | Futures | 4089.35 | 4093.71 | 4087.32 | 4092.84 | 565.0 |
| 2014-02-02 22:00:00 | NQ | Futures | 4093.13 | 4095.75 | 4091.97 | 4093.42 | 273.0 |
| 2014-02-02 22:30:00 | NQ | Futures | 4093.71 | 4095.17 | 4089.64 | 4093.71 | 538.0 |
| 2014-02-02 23:00:00 | NQ | Futures | 4093.71 | 4094.88 | 4090.52 | 4092.84 | 229.0 |
| 2014-02-02 23:30:00 | NQ | Futures | 4093.13 | 4094.0 | 4092.26 | 4093.13 | 119.0 |
| 2014-02-02 18:00:00 | YM | Futures | 16041.4 | 16087.5 | 16041.4 | 16082.4 | 635.0 |
| 2014-02-02 18:30:00 | YM | Futures | 16081.4 | 16095.7 | 16078.3 | 16087.5 | 277.0 |
| 2014-02-02 19:00:00 | YM | Futures | 16086.5 | 16094.7 | 16077.3 | 16078.3 | 343.0 |
| 2014-02-02 19:30:00 | YM | Futures | 16077.3 | 16078.3 | 16060.9 | 16070.1 | 512.0 |
| 2014-02-02 20:00:00 | YM | Futures | 16069.1 | 16071.1 | 16053.7 | 16054.7 | 579.0 |
| 2014-02-02 20:30:00 | YM | Futures | 16054.7 | 16062.9 | 16029.1 | 16031.1 | 924.0 |
| 2014-02-02 21:00:00 | YM | Futures | 16032.2 | 16043.5 | 16024.0 | 16041.4 | 917.0 |
| 2014-02-02 21:30:00 | YM | Futures | 16038.3 | 16054.7 | 16033.2 | 16049.6 | 540.0 |
| 2014-02-02 22:00:00 | YM | Futures | 16050.6 | 16062.9 | 16050.6 | 16056.8 | 310.0 |
| 2014-02-02 22:30:00 | YM | Futures | 16057.8 | 16062.9 | 16043.5 | 16059.9 | 459.0 |
| 2014-02-02 23:00:00 | YM | Futures | 16059.9 | 16065.0 | 16049.6 | 16059.9 | 252.0 |
| 2014-02-02 23:30:00 | YM | Futures | 16060.9 | 16061.9 | 16054.7 | 16058.8 | 87.0 |
| 2014-02-02 18:00:00 | CL | Futures | 153.01 | 153.23 | 152.71 | 152.84 | 358.0 |
| 2014-02-02 18:30:00 | CL | Futures | 152.85 | 152.85 | 152.7 | 152.7 | 89.0 |
| 2014-02-02 19:00:00 | CL | Futures | 152.7 | 152.79 | 152.41 | 152.43 | 514.0 |
| 2014-02-02 19:30:00 | CL | Futures | 152.41 | 152.49 | 152.04 | 152.24 | 769.0 |
| 2014-02-02 20:00:00 | CL | Futures | 152.26 | 152.41 | 152.21 | 152.35 | 314.0 |
| 2014-02-02 20:30:00 | CL | Futures | 152.29 | 152.4 | 152.1 | 152.33 | 489.0 |
| 2014-02-02 21:00:00 | CL | Futures | 152.32 | 152.59 | 152.32 | 152.59 | 394.0 |
| 2014-02-02 21:30:00 | CL | Futures | 152.57 | 152.65 | 152.49 | 152.62 | 254.0 |
| 2014-02-02 22:00:00 | CL | Futures | 152.6 | 152.62 | 152.46 | 152.52 | 145.0 |
| 2014-02-02 22:30:00 | CL | Futures | 152.54 | 152.66 | 152.52 | 152.52 | 208.0 |
| 2014-02-02 23:00:00 | CL | Futures | 152.54 | 152.79 | 152.52 | 152.74 | 326.0 |
| 2014-02-02 23:30:00 | CL | Futures | 152.74 | 152.85 | 152.73 | 152.81 | 262.0 |
| 2014-02-02 18:00:00 | GC | Futures | 1701.0 | 1703.6 | 1700.6 | 1701.3 | 792.0 |
| 2014-02-02 18:30:00 | GC | Futures | 1701.4 | 1703.6 | 1701.2 | 1702.9 | 350.0 |
> showing 50 of 508 rows — these rows as CSV