PREVIEW / futures_30min / 2013-12-31
file: by_date/futures_30min/2013/2013-12-31.parquet size: 53 KB rows: 1,885
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-31 00:00:00 | ES | Futures | 1898.52 | 1898.52 | 1898.26 | 1898.26 | 138.0 |
| 2013-12-31 00:30:00 | ES | Futures | 1898.52 | 1898.77 | 1898.26 | 1898.26 | 131.0 |
| 2013-12-31 01:00:00 | ES | Futures | 1898.52 | 1898.77 | 1898.26 | 1898.26 | 106.0 |
| 2013-12-31 01:30:00 | ES | Futures | 1898.26 | 1898.52 | 1898.26 | 1898.52 | 254.0 |
| 2013-12-31 02:00:00 | ES | Futures | 1898.26 | 1899.03 | 1898.26 | 1899.03 | 611.0 |
| 2013-12-31 02:30:00 | ES | Futures | 1898.77 | 1898.77 | 1898.52 | 1898.52 | 492.0 |
| 2013-12-31 03:00:00 | ES | Futures | 1898.77 | 1899.03 | 1898.52 | 1898.77 | 814.0 |
| 2013-12-31 03:30:00 | ES | Futures | 1898.77 | 1899.03 | 1898.52 | 1899.03 | 697.0 |
| 2013-12-31 04:00:00 | ES | Futures | 1899.03 | 1899.29 | 1898.77 | 1899.29 | 801.0 |
| 2013-12-31 04:30:00 | ES | Futures | 1899.29 | 1899.29 | 1898.77 | 1899.29 | 711.0 |
| 2013-12-31 05:00:00 | ES | Futures | 1899.03 | 1899.55 | 1899.03 | 1899.29 | 1047.0 |
| 2013-12-31 05:30:00 | ES | Futures | 1899.55 | 1899.55 | 1898.52 | 1899.29 | 1121.0 |
| 2013-12-31 06:00:00 | ES | Futures | 1899.29 | 1899.55 | 1899.03 | 1899.29 | 1004.0 |
| 2013-12-31 06:30:00 | ES | Futures | 1899.55 | 1899.55 | 1899.03 | 1899.03 | 865.0 |
| 2013-12-31 07:00:00 | ES | Futures | 1899.29 | 1899.29 | 1898.77 | 1899.29 | 1159.0 |
| 2013-12-31 07:30:00 | ES | Futures | 1899.29 | 1900.84 | 1899.29 | 1900.58 | 5198.0 |
| 2013-12-31 08:00:00 | ES | Futures | 1900.58 | 1902.14 | 1900.58 | 1901.88 | 6589.0 |
| 2013-12-31 08:30:00 | ES | Futures | 1901.88 | 1902.39 | 1901.36 | 1901.88 | 4308.0 |
| 2013-12-31 09:00:00 | ES | Futures | 1901.88 | 1902.39 | 1901.62 | 1901.62 | 4632.0 |
| 2013-12-31 09:30:00 | ES | Futures | 1901.62 | 1902.91 | 1900.84 | 1902.39 | 36840.0 |
| 2013-12-31 10:00:00 | ES | Futures | 1902.39 | 1904.46 | 1902.39 | 1903.43 | 44002.0 |
| 2013-12-31 10:30:00 | ES | Futures | 1903.43 | 1904.46 | 1903.17 | 1904.46 | 26341.0 |
| 2013-12-31 11:00:00 | ES | Futures | 1904.46 | 1907.31 | 1904.46 | 1906.02 | 50591.0 |
| 2013-12-31 11:30:00 | ES | Futures | 1906.27 | 1906.53 | 1904.98 | 1905.24 | 14172.0 |
| 2013-12-31 12:00:00 | ES | Futures | 1905.5 | 1905.76 | 1904.46 | 1904.98 | 15618.0 |
| 2013-12-31 12:30:00 | ES | Futures | 1905.24 | 1906.02 | 1903.69 | 1905.24 | 24119.0 |
| 2013-12-31 13:00:00 | ES | Futures | 1904.98 | 1905.24 | 1903.69 | 1904.98 | 13957.0 |
| 2013-12-31 13:30:00 | ES | Futures | 1904.98 | 1905.24 | 1904.46 | 1904.72 | 10887.0 |
| 2013-12-31 14:00:00 | ES | Futures | 1904.98 | 1904.98 | 1902.39 | 1902.65 | 24089.0 |
| 2013-12-31 14:30:00 | ES | Futures | 1902.91 | 1903.43 | 1900.58 | 1901.88 | 37550.0 |
| 2013-12-31 15:00:00 | ES | Futures | 1901.88 | 1902.91 | 1900.33 | 1902.65 | 26076.0 |
| 2013-12-31 15:30:00 | ES | Futures | 1902.65 | 1908.09 | 1902.65 | 1906.53 | 184886.0 |
| 2013-12-31 16:00:00 | ES | Futures | 1906.53 | 1910.41 | 1906.53 | 1910.15 | 93820.0 |
| 2013-12-31 16:30:00 | ES | Futures | 1909.9 | 1910.41 | 1909.12 | 1909.38 | 8608.0 |
| 2013-12-31 17:00:00 | ES | Futures | 1909.38 | 1910.41 | 1909.38 | 1910.15 | 1305.0 |
| 2013-12-31 00:00:00 | NQ | Futures | 4146.91 | 4146.91 | 4146.04 | 4146.04 | 11.0 |
| 2013-12-31 00:30:00 | NQ | Futures | 4146.62 | 4146.91 | 4146.33 | 4146.62 | 21.0 |
| 2013-12-31 01:00:00 | NQ | Futures | 4146.91 | 4147.2 | 4146.33 | 4146.62 | 19.0 |
| 2013-12-31 01:30:00 | NQ | Futures | 4146.91 | 4146.91 | 4146.91 | 4146.91 | 2.0 |
| 2013-12-31 02:00:00 | NQ | Futures | 4146.91 | 4147.78 | 4146.91 | 4147.78 | 29.0 |
| 2013-12-31 02:30:00 | NQ | Futures | 4148.07 | 4148.07 | 4146.91 | 4147.2 | 34.0 |
| 2013-12-31 03:00:00 | NQ | Futures | 4147.2 | 4147.78 | 4146.91 | 4147.49 | 24.0 |
| 2013-12-31 03:30:00 | NQ | Futures | 4147.2 | 4147.49 | 4146.91 | 4146.91 | 22.0 |
| 2013-12-31 04:00:00 | NQ | Futures | 4146.91 | 4148.07 | 4146.91 | 4147.78 | 54.0 |
| 2013-12-31 04:30:00 | NQ | Futures | 4147.49 | 4148.36 | 4147.49 | 4148.36 | 36.0 |
| 2013-12-31 05:00:00 | NQ | Futures | 4148.36 | 4148.36 | 4147.78 | 4148.07 | 62.0 |
| 2013-12-31 05:30:00 | NQ | Futures | 4148.07 | 4148.36 | 4146.91 | 4147.78 | 31.0 |
| 2013-12-31 06:00:00 | NQ | Futures | 4147.49 | 4148.94 | 4147.49 | 4148.94 | 54.0 |
| 2013-12-31 06:30:00 | NQ | Futures | 4148.65 | 4148.94 | 4148.36 | 4148.94 | 29.0 |
| 2013-12-31 07:00:00 | NQ | Futures | 4148.65 | 4148.65 | 4148.36 | 4148.65 | 54.0 |
> showing 50 of 1,885 rows — these rows as CSV