PREVIEW / futures_30min / 2013-07-22
file: by_date/futures_30min/2013/2013-07-22.parquet size: 72 KB rows: 2,762
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-22 00:00:00 | ES | Futures | 1748.98 | 1748.98 | 1748.46 | 1748.46 | 598.0 |
| 2013-07-22 00:30:00 | ES | Futures | 1748.72 | 1749.23 | 1748.46 | 1748.46 | 745.0 |
| 2013-07-22 01:00:00 | ES | Futures | 1748.46 | 1748.72 | 1747.94 | 1748.2 | 964.0 |
| 2013-07-22 01:30:00 | ES | Futures | 1748.2 | 1749.23 | 1747.94 | 1748.72 | 1667.0 |
| 2013-07-22 02:00:00 | ES | Futures | 1748.98 | 1749.23 | 1748.2 | 1748.72 | 3017.0 |
| 2013-07-22 02:30:00 | ES | Futures | 1748.46 | 1748.72 | 1747.94 | 1747.94 | 1793.0 |
| 2013-07-22 03:00:00 | ES | Futures | 1747.94 | 1748.72 | 1745.87 | 1746.91 | 14510.0 |
| 2013-07-22 03:30:00 | ES | Futures | 1746.91 | 1747.17 | 1745.62 | 1746.13 | 7438.0 |
| 2013-07-22 04:00:00 | ES | Futures | 1746.13 | 1748.2 | 1746.13 | 1747.68 | 7360.0 |
| 2013-07-22 04:30:00 | ES | Futures | 1747.68 | 1750.53 | 1747.68 | 1749.23 | 10181.0 |
| 2013-07-22 05:00:00 | ES | Futures | 1749.49 | 1749.49 | 1748.46 | 1749.23 | 4180.0 |
| 2013-07-22 05:30:00 | ES | Futures | 1749.23 | 1749.49 | 1748.98 | 1749.23 | 2478.0 |
| 2013-07-22 06:00:00 | ES | Futures | 1749.23 | 1749.49 | 1747.68 | 1748.46 | 5657.0 |
| 2013-07-22 06:30:00 | ES | Futures | 1748.46 | 1748.98 | 1746.91 | 1747.68 | 5406.0 |
| 2013-07-22 07:00:00 | ES | Futures | 1747.94 | 1748.46 | 1747.17 | 1748.46 | 4402.0 |
| 2013-07-22 07:30:00 | ES | Futures | 1748.46 | 1749.49 | 1747.68 | 1748.2 | 11029.0 |
| 2013-07-22 08:00:00 | ES | Futures | 1748.2 | 1748.2 | 1746.13 | 1747.42 | 13208.0 |
| 2013-07-22 08:30:00 | ES | Futures | 1747.17 | 1747.94 | 1746.13 | 1746.91 | 15803.0 |
| 2013-07-22 09:00:00 | ES | Futures | 1746.65 | 1747.17 | 1744.84 | 1747.17 | 23874.0 |
| 2013-07-22 09:30:00 | ES | Futures | 1746.91 | 1747.94 | 1743.29 | 1743.81 | 124385.0 |
| 2013-07-22 10:00:00 | ES | Futures | 1743.81 | 1746.65 | 1742.77 | 1745.36 | 94888.0 |
| 2013-07-22 10:30:00 | ES | Futures | 1745.62 | 1747.42 | 1744.32 | 1746.65 | 68483.0 |
| 2013-07-22 11:00:00 | ES | Futures | 1746.39 | 1749.75 | 1746.39 | 1749.23 | 61791.0 |
| 2013-07-22 11:30:00 | ES | Futures | 1749.49 | 1750.53 | 1747.68 | 1747.94 | 59257.0 |
| 2013-07-22 12:00:00 | ES | Futures | 1747.68 | 1748.72 | 1747.42 | 1748.46 | 24891.0 |
| 2013-07-22 12:30:00 | ES | Futures | 1748.46 | 1749.49 | 1747.42 | 1748.2 | 21192.0 |
| 2013-07-22 13:00:00 | ES | Futures | 1748.2 | 1748.98 | 1746.65 | 1746.91 | 27917.0 |
| 2013-07-22 13:30:00 | ES | Futures | 1747.17 | 1747.17 | 1745.36 | 1746.39 | 30743.0 |
| 2013-07-22 14:00:00 | ES | Futures | 1746.65 | 1747.94 | 1745.87 | 1747.17 | 28205.0 |
| 2013-07-22 14:30:00 | ES | Futures | 1747.17 | 1749.23 | 1746.91 | 1748.98 | 32430.0 |
| 2013-07-22 15:00:00 | ES | Futures | 1748.98 | 1749.23 | 1747.68 | 1748.2 | 23315.0 |
| 2013-07-22 15:30:00 | ES | Futures | 1748.2 | 1748.46 | 1745.62 | 1747.94 | 76529.0 |
| 2013-07-22 16:00:00 | ES | Futures | 1748.2 | 1748.72 | 1747.68 | 1747.94 | 45324.0 |
| 2013-07-22 16:30:00 | ES | Futures | 1747.68 | 1748.2 | 1747.68 | 1748.2 | 2607.0 |
| 2013-07-22 17:00:00 | ES | Futures | 1747.94 | 1748.46 | 1747.68 | 1747.94 | 1333.0 |
| 2013-07-22 18:00:00 | ES | Futures | 1747.94 | 1749.23 | 1747.68 | 1748.98 | 2616.0 |
| 2013-07-22 18:30:00 | ES | Futures | 1748.98 | 1750.01 | 1748.98 | 1749.23 | 1783.0 |
| 2013-07-22 19:00:00 | ES | Futures | 1749.23 | 1749.75 | 1748.98 | 1749.23 | 552.0 |
| 2013-07-22 19:30:00 | ES | Futures | 1749.23 | 1749.23 | 1748.72 | 1749.23 | 936.0 |
| 2013-07-22 20:00:00 | ES | Futures | 1749.23 | 1749.49 | 1748.46 | 1748.72 | 1806.0 |
| 2013-07-22 20:30:00 | ES | Futures | 1748.98 | 1750.01 | 1748.98 | 1749.49 | 2212.0 |
| 2013-07-22 21:00:00 | ES | Futures | 1749.23 | 1749.49 | 1748.98 | 1749.23 | 1300.0 |
| 2013-07-22 21:30:00 | ES | Futures | 1749.49 | 1751.3 | 1749.49 | 1751.04 | 2863.0 |
| 2013-07-22 22:00:00 | ES | Futures | 1750.79 | 1751.3 | 1750.27 | 1751.04 | 1899.0 |
| 2013-07-22 22:30:00 | ES | Futures | 1751.3 | 1751.82 | 1751.04 | 1751.56 | 3399.0 |
| 2013-07-22 23:00:00 | ES | Futures | 1751.56 | 1752.34 | 1751.3 | 1751.82 | 3010.0 |
| 2013-07-22 23:30:00 | ES | Futures | 1752.08 | 1752.59 | 1751.56 | 1752.34 | 3195.0 |
| 2013-07-22 00:00:00 | NQ | Futures | 3563.23 | 3563.52 | 3562.36 | 3562.65 | 110.0 |
| 2013-07-22 00:30:00 | NQ | Futures | 3562.94 | 3564.11 | 3562.65 | 3562.65 | 94.0 |
| 2013-07-22 01:00:00 | NQ | Futures | 3562.65 | 3563.23 | 3561.77 | 3562.36 | 108.0 |
> showing 50 of 2,762 rows — these rows as CSV