PREVIEW / futures_30min / 2013-06-20

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-06-20.parquet
  size:    89 KB
  rows:    2,967

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-06-20 00:00:00	ES	Futures	1670.13	1670.65	1669.36	1670.13	2446.0
2013-06-20 00:30:00	ES	Futures	1670.13	1672.46	1669.88	1670.65	2401.0
2013-06-20 01:00:00	ES	Futures	1670.65	1670.65	1669.36	1670.39	2712.0
2013-06-20 01:30:00	ES	Futures	1670.39	1671.94	1668.84	1669.88	4739.0
2013-06-20 02:00:00	ES	Futures	1670.13	1671.94	1669.36	1669.36	7029.0
2013-06-20 02:30:00	ES	Futures	1669.36	1672.2	1668.84	1671.69	6881.0
2013-06-20 03:00:00	ES	Futures	1671.69	1674.53	1669.1	1674.27	27286.0
2013-06-20 03:30:00	ES	Futures	1674.01	1674.27	1670.39	1671.17	19236.0
2013-06-20 04:00:00	ES	Futures	1671.43	1672.46	1666.77	1668.84	35652.0
2013-06-20 04:30:00	ES	Futures	1668.84	1669.36	1666.77	1666.77	13536.0
2013-06-20 05:00:00	ES	Futures	1666.77	1669.62	1665.74	1668.58	15973.0
2013-06-20 05:30:00	ES	Futures	1668.33	1668.58	1660.05	1662.12	25571.0
2013-06-20 06:00:00	ES	Futures	1662.38	1663.93	1660.83	1662.9	27389.0
2013-06-20 06:30:00	ES	Futures	1662.9	1666.0	1662.9	1664.97	22442.0
2013-06-20 07:00:00	ES	Futures	1665.22	1667.55	1663.93	1663.93	25233.0
2013-06-20 07:30:00	ES	Futures	1663.93	1665.22	1661.35	1664.97	32055.0
2013-06-20 08:00:00	ES	Futures	1664.97	1667.55	1664.71	1666.0	25499.0
2013-06-20 08:30:00	ES	Futures	1666.0	1667.55	1662.64	1663.16	44417.0
2013-06-20 09:00:00	ES	Futures	1662.64	1663.67	1660.57	1661.35	46620.0
2013-06-20 09:30:00	ES	Futures	1661.35	1663.67	1656.18	1659.8	318506.0
2013-06-20 10:00:00	ES	Futures	1659.8	1662.64	1651.01	1652.3	317799.0
2013-06-20 10:30:00	ES	Futures	1652.3	1654.88	1648.16	1652.82	255223.0
2013-06-20 11:00:00	ES	Futures	1652.82	1653.33	1646.35	1649.97	199527.0
2013-06-20 11:30:00	ES	Futures	1649.97	1653.85	1648.16	1652.56	143436.0
2013-06-20 12:00:00	ES	Futures	1652.56	1655.92	1652.3	1653.85	114946.0
2013-06-20 12:30:00	ES	Futures	1653.85	1656.95	1649.97	1650.23	87896.0
2013-06-20 13:00:00	ES	Futures	1650.23	1652.82	1646.35	1648.94	106878.0
2013-06-20 13:30:00	ES	Futures	1648.94	1652.3	1647.65	1650.75	114379.0
2013-06-20 14:00:00	ES	Futures	1651.01	1651.52	1639.89	1640.41	211358.0
2013-06-20 14:30:00	ES	Futures	1640.67	1642.73	1634.98	1635.24	183929.0
2013-06-20 15:00:00	ES	Futures	1635.24	1640.67	1633.43	1635.76	198279.0
2013-06-20 15:30:00	ES	Futures	1635.76	1639.63	1630.59	1634.72	362393.0
2013-06-20 16:00:00	ES	Futures	1634.98	1638.86	1634.2	1638.08	138655.0
2013-06-20 16:30:00	ES	Futures	1638.08	1638.08	1636.53	1637.31	20884.0
2013-06-20 17:00:00	ES	Futures	1637.56	1638.34	1637.05	1637.56	5452.0
2013-06-20 18:00:00	ES	Futures	1638.08	1639.89	1637.82	1639.12	6436.0
2013-06-20 18:30:00	ES	Futures	1639.12	1639.12	1636.53	1637.31	3395.0
2013-06-20 19:00:00	ES	Futures	1637.31	1637.82	1636.53	1637.82	1919.0
2013-06-20 19:30:00	ES	Futures	1637.56	1639.12	1637.05	1638.86	3710.0
2013-06-20 20:00:00	ES	Futures	1639.12	1640.15	1638.08	1638.86	5546.0
2013-06-20 20:30:00	ES	Futures	1638.6	1639.89	1638.34	1638.34	2897.0
2013-06-20 21:00:00	ES	Futures	1638.6	1640.41	1638.08	1638.6	4617.0
2013-06-20 21:30:00	ES	Futures	1638.6	1641.7	1638.6	1641.44	5477.0
2013-06-20 22:00:00	ES	Futures	1641.7	1643.77	1641.44	1642.99	9749.0
2013-06-20 22:30:00	ES	Futures	1642.73	1643.77	1642.48	1643.77	4375.0
2013-06-20 23:00:00	ES	Futures	1643.51	1644.03	1642.22	1642.99	4072.0
2013-06-20 23:30:00	ES	Futures	1642.73	1643.51	1641.7	1642.22	2976.0
2013-06-20 00:00:00	NQ	Futures	3439.91	3441.37	3438.74	3439.62	272.0
2013-06-20 00:30:00	NQ	Futures	3439.91	3443.71	3439.32	3440.2	363.0
2013-06-20 01:00:00	NQ	Futures	3440.2	3440.2	3437.86	3439.62	362.0

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

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