PREVIEW / futures_30min / 2014-02-05
file: by_date/futures_30min/2014/2014-02-05.parquet size: 78 KB rows: 2,948
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 |
|---|---|---|---|---|---|---|---|
| 2014-02-05 00:00:00 | ES | Futures | 1799.71 | 1801.0 | 1798.93 | 1799.97 | 2750.0 |
| 2014-02-05 00:30:00 | ES | Futures | 1800.23 | 1800.49 | 1799.45 | 1799.97 | 1356.0 |
| 2014-02-05 01:00:00 | ES | Futures | 1799.97 | 1801.0 | 1799.71 | 1800.74 | 1659.0 |
| 2014-02-05 01:30:00 | ES | Futures | 1800.49 | 1801.0 | 1799.97 | 1800.23 | 1872.0 |
| 2014-02-05 02:00:00 | ES | Futures | 1800.23 | 1801.26 | 1798.67 | 1800.74 | 7650.0 |
| 2014-02-05 02:30:00 | ES | Futures | 1801.0 | 1801.78 | 1799.97 | 1801.52 | 5012.0 |
| 2014-02-05 03:00:00 | ES | Futures | 1801.26 | 1803.59 | 1799.19 | 1803.07 | 27125.0 |
| 2014-02-05 03:30:00 | ES | Futures | 1803.07 | 1804.88 | 1802.55 | 1803.07 | 14155.0 |
| 2014-02-05 04:00:00 | ES | Futures | 1803.07 | 1804.88 | 1802.3 | 1804.88 | 12004.0 |
| 2014-02-05 04:30:00 | ES | Futures | 1804.88 | 1804.88 | 1802.81 | 1803.07 | 7225.0 |
| 2014-02-05 05:00:00 | ES | Futures | 1803.07 | 1804.37 | 1801.26 | 1803.59 | 10660.0 |
| 2014-02-05 05:30:00 | ES | Futures | 1803.59 | 1804.11 | 1801.52 | 1801.78 | 5644.0 |
| 2014-02-05 06:00:00 | ES | Futures | 1802.04 | 1802.04 | 1799.45 | 1800.49 | 8893.0 |
| 2014-02-05 06:30:00 | ES | Futures | 1800.49 | 1803.07 | 1800.23 | 1800.74 | 11447.0 |
| 2014-02-05 07:00:00 | ES | Futures | 1800.74 | 1802.3 | 1797.9 | 1800.74 | 14716.0 |
| 2014-02-05 07:30:00 | ES | Futures | 1800.74 | 1801.78 | 1798.16 | 1798.93 | 13751.0 |
| 2014-02-05 08:00:00 | ES | Futures | 1798.93 | 1801.78 | 1794.28 | 1795.83 | 69044.0 |
| 2014-02-05 08:30:00 | ES | Futures | 1795.57 | 1804.37 | 1795.05 | 1803.07 | 61421.0 |
| 2014-02-05 09:00:00 | ES | Futures | 1802.81 | 1804.37 | 1801.52 | 1803.07 | 46158.0 |
| 2014-02-05 09:30:00 | ES | Futures | 1803.33 | 1807.47 | 1798.93 | 1800.74 | 227801.0 |
| 2014-02-05 10:00:00 | ES | Futures | 1800.74 | 1809.8 | 1791.95 | 1795.57 | 356973.0 |
| 2014-02-05 10:30:00 | ES | Futures | 1795.57 | 1801.26 | 1794.28 | 1798.42 | 190923.0 |
| 2014-02-05 11:00:00 | ES | Futures | 1798.16 | 1803.07 | 1794.02 | 1802.81 | 121916.0 |
| 2014-02-05 11:30:00 | ES | Futures | 1802.81 | 1807.99 | 1801.52 | 1806.69 | 112694.0 |
| 2014-02-05 12:00:00 | ES | Futures | 1806.69 | 1809.02 | 1804.37 | 1805.4 | 70695.0 |
| 2014-02-05 12:30:00 | ES | Futures | 1805.66 | 1807.47 | 1804.88 | 1806.95 | 37363.0 |
| 2014-02-05 13:00:00 | ES | Futures | 1807.21 | 1811.09 | 1806.95 | 1808.5 | 75830.0 |
| 2014-02-05 13:30:00 | ES | Futures | 1808.5 | 1811.09 | 1807.99 | 1809.54 | 55380.0 |
| 2014-02-05 14:00:00 | ES | Futures | 1809.54 | 1811.35 | 1806.95 | 1809.28 | 58453.0 |
| 2014-02-05 14:30:00 | ES | Futures | 1809.54 | 1810.57 | 1804.62 | 1805.66 | 73762.0 |
| 2014-02-05 15:00:00 | ES | Futures | 1805.66 | 1809.54 | 1804.37 | 1809.54 | 67266.0 |
| 2014-02-05 15:30:00 | ES | Futures | 1809.28 | 1811.09 | 1805.92 | 1806.69 | 143745.0 |
| 2014-02-05 16:00:00 | ES | Futures | 1806.69 | 1806.95 | 1803.07 | 1804.62 | 92309.0 |
| 2014-02-05 16:30:00 | ES | Futures | 1804.37 | 1806.43 | 1804.37 | 1805.92 | 7751.0 |
| 2014-02-05 17:00:00 | ES | Futures | 1805.92 | 1806.43 | 1804.88 | 1805.14 | 2865.0 |
| 2014-02-05 18:00:00 | ES | Futures | 1805.14 | 1806.69 | 1804.37 | 1806.43 | 6414.0 |
| 2014-02-05 18:30:00 | ES | Futures | 1806.43 | 1806.43 | 1804.62 | 1806.18 | 2696.0 |
| 2014-02-05 19:00:00 | ES | Futures | 1805.92 | 1807.99 | 1805.66 | 1807.99 | 4428.0 |
| 2014-02-05 19:30:00 | ES | Futures | 1807.99 | 1809.8 | 1807.47 | 1808.25 | 5540.0 |
| 2014-02-05 20:00:00 | ES | Futures | 1808.25 | 1808.5 | 1806.69 | 1806.95 | 2368.0 |
| 2014-02-05 20:30:00 | ES | Futures | 1807.21 | 1807.99 | 1804.37 | 1807.21 | 4535.0 |
| 2014-02-05 21:00:00 | ES | Futures | 1807.21 | 1807.99 | 1804.88 | 1806.95 | 2269.0 |
| 2014-02-05 21:30:00 | ES | Futures | 1806.69 | 1808.25 | 1806.69 | 1807.73 | 771.0 |
| 2014-02-05 22:00:00 | ES | Futures | 1807.73 | 1807.73 | 1806.69 | 1806.95 | 1029.0 |
| 2014-02-05 22:30:00 | ES | Futures | 1806.95 | 1808.25 | 1806.95 | 1807.99 | 1713.0 |
| 2014-02-05 23:00:00 | ES | Futures | 1808.25 | 1809.54 | 1808.25 | 1809.28 | 2134.0 |
| 2014-02-05 23:30:00 | ES | Futures | 1809.28 | 1809.54 | 1808.25 | 1808.25 | 823.0 |
| 2014-02-05 00:00:00 | NQ | Futures | 4005.64 | 4007.96 | 4002.73 | 4005.05 | 280.0 |
| 2014-02-05 00:30:00 | NQ | Futures | 4005.93 | 4007.09 | 4004.18 | 4005.34 | 190.0 |
| 2014-02-05 01:00:00 | NQ | Futures | 4006.22 | 4007.38 | 4005.34 | 4007.09 | 60.0 |
> showing 50 of 2,948 rows — these rows as CSV