PREVIEW / futures_30min / 2013-06-17

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-06-17.parquet
  size:    74 KB
  rows:    2,728

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-17 00:00:00	ES	Futures	1680.22	1680.73	1679.96	1680.47	965.0
2013-06-17 00:30:00	ES	Futures	1680.47	1680.73	1679.7	1679.96	1167.0
2013-06-17 01:00:00	ES	Futures	1679.96	1680.47	1679.7	1680.22	742.0
2013-06-17 01:30:00	ES	Futures	1680.22	1681.77	1680.22	1681.77	2529.0
2013-06-17 02:00:00	ES	Futures	1681.77	1684.35	1681.51	1683.58	7770.0
2013-06-17 02:30:00	ES	Futures	1683.58	1686.16	1683.32	1684.61	5703.0
2013-06-17 03:00:00	ES	Futures	1684.61	1687.45	1683.32	1684.61	16889.0
2013-06-17 03:30:00	ES	Futures	1684.61	1688.75	1684.61	1687.97	15431.0
2013-06-17 04:00:00	ES	Futures	1687.97	1688.75	1686.42	1686.68	8009.0
2013-06-17 04:30:00	ES	Futures	1686.68	1687.71	1685.64	1686.94	5443.0
2013-06-17 05:00:00	ES	Futures	1686.94	1688.75	1686.68	1688.49	5720.0
2013-06-17 05:30:00	ES	Futures	1688.49	1689.52	1688.49	1689.01	7031.0
2013-06-17 06:00:00	ES	Futures	1689.01	1690.3	1688.23	1688.49	7845.0
2013-06-17 06:30:00	ES	Futures	1688.49	1689.26	1687.45	1687.97	12906.0
2013-06-17 07:00:00	ES	Futures	1688.23	1688.75	1686.68	1687.2	16829.0
2013-06-17 07:30:00	ES	Futures	1687.45	1688.23	1684.87	1685.64	20847.0
2013-06-17 08:00:00	ES	Futures	1685.64	1687.45	1684.35	1686.94	17836.0
2013-06-17 08:30:00	ES	Futures	1687.2	1687.45	1684.61	1686.42	21605.0
2013-06-17 09:00:00	ES	Futures	1686.42	1687.45	1685.13	1686.94	20692.0
2013-06-17 09:30:00	ES	Futures	1686.94	1693.92	1686.68	1692.37	221534.0
2013-06-17 10:00:00	ES	Futures	1692.62	1694.43	1690.81	1692.88	125611.0
2013-06-17 10:30:00	ES	Futures	1693.14	1694.95	1691.59	1694.43	82470.0
2013-06-17 11:00:00	ES	Futures	1694.69	1696.76	1693.14	1694.17	84987.0
2013-06-17 11:30:00	ES	Futures	1694.17	1694.69	1691.85	1693.14	67959.0
2013-06-17 12:00:00	ES	Futures	1693.14	1693.66	1691.59	1691.59	39183.0
2013-06-17 12:30:00	ES	Futures	1691.85	1693.66	1691.59	1692.62	30258.0
2013-06-17 13:00:00	ES	Futures	1692.37	1694.69	1691.33	1694.17	41049.0
2013-06-17 13:30:00	ES	Futures	1694.17	1695.21	1693.4	1693.92	29538.0
2013-06-17 14:00:00	ES	Futures	1694.17	1694.43	1684.35	1686.16	135271.0
2013-06-17 14:30:00	ES	Futures	1686.16	1687.71	1678.92	1680.99	149953.0
2013-06-17 15:00:00	ES	Futures	1681.25	1684.35	1679.7	1683.84	119921.0
2013-06-17 15:30:00	ES	Futures	1683.84	1690.56	1683.84	1688.49	172330.0
2013-06-17 16:00:00	ES	Futures	1688.49	1690.3	1687.71	1689.78	58145.0
2013-06-17 16:30:00	ES	Futures	1689.78	1690.81	1689.78	1690.3	4614.0
2013-06-17 17:00:00	ES	Futures	1690.3	1691.33	1690.04	1690.81	2472.0
2013-06-17 18:00:00	ES	Futures	1690.3	1691.07	1689.52	1689.78	2985.0
2013-06-17 18:30:00	ES	Futures	1689.78	1691.07	1689.78	1690.56	897.0
2013-06-17 19:00:00	ES	Futures	1690.3	1690.81	1689.78	1690.04	1056.0
2013-06-17 19:30:00	ES	Futures	1690.04	1690.81	1689.52	1689.52	727.0
2013-06-17 20:00:00	ES	Futures	1689.52	1691.07	1689.26	1689.52	2413.0
2013-06-17 20:30:00	ES	Futures	1689.52	1690.04	1689.01	1689.26	1194.0
2013-06-17 21:00:00	ES	Futures	1689.26	1689.52	1688.75	1688.75	966.0
2013-06-17 21:30:00	ES	Futures	1689.01	1689.26	1687.71	1688.23	1857.0
2013-06-17 22:00:00	ES	Futures	1688.49	1689.01	1687.71	1688.23	1842.0
2013-06-17 22:30:00	ES	Futures	1688.23	1689.01	1688.23	1688.49	602.0
2013-06-17 23:00:00	ES	Futures	1688.49	1688.75	1687.71	1688.23	1801.0
2013-06-17 23:30:00	ES	Futures	1688.23	1689.78	1687.71	1689.01	4484.0
2013-06-17 00:00:00	NQ	Futures	3447.8	3448.09	3447.21	3447.51	107.0
2013-06-17 00:30:00	NQ	Futures	3447.8	3447.8	3446.05	3446.34	119.0
2013-06-17 01:00:00	NQ	Futures	3446.34	3447.21	3445.46	3446.63	45.0

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

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