PREVIEW / futures_30min / 2013-09-17
file: by_date/futures_30min/2013/2013-09-17.parquet size: 72 KB rows: 2,774
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-09-17 00:00:00 | ES | Futures | 1743.04 | 1743.3 | 1742.52 | 1743.04 | 791.0 |
| 2013-09-17 00:30:00 | ES | Futures | 1743.04 | 1743.04 | 1742.26 | 1742.52 | 505.0 |
| 2013-09-17 01:00:00 | ES | Futures | 1742.78 | 1743.04 | 1742.01 | 1742.01 | 1167.0 |
| 2013-09-17 01:30:00 | ES | Futures | 1742.01 | 1743.04 | 1741.75 | 1742.78 | 1535.0 |
| 2013-09-17 02:00:00 | ES | Futures | 1742.52 | 1743.55 | 1742.26 | 1743.04 | 3437.0 |
| 2013-09-17 02:30:00 | ES | Futures | 1742.78 | 1743.3 | 1742.26 | 1743.04 | 1729.0 |
| 2013-09-17 03:00:00 | ES | Futures | 1743.3 | 1745.1 | 1743.04 | 1743.55 | 8356.0 |
| 2013-09-17 03:30:00 | ES | Futures | 1743.55 | 1744.59 | 1742.01 | 1742.26 | 5914.0 |
| 2013-09-17 04:00:00 | ES | Futures | 1742.01 | 1742.78 | 1741.49 | 1742.26 | 5373.0 |
| 2013-09-17 04:30:00 | ES | Futures | 1742.26 | 1744.07 | 1741.75 | 1743.55 | 5040.0 |
| 2013-09-17 05:00:00 | ES | Futures | 1743.3 | 1744.33 | 1741.75 | 1742.52 | 9116.0 |
| 2013-09-17 05:30:00 | ES | Futures | 1742.26 | 1743.55 | 1741.75 | 1743.04 | 6759.0 |
| 2013-09-17 06:00:00 | ES | Futures | 1743.3 | 1743.55 | 1742.01 | 1742.78 | 5655.0 |
| 2013-09-17 06:30:00 | ES | Futures | 1742.78 | 1743.55 | 1742.52 | 1743.3 | 4539.0 |
| 2013-09-17 07:00:00 | ES | Futures | 1743.3 | 1745.36 | 1742.26 | 1745.1 | 10463.0 |
| 2013-09-17 07:30:00 | ES | Futures | 1745.1 | 1745.1 | 1743.3 | 1745.1 | 10697.0 |
| 2013-09-17 08:00:00 | ES | Futures | 1745.1 | 1745.62 | 1744.59 | 1745.36 | 12714.0 |
| 2013-09-17 08:30:00 | ES | Futures | 1745.36 | 1746.65 | 1745.1 | 1745.62 | 20180.0 |
| 2013-09-17 09:00:00 | ES | Futures | 1745.62 | 1747.17 | 1745.62 | 1746.13 | 31728.0 |
| 2013-09-17 09:30:00 | ES | Futures | 1746.13 | 1750.52 | 1745.88 | 1748.97 | 147240.0 |
| 2013-09-17 10:00:00 | ES | Futures | 1749.23 | 1751.29 | 1748.71 | 1750.78 | 84015.0 |
| 2013-09-17 10:30:00 | ES | Futures | 1750.78 | 1751.81 | 1749.49 | 1750.26 | 61921.0 |
| 2013-09-17 11:00:00 | ES | Futures | 1750.0 | 1751.04 | 1749.49 | 1751.04 | 44702.0 |
| 2013-09-17 11:30:00 | ES | Futures | 1750.78 | 1751.29 | 1749.49 | 1750.26 | 34168.0 |
| 2013-09-17 12:00:00 | ES | Futures | 1750.26 | 1750.78 | 1749.75 | 1750.78 | 17048.0 |
| 2013-09-17 12:30:00 | ES | Futures | 1750.78 | 1752.33 | 1750.0 | 1752.07 | 29025.0 |
| 2013-09-17 13:00:00 | ES | Futures | 1752.07 | 1752.58 | 1751.04 | 1751.29 | 31124.0 |
| 2013-09-17 13:30:00 | ES | Futures | 1751.55 | 1752.33 | 1751.29 | 1752.33 | 21158.0 |
| 2013-09-17 14:00:00 | ES | Futures | 1752.07 | 1752.84 | 1751.29 | 1752.07 | 28433.0 |
| 2013-09-17 14:30:00 | ES | Futures | 1751.81 | 1752.58 | 1751.55 | 1752.07 | 27874.0 |
| 2013-09-17 15:00:00 | ES | Futures | 1751.81 | 1752.33 | 1751.55 | 1752.07 | 35368.0 |
| 2013-09-17 15:30:00 | ES | Futures | 1751.81 | 1752.33 | 1750.52 | 1752.33 | 95740.0 |
| 2013-09-17 16:00:00 | ES | Futures | 1752.07 | 1753.36 | 1751.55 | 1753.1 | 56227.0 |
| 2013-09-17 16:30:00 | ES | Futures | 1753.1 | 1753.87 | 1752.58 | 1753.1 | 7059.0 |
| 2013-09-17 17:00:00 | ES | Futures | 1753.36 | 1753.87 | 1753.1 | 1753.36 | 1740.0 |
| 2013-09-17 18:00:00 | ES | Futures | 1753.36 | 1753.87 | 1752.33 | 1752.58 | 3018.0 |
| 2013-09-17 18:30:00 | ES | Futures | 1752.58 | 1753.1 | 1752.58 | 1752.84 | 868.0 |
| 2013-09-17 19:00:00 | ES | Futures | 1752.84 | 1753.1 | 1752.58 | 1753.1 | 484.0 |
| 2013-09-17 19:30:00 | ES | Futures | 1753.1 | 1753.36 | 1752.84 | 1753.1 | 1298.0 |
| 2013-09-17 20:00:00 | ES | Futures | 1752.84 | 1754.13 | 1752.58 | 1753.61 | 4096.0 |
| 2013-09-17 20:30:00 | ES | Futures | 1753.61 | 1753.87 | 1753.1 | 1753.36 | 982.0 |
| 2013-09-17 21:00:00 | ES | Futures | 1753.1 | 1754.39 | 1753.1 | 1754.39 | 1862.0 |
| 2013-09-17 21:30:00 | ES | Futures | 1754.39 | 1754.65 | 1753.87 | 1754.65 | 2725.0 |
| 2013-09-17 22:00:00 | ES | Futures | 1754.39 | 1755.16 | 1754.39 | 1754.65 | 1898.0 |
| 2013-09-17 22:30:00 | ES | Futures | 1754.65 | 1754.65 | 1754.13 | 1754.13 | 1141.0 |
| 2013-09-17 23:00:00 | ES | Futures | 1754.39 | 1754.39 | 1752.33 | 1753.1 | 3837.0 |
| 2013-09-17 23:30:00 | ES | Futures | 1752.84 | 1753.87 | 1752.84 | 1753.36 | 891.0 |
| 2013-09-17 00:00:00 | NQ | Futures | 3671.36 | 3671.65 | 3669.91 | 3670.49 | 192.0 |
| 2013-09-17 00:30:00 | NQ | Futures | 3670.2 | 3670.2 | 3669.03 | 3669.03 | 139.0 |
| 2013-09-17 01:00:00 | NQ | Futures | 3669.32 | 3669.91 | 3667.87 | 3668.16 | 241.0 |
> showing 50 of 2,774 rows — these rows as CSV