PREVIEW / futures_30min / 2013-11-21
file: by_date/futures_30min/2013/2013-11-21.parquet size: 77 KB rows: 2,836
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-21 00:00:00 | ES | Futures | 1832.81 | 1833.84 | 1832.81 | 1833.07 | 2061.0 |
| 2013-11-21 00:30:00 | ES | Futures | 1833.07 | 1833.58 | 1832.81 | 1833.32 | 1919.0 |
| 2013-11-21 01:00:00 | ES | Futures | 1833.07 | 1834.87 | 1833.07 | 1834.61 | 2217.0 |
| 2013-11-21 01:30:00 | ES | Futures | 1834.36 | 1834.87 | 1834.1 | 1834.1 | 1722.0 |
| 2013-11-21 02:00:00 | ES | Futures | 1834.1 | 1834.61 | 1834.1 | 1834.61 | 3843.0 |
| 2013-11-21 02:30:00 | ES | Futures | 1834.61 | 1836.16 | 1834.61 | 1835.13 | 5293.0 |
| 2013-11-21 03:00:00 | ES | Futures | 1835.13 | 1835.39 | 1832.29 | 1834.1 | 21296.0 |
| 2013-11-21 03:30:00 | ES | Futures | 1833.84 | 1835.9 | 1833.07 | 1835.39 | 11593.0 |
| 2013-11-21 04:00:00 | ES | Futures | 1835.39 | 1837.71 | 1834.61 | 1837.19 | 27047.0 |
| 2013-11-21 04:30:00 | ES | Futures | 1837.19 | 1839.52 | 1837.19 | 1839.0 | 17570.0 |
| 2013-11-21 05:00:00 | ES | Futures | 1839.0 | 1840.29 | 1838.23 | 1839.77 | 11756.0 |
| 2013-11-21 05:30:00 | ES | Futures | 1839.77 | 1840.55 | 1839.77 | 1840.55 | 5464.0 |
| 2013-11-21 06:00:00 | ES | Futures | 1840.81 | 1840.81 | 1839.77 | 1840.29 | 12616.0 |
| 2013-11-21 06:30:00 | ES | Futures | 1840.29 | 1840.55 | 1838.23 | 1839.26 | 16319.0 |
| 2013-11-21 07:00:00 | ES | Futures | 1839.52 | 1839.52 | 1838.48 | 1839.0 | 7321.0 |
| 2013-11-21 07:30:00 | ES | Futures | 1838.74 | 1841.32 | 1838.48 | 1840.55 | 15428.0 |
| 2013-11-21 08:00:00 | ES | Futures | 1840.55 | 1842.87 | 1840.55 | 1841.84 | 23590.0 |
| 2013-11-21 08:30:00 | ES | Futures | 1841.84 | 1842.1 | 1839.77 | 1839.77 | 22314.0 |
| 2013-11-21 09:00:00 | ES | Futures | 1839.77 | 1842.1 | 1839.77 | 1841.58 | 26167.0 |
| 2013-11-21 09:30:00 | ES | Futures | 1841.58 | 1845.45 | 1840.29 | 1844.67 | 191795.0 |
| 2013-11-21 10:00:00 | ES | Futures | 1844.67 | 1845.96 | 1842.35 | 1844.42 | 127150.0 |
| 2013-11-21 10:30:00 | ES | Futures | 1844.67 | 1848.8 | 1844.67 | 1847.51 | 118304.0 |
| 2013-11-21 11:00:00 | ES | Futures | 1847.77 | 1848.54 | 1846.22 | 1848.29 | 53052.0 |
| 2013-11-21 11:30:00 | ES | Futures | 1848.29 | 1849.06 | 1846.22 | 1848.29 | 69499.0 |
| 2013-11-21 12:00:00 | ES | Futures | 1848.29 | 1848.54 | 1846.22 | 1848.03 | 39823.0 |
| 2013-11-21 12:30:00 | ES | Futures | 1848.03 | 1848.29 | 1845.45 | 1845.45 | 39748.0 |
| 2013-11-21 13:00:00 | ES | Futures | 1845.45 | 1848.54 | 1845.45 | 1848.03 | 42154.0 |
| 2013-11-21 13:30:00 | ES | Futures | 1848.03 | 1850.87 | 1847.77 | 1850.61 | 71542.0 |
| 2013-11-21 14:00:00 | ES | Futures | 1850.35 | 1851.12 | 1849.32 | 1850.09 | 37189.0 |
| 2013-11-21 14:30:00 | ES | Futures | 1850.09 | 1851.9 | 1849.06 | 1850.61 | 52155.0 |
| 2013-11-21 15:00:00 | ES | Futures | 1850.87 | 1852.67 | 1850.61 | 1851.9 | 57344.0 |
| 2013-11-21 15:30:00 | ES | Futures | 1851.64 | 1852.16 | 1849.58 | 1850.61 | 126822.0 |
| 2013-11-21 16:00:00 | ES | Futures | 1850.87 | 1851.38 | 1849.83 | 1850.87 | 77879.0 |
| 2013-11-21 16:30:00 | ES | Futures | 1850.87 | 1851.64 | 1850.61 | 1851.12 | 6199.0 |
| 2013-11-21 17:00:00 | ES | Futures | 1850.87 | 1851.38 | 1850.61 | 1850.87 | 2659.0 |
| 2013-11-21 18:00:00 | ES | Futures | 1850.35 | 1852.16 | 1850.09 | 1851.9 | 5727.0 |
| 2013-11-21 18:30:00 | ES | Futures | 1852.16 | 1852.67 | 1851.64 | 1852.41 | 3873.0 |
| 2013-11-21 19:00:00 | ES | Futures | 1852.16 | 1852.41 | 1851.12 | 1852.16 | 2077.0 |
| 2013-11-21 19:30:00 | ES | Futures | 1851.9 | 1852.16 | 1851.38 | 1852.16 | 1545.0 |
| 2013-11-21 20:00:00 | ES | Futures | 1851.9 | 1852.16 | 1851.64 | 1852.16 | 1461.0 |
| 2013-11-21 20:30:00 | ES | Futures | 1851.9 | 1852.16 | 1850.87 | 1851.64 | 1937.0 |
| 2013-11-21 21:00:00 | ES | Futures | 1851.64 | 1851.9 | 1851.12 | 1851.64 | 650.0 |
| 2013-11-21 21:30:00 | ES | Futures | 1851.64 | 1851.9 | 1851.38 | 1851.64 | 912.0 |
| 2013-11-21 22:00:00 | ES | Futures | 1851.38 | 1851.64 | 1850.87 | 1851.12 | 790.0 |
| 2013-11-21 22:30:00 | ES | Futures | 1851.12 | 1851.38 | 1850.35 | 1850.35 | 1563.0 |
| 2013-11-21 23:00:00 | ES | Futures | 1850.61 | 1851.38 | 1850.09 | 1850.35 | 2160.0 |
| 2013-11-21 23:30:00 | ES | Futures | 1850.61 | 1850.87 | 1849.58 | 1849.83 | 2123.0 |
| 2013-11-21 00:00:00 | NQ | Futures | 3905.74 | 3907.19 | 3905.16 | 3906.61 | 281.0 |
| 2013-11-21 00:30:00 | NQ | Futures | 3906.9 | 3908.06 | 3906.9 | 3907.77 | 278.0 |
| 2013-11-21 01:00:00 | NQ | Futures | 3907.77 | 3911.25 | 3907.77 | 3910.67 | 467.0 |
> showing 50 of 2,836 rows — these rows as CSV