PREVIEW / futures_30min / 2013-02-20

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-02-20.parquet
  size:    80 KB
  rows:    2,918

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-02-20 00:00:00	ES	Futures	1569.31	1569.57	1568.8	1568.8	2006.0
2013-02-20 00:30:00	ES	Futures	1568.8	1569.05	1568.8	1568.8	1021.0
2013-02-20 01:00:00	ES	Futures	1568.8	1569.05	1568.28	1568.28	2415.0
2013-02-20 01:30:00	ES	Futures	1568.54	1568.54	1567.77	1568.03	3227.0
2013-02-20 02:00:00	ES	Futures	1568.03	1568.54	1567.51	1568.03	3199.0
2013-02-20 02:30:00	ES	Futures	1568.03	1568.54	1567.77	1567.77	3996.0
2013-02-20 03:00:00	ES	Futures	1567.77	1569.57	1567.51	1569.31	16873.0
2013-02-20 03:30:00	ES	Futures	1569.31	1570.34	1568.8	1570.34	10428.0
2013-02-20 04:00:00	ES	Futures	1570.34	1570.34	1569.57	1569.82	6783.0
2013-02-20 04:30:00	ES	Futures	1569.82	1570.34	1569.31	1569.57	11299.0
2013-02-20 05:00:00	ES	Futures	1569.82	1569.82	1568.54	1569.31	13972.0
2013-02-20 05:30:00	ES	Futures	1569.31	1569.82	1568.54	1568.8	8347.0
2013-02-20 06:00:00	ES	Futures	1568.8	1569.05	1568.28	1568.8	8832.0
2013-02-20 06:30:00	ES	Futures	1568.8	1569.05	1567.77	1568.28	7592.0
2013-02-20 07:00:00	ES	Futures	1568.03	1568.54	1566.75	1567.26	13948.0
2013-02-20 07:30:00	ES	Futures	1567.51	1568.03	1566.75	1568.03	13619.0
2013-02-20 08:00:00	ES	Futures	1567.77	1568.03	1567.26	1567.26	10113.0
2013-02-20 08:30:00	ES	Futures	1567.26	1568.8	1566.23	1568.54	30909.0
2013-02-20 09:00:00	ES	Futures	1568.54	1569.31	1567.51	1567.51	22727.0
2013-02-20 09:30:00	ES	Futures	1567.77	1568.28	1564.95	1565.21	169667.0
2013-02-20 10:00:00	ES	Futures	1565.21	1567.77	1565.21	1566.49	104084.0
2013-02-20 10:30:00	ES	Futures	1566.23	1567.51	1564.44	1564.44	94904.0
2013-02-20 11:00:00	ES	Futures	1564.44	1564.69	1561.87	1563.15	157732.0
2013-02-20 11:30:00	ES	Futures	1563.15	1563.15	1559.82	1561.36	106019.0
2013-02-20 12:00:00	ES	Futures	1561.1	1563.15	1560.84	1562.38	66215.0
2013-02-20 12:30:00	ES	Futures	1562.64	1563.67	1561.61	1562.9	61063.0
2013-02-20 13:00:00	ES	Futures	1562.64	1563.15	1560.84	1562.38	43508.0
2013-02-20 13:30:00	ES	Futures	1562.13	1562.38	1560.59	1561.1	40832.0
2013-02-20 14:00:00	ES	Futures	1561.36	1563.41	1558.53	1560.84	187372.0
2013-02-20 14:30:00	ES	Futures	1560.59	1561.36	1554.43	1555.2	178467.0
2013-02-20 15:00:00	ES	Futures	1555.46	1555.46	1550.58	1551.35	188245.0
2013-02-20 15:30:00	ES	Futures	1551.35	1553.15	1548.53	1548.78	256181.0
2013-02-20 16:00:00	ES	Futures	1548.78	1549.3	1546.22	1546.73	126307.0
2013-02-20 16:30:00	ES	Futures	1546.99	1548.01	1546.47	1547.76	14064.0
2013-02-20 17:00:00	ES	Futures	1547.5	1548.01	1546.73	1546.73	3286.0
2013-02-20 18:00:00	ES	Futures	1547.5	1548.01	1546.99	1547.5	5787.0
2013-02-20 18:30:00	ES	Futures	1547.5	1548.53	1546.99	1548.27	3599.0
2013-02-20 19:00:00	ES	Futures	1548.27	1549.04	1548.01	1548.78	4545.0
2013-02-20 19:30:00	ES	Futures	1548.53	1549.04	1548.27	1548.78	2407.0
2013-02-20 20:00:00	ES	Futures	1549.04	1549.55	1548.53	1548.53	4324.0
2013-02-20 20:30:00	ES	Futures	1548.53	1548.78	1547.76	1548.01	3273.0
2013-02-20 21:00:00	ES	Futures	1548.01	1548.01	1546.99	1547.24	3211.0
2013-02-20 21:30:00	ES	Futures	1547.5	1548.01	1547.24	1547.76	2250.0
2013-02-20 22:00:00	ES	Futures	1547.76	1548.01	1546.73	1546.99	3399.0
2013-02-20 22:30:00	ES	Futures	1546.73	1546.99	1545.19	1545.45	7280.0
2013-02-20 23:00:00	ES	Futures	1545.45	1546.22	1545.19	1545.45	3831.0
2013-02-20 23:30:00	ES	Futures	1545.45	1545.96	1545.19	1545.19	5228.0
2013-02-20 00:00:00	NQ	Futures	3244.26	3244.26	3242.51	3242.8	100.0
2013-02-20 00:30:00	NQ	Futures	3242.8	3242.8	3242.51	3242.51	31.0
2013-02-20 01:00:00	NQ	Futures	3242.51	3242.8	3241.64	3241.93	160.0

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

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