PREVIEW / futures_30min / 2013-08-14

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-08-14.parquet
  size:    74 KB
  rows:    2,807

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-08-14 00:00:00	ES	Futures	1745.62	1745.62	1744.84	1745.1	1931.0
2013-08-14 00:30:00	ES	Futures	1745.1	1745.62	1745.1	1745.62	1298.0
2013-08-14 01:00:00	ES	Futures	1745.62	1746.13	1745.62	1746.13	1069.0
2013-08-14 01:30:00	ES	Futures	1746.13	1746.91	1746.13	1746.91	1771.0
2013-08-14 02:00:00	ES	Futures	1746.65	1747.42	1746.39	1746.91	2218.0
2013-08-14 02:30:00	ES	Futures	1747.17	1747.42	1745.62	1745.87	3131.0
2013-08-14 03:00:00	ES	Futures	1745.87	1746.65	1745.1	1745.36	8563.0
2013-08-14 03:30:00	ES	Futures	1745.36	1745.36	1742.77	1743.81	10637.0
2013-08-14 04:00:00	ES	Futures	1743.81	1744.58	1743.03	1743.81	7306.0
2013-08-14 04:30:00	ES	Futures	1743.81	1745.1	1742.51	1744.32	8366.0
2013-08-14 05:00:00	ES	Futures	1744.06	1745.1	1743.29	1743.55	4662.0
2013-08-14 05:30:00	ES	Futures	1743.55	1745.1	1743.55	1744.84	5256.0
2013-08-14 06:00:00	ES	Futures	1744.84	1745.87	1744.84	1744.84	5727.0
2013-08-14 06:30:00	ES	Futures	1744.84	1746.39	1744.84	1746.13	3124.0
2013-08-14 07:00:00	ES	Futures	1746.13	1746.39	1745.36	1745.87	5784.0
2013-08-14 07:30:00	ES	Futures	1745.62	1746.39	1745.62	1746.13	4806.0
2013-08-14 08:00:00	ES	Futures	1746.13	1746.13	1742.77	1743.55	14653.0
2013-08-14 08:30:00	ES	Futures	1743.55	1745.87	1743.29	1745.62	18861.0
2013-08-14 09:00:00	ES	Futures	1745.62	1748.2	1745.36	1747.94	33017.0
2013-08-14 09:30:00	ES	Futures	1747.94	1750.79	1745.87	1748.46	178778.0
2013-08-14 10:00:00	ES	Futures	1748.46	1749.23	1744.06	1745.62	131772.0
2013-08-14 10:30:00	ES	Futures	1745.62	1747.17	1740.96	1742.77	128460.0
2013-08-14 11:00:00	ES	Futures	1742.77	1743.81	1740.96	1743.55	109487.0
2013-08-14 11:30:00	ES	Futures	1743.81	1744.58	1740.96	1742.0	94483.0
2013-08-14 12:00:00	ES	Futures	1742.0	1744.84	1741.74	1744.84	55684.0
2013-08-14 12:30:00	ES	Futures	1744.84	1745.1	1742.51	1742.77	51983.0
2013-08-14 13:00:00	ES	Futures	1742.77	1744.06	1742.0	1742.0	52117.0
2013-08-14 13:30:00	ES	Futures	1742.0	1742.26	1739.15	1741.22	126713.0
2013-08-14 14:00:00	ES	Futures	1741.22	1742.51	1739.41	1740.45	58187.0
2013-08-14 14:30:00	ES	Futures	1740.45	1742.77	1740.19	1741.74	61533.0
2013-08-14 15:00:00	ES	Futures	1742.0	1744.58	1740.7	1742.26	91447.0
2013-08-14 15:30:00	ES	Futures	1742.51	1742.51	1739.15	1739.67	107245.0
2013-08-14 16:00:00	ES	Futures	1739.93	1740.19	1738.12	1738.64	72200.0
2013-08-14 16:30:00	ES	Futures	1738.64	1739.93	1738.38	1739.15	7246.0
2013-08-14 17:00:00	ES	Futures	1739.15	1739.41	1738.12	1738.12	4519.0
2013-08-14 18:00:00	ES	Futures	1737.6	1737.86	1733.98	1735.79	9281.0
2013-08-14 18:30:00	ES	Futures	1735.79	1736.57	1735.28	1735.53	2003.0
2013-08-14 19:00:00	ES	Futures	1735.53	1735.79	1735.02	1735.53	931.0
2013-08-14 19:30:00	ES	Futures	1735.53	1736.05	1734.76	1735.02	1824.0
2013-08-14 20:00:00	ES	Futures	1734.76	1736.83	1734.76	1736.31	3715.0
2013-08-14 20:30:00	ES	Futures	1736.57	1736.57	1736.05	1736.57	1733.0
2013-08-14 21:00:00	ES	Futures	1736.31	1737.86	1736.31	1737.86	4267.0
2013-08-14 21:30:00	ES	Futures	1737.6	1738.64	1737.34	1738.12	4214.0
2013-08-14 22:00:00	ES	Futures	1738.38	1739.15	1737.6	1738.89	3754.0
2013-08-14 22:30:00	ES	Futures	1738.64	1739.15	1737.86	1738.38	2097.0
2013-08-14 23:00:00	ES	Futures	1738.12	1738.38	1736.83	1736.83	2713.0
2013-08-14 23:30:00	ES	Futures	1737.09	1738.12	1736.31	1738.12	2289.0
2013-08-14 00:00:00	NQ	Futures	3665.51	3665.81	3664.93	3665.22	175.0
2013-08-14 00:30:00	NQ	Futures	3665.51	3666.1	3665.22	3665.51	128.0
2013-08-14 01:00:00	NQ	Futures	3665.81	3667.56	3665.51	3666.68	269.0

> showing 50 of 2,807 rows — these rows as CSV

> unlock the full archive -- $79 one-time