PREVIEW / futures_30min / 2013-11-18
file: by_date/futures_30min/2013/2013-11-18.parquet size: 73 KB rows: 2,793
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-18 00:00:00 | ES | Futures | 1849.32 | 1849.83 | 1848.8 | 1849.32 | 2542.0 |
| 2013-11-18 00:30:00 | ES | Futures | 1849.32 | 1849.32 | 1848.03 | 1848.54 | 1940.0 |
| 2013-11-18 01:00:00 | ES | Futures | 1848.8 | 1849.06 | 1848.54 | 1848.8 | 762.0 |
| 2013-11-18 01:30:00 | ES | Futures | 1848.8 | 1849.58 | 1848.54 | 1849.58 | 1151.0 |
| 2013-11-18 02:00:00 | ES | Futures | 1849.58 | 1849.58 | 1848.03 | 1848.03 | 2436.0 |
| 2013-11-18 02:30:00 | ES | Futures | 1848.03 | 1848.8 | 1847.77 | 1847.77 | 2775.0 |
| 2013-11-18 03:00:00 | ES | Futures | 1847.77 | 1850.09 | 1847.25 | 1849.32 | 14174.0 |
| 2013-11-18 03:30:00 | ES | Futures | 1849.06 | 1849.58 | 1847.51 | 1847.77 | 8853.0 |
| 2013-11-18 04:00:00 | ES | Futures | 1847.51 | 1849.58 | 1847.51 | 1849.58 | 8075.0 |
| 2013-11-18 04:30:00 | ES | Futures | 1849.32 | 1850.61 | 1849.32 | 1850.09 | 12018.0 |
| 2013-11-18 05:00:00 | ES | Futures | 1850.09 | 1852.67 | 1850.09 | 1851.64 | 15886.0 |
| 2013-11-18 05:30:00 | ES | Futures | 1851.64 | 1852.67 | 1851.64 | 1851.9 | 7837.0 |
| 2013-11-18 06:00:00 | ES | Futures | 1851.9 | 1853.19 | 1851.9 | 1852.93 | 15277.0 |
| 2013-11-18 06:30:00 | ES | Futures | 1852.67 | 1854.48 | 1852.67 | 1854.22 | 13951.0 |
| 2013-11-18 07:00:00 | ES | Futures | 1853.96 | 1854.74 | 1853.45 | 1854.22 | 11704.0 |
| 2013-11-18 07:30:00 | ES | Futures | 1853.96 | 1854.22 | 1852.67 | 1853.45 | 11938.0 |
| 2013-11-18 08:00:00 | ES | Futures | 1853.19 | 1853.7 | 1852.41 | 1853.45 | 14547.0 |
| 2013-11-18 08:30:00 | ES | Futures | 1853.19 | 1854.22 | 1852.67 | 1854.22 | 14977.0 |
| 2013-11-18 09:00:00 | ES | Futures | 1853.96 | 1856.28 | 1853.96 | 1855.25 | 35893.0 |
| 2013-11-18 09:30:00 | ES | Futures | 1855.25 | 1857.06 | 1850.61 | 1850.87 | 209427.0 |
| 2013-11-18 10:00:00 | ES | Futures | 1850.87 | 1854.22 | 1849.58 | 1852.93 | 134607.0 |
| 2013-11-18 10:30:00 | ES | Futures | 1852.93 | 1854.48 | 1851.9 | 1854.48 | 72833.0 |
| 2013-11-18 11:00:00 | ES | Futures | 1854.22 | 1856.03 | 1854.22 | 1854.99 | 83234.0 |
| 2013-11-18 11:30:00 | ES | Futures | 1855.25 | 1855.77 | 1852.41 | 1853.19 | 60464.0 |
| 2013-11-18 12:00:00 | ES | Futures | 1852.93 | 1854.48 | 1852.67 | 1853.96 | 56980.0 |
| 2013-11-18 12:30:00 | ES | Futures | 1853.7 | 1854.74 | 1851.9 | 1852.41 | 50266.0 |
| 2013-11-18 13:00:00 | ES | Futures | 1852.67 | 1854.48 | 1852.16 | 1854.48 | 28223.0 |
| 2013-11-18 13:30:00 | ES | Futures | 1854.22 | 1854.48 | 1852.93 | 1853.7 | 32157.0 |
| 2013-11-18 14:00:00 | ES | Futures | 1853.96 | 1855.51 | 1853.45 | 1855.25 | 37935.0 |
| 2013-11-18 14:30:00 | ES | Futures | 1855.25 | 1855.25 | 1849.83 | 1849.83 | 83087.0 |
| 2013-11-18 15:00:00 | ES | Futures | 1849.83 | 1850.09 | 1842.35 | 1844.42 | 204014.0 |
| 2013-11-18 15:30:00 | ES | Futures | 1844.16 | 1846.48 | 1841.58 | 1846.48 | 184957.0 |
| 2013-11-18 16:00:00 | ES | Futures | 1846.48 | 1846.74 | 1845.45 | 1845.71 | 74081.0 |
| 2013-11-18 16:30:00 | ES | Futures | 1845.45 | 1846.74 | 1845.45 | 1846.74 | 9583.0 |
| 2013-11-18 17:00:00 | ES | Futures | 1846.74 | 1847.0 | 1846.22 | 1846.48 | 5268.0 |
| 2013-11-18 18:00:00 | ES | Futures | 1846.48 | 1846.74 | 1844.67 | 1845.19 | 4610.0 |
| 2013-11-18 18:30:00 | ES | Futures | 1845.45 | 1846.22 | 1845.45 | 1845.71 | 1465.0 |
| 2013-11-18 19:00:00 | ES | Futures | 1845.71 | 1847.77 | 1845.45 | 1847.51 | 3036.0 |
| 2013-11-18 19:30:00 | ES | Futures | 1847.25 | 1847.25 | 1846.22 | 1846.74 | 1753.0 |
| 2013-11-18 20:00:00 | ES | Futures | 1846.48 | 1846.48 | 1845.45 | 1845.71 | 2717.0 |
| 2013-11-18 20:30:00 | ES | Futures | 1845.71 | 1845.96 | 1843.9 | 1844.42 | 4202.0 |
| 2013-11-18 21:00:00 | ES | Futures | 1844.16 | 1846.48 | 1844.16 | 1845.96 | 1649.0 |
| 2013-11-18 21:30:00 | ES | Futures | 1846.22 | 1846.74 | 1845.71 | 1845.71 | 1107.0 |
| 2013-11-18 22:00:00 | ES | Futures | 1845.96 | 1846.48 | 1845.19 | 1846.22 | 1851.0 |
| 2013-11-18 22:30:00 | ES | Futures | 1846.48 | 1847.25 | 1845.71 | 1847.0 | 1894.0 |
| 2013-11-18 23:00:00 | ES | Futures | 1847.0 | 1847.25 | 1845.96 | 1846.48 | 1093.0 |
| 2013-11-18 23:30:00 | ES | Futures | 1846.48 | 1846.74 | 1845.96 | 1846.48 | 869.0 |
| 2013-11-18 00:00:00 | NQ | Futures | 3968.18 | 3969.63 | 3967.6 | 3968.47 | 309.0 |
| 2013-11-18 00:30:00 | NQ | Futures | 3968.47 | 3968.47 | 3966.15 | 3967.31 | 254.0 |
| 2013-11-18 01:00:00 | NQ | Futures | 3967.31 | 3968.47 | 3967.02 | 3967.89 | 109.0 |
> showing 50 of 2,793 rows — these rows as CSV