PREVIEW / futures_30min / 2013-08-13
file: by_date/futures_30min/2013/2013-08-13.parquet size: 77 KB rows: 2,832
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-08-13 00:00:00 | ES | Futures | 1746.13 | 1746.39 | 1745.62 | 1745.87 | 1125.0 |
| 2013-08-13 00:30:00 | ES | Futures | 1745.87 | 1746.65 | 1745.87 | 1746.13 | 1879.0 |
| 2013-08-13 01:00:00 | ES | Futures | 1746.13 | 1746.65 | 1746.13 | 1746.13 | 1251.0 |
| 2013-08-13 01:30:00 | ES | Futures | 1746.39 | 1747.17 | 1746.13 | 1746.13 | 2552.0 |
| 2013-08-13 02:00:00 | ES | Futures | 1746.13 | 1747.42 | 1746.13 | 1746.91 | 4097.0 |
| 2013-08-13 02:30:00 | ES | Futures | 1747.17 | 1747.42 | 1746.13 | 1746.91 | 2598.0 |
| 2013-08-13 03:00:00 | ES | Futures | 1746.91 | 1749.49 | 1746.13 | 1748.98 | 13684.0 |
| 2013-08-13 03:30:00 | ES | Futures | 1748.98 | 1749.49 | 1747.94 | 1747.94 | 11104.0 |
| 2013-08-13 04:00:00 | ES | Futures | 1747.94 | 1750.27 | 1747.94 | 1749.75 | 10189.0 |
| 2013-08-13 04:30:00 | ES | Futures | 1749.75 | 1751.04 | 1749.75 | 1751.04 | 7923.0 |
| 2013-08-13 05:00:00 | ES | Futures | 1750.79 | 1751.56 | 1749.75 | 1750.27 | 8880.0 |
| 2013-08-13 05:30:00 | ES | Futures | 1750.27 | 1751.3 | 1749.49 | 1750.01 | 6748.0 |
| 2013-08-13 06:00:00 | ES | Futures | 1750.01 | 1750.79 | 1749.75 | 1750.27 | 6806.0 |
| 2013-08-13 06:30:00 | ES | Futures | 1750.27 | 1750.53 | 1748.72 | 1748.98 | 6779.0 |
| 2013-08-13 07:00:00 | ES | Futures | 1748.98 | 1749.23 | 1747.68 | 1747.94 | 10804.0 |
| 2013-08-13 07:30:00 | ES | Futures | 1747.94 | 1748.98 | 1747.94 | 1748.46 | 7851.0 |
| 2013-08-13 08:00:00 | ES | Futures | 1748.46 | 1748.98 | 1747.94 | 1748.2 | 9257.0 |
| 2013-08-13 08:30:00 | ES | Futures | 1748.2 | 1749.23 | 1745.62 | 1747.17 | 36704.0 |
| 2013-08-13 09:00:00 | ES | Futures | 1747.42 | 1748.46 | 1746.39 | 1746.91 | 29250.0 |
| 2013-08-13 09:30:00 | ES | Futures | 1746.65 | 1747.94 | 1742.26 | 1743.81 | 204160.0 |
| 2013-08-13 10:00:00 | ES | Futures | 1743.55 | 1743.81 | 1736.31 | 1739.15 | 214957.0 |
| 2013-08-13 10:30:00 | ES | Futures | 1738.89 | 1740.45 | 1736.83 | 1738.64 | 122580.0 |
| 2013-08-13 11:00:00 | ES | Futures | 1738.64 | 1742.26 | 1738.12 | 1742.0 | 97239.0 |
| 2013-08-13 11:30:00 | ES | Futures | 1742.0 | 1743.29 | 1741.74 | 1741.74 | 70766.0 |
| 2013-08-13 12:00:00 | ES | Futures | 1741.74 | 1746.13 | 1740.96 | 1745.87 | 76157.0 |
| 2013-08-13 12:30:00 | ES | Futures | 1745.87 | 1749.23 | 1745.87 | 1748.2 | 96376.0 |
| 2013-08-13 13:00:00 | ES | Futures | 1748.2 | 1752.08 | 1747.42 | 1751.04 | 91982.0 |
| 2013-08-13 13:30:00 | ES | Futures | 1750.79 | 1751.3 | 1748.98 | 1749.23 | 68952.0 |
| 2013-08-13 14:00:00 | ES | Futures | 1749.23 | 1750.79 | 1748.72 | 1750.27 | 45140.0 |
| 2013-08-13 14:30:00 | ES | Futures | 1750.27 | 1750.27 | 1747.68 | 1749.49 | 70705.0 |
| 2013-08-13 15:00:00 | ES | Futures | 1749.49 | 1751.3 | 1748.46 | 1750.27 | 65345.0 |
| 2013-08-13 15:30:00 | ES | Futures | 1750.27 | 1751.04 | 1747.94 | 1748.72 | 105294.0 |
| 2013-08-13 16:00:00 | ES | Futures | 1748.72 | 1750.01 | 1747.94 | 1748.2 | 68099.0 |
| 2013-08-13 16:30:00 | ES | Futures | 1748.2 | 1748.72 | 1747.94 | 1748.2 | 4946.0 |
| 2013-08-13 17:00:00 | ES | Futures | 1748.2 | 1748.46 | 1747.94 | 1748.2 | 1437.0 |
| 2013-08-13 18:00:00 | ES | Futures | 1748.98 | 1750.01 | 1748.2 | 1749.75 | 3720.0 |
| 2013-08-13 18:30:00 | ES | Futures | 1749.75 | 1749.75 | 1749.23 | 1749.75 | 380.0 |
| 2013-08-13 19:00:00 | ES | Futures | 1749.75 | 1750.01 | 1749.23 | 1749.49 | 554.0 |
| 2013-08-13 19:30:00 | ES | Futures | 1749.49 | 1749.49 | 1748.2 | 1748.2 | 1107.0 |
| 2013-08-13 20:00:00 | ES | Futures | 1748.2 | 1748.46 | 1746.91 | 1747.17 | 4272.0 |
| 2013-08-13 20:30:00 | ES | Futures | 1747.42 | 1748.2 | 1746.65 | 1747.94 | 3644.0 |
| 2013-08-13 21:00:00 | ES | Futures | 1747.68 | 1747.94 | 1746.91 | 1746.91 | 2387.0 |
| 2013-08-13 21:30:00 | ES | Futures | 1746.91 | 1747.17 | 1746.65 | 1746.65 | 2925.0 |
| 2013-08-13 22:00:00 | ES | Futures | 1746.65 | 1746.91 | 1745.87 | 1746.39 | 3208.0 |
| 2013-08-13 22:30:00 | ES | Futures | 1746.39 | 1746.91 | 1745.87 | 1746.39 | 1633.0 |
| 2013-08-13 23:00:00 | ES | Futures | 1746.39 | 1746.39 | 1745.62 | 1745.87 | 1599.0 |
| 2013-08-13 23:30:00 | ES | Futures | 1746.13 | 1746.39 | 1745.36 | 1745.62 | 2201.0 |
| 2013-08-13 00:00:00 | NQ | Futures | 3656.16 | 3657.04 | 3655.87 | 3656.46 | 131.0 |
| 2013-08-13 00:30:00 | NQ | Futures | 3656.46 | 3657.33 | 3656.16 | 3656.75 | 303.0 |
| 2013-08-13 01:00:00 | NQ | Futures | 3657.04 | 3657.33 | 3656.16 | 3656.46 | 145.0 |
> showing 50 of 2,832 rows — these rows as CSV