PREVIEW / futures_30min / 2013-04-01

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-04-01.parquet
  size:    63 KB
  rows:    2,308

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-01 00:00:00	ES	Futures	1608.87	1609.39	1608.61	1608.61	751.0
2013-04-01 00:30:00	ES	Futures	1608.87	1610.16	1606.55	1608.1	5294.0
2013-04-01 01:00:00	ES	Futures	1608.36	1608.87	1607.33	1607.33	1611.0
2013-04-01 01:30:00	ES	Futures	1607.58	1608.87	1606.81	1607.33	1861.0
2013-04-01 02:00:00	ES	Futures	1607.07	1607.84	1606.81	1607.58	1634.0
2013-04-01 02:30:00	ES	Futures	1607.58	1607.84	1607.33	1607.33	175.0
2013-04-01 03:00:00	ES	Futures	1607.33	1608.87	1607.33	1608.1	1719.0
2013-04-01 03:30:00	ES	Futures	1608.1	1608.36	1607.33	1607.58	788.0
2013-04-01 04:00:00	ES	Futures	1607.58	1607.84	1606.81	1606.81	1698.0
2013-04-01 04:30:00	ES	Futures	1607.33	1607.84	1606.81	1607.84	1691.0
2013-04-01 05:00:00	ES	Futures	1607.84	1608.1	1607.33	1607.58	805.0
2013-04-01 05:30:00	ES	Futures	1607.58	1607.58	1606.55	1607.33	1284.0
2013-04-01 06:00:00	ES	Futures	1607.33	1608.61	1607.07	1608.61	1352.0
2013-04-01 06:30:00	ES	Futures	1608.36	1609.39	1608.36	1608.87	3065.0
2013-04-01 07:00:00	ES	Futures	1609.13	1610.42	1608.87	1610.16	1951.0
2013-04-01 07:30:00	ES	Futures	1610.42	1611.45	1609.9	1609.9	4026.0
2013-04-01 08:00:00	ES	Futures	1609.9	1611.19	1609.64	1610.67	5824.0
2013-04-01 08:30:00	ES	Futures	1610.67	1610.67	1609.39	1609.9	7231.0
2013-04-01 09:00:00	ES	Futures	1609.64	1610.16	1608.61	1608.87	15575.0
2013-04-01 09:30:00	ES	Futures	1608.87	1612.48	1608.61	1609.39	87611.0
2013-04-01 10:00:00	ES	Futures	1609.39	1610.67	1604.75	1607.58	169024.0
2013-04-01 10:30:00	ES	Futures	1607.84	1607.84	1601.4	1601.66	139322.0
2013-04-01 11:00:00	ES	Futures	1601.4	1602.69	1600.37	1602.43	84504.0
2013-04-01 11:30:00	ES	Futures	1602.17	1603.98	1601.66	1602.43	62068.0
2013-04-01 12:00:00	ES	Futures	1602.43	1603.2	1600.89	1602.17	46771.0
2013-04-01 12:30:00	ES	Futures	1602.17	1603.72	1600.89	1603.46	40062.0
2013-04-01 13:00:00	ES	Futures	1603.72	1605.78	1603.2	1605.27	48106.0
2013-04-01 13:30:00	ES	Futures	1605.27	1605.52	1603.46	1603.98	32125.0
2013-04-01 14:00:00	ES	Futures	1603.98	1605.27	1603.2	1603.46	34442.0
2013-04-01 14:30:00	ES	Futures	1603.72	1603.98	1601.66	1602.17	39982.0
2013-04-01 15:00:00	ES	Futures	1602.17	1603.46	1599.86	1600.89	69882.0
2013-04-01 15:30:00	ES	Futures	1601.14	1603.72	1599.6	1603.72	125737.0
2013-04-01 16:00:00	ES	Futures	1603.72	1603.98	1602.17	1602.69	66756.0
2013-04-01 16:30:00	ES	Futures	1602.95	1603.46	1602.43	1602.95	4793.0
2013-04-01 17:00:00	ES	Futures	1602.95	1603.98	1602.95	1603.72	2000.0
2013-04-01 18:00:00	ES	Futures	1603.46	1603.98	1602.95	1603.72	2044.0
2013-04-01 18:30:00	ES	Futures	1603.46	1603.46	1602.43	1603.2	1264.0
2013-04-01 19:00:00	ES	Futures	1603.2	1603.46	1602.69	1603.2	927.0
2013-04-01 19:30:00	ES	Futures	1603.2	1604.24	1602.95	1603.98	2360.0
2013-04-01 20:00:00	ES	Futures	1603.72	1603.98	1601.4	1603.2	7023.0
2013-04-01 20:30:00	ES	Futures	1602.95	1603.2	1602.17	1602.17	2774.0
2013-04-01 21:00:00	ES	Futures	1602.43	1603.2	1601.92	1602.95	2793.0
2013-04-01 21:30:00	ES	Futures	1603.2	1605.01	1602.95	1604.75	4848.0
2013-04-01 22:00:00	ES	Futures	1604.49	1605.78	1603.98	1604.75	4313.0
2013-04-01 22:30:00	ES	Futures	1605.01	1605.52	1604.49	1604.49	1967.0
2013-04-01 23:00:00	ES	Futures	1604.75	1605.01	1603.46	1603.46	2061.0
2013-04-01 23:30:00	ES	Futures	1603.72	1604.49	1603.46	1603.72	1568.0
2013-04-01 00:00:00	NQ	Futures	3280.39	3280.39	3279.22	3279.51	58.0
2013-04-01 00:30:00	NQ	Futures	3278.93	3282.14	3275.43	3277.76	514.0
2013-04-01 01:00:00	NQ	Futures	3278.35	3279.51	3276.31	3276.31	92.0

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

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