PREVIEW / futures_30min / 2013-04-08
file: by_date/futures_30min/2013/2013-04-08.parquet size: 77 KB rows: 2,854
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-04-08 00:00:00 | ES | Futures | 1594.45 | 1594.7 | 1594.19 | 1594.45 | 1118.0 |
| 2013-04-08 00:30:00 | ES | Futures | 1594.45 | 1594.96 | 1594.45 | 1594.7 | 1280.0 |
| 2013-04-08 01:00:00 | ES | Futures | 1594.7 | 1594.96 | 1593.93 | 1594.19 | 1283.0 |
| 2013-04-08 01:30:00 | ES | Futures | 1594.45 | 1594.7 | 1592.39 | 1592.64 | 3672.0 |
| 2013-04-08 02:00:00 | ES | Futures | 1592.64 | 1593.42 | 1591.87 | 1593.16 | 5514.0 |
| 2013-04-08 02:30:00 | ES | Futures | 1593.16 | 1593.16 | 1592.13 | 1593.16 | 4065.0 |
| 2013-04-08 03:00:00 | ES | Futures | 1592.9 | 1595.48 | 1592.39 | 1595.22 | 15319.0 |
| 2013-04-08 03:30:00 | ES | Futures | 1595.22 | 1596.77 | 1595.22 | 1595.48 | 11389.0 |
| 2013-04-08 04:00:00 | ES | Futures | 1595.73 | 1595.99 | 1594.96 | 1595.48 | 8915.0 |
| 2013-04-08 04:30:00 | ES | Futures | 1595.48 | 1598.05 | 1595.48 | 1597.8 | 12646.0 |
| 2013-04-08 05:00:00 | ES | Futures | 1597.54 | 1598.05 | 1595.99 | 1596.51 | 12753.0 |
| 2013-04-08 05:30:00 | ES | Futures | 1596.77 | 1597.54 | 1596.25 | 1597.02 | 4404.0 |
| 2013-04-08 06:00:00 | ES | Futures | 1597.02 | 1597.8 | 1596.51 | 1597.02 | 8254.0 |
| 2013-04-08 06:30:00 | ES | Futures | 1597.28 | 1598.05 | 1597.02 | 1597.8 | 6515.0 |
| 2013-04-08 07:00:00 | ES | Futures | 1597.8 | 1599.08 | 1597.28 | 1598.31 | 13887.0 |
| 2013-04-08 07:30:00 | ES | Futures | 1598.31 | 1599.08 | 1597.28 | 1598.57 | 14565.0 |
| 2013-04-08 08:00:00 | ES | Futures | 1598.57 | 1599.08 | 1597.28 | 1597.28 | 8488.0 |
| 2013-04-08 08:30:00 | ES | Futures | 1597.28 | 1598.31 | 1596.77 | 1597.02 | 15835.0 |
| 2013-04-08 09:00:00 | ES | Futures | 1597.02 | 1597.28 | 1594.96 | 1595.22 | 29502.0 |
| 2013-04-08 09:30:00 | ES | Futures | 1595.22 | 1595.73 | 1590.58 | 1592.9 | 201699.0 |
| 2013-04-08 10:00:00 | ES | Futures | 1592.64 | 1593.93 | 1589.81 | 1591.87 | 124247.0 |
| 2013-04-08 10:30:00 | ES | Futures | 1591.87 | 1595.22 | 1591.36 | 1594.96 | 110639.0 |
| 2013-04-08 11:00:00 | ES | Futures | 1594.7 | 1595.22 | 1592.39 | 1593.93 | 86777.0 |
| 2013-04-08 11:30:00 | ES | Futures | 1594.19 | 1594.96 | 1592.64 | 1593.16 | 49657.0 |
| 2013-04-08 12:00:00 | ES | Futures | 1593.16 | 1594.19 | 1591.87 | 1592.9 | 39056.0 |
| 2013-04-08 12:30:00 | ES | Futures | 1592.64 | 1594.7 | 1592.64 | 1593.67 | 29379.0 |
| 2013-04-08 13:00:00 | ES | Futures | 1593.67 | 1595.73 | 1593.67 | 1595.22 | 45577.0 |
| 2013-04-08 13:30:00 | ES | Futures | 1594.96 | 1599.08 | 1594.7 | 1598.83 | 78396.0 |
| 2013-04-08 14:00:00 | ES | Futures | 1598.83 | 1600.89 | 1598.31 | 1599.6 | 73052.0 |
| 2013-04-08 14:30:00 | ES | Futures | 1599.86 | 1600.89 | 1599.08 | 1599.6 | 46792.0 |
| 2013-04-08 15:00:00 | ES | Futures | 1599.6 | 1601.4 | 1599.34 | 1601.4 | 50093.0 |
| 2013-04-08 15:30:00 | ES | Futures | 1601.4 | 1605.52 | 1600.37 | 1605.01 | 157347.0 |
| 2013-04-08 16:00:00 | ES | Futures | 1605.01 | 1607.84 | 1604.75 | 1606.3 | 99875.0 |
| 2013-04-08 16:30:00 | ES | Futures | 1606.55 | 1610.16 | 1606.3 | 1610.16 | 20542.0 |
| 2013-04-08 17:00:00 | ES | Futures | 1609.9 | 1610.16 | 1608.1 | 1608.36 | 6590.0 |
| 2013-04-08 18:00:00 | ES | Futures | 1608.1 | 1608.61 | 1606.81 | 1607.07 | 5630.0 |
| 2013-04-08 18:30:00 | ES | Futures | 1607.07 | 1607.84 | 1607.07 | 1607.58 | 1881.0 |
| 2013-04-08 19:00:00 | ES | Futures | 1607.33 | 1607.84 | 1607.33 | 1607.84 | 617.0 |
| 2013-04-08 19:30:00 | ES | Futures | 1607.84 | 1607.84 | 1607.07 | 1607.33 | 1488.0 |
| 2013-04-08 20:00:00 | ES | Futures | 1607.33 | 1608.1 | 1607.07 | 1607.84 | 2782.0 |
| 2013-04-08 20:30:00 | ES | Futures | 1608.1 | 1608.87 | 1607.84 | 1608.1 | 3899.0 |
| 2013-04-08 21:00:00 | ES | Futures | 1608.1 | 1608.61 | 1607.58 | 1608.36 | 3122.0 |
| 2013-04-08 21:30:00 | ES | Futures | 1608.36 | 1609.13 | 1608.1 | 1608.87 | 3359.0 |
| 2013-04-08 22:00:00 | ES | Futures | 1608.87 | 1611.19 | 1608.87 | 1610.67 | 5041.0 |
| 2013-04-08 22:30:00 | ES | Futures | 1610.42 | 1610.67 | 1609.13 | 1609.64 | 2334.0 |
| 2013-04-08 23:00:00 | ES | Futures | 1609.64 | 1609.64 | 1608.87 | 1609.13 | 1326.0 |
| 2013-04-08 23:30:00 | ES | Futures | 1609.39 | 1609.9 | 1608.61 | 1608.61 | 1082.0 |
| 2013-04-08 00:00:00 | NQ | Futures | 3228.18 | 3228.76 | 3228.18 | 3228.47 | 178.0 |
| 2013-04-08 00:30:00 | NQ | Futures | 3228.47 | 3229.06 | 3228.18 | 3229.06 | 48.0 |
| 2013-04-08 01:00:00 | NQ | Futures | 3228.76 | 3229.06 | 3228.18 | 3228.47 | 274.0 |
> showing 50 of 2,854 rows — these rows as CSV