PREVIEW / futures_30min / 2013-06-10

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-06-10.parquet
  size:    70 KB
  rows:    2,547

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-10 00:00:00	ES	Futures	1690.53	1690.78	1690.01	1690.53	1098.0
2013-06-10 00:30:00	ES	Futures	1690.78	1690.78	1690.01	1690.27	1048.0
2013-06-10 01:00:00	ES	Futures	1690.27	1691.56	1689.75	1690.27	2357.0
2013-06-10 01:30:00	ES	Futures	1690.27	1691.56	1689.75	1691.3	2961.0
2013-06-10 02:00:00	ES	Futures	1691.3	1692.84	1690.78	1692.59	7459.0
2013-06-10 02:30:00	ES	Futures	1692.59	1693.36	1692.33	1693.1	4314.0
2013-06-10 03:00:00	ES	Futures	1693.1	1694.39	1691.3	1693.1	17071.0
2013-06-10 03:30:00	ES	Futures	1692.84	1693.87	1691.3	1693.36	10552.0
2013-06-10 04:00:00	ES	Futures	1693.62	1696.19	1693.1	1693.87	18398.0
2013-06-10 04:30:00	ES	Futures	1693.87	1695.42	1693.62	1695.16	7356.0
2013-06-10 05:00:00	ES	Futures	1695.42	1695.68	1693.87	1694.39	6645.0
2013-06-10 05:30:00	ES	Futures	1694.39	1695.68	1694.39	1695.16	4807.0
2013-06-10 06:00:00	ES	Futures	1695.16	1695.42	1693.62	1694.65	6864.0
2013-06-10 06:30:00	ES	Futures	1694.39	1695.42	1693.87	1694.39	7480.0
2013-06-10 07:00:00	ES	Futures	1694.65	1696.71	1694.39	1695.16	24459.0
2013-06-10 07:30:00	ES	Futures	1695.16	1695.42	1693.87	1694.9	10637.0
2013-06-10 08:00:00	ES	Futures	1694.9	1695.42	1691.81	1692.33	24015.0
2013-06-10 08:30:00	ES	Futures	1692.59	1695.94	1691.3	1694.9	49946.0
2013-06-10 09:00:00	ES	Futures	1694.9	1698.25	1693.87	1697.22	51844.0
2013-06-10 09:30:00	ES	Futures	1697.22	1698.51	1690.53	1691.81	256120.0
2013-06-10 10:00:00	ES	Futures	1692.07	1692.84	1687.95	1692.59	204645.0
2013-06-10 10:30:00	ES	Futures	1692.84	1696.19	1692.07	1694.39	111036.0
2013-06-10 11:00:00	ES	Futures	1694.39	1696.97	1693.87	1694.13	90457.0
2013-06-10 11:30:00	ES	Futures	1694.13	1696.45	1692.59	1695.16	130270.0
2013-06-10 12:00:00	ES	Futures	1695.16	1697.22	1694.9	1695.16	80006.0
2013-06-10 12:30:00	ES	Futures	1695.42	1695.42	1691.3	1691.81	66184.0
2013-06-10 13:00:00	ES	Futures	1692.07	1693.36	1691.04	1692.33	62349.0
2013-06-10 13:30:00	ES	Futures	1692.33	1692.59	1689.5	1692.07	63091.0
2013-06-10 14:00:00	ES	Futures	1691.81	1692.33	1688.72	1691.3	62343.0
2013-06-10 14:30:00	ES	Futures	1691.3	1694.13	1690.01	1693.87	60099.0
2013-06-10 15:00:00	ES	Futures	1693.87	1694.13	1690.53	1692.59	68532.0
2013-06-10 15:30:00	ES	Futures	1692.33	1693.62	1689.24	1691.81	94828.0
2013-06-10 16:00:00	ES	Futures	1691.81	1692.84	1691.3	1692.33	46284.0
2013-06-10 16:30:00	ES	Futures	1692.59	1692.59	1691.3	1691.81	5571.0
2013-06-10 17:00:00	ES	Futures	1691.81	1692.07	1691.56	1691.81	1329.0
2013-06-10 18:00:00	ES	Futures	1691.81	1692.33	1691.04	1691.3	2173.0
2013-06-10 18:30:00	ES	Futures	1691.3	1692.07	1690.78	1691.3	1139.0
2013-06-10 19:00:00	ES	Futures	1691.56	1691.81	1691.56	1691.56	257.0
2013-06-10 19:30:00	ES	Futures	1691.3	1691.56	1691.04	1691.56	725.0
2013-06-10 20:00:00	ES	Futures	1691.3	1691.3	1690.01	1690.78	2392.0
2013-06-10 20:30:00	ES	Futures	1691.04	1691.56	1690.53	1691.04	1675.0
2013-06-10 21:00:00	ES	Futures	1691.3	1692.07	1690.53	1691.56	2656.0
2013-06-10 21:30:00	ES	Futures	1691.81	1692.07	1691.04	1691.3	1869.0
2013-06-10 22:00:00	ES	Futures	1691.3	1691.81	1690.53	1691.04	2176.0
2013-06-10 22:30:00	ES	Futures	1691.04	1691.3	1689.24	1689.5	2817.0
2013-06-10 23:00:00	ES	Futures	1689.75	1689.75	1687.95	1688.47	6653.0
2013-06-10 23:30:00	ES	Futures	1688.47	1690.01	1687.95	1688.98	4492.0
2013-06-10 00:00:00	NQ	Futures	3484.56	3485.72	3483.97	3485.14	135.0
2013-06-10 00:30:00	NQ	Futures	3485.43	3486.31	3484.56	3484.56	200.0
2013-06-10 01:00:00	NQ	Futures	3484.56	3486.6	3483.68	3484.56	320.0

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

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