PREVIEW / futures_30min / 2013-07-15
file: by_date/futures_30min/2013/2013-07-15.parquet size: 73 KB rows: 2,751
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-15 00:00:00 | ES | Futures | 1730.88 | 1730.88 | 1730.36 | 1730.62 | 535.0 |
| 2013-07-15 00:30:00 | ES | Futures | 1730.62 | 1731.4 | 1730.62 | 1731.4 | 566.0 |
| 2013-07-15 01:00:00 | ES | Futures | 1731.14 | 1731.66 | 1730.62 | 1731.14 | 1867.0 |
| 2013-07-15 01:30:00 | ES | Futures | 1731.14 | 1731.14 | 1730.62 | 1731.14 | 603.0 |
| 2013-07-15 02:00:00 | ES | Futures | 1730.88 | 1731.14 | 1730.11 | 1730.36 | 1675.0 |
| 2013-07-15 02:30:00 | ES | Futures | 1730.36 | 1730.36 | 1729.33 | 1729.33 | 1500.0 |
| 2013-07-15 03:00:00 | ES | Futures | 1729.33 | 1731.92 | 1729.07 | 1730.88 | 12683.0 |
| 2013-07-15 03:30:00 | ES | Futures | 1730.88 | 1732.69 | 1730.62 | 1731.4 | 10327.0 |
| 2013-07-15 04:00:00 | ES | Futures | 1731.4 | 1732.17 | 1730.62 | 1730.62 | 5406.0 |
| 2013-07-15 04:30:00 | ES | Futures | 1730.62 | 1731.4 | 1730.36 | 1730.62 | 4654.0 |
| 2013-07-15 05:00:00 | ES | Futures | 1730.36 | 1731.14 | 1730.36 | 1730.62 | 2675.0 |
| 2013-07-15 05:30:00 | ES | Futures | 1730.62 | 1730.88 | 1728.55 | 1728.55 | 8560.0 |
| 2013-07-15 06:00:00 | ES | Futures | 1728.55 | 1729.33 | 1728.55 | 1729.07 | 3253.0 |
| 2013-07-15 06:30:00 | ES | Futures | 1729.07 | 1730.11 | 1728.55 | 1729.33 | 5454.0 |
| 2013-07-15 07:00:00 | ES | Futures | 1729.33 | 1730.36 | 1728.81 | 1729.59 | 7193.0 |
| 2013-07-15 07:30:00 | ES | Futures | 1729.59 | 1730.62 | 1728.81 | 1729.85 | 9485.0 |
| 2013-07-15 08:00:00 | ES | Futures | 1729.85 | 1731.66 | 1729.59 | 1730.88 | 10038.0 |
| 2013-07-15 08:30:00 | ES | Futures | 1730.88 | 1731.92 | 1729.59 | 1730.62 | 22297.0 |
| 2013-07-15 09:00:00 | ES | Futures | 1730.62 | 1732.17 | 1730.11 | 1731.92 | 23192.0 |
| 2013-07-15 09:30:00 | ES | Futures | 1732.17 | 1733.72 | 1729.07 | 1731.14 | 137921.0 |
| 2013-07-15 10:00:00 | ES | Futures | 1731.14 | 1732.95 | 1730.11 | 1731.92 | 76999.0 |
| 2013-07-15 10:30:00 | ES | Futures | 1731.66 | 1732.95 | 1730.62 | 1732.43 | 64941.0 |
| 2013-07-15 11:00:00 | ES | Futures | 1732.69 | 1733.47 | 1731.66 | 1733.47 | 40606.0 |
| 2013-07-15 11:30:00 | ES | Futures | 1733.21 | 1734.76 | 1732.95 | 1734.24 | 60328.0 |
| 2013-07-15 12:00:00 | ES | Futures | 1734.24 | 1735.02 | 1733.47 | 1734.76 | 33326.0 |
| 2013-07-15 12:30:00 | ES | Futures | 1734.5 | 1735.02 | 1733.21 | 1733.47 | 26521.0 |
| 2013-07-15 13:00:00 | ES | Futures | 1733.47 | 1734.24 | 1732.69 | 1733.72 | 25761.0 |
| 2013-07-15 13:30:00 | ES | Futures | 1733.72 | 1734.76 | 1732.95 | 1734.5 | 27252.0 |
| 2013-07-15 14:00:00 | ES | Futures | 1734.24 | 1736.05 | 1734.24 | 1735.79 | 46780.0 |
| 2013-07-15 14:30:00 | ES | Futures | 1735.79 | 1736.57 | 1734.76 | 1735.53 | 43294.0 |
| 2013-07-15 15:00:00 | ES | Futures | 1735.53 | 1736.31 | 1734.5 | 1735.02 | 39208.0 |
| 2013-07-15 15:30:00 | ES | Futures | 1734.76 | 1735.53 | 1733.98 | 1734.24 | 75815.0 |
| 2013-07-15 16:00:00 | ES | Futures | 1734.5 | 1735.28 | 1733.98 | 1734.5 | 52789.0 |
| 2013-07-15 16:30:00 | ES | Futures | 1734.76 | 1735.28 | 1734.5 | 1734.76 | 5331.0 |
| 2013-07-15 17:00:00 | ES | Futures | 1734.5 | 1735.02 | 1734.5 | 1734.5 | 1598.0 |
| 2013-07-15 18:00:00 | ES | Futures | 1734.76 | 1735.53 | 1734.24 | 1734.5 | 2370.0 |
| 2013-07-15 18:30:00 | ES | Futures | 1734.5 | 1734.76 | 1733.98 | 1734.24 | 622.0 |
| 2013-07-15 19:00:00 | ES | Futures | 1734.24 | 1734.76 | 1734.24 | 1734.5 | 300.0 |
| 2013-07-15 19:30:00 | ES | Futures | 1734.5 | 1734.76 | 1733.72 | 1733.98 | 1004.0 |
| 2013-07-15 20:00:00 | ES | Futures | 1733.98 | 1734.5 | 1733.21 | 1733.21 | 2542.0 |
| 2013-07-15 20:30:00 | ES | Futures | 1733.21 | 1734.5 | 1733.21 | 1734.5 | 1189.0 |
| 2013-07-15 21:00:00 | ES | Futures | 1734.24 | 1734.76 | 1733.98 | 1733.98 | 1347.0 |
| 2013-07-15 21:30:00 | ES | Futures | 1733.98 | 1734.5 | 1733.47 | 1734.24 | 1664.0 |
| 2013-07-15 22:00:00 | ES | Futures | 1734.24 | 1734.5 | 1733.21 | 1733.47 | 1116.0 |
| 2013-07-15 22:30:00 | ES | Futures | 1733.21 | 1733.98 | 1733.21 | 1733.47 | 1291.0 |
| 2013-07-15 23:00:00 | ES | Futures | 1733.72 | 1733.72 | 1733.21 | 1733.72 | 696.0 |
| 2013-07-15 23:30:00 | ES | Futures | 1733.98 | 1734.24 | 1733.47 | 1733.72 | 672.0 |
| 2013-07-15 00:00:00 | NQ | Futures | 3590.12 | 3590.7 | 3589.83 | 3590.41 | 97.0 |
| 2013-07-15 00:30:00 | NQ | Futures | 3590.7 | 3591.58 | 3590.12 | 3590.41 | 154.0 |
| 2013-07-15 01:00:00 | NQ | Futures | 3590.41 | 3590.99 | 3589.24 | 3590.7 | 161.0 |
> showing 50 of 2,751 rows — these rows as CSV