PREVIEW / futures_5min / 2014-01-31
file: by_date/futures_5min/2014/2014-01-31.parquet size: 219 KB rows: 12,456
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-31 00:00:00 | ES | Futures | 1838.77 | 1839.02 | 1838.51 | 1838.51 | 541.0 |
| 2014-01-31 00:05:00 | ES | Futures | 1838.51 | 1838.77 | 1837.99 | 1838.51 | 1173.0 |
| 2014-01-31 00:10:00 | ES | Futures | 1838.51 | 1839.54 | 1838.25 | 1839.02 | 604.0 |
| 2014-01-31 00:15:00 | ES | Futures | 1839.02 | 1839.8 | 1838.77 | 1839.8 | 564.0 |
| 2014-01-31 00:20:00 | ES | Futures | 1840.06 | 1840.06 | 1839.28 | 1839.54 | 264.0 |
| 2014-01-31 00:25:00 | ES | Futures | 1839.54 | 1840.58 | 1839.02 | 1840.58 | 423.0 |
| 2014-01-31 00:30:00 | ES | Futures | 1840.58 | 1842.13 | 1840.32 | 1841.61 | 975.0 |
| 2014-01-31 00:35:00 | ES | Futures | 1841.87 | 1842.13 | 1841.35 | 1841.87 | 234.0 |
| 2014-01-31 00:40:00 | ES | Futures | 1841.61 | 1842.13 | 1840.58 | 1841.61 | 705.0 |
| 2014-01-31 00:45:00 | ES | Futures | 1841.35 | 1841.87 | 1841.09 | 1841.35 | 213.0 |
| 2014-01-31 00:50:00 | ES | Futures | 1841.61 | 1842.13 | 1841.09 | 1841.35 | 355.0 |
| 2014-01-31 00:55:00 | ES | Futures | 1841.35 | 1842.65 | 1841.35 | 1842.13 | 459.0 |
| 2014-01-31 01:00:00 | ES | Futures | 1842.13 | 1842.65 | 1841.09 | 1841.09 | 965.0 |
| 2014-01-31 01:05:00 | ES | Futures | 1841.09 | 1842.13 | 1841.09 | 1842.13 | 527.0 |
| 2014-01-31 01:10:00 | ES | Futures | 1841.87 | 1842.39 | 1841.61 | 1841.61 | 286.0 |
| 2014-01-31 01:15:00 | ES | Futures | 1841.61 | 1841.87 | 1841.09 | 1841.61 | 303.0 |
| 2014-01-31 01:20:00 | ES | Futures | 1841.61 | 1842.39 | 1841.61 | 1841.87 | 120.0 |
| 2014-01-31 01:25:00 | ES | Futures | 1842.13 | 1842.39 | 1841.87 | 1842.13 | 431.0 |
| 2014-01-31 01:30:00 | ES | Futures | 1841.87 | 1842.39 | 1841.61 | 1842.39 | 204.0 |
| 2014-01-31 01:35:00 | ES | Futures | 1842.65 | 1843.68 | 1842.39 | 1843.42 | 1077.0 |
| 2014-01-31 01:40:00 | ES | Futures | 1843.42 | 1843.42 | 1842.9 | 1843.16 | 58.0 |
| 2014-01-31 01:45:00 | ES | Futures | 1843.16 | 1843.42 | 1842.65 | 1842.9 | 258.0 |
| 2014-01-31 01:50:00 | ES | Futures | 1842.9 | 1843.16 | 1842.9 | 1843.16 | 111.0 |
| 2014-01-31 01:55:00 | ES | Futures | 1843.16 | 1843.16 | 1842.13 | 1842.13 | 385.0 |
| 2014-01-31 02:00:00 | ES | Futures | 1842.13 | 1843.42 | 1842.13 | 1842.39 | 1495.0 |
| 2014-01-31 02:05:00 | ES | Futures | 1842.39 | 1842.65 | 1841.61 | 1841.87 | 1137.0 |
| 2014-01-31 02:10:00 | ES | Futures | 1842.13 | 1842.65 | 1841.87 | 1842.39 | 401.0 |
| 2014-01-31 02:15:00 | ES | Futures | 1842.13 | 1842.9 | 1842.13 | 1842.65 | 655.0 |
| 2014-01-31 02:20:00 | ES | Futures | 1842.65 | 1843.16 | 1841.35 | 1841.61 | 1356.0 |
| 2014-01-31 02:25:00 | ES | Futures | 1841.61 | 1842.39 | 1841.35 | 1842.13 | 858.0 |
| 2014-01-31 02:30:00 | ES | Futures | 1842.13 | 1842.39 | 1841.87 | 1841.87 | 644.0 |
| 2014-01-31 02:35:00 | ES | Futures | 1842.13 | 1842.13 | 1841.61 | 1842.13 | 483.0 |
| 2014-01-31 02:40:00 | ES | Futures | 1842.13 | 1842.39 | 1841.87 | 1842.39 | 370.0 |
| 2014-01-31 02:45:00 | ES | Futures | 1842.39 | 1842.65 | 1842.13 | 1842.39 | 1063.0 |
| 2014-01-31 02:50:00 | ES | Futures | 1842.39 | 1842.39 | 1841.87 | 1842.13 | 449.0 |
| 2014-01-31 02:55:00 | ES | Futures | 1842.13 | 1843.16 | 1841.87 | 1842.65 | 1177.0 |
| 2014-01-31 03:00:00 | ES | Futures | 1842.65 | 1842.65 | 1839.8 | 1840.58 | 4317.0 |
| 2014-01-31 03:05:00 | ES | Futures | 1840.58 | 1841.09 | 1838.77 | 1839.54 | 4647.0 |
| 2014-01-31 03:10:00 | ES | Futures | 1839.54 | 1842.13 | 1839.28 | 1841.35 | 4820.0 |
| 2014-01-31 03:15:00 | ES | Futures | 1841.61 | 1841.61 | 1840.32 | 1841.09 | 2292.0 |
| 2014-01-31 03:20:00 | ES | Futures | 1841.09 | 1841.61 | 1840.58 | 1841.61 | 2420.0 |
| 2014-01-31 03:25:00 | ES | Futures | 1841.35 | 1841.61 | 1838.51 | 1839.54 | 7313.0 |
| 2014-01-31 03:30:00 | ES | Futures | 1839.54 | 1839.8 | 1837.73 | 1837.99 | 3768.0 |
| 2014-01-31 03:35:00 | ES | Futures | 1837.99 | 1839.28 | 1837.73 | 1838.51 | 2060.0 |
| 2014-01-31 03:40:00 | ES | Futures | 1838.51 | 1839.28 | 1837.99 | 1838.51 | 1925.0 |
| 2014-01-31 03:45:00 | ES | Futures | 1838.51 | 1840.32 | 1838.51 | 1840.06 | 2247.0 |
| 2014-01-31 03:50:00 | ES | Futures | 1840.06 | 1840.32 | 1838.77 | 1839.28 | 1545.0 |
| 2014-01-31 03:55:00 | ES | Futures | 1839.28 | 1839.8 | 1838.51 | 1839.8 | 1764.0 |
| 2014-01-31 04:00:00 | ES | Futures | 1839.54 | 1840.58 | 1839.54 | 1840.06 | 1359.0 |
| 2014-01-31 04:05:00 | ES | Futures | 1839.8 | 1840.58 | 1839.54 | 1840.06 | 1312.0 |
> showing 50 of 12,456 rows — these rows as CSV