PREVIEW / futures_30min / 2013-03-21
file: by_date/futures_30min/2013/2013-03-21.parquet size: 76 KB rows: 2,845
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-03-21 00:00:00 | ES | Futures | 1596.51 | 1597.02 | 1596.51 | 1596.77 | 772.0 |
| 2013-03-21 00:30:00 | ES | Futures | 1596.77 | 1596.77 | 1595.22 | 1595.48 | 1103.0 |
| 2013-03-21 01:00:00 | ES | Futures | 1595.48 | 1596.77 | 1594.96 | 1596.51 | 1821.0 |
| 2013-03-21 01:30:00 | ES | Futures | 1596.51 | 1596.77 | 1594.96 | 1595.22 | 1600.0 |
| 2013-03-21 02:00:00 | ES | Futures | 1594.96 | 1596.25 | 1594.7 | 1595.48 | 1451.0 |
| 2013-03-21 02:30:00 | ES | Futures | 1595.48 | 1595.48 | 1594.7 | 1594.96 | 1626.0 |
| 2013-03-21 03:00:00 | ES | Futures | 1594.96 | 1597.02 | 1594.96 | 1596.51 | 3016.0 |
| 2013-03-21 03:30:00 | ES | Futures | 1596.25 | 1597.8 | 1596.25 | 1596.51 | 4870.0 |
| 2013-03-21 04:00:00 | ES | Futures | 1596.51 | 1597.8 | 1594.96 | 1595.22 | 17516.0 |
| 2013-03-21 04:30:00 | ES | Futures | 1595.22 | 1595.48 | 1592.39 | 1593.42 | 29470.0 |
| 2013-03-21 05:00:00 | ES | Futures | 1593.42 | 1595.73 | 1592.64 | 1594.96 | 20115.0 |
| 2013-03-21 05:30:00 | ES | Futures | 1594.96 | 1595.48 | 1593.93 | 1594.45 | 11544.0 |
| 2013-03-21 06:00:00 | ES | Futures | 1594.45 | 1594.45 | 1592.64 | 1593.93 | 11067.0 |
| 2013-03-21 06:30:00 | ES | Futures | 1594.19 | 1595.22 | 1593.42 | 1594.7 | 11120.0 |
| 2013-03-21 07:00:00 | ES | Futures | 1594.7 | 1596.77 | 1594.7 | 1595.73 | 19647.0 |
| 2013-03-21 07:30:00 | ES | Futures | 1595.73 | 1596.77 | 1594.96 | 1595.99 | 10416.0 |
| 2013-03-21 08:00:00 | ES | Futures | 1595.99 | 1597.54 | 1595.48 | 1597.02 | 17625.0 |
| 2013-03-21 08:30:00 | ES | Futures | 1597.28 | 1597.54 | 1594.45 | 1594.7 | 21728.0 |
| 2013-03-21 09:00:00 | ES | Futures | 1594.45 | 1595.73 | 1589.81 | 1590.58 | 76766.0 |
| 2013-03-21 09:30:00 | ES | Futures | 1590.58 | 1594.45 | 1589.81 | 1593.93 | 150352.0 |
| 2013-03-21 10:00:00 | ES | Futures | 1593.93 | 1594.96 | 1588.27 | 1590.33 | 194332.0 |
| 2013-03-21 10:30:00 | ES | Futures | 1590.33 | 1591.36 | 1588.52 | 1591.36 | 101872.0 |
| 2013-03-21 11:00:00 | ES | Futures | 1591.36 | 1593.93 | 1589.3 | 1592.64 | 94103.0 |
| 2013-03-21 11:30:00 | ES | Futures | 1592.9 | 1595.99 | 1592.39 | 1594.45 | 100956.0 |
| 2013-03-21 12:00:00 | ES | Futures | 1594.19 | 1594.96 | 1592.13 | 1592.64 | 47590.0 |
| 2013-03-21 12:30:00 | ES | Futures | 1592.64 | 1594.19 | 1591.87 | 1592.9 | 57218.0 |
| 2013-03-21 13:00:00 | ES | Futures | 1592.64 | 1593.93 | 1588.78 | 1589.55 | 89260.0 |
| 2013-03-21 13:30:00 | ES | Futures | 1589.81 | 1589.81 | 1586.98 | 1588.01 | 143720.0 |
| 2013-03-21 14:00:00 | ES | Futures | 1588.01 | 1590.33 | 1583.11 | 1588.78 | 224135.0 |
| 2013-03-21 14:30:00 | ES | Futures | 1588.52 | 1589.81 | 1587.23 | 1589.3 | 67148.0 |
| 2013-03-21 15:00:00 | ES | Futures | 1589.3 | 1591.36 | 1587.23 | 1589.81 | 85230.0 |
| 2013-03-21 15:30:00 | ES | Futures | 1590.07 | 1590.07 | 1585.43 | 1585.95 | 153664.0 |
| 2013-03-21 16:00:00 | ES | Futures | 1585.95 | 1586.46 | 1585.17 | 1586.2 | 85292.0 |
| 2013-03-21 16:30:00 | ES | Futures | 1586.46 | 1586.98 | 1585.43 | 1585.95 | 11722.0 |
| 2013-03-21 17:00:00 | ES | Futures | 1586.2 | 1586.2 | 1585.17 | 1585.69 | 3481.0 |
| 2013-03-21 18:00:00 | ES | Futures | 1585.17 | 1585.69 | 1584.4 | 1584.66 | 4412.0 |
| 2013-03-21 18:30:00 | ES | Futures | 1584.92 | 1585.17 | 1584.14 | 1584.66 | 2078.0 |
| 2013-03-21 19:00:00 | ES | Futures | 1584.66 | 1584.92 | 1584.4 | 1584.92 | 1833.0 |
| 2013-03-21 19:30:00 | ES | Futures | 1584.92 | 1585.69 | 1584.92 | 1585.43 | 1543.0 |
| 2013-03-21 20:00:00 | ES | Futures | 1585.69 | 1585.69 | 1584.4 | 1584.66 | 2852.0 |
| 2013-03-21 20:30:00 | ES | Futures | 1584.66 | 1585.69 | 1584.4 | 1585.69 | 3214.0 |
| 2013-03-21 21:00:00 | ES | Futures | 1585.43 | 1586.46 | 1584.92 | 1585.95 | 3395.0 |
| 2013-03-21 21:30:00 | ES | Futures | 1585.95 | 1586.46 | 1585.43 | 1586.2 | 1979.0 |
| 2013-03-21 22:00:00 | ES | Futures | 1586.2 | 1586.72 | 1585.95 | 1586.2 | 1692.0 |
| 2013-03-21 22:30:00 | ES | Futures | 1586.46 | 1586.46 | 1585.17 | 1585.95 | 1640.0 |
| 2013-03-21 23:00:00 | ES | Futures | 1585.95 | 1586.46 | 1585.69 | 1586.2 | 1061.0 |
| 2013-03-21 23:30:00 | ES | Futures | 1586.46 | 1586.46 | 1585.69 | 1586.2 | 595.0 |
| 2013-03-21 00:00:00 | NQ | Futures | 3249.47 | 3250.64 | 3249.47 | 3250.64 | 40.0 |
| 2013-03-21 00:30:00 | NQ | Futures | 3250.35 | 3250.64 | 3247.43 | 3247.43 | 105.0 |
| 2013-03-21 01:00:00 | NQ | Futures | 3247.14 | 3249.47 | 3246.85 | 3249.47 | 149.0 |
> showing 50 of 2,845 rows — these rows as CSV