PREVIEW / futures_30min / 2014-04-14
file: by_date/futures_30min/2014/2014-04-14.parquet size: 74 KB rows: 2,871
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-04-14 00:00:00 | ES | Futures | 1878.46 | 1879.24 | 1877.94 | 1878.98 | 1038.0 |
| 2014-04-14 00:30:00 | ES | Futures | 1878.98 | 1879.24 | 1877.68 | 1878.46 | 2066.0 |
| 2014-04-14 01:00:00 | ES | Futures | 1878.72 | 1879.76 | 1878.72 | 1879.24 | 1529.0 |
| 2014-04-14 01:30:00 | ES | Futures | 1879.24 | 1879.76 | 1878.46 | 1878.72 | 1345.0 |
| 2014-04-14 02:00:00 | ES | Futures | 1878.72 | 1878.98 | 1877.42 | 1877.42 | 6214.0 |
| 2014-04-14 02:30:00 | ES | Futures | 1877.42 | 1879.24 | 1877.42 | 1879.24 | 2762.0 |
| 2014-04-14 03:00:00 | ES | Futures | 1878.98 | 1883.14 | 1878.98 | 1882.62 | 23023.0 |
| 2014-04-14 03:30:00 | ES | Futures | 1882.88 | 1883.65 | 1880.28 | 1880.54 | 13912.0 |
| 2014-04-14 04:00:00 | ES | Futures | 1880.8 | 1881.06 | 1877.68 | 1879.24 | 14561.0 |
| 2014-04-14 04:30:00 | ES | Futures | 1879.24 | 1880.02 | 1877.94 | 1879.76 | 12086.0 |
| 2014-04-14 05:00:00 | ES | Futures | 1880.02 | 1880.02 | 1876.38 | 1876.9 | 12438.0 |
| 2014-04-14 05:30:00 | ES | Futures | 1876.9 | 1879.24 | 1876.12 | 1878.46 | 7635.0 |
| 2014-04-14 06:00:00 | ES | Futures | 1878.46 | 1880.8 | 1877.94 | 1880.28 | 10511.0 |
| 2014-04-14 06:30:00 | ES | Futures | 1880.28 | 1882.88 | 1879.76 | 1882.62 | 12457.0 |
| 2014-04-14 07:00:00 | ES | Futures | 1882.62 | 1883.65 | 1881.58 | 1881.84 | 12473.0 |
| 2014-04-14 07:30:00 | ES | Futures | 1881.84 | 1886.25 | 1881.32 | 1885.99 | 23226.0 |
| 2014-04-14 08:00:00 | ES | Futures | 1885.99 | 1889.63 | 1885.73 | 1889.11 | 38804.0 |
| 2014-04-14 08:30:00 | ES | Futures | 1888.85 | 1893.0 | 1888.85 | 1890.67 | 59829.0 |
| 2014-04-14 09:00:00 | ES | Futures | 1890.67 | 1894.3 | 1890.41 | 1894.04 | 33035.0 |
| 2014-04-14 09:30:00 | ES | Futures | 1894.3 | 1895.34 | 1886.51 | 1887.55 | 257947.0 |
| 2014-04-14 10:00:00 | ES | Futures | 1887.29 | 1891.7 | 1885.73 | 1889.11 | 147555.0 |
| 2014-04-14 10:30:00 | ES | Futures | 1889.11 | 1897.94 | 1888.59 | 1897.68 | 148819.0 |
| 2014-04-14 11:00:00 | ES | Futures | 1897.42 | 1897.94 | 1893.52 | 1894.82 | 95246.0 |
| 2014-04-14 11:30:00 | ES | Futures | 1894.82 | 1897.94 | 1893.78 | 1894.3 | 64636.0 |
| 2014-04-14 12:00:00 | ES | Futures | 1894.56 | 1896.9 | 1893.26 | 1896.38 | 45085.0 |
| 2014-04-14 12:30:00 | ES | Futures | 1896.38 | 1898.72 | 1895.6 | 1897.16 | 48169.0 |
| 2014-04-14 13:00:00 | ES | Futures | 1897.16 | 1897.42 | 1892.22 | 1892.74 | 53821.0 |
| 2014-04-14 13:30:00 | ES | Futures | 1892.48 | 1895.08 | 1890.93 | 1891.19 | 53574.0 |
| 2014-04-14 14:00:00 | ES | Futures | 1891.19 | 1893.26 | 1887.55 | 1888.07 | 97439.0 |
| 2014-04-14 14:30:00 | ES | Futures | 1888.07 | 1889.89 | 1885.99 | 1886.77 | 70293.0 |
| 2014-04-14 15:00:00 | ES | Futures | 1886.77 | 1887.29 | 1878.72 | 1884.17 | 163841.0 |
| 2014-04-14 15:30:00 | ES | Futures | 1884.17 | 1895.6 | 1884.17 | 1894.3 | 202563.0 |
| 2014-04-14 16:00:00 | ES | Futures | 1894.3 | 1895.86 | 1893.78 | 1895.08 | 74057.0 |
| 2014-04-14 16:30:00 | ES | Futures | 1895.34 | 1895.86 | 1895.08 | 1895.34 | 6563.0 |
| 2014-04-14 17:00:00 | ES | Futures | 1895.34 | 1895.86 | 1895.08 | 1895.6 | 2628.0 |
| 2014-04-14 18:00:00 | ES | Futures | 1895.6 | 1896.64 | 1895.34 | 1895.34 | 2596.0 |
| 2014-04-14 18:30:00 | ES | Futures | 1895.34 | 1895.6 | 1894.82 | 1895.08 | 2420.0 |
| 2014-04-14 19:00:00 | ES | Futures | 1895.08 | 1896.38 | 1895.08 | 1895.34 | 2443.0 |
| 2014-04-14 19:30:00 | ES | Futures | 1895.34 | 1895.86 | 1895.08 | 1895.6 | 1653.0 |
| 2014-04-14 20:00:00 | ES | Futures | 1895.34 | 1895.6 | 1894.82 | 1894.82 | 2495.0 |
| 2014-04-14 20:30:00 | ES | Futures | 1895.08 | 1895.6 | 1894.82 | 1895.34 | 1430.0 |
| 2014-04-14 21:00:00 | ES | Futures | 1895.34 | 1897.42 | 1895.08 | 1896.38 | 4056.0 |
| 2014-04-14 21:30:00 | ES | Futures | 1896.38 | 1896.38 | 1895.08 | 1895.34 | 1866.0 |
| 2014-04-14 22:00:00 | ES | Futures | 1895.34 | 1895.6 | 1894.56 | 1895.34 | 1580.0 |
| 2014-04-14 22:30:00 | ES | Futures | 1895.6 | 1896.12 | 1895.34 | 1895.6 | 920.0 |
| 2014-04-14 23:00:00 | ES | Futures | 1895.6 | 1896.12 | 1895.08 | 1895.6 | 1403.0 |
| 2014-04-14 23:30:00 | ES | Futures | 1895.6 | 1896.38 | 1895.34 | 1895.6 | 1323.0 |
| 2014-04-14 00:00:00 | NQ | Futures | 4005.47 | 4008.09 | 4004.31 | 4007.8 | 174.0 |
| 2014-04-14 00:30:00 | NQ | Futures | 4006.93 | 4006.93 | 4004.31 | 4006.05 | 265.0 |
| 2014-04-14 01:00:00 | NQ | Futures | 4006.05 | 4009.55 | 4006.05 | 4006.93 | 247.0 |
> showing 50 of 2,871 rows — these rows as CSV