PREVIEW / futures_30min / 2013-11-07
file: by_date/futures_30min/2013/2013-11-07.parquet size: 80 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-11-07 00:00:00 | ES | Futures | 1819.39 | 1820.43 | 1818.88 | 1819.91 | 1652.0 |
| 2013-11-07 00:30:00 | ES | Futures | 1819.91 | 1820.17 | 1819.39 | 1819.39 | 1188.0 |
| 2013-11-07 01:00:00 | ES | Futures | 1819.65 | 1820.17 | 1819.14 | 1819.91 | 696.0 |
| 2013-11-07 01:30:00 | ES | Futures | 1819.91 | 1820.43 | 1819.65 | 1820.17 | 735.0 |
| 2013-11-07 02:00:00 | ES | Futures | 1820.17 | 1820.17 | 1819.14 | 1819.65 | 1765.0 |
| 2013-11-07 02:30:00 | ES | Futures | 1819.39 | 1819.91 | 1819.14 | 1819.65 | 1078.0 |
| 2013-11-07 03:00:00 | ES | Futures | 1819.91 | 1820.43 | 1818.62 | 1819.65 | 6986.0 |
| 2013-11-07 03:30:00 | ES | Futures | 1819.39 | 1820.94 | 1818.88 | 1820.17 | 4912.0 |
| 2013-11-07 04:00:00 | ES | Futures | 1820.17 | 1820.68 | 1818.36 | 1819.14 | 7130.0 |
| 2013-11-07 04:30:00 | ES | Futures | 1819.14 | 1820.17 | 1818.62 | 1819.39 | 4370.0 |
| 2013-11-07 05:00:00 | ES | Futures | 1819.39 | 1820.68 | 1819.39 | 1819.91 | 4591.0 |
| 2013-11-07 05:30:00 | ES | Futures | 1819.91 | 1820.17 | 1818.62 | 1818.62 | 4320.0 |
| 2013-11-07 06:00:00 | ES | Futures | 1818.62 | 1819.65 | 1818.62 | 1818.88 | 4687.0 |
| 2013-11-07 06:30:00 | ES | Futures | 1818.88 | 1819.65 | 1818.36 | 1819.14 | 5509.0 |
| 2013-11-07 07:00:00 | ES | Futures | 1819.14 | 1821.72 | 1818.88 | 1820.68 | 13315.0 |
| 2013-11-07 07:30:00 | ES | Futures | 1820.94 | 1831.0 | 1820.43 | 1828.17 | 86207.0 |
| 2013-11-07 08:00:00 | ES | Futures | 1828.42 | 1830.49 | 1828.17 | 1828.42 | 37189.0 |
| 2013-11-07 08:30:00 | ES | Futures | 1828.68 | 1829.97 | 1825.84 | 1827.91 | 64488.0 |
| 2013-11-07 09:00:00 | ES | Futures | 1827.91 | 1828.17 | 1826.1 | 1826.36 | 25121.0 |
| 2013-11-07 09:30:00 | ES | Futures | 1826.36 | 1827.91 | 1822.23 | 1822.75 | 205562.0 |
| 2013-11-07 10:00:00 | ES | Futures | 1823.01 | 1823.78 | 1814.75 | 1817.59 | 254028.0 |
| 2013-11-07 10:30:00 | ES | Futures | 1817.59 | 1817.85 | 1812.43 | 1813.72 | 208315.0 |
| 2013-11-07 11:00:00 | ES | Futures | 1813.72 | 1815.78 | 1808.04 | 1810.37 | 199593.0 |
| 2013-11-07 11:30:00 | ES | Futures | 1810.62 | 1815.01 | 1809.59 | 1814.75 | 149156.0 |
| 2013-11-07 12:00:00 | ES | Futures | 1814.75 | 1817.59 | 1814.49 | 1816.04 | 99343.0 |
| 2013-11-07 12:30:00 | ES | Futures | 1816.04 | 1816.82 | 1812.95 | 1812.95 | 61195.0 |
| 2013-11-07 13:00:00 | ES | Futures | 1812.95 | 1813.98 | 1808.56 | 1808.82 | 66928.0 |
| 2013-11-07 13:30:00 | ES | Futures | 1809.08 | 1809.85 | 1806.5 | 1807.53 | 98918.0 |
| 2013-11-07 14:00:00 | ES | Futures | 1807.53 | 1807.79 | 1802.63 | 1803.4 | 154409.0 |
| 2013-11-07 14:30:00 | ES | Futures | 1803.4 | 1807.01 | 1800.82 | 1805.72 | 143763.0 |
| 2013-11-07 15:00:00 | ES | Futures | 1805.98 | 1806.5 | 1799.27 | 1799.79 | 120904.0 |
| 2013-11-07 15:30:00 | ES | Futures | 1799.53 | 1801.6 | 1797.73 | 1799.79 | 268317.0 |
| 2013-11-07 16:00:00 | ES | Futures | 1800.05 | 1801.6 | 1799.79 | 1801.08 | 116767.0 |
| 2013-11-07 16:30:00 | ES | Futures | 1801.08 | 1802.37 | 1800.82 | 1801.08 | 10214.0 |
| 2013-11-07 17:00:00 | ES | Futures | 1801.08 | 1801.34 | 1799.79 | 1800.31 | 3344.0 |
| 2013-11-07 18:00:00 | ES | Futures | 1800.31 | 1801.34 | 1797.98 | 1799.02 | 7276.0 |
| 2013-11-07 18:30:00 | ES | Futures | 1799.02 | 1801.6 | 1799.02 | 1801.34 | 3652.0 |
| 2013-11-07 19:00:00 | ES | Futures | 1801.34 | 1804.18 | 1800.82 | 1803.66 | 6043.0 |
| 2013-11-07 19:30:00 | ES | Futures | 1803.92 | 1803.92 | 1802.37 | 1803.14 | 3386.0 |
| 2013-11-07 20:00:00 | ES | Futures | 1802.89 | 1804.18 | 1802.89 | 1803.66 | 2537.0 |
| 2013-11-07 20:30:00 | ES | Futures | 1803.92 | 1804.43 | 1803.66 | 1803.66 | 1850.0 |
| 2013-11-07 21:00:00 | ES | Futures | 1803.66 | 1803.92 | 1802.89 | 1803.14 | 2040.0 |
| 2013-11-07 21:30:00 | ES | Futures | 1803.14 | 1804.95 | 1803.14 | 1803.4 | 4428.0 |
| 2013-11-07 22:00:00 | ES | Futures | 1803.4 | 1804.43 | 1803.14 | 1804.43 | 1428.0 |
| 2013-11-07 22:30:00 | ES | Futures | 1804.43 | 1804.43 | 1803.4 | 1803.4 | 1653.0 |
| 2013-11-07 23:00:00 | ES | Futures | 1803.66 | 1804.18 | 1803.4 | 1803.66 | 1417.0 |
| 2013-11-07 23:30:00 | ES | Futures | 1803.66 | 1804.43 | 1803.4 | 1804.18 | 2879.0 |
| 2013-11-07 00:00:00 | NQ | Futures | 3917.93 | 3919.68 | 3916.48 | 3918.81 | 359.0 |
| 2013-11-07 00:30:00 | NQ | Futures | 3918.81 | 3919.39 | 3917.64 | 3918.52 | 293.0 |
| 2013-11-07 01:00:00 | NQ | Futures | 3918.52 | 3919.68 | 3917.93 | 3919.1 | 238.0 |
> showing 50 of 2,921 rows — these rows as CSV