PREVIEW / futures_30min / 2013-09-12
file: by_date/futures_30min/2013/2013-09-12.parquet size: 72 KB rows: 2,755
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-09-12 00:00:00 | ES | Futures | 1745.87 | 1746.13 | 1745.1 | 1745.36 | 756.0 |
| 2013-09-12 00:30:00 | ES | Futures | 1745.1 | 1745.36 | 1744.84 | 1745.1 | 891.0 |
| 2013-09-12 01:00:00 | ES | Futures | 1744.84 | 1745.62 | 1744.84 | 1745.36 | 1047.0 |
| 2013-09-12 01:30:00 | ES | Futures | 1745.62 | 1746.13 | 1745.36 | 1745.62 | 3217.0 |
| 2013-09-12 02:00:00 | ES | Futures | 1745.87 | 1745.87 | 1744.58 | 1745.1 | 2761.0 |
| 2013-09-12 02:30:00 | ES | Futures | 1745.1 | 1745.1 | 1744.06 | 1744.32 | 3043.0 |
| 2013-09-12 03:00:00 | ES | Futures | 1744.58 | 1745.36 | 1744.06 | 1744.84 | 6645.0 |
| 2013-09-12 03:30:00 | ES | Futures | 1744.84 | 1745.62 | 1744.32 | 1744.84 | 7288.0 |
| 2013-09-12 04:00:00 | ES | Futures | 1745.1 | 1745.62 | 1743.81 | 1744.32 | 9473.0 |
| 2013-09-12 04:30:00 | ES | Futures | 1744.06 | 1744.58 | 1743.81 | 1744.06 | 5154.0 |
| 2013-09-12 05:00:00 | ES | Futures | 1744.32 | 1744.32 | 1742.51 | 1742.77 | 8745.0 |
| 2013-09-12 05:30:00 | ES | Futures | 1742.77 | 1744.32 | 1742.51 | 1743.29 | 7302.0 |
| 2013-09-12 06:00:00 | ES | Futures | 1743.55 | 1744.32 | 1742.51 | 1744.06 | 5858.0 |
| 2013-09-12 06:30:00 | ES | Futures | 1744.32 | 1745.1 | 1743.81 | 1744.84 | 7481.0 |
| 2013-09-12 07:00:00 | ES | Futures | 1744.84 | 1745.1 | 1744.06 | 1744.58 | 7632.0 |
| 2013-09-12 07:30:00 | ES | Futures | 1744.32 | 1746.91 | 1744.32 | 1746.65 | 16640.0 |
| 2013-09-12 08:00:00 | ES | Futures | 1746.65 | 1746.91 | 1744.58 | 1744.84 | 13413.0 |
| 2013-09-12 08:30:00 | ES | Futures | 1745.1 | 1746.39 | 1744.32 | 1746.13 | 17386.0 |
| 2013-09-12 09:00:00 | ES | Futures | 1745.87 | 1746.13 | 1744.32 | 1745.36 | 15337.0 |
| 2013-09-12 09:30:00 | ES | Futures | 1745.36 | 1746.39 | 1742.26 | 1745.36 | 148145.0 |
| 2013-09-12 10:00:00 | ES | Futures | 1745.36 | 1746.65 | 1744.32 | 1746.65 | 56395.0 |
| 2013-09-12 10:30:00 | ES | Futures | 1746.65 | 1747.42 | 1745.1 | 1745.1 | 51396.0 |
| 2013-09-12 11:00:00 | ES | Futures | 1745.1 | 1746.13 | 1742.51 | 1744.06 | 66393.0 |
| 2013-09-12 11:30:00 | ES | Futures | 1744.06 | 1744.84 | 1741.48 | 1742.51 | 67010.0 |
| 2013-09-12 12:00:00 | ES | Futures | 1742.51 | 1742.77 | 1738.89 | 1739.93 | 71114.0 |
| 2013-09-12 12:30:00 | ES | Futures | 1740.19 | 1741.74 | 1739.93 | 1741.48 | 34296.0 |
| 2013-09-12 13:00:00 | ES | Futures | 1741.74 | 1744.84 | 1741.22 | 1744.06 | 35030.0 |
| 2013-09-12 13:30:00 | ES | Futures | 1743.81 | 1744.58 | 1742.77 | 1743.03 | 25686.0 |
| 2013-09-12 14:00:00 | ES | Futures | 1743.03 | 1744.06 | 1742.26 | 1743.03 | 35329.0 |
| 2013-09-12 14:30:00 | ES | Futures | 1743.03 | 1744.06 | 1740.96 | 1744.06 | 40206.0 |
| 2013-09-12 15:00:00 | ES | Futures | 1744.06 | 1744.06 | 1739.67 | 1741.48 | 69623.0 |
| 2013-09-12 15:30:00 | ES | Futures | 1741.48 | 1741.48 | 1738.38 | 1740.96 | 90501.0 |
| 2013-09-12 16:00:00 | ES | Futures | 1740.96 | 1742.26 | 1740.7 | 1742.0 | 61026.0 |
| 2013-09-12 16:30:00 | ES | Futures | 1742.26 | 1743.03 | 1742.26 | 1742.51 | 3672.0 |
| 2013-09-12 17:00:00 | ES | Futures | 1742.77 | 1743.03 | 1742.0 | 1742.77 | 2284.0 |
| 2013-09-12 18:00:00 | ES | Futures | 1742.0 | 1743.03 | 1742.0 | 1743.03 | 1952.0 |
| 2013-09-12 18:30:00 | ES | Futures | 1743.03 | 1743.03 | 1742.77 | 1743.03 | 61.0 |
| 2013-09-12 19:00:00 | ES | Futures | 1743.03 | 1743.03 | 1742.51 | 1742.77 | 235.0 |
| 2013-09-12 19:30:00 | ES | Futures | 1742.77 | 1743.03 | 1742.26 | 1742.77 | 375.0 |
| 2013-09-12 20:00:00 | ES | Futures | 1743.03 | 1744.58 | 1742.77 | 1743.81 | 2060.0 |
| 2013-09-12 20:30:00 | ES | Futures | 1743.81 | 1744.58 | 1743.81 | 1744.06 | 1516.0 |
| 2013-09-12 21:00:00 | ES | Futures | 1744.06 | 1744.32 | 1743.03 | 1743.29 | 1343.0 |
| 2013-09-12 21:30:00 | ES | Futures | 1743.55 | 1743.81 | 1743.03 | 1743.29 | 597.0 |
| 2013-09-12 22:00:00 | ES | Futures | 1743.55 | 1743.55 | 1742.26 | 1742.51 | 866.0 |
| 2013-09-12 22:30:00 | ES | Futures | 1742.51 | 1742.77 | 1742.0 | 1742.77 | 553.0 |
| 2013-09-12 23:00:00 | ES | Futures | 1742.51 | 1743.29 | 1742.26 | 1742.26 | 606.0 |
| 2013-09-12 23:30:00 | ES | Futures | 1742.51 | 1743.03 | 1741.74 | 1743.03 | 807.0 |
| 2013-09-12 00:00:00 | NQ | Futures | 3717.82 | 3718.41 | 3716.66 | 3717.24 | 83.0 |
| 2013-09-12 00:30:00 | NQ | Futures | 3716.95 | 3716.95 | 3716.07 | 3716.36 | 126.0 |
| 2013-09-12 01:00:00 | NQ | Futures | 3716.36 | 3718.41 | 3716.36 | 3717.82 | 99.0 |
> showing 50 of 2,755 rows — these rows as CSV