PREVIEW / futures_30min / 2013-05-01
file: by_date/futures_30min/2013/2013-05-01.parquet size: 69 KB rows: 2,527
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-01 00:00:00 | ES | Futures | 1640.3 | 1640.55 | 1640.04 | 1640.04 | 409.0 |
| 2013-05-01 00:30:00 | ES | Futures | 1640.3 | 1640.3 | 1639.78 | 1640.04 | 718.0 |
| 2013-05-01 01:00:00 | ES | Futures | 1640.3 | 1640.55 | 1640.04 | 1640.55 | 652.0 |
| 2013-05-01 01:30:00 | ES | Futures | 1640.55 | 1640.55 | 1640.04 | 1640.04 | 412.0 |
| 2013-05-01 02:00:00 | ES | Futures | 1640.3 | 1640.3 | 1639.78 | 1640.04 | 1263.0 |
| 2013-05-01 02:30:00 | ES | Futures | 1640.04 | 1640.3 | 1639.78 | 1640.04 | 1031.0 |
| 2013-05-01 03:00:00 | ES | Futures | 1640.3 | 1641.07 | 1639.78 | 1640.81 | 2448.0 |
| 2013-05-01 03:30:00 | ES | Futures | 1641.07 | 1642.1 | 1640.81 | 1641.84 | 4128.0 |
| 2013-05-01 04:00:00 | ES | Futures | 1641.84 | 1642.62 | 1641.58 | 1642.62 | 3630.0 |
| 2013-05-01 04:30:00 | ES | Futures | 1642.36 | 1643.39 | 1641.84 | 1643.39 | 4793.0 |
| 2013-05-01 05:00:00 | ES | Futures | 1643.39 | 1643.65 | 1642.1 | 1642.36 | 4078.0 |
| 2013-05-01 05:30:00 | ES | Futures | 1642.36 | 1643.13 | 1642.1 | 1642.36 | 2109.0 |
| 2013-05-01 06:00:00 | ES | Futures | 1642.36 | 1642.62 | 1641.58 | 1641.84 | 2956.0 |
| 2013-05-01 06:30:00 | ES | Futures | 1641.84 | 1643.13 | 1641.58 | 1642.87 | 7803.0 |
| 2013-05-01 07:00:00 | ES | Futures | 1642.87 | 1643.13 | 1641.58 | 1642.1 | 6127.0 |
| 2013-05-01 07:30:00 | ES | Futures | 1642.1 | 1643.9 | 1641.58 | 1642.1 | 10778.0 |
| 2013-05-01 08:00:00 | ES | Futures | 1641.84 | 1642.36 | 1640.3 | 1641.33 | 22996.0 |
| 2013-05-01 08:30:00 | ES | Futures | 1641.07 | 1641.07 | 1637.98 | 1638.24 | 30884.0 |
| 2013-05-01 09:00:00 | ES | Futures | 1638.49 | 1638.49 | 1636.18 | 1636.69 | 36976.0 |
| 2013-05-01 09:30:00 | ES | Futures | 1636.95 | 1637.72 | 1634.12 | 1635.15 | 161629.0 |
| 2013-05-01 10:00:00 | ES | Futures | 1635.15 | 1637.46 | 1630.77 | 1632.57 | 165642.0 |
| 2013-05-01 10:30:00 | ES | Futures | 1632.57 | 1635.92 | 1631.8 | 1635.66 | 77946.0 |
| 2013-05-01 11:00:00 | ES | Futures | 1635.92 | 1636.43 | 1634.63 | 1635.15 | 46852.0 |
| 2013-05-01 11:30:00 | ES | Futures | 1635.4 | 1636.18 | 1632.83 | 1635.66 | 54548.0 |
| 2013-05-01 12:00:00 | ES | Futures | 1635.4 | 1635.92 | 1633.34 | 1634.63 | 28656.0 |
| 2013-05-01 12:30:00 | ES | Futures | 1634.89 | 1634.89 | 1631.28 | 1631.54 | 42521.0 |
| 2013-05-01 13:00:00 | ES | Futures | 1631.54 | 1632.05 | 1629.22 | 1631.54 | 74819.0 |
| 2013-05-01 13:30:00 | ES | Futures | 1631.28 | 1631.8 | 1627.42 | 1629.22 | 78464.0 |
| 2013-05-01 14:00:00 | ES | Futures | 1629.22 | 1634.37 | 1628.96 | 1632.83 | 142161.0 |
| 2013-05-01 14:30:00 | ES | Futures | 1632.83 | 1633.34 | 1629.74 | 1631.8 | 71227.0 |
| 2013-05-01 15:00:00 | ES | Futures | 1631.8 | 1632.31 | 1625.1 | 1625.61 | 108510.0 |
| 2013-05-01 15:30:00 | ES | Futures | 1625.36 | 1627.42 | 1623.81 | 1626.13 | 150340.0 |
| 2013-05-01 16:00:00 | ES | Futures | 1626.13 | 1626.9 | 1624.33 | 1624.84 | 91070.0 |
| 2013-05-01 16:30:00 | ES | Futures | 1625.1 | 1626.9 | 1625.1 | 1626.65 | 8497.0 |
| 2013-05-01 17:00:00 | ES | Futures | 1626.39 | 1627.16 | 1626.39 | 1626.65 | 1861.0 |
| 2013-05-01 18:00:00 | ES | Futures | 1627.16 | 1628.19 | 1626.9 | 1627.42 | 4812.0 |
| 2013-05-01 18:30:00 | ES | Futures | 1627.42 | 1628.45 | 1626.9 | 1628.19 | 1901.0 |
| 2013-05-01 19:00:00 | ES | Futures | 1627.93 | 1628.45 | 1627.68 | 1627.68 | 854.0 |
| 2013-05-01 19:30:00 | ES | Futures | 1627.68 | 1627.68 | 1626.65 | 1627.16 | 1667.0 |
| 2013-05-01 20:00:00 | ES | Futures | 1627.16 | 1629.22 | 1626.9 | 1628.96 | 4137.0 |
| 2013-05-01 20:30:00 | ES | Futures | 1628.96 | 1629.74 | 1628.71 | 1628.71 | 2850.0 |
| 2013-05-01 21:00:00 | ES | Futures | 1628.71 | 1629.22 | 1627.68 | 1627.68 | 2842.0 |
| 2013-05-01 21:30:00 | ES | Futures | 1627.68 | 1628.45 | 1627.16 | 1627.93 | 1591.0 |
| 2013-05-01 22:00:00 | ES | Futures | 1628.19 | 1628.96 | 1627.93 | 1628.45 | 1093.0 |
| 2013-05-01 22:30:00 | ES | Futures | 1628.45 | 1629.22 | 1628.45 | 1629.22 | 1485.0 |
| 2013-05-01 23:00:00 | ES | Futures | 1628.96 | 1629.74 | 1628.96 | 1629.48 | 1828.0 |
| 2013-05-01 23:30:00 | ES | Futures | 1629.48 | 1629.99 | 1629.22 | 1629.22 | 1559.0 |
| 2013-05-01 00:00:00 | NQ | Futures | 3361.77 | 3362.93 | 3361.47 | 3361.77 | 93.0 |
| 2013-05-01 00:30:00 | NQ | Futures | 3361.77 | 3362.06 | 3361.47 | 3361.47 | 36.0 |
| 2013-05-01 01:00:00 | NQ | Futures | 3361.77 | 3362.06 | 3361.47 | 3362.06 | 46.0 |
> showing 50 of 2,527 rows — these rows as CSV