PREVIEW / futures_30min / 2013-07-08

all futures 30-min files

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

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-08 00:00:00	ES	Futures	1685.13	1685.13	1683.58	1683.58	1879.0
2013-07-08 00:30:00	ES	Futures	1683.84	1684.87	1683.84	1684.35	1341.0
2013-07-08 01:00:00	ES	Futures	1684.35	1684.61	1682.54	1683.32	3105.0
2013-07-08 01:30:00	ES	Futures	1683.06	1683.84	1682.28	1682.8	3639.0
2013-07-08 02:00:00	ES	Futures	1682.8	1683.84	1681.25	1682.8	6436.0
2013-07-08 02:30:00	ES	Futures	1682.8	1685.13	1682.54	1684.87	3216.0
2013-07-08 03:00:00	ES	Futures	1684.61	1686.94	1683.58	1686.94	17610.0
2013-07-08 03:30:00	ES	Futures	1686.94	1689.01	1686.68	1687.97	17280.0
2013-07-08 04:00:00	ES	Futures	1687.97	1688.23	1686.16	1687.45	6572.0
2013-07-08 04:30:00	ES	Futures	1687.45	1688.75	1686.68	1688.23	8033.0
2013-07-08 05:00:00	ES	Futures	1688.23	1692.62	1687.97	1692.11	27549.0
2013-07-08 05:30:00	ES	Futures	1692.37	1693.66	1691.59	1692.37	10576.0
2013-07-08 06:00:00	ES	Futures	1692.11	1693.66	1691.59	1692.11	12223.0
2013-07-08 06:30:00	ES	Futures	1691.85	1692.62	1691.33	1691.59	8080.0
2013-07-08 07:00:00	ES	Futures	1691.59	1692.37	1691.07	1691.59	10553.0
2013-07-08 07:30:00	ES	Futures	1691.33	1692.37	1690.04	1692.11	14413.0
2013-07-08 08:00:00	ES	Futures	1692.11	1692.62	1690.56	1691.85	11942.0
2013-07-08 08:30:00	ES	Futures	1691.59	1692.11	1689.26	1689.78	18264.0
2013-07-08 09:00:00	ES	Futures	1689.78	1690.81	1687.2	1689.26	34693.0
2013-07-08 09:30:00	ES	Futures	1689.52	1692.88	1687.45	1692.11	188980.0
2013-07-08 10:00:00	ES	Futures	1691.85	1695.21	1691.59	1692.37	156463.0
2013-07-08 10:30:00	ES	Futures	1692.62	1694.43	1691.07	1691.85	94488.0
2013-07-08 11:00:00	ES	Futures	1691.85	1693.66	1689.78	1690.81	80210.0
2013-07-08 11:30:00	ES	Futures	1690.81	1691.07	1687.45	1688.49	67578.0
2013-07-08 12:00:00	ES	Futures	1688.49	1689.26	1686.68	1687.45	53104.0
2013-07-08 12:30:00	ES	Futures	1687.2	1690.04	1686.94	1687.97	56959.0
2013-07-08 13:00:00	ES	Futures	1687.71	1690.3	1686.68	1687.71	33410.0
2013-07-08 13:30:00	ES	Futures	1687.71	1691.59	1687.45	1691.07	39196.0
2013-07-08 14:00:00	ES	Futures	1691.07	1691.85	1689.26	1689.52	32176.0
2013-07-08 14:30:00	ES	Futures	1689.78	1692.37	1689.52	1691.59	33539.0
2013-07-08 15:00:00	ES	Futures	1691.59	1691.59	1688.75	1689.01	38638.0
2013-07-08 15:30:00	ES	Futures	1688.75	1691.07	1687.71	1689.78	112393.0
2013-07-08 16:00:00	ES	Futures	1689.78	1691.59	1689.52	1691.33	55301.0
2013-07-08 16:30:00	ES	Futures	1691.59	1693.14	1691.33	1692.62	8125.0
2013-07-08 17:00:00	ES	Futures	1692.88	1693.14	1692.37	1692.62	1686.0
2013-07-08 18:00:00	ES	Futures	1692.37	1692.37	1691.59	1692.11	2393.0
2013-07-08 18:30:00	ES	Futures	1692.11	1692.62	1691.85	1692.11	552.0
2013-07-08 19:00:00	ES	Futures	1692.11	1693.4	1692.11	1693.14	985.0
2013-07-08 19:30:00	ES	Futures	1693.14	1693.4	1692.62	1693.14	1682.0
2013-07-08 20:00:00	ES	Futures	1693.14	1693.4	1692.37	1692.62	2078.0
2013-07-08 20:30:00	ES	Futures	1692.37	1692.88	1691.33	1692.37	1864.0
2013-07-08 21:00:00	ES	Futures	1692.37	1693.14	1691.85	1692.37	2395.0
2013-07-08 21:30:00	ES	Futures	1692.37	1697.54	1691.59	1696.5	11164.0
2013-07-08 22:00:00	ES	Futures	1696.5	1697.28	1695.21	1695.98	3077.0
2013-07-08 22:30:00	ES	Futures	1695.98	1696.24	1695.21	1695.73	2174.0
2013-07-08 23:00:00	ES	Futures	1695.47	1695.98	1695.21	1695.73	1413.0
2013-07-08 23:30:00	ES	Futures	1695.47	1697.02	1694.95	1697.02	2465.0
2013-07-08 00:00:00	NQ	Futures	3467.38	3467.38	3464.16	3464.46	201.0
2013-07-08 00:30:00	NQ	Futures	3464.75	3466.79	3464.75	3466.21	145.0
2013-07-08 01:00:00	NQ	Futures	3466.21	3466.21	3462.99	3463.87	264.0

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

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