PREVIEW / futures_30min / 2013-07-16
file: by_date/futures_30min/2013/2013-07-16.parquet size: 75 KB rows: 2,848
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-07-16 00:00:00 | ES | Futures | 1733.98 | 1734.5 | 1733.72 | 1733.98 | 434.0 |
| 2013-07-16 00:30:00 | ES | Futures | 1734.24 | 1734.5 | 1733.47 | 1734.24 | 721.0 |
| 2013-07-16 01:00:00 | ES | Futures | 1734.24 | 1734.5 | 1733.72 | 1733.98 | 794.0 |
| 2013-07-16 01:30:00 | ES | Futures | 1734.24 | 1734.76 | 1733.98 | 1734.24 | 1480.0 |
| 2013-07-16 02:00:00 | ES | Futures | 1734.5 | 1735.02 | 1734.24 | 1734.76 | 1483.0 |
| 2013-07-16 02:30:00 | ES | Futures | 1735.02 | 1735.53 | 1734.5 | 1735.53 | 2402.0 |
| 2013-07-16 03:00:00 | ES | Futures | 1735.53 | 1735.79 | 1733.72 | 1734.24 | 9542.0 |
| 2013-07-16 03:30:00 | ES | Futures | 1733.98 | 1735.79 | 1732.43 | 1732.95 | 13689.0 |
| 2013-07-16 04:00:00 | ES | Futures | 1733.21 | 1733.21 | 1731.14 | 1732.95 | 9776.0 |
| 2013-07-16 04:30:00 | ES | Futures | 1732.95 | 1733.98 | 1732.69 | 1733.72 | 4072.0 |
| 2013-07-16 05:00:00 | ES | Futures | 1733.72 | 1735.28 | 1732.95 | 1734.5 | 7341.0 |
| 2013-07-16 05:30:00 | ES | Futures | 1734.76 | 1735.02 | 1734.24 | 1734.76 | 3201.0 |
| 2013-07-16 06:00:00 | ES | Futures | 1734.76 | 1735.28 | 1734.5 | 1735.02 | 2737.0 |
| 2013-07-16 06:30:00 | ES | Futures | 1734.76 | 1735.79 | 1734.5 | 1734.76 | 8824.0 |
| 2013-07-16 07:00:00 | ES | Futures | 1734.76 | 1735.79 | 1734.24 | 1734.5 | 6928.0 |
| 2013-07-16 07:30:00 | ES | Futures | 1734.24 | 1735.79 | 1733.21 | 1733.47 | 13687.0 |
| 2013-07-16 08:00:00 | ES | Futures | 1733.72 | 1735.02 | 1732.95 | 1734.24 | 12093.0 |
| 2013-07-16 08:30:00 | ES | Futures | 1734.24 | 1735.02 | 1732.17 | 1734.5 | 21458.0 |
| 2013-07-16 09:00:00 | ES | Futures | 1734.5 | 1736.31 | 1734.24 | 1735.28 | 17690.0 |
| 2013-07-16 09:30:00 | ES | Futures | 1735.53 | 1736.57 | 1731.4 | 1731.66 | 127279.0 |
| 2013-07-16 10:00:00 | ES | Futures | 1731.92 | 1734.5 | 1731.66 | 1732.69 | 88903.0 |
| 2013-07-16 10:30:00 | ES | Futures | 1732.43 | 1733.47 | 1729.85 | 1729.85 | 69575.0 |
| 2013-07-16 11:00:00 | ES | Futures | 1729.85 | 1730.36 | 1727.52 | 1727.78 | 108823.0 |
| 2013-07-16 11:30:00 | ES | Futures | 1727.78 | 1728.3 | 1724.68 | 1726.23 | 113974.0 |
| 2013-07-16 12:00:00 | ES | Futures | 1726.23 | 1728.04 | 1725.45 | 1727.78 | 50934.0 |
| 2013-07-16 12:30:00 | ES | Futures | 1727.78 | 1727.78 | 1725.97 | 1726.23 | 28384.0 |
| 2013-07-16 13:00:00 | ES | Futures | 1725.97 | 1726.23 | 1723.13 | 1723.64 | 58171.0 |
| 2013-07-16 13:30:00 | ES | Futures | 1723.64 | 1726.75 | 1723.13 | 1726.75 | 48830.0 |
| 2013-07-16 14:00:00 | ES | Futures | 1726.75 | 1729.33 | 1726.49 | 1727.52 | 51485.0 |
| 2013-07-16 14:30:00 | ES | Futures | 1727.52 | 1728.55 | 1726.75 | 1727.0 | 38592.0 |
| 2013-07-16 15:00:00 | ES | Futures | 1726.75 | 1727.0 | 1724.42 | 1726.75 | 62031.0 |
| 2013-07-16 15:30:00 | ES | Futures | 1727.0 | 1728.3 | 1726.49 | 1727.78 | 97945.0 |
| 2013-07-16 16:00:00 | ES | Futures | 1728.04 | 1729.33 | 1727.26 | 1728.3 | 66638.0 |
| 2013-07-16 16:30:00 | ES | Futures | 1728.3 | 1729.33 | 1728.3 | 1728.81 | 4398.0 |
| 2013-07-16 17:00:00 | ES | Futures | 1728.55 | 1728.81 | 1728.3 | 1728.3 | 1088.0 |
| 2013-07-16 18:00:00 | ES | Futures | 1728.55 | 1729.59 | 1728.04 | 1728.81 | 2792.0 |
| 2013-07-16 18:30:00 | ES | Futures | 1728.81 | 1729.07 | 1728.55 | 1728.55 | 624.0 |
| 2013-07-16 19:00:00 | ES | Futures | 1728.55 | 1728.81 | 1728.04 | 1728.04 | 199.0 |
| 2013-07-16 19:30:00 | ES | Futures | 1728.04 | 1728.81 | 1728.04 | 1728.81 | 497.0 |
| 2013-07-16 20:00:00 | ES | Futures | 1728.81 | 1728.81 | 1728.3 | 1728.3 | 1049.0 |
| 2013-07-16 20:30:00 | ES | Futures | 1728.3 | 1728.81 | 1728.04 | 1728.04 | 816.0 |
| 2013-07-16 21:00:00 | ES | Futures | 1728.04 | 1728.55 | 1727.78 | 1728.3 | 1330.0 |
| 2013-07-16 21:30:00 | ES | Futures | 1728.3 | 1728.3 | 1726.75 | 1727.0 | 2283.0 |
| 2013-07-16 22:00:00 | ES | Futures | 1727.0 | 1728.55 | 1726.75 | 1728.3 | 2076.0 |
| 2013-07-16 22:30:00 | ES | Futures | 1728.55 | 1728.55 | 1728.04 | 1728.04 | 774.0 |
| 2013-07-16 23:00:00 | ES | Futures | 1728.3 | 1729.07 | 1728.04 | 1728.55 | 1150.0 |
| 2013-07-16 23:30:00 | ES | Futures | 1728.81 | 1728.81 | 1728.04 | 1728.81 | 452.0 |
| 2013-07-16 00:00:00 | NQ | Futures | 3592.46 | 3593.62 | 3592.46 | 3593.33 | 84.0 |
| 2013-07-16 00:30:00 | NQ | Futures | 3593.62 | 3594.79 | 3593.04 | 3594.5 | 142.0 |
| 2013-07-16 01:00:00 | NQ | Futures | 3594.21 | 3594.79 | 3593.33 | 3594.21 | 151.0 |
> showing 50 of 2,848 rows — these rows as CSV