PREVIEW / futures_30min / 2013-11-19
file: by_date/futures_30min/2013/2013-11-19.parquet size: 74 KB rows: 2,840
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-11-19 00:00:00 | ES | Futures | 1846.48 | 1848.29 | 1846.22 | 1847.25 | 2389.0 |
| 2013-11-19 00:30:00 | ES | Futures | 1847.25 | 1848.29 | 1847.0 | 1847.77 | 2126.0 |
| 2013-11-19 01:00:00 | ES | Futures | 1848.03 | 1848.03 | 1847.25 | 1847.51 | 1251.0 |
| 2013-11-19 01:30:00 | ES | Futures | 1847.51 | 1847.77 | 1847.25 | 1847.25 | 928.0 |
| 2013-11-19 02:00:00 | ES | Futures | 1847.0 | 1847.25 | 1845.45 | 1846.22 | 3409.0 |
| 2013-11-19 02:30:00 | ES | Futures | 1845.96 | 1846.74 | 1845.71 | 1846.74 | 1891.0 |
| 2013-11-19 03:00:00 | ES | Futures | 1846.48 | 1847.51 | 1844.16 | 1844.42 | 14435.0 |
| 2013-11-19 03:30:00 | ES | Futures | 1844.67 | 1844.67 | 1842.35 | 1842.35 | 10641.0 |
| 2013-11-19 04:00:00 | ES | Futures | 1842.61 | 1845.19 | 1842.61 | 1843.64 | 7958.0 |
| 2013-11-19 04:30:00 | ES | Futures | 1843.64 | 1843.9 | 1842.87 | 1843.13 | 4890.0 |
| 2013-11-19 05:00:00 | ES | Futures | 1843.13 | 1843.64 | 1841.58 | 1842.1 | 11545.0 |
| 2013-11-19 05:30:00 | ES | Futures | 1842.35 | 1843.64 | 1841.84 | 1843.13 | 5561.0 |
| 2013-11-19 06:00:00 | ES | Futures | 1843.13 | 1844.42 | 1842.87 | 1843.9 | 18186.0 |
| 2013-11-19 06:30:00 | ES | Futures | 1843.9 | 1844.42 | 1842.61 | 1842.87 | 11625.0 |
| 2013-11-19 07:00:00 | ES | Futures | 1842.87 | 1843.13 | 1841.06 | 1841.32 | 15247.0 |
| 2013-11-19 07:30:00 | ES | Futures | 1841.32 | 1842.87 | 1841.32 | 1842.35 | 13610.0 |
| 2013-11-19 08:00:00 | ES | Futures | 1842.35 | 1843.13 | 1842.1 | 1842.87 | 15486.0 |
| 2013-11-19 08:30:00 | ES | Futures | 1843.13 | 1844.93 | 1842.87 | 1844.67 | 25617.0 |
| 2013-11-19 09:00:00 | ES | Futures | 1844.42 | 1846.48 | 1844.16 | 1844.93 | 22172.0 |
| 2013-11-19 09:30:00 | ES | Futures | 1845.19 | 1846.74 | 1840.29 | 1845.71 | 214815.0 |
| 2013-11-19 10:00:00 | ES | Futures | 1845.71 | 1849.83 | 1845.45 | 1847.25 | 124781.0 |
| 2013-11-19 10:30:00 | ES | Futures | 1847.25 | 1850.87 | 1847.0 | 1848.8 | 124121.0 |
| 2013-11-19 11:00:00 | ES | Futures | 1848.8 | 1849.06 | 1844.67 | 1845.45 | 83048.0 |
| 2013-11-19 11:30:00 | ES | Futures | 1845.45 | 1846.48 | 1843.13 | 1845.71 | 72303.0 |
| 2013-11-19 12:00:00 | ES | Futures | 1845.71 | 1849.06 | 1844.93 | 1848.54 | 69801.0 |
| 2013-11-19 12:30:00 | ES | Futures | 1848.54 | 1848.8 | 1844.93 | 1845.19 | 42012.0 |
| 2013-11-19 13:00:00 | ES | Futures | 1844.93 | 1845.45 | 1840.29 | 1840.55 | 89577.0 |
| 2013-11-19 13:30:00 | ES | Futures | 1840.55 | 1842.61 | 1839.0 | 1839.77 | 95676.0 |
| 2013-11-19 14:00:00 | ES | Futures | 1839.77 | 1842.61 | 1838.74 | 1839.52 | 95740.0 |
| 2013-11-19 14:30:00 | ES | Futures | 1839.77 | 1845.19 | 1839.52 | 1842.35 | 97359.0 |
| 2013-11-19 15:00:00 | ES | Futures | 1842.61 | 1846.48 | 1842.35 | 1844.16 | 69954.0 |
| 2013-11-19 15:30:00 | ES | Futures | 1844.16 | 1844.67 | 1840.81 | 1842.35 | 125765.0 |
| 2013-11-19 16:00:00 | ES | Futures | 1842.35 | 1842.87 | 1841.32 | 1842.1 | 58090.0 |
| 2013-11-19 16:30:00 | ES | Futures | 1842.1 | 1842.35 | 1841.58 | 1842.35 | 6608.0 |
| 2013-11-19 17:00:00 | ES | Futures | 1842.35 | 1842.61 | 1841.58 | 1841.84 | 1716.0 |
| 2013-11-19 18:00:00 | ES | Futures | 1842.35 | 1847.0 | 1841.84 | 1846.74 | 8932.0 |
| 2013-11-19 18:30:00 | ES | Futures | 1846.74 | 1847.51 | 1843.9 | 1845.19 | 6771.0 |
| 2013-11-19 19:00:00 | ES | Futures | 1845.19 | 1845.45 | 1843.13 | 1843.39 | 2955.0 |
| 2013-11-19 19:30:00 | ES | Futures | 1843.39 | 1843.64 | 1841.06 | 1841.32 | 7146.0 |
| 2013-11-19 20:00:00 | ES | Futures | 1841.32 | 1842.87 | 1841.06 | 1842.35 | 2882.0 |
| 2013-11-19 20:30:00 | ES | Futures | 1842.1 | 1842.35 | 1841.58 | 1842.1 | 1508.0 |
| 2013-11-19 21:00:00 | ES | Futures | 1842.1 | 1842.1 | 1841.06 | 1841.06 | 2181.0 |
| 2013-11-19 21:30:00 | ES | Futures | 1841.06 | 1841.58 | 1841.06 | 1841.58 | 1016.0 |
| 2013-11-19 22:00:00 | ES | Futures | 1841.32 | 1841.58 | 1841.06 | 1841.06 | 531.0 |
| 2013-11-19 22:30:00 | ES | Futures | 1841.32 | 1841.84 | 1840.81 | 1841.84 | 1557.0 |
| 2013-11-19 23:00:00 | ES | Futures | 1841.84 | 1842.1 | 1841.58 | 1842.1 | 489.0 |
| 2013-11-19 23:30:00 | ES | Futures | 1842.1 | 1842.61 | 1841.84 | 1842.61 | 1154.0 |
| 2013-11-19 00:00:00 | NQ | Futures | 3933.91 | 3938.26 | 3933.91 | 3936.23 | 416.0 |
| 2013-11-19 00:30:00 | NQ | Futures | 3935.94 | 3938.26 | 3935.36 | 3936.81 | 248.0 |
| 2013-11-19 01:00:00 | NQ | Futures | 3936.81 | 3937.1 | 3935.65 | 3936.23 | 73.0 |
> showing 50 of 2,840 rows — these rows as CSV