PREVIEW / futures_30min / 2013-03-31

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-03-31.parquet
  size:    20 KB
  rows:    520

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-03-31 18:00:00	ES	Futures	1610.42	1611.19	1609.13	1609.39	3035.0
2013-03-31 18:30:00	ES	Futures	1609.39	1610.42	1609.39	1610.16	599.0
2013-03-31 19:00:00	ES	Futures	1610.16	1611.45	1610.16	1610.93	1802.0
2013-03-31 19:30:00	ES	Futures	1610.93	1611.45	1610.42	1610.42	1387.0
2013-03-31 20:00:00	ES	Futures	1610.67	1610.67	1609.39	1609.39	1583.0
2013-03-31 20:30:00	ES	Futures	1609.39	1609.64	1607.33	1607.84	4637.0
2013-03-31 21:00:00	ES	Futures	1607.84	1608.1	1606.55	1606.81	4512.0
2013-03-31 21:30:00	ES	Futures	1606.81	1608.61	1606.55	1608.1	3293.0
2013-03-31 22:00:00	ES	Futures	1608.1	1608.36	1607.84	1608.1	830.0
2013-03-31 22:30:00	ES	Futures	1608.1	1608.61	1607.84	1608.36	632.0
2013-03-31 23:00:00	ES	Futures	1608.1	1608.61	1608.1	1608.36	447.0
2013-03-31 23:30:00	ES	Futures	1608.1	1608.87	1607.33	1608.61	1346.0
2013-03-31 18:00:00	NQ	Futures	3279.51	3282.72	3279.51	3280.97	311.0
2013-03-31 18:30:00	NQ	Futures	3280.68	3282.43	3280.68	3282.14	107.0
2013-03-31 19:00:00	NQ	Futures	3282.43	3284.18	3282.14	3283.31	132.0
2013-03-31 19:30:00	NQ	Futures	3283.31	3284.18	3282.14	3282.43	54.0
2013-03-31 20:00:00	NQ	Futures	3282.14	3282.72	3281.26	3281.26	82.0
2013-03-31 20:30:00	NQ	Futures	3281.26	3281.26	3277.47	3277.47	607.0
2013-03-31 21:00:00	NQ	Futures	3278.06	3278.06	3275.72	3276.01	362.0
2013-03-31 21:30:00	NQ	Futures	3275.72	3278.93	3275.43	3278.64	268.0
2013-03-31 22:00:00	NQ	Futures	3278.06	3278.64	3277.76	3277.76	89.0
2013-03-31 22:30:00	NQ	Futures	3278.06	3278.93	3278.06	3278.35	47.0
2013-03-31 23:00:00	NQ	Futures	3278.35	3279.22	3278.06	3278.93	94.0
2013-03-31 23:30:00	NQ	Futures	3278.64	3280.39	3276.89	3280.1	107.0
2013-03-31 18:00:00	YM	Futures	14666.8	14666.8	14650.6	14650.6	213.0
2013-03-31 18:30:00	YM	Futures	14650.6	14659.7	14650.6	14657.7	64.0
2013-03-31 19:00:00	YM	Futures	14658.7	14666.8	14658.7	14661.7	93.0
2013-03-31 19:30:00	YM	Futures	14661.7	14664.8	14658.7	14661.7	75.0
2013-03-31 20:00:00	YM	Futures	14661.7	14662.7	14653.6	14653.6	99.0
2013-03-31 20:30:00	YM	Futures	14653.6	14654.7	14639.5	14641.5	309.0
2013-03-31 21:00:00	YM	Futures	14640.5	14640.5	14631.4	14637.5	601.0
2013-03-31 21:30:00	YM	Futures	14636.5	14649.6	14635.5	14649.6	529.0
2013-03-31 22:00:00	YM	Futures	14649.6	14651.6	14647.6	14647.6	184.0
2013-03-31 22:30:00	YM	Futures	14647.6	14651.6	14647.6	14648.6	137.0
2013-03-31 23:00:00	YM	Futures	14648.6	14652.6	14648.6	14650.6	101.0
2013-03-31 23:30:00	YM	Futures	14649.6	14653.6	14642.5	14652.6	167.0
2013-03-31 18:00:00	CL	Futures	154.07	154.77	153.68	153.93	2367.0
2013-03-31 18:30:00	CL	Futures	153.91	153.99	153.85	153.96	281.0
2013-03-31 19:00:00	CL	Futures	153.94	153.94	153.79	153.88	175.0
2013-03-31 19:30:00	CL	Futures	153.88	153.94	153.79	153.85	404.0
2013-03-31 20:00:00	CL	Futures	153.85	153.87	153.53	153.72	808.0
2013-03-31 20:30:00	CL	Futures	153.74	153.74	153.45	153.61	482.0
2013-03-31 21:00:00	CL	Futures	153.61	153.64	153.38	153.57	520.0
2013-03-31 21:30:00	CL	Futures	153.57	153.66	153.52	153.58	368.0
2013-03-31 22:00:00	CL	Futures	153.58	153.63	153.15	153.17	837.0
2013-03-31 22:30:00	CL	Futures	153.17	153.19	153.06	153.06	459.0
2013-03-31 23:00:00	CL	Futures	153.06	153.19	153.01	153.11	311.0
2013-03-31 23:30:00	CL	Futures	153.12	153.3	153.07	153.3	303.0
2013-03-31 18:00:00	GC	Futures	2194.9	2199.7	2192.5	2194.2	1530.0
2013-03-31 18:30:00	GC	Futures	2194.4	2196.4	2194.4	2194.9	348.0

> showing 50 of 520 rows — these rows as CSV

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