PREVIEW / futures_30min / 2013-07-01

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-07-01.parquet
  size:    76 KB
  rows:    2,786

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-07-01 00:00:00	ES	Futures	1649.71	1651.78	1649.2	1651.52	1373.0
2013-07-01 00:30:00	ES	Futures	1651.52	1652.04	1650.49	1650.75	1323.0
2013-07-01 01:00:00	ES	Futures	1651.01	1652.3	1650.75	1652.3	1286.0
2013-07-01 01:30:00	ES	Futures	1652.04	1655.14	1651.78	1654.11	4350.0
2013-07-01 02:00:00	ES	Futures	1654.11	1658.5	1653.85	1657.99	7478.0
2013-07-01 02:30:00	ES	Futures	1657.99	1660.05	1657.99	1659.28	7536.0
2013-07-01 03:00:00	ES	Futures	1659.54	1664.45	1659.54	1663.93	21648.0
2013-07-01 03:30:00	ES	Futures	1664.19	1664.45	1661.86	1662.9	14587.0
2013-07-01 04:00:00	ES	Futures	1662.9	1662.9	1656.43	1657.21	20657.0
2013-07-01 04:30:00	ES	Futures	1657.21	1659.02	1656.69	1657.47	7128.0
2013-07-01 05:00:00	ES	Futures	1657.21	1661.35	1656.95	1661.35	11414.0
2013-07-01 05:30:00	ES	Futures	1661.35	1664.19	1661.35	1663.41	12373.0
2013-07-01 06:00:00	ES	Futures	1663.67	1664.71	1660.31	1661.35	13077.0
2013-07-01 06:30:00	ES	Futures	1661.35	1661.86	1659.8	1660.57	6736.0
2013-07-01 07:00:00	ES	Futures	1660.57	1661.6	1659.8	1660.57	6948.0
2013-07-01 07:30:00	ES	Futures	1660.57	1662.64	1660.31	1661.09	9716.0
2013-07-01 08:00:00	ES	Futures	1661.09	1662.9	1660.31	1661.09	10806.0
2013-07-01 08:30:00	ES	Futures	1661.09	1661.86	1659.8	1660.57	13793.0
2013-07-01 09:00:00	ES	Futures	1660.83	1663.41	1660.31	1662.64	26999.0
2013-07-01 09:30:00	ES	Futures	1662.9	1670.13	1661.86	1668.84	215392.0
2013-07-01 10:00:00	ES	Futures	1669.1	1675.05	1668.33	1672.72	163689.0
2013-07-01 10:30:00	ES	Futures	1672.72	1673.75	1670.39	1671.43	93999.0
2013-07-01 11:00:00	ES	Futures	1671.43	1674.79	1671.17	1673.5	73190.0
2013-07-01 11:30:00	ES	Futures	1673.24	1674.79	1671.94	1674.53	63573.0
2013-07-01 12:00:00	ES	Futures	1674.53	1675.56	1671.17	1671.69	68301.0
2013-07-01 12:30:00	ES	Futures	1671.69	1673.75	1671.17	1672.46	42345.0
2013-07-01 13:00:00	ES	Futures	1672.46	1673.5	1671.17	1672.46	44700.0
2013-07-01 13:30:00	ES	Futures	1672.46	1672.98	1667.29	1667.55	66825.0
2013-07-01 14:00:00	ES	Futures	1667.29	1669.62	1665.22	1667.55	83758.0
2013-07-01 14:30:00	ES	Futures	1667.55	1669.62	1665.74	1668.58	68153.0
2013-07-01 15:00:00	ES	Futures	1668.58	1670.39	1665.22	1665.48	71949.0
2013-07-01 15:30:00	ES	Futures	1665.48	1665.74	1660.57	1663.67	178758.0
2013-07-01 16:00:00	ES	Futures	1663.67	1664.19	1660.83	1661.09	64550.0
2013-07-01 16:30:00	ES	Futures	1661.09	1661.35	1660.05	1661.09	7278.0
2013-07-01 17:00:00	ES	Futures	1660.83	1661.86	1660.83	1661.09	2435.0
2013-07-01 18:00:00	ES	Futures	1661.35	1662.38	1660.83	1661.35	2221.0
2013-07-01 18:30:00	ES	Futures	1661.09	1662.64	1661.09	1662.12	1529.0
2013-07-01 19:00:00	ES	Futures	1662.12	1662.38	1661.6	1662.12	671.0
2013-07-01 19:30:00	ES	Futures	1662.12	1662.9	1661.86	1662.64	1202.0
2013-07-01 20:00:00	ES	Futures	1662.38	1664.71	1662.38	1664.71	3714.0
2013-07-01 20:30:00	ES	Futures	1664.97	1665.74	1663.67	1665.22	4220.0
2013-07-01 21:00:00	ES	Futures	1665.22	1666.52	1664.45	1666.26	3702.0
2013-07-01 21:30:00	ES	Futures	1666.26	1666.52	1663.93	1664.45	2080.0
2013-07-01 22:00:00	ES	Futures	1664.71	1664.97	1663.16	1664.71	2060.0
2013-07-01 22:30:00	ES	Futures	1664.45	1664.71	1663.93	1664.45	693.0
2013-07-01 23:00:00	ES	Futures	1664.71	1665.22	1662.9	1663.41	1911.0
2013-07-01 23:30:00	ES	Futures	1663.16	1663.93	1662.38	1663.16	1595.0
2013-07-01 00:00:00	NQ	Futures	3387.89	3392.27	3387.31	3391.98	191.0
2013-07-01 00:30:00	NQ	Futures	3391.69	3393.15	3389.94	3390.81	163.0
2013-07-01 01:00:00	NQ	Futures	3390.52	3392.86	3390.23	3392.86	145.0

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

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