PREVIEW / futures_30min / 2013-11-22
file: by_date/futures_30min/2013/2013-11-22.parquet size: 64 KB rows: 2,299
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-22 00:00:00 | ES | Futures | 1849.83 | 1850.09 | 1849.32 | 1849.58 | 2076.0 |
| 2013-11-22 00:30:00 | ES | Futures | 1849.58 | 1849.58 | 1849.06 | 1849.32 | 1060.0 |
| 2013-11-22 01:00:00 | ES | Futures | 1849.06 | 1850.09 | 1849.06 | 1849.83 | 1191.0 |
| 2013-11-22 01:30:00 | ES | Futures | 1849.83 | 1850.61 | 1849.83 | 1850.61 | 1284.0 |
| 2013-11-22 02:00:00 | ES | Futures | 1850.35 | 1851.64 | 1850.09 | 1850.87 | 3171.0 |
| 2013-11-22 02:30:00 | ES | Futures | 1850.87 | 1851.12 | 1850.09 | 1850.61 | 2565.0 |
| 2013-11-22 03:00:00 | ES | Futures | 1850.61 | 1853.19 | 1849.32 | 1852.93 | 17070.0 |
| 2013-11-22 03:30:00 | ES | Futures | 1852.93 | 1852.93 | 1851.12 | 1851.64 | 15617.0 |
| 2013-11-22 04:00:00 | ES | Futures | 1851.38 | 1852.93 | 1850.87 | 1851.64 | 12439.0 |
| 2013-11-22 04:30:00 | ES | Futures | 1851.9 | 1852.67 | 1850.09 | 1850.35 | 11852.0 |
| 2013-11-22 05:00:00 | ES | Futures | 1850.35 | 1851.9 | 1850.09 | 1851.64 | 12986.0 |
| 2013-11-22 05:30:00 | ES | Futures | 1851.9 | 1852.16 | 1849.58 | 1849.58 | 16970.0 |
| 2013-11-22 06:00:00 | ES | Futures | 1849.58 | 1851.12 | 1849.58 | 1850.35 | 13612.0 |
| 2013-11-22 06:30:00 | ES | Futures | 1850.61 | 1851.12 | 1849.58 | 1849.83 | 12063.0 |
| 2013-11-22 07:00:00 | ES | Futures | 1850.09 | 1851.38 | 1849.32 | 1851.12 | 15725.0 |
| 2013-11-22 07:30:00 | ES | Futures | 1851.12 | 1851.64 | 1850.09 | 1850.61 | 11792.0 |
| 2013-11-22 08:00:00 | ES | Futures | 1850.87 | 1853.96 | 1850.35 | 1853.19 | 27110.0 |
| 2013-11-22 08:30:00 | ES | Futures | 1853.45 | 1853.45 | 1851.12 | 1851.64 | 23623.0 |
| 2013-11-22 09:00:00 | ES | Futures | 1851.64 | 1852.93 | 1851.38 | 1851.64 | 16963.0 |
| 2013-11-22 09:30:00 | ES | Futures | 1851.9 | 1852.93 | 1849.58 | 1852.16 | 145600.0 |
| 2013-11-22 10:00:00 | ES | Futures | 1852.16 | 1854.48 | 1850.09 | 1853.19 | 108013.0 |
| 2013-11-22 10:30:00 | ES | Futures | 1853.19 | 1854.48 | 1852.41 | 1853.45 | 67540.0 |
| 2013-11-22 11:00:00 | ES | Futures | 1853.7 | 1854.99 | 1852.93 | 1853.96 | 71419.0 |
| 2013-11-22 11:30:00 | ES | Futures | 1854.22 | 1857.83 | 1853.7 | 1857.32 | 84579.0 |
| 2013-11-22 12:00:00 | ES | Futures | 1857.06 | 1857.83 | 1856.28 | 1856.8 | 37790.0 |
| 2013-11-22 12:30:00 | ES | Futures | 1857.06 | 1857.32 | 1856.54 | 1857.06 | 24310.0 |
| 2013-11-22 13:00:00 | ES | Futures | 1857.32 | 1857.83 | 1856.8 | 1857.06 | 27925.0 |
| 2013-11-22 13:30:00 | ES | Futures | 1857.32 | 1857.32 | 1855.51 | 1855.77 | 33706.0 |
| 2013-11-22 14:00:00 | ES | Futures | 1855.77 | 1858.6 | 1855.77 | 1858.6 | 45249.0 |
| 2013-11-22 14:30:00 | ES | Futures | 1858.6 | 1859.12 | 1857.83 | 1859.12 | 38568.0 |
| 2013-11-22 15:00:00 | ES | Futures | 1859.12 | 1860.41 | 1858.86 | 1859.38 | 66654.0 |
| 2013-11-22 15:30:00 | ES | Futures | 1859.12 | 1860.67 | 1858.86 | 1860.15 | 139240.0 |
| 2013-11-22 16:00:00 | ES | Futures | 1860.15 | 1860.67 | 1858.35 | 1858.6 | 81166.0 |
| 2013-11-22 16:30:00 | ES | Futures | 1858.6 | 1858.86 | 1858.09 | 1858.86 | 8263.0 |
| 2013-11-22 17:00:00 | ES | Futures | 1858.86 | 1858.86 | 1857.83 | 1858.6 | 1526.0 |
| 2013-11-22 00:00:00 | NQ | Futures | 3951.04 | 3951.62 | 3950.46 | 3951.33 | 122.0 |
| 2013-11-22 00:30:00 | NQ | Futures | 3951.04 | 3951.33 | 3950.46 | 3950.46 | 139.0 |
| 2013-11-22 01:00:00 | NQ | Futures | 3950.46 | 3952.21 | 3950.46 | 3951.92 | 110.0 |
| 2013-11-22 01:30:00 | NQ | Futures | 3951.92 | 3953.08 | 3951.62 | 3953.08 | 188.0 |
| 2013-11-22 02:00:00 | NQ | Futures | 3953.08 | 3955.69 | 3952.5 | 3954.82 | 417.0 |
| 2013-11-22 02:30:00 | NQ | Futures | 3954.53 | 3955.11 | 3953.37 | 3955.11 | 497.0 |
| 2013-11-22 03:00:00 | NQ | Futures | 3954.82 | 3959.47 | 3952.5 | 3958.3 | 3202.0 |
| 2013-11-22 03:30:00 | NQ | Futures | 3958.3 | 3959.18 | 3955.4 | 3956.56 | 2876.0 |
| 2013-11-22 04:00:00 | NQ | Futures | 3956.27 | 3958.89 | 3955.11 | 3956.27 | 1526.0 |
| 2013-11-22 04:30:00 | NQ | Futures | 3956.27 | 3958.3 | 3952.5 | 3953.37 | 3135.0 |
| 2013-11-22 05:00:00 | NQ | Futures | 3953.37 | 3956.27 | 3951.33 | 3955.69 | 1901.0 |
| 2013-11-22 05:30:00 | NQ | Futures | 3955.69 | 3957.14 | 3949.88 | 3950.17 | 1296.0 |
| 2013-11-22 06:00:00 | NQ | Futures | 3950.17 | 3954.24 | 3949.88 | 3952.5 | 1404.0 |
| 2013-11-22 06:30:00 | NQ | Futures | 3952.5 | 3953.66 | 3950.46 | 3950.75 | 1536.0 |
| 2013-11-22 07:00:00 | NQ | Futures | 3951.33 | 3954.24 | 3950.46 | 3953.66 | 1791.0 |
> showing 50 of 2,299 rows — these rows as CSV