PREVIEW / futures_30min / 2013-10-01
file: by_date/futures_30min/2013/2013-10-01.parquet size: 78 KB rows: 2,879
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-01 00:00:00 | ES | Futures | 1729.88 | 1733.24 | 1729.37 | 1732.2 | 5669.0 |
| 2013-10-01 00:30:00 | ES | Futures | 1732.2 | 1733.24 | 1731.17 | 1731.69 | 1869.0 |
| 2013-10-01 01:00:00 | ES | Futures | 1731.69 | 1733.24 | 1731.69 | 1731.69 | 2605.0 |
| 2013-10-01 01:30:00 | ES | Futures | 1731.69 | 1732.72 | 1730.91 | 1731.69 | 2457.0 |
| 2013-10-01 02:00:00 | ES | Futures | 1731.43 | 1732.46 | 1731.17 | 1731.43 | 3055.0 |
| 2013-10-01 02:30:00 | ES | Futures | 1731.17 | 1732.98 | 1731.17 | 1732.46 | 3231.0 |
| 2013-10-01 03:00:00 | ES | Futures | 1732.46 | 1735.04 | 1732.2 | 1734.27 | 13463.0 |
| 2013-10-01 03:30:00 | ES | Futures | 1734.27 | 1737.11 | 1733.49 | 1736.85 | 16651.0 |
| 2013-10-01 04:00:00 | ES | Futures | 1737.11 | 1737.88 | 1735.56 | 1735.82 | 9533.0 |
| 2013-10-01 04:30:00 | ES | Futures | 1736.07 | 1736.59 | 1735.3 | 1736.07 | 7922.0 |
| 2013-10-01 05:00:00 | ES | Futures | 1736.07 | 1736.85 | 1732.98 | 1735.04 | 15087.0 |
| 2013-10-01 05:30:00 | ES | Futures | 1735.04 | 1736.33 | 1735.04 | 1735.04 | 5720.0 |
| 2013-10-01 06:00:00 | ES | Futures | 1735.04 | 1736.33 | 1734.78 | 1735.82 | 3595.0 |
| 2013-10-01 06:30:00 | ES | Futures | 1735.56 | 1736.07 | 1734.78 | 1734.78 | 5566.0 |
| 2013-10-01 07:00:00 | ES | Futures | 1735.04 | 1735.3 | 1731.69 | 1732.2 | 19310.0 |
| 2013-10-01 07:30:00 | ES | Futures | 1732.2 | 1733.24 | 1731.17 | 1732.98 | 18478.0 |
| 2013-10-01 08:00:00 | ES | Futures | 1732.72 | 1733.24 | 1729.62 | 1732.72 | 23455.0 |
| 2013-10-01 08:30:00 | ES | Futures | 1732.72 | 1734.27 | 1730.14 | 1732.72 | 27842.0 |
| 2013-10-01 09:00:00 | ES | Futures | 1732.72 | 1732.72 | 1729.37 | 1729.88 | 30705.0 |
| 2013-10-01 09:30:00 | ES | Futures | 1729.88 | 1736.07 | 1728.59 | 1731.69 | 226436.0 |
| 2013-10-01 10:00:00 | ES | Futures | 1731.43 | 1738.65 | 1730.91 | 1737.11 | 201025.0 |
| 2013-10-01 10:30:00 | ES | Futures | 1736.85 | 1742.01 | 1736.85 | 1740.97 | 162223.0 |
| 2013-10-01 11:00:00 | ES | Futures | 1740.97 | 1741.49 | 1739.17 | 1739.69 | 84304.0 |
| 2013-10-01 11:30:00 | ES | Futures | 1739.94 | 1743.3 | 1739.69 | 1742.01 | 78956.0 |
| 2013-10-01 12:00:00 | ES | Futures | 1742.01 | 1744.33 | 1740.97 | 1743.04 | 66634.0 |
| 2013-10-01 12:30:00 | ES | Futures | 1743.3 | 1743.3 | 1740.72 | 1741.49 | 42165.0 |
| 2013-10-01 13:00:00 | ES | Futures | 1741.23 | 1742.52 | 1740.72 | 1741.49 | 39303.0 |
| 2013-10-01 13:30:00 | ES | Futures | 1741.23 | 1742.01 | 1739.69 | 1740.97 | 48225.0 |
| 2013-10-01 14:00:00 | ES | Futures | 1740.97 | 1740.97 | 1736.33 | 1737.11 | 61345.0 |
| 2013-10-01 14:30:00 | ES | Futures | 1736.85 | 1739.43 | 1736.33 | 1738.4 | 62035.0 |
| 2013-10-01 15:00:00 | ES | Futures | 1738.65 | 1738.65 | 1735.82 | 1736.85 | 76033.0 |
| 2013-10-01 15:30:00 | ES | Futures | 1737.11 | 1743.04 | 1736.85 | 1742.01 | 165809.0 |
| 2013-10-01 16:00:00 | ES | Futures | 1742.26 | 1746.13 | 1742.01 | 1743.04 | 154033.0 |
| 2013-10-01 16:30:00 | ES | Futures | 1743.3 | 1745.1 | 1743.3 | 1744.59 | 11053.0 |
| 2013-10-01 17:00:00 | ES | Futures | 1744.84 | 1745.88 | 1744.59 | 1745.62 | 3128.0 |
| 2013-10-01 18:00:00 | ES | Futures | 1745.36 | 1745.62 | 1744.33 | 1745.36 | 4503.0 |
| 2013-10-01 18:30:00 | ES | Futures | 1745.36 | 1745.62 | 1744.59 | 1744.84 | 3159.0 |
| 2013-10-01 19:00:00 | ES | Futures | 1744.84 | 1744.84 | 1743.04 | 1743.55 | 3514.0 |
| 2013-10-01 19:30:00 | ES | Futures | 1743.55 | 1743.55 | 1742.78 | 1743.04 | 1644.0 |
| 2013-10-01 20:00:00 | ES | Futures | 1743.04 | 1743.55 | 1742.78 | 1743.3 | 3009.0 |
| 2013-10-01 20:30:00 | ES | Futures | 1743.3 | 1743.3 | 1742.52 | 1742.78 | 2090.0 |
| 2013-10-01 21:00:00 | ES | Futures | 1743.04 | 1743.04 | 1742.01 | 1742.26 | 3323.0 |
| 2013-10-01 21:30:00 | ES | Futures | 1742.26 | 1742.26 | 1741.49 | 1741.75 | 3650.0 |
| 2013-10-01 22:00:00 | ES | Futures | 1741.75 | 1742.01 | 1740.97 | 1741.75 | 3315.0 |
| 2013-10-01 22:30:00 | ES | Futures | 1741.75 | 1742.26 | 1740.72 | 1742.01 | 2560.0 |
| 2013-10-01 23:00:00 | ES | Futures | 1742.26 | 1742.26 | 1741.49 | 1741.75 | 2116.0 |
| 2013-10-01 23:30:00 | ES | Futures | 1741.75 | 1742.26 | 1740.46 | 1740.46 | 2602.0 |
| 2013-10-01 00:00:00 | NQ | Futures | 3734.96 | 3742.51 | 3734.67 | 3739.9 | 623.0 |
| 2013-10-01 00:30:00 | NQ | Futures | 3740.19 | 3741.93 | 3736.7 | 3739.03 | 257.0 |
| 2013-10-01 01:00:00 | NQ | Futures | 3739.61 | 3742.8 | 3739.61 | 3739.9 | 361.0 |
> showing 50 of 2,879 rows — these rows as CSV