PREVIEW / futures_30min / 2013-07-30
file: by_date/futures_30min/2013/2013-07-30.parquet size: 73 KB rows: 2,817
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-30 00:00:00 | ES | Futures | 1742.26 | 1742.26 | 1741.74 | 1742.26 | 614.0 |
| 2013-07-30 00:30:00 | ES | Futures | 1742.0 | 1742.26 | 1741.74 | 1741.74 | 392.0 |
| 2013-07-30 01:00:00 | ES | Futures | 1741.74 | 1742.26 | 1741.74 | 1742.0 | 860.0 |
| 2013-07-30 01:30:00 | ES | Futures | 1742.0 | 1742.51 | 1741.48 | 1741.74 | 1390.0 |
| 2013-07-30 02:00:00 | ES | Futures | 1741.74 | 1742.51 | 1741.48 | 1742.26 | 2365.0 |
| 2013-07-30 02:30:00 | ES | Futures | 1742.26 | 1743.03 | 1742.0 | 1742.0 | 2707.0 |
| 2013-07-30 03:00:00 | ES | Futures | 1742.26 | 1742.51 | 1740.7 | 1741.74 | 8174.0 |
| 2013-07-30 03:30:00 | ES | Futures | 1741.48 | 1743.55 | 1741.48 | 1743.03 | 6159.0 |
| 2013-07-30 04:00:00 | ES | Futures | 1743.03 | 1744.32 | 1743.03 | 1743.55 | 10194.0 |
| 2013-07-30 04:30:00 | ES | Futures | 1743.29 | 1743.81 | 1739.67 | 1740.96 | 12076.0 |
| 2013-07-30 05:00:00 | ES | Futures | 1741.22 | 1742.0 | 1740.19 | 1741.22 | 6523.0 |
| 2013-07-30 05:30:00 | ES | Futures | 1741.22 | 1741.74 | 1739.41 | 1739.93 | 5370.0 |
| 2013-07-30 06:00:00 | ES | Futures | 1739.67 | 1741.74 | 1739.41 | 1741.22 | 6468.0 |
| 2013-07-30 06:30:00 | ES | Futures | 1741.22 | 1743.81 | 1740.7 | 1743.81 | 11518.0 |
| 2013-07-30 07:00:00 | ES | Futures | 1743.81 | 1744.58 | 1743.55 | 1743.81 | 8155.0 |
| 2013-07-30 07:30:00 | ES | Futures | 1744.06 | 1744.58 | 1742.51 | 1743.81 | 10460.0 |
| 2013-07-30 08:00:00 | ES | Futures | 1743.81 | 1744.06 | 1743.29 | 1743.81 | 6785.0 |
| 2013-07-30 08:30:00 | ES | Futures | 1743.55 | 1745.36 | 1743.55 | 1745.1 | 17566.0 |
| 2013-07-30 09:00:00 | ES | Futures | 1745.1 | 1745.36 | 1743.55 | 1743.81 | 18674.0 |
| 2013-07-30 09:30:00 | ES | Futures | 1743.81 | 1745.87 | 1741.22 | 1742.77 | 136807.0 |
| 2013-07-30 10:00:00 | ES | Futures | 1743.03 | 1744.84 | 1742.26 | 1744.06 | 101068.0 |
| 2013-07-30 10:30:00 | ES | Futures | 1744.06 | 1744.84 | 1740.45 | 1740.96 | 83195.0 |
| 2013-07-30 11:00:00 | ES | Futures | 1740.96 | 1742.77 | 1740.19 | 1742.0 | 74523.0 |
| 2013-07-30 11:30:00 | ES | Futures | 1742.0 | 1743.55 | 1741.74 | 1742.51 | 62601.0 |
| 2013-07-30 12:00:00 | ES | Futures | 1742.51 | 1742.51 | 1739.67 | 1740.7 | 58217.0 |
| 2013-07-30 12:30:00 | ES | Futures | 1740.7 | 1742.0 | 1739.93 | 1741.22 | 47042.0 |
| 2013-07-30 13:00:00 | ES | Futures | 1741.22 | 1741.22 | 1735.79 | 1736.57 | 83958.0 |
| 2013-07-30 13:30:00 | ES | Futures | 1736.31 | 1736.83 | 1734.24 | 1736.31 | 100569.0 |
| 2013-07-30 14:00:00 | ES | Futures | 1736.05 | 1737.34 | 1735.02 | 1737.09 | 55956.0 |
| 2013-07-30 14:30:00 | ES | Futures | 1736.83 | 1738.64 | 1736.83 | 1737.34 | 67228.0 |
| 2013-07-30 15:00:00 | ES | Futures | 1737.34 | 1740.7 | 1736.57 | 1740.7 | 82060.0 |
| 2013-07-30 15:30:00 | ES | Futures | 1740.7 | 1741.74 | 1738.38 | 1738.38 | 135185.0 |
| 2013-07-30 16:00:00 | ES | Futures | 1738.38 | 1742.26 | 1738.12 | 1742.26 | 61927.0 |
| 2013-07-30 16:30:00 | ES | Futures | 1741.74 | 1742.0 | 1741.22 | 1741.74 | 6066.0 |
| 2013-07-30 17:00:00 | ES | Futures | 1741.74 | 1741.74 | 1741.22 | 1741.48 | 2192.0 |
| 2013-07-30 18:00:00 | ES | Futures | 1741.22 | 1742.0 | 1740.7 | 1741.74 | 2631.0 |
| 2013-07-30 18:30:00 | ES | Futures | 1741.48 | 1742.0 | 1741.22 | 1741.74 | 1005.0 |
| 2013-07-30 19:00:00 | ES | Futures | 1741.74 | 1741.74 | 1741.48 | 1741.74 | 823.0 |
| 2013-07-30 19:30:00 | ES | Futures | 1741.74 | 1742.0 | 1741.22 | 1741.48 | 496.0 |
| 2013-07-30 20:00:00 | ES | Futures | 1741.48 | 1741.48 | 1740.19 | 1740.45 | 2377.0 |
| 2013-07-30 20:30:00 | ES | Futures | 1740.7 | 1741.48 | 1740.7 | 1740.96 | 670.0 |
| 2013-07-30 21:00:00 | ES | Futures | 1741.22 | 1742.0 | 1740.7 | 1741.74 | 1373.0 |
| 2013-07-30 21:30:00 | ES | Futures | 1741.74 | 1743.81 | 1741.74 | 1743.81 | 2372.0 |
| 2013-07-30 22:00:00 | ES | Futures | 1743.81 | 1744.06 | 1743.03 | 1743.55 | 1505.0 |
| 2013-07-30 22:30:00 | ES | Futures | 1743.55 | 1743.81 | 1743.55 | 1743.81 | 420.0 |
| 2013-07-30 23:00:00 | ES | Futures | 1743.55 | 1744.06 | 1743.29 | 1743.81 | 689.0 |
| 2013-07-30 23:30:00 | ES | Futures | 1743.81 | 1744.32 | 1743.29 | 1743.55 | 1496.0 |
| 2013-07-30 00:00:00 | NQ | Futures | 3590.99 | 3591.29 | 3590.12 | 3590.7 | 94.0 |
| 2013-07-30 00:30:00 | NQ | Futures | 3590.99 | 3592.46 | 3590.7 | 3591.29 | 242.0 |
| 2013-07-30 01:00:00 | NQ | Futures | 3591.58 | 3591.87 | 3590.41 | 3591.58 | 139.0 |
> showing 50 of 2,817 rows — these rows as CSV