PREVIEW / futures_5min / 2013-05-23
file: by_date/futures_5min/2013/2013-05-23.parquet size: 255 KB rows: 14,678
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-05-23 00:00:00 | ES | Futures | 1700.06 | 1700.06 | 1699.03 | 1699.28 | 2702.0 |
| 2013-05-23 00:05:00 | ES | Futures | 1699.28 | 1699.8 | 1699.03 | 1699.8 | 1408.0 |
| 2013-05-23 00:10:00 | ES | Futures | 1699.8 | 1700.06 | 1699.28 | 1699.8 | 579.0 |
| 2013-05-23 00:15:00 | ES | Futures | 1699.8 | 1700.06 | 1698.77 | 1698.77 | 1443.0 |
| 2013-05-23 00:20:00 | ES | Futures | 1698.77 | 1699.03 | 1698.0 | 1698.0 | 3819.0 |
| 2013-05-23 00:25:00 | ES | Futures | 1698.25 | 1698.51 | 1698.0 | 1698.0 | 880.0 |
| 2013-05-23 00:30:00 | ES | Futures | 1698.25 | 1700.83 | 1698.0 | 1700.83 | 2574.0 |
| 2013-05-23 00:35:00 | ES | Futures | 1700.57 | 1701.86 | 1700.31 | 1701.09 | 2822.0 |
| 2013-05-23 00:40:00 | ES | Futures | 1701.09 | 1701.34 | 1699.8 | 1700.31 | 1400.0 |
| 2013-05-23 00:45:00 | ES | Futures | 1700.06 | 1700.06 | 1699.28 | 1700.06 | 1174.0 |
| 2013-05-23 00:50:00 | ES | Futures | 1700.06 | 1700.31 | 1699.8 | 1700.06 | 894.0 |
| 2013-05-23 00:55:00 | ES | Futures | 1699.8 | 1700.57 | 1699.54 | 1699.8 | 860.0 |
| 2013-05-23 01:00:00 | ES | Futures | 1699.8 | 1700.57 | 1699.28 | 1699.28 | 529.0 |
| 2013-05-23 01:05:00 | ES | Futures | 1699.28 | 1699.54 | 1698.0 | 1698.0 | 2002.0 |
| 2013-05-23 01:10:00 | ES | Futures | 1698.0 | 1698.25 | 1697.22 | 1697.74 | 3222.0 |
| 2013-05-23 01:15:00 | ES | Futures | 1697.74 | 1697.74 | 1696.71 | 1697.22 | 2203.0 |
| 2013-05-23 01:20:00 | ES | Futures | 1697.48 | 1697.48 | 1696.97 | 1697.22 | 1162.0 |
| 2013-05-23 01:25:00 | ES | Futures | 1697.22 | 1698.25 | 1696.97 | 1698.0 | 2208.0 |
| 2013-05-23 01:30:00 | ES | Futures | 1698.0 | 1698.0 | 1695.68 | 1696.19 | 2887.0 |
| 2013-05-23 01:35:00 | ES | Futures | 1696.45 | 1696.45 | 1695.16 | 1695.42 | 4391.0 |
| 2013-05-23 01:40:00 | ES | Futures | 1695.42 | 1696.19 | 1695.16 | 1696.19 | 3233.0 |
| 2013-05-23 01:45:00 | ES | Futures | 1696.19 | 1696.71 | 1695.94 | 1696.45 | 1868.0 |
| 2013-05-23 01:50:00 | ES | Futures | 1696.19 | 1696.71 | 1695.42 | 1695.42 | 2005.0 |
| 2013-05-23 01:55:00 | ES | Futures | 1695.42 | 1695.68 | 1694.9 | 1695.16 | 2647.0 |
| 2013-05-23 02:00:00 | ES | Futures | 1695.16 | 1695.42 | 1693.62 | 1694.65 | 9975.0 |
| 2013-05-23 02:05:00 | ES | Futures | 1694.65 | 1695.94 | 1694.39 | 1695.16 | 3292.0 |
| 2013-05-23 02:10:00 | ES | Futures | 1695.16 | 1695.42 | 1693.87 | 1694.13 | 3447.0 |
| 2013-05-23 02:15:00 | ES | Futures | 1694.13 | 1694.39 | 1690.27 | 1690.53 | 13408.0 |
| 2013-05-23 02:20:00 | ES | Futures | 1690.53 | 1690.53 | 1685.89 | 1687.43 | 14873.0 |
| 2013-05-23 02:25:00 | ES | Futures | 1687.18 | 1687.95 | 1686.66 | 1687.18 | 3704.0 |
| 2013-05-23 02:30:00 | ES | Futures | 1687.18 | 1687.18 | 1683.31 | 1684.6 | 10460.0 |
| 2013-05-23 02:35:00 | ES | Futures | 1684.6 | 1688.21 | 1684.09 | 1687.95 | 9420.0 |
| 2013-05-23 02:40:00 | ES | Futures | 1687.69 | 1690.53 | 1687.18 | 1690.01 | 6499.0 |
| 2013-05-23 02:45:00 | ES | Futures | 1690.01 | 1690.78 | 1689.24 | 1690.27 | 3467.0 |
| 2013-05-23 02:50:00 | ES | Futures | 1690.53 | 1691.56 | 1689.75 | 1690.27 | 4348.0 |
| 2013-05-23 02:55:00 | ES | Futures | 1690.27 | 1691.81 | 1689.24 | 1691.04 | 4247.0 |
| 2013-05-23 03:00:00 | ES | Futures | 1690.78 | 1691.04 | 1686.66 | 1686.66 | 10001.0 |
| 2013-05-23 03:05:00 | ES | Futures | 1686.92 | 1689.24 | 1685.63 | 1689.24 | 7462.0 |
| 2013-05-23 03:10:00 | ES | Futures | 1689.24 | 1691.81 | 1688.72 | 1691.3 | 8158.0 |
| 2013-05-23 03:15:00 | ES | Futures | 1691.3 | 1691.81 | 1689.75 | 1690.78 | 4525.0 |
| 2013-05-23 03:20:00 | ES | Futures | 1690.78 | 1692.84 | 1690.78 | 1692.59 | 5171.0 |
| 2013-05-23 03:25:00 | ES | Futures | 1692.59 | 1693.87 | 1691.56 | 1693.62 | 4558.0 |
| 2013-05-23 03:30:00 | ES | Futures | 1693.62 | 1693.87 | 1690.78 | 1690.78 | 5477.0 |
| 2013-05-23 03:35:00 | ES | Futures | 1690.78 | 1692.33 | 1690.53 | 1692.07 | 3478.0 |
| 2013-05-23 03:40:00 | ES | Futures | 1691.81 | 1692.07 | 1690.01 | 1690.53 | 3435.0 |
| 2013-05-23 03:45:00 | ES | Futures | 1690.27 | 1690.78 | 1688.72 | 1689.24 | 5547.0 |
| 2013-05-23 03:50:00 | ES | Futures | 1689.24 | 1690.27 | 1686.92 | 1687.69 | 5361.0 |
| 2013-05-23 03:55:00 | ES | Futures | 1687.95 | 1688.21 | 1686.66 | 1688.21 | 2975.0 |
| 2013-05-23 04:00:00 | ES | Futures | 1687.95 | 1688.72 | 1687.18 | 1688.72 | 4798.0 |
| 2013-05-23 04:05:00 | ES | Futures | 1688.72 | 1688.72 | 1686.92 | 1686.92 | 3610.0 |
> showing 50 of 14,678 rows — these rows as CSV