PREVIEW / futures_30min / 2013-10-02
file: by_date/futures_30min/2013/2013-10-02.parquet size: 77 KB rows: 2,880
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-02 00:00:00 | ES | Futures | 1740.46 | 1740.97 | 1740.2 | 1740.72 | 2154.0 |
| 2013-10-02 00:30:00 | ES | Futures | 1740.72 | 1740.97 | 1740.2 | 1740.46 | 1557.0 |
| 2013-10-02 01:00:00 | ES | Futures | 1740.46 | 1740.97 | 1738.65 | 1739.17 | 4141.0 |
| 2013-10-02 01:30:00 | ES | Futures | 1738.91 | 1739.94 | 1738.14 | 1739.69 | 4731.0 |
| 2013-10-02 02:00:00 | ES | Futures | 1739.69 | 1739.69 | 1737.62 | 1738.14 | 4830.0 |
| 2013-10-02 02:30:00 | ES | Futures | 1738.4 | 1738.4 | 1737.11 | 1738.14 | 4487.0 |
| 2013-10-02 03:00:00 | ES | Futures | 1737.88 | 1737.88 | 1731.17 | 1731.95 | 35931.0 |
| 2013-10-02 03:30:00 | ES | Futures | 1731.95 | 1731.95 | 1729.62 | 1730.91 | 19923.0 |
| 2013-10-02 04:00:00 | ES | Futures | 1730.91 | 1732.2 | 1728.85 | 1729.62 | 17881.0 |
| 2013-10-02 04:30:00 | ES | Futures | 1729.62 | 1730.66 | 1728.85 | 1730.4 | 11246.0 |
| 2013-10-02 05:00:00 | ES | Futures | 1730.4 | 1732.98 | 1730.14 | 1732.46 | 11035.0 |
| 2013-10-02 05:30:00 | ES | Futures | 1732.46 | 1733.49 | 1729.37 | 1731.17 | 15192.0 |
| 2013-10-02 06:00:00 | ES | Futures | 1731.17 | 1731.95 | 1729.62 | 1731.43 | 10718.0 |
| 2013-10-02 06:30:00 | ES | Futures | 1731.17 | 1731.95 | 1730.14 | 1731.17 | 10789.0 |
| 2013-10-02 07:00:00 | ES | Futures | 1731.17 | 1733.75 | 1730.4 | 1733.24 | 17161.0 |
| 2013-10-02 07:30:00 | ES | Futures | 1733.24 | 1735.3 | 1732.98 | 1734.27 | 21198.0 |
| 2013-10-02 08:00:00 | ES | Futures | 1734.27 | 1735.04 | 1729.62 | 1730.14 | 42832.0 |
| 2013-10-02 08:30:00 | ES | Futures | 1730.14 | 1731.17 | 1728.59 | 1730.14 | 35669.0 |
| 2013-10-02 09:00:00 | ES | Futures | 1730.4 | 1732.72 | 1729.37 | 1732.2 | 32158.0 |
| 2013-10-02 09:30:00 | ES | Futures | 1731.95 | 1734.53 | 1729.88 | 1731.69 | 197000.0 |
| 2013-10-02 10:00:00 | ES | Futures | 1731.69 | 1732.72 | 1726.53 | 1728.85 | 168876.0 |
| 2013-10-02 10:30:00 | ES | Futures | 1728.85 | 1732.2 | 1726.79 | 1731.43 | 105105.0 |
| 2013-10-02 11:00:00 | ES | Futures | 1731.43 | 1735.3 | 1730.91 | 1734.27 | 105388.0 |
| 2013-10-02 11:30:00 | ES | Futures | 1734.27 | 1736.33 | 1733.24 | 1735.3 | 84442.0 |
| 2013-10-02 12:00:00 | ES | Futures | 1735.3 | 1738.14 | 1735.04 | 1736.07 | 76694.0 |
| 2013-10-02 12:30:00 | ES | Futures | 1736.07 | 1739.17 | 1736.07 | 1737.88 | 60632.0 |
| 2013-10-02 13:00:00 | ES | Futures | 1737.88 | 1740.72 | 1737.36 | 1740.2 | 67767.0 |
| 2013-10-02 13:30:00 | ES | Futures | 1740.46 | 1741.23 | 1738.91 | 1739.43 | 43740.0 |
| 2013-10-02 14:00:00 | ES | Futures | 1739.17 | 1739.43 | 1737.11 | 1738.4 | 60337.0 |
| 2013-10-02 14:30:00 | ES | Futures | 1738.65 | 1739.17 | 1735.56 | 1736.85 | 62107.0 |
| 2013-10-02 15:00:00 | ES | Futures | 1736.85 | 1737.88 | 1735.82 | 1737.11 | 47119.0 |
| 2013-10-02 15:30:00 | ES | Futures | 1737.11 | 1741.23 | 1736.07 | 1740.46 | 134183.0 |
| 2013-10-02 16:00:00 | ES | Futures | 1740.72 | 1740.72 | 1736.33 | 1737.11 | 87255.0 |
| 2013-10-02 16:30:00 | ES | Futures | 1737.36 | 1737.36 | 1735.82 | 1737.11 | 9775.0 |
| 2013-10-02 17:00:00 | ES | Futures | 1737.11 | 1737.36 | 1736.33 | 1736.33 | 1856.0 |
| 2013-10-02 18:00:00 | ES | Futures | 1736.59 | 1737.11 | 1735.56 | 1736.33 | 3300.0 |
| 2013-10-02 18:30:00 | ES | Futures | 1736.33 | 1736.33 | 1734.53 | 1734.78 | 3084.0 |
| 2013-10-02 19:00:00 | ES | Futures | 1735.04 | 1735.04 | 1731.69 | 1731.95 | 7911.0 |
| 2013-10-02 19:30:00 | ES | Futures | 1731.69 | 1731.95 | 1726.79 | 1730.14 | 14193.0 |
| 2013-10-02 20:00:00 | ES | Futures | 1730.14 | 1730.4 | 1728.59 | 1730.4 | 6873.0 |
| 2013-10-02 20:30:00 | ES | Futures | 1730.4 | 1730.91 | 1728.85 | 1729.37 | 4316.0 |
| 2013-10-02 21:00:00 | ES | Futures | 1729.37 | 1732.46 | 1729.37 | 1731.95 | 4287.0 |
| 2013-10-02 21:30:00 | ES | Futures | 1732.2 | 1732.46 | 1731.69 | 1731.95 | 2208.0 |
| 2013-10-02 22:00:00 | ES | Futures | 1732.2 | 1733.49 | 1731.95 | 1732.2 | 2475.0 |
| 2013-10-02 22:30:00 | ES | Futures | 1732.2 | 1733.49 | 1731.69 | 1733.24 | 1967.0 |
| 2013-10-02 23:00:00 | ES | Futures | 1733.24 | 1735.56 | 1733.24 | 1734.53 | 4077.0 |
| 2013-10-02 23:30:00 | ES | Futures | 1734.78 | 1735.56 | 1734.27 | 1734.53 | 1792.0 |
| 2013-10-02 00:00:00 | NQ | Futures | 3766.04 | 3767.49 | 3765.46 | 3766.33 | 123.0 |
| 2013-10-02 00:30:00 | NQ | Futures | 3766.33 | 3766.91 | 3766.04 | 3766.91 | 67.0 |
| 2013-10-02 01:00:00 | NQ | Futures | 3766.91 | 3767.2 | 3764.3 | 3764.88 | 412.0 |
> showing 50 of 2,880 rows — these rows as CSV