PREVIEW / futures_30min / 2013-12-23
file: by_date/futures_30min/2013/2013-12-23.parquet size: 67 KB rows: 2,729
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-12-23 00:00:00 | ES | Futures | 1882.74 | 1883.51 | 1882.48 | 1883.0 | 1146.0 |
| 2013-12-23 00:30:00 | ES | Futures | 1883.25 | 1883.77 | 1883.0 | 1883.25 | 551.0 |
| 2013-12-23 01:00:00 | ES | Futures | 1883.25 | 1883.51 | 1883.0 | 1883.25 | 418.0 |
| 2013-12-23 01:30:00 | ES | Futures | 1883.25 | 1883.25 | 1882.48 | 1883.0 | 919.0 |
| 2013-12-23 02:00:00 | ES | Futures | 1883.0 | 1883.77 | 1882.74 | 1883.77 | 1164.0 |
| 2013-12-23 02:30:00 | ES | Futures | 1883.77 | 1884.03 | 1883.51 | 1883.51 | 1307.0 |
| 2013-12-23 03:00:00 | ES | Futures | 1883.51 | 1884.29 | 1883.25 | 1883.77 | 5001.0 |
| 2013-12-23 03:30:00 | ES | Futures | 1883.51 | 1884.81 | 1883.51 | 1884.29 | 3539.0 |
| 2013-12-23 04:00:00 | ES | Futures | 1884.29 | 1884.81 | 1884.03 | 1884.81 | 2139.0 |
| 2013-12-23 04:30:00 | ES | Futures | 1884.55 | 1885.58 | 1884.55 | 1885.32 | 2064.0 |
| 2013-12-23 05:00:00 | ES | Futures | 1885.07 | 1885.84 | 1885.07 | 1885.84 | 2926.0 |
| 2013-12-23 05:30:00 | ES | Futures | 1885.84 | 1885.84 | 1885.07 | 1885.32 | 1964.0 |
| 2013-12-23 06:00:00 | ES | Futures | 1885.32 | 1885.84 | 1885.32 | 1885.58 | 3055.0 |
| 2013-12-23 06:30:00 | ES | Futures | 1885.58 | 1886.1 | 1883.77 | 1884.55 | 4900.0 |
| 2013-12-23 07:00:00 | ES | Futures | 1884.55 | 1885.32 | 1884.29 | 1884.55 | 2535.0 |
| 2013-12-23 07:30:00 | ES | Futures | 1884.29 | 1885.84 | 1884.29 | 1885.84 | 4366.0 |
| 2013-12-23 08:00:00 | ES | Futures | 1885.84 | 1886.88 | 1885.07 | 1886.88 | 8619.0 |
| 2013-12-23 08:30:00 | ES | Futures | 1886.62 | 1886.88 | 1886.1 | 1886.62 | 8169.0 |
| 2013-12-23 09:00:00 | ES | Futures | 1886.36 | 1886.88 | 1884.81 | 1885.07 | 18668.0 |
| 2013-12-23 09:30:00 | ES | Futures | 1885.07 | 1886.1 | 1882.48 | 1882.48 | 98324.0 |
| 2013-12-23 10:00:00 | ES | Futures | 1882.74 | 1884.81 | 1881.19 | 1884.03 | 69984.0 |
| 2013-12-23 10:30:00 | ES | Futures | 1884.29 | 1885.32 | 1882.74 | 1884.81 | 44810.0 |
| 2013-12-23 11:00:00 | ES | Futures | 1884.81 | 1885.84 | 1884.55 | 1885.84 | 26640.0 |
| 2013-12-23 11:30:00 | ES | Futures | 1885.84 | 1886.62 | 1885.32 | 1885.84 | 31554.0 |
| 2013-12-23 12:00:00 | ES | Futures | 1886.1 | 1887.65 | 1885.32 | 1887.13 | 26329.0 |
| 2013-12-23 12:30:00 | ES | Futures | 1887.13 | 1887.39 | 1885.58 | 1885.58 | 24235.0 |
| 2013-12-23 13:00:00 | ES | Futures | 1885.84 | 1886.36 | 1885.32 | 1885.84 | 26546.0 |
| 2013-12-23 13:30:00 | ES | Futures | 1885.58 | 1886.62 | 1882.22 | 1884.03 | 46952.0 |
| 2013-12-23 14:00:00 | ES | Futures | 1884.03 | 1885.07 | 1883.25 | 1884.03 | 40621.0 |
| 2013-12-23 14:30:00 | ES | Futures | 1884.03 | 1885.58 | 1883.77 | 1884.29 | 33053.0 |
| 2013-12-23 15:00:00 | ES | Futures | 1884.29 | 1885.58 | 1884.03 | 1885.32 | 40559.0 |
| 2013-12-23 15:30:00 | ES | Futures | 1885.32 | 1886.36 | 1884.29 | 1885.58 | 70528.0 |
| 2013-12-23 16:00:00 | ES | Futures | 1885.84 | 1886.62 | 1885.07 | 1886.62 | 54757.0 |
| 2013-12-23 16:30:00 | ES | Futures | 1886.36 | 1886.62 | 1885.07 | 1886.36 | 4332.0 |
| 2013-12-23 17:00:00 | ES | Futures | 1886.62 | 1886.62 | 1885.32 | 1886.36 | 2178.0 |
| 2013-12-23 18:00:00 | ES | Futures | 1885.84 | 1886.62 | 1885.58 | 1885.84 | 1869.0 |
| 2013-12-23 18:30:00 | ES | Futures | 1885.84 | 1886.1 | 1885.32 | 1885.84 | 666.0 |
| 2013-12-23 19:00:00 | ES | Futures | 1885.84 | 1885.84 | 1884.03 | 1884.29 | 2099.0 |
| 2013-12-23 19:30:00 | ES | Futures | 1884.03 | 1884.81 | 1883.51 | 1883.77 | 1854.0 |
| 2013-12-23 20:00:00 | ES | Futures | 1884.03 | 1884.29 | 1883.51 | 1884.29 | 1230.0 |
| 2013-12-23 20:30:00 | ES | Futures | 1884.29 | 1884.81 | 1883.77 | 1884.29 | 938.0 |
| 2013-12-23 21:00:00 | ES | Futures | 1884.29 | 1884.55 | 1884.29 | 1884.55 | 336.0 |
| 2013-12-23 21:30:00 | ES | Futures | 1884.55 | 1884.55 | 1884.29 | 1884.29 | 453.0 |
| 2013-12-23 22:00:00 | ES | Futures | 1884.29 | 1884.55 | 1884.29 | 1884.55 | 592.0 |
| 2013-12-23 22:30:00 | ES | Futures | 1884.55 | 1884.81 | 1884.03 | 1884.29 | 825.0 |
| 2013-12-23 23:00:00 | ES | Futures | 1884.29 | 1884.81 | 1884.29 | 1884.81 | 248.0 |
| 2013-12-23 23:30:00 | ES | Futures | 1884.55 | 1886.1 | 1884.55 | 1886.1 | 1912.0 |
| 2013-12-23 00:00:00 | NQ | Futures | 4124.53 | 4127.14 | 4124.53 | 4126.27 | 243.0 |
| 2013-12-23 00:30:00 | NQ | Futures | 4126.27 | 4127.43 | 4125.98 | 4126.85 | 118.0 |
| 2013-12-23 01:00:00 | NQ | Futures | 4126.56 | 4126.56 | 4125.69 | 4126.56 | 216.0 |
> showing 50 of 2,729 rows — these rows as CSV