PREVIEW / futures_30min / 2013-12-15
file: by_date/futures_30min/2013/2013-12-15.parquet size: 20 KB rows: 499
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-12-15 18:00:00 | ES | Futures | 1829.71 | 1831.52 | 1828.94 | 1831.01 | 3266.0 |
| 2013-12-15 18:30:00 | ES | Futures | 1831.01 | 1831.27 | 1830.23 | 1831.01 | 1221.0 |
| 2013-12-15 19:00:00 | ES | Futures | 1831.01 | 1832.04 | 1830.49 | 1831.01 | 3119.0 |
| 2013-12-15 19:30:00 | ES | Futures | 1831.01 | 1832.82 | 1831.01 | 1831.78 | 2604.0 |
| 2013-12-15 20:00:00 | ES | Futures | 1831.78 | 1831.78 | 1829.97 | 1830.23 | 1600.0 |
| 2013-12-15 20:30:00 | ES | Futures | 1830.23 | 1830.75 | 1829.71 | 1829.97 | 2060.0 |
| 2013-12-15 21:00:00 | ES | Futures | 1829.97 | 1830.75 | 1829.45 | 1829.45 | 1537.0 |
| 2013-12-15 21:30:00 | ES | Futures | 1829.45 | 1829.71 | 1826.61 | 1827.9 | 4267.0 |
| 2013-12-15 22:00:00 | ES | Futures | 1827.9 | 1827.9 | 1814.71 | 1820.92 | 21855.0 |
| 2013-12-15 22:30:00 | ES | Futures | 1820.66 | 1821.95 | 1818.07 | 1819.11 | 5434.0 |
| 2013-12-15 23:00:00 | ES | Futures | 1819.37 | 1821.44 | 1819.11 | 1820.92 | 2908.0 |
| 2013-12-15 23:30:00 | ES | Futures | 1820.92 | 1821.95 | 1820.66 | 1821.44 | 965.0 |
| 2013-12-15 18:00:00 | NQ | Futures | 4016.39 | 4019.59 | 4014.36 | 4019.01 | 357.0 |
| 2013-12-15 18:30:00 | NQ | Futures | 4019.01 | 4019.01 | 4017.55 | 4019.01 | 100.0 |
| 2013-12-15 19:00:00 | NQ | Futures | 4018.43 | 4021.04 | 4017.55 | 4018.14 | 396.0 |
| 2013-12-15 19:30:00 | NQ | Futures | 4018.43 | 4021.33 | 4018.43 | 4019.3 | 320.0 |
| 2013-12-15 20:00:00 | NQ | Futures | 4019.3 | 4019.59 | 4016.39 | 4016.68 | 250.0 |
| 2013-12-15 20:30:00 | NQ | Futures | 4016.97 | 4018.14 | 4015.81 | 4016.68 | 452.0 |
| 2013-12-15 21:00:00 | NQ | Futures | 4016.97 | 4019.01 | 4015.81 | 4016.1 | 346.0 |
| 2013-12-15 21:30:00 | NQ | Futures | 4016.39 | 4016.68 | 4010.29 | 4012.61 | 461.0 |
| 2013-12-15 22:00:00 | NQ | Futures | 4012.32 | 4012.61 | 3987.61 | 3996.04 | 4052.0 |
| 2013-12-15 22:30:00 | NQ | Futures | 3995.75 | 3998.95 | 3992.55 | 3994.01 | 1472.0 |
| 2013-12-15 23:00:00 | NQ | Futures | 3994.3 | 3998.37 | 3993.72 | 3997.5 | 678.0 |
| 2013-12-15 23:30:00 | NQ | Futures | 3997.5 | 3998.95 | 3997.21 | 3998.37 | 254.0 |
| 2013-12-15 18:00:00 | YM | Futures | 16107.0 | 16107.0 | 16090.6 | 16104.0 | 574.0 |
| 2013-12-15 18:30:00 | YM | Futures | 16105.0 | 16106.0 | 16099.9 | 16106.0 | 127.0 |
| 2013-12-15 19:00:00 | YM | Futures | 16104.0 | 16113.2 | 16101.9 | 16102.9 | 379.0 |
| 2013-12-15 19:30:00 | YM | Futures | 16102.9 | 16114.2 | 16102.9 | 16108.1 | 426.0 |
| 2013-12-15 20:00:00 | YM | Futures | 16108.1 | 16110.1 | 16091.6 | 16094.7 | 439.0 |
| 2013-12-15 20:30:00 | YM | Futures | 16092.7 | 16099.9 | 16089.6 | 16094.7 | 561.0 |
| 2013-12-15 21:00:00 | YM | Futures | 16094.7 | 16101.9 | 16093.7 | 16094.7 | 209.0 |
| 2013-12-15 21:30:00 | YM | Futures | 16094.7 | 16095.7 | 16076.3 | 16083.4 | 604.0 |
| 2013-12-15 22:00:00 | YM | Futures | 16083.4 | 16083.4 | 16004.5 | 16030.1 | 3543.0 |
| 2013-12-15 22:30:00 | YM | Futures | 16029.1 | 16038.3 | 16013.7 | 16020.9 | 1479.0 |
| 2013-12-15 23:00:00 | YM | Futures | 16021.9 | 16036.3 | 16018.8 | 16034.2 | 499.0 |
| 2013-12-15 23:30:00 | YM | Futures | 16032.2 | 16039.4 | 16032.2 | 16037.3 | 288.0 |
| 2013-12-15 18:00:00 | CL | Futures | 152.45 | 152.9 | 152.45 | 152.89 | 468.0 |
| 2013-12-15 18:30:00 | CL | Futures | 152.84 | 152.89 | 152.81 | 152.87 | 94.0 |
| 2013-12-15 19:00:00 | CL | Futures | 152.87 | 152.9 | 152.79 | 152.81 | 63.0 |
| 2013-12-15 19:30:00 | CL | Futures | 152.83 | 152.86 | 152.76 | 152.79 | 28.0 |
| 2013-12-15 20:00:00 | CL | Futures | 152.79 | 152.79 | 152.54 | 152.67 | 146.0 |
| 2013-12-15 20:30:00 | CL | Futures | 152.65 | 152.7 | 152.59 | 152.6 | 56.0 |
| 2013-12-15 21:00:00 | CL | Futures | 152.6 | 152.7 | 152.6 | 152.64 | 79.0 |
| 2013-12-15 21:30:00 | CL | Futures | 152.64 | 152.64 | 152.46 | 152.48 | 54.0 |
| 2013-12-15 22:00:00 | CL | Futures | 152.49 | 152.56 | 152.43 | 152.45 | 84.0 |
| 2013-12-15 22:30:00 | CL | Futures | 152.46 | 152.46 | 152.26 | 152.35 | 145.0 |
| 2013-12-15 23:00:00 | CL | Futures | 152.37 | 152.42 | 152.27 | 152.27 | 53.0 |
| 2013-12-15 23:30:00 | CL | Futures | 152.24 | 152.37 | 152.18 | 152.27 | 109.0 |
| 2013-12-15 18:00:00 | GC | Futures | 1696.1 | 1697.3 | 1694.4 | 1694.5 | 625.0 |
| 2013-12-15 18:30:00 | GC | Futures | 1694.4 | 1695.2 | 1693.4 | 1693.6 | 231.0 |
> showing 50 of 499 rows — these rows as CSV