PREVIEW / futures_30min / 2013-11-13
file: by_date/futures_30min/2013/2013-11-13.parquet size: 79 KB rows: 2,907
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-13 00:00:00 | ES | Futures | 1814.49 | 1816.04 | 1814.24 | 1814.49 | 4121.0 |
| 2013-11-13 00:30:00 | ES | Futures | 1814.75 | 1815.27 | 1814.24 | 1815.01 | 1795.0 |
| 2013-11-13 01:00:00 | ES | Futures | 1815.27 | 1816.56 | 1814.24 | 1816.56 | 2230.0 |
| 2013-11-13 01:30:00 | ES | Futures | 1816.56 | 1817.33 | 1816.3 | 1816.56 | 1666.0 |
| 2013-11-13 02:00:00 | ES | Futures | 1816.56 | 1817.07 | 1815.27 | 1815.53 | 2918.0 |
| 2013-11-13 02:30:00 | ES | Futures | 1815.78 | 1817.07 | 1815.53 | 1817.07 | 4756.0 |
| 2013-11-13 03:00:00 | ES | Futures | 1816.82 | 1820.94 | 1816.56 | 1820.68 | 14569.0 |
| 2013-11-13 03:30:00 | ES | Futures | 1820.94 | 1820.94 | 1819.14 | 1819.65 | 9387.0 |
| 2013-11-13 04:00:00 | ES | Futures | 1819.65 | 1819.65 | 1817.07 | 1819.14 | 12254.0 |
| 2013-11-13 04:30:00 | ES | Futures | 1819.39 | 1819.39 | 1817.33 | 1818.11 | 8432.0 |
| 2013-11-13 05:00:00 | ES | Futures | 1818.36 | 1820.43 | 1818.11 | 1819.14 | 8046.0 |
| 2013-11-13 05:30:00 | ES | Futures | 1819.14 | 1819.39 | 1817.85 | 1818.62 | 7253.0 |
| 2013-11-13 06:00:00 | ES | Futures | 1818.62 | 1818.88 | 1817.07 | 1817.59 | 7689.0 |
| 2013-11-13 06:30:00 | ES | Futures | 1817.59 | 1818.11 | 1815.53 | 1816.04 | 8762.0 |
| 2013-11-13 07:00:00 | ES | Futures | 1816.3 | 1817.07 | 1815.78 | 1815.78 | 12720.0 |
| 2013-11-13 07:30:00 | ES | Futures | 1815.78 | 1815.78 | 1813.72 | 1814.49 | 24504.0 |
| 2013-11-13 08:00:00 | ES | Futures | 1814.75 | 1814.75 | 1811.14 | 1811.66 | 46150.0 |
| 2013-11-13 08:30:00 | ES | Futures | 1811.66 | 1812.43 | 1810.11 | 1811.4 | 34110.0 |
| 2013-11-13 09:00:00 | ES | Futures | 1811.4 | 1812.69 | 1810.88 | 1811.4 | 21934.0 |
| 2013-11-13 09:30:00 | ES | Futures | 1811.4 | 1818.11 | 1811.4 | 1817.59 | 187747.0 |
| 2013-11-13 10:00:00 | ES | Futures | 1817.85 | 1819.39 | 1815.01 | 1818.36 | 119239.0 |
| 2013-11-13 10:30:00 | ES | Futures | 1818.62 | 1820.94 | 1818.36 | 1819.39 | 106992.0 |
| 2013-11-13 11:00:00 | ES | Futures | 1819.39 | 1819.91 | 1817.85 | 1818.88 | 64437.0 |
| 2013-11-13 11:30:00 | ES | Futures | 1818.62 | 1820.17 | 1817.59 | 1819.91 | 57680.0 |
| 2013-11-13 12:00:00 | ES | Futures | 1819.91 | 1824.3 | 1818.62 | 1823.78 | 105691.0 |
| 2013-11-13 12:30:00 | ES | Futures | 1823.78 | 1826.36 | 1823.26 | 1825.59 | 100351.0 |
| 2013-11-13 13:00:00 | ES | Futures | 1825.84 | 1828.17 | 1824.55 | 1827.91 | 64065.0 |
| 2013-11-13 13:30:00 | ES | Futures | 1827.91 | 1830.23 | 1827.39 | 1828.68 | 94070.0 |
| 2013-11-13 14:00:00 | ES | Futures | 1828.68 | 1829.46 | 1827.65 | 1828.68 | 49081.0 |
| 2013-11-13 14:30:00 | ES | Futures | 1828.94 | 1828.94 | 1826.62 | 1826.88 | 38386.0 |
| 2013-11-13 15:00:00 | ES | Futures | 1827.13 | 1830.49 | 1826.88 | 1829.46 | 47427.0 |
| 2013-11-13 15:30:00 | ES | Futures | 1829.2 | 1835.65 | 1828.68 | 1834.87 | 220080.0 |
| 2013-11-13 16:00:00 | ES | Futures | 1835.13 | 1836.16 | 1833.84 | 1835.13 | 109795.0 |
| 2013-11-13 16:30:00 | ES | Futures | 1834.87 | 1839.0 | 1834.87 | 1837.19 | 27745.0 |
| 2013-11-13 17:00:00 | ES | Futures | 1837.19 | 1837.97 | 1835.65 | 1836.16 | 6771.0 |
| 2013-11-13 18:00:00 | ES | Futures | 1836.42 | 1839.0 | 1835.65 | 1838.74 | 11955.0 |
| 2013-11-13 18:30:00 | ES | Futures | 1838.74 | 1840.03 | 1838.48 | 1839.26 | 7517.0 |
| 2013-11-13 19:00:00 | ES | Futures | 1839.26 | 1839.52 | 1838.74 | 1839.26 | 3305.0 |
| 2013-11-13 19:30:00 | ES | Futures | 1839.52 | 1840.03 | 1839.0 | 1839.52 | 2454.0 |
| 2013-11-13 20:00:00 | ES | Futures | 1839.26 | 1839.77 | 1838.48 | 1838.74 | 3608.0 |
| 2013-11-13 20:30:00 | ES | Futures | 1838.74 | 1839.0 | 1837.45 | 1837.45 | 4022.0 |
| 2013-11-13 21:00:00 | ES | Futures | 1837.45 | 1838.23 | 1837.45 | 1837.71 | 2075.0 |
| 2013-11-13 21:30:00 | ES | Futures | 1837.71 | 1840.03 | 1837.71 | 1839.52 | 3243.0 |
| 2013-11-13 22:00:00 | ES | Futures | 1839.52 | 1840.55 | 1839.52 | 1840.03 | 4683.0 |
| 2013-11-13 22:30:00 | ES | Futures | 1840.29 | 1840.55 | 1839.26 | 1839.52 | 3438.0 |
| 2013-11-13 23:00:00 | ES | Futures | 1839.52 | 1840.29 | 1838.74 | 1839.77 | 3637.0 |
| 2013-11-13 23:30:00 | ES | Futures | 1839.77 | 1840.03 | 1839.52 | 1839.77 | 829.0 |
| 2013-11-13 00:00:00 | NQ | Futures | 3890.34 | 3893.25 | 3889.76 | 3890.92 | 622.0 |
| 2013-11-13 00:30:00 | NQ | Futures | 3891.21 | 3892.67 | 3890.63 | 3891.8 | 302.0 |
| 2013-11-13 01:00:00 | NQ | Futures | 3891.8 | 3895.28 | 3890.92 | 3895.28 | 279.0 |
> showing 50 of 2,907 rows — these rows as CSV