PREVIEW / futures_30min / 2013-10-22
file: by_date/futures_30min/2013/2013-10-22.parquet size: 77 KB rows: 2,921
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-10-22 00:00:00 | ES | Futures | 1792.31 | 1792.31 | 1792.05 | 1792.31 | 166.0 |
| 2013-10-22 00:30:00 | ES | Futures | 1792.31 | 1792.57 | 1792.05 | 1792.31 | 403.0 |
| 2013-10-22 01:00:00 | ES | Futures | 1792.57 | 1793.08 | 1792.31 | 1792.57 | 1079.0 |
| 2013-10-22 01:30:00 | ES | Futures | 1792.57 | 1793.34 | 1792.57 | 1793.08 | 1476.0 |
| 2013-10-22 02:00:00 | ES | Futures | 1793.08 | 1793.08 | 1791.79 | 1792.05 | 2122.0 |
| 2013-10-22 02:30:00 | ES | Futures | 1792.31 | 1792.57 | 1791.54 | 1791.79 | 2303.0 |
| 2013-10-22 03:00:00 | ES | Futures | 1791.79 | 1793.6 | 1791.54 | 1793.34 | 6705.0 |
| 2013-10-22 03:30:00 | ES | Futures | 1793.34 | 1793.86 | 1792.05 | 1792.57 | 5543.0 |
| 2013-10-22 04:00:00 | ES | Futures | 1792.57 | 1793.34 | 1792.57 | 1792.82 | 2268.0 |
| 2013-10-22 04:30:00 | ES | Futures | 1792.57 | 1793.34 | 1792.05 | 1793.08 | 3819.0 |
| 2013-10-22 05:00:00 | ES | Futures | 1793.08 | 1793.08 | 1792.31 | 1792.82 | 2631.0 |
| 2013-10-22 05:30:00 | ES | Futures | 1792.82 | 1792.82 | 1792.31 | 1792.57 | 4229.0 |
| 2013-10-22 06:00:00 | ES | Futures | 1792.31 | 1793.08 | 1792.05 | 1792.82 | 5861.0 |
| 2013-10-22 06:30:00 | ES | Futures | 1792.82 | 1792.82 | 1792.05 | 1792.57 | 6456.0 |
| 2013-10-22 07:00:00 | ES | Futures | 1792.57 | 1793.6 | 1792.05 | 1793.6 | 7569.0 |
| 2013-10-22 07:30:00 | ES | Futures | 1793.6 | 1794.37 | 1792.82 | 1793.08 | 9057.0 |
| 2013-10-22 08:00:00 | ES | Futures | 1793.08 | 1797.21 | 1793.08 | 1795.92 | 32468.0 |
| 2013-10-22 08:30:00 | ES | Futures | 1795.92 | 1800.31 | 1793.86 | 1798.24 | 98075.0 |
| 2013-10-22 09:00:00 | ES | Futures | 1798.24 | 1800.31 | 1798.24 | 1799.27 | 35579.0 |
| 2013-10-22 09:30:00 | ES | Futures | 1799.53 | 1805.21 | 1798.76 | 1804.43 | 195274.0 |
| 2013-10-22 10:00:00 | ES | Futures | 1804.69 | 1810.37 | 1804.18 | 1808.04 | 200647.0 |
| 2013-10-22 10:30:00 | ES | Futures | 1808.04 | 1808.3 | 1797.21 | 1801.34 | 253865.0 |
| 2013-10-22 11:00:00 | ES | Futures | 1801.08 | 1803.14 | 1798.5 | 1800.31 | 149710.0 |
| 2013-10-22 11:30:00 | ES | Futures | 1800.31 | 1804.43 | 1798.5 | 1804.18 | 90706.0 |
| 2013-10-22 12:00:00 | ES | Futures | 1804.18 | 1804.69 | 1801.08 | 1801.85 | 52742.0 |
| 2013-10-22 12:30:00 | ES | Futures | 1801.85 | 1802.37 | 1800.05 | 1801.6 | 70639.0 |
| 2013-10-22 13:00:00 | ES | Futures | 1801.6 | 1803.4 | 1801.08 | 1802.37 | 40533.0 |
| 2013-10-22 13:30:00 | ES | Futures | 1802.37 | 1805.21 | 1801.6 | 1804.43 | 73017.0 |
| 2013-10-22 14:00:00 | ES | Futures | 1804.69 | 1806.24 | 1802.11 | 1803.14 | 77991.0 |
| 2013-10-22 14:30:00 | ES | Futures | 1802.89 | 1807.27 | 1802.63 | 1805.72 | 74175.0 |
| 2013-10-22 15:00:00 | ES | Futures | 1805.72 | 1809.08 | 1805.46 | 1807.27 | 76803.0 |
| 2013-10-22 15:30:00 | ES | Futures | 1807.27 | 1807.53 | 1804.18 | 1804.95 | 157472.0 |
| 2013-10-22 16:00:00 | ES | Futures | 1805.21 | 1805.72 | 1803.92 | 1805.21 | 69875.0 |
| 2013-10-22 16:30:00 | ES | Futures | 1804.95 | 1805.72 | 1804.43 | 1805.46 | 7689.0 |
| 2013-10-22 17:00:00 | ES | Futures | 1805.46 | 1805.98 | 1805.21 | 1805.46 | 1750.0 |
| 2013-10-22 18:00:00 | ES | Futures | 1805.21 | 1805.21 | 1802.89 | 1803.92 | 4231.0 |
| 2013-10-22 18:30:00 | ES | Futures | 1803.92 | 1803.92 | 1803.14 | 1803.4 | 859.0 |
| 2013-10-22 19:00:00 | ES | Futures | 1803.66 | 1804.18 | 1803.4 | 1804.18 | 888.0 |
| 2013-10-22 19:30:00 | ES | Futures | 1803.92 | 1804.18 | 1803.92 | 1803.92 | 451.0 |
| 2013-10-22 20:00:00 | ES | Futures | 1804.18 | 1804.69 | 1802.89 | 1803.4 | 2947.0 |
| 2013-10-22 20:30:00 | ES | Futures | 1803.14 | 1803.66 | 1802.37 | 1802.63 | 2311.0 |
| 2013-10-22 21:00:00 | ES | Futures | 1802.63 | 1803.14 | 1802.63 | 1803.14 | 1044.0 |
| 2013-10-22 21:30:00 | ES | Futures | 1802.89 | 1804.18 | 1802.11 | 1803.92 | 2654.0 |
| 2013-10-22 22:00:00 | ES | Futures | 1803.92 | 1804.18 | 1803.4 | 1803.66 | 1281.0 |
| 2013-10-22 22:30:00 | ES | Futures | 1803.66 | 1804.18 | 1803.66 | 1803.92 | 455.0 |
| 2013-10-22 23:00:00 | ES | Futures | 1803.92 | 1803.92 | 1801.85 | 1801.85 | 2126.0 |
| 2013-10-22 23:30:00 | ES | Futures | 1801.85 | 1802.37 | 1800.82 | 1801.08 | 7559.0 |
| 2013-10-22 00:00:00 | NQ | Futures | 3894.99 | 3896.15 | 3894.99 | 3895.28 | 51.0 |
| 2013-10-22 00:30:00 | NQ | Futures | 3895.28 | 3896.15 | 3895.28 | 3895.86 | 48.0 |
| 2013-10-22 01:00:00 | NQ | Futures | 3896.15 | 3897.6 | 3895.86 | 3897.02 | 138.0 |
> showing 50 of 2,921 rows — these rows as CSV