PREVIEW / futures_30min / 2013-04-24

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-04-24.parquet
  size:    77 KB
  rows:    2,874

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-24 00:00:00	ES	Futures	1623.04	1623.04	1622.27	1623.04	1488.0
2013-04-24 00:30:00	ES	Futures	1623.04	1623.3	1622.78	1623.3	854.0
2013-04-24 01:00:00	ES	Futures	1623.3	1623.55	1622.01	1622.01	1274.0
2013-04-24 01:30:00	ES	Futures	1622.27	1625.61	1622.27	1624.84	7676.0
2013-04-24 02:00:00	ES	Futures	1624.84	1625.1	1623.81	1623.81	6382.0
2013-04-24 02:30:00	ES	Futures	1623.81	1624.33	1623.81	1623.81	2703.0
2013-04-24 03:00:00	ES	Futures	1624.07	1626.39	1623.55	1625.87	14153.0
2013-04-24 03:30:00	ES	Futures	1625.87	1626.9	1625.36	1626.65	12724.0
2013-04-24 04:00:00	ES	Futures	1626.39	1626.9	1624.33	1624.33	17195.0
2013-04-24 04:30:00	ES	Futures	1624.33	1626.13	1623.81	1624.58	15232.0
2013-04-24 05:00:00	ES	Futures	1624.58	1625.61	1624.07	1624.58	8486.0
2013-04-24 05:30:00	ES	Futures	1624.84	1626.13	1624.58	1626.13	8904.0
2013-04-24 06:00:00	ES	Futures	1625.87	1626.39	1624.33	1624.58	7619.0
2013-04-24 06:30:00	ES	Futures	1624.84	1625.36	1623.04	1623.55	12669.0
2013-04-24 07:00:00	ES	Futures	1623.55	1624.58	1623.3	1624.33	11414.0
2013-04-24 07:30:00	ES	Futures	1624.07	1625.1	1623.04	1623.55	12643.0
2013-04-24 08:00:00	ES	Futures	1623.55	1623.55	1622.01	1622.78	20338.0
2013-04-24 08:30:00	ES	Futures	1622.78	1622.78	1619.69	1620.46	56919.0
2013-04-24 09:00:00	ES	Futures	1620.72	1622.78	1620.21	1621.49	36200.0
2013-04-24 09:30:00	ES	Futures	1621.75	1624.84	1620.72	1622.78	197013.0
2013-04-24 10:00:00	ES	Futures	1623.04	1624.58	1618.4	1620.98	169542.0
2013-04-24 10:30:00	ES	Futures	1620.72	1624.33	1620.72	1623.04	127892.0
2013-04-24 11:00:00	ES	Futures	1623.04	1624.07	1619.95	1622.52	100947.0
2013-04-24 11:30:00	ES	Futures	1622.52	1623.81	1621.24	1622.78	50676.0
2013-04-24 12:00:00	ES	Futures	1622.52	1623.55	1621.24	1622.01	38581.0
2013-04-24 12:30:00	ES	Futures	1621.75	1622.78	1619.69	1621.24	47215.0
2013-04-24 13:00:00	ES	Futures	1621.24	1623.55	1620.98	1622.78	39462.0
2013-04-24 13:30:00	ES	Futures	1622.78	1624.07	1622.27	1623.04	31785.0
2013-04-24 14:00:00	ES	Futures	1622.78	1625.1	1622.52	1624.58	50082.0
2013-04-24 14:30:00	ES	Futures	1624.84	1626.39	1624.33	1626.39	53689.0
2013-04-24 15:00:00	ES	Futures	1626.13	1626.39	1623.55	1623.81	47172.0
2013-04-24 15:30:00	ES	Futures	1623.55	1624.33	1620.72	1622.01	110423.0
2013-04-24 16:00:00	ES	Futures	1622.01	1623.55	1621.24	1621.49	56861.0
2013-04-24 16:30:00	ES	Futures	1621.24	1622.27	1620.72	1622.01	5833.0
2013-04-24 17:00:00	ES	Futures	1622.01	1622.01	1621.24	1621.49	1171.0
2013-04-24 18:00:00	ES	Futures	1620.72	1621.24	1619.69	1620.98	2685.0
2013-04-24 18:30:00	ES	Futures	1620.72	1620.98	1620.21	1620.72	584.0
2013-04-24 19:00:00	ES	Futures	1620.72	1620.98	1620.46	1620.46	534.0
2013-04-24 19:30:00	ES	Futures	1620.72	1621.24	1620.46	1620.72	659.0
2013-04-24 20:00:00	ES	Futures	1620.46	1620.98	1619.43	1620.46	2486.0
2013-04-24 20:30:00	ES	Futures	1620.46	1620.72	1618.4	1618.92	3870.0
2013-04-24 21:00:00	ES	Futures	1618.92	1621.49	1618.66	1620.98	3181.0
2013-04-24 21:30:00	ES	Futures	1620.98	1622.78	1620.98	1621.49	5294.0
2013-04-24 22:00:00	ES	Futures	1621.75	1622.27	1620.72	1622.01	2153.0
2013-04-24 22:30:00	ES	Futures	1622.27	1623.81	1621.75	1623.3	3744.0
2013-04-24 23:00:00	ES	Futures	1623.55	1624.33	1623.04	1624.07	1841.0
2013-04-24 23:30:00	ES	Futures	1623.81	1624.33	1622.52	1624.07	2581.0
2013-04-24 00:00:00	NQ	Futures	3296.43	3296.72	3294.68	3295.56	387.0
2013-04-24 00:30:00	NQ	Futures	3295.85	3296.14	3295.26	3295.56	273.0
2013-04-24 01:00:00	NQ	Futures	3295.85	3296.43	3293.22	3293.81	278.0

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

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