PREVIEW / futures_5min / 2013-06-19
file: by_date/futures_5min/2013/2013-06-19.parquet size: 249 KB rows: 14,374
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-06-19 00:00:00 | ES | Futures | 1698.05 | 1698.31 | 1698.05 | 1698.31 | 132.0 |
| 2013-06-19 00:05:00 | ES | Futures | 1698.05 | 1698.31 | 1698.05 | 1698.05 | 129.0 |
| 2013-06-19 00:10:00 | ES | Futures | 1698.31 | 1698.31 | 1697.54 | 1697.79 | 1354.0 |
| 2013-06-19 00:15:00 | ES | Futures | 1697.79 | 1698.83 | 1697.54 | 1698.57 | 390.0 |
| 2013-06-19 00:20:00 | ES | Futures | 1698.83 | 1698.83 | 1698.05 | 1698.05 | 300.0 |
| 2013-06-19 00:25:00 | ES | Futures | 1698.05 | 1699.09 | 1698.05 | 1698.83 | 657.0 |
| 2013-06-19 00:30:00 | ES | Futures | 1699.09 | 1699.09 | 1698.05 | 1698.31 | 363.0 |
| 2013-06-19 00:35:00 | ES | Futures | 1698.05 | 1698.31 | 1698.05 | 1698.05 | 372.0 |
| 2013-06-19 00:40:00 | ES | Futures | 1698.05 | 1698.31 | 1697.79 | 1698.05 | 283.0 |
| 2013-06-19 00:45:00 | ES | Futures | 1698.05 | 1698.31 | 1697.79 | 1698.05 | 243.0 |
| 2013-06-19 00:50:00 | ES | Futures | 1697.79 | 1698.31 | 1697.79 | 1698.05 | 171.0 |
| 2013-06-19 00:55:00 | ES | Futures | 1698.05 | 1698.05 | 1697.79 | 1698.05 | 56.0 |
| 2013-06-19 01:00:00 | ES | Futures | 1698.05 | 1699.09 | 1698.05 | 1699.09 | 254.0 |
| 2013-06-19 01:05:00 | ES | Futures | 1699.09 | 1699.34 | 1698.57 | 1698.83 | 308.0 |
| 2013-06-19 01:10:00 | ES | Futures | 1698.83 | 1699.34 | 1698.57 | 1699.09 | 189.0 |
| 2013-06-19 01:15:00 | ES | Futures | 1698.83 | 1699.34 | 1698.83 | 1699.34 | 164.0 |
| 2013-06-19 01:20:00 | ES | Futures | 1699.34 | 1699.86 | 1699.34 | 1699.34 | 554.0 |
| 2013-06-19 01:25:00 | ES | Futures | 1699.34 | 1700.12 | 1699.34 | 1700.12 | 285.0 |
| 2013-06-19 01:30:00 | ES | Futures | 1700.12 | 1700.64 | 1699.86 | 1700.64 | 500.0 |
| 2013-06-19 01:35:00 | ES | Futures | 1700.38 | 1700.9 | 1700.12 | 1700.38 | 406.0 |
| 2013-06-19 01:40:00 | ES | Futures | 1700.64 | 1700.9 | 1700.38 | 1700.9 | 131.0 |
| 2013-06-19 01:45:00 | ES | Futures | 1700.64 | 1701.15 | 1700.38 | 1701.15 | 470.0 |
| 2013-06-19 01:50:00 | ES | Futures | 1700.9 | 1701.41 | 1700.9 | 1701.41 | 507.0 |
| 2013-06-19 01:55:00 | ES | Futures | 1701.41 | 1701.93 | 1701.15 | 1701.93 | 708.0 |
| 2013-06-19 02:00:00 | ES | Futures | 1701.93 | 1704.26 | 1701.67 | 1703.74 | 2155.0 |
| 2013-06-19 02:05:00 | ES | Futures | 1703.48 | 1704.0 | 1703.22 | 1703.48 | 986.0 |
| 2013-06-19 02:10:00 | ES | Futures | 1703.48 | 1703.48 | 1702.96 | 1703.22 | 677.0 |
| 2013-06-19 02:15:00 | ES | Futures | 1703.22 | 1703.22 | 1702.45 | 1702.71 | 790.0 |
| 2013-06-19 02:20:00 | ES | Futures | 1702.96 | 1703.74 | 1702.96 | 1703.48 | 485.0 |
| 2013-06-19 02:25:00 | ES | Futures | 1703.48 | 1703.48 | 1703.22 | 1703.22 | 421.0 |
| 2013-06-19 02:30:00 | ES | Futures | 1703.22 | 1704.26 | 1702.96 | 1704.0 | 509.0 |
| 2013-06-19 02:35:00 | ES | Futures | 1704.0 | 1704.26 | 1703.48 | 1704.26 | 455.0 |
| 2013-06-19 02:40:00 | ES | Futures | 1704.26 | 1704.77 | 1703.74 | 1704.26 | 1643.0 |
| 2013-06-19 02:45:00 | ES | Futures | 1704.26 | 1704.77 | 1704.26 | 1704.51 | 522.0 |
| 2013-06-19 02:50:00 | ES | Futures | 1704.51 | 1704.77 | 1704.0 | 1704.0 | 298.0 |
| 2013-06-19 02:55:00 | ES | Futures | 1704.0 | 1704.26 | 1703.74 | 1704.0 | 786.0 |
| 2013-06-19 03:00:00 | ES | Futures | 1704.0 | 1704.0 | 1702.96 | 1703.74 | 1759.0 |
| 2013-06-19 03:05:00 | ES | Futures | 1703.74 | 1704.26 | 1703.48 | 1703.74 | 1500.0 |
| 2013-06-19 03:10:00 | ES | Futures | 1703.48 | 1703.74 | 1701.67 | 1702.19 | 2991.0 |
| 2013-06-19 03:15:00 | ES | Futures | 1701.93 | 1702.71 | 1701.67 | 1702.45 | 2201.0 |
| 2013-06-19 03:20:00 | ES | Futures | 1702.45 | 1704.0 | 1702.19 | 1703.22 | 2375.0 |
| 2013-06-19 03:25:00 | ES | Futures | 1703.22 | 1703.22 | 1698.31 | 1698.57 | 5899.0 |
| 2013-06-19 03:30:00 | ES | Futures | 1698.31 | 1700.12 | 1697.02 | 1699.86 | 7981.0 |
| 2013-06-19 03:35:00 | ES | Futures | 1699.86 | 1700.38 | 1698.57 | 1700.38 | 2083.0 |
| 2013-06-19 03:40:00 | ES | Futures | 1700.38 | 1700.38 | 1699.09 | 1699.34 | 1139.0 |
| 2013-06-19 03:45:00 | ES | Futures | 1699.34 | 1699.6 | 1698.83 | 1698.83 | 1299.0 |
| 2013-06-19 03:50:00 | ES | Futures | 1698.83 | 1699.34 | 1697.28 | 1698.83 | 3979.0 |
| 2013-06-19 03:55:00 | ES | Futures | 1698.83 | 1700.12 | 1698.83 | 1699.86 | 1931.0 |
| 2013-06-19 04:00:00 | ES | Futures | 1699.6 | 1699.6 | 1697.79 | 1699.6 | 2021.0 |
| 2013-06-19 04:05:00 | ES | Futures | 1699.34 | 1700.38 | 1699.09 | 1700.38 | 1226.0 |
> showing 50 of 14,374 rows — these rows as CSV