PREVIEW / futures_30min / 2013-09-20

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-09-20.parquet
  size:    66 KB
  rows:    2,344

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-09-20 00:00:00	ES	Futures	1769.61	1770.12	1769.35	1769.35	488.0
2013-09-20 00:30:00	ES	Futures	1769.61	1770.12	1769.35	1770.12	360.0
2013-09-20 01:00:00	ES	Futures	1770.12	1770.38	1769.87	1770.38	336.0
2013-09-20 01:30:00	ES	Futures	1770.38	1770.64	1770.12	1770.64	1446.0
2013-09-20 02:00:00	ES	Futures	1770.64	1770.9	1769.87	1770.12	2473.0
2013-09-20 02:30:00	ES	Futures	1769.87	1770.12	1769.09	1770.12	3608.0
2013-09-20 03:00:00	ES	Futures	1770.38	1770.9	1769.35	1770.12	8810.0
2013-09-20 03:30:00	ES	Futures	1770.12	1771.93	1769.61	1771.16	9669.0
2013-09-20 04:00:00	ES	Futures	1771.41	1772.19	1771.16	1771.93	6374.0
2013-09-20 04:30:00	ES	Futures	1771.67	1771.93	1770.9	1771.16	4972.0
2013-09-20 05:00:00	ES	Futures	1771.16	1771.67	1770.64	1771.16	7384.0
2013-09-20 05:30:00	ES	Futures	1771.16	1772.19	1770.9	1771.93	6827.0
2013-09-20 06:00:00	ES	Futures	1771.93	1771.93	1771.41	1771.67	4306.0
2013-09-20 06:30:00	ES	Futures	1771.41	1772.19	1771.16	1771.93	5271.0
2013-09-20 07:00:00	ES	Futures	1771.67	1773.22	1771.67	1772.7	14330.0
2013-09-20 07:30:00	ES	Futures	1772.96	1772.96	1770.64	1770.9	10948.0
2013-09-20 08:00:00	ES	Futures	1771.16	1771.16	1768.32	1769.35	49056.0
2013-09-20 08:30:00	ES	Futures	1769.35	1770.9	1768.58	1770.64	33078.0
2013-09-20 09:00:00	ES	Futures	1770.38	1774.25	1769.87	1773.74	68125.0
2013-09-20 09:30:00	ES	Futures	1773.74	1773.99	1767.54	1769.09	207655.0
2013-09-20 10:00:00	ES	Futures	1768.83	1769.87	1766.25	1768.58	124552.0
2013-09-20 10:30:00	ES	Futures	1768.58	1770.38	1767.8	1769.09	98588.0
2013-09-20 11:00:00	ES	Futures	1768.83	1769.87	1765.48	1766.77	96115.0
2013-09-20 11:30:00	ES	Futures	1766.51	1767.54	1762.13	1762.64	107315.0
2013-09-20 12:00:00	ES	Futures	1762.64	1764.45	1761.1	1761.61	85829.0
2013-09-20 12:30:00	ES	Futures	1761.61	1764.45	1761.1	1763.93	56402.0
2013-09-20 13:00:00	ES	Futures	1763.93	1764.45	1760.32	1761.87	64386.0
2013-09-20 13:30:00	ES	Futures	1761.87	1762.64	1759.55	1759.81	60416.0
2013-09-20 14:00:00	ES	Futures	1759.81	1761.61	1758.52	1761.35	70723.0
2013-09-20 14:30:00	ES	Futures	1761.1	1761.61	1758.26	1760.06	66035.0
2013-09-20 15:00:00	ES	Futures	1760.06	1761.35	1756.71	1756.97	101297.0
2013-09-20 15:30:00	ES	Futures	1756.97	1759.03	1755.42	1756.97	195876.0
2013-09-20 16:00:00	ES	Futures	1756.97	1757.48	1755.42	1756.97	121649.0
2013-09-20 16:30:00	ES	Futures	1756.97	1758.77	1756.97	1758.52	9269.0
2013-09-20 17:00:00	ES	Futures	1758.52	1759.03	1757.74	1758.0	3167.0
2013-09-20 00:00:00	NQ	Futures	3750.06	3750.65	3750.06	3750.35	88.0
2013-09-20 00:30:00	NQ	Futures	3750.35	3752.1	3750.35	3752.1	142.0
2013-09-20 01:00:00	NQ	Futures	3751.52	3752.39	3750.94	3752.39	39.0
2013-09-20 01:30:00	NQ	Futures	3752.39	3753.55	3752.1	3753.26	121.0
2013-09-20 02:00:00	NQ	Futures	3753.26	3754.71	3752.68	3753.84	304.0
2013-09-20 02:30:00	NQ	Futures	3752.97	3754.13	3751.52	3753.26	456.0
2013-09-20 03:00:00	NQ	Futures	3753.26	3754.42	3751.81	3753.26	725.0
2013-09-20 03:30:00	NQ	Futures	3752.97	3758.2	3752.68	3757.62	1508.0
2013-09-20 04:00:00	NQ	Futures	3757.91	3758.78	3756.74	3758.2	1194.0
2013-09-20 04:30:00	NQ	Futures	3758.2	3759.07	3756.74	3757.03	1043.0
2013-09-20 05:00:00	NQ	Futures	3757.03	3758.2	3756.16	3757.03	900.0
2013-09-20 05:30:00	NQ	Futures	3757.03	3759.94	3757.03	3758.78	910.0
2013-09-20 06:00:00	NQ	Futures	3758.78	3758.78	3757.33	3757.91	527.0
2013-09-20 06:30:00	NQ	Futures	3757.91	3759.07	3757.62	3758.49	447.0
2013-09-20 07:00:00	NQ	Futures	3758.78	3760.81	3758.49	3759.94	1249.0

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

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