PREVIEW / futures_30min / 2013-10-30
file: by_date/futures_30min/2013/2013-10-30.parquet size: 76 KB rows: 2,881
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-30 00:00:00 | ES | Futures | 1824.04 | 1824.04 | 1823.52 | 1823.52 | 462.0 |
| 2013-10-30 00:30:00 | ES | Futures | 1823.52 | 1823.52 | 1823.01 | 1823.26 | 420.0 |
| 2013-10-30 01:00:00 | ES | Futures | 1823.26 | 1823.78 | 1823.01 | 1823.01 | 859.0 |
| 2013-10-30 01:30:00 | ES | Futures | 1823.26 | 1824.04 | 1823.01 | 1823.78 | 1227.0 |
| 2013-10-30 02:00:00 | ES | Futures | 1823.78 | 1824.55 | 1823.52 | 1824.3 | 1253.0 |
| 2013-10-30 02:30:00 | ES | Futures | 1824.55 | 1825.84 | 1824.3 | 1825.07 | 2488.0 |
| 2013-10-30 03:00:00 | ES | Futures | 1825.07 | 1826.1 | 1824.3 | 1825.84 | 3193.0 |
| 2013-10-30 03:30:00 | ES | Futures | 1826.1 | 1826.1 | 1825.07 | 1825.59 | 2902.0 |
| 2013-10-30 04:00:00 | ES | Futures | 1825.59 | 1827.91 | 1824.55 | 1827.65 | 15270.0 |
| 2013-10-30 04:30:00 | ES | Futures | 1827.65 | 1828.17 | 1826.88 | 1827.91 | 8704.0 |
| 2013-10-30 05:00:00 | ES | Futures | 1828.17 | 1829.2 | 1827.91 | 1828.94 | 10296.0 |
| 2013-10-30 05:30:00 | ES | Futures | 1828.94 | 1829.71 | 1828.42 | 1828.94 | 9033.0 |
| 2013-10-30 06:00:00 | ES | Futures | 1828.94 | 1829.2 | 1827.91 | 1828.68 | 5676.0 |
| 2013-10-30 06:30:00 | ES | Futures | 1828.42 | 1829.2 | 1828.17 | 1828.42 | 3863.0 |
| 2013-10-30 07:00:00 | ES | Futures | 1828.68 | 1828.94 | 1827.91 | 1827.91 | 8359.0 |
| 2013-10-30 07:30:00 | ES | Futures | 1827.91 | 1828.17 | 1827.13 | 1827.91 | 7412.0 |
| 2013-10-30 08:00:00 | ES | Futures | 1827.91 | 1827.91 | 1826.1 | 1826.88 | 17392.0 |
| 2013-10-30 08:30:00 | ES | Futures | 1826.88 | 1827.65 | 1825.33 | 1826.1 | 15910.0 |
| 2013-10-30 09:00:00 | ES | Futures | 1825.84 | 1826.62 | 1824.3 | 1825.33 | 22461.0 |
| 2013-10-30 09:30:00 | ES | Futures | 1825.59 | 1826.88 | 1822.75 | 1824.3 | 147334.0 |
| 2013-10-30 10:00:00 | ES | Futures | 1824.3 | 1825.07 | 1821.72 | 1823.26 | 119310.0 |
| 2013-10-30 10:30:00 | ES | Futures | 1823.52 | 1824.81 | 1821.72 | 1824.04 | 86858.0 |
| 2013-10-30 11:00:00 | ES | Futures | 1824.04 | 1824.81 | 1819.65 | 1820.17 | 85639.0 |
| 2013-10-30 11:30:00 | ES | Futures | 1819.91 | 1820.17 | 1817.59 | 1818.88 | 95829.0 |
| 2013-10-30 12:00:00 | ES | Futures | 1818.88 | 1819.91 | 1818.11 | 1818.88 | 51240.0 |
| 2013-10-30 12:30:00 | ES | Futures | 1818.62 | 1821.46 | 1818.62 | 1820.94 | 58933.0 |
| 2013-10-30 13:00:00 | ES | Futures | 1821.2 | 1821.46 | 1818.11 | 1818.11 | 42384.0 |
| 2013-10-30 13:30:00 | ES | Futures | 1818.11 | 1819.14 | 1816.3 | 1817.33 | 67406.0 |
| 2013-10-30 14:00:00 | ES | Futures | 1817.33 | 1822.49 | 1807.53 | 1810.62 | 365838.0 |
| 2013-10-30 14:30:00 | ES | Futures | 1810.37 | 1814.75 | 1809.33 | 1813.46 | 141287.0 |
| 2013-10-30 15:00:00 | ES | Futures | 1813.72 | 1817.07 | 1812.17 | 1814.75 | 122321.0 |
| 2013-10-30 15:30:00 | ES | Futures | 1814.75 | 1817.07 | 1813.46 | 1814.75 | 127547.0 |
| 2013-10-30 16:00:00 | ES | Futures | 1814.49 | 1817.07 | 1813.2 | 1816.82 | 91023.0 |
| 2013-10-30 16:30:00 | ES | Futures | 1816.82 | 1817.07 | 1815.53 | 1815.53 | 10189.0 |
| 2013-10-30 17:00:00 | ES | Futures | 1815.53 | 1815.78 | 1815.01 | 1815.01 | 1819.0 |
| 2013-10-30 18:00:00 | ES | Futures | 1813.72 | 1813.98 | 1811.4 | 1811.4 | 7092.0 |
| 2013-10-30 18:30:00 | ES | Futures | 1811.4 | 1812.17 | 1809.08 | 1809.59 | 6556.0 |
| 2013-10-30 19:00:00 | ES | Futures | 1809.59 | 1810.62 | 1809.08 | 1809.85 | 4054.0 |
| 2013-10-30 19:30:00 | ES | Futures | 1809.59 | 1811.14 | 1809.08 | 1810.37 | 4552.0 |
| 2013-10-30 20:00:00 | ES | Futures | 1810.37 | 1811.14 | 1809.33 | 1810.88 | 3348.0 |
| 2013-10-30 20:30:00 | ES | Futures | 1810.88 | 1810.88 | 1809.59 | 1810.11 | 2559.0 |
| 2013-10-30 21:00:00 | ES | Futures | 1810.11 | 1810.37 | 1808.3 | 1808.82 | 5536.0 |
| 2013-10-30 21:30:00 | ES | Futures | 1808.82 | 1808.82 | 1807.79 | 1808.56 | 4555.0 |
| 2013-10-30 22:00:00 | ES | Futures | 1808.82 | 1808.82 | 1808.3 | 1808.82 | 3329.0 |
| 2013-10-30 22:30:00 | ES | Futures | 1808.82 | 1809.33 | 1808.56 | 1809.33 | 3810.0 |
| 2013-10-30 23:00:00 | ES | Futures | 1809.33 | 1809.85 | 1808.04 | 1809.85 | 2608.0 |
| 2013-10-30 23:30:00 | ES | Futures | 1809.85 | 1811.4 | 1809.85 | 1810.37 | 2523.0 |
| 2013-10-30 00:00:00 | NQ | Futures | 3938.26 | 3938.56 | 3937.68 | 3937.68 | 61.0 |
| 2013-10-30 00:30:00 | NQ | Futures | 3937.68 | 3937.97 | 3937.1 | 3937.1 | 106.0 |
| 2013-10-30 01:00:00 | NQ | Futures | 3937.39 | 3937.97 | 3936.81 | 3936.81 | 170.0 |
> showing 50 of 2,881 rows — these rows as CSV