PREVIEW / futures_30min / 2013-12-17
file: by_date/futures_30min/2013/2013-12-17.parquet size: 73 KB rows: 2,872
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-17 00:00:00 | ES | Futures | 1841.61 | 1842.13 | 1841.35 | 1841.87 | 943.0 |
| 2013-12-17 00:30:00 | ES | Futures | 1841.87 | 1842.13 | 1841.61 | 1841.87 | 444.0 |
| 2013-12-17 01:00:00 | ES | Futures | 1842.13 | 1842.13 | 1841.87 | 1841.87 | 102.0 |
| 2013-12-17 01:30:00 | ES | Futures | 1841.87 | 1842.13 | 1841.35 | 1841.35 | 555.0 |
| 2013-12-17 02:00:00 | ES | Futures | 1841.61 | 1841.61 | 1840.06 | 1840.58 | 2252.0 |
| 2013-12-17 02:30:00 | ES | Futures | 1840.58 | 1841.87 | 1840.06 | 1841.61 | 2881.0 |
| 2013-12-17 03:00:00 | ES | Futures | 1841.61 | 1841.87 | 1839.28 | 1839.8 | 5982.0 |
| 2013-12-17 03:30:00 | ES | Futures | 1839.8 | 1841.61 | 1839.28 | 1841.09 | 4345.0 |
| 2013-12-17 04:00:00 | ES | Futures | 1841.09 | 1841.35 | 1839.02 | 1839.54 | 6312.0 |
| 2013-12-17 04:30:00 | ES | Futures | 1839.28 | 1840.84 | 1839.02 | 1840.32 | 3710.0 |
| 2013-12-17 05:00:00 | ES | Futures | 1840.58 | 1840.84 | 1839.54 | 1840.06 | 3521.0 |
| 2013-12-17 05:30:00 | ES | Futures | 1840.06 | 1841.61 | 1840.06 | 1841.35 | 5005.0 |
| 2013-12-17 06:00:00 | ES | Futures | 1841.09 | 1841.35 | 1840.32 | 1840.58 | 2580.0 |
| 2013-12-17 06:30:00 | ES | Futures | 1840.84 | 1841.35 | 1840.58 | 1841.09 | 2187.0 |
| 2013-12-17 07:00:00 | ES | Futures | 1841.09 | 1843.42 | 1841.09 | 1842.9 | 10482.0 |
| 2013-12-17 07:30:00 | ES | Futures | 1843.16 | 1843.42 | 1841.87 | 1842.9 | 8008.0 |
| 2013-12-17 08:00:00 | ES | Futures | 1842.9 | 1843.16 | 1841.61 | 1842.39 | 7137.0 |
| 2013-12-17 08:30:00 | ES | Futures | 1842.39 | 1844.2 | 1841.87 | 1842.9 | 20457.0 |
| 2013-12-17 09:00:00 | ES | Futures | 1842.9 | 1843.68 | 1841.61 | 1843.16 | 19525.0 |
| 2013-12-17 09:30:00 | ES | Futures | 1843.16 | 1843.94 | 1835.4 | 1839.28 | 181570.0 |
| 2013-12-17 10:00:00 | ES | Futures | 1839.28 | 1840.32 | 1837.47 | 1837.99 | 92866.0 |
| 2013-12-17 10:30:00 | ES | Futures | 1837.73 | 1839.02 | 1832.82 | 1833.85 | 117271.0 |
| 2013-12-17 11:00:00 | ES | Futures | 1834.11 | 1834.11 | 1831.52 | 1832.04 | 80545.0 |
| 2013-12-17 11:30:00 | ES | Futures | 1832.3 | 1834.63 | 1831.52 | 1834.11 | 76086.0 |
| 2013-12-17 12:00:00 | ES | Futures | 1834.11 | 1835.66 | 1833.08 | 1834.63 | 47303.0 |
| 2013-12-17 12:30:00 | ES | Futures | 1834.89 | 1837.21 | 1834.37 | 1836.18 | 40369.0 |
| 2013-12-17 13:00:00 | ES | Futures | 1836.18 | 1837.21 | 1835.66 | 1836.44 | 33455.0 |
| 2013-12-17 13:30:00 | ES | Futures | 1836.7 | 1837.47 | 1834.89 | 1836.18 | 36292.0 |
| 2013-12-17 14:00:00 | ES | Futures | 1836.18 | 1840.84 | 1835.92 | 1839.54 | 64166.0 |
| 2013-12-17 14:30:00 | ES | Futures | 1839.54 | 1839.54 | 1836.44 | 1837.47 | 61648.0 |
| 2013-12-17 15:00:00 | ES | Futures | 1837.21 | 1839.54 | 1837.21 | 1838.77 | 66808.0 |
| 2013-12-17 15:30:00 | ES | Futures | 1838.77 | 1839.28 | 1835.4 | 1835.4 | 118609.0 |
| 2013-12-17 16:00:00 | ES | Futures | 1835.66 | 1835.66 | 1833.33 | 1834.37 | 78188.0 |
| 2013-12-17 16:30:00 | ES | Futures | 1834.11 | 1834.37 | 1832.82 | 1833.33 | 8341.0 |
| 2013-12-17 17:00:00 | ES | Futures | 1833.33 | 1833.85 | 1833.08 | 1833.08 | 1805.0 |
| 2013-12-17 18:00:00 | ES | Futures | 1833.33 | 1834.89 | 1833.33 | 1834.63 | 2696.0 |
| 2013-12-17 18:30:00 | ES | Futures | 1834.89 | 1835.4 | 1834.63 | 1835.14 | 1893.0 |
| 2013-12-17 19:00:00 | ES | Futures | 1835.14 | 1836.96 | 1834.89 | 1836.96 | 4140.0 |
| 2013-12-17 19:30:00 | ES | Futures | 1836.96 | 1837.99 | 1836.7 | 1836.7 | 3954.0 |
| 2013-12-17 20:00:00 | ES | Futures | 1836.7 | 1837.47 | 1836.44 | 1836.44 | 2121.0 |
| 2013-12-17 20:30:00 | ES | Futures | 1836.44 | 1836.96 | 1834.89 | 1835.66 | 2995.0 |
| 2013-12-17 21:00:00 | ES | Futures | 1835.66 | 1837.21 | 1835.66 | 1836.44 | 2013.0 |
| 2013-12-17 21:30:00 | ES | Futures | 1836.44 | 1837.47 | 1836.44 | 1837.47 | 782.0 |
| 2013-12-17 22:00:00 | ES | Futures | 1837.47 | 1837.47 | 1836.7 | 1836.96 | 1379.0 |
| 2013-12-17 22:30:00 | ES | Futures | 1837.21 | 1837.47 | 1836.96 | 1837.21 | 971.0 |
| 2013-12-17 23:00:00 | ES | Futures | 1837.47 | 1837.73 | 1836.96 | 1837.73 | 1075.0 |
| 2013-12-17 23:30:00 | ES | Futures | 1837.47 | 1837.47 | 1836.96 | 1837.21 | 1010.0 |
| 2013-12-17 00:00:00 | NQ | Futures | 4034.7 | 4036.16 | 4034.41 | 4034.99 | 128.0 |
| 2013-12-17 00:30:00 | NQ | Futures | 4035.29 | 4036.16 | 4034.99 | 4036.16 | 75.0 |
| 2013-12-17 01:00:00 | NQ | Futures | 4036.16 | 4036.74 | 4035.58 | 4036.16 | 37.0 |
> showing 50 of 2,872 rows — these rows as CSV