PREVIEW / futures_30min / 2013-11-11
file: by_date/futures_30min/2013/2013-11-11.parquet size: 70 KB rows: 2,775
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-11 00:00:00 | ES | Futures | 1819.91 | 1820.17 | 1819.39 | 1819.39 | 1678.0 |
| 2013-11-11 00:30:00 | ES | Futures | 1819.65 | 1821.72 | 1819.39 | 1821.72 | 2604.0 |
| 2013-11-11 01:00:00 | ES | Futures | 1821.72 | 1821.97 | 1821.2 | 1821.72 | 1125.0 |
| 2013-11-11 01:30:00 | ES | Futures | 1821.72 | 1821.72 | 1820.94 | 1820.94 | 934.0 |
| 2013-11-11 02:00:00 | ES | Futures | 1821.2 | 1822.75 | 1820.94 | 1822.75 | 3380.0 |
| 2013-11-11 02:30:00 | ES | Futures | 1822.75 | 1823.01 | 1821.2 | 1821.72 | 3659.0 |
| 2013-11-11 03:00:00 | ES | Futures | 1821.46 | 1821.46 | 1819.65 | 1820.17 | 10008.0 |
| 2013-11-11 03:30:00 | ES | Futures | 1820.17 | 1820.68 | 1819.39 | 1820.43 | 5517.0 |
| 2013-11-11 04:00:00 | ES | Futures | 1820.17 | 1822.23 | 1820.17 | 1821.72 | 6672.0 |
| 2013-11-11 04:30:00 | ES | Futures | 1821.97 | 1822.23 | 1821.46 | 1821.97 | 4479.0 |
| 2013-11-11 05:00:00 | ES | Futures | 1821.72 | 1824.3 | 1821.72 | 1824.3 | 6414.0 |
| 2013-11-11 05:30:00 | ES | Futures | 1824.3 | 1824.81 | 1823.26 | 1823.78 | 5093.0 |
| 2013-11-11 06:00:00 | ES | Futures | 1823.78 | 1824.3 | 1823.26 | 1823.78 | 2950.0 |
| 2013-11-11 06:30:00 | ES | Futures | 1823.78 | 1823.78 | 1822.23 | 1822.75 | 6051.0 |
| 2013-11-11 07:00:00 | ES | Futures | 1822.75 | 1823.78 | 1822.23 | 1823.26 | 9697.0 |
| 2013-11-11 07:30:00 | ES | Futures | 1823.01 | 1825.07 | 1823.01 | 1824.81 | 10193.0 |
| 2013-11-11 08:00:00 | ES | Futures | 1824.55 | 1824.81 | 1823.52 | 1824.04 | 10400.0 |
| 2013-11-11 08:30:00 | ES | Futures | 1823.78 | 1824.3 | 1822.49 | 1823.01 | 11917.0 |
| 2013-11-11 09:00:00 | ES | Futures | 1823.01 | 1823.78 | 1821.97 | 1822.75 | 18079.0 |
| 2013-11-11 09:30:00 | ES | Futures | 1822.49 | 1826.62 | 1820.17 | 1825.33 | 176395.0 |
| 2013-11-11 10:00:00 | ES | Futures | 1825.59 | 1826.36 | 1823.26 | 1823.78 | 86171.0 |
| 2013-11-11 10:30:00 | ES | Futures | 1823.52 | 1825.59 | 1822.23 | 1825.33 | 80919.0 |
| 2013-11-11 11:00:00 | ES | Futures | 1825.33 | 1825.59 | 1822.23 | 1824.04 | 66117.0 |
| 2013-11-11 11:30:00 | ES | Futures | 1824.04 | 1825.07 | 1823.01 | 1824.3 | 47518.0 |
| 2013-11-11 12:00:00 | ES | Futures | 1824.3 | 1824.3 | 1823.26 | 1823.78 | 31319.0 |
| 2013-11-11 12:30:00 | ES | Futures | 1824.04 | 1824.3 | 1822.75 | 1824.04 | 38016.0 |
| 2013-11-11 13:00:00 | ES | Futures | 1823.78 | 1825.07 | 1823.26 | 1824.04 | 39070.0 |
| 2013-11-11 13:30:00 | ES | Futures | 1824.04 | 1824.81 | 1823.52 | 1824.3 | 20250.0 |
| 2013-11-11 14:00:00 | ES | Futures | 1824.3 | 1824.3 | 1823.52 | 1824.04 | 31604.0 |
| 2013-11-11 14:30:00 | ES | Futures | 1823.78 | 1824.55 | 1823.52 | 1824.3 | 34661.0 |
| 2013-11-11 15:00:00 | ES | Futures | 1824.3 | 1824.81 | 1823.78 | 1824.55 | 26689.0 |
| 2013-11-11 15:30:00 | ES | Futures | 1824.55 | 1824.81 | 1823.52 | 1824.3 | 77079.0 |
| 2013-11-11 16:00:00 | ES | Futures | 1824.04 | 1824.55 | 1823.52 | 1823.78 | 37931.0 |
| 2013-11-11 16:30:00 | ES | Futures | 1823.78 | 1824.3 | 1823.52 | 1823.78 | 3346.0 |
| 2013-11-11 17:00:00 | ES | Futures | 1824.04 | 1824.3 | 1823.78 | 1824.04 | 1173.0 |
| 2013-11-11 18:00:00 | ES | Futures | 1824.04 | 1824.55 | 1823.52 | 1824.3 | 1523.0 |
| 2013-11-11 18:30:00 | ES | Futures | 1824.3 | 1824.3 | 1823.52 | 1824.04 | 1183.0 |
| 2013-11-11 19:00:00 | ES | Futures | 1824.04 | 1824.3 | 1823.78 | 1824.04 | 2508.0 |
| 2013-11-11 19:30:00 | ES | Futures | 1824.3 | 1825.33 | 1824.3 | 1825.07 | 6050.0 |
| 2013-11-11 20:00:00 | ES | Futures | 1825.07 | 1825.33 | 1824.81 | 1825.33 | 7467.0 |
| 2013-11-11 20:30:00 | ES | Futures | 1825.07 | 1825.07 | 1823.78 | 1824.55 | 8759.0 |
| 2013-11-11 21:00:00 | ES | Futures | 1824.55 | 1824.81 | 1824.3 | 1824.55 | 1737.0 |
| 2013-11-11 21:30:00 | ES | Futures | 1824.55 | 1824.81 | 1823.52 | 1824.04 | 1724.0 |
| 2013-11-11 22:00:00 | ES | Futures | 1824.04 | 1824.55 | 1823.78 | 1824.3 | 1401.0 |
| 2013-11-11 22:30:00 | ES | Futures | 1824.04 | 1824.81 | 1823.78 | 1824.3 | 2241.0 |
| 2013-11-11 23:00:00 | ES | Futures | 1824.04 | 1824.55 | 1823.78 | 1824.55 | 634.0 |
| 2013-11-11 23:30:00 | ES | Futures | 1824.3 | 1825.07 | 1824.04 | 1825.07 | 2199.0 |
| 2013-11-11 00:00:00 | NQ | Futures | 3897.31 | 3897.89 | 3896.73 | 3897.02 | 246.0 |
| 2013-11-11 00:30:00 | NQ | Futures | 3897.02 | 3901.09 | 3897.02 | 3900.22 | 370.0 |
| 2013-11-11 01:00:00 | NQ | Futures | 3900.22 | 3900.8 | 3899.35 | 3900.51 | 111.0 |
> showing 50 of 2,775 rows — these rows as CSV