PREVIEW / futures_30min / 2013-04-09

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-04-09.parquet
  size:    76 KB
  rows:    2,858

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-04-09 00:00:00	ES	Futures	1608.61	1609.13	1608.1	1608.87	1731.0
2013-04-09 00:30:00	ES	Futures	1608.87	1609.13	1607.84	1607.84	866.0
2013-04-09 01:00:00	ES	Futures	1607.84	1608.87	1607.84	1608.61	1763.0
2013-04-09 01:30:00	ES	Futures	1608.61	1608.87	1607.33	1607.84	2656.0
2013-04-09 02:00:00	ES	Futures	1607.58	1607.84	1606.3	1606.81	7208.0
2013-04-09 02:30:00	ES	Futures	1606.81	1607.07	1606.3	1606.81	3897.0
2013-04-09 03:00:00	ES	Futures	1607.07	1607.84	1606.55	1607.33	15419.0
2013-04-09 03:30:00	ES	Futures	1607.07	1608.36	1607.07	1607.58	12587.0
2013-04-09 04:00:00	ES	Futures	1607.33	1610.16	1607.33	1610.16	15758.0
2013-04-09 04:30:00	ES	Futures	1610.16	1610.42	1607.58	1608.1	13228.0
2013-04-09 05:00:00	ES	Futures	1608.1	1609.39	1606.81	1609.39	10546.0
2013-04-09 05:30:00	ES	Futures	1609.13	1609.39	1606.81	1607.84	11003.0
2013-04-09 06:00:00	ES	Futures	1608.1	1608.87	1607.84	1608.87	5989.0
2013-04-09 06:30:00	ES	Futures	1608.61	1608.87	1607.07	1607.84	6411.0
2013-04-09 07:00:00	ES	Futures	1607.84	1609.64	1607.84	1608.87	9412.0
2013-04-09 07:30:00	ES	Futures	1608.61	1609.9	1608.36	1608.87	7251.0
2013-04-09 08:00:00	ES	Futures	1608.61	1609.64	1608.36	1608.87	11745.0
2013-04-09 08:30:00	ES	Futures	1608.61	1610.67	1608.61	1609.64	23258.0
2013-04-09 09:00:00	ES	Futures	1609.64	1610.42	1608.1	1608.1	29378.0
2013-04-09 09:30:00	ES	Futures	1608.36	1609.39	1602.69	1603.46	196267.0
2013-04-09 10:00:00	ES	Futures	1603.46	1608.36	1603.2	1608.36	134864.0
2013-04-09 10:30:00	ES	Futures	1608.36	1608.61	1603.98	1605.52	127400.0
2013-04-09 11:00:00	ES	Futures	1605.52	1606.3	1603.2	1605.52	88829.0
2013-04-09 11:30:00	ES	Futures	1605.52	1608.1	1605.01	1608.1	62904.0
2013-04-09 12:00:00	ES	Futures	1608.1	1608.87	1606.81	1608.87	34821.0
2013-04-09 12:30:00	ES	Futures	1608.87	1610.93	1608.61	1609.39	67617.0
2013-04-09 13:00:00	ES	Futures	1609.64	1614.54	1609.39	1613.77	111087.0
2013-04-09 13:30:00	ES	Futures	1613.51	1615.31	1613.25	1613.51	93766.0
2013-04-09 14:00:00	ES	Futures	1613.51	1615.31	1612.99	1614.54	73977.0
2013-04-09 14:30:00	ES	Futures	1614.54	1616.6	1614.54	1615.83	99038.0
2013-04-09 15:00:00	ES	Futures	1615.83	1616.6	1613.51	1614.02	79016.0
2013-04-09 15:30:00	ES	Futures	1613.77	1614.28	1610.16	1610.67	165620.0
2013-04-09 16:00:00	ES	Futures	1610.67	1611.96	1610.16	1610.67	64723.0
2013-04-09 16:30:00	ES	Futures	1610.67	1611.71	1610.67	1611.19	7649.0
2013-04-09 17:00:00	ES	Futures	1610.93	1611.45	1610.93	1610.93	1644.0
2013-04-09 18:00:00	ES	Futures	1611.19	1611.19	1609.64	1610.42	3191.0
2013-04-09 18:30:00	ES	Futures	1610.42	1610.67	1609.9	1610.16	986.0
2013-04-09 19:00:00	ES	Futures	1610.16	1610.67	1610.16	1610.67	320.0
2013-04-09 19:30:00	ES	Futures	1610.67	1610.67	1609.39	1609.39	1364.0
2013-04-09 20:00:00	ES	Futures	1609.39	1609.9	1608.87	1609.39	3575.0
2013-04-09 20:30:00	ES	Futures	1609.13	1609.64	1608.87	1608.87	1779.0
2013-04-09 21:00:00	ES	Futures	1609.13	1609.13	1608.36	1608.61	3982.0
2013-04-09 21:30:00	ES	Futures	1608.87	1609.9	1608.61	1609.39	4071.0
2013-04-09 22:00:00	ES	Futures	1609.39	1610.42	1609.39	1609.64	3018.0
2013-04-09 22:30:00	ES	Futures	1609.9	1610.16	1609.64	1609.9	1001.0
2013-04-09 23:00:00	ES	Futures	1609.9	1609.9	1609.64	1609.9	602.0
2013-04-09 23:30:00	ES	Futures	1609.64	1610.16	1609.39	1609.64	1133.0
2013-04-09 00:00:00	NQ	Futures	3250.64	3251.81	3250.35	3251.51	112.0
2013-04-09 00:30:00	NQ	Futures	3251.22	3251.22	3250.06	3250.06	57.0
2013-04-09 01:00:00	NQ	Futures	3250.06	3251.51	3250.06	3250.64	151.0

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

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