PREVIEW / futures_30min / 2014-01-30
file: by_date/futures_30min/2014/2014-01-30.parquet size: 80 KB rows: 2,977
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-01-30 00:00:00 | ES | Futures | 1836.18 | 1836.18 | 1835.4 | 1835.66 | 1982.0 |
| 2014-01-30 00:30:00 | ES | Futures | 1835.4 | 1835.92 | 1834.11 | 1835.14 | 2793.0 |
| 2014-01-30 01:00:00 | ES | Futures | 1835.14 | 1836.7 | 1834.37 | 1836.7 | 2660.0 |
| 2014-01-30 01:30:00 | ES | Futures | 1836.7 | 1836.7 | 1834.89 | 1836.44 | 1462.0 |
| 2014-01-30 02:00:00 | ES | Futures | 1836.44 | 1838.51 | 1836.18 | 1838.25 | 5581.0 |
| 2014-01-30 02:30:00 | ES | Futures | 1837.99 | 1838.25 | 1836.44 | 1836.96 | 3570.0 |
| 2014-01-30 03:00:00 | ES | Futures | 1836.96 | 1837.73 | 1833.85 | 1835.14 | 20608.0 |
| 2014-01-30 03:30:00 | ES | Futures | 1835.14 | 1837.21 | 1833.59 | 1833.85 | 11714.0 |
| 2014-01-30 04:00:00 | ES | Futures | 1833.85 | 1836.18 | 1832.04 | 1834.11 | 20677.0 |
| 2014-01-30 04:30:00 | ES | Futures | 1834.37 | 1837.21 | 1834.11 | 1834.63 | 11981.0 |
| 2014-01-30 05:00:00 | ES | Futures | 1834.89 | 1837.47 | 1834.63 | 1836.96 | 7661.0 |
| 2014-01-30 05:30:00 | ES | Futures | 1836.96 | 1837.99 | 1834.89 | 1836.7 | 9027.0 |
| 2014-01-30 06:00:00 | ES | Futures | 1836.96 | 1840.58 | 1835.4 | 1837.73 | 21395.0 |
| 2014-01-30 06:30:00 | ES | Futures | 1837.99 | 1840.58 | 1837.47 | 1838.51 | 10817.0 |
| 2014-01-30 07:00:00 | ES | Futures | 1838.51 | 1838.77 | 1836.96 | 1837.47 | 12798.0 |
| 2014-01-30 07:30:00 | ES | Futures | 1837.47 | 1839.02 | 1836.44 | 1838.25 | 13379.0 |
| 2014-01-30 08:00:00 | ES | Futures | 1838.25 | 1839.02 | 1835.14 | 1835.92 | 17430.0 |
| 2014-01-30 08:30:00 | ES | Futures | 1836.18 | 1842.65 | 1834.63 | 1842.39 | 54633.0 |
| 2014-01-30 09:00:00 | ES | Futures | 1842.39 | 1846.78 | 1841.87 | 1845.75 | 64753.0 |
| 2014-01-30 09:30:00 | ES | Futures | 1846.01 | 1847.3 | 1841.87 | 1842.65 | 224170.0 |
| 2014-01-30 10:00:00 | ES | Futures | 1842.39 | 1845.49 | 1839.54 | 1842.65 | 169893.0 |
| 2014-01-30 10:30:00 | ES | Futures | 1842.9 | 1846.78 | 1842.9 | 1844.97 | 111187.0 |
| 2014-01-30 11:00:00 | ES | Futures | 1844.97 | 1848.85 | 1843.42 | 1847.04 | 101561.0 |
| 2014-01-30 11:30:00 | ES | Futures | 1847.04 | 1854.03 | 1847.04 | 1852.73 | 154352.0 |
| 2014-01-30 12:00:00 | ES | Futures | 1852.99 | 1853.77 | 1851.44 | 1851.44 | 57485.0 |
| 2014-01-30 12:30:00 | ES | Futures | 1851.7 | 1855.84 | 1851.44 | 1854.54 | 70430.0 |
| 2014-01-30 13:00:00 | ES | Futures | 1854.54 | 1854.8 | 1852.47 | 1852.73 | 46684.0 |
| 2014-01-30 13:30:00 | ES | Futures | 1852.73 | 1853.25 | 1850.92 | 1851.44 | 54716.0 |
| 2014-01-30 14:00:00 | ES | Futures | 1851.44 | 1851.7 | 1848.34 | 1851.44 | 59969.0 |
| 2014-01-30 14:30:00 | ES | Futures | 1851.44 | 1852.99 | 1850.41 | 1851.44 | 54539.0 |
| 2014-01-30 15:00:00 | ES | Futures | 1851.18 | 1854.8 | 1851.18 | 1853.51 | 58391.0 |
| 2014-01-30 15:30:00 | ES | Futures | 1853.51 | 1854.03 | 1849.63 | 1850.66 | 157568.0 |
| 2014-01-30 16:00:00 | ES | Futures | 1850.66 | 1850.92 | 1842.39 | 1842.65 | 124422.0 |
| 2014-01-30 16:30:00 | ES | Futures | 1842.9 | 1846.78 | 1842.65 | 1846.01 | 17789.0 |
| 2014-01-30 17:00:00 | ES | Futures | 1846.01 | 1847.04 | 1845.23 | 1845.49 | 3469.0 |
| 2014-01-30 18:00:00 | ES | Futures | 1845.23 | 1846.27 | 1843.94 | 1846.01 | 6282.0 |
| 2014-01-30 18:30:00 | ES | Futures | 1846.01 | 1846.27 | 1844.97 | 1845.23 | 1708.0 |
| 2014-01-30 19:00:00 | ES | Futures | 1845.49 | 1845.49 | 1843.68 | 1844.97 | 3176.0 |
| 2014-01-30 19:30:00 | ES | Futures | 1844.97 | 1846.27 | 1844.72 | 1846.01 | 1601.0 |
| 2014-01-30 20:00:00 | ES | Futures | 1846.27 | 1846.53 | 1844.97 | 1845.23 | 1517.0 |
| 2014-01-30 20:30:00 | ES | Futures | 1844.97 | 1846.01 | 1844.72 | 1845.49 | 782.0 |
| 2014-01-30 21:00:00 | ES | Futures | 1845.49 | 1845.75 | 1844.97 | 1845.23 | 749.0 |
| 2014-01-30 21:30:00 | ES | Futures | 1845.49 | 1845.75 | 1844.46 | 1845.75 | 1016.0 |
| 2014-01-30 22:00:00 | ES | Futures | 1845.75 | 1846.01 | 1845.23 | 1845.49 | 473.0 |
| 2014-01-30 22:30:00 | ES | Futures | 1845.23 | 1845.75 | 1843.16 | 1843.42 | 4191.0 |
| 2014-01-30 23:00:00 | ES | Futures | 1843.42 | 1843.42 | 1840.32 | 1840.32 | 8247.0 |
| 2014-01-30 23:30:00 | ES | Futures | 1840.32 | 1841.09 | 1838.51 | 1838.77 | 7471.0 |
| 2014-01-30 00:00:00 | NQ | Futures | 4051.85 | 4052.15 | 4049.24 | 4049.24 | 271.0 |
| 2014-01-30 00:30:00 | NQ | Futures | 4049.53 | 4050.69 | 4047.2 | 4049.53 | 424.0 |
| 2014-01-30 01:00:00 | NQ | Futures | 4049.53 | 4052.73 | 4048.08 | 4051.85 | 309.0 |
> showing 50 of 2,977 rows — these rows as CSV