PREVIEW / futures_30min / 2014-02-07
file: by_date/futures_30min/2014/2014-02-07.parquet size: 68 KB rows: 2,384
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-02-07 00:00:00 | ES | Futures | 1828.68 | 1830.23 | 1828.68 | 1829.97 | 1801.0 |
| 2014-02-07 00:30:00 | ES | Futures | 1829.97 | 1830.49 | 1829.45 | 1829.97 | 861.0 |
| 2014-02-07 01:00:00 | ES | Futures | 1830.23 | 1836.96 | 1829.97 | 1835.14 | 13258.0 |
| 2014-02-07 01:30:00 | ES | Futures | 1835.14 | 1835.66 | 1834.37 | 1835.4 | 2878.0 |
| 2014-02-07 02:00:00 | ES | Futures | 1835.66 | 1835.66 | 1833.08 | 1834.37 | 5597.0 |
| 2014-02-07 02:30:00 | ES | Futures | 1834.37 | 1834.37 | 1832.82 | 1833.08 | 3497.0 |
| 2014-02-07 03:00:00 | ES | Futures | 1833.33 | 1833.33 | 1830.75 | 1831.27 | 14996.0 |
| 2014-02-07 03:30:00 | ES | Futures | 1831.27 | 1831.27 | 1827.64 | 1829.45 | 20040.0 |
| 2014-02-07 04:00:00 | ES | Futures | 1829.2 | 1833.85 | 1829.2 | 1832.56 | 14231.0 |
| 2014-02-07 04:30:00 | ES | Futures | 1832.56 | 1834.63 | 1832.3 | 1833.85 | 8815.0 |
| 2014-02-07 05:00:00 | ES | Futures | 1833.85 | 1834.11 | 1832.82 | 1833.08 | 6342.0 |
| 2014-02-07 05:30:00 | ES | Futures | 1833.08 | 1833.33 | 1832.3 | 1833.08 | 5574.0 |
| 2014-02-07 06:00:00 | ES | Futures | 1833.33 | 1833.33 | 1832.3 | 1832.82 | 6235.0 |
| 2014-02-07 06:30:00 | ES | Futures | 1833.08 | 1833.85 | 1831.27 | 1833.08 | 10282.0 |
| 2014-02-07 07:00:00 | ES | Futures | 1833.08 | 1835.14 | 1832.82 | 1834.89 | 13140.0 |
| 2014-02-07 07:30:00 | ES | Futures | 1834.89 | 1835.4 | 1833.85 | 1835.4 | 13498.0 |
| 2014-02-07 08:00:00 | ES | Futures | 1835.14 | 1836.96 | 1833.08 | 1835.66 | 33234.0 |
| 2014-02-07 08:30:00 | ES | Futures | 1835.4 | 1847.82 | 1819.11 | 1841.09 | 373394.0 |
| 2014-02-07 09:00:00 | ES | Futures | 1841.35 | 1841.35 | 1836.7 | 1839.8 | 81301.0 |
| 2014-02-07 09:30:00 | ES | Futures | 1839.54 | 1845.49 | 1837.21 | 1841.61 | 278837.0 |
| 2014-02-07 10:00:00 | ES | Futures | 1841.61 | 1843.68 | 1833.59 | 1834.63 | 219889.0 |
| 2014-02-07 10:30:00 | ES | Futures | 1834.89 | 1840.32 | 1834.37 | 1839.54 | 130400.0 |
| 2014-02-07 11:00:00 | ES | Futures | 1839.54 | 1841.35 | 1837.99 | 1840.84 | 89180.0 |
| 2014-02-07 11:30:00 | ES | Futures | 1840.84 | 1846.27 | 1840.84 | 1846.01 | 102002.0 |
| 2014-02-07 12:00:00 | ES | Futures | 1846.01 | 1846.01 | 1843.68 | 1845.23 | 57213.0 |
| 2014-02-07 12:30:00 | ES | Futures | 1845.23 | 1846.01 | 1843.16 | 1845.49 | 49438.0 |
| 2014-02-07 13:00:00 | ES | Futures | 1845.49 | 1847.56 | 1845.23 | 1846.78 | 63028.0 |
| 2014-02-07 13:30:00 | ES | Futures | 1847.04 | 1851.44 | 1846.53 | 1850.66 | 135278.0 |
| 2014-02-07 14:00:00 | ES | Futures | 1850.66 | 1851.7 | 1849.63 | 1850.66 | 71207.0 |
| 2014-02-07 14:30:00 | ES | Futures | 1850.92 | 1852.22 | 1849.63 | 1851.18 | 85110.0 |
| 2014-02-07 15:00:00 | ES | Futures | 1851.18 | 1853.51 | 1850.92 | 1852.73 | 83009.0 |
| 2014-02-07 15:30:00 | ES | Futures | 1852.73 | 1855.84 | 1852.22 | 1854.03 | 202229.0 |
| 2014-02-07 16:00:00 | ES | Futures | 1853.77 | 1856.1 | 1853.51 | 1855.32 | 109004.0 |
| 2014-02-07 16:30:00 | ES | Futures | 1855.32 | 1855.58 | 1854.54 | 1855.06 | 6277.0 |
| 2014-02-07 17:00:00 | ES | Futures | 1855.06 | 1855.58 | 1854.54 | 1855.58 | 1616.0 |
| 2014-02-07 00:00:00 | NQ | Futures | 4059.12 | 4062.03 | 4059.12 | 4061.45 | 215.0 |
| 2014-02-07 00:30:00 | NQ | Futures | 4061.74 | 4062.9 | 4060.58 | 4062.32 | 213.0 |
| 2014-02-07 01:00:00 | NQ | Futures | 4062.32 | 4077.14 | 4062.32 | 4074.53 | 1468.0 |
| 2014-02-07 01:30:00 | NQ | Futures | 4074.82 | 4075.98 | 4072.78 | 4074.82 | 537.0 |
| 2014-02-07 02:00:00 | NQ | Futures | 4074.24 | 4074.53 | 4068.42 | 4070.75 | 395.0 |
| 2014-02-07 02:30:00 | NQ | Futures | 4070.75 | 4071.04 | 4068.71 | 4069.88 | 265.0 |
| 2014-02-07 03:00:00 | NQ | Futures | 4069.88 | 4070.17 | 4064.35 | 4066.97 | 2968.0 |
| 2014-02-07 03:30:00 | NQ | Futures | 4066.68 | 4067.26 | 4060.58 | 4062.9 | 2215.0 |
| 2014-02-07 04:00:00 | NQ | Futures | 4062.9 | 4075.11 | 4062.9 | 4071.91 | 2218.0 |
| 2014-02-07 04:30:00 | NQ | Futures | 4072.2 | 4077.73 | 4071.91 | 4076.56 | 1446.0 |
| 2014-02-07 05:00:00 | NQ | Futures | 4076.56 | 4076.56 | 4073.66 | 4075.11 | 732.0 |
| 2014-02-07 05:30:00 | NQ | Futures | 4075.11 | 4076.27 | 4073.37 | 4076.27 | 671.0 |
| 2014-02-07 06:00:00 | NQ | Futures | 4076.27 | 4077.14 | 4074.24 | 4076.85 | 1138.0 |
| 2014-02-07 06:30:00 | NQ | Futures | 4076.85 | 4078.31 | 4072.49 | 4076.56 | 1106.0 |
| 2014-02-07 07:00:00 | NQ | Futures | 4076.27 | 4079.47 | 4075.11 | 4078.6 | 1364.0 |
> showing 50 of 2,384 rows — these rows as CSV