PREVIEW / futures_30min / 2013-11-15
file: by_date/futures_30min/2013/2013-11-15.parquet size: 62 KB rows: 2,311
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-11-15 00:00:00 | ES | Futures | 1847.0 | 1847.25 | 1846.74 | 1847.0 | 1079.0 |
| 2013-11-15 00:30:00 | ES | Futures | 1847.0 | 1847.77 | 1846.48 | 1846.48 | 2058.0 |
| 2013-11-15 01:00:00 | ES | Futures | 1846.48 | 1846.74 | 1845.71 | 1846.22 | 2824.0 |
| 2013-11-15 01:30:00 | ES | Futures | 1845.96 | 1847.0 | 1845.96 | 1846.22 | 1124.0 |
| 2013-11-15 02:00:00 | ES | Futures | 1846.22 | 1846.48 | 1845.45 | 1845.96 | 2406.0 |
| 2013-11-15 02:30:00 | ES | Futures | 1845.96 | 1846.74 | 1845.71 | 1846.22 | 2961.0 |
| 2013-11-15 03:00:00 | ES | Futures | 1846.22 | 1847.0 | 1845.45 | 1845.96 | 14427.0 |
| 2013-11-15 03:30:00 | ES | Futures | 1845.71 | 1846.74 | 1844.67 | 1846.22 | 8820.0 |
| 2013-11-15 04:00:00 | ES | Futures | 1846.22 | 1847.0 | 1845.96 | 1846.74 | 5859.0 |
| 2013-11-15 04:30:00 | ES | Futures | 1846.74 | 1847.0 | 1845.96 | 1846.22 | 5535.0 |
| 2013-11-15 05:00:00 | ES | Futures | 1846.48 | 1847.25 | 1846.22 | 1847.0 | 5497.0 |
| 2013-11-15 05:30:00 | ES | Futures | 1847.0 | 1848.8 | 1846.74 | 1848.03 | 13680.0 |
| 2013-11-15 06:00:00 | ES | Futures | 1848.03 | 1849.32 | 1847.77 | 1848.54 | 12968.0 |
| 2013-11-15 06:30:00 | ES | Futures | 1848.54 | 1849.58 | 1848.29 | 1848.8 | 12396.0 |
| 2013-11-15 07:00:00 | ES | Futures | 1848.8 | 1849.83 | 1847.77 | 1848.03 | 14334.0 |
| 2013-11-15 07:30:00 | ES | Futures | 1848.03 | 1849.32 | 1847.77 | 1849.06 | 14250.0 |
| 2013-11-15 08:00:00 | ES | Futures | 1848.8 | 1849.32 | 1848.03 | 1848.29 | 14824.0 |
| 2013-11-15 08:30:00 | ES | Futures | 1848.03 | 1848.54 | 1847.51 | 1848.29 | 18153.0 |
| 2013-11-15 09:00:00 | ES | Futures | 1848.29 | 1848.8 | 1846.22 | 1847.25 | 28430.0 |
| 2013-11-15 09:30:00 | ES | Futures | 1847.51 | 1847.77 | 1844.93 | 1847.51 | 156927.0 |
| 2013-11-15 10:00:00 | ES | Futures | 1847.51 | 1848.29 | 1845.45 | 1847.51 | 110234.0 |
| 2013-11-15 10:30:00 | ES | Futures | 1847.51 | 1848.54 | 1846.22 | 1847.77 | 69332.0 |
| 2013-11-15 11:00:00 | ES | Futures | 1848.03 | 1849.06 | 1847.51 | 1848.29 | 56706.0 |
| 2013-11-15 11:30:00 | ES | Futures | 1848.29 | 1848.8 | 1844.93 | 1845.96 | 84496.0 |
| 2013-11-15 12:00:00 | ES | Futures | 1845.71 | 1847.25 | 1845.45 | 1846.48 | 51268.0 |
| 2013-11-15 12:30:00 | ES | Futures | 1846.48 | 1847.0 | 1845.19 | 1845.45 | 35424.0 |
| 2013-11-15 13:00:00 | ES | Futures | 1845.45 | 1848.03 | 1845.45 | 1847.77 | 25488.0 |
| 2013-11-15 13:30:00 | ES | Futures | 1847.77 | 1848.8 | 1847.25 | 1847.77 | 40012.0 |
| 2013-11-15 14:00:00 | ES | Futures | 1847.77 | 1849.58 | 1847.51 | 1848.8 | 37369.0 |
| 2013-11-15 14:30:00 | ES | Futures | 1848.8 | 1849.58 | 1848.54 | 1849.32 | 35553.0 |
| 2013-11-15 15:00:00 | ES | Futures | 1849.32 | 1851.9 | 1848.8 | 1851.64 | 76185.0 |
| 2013-11-15 15:30:00 | ES | Futures | 1851.64 | 1852.67 | 1850.35 | 1852.41 | 129135.0 |
| 2013-11-15 16:00:00 | ES | Futures | 1852.67 | 1853.19 | 1850.35 | 1850.35 | 96407.0 |
| 2013-11-15 16:30:00 | ES | Futures | 1850.61 | 1851.38 | 1850.61 | 1850.61 | 7837.0 |
| 2013-11-15 17:00:00 | ES | Futures | 1850.61 | 1851.38 | 1850.35 | 1851.38 | 1545.0 |
| 2013-11-15 00:00:00 | NQ | Futures | 3969.92 | 3970.79 | 3969.63 | 3970.5 | 280.0 |
| 2013-11-15 00:30:00 | NQ | Futures | 3970.21 | 3971.37 | 3969.34 | 3969.34 | 326.0 |
| 2013-11-15 01:00:00 | NQ | Futures | 3969.63 | 3970.21 | 3967.89 | 3968.18 | 251.0 |
| 2013-11-15 01:30:00 | NQ | Futures | 3968.18 | 3969.34 | 3967.89 | 3968.76 | 95.0 |
| 2013-11-15 02:00:00 | NQ | Futures | 3968.47 | 3969.34 | 3967.89 | 3969.34 | 398.0 |
| 2013-11-15 02:30:00 | NQ | Futures | 3969.34 | 3970.79 | 3968.76 | 3969.63 | 290.0 |
| 2013-11-15 03:00:00 | NQ | Futures | 3969.63 | 3971.37 | 3968.18 | 3969.05 | 1757.0 |
| 2013-11-15 03:30:00 | NQ | Futures | 3968.76 | 3971.08 | 3967.02 | 3969.92 | 1053.0 |
| 2013-11-15 04:00:00 | NQ | Futures | 3969.92 | 3971.66 | 3969.63 | 3970.79 | 758.0 |
| 2013-11-15 04:30:00 | NQ | Futures | 3970.79 | 3970.79 | 3968.47 | 3968.76 | 967.0 |
| 2013-11-15 05:00:00 | NQ | Futures | 3969.05 | 3970.5 | 3968.76 | 3969.63 | 577.0 |
| 2013-11-15 05:30:00 | NQ | Futures | 3969.63 | 3972.83 | 3969.63 | 3970.79 | 1360.0 |
| 2013-11-15 06:00:00 | NQ | Futures | 3970.79 | 3973.7 | 3969.63 | 3971.96 | 1412.0 |
| 2013-11-15 06:30:00 | NQ | Futures | 3972.25 | 3974.57 | 3971.37 | 3972.25 | 1242.0 |
| 2013-11-15 07:00:00 | NQ | Futures | 3971.96 | 3973.99 | 3967.02 | 3967.31 | 2340.0 |
> showing 50 of 2,311 rows — these rows as CSV