PREVIEW / futures_30min / 2013-09-18

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-09-18.parquet
  size:    80 KB
  rows:    2,849

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-18 00:00:00	ES	Futures	1753.61	1753.87	1753.1	1753.36	563.0
2013-09-18 00:30:00	ES	Futures	1753.36	1753.61	1753.1	1753.36	409.0
2013-09-18 01:00:00	ES	Futures	1753.36	1753.61	1753.1	1753.61	487.0
2013-09-18 01:30:00	ES	Futures	1753.61	1754.13	1753.36	1753.87	1414.0
2013-09-18 02:00:00	ES	Futures	1754.13	1754.13	1752.84	1753.1	2730.0
2013-09-18 02:30:00	ES	Futures	1753.1	1753.61	1752.84	1753.61	1729.0
2013-09-18 03:00:00	ES	Futures	1753.36	1754.13	1752.33	1752.58	8349.0
2013-09-18 03:30:00	ES	Futures	1752.33	1753.36	1752.07	1752.84	5480.0
2013-09-18 04:00:00	ES	Futures	1753.1	1754.9	1753.1	1754.39	7037.0
2013-09-18 04:30:00	ES	Futures	1754.65	1754.9	1753.87	1754.65	7197.0
2013-09-18 05:00:00	ES	Futures	1754.9	1755.68	1753.87	1755.42	8367.0
2013-09-18 05:30:00	ES	Futures	1755.42	1755.94	1754.13	1754.65	7749.0
2013-09-18 06:00:00	ES	Futures	1754.39	1754.9	1753.87	1754.13	7102.0
2013-09-18 06:30:00	ES	Futures	1754.39	1754.65	1753.36	1754.39	8112.0
2013-09-18 07:00:00	ES	Futures	1754.39	1754.65	1753.36	1753.61	5470.0
2013-09-18 07:30:00	ES	Futures	1753.87	1754.39	1753.1	1753.61	6735.0
2013-09-18 08:00:00	ES	Futures	1753.61	1754.39	1752.58	1753.1	20468.0
2013-09-18 08:30:00	ES	Futures	1753.1	1753.61	1752.33	1752.58	13983.0
2013-09-18 09:00:00	ES	Futures	1752.58	1753.1	1751.29	1751.81	21783.0
2013-09-18 09:30:00	ES	Futures	1751.81	1753.1	1751.04	1751.81	110931.0
2013-09-18 10:00:00	ES	Futures	1751.81	1753.36	1749.49	1750.0	85928.0
2013-09-18 10:30:00	ES	Futures	1750.0	1750.52	1748.46	1750.0	78127.0
2013-09-18 11:00:00	ES	Futures	1750.0	1750.52	1748.97	1750.0	42563.0
2013-09-18 11:30:00	ES	Futures	1750.0	1750.26	1747.94	1748.46	53540.0
2013-09-18 12:00:00	ES	Futures	1748.2	1748.71	1747.17	1747.94	58350.0
2013-09-18 12:30:00	ES	Futures	1747.94	1749.49	1747.42	1749.23	28271.0
2013-09-18 13:00:00	ES	Futures	1748.97	1751.55	1748.97	1750.78	51731.0
2013-09-18 13:30:00	ES	Futures	1750.78	1751.29	1748.97	1749.49	36606.0
2013-09-18 14:00:00	ES	Futures	1749.75	1771.67	1749.75	1768.32	492475.0
2013-09-18 14:30:00	ES	Futures	1768.32	1777.35	1766.51	1777.09	217634.0
2013-09-18 15:00:00	ES	Futures	1777.35	1778.12	1771.41	1771.93	193711.0
2013-09-18 15:30:00	ES	Futures	1771.93	1774.51	1770.9	1773.48	207132.0
2013-09-18 16:00:00	ES	Futures	1773.48	1773.99	1771.93	1772.7	104316.0
2013-09-18 16:30:00	ES	Futures	1772.7	1773.22	1772.19	1773.22	7618.0
2013-09-18 17:00:00	ES	Futures	1772.96	1773.74	1772.96	1773.74	3837.0
2013-09-18 18:00:00	ES	Futures	1773.22	1774.25	1773.22	1773.48	4280.0
2013-09-18 18:30:00	ES	Futures	1773.74	1774.51	1773.22	1773.99	3024.0
2013-09-18 19:00:00	ES	Futures	1774.25	1775.28	1773.74	1775.28	5154.0
2013-09-18 19:30:00	ES	Futures	1775.03	1775.28	1773.99	1774.25	2945.0
2013-09-18 20:00:00	ES	Futures	1774.25	1774.51	1773.22	1773.48	3714.0
2013-09-18 20:30:00	ES	Futures	1773.22	1773.99	1772.96	1773.48	2144.0
2013-09-18 21:00:00	ES	Futures	1773.48	1773.74	1772.96	1773.48	2526.0
2013-09-18 21:30:00	ES	Futures	1773.48	1774.25	1773.22	1774.25	1885.0
2013-09-18 22:00:00	ES	Futures	1774.25	1775.28	1773.99	1775.28	4286.0
2013-09-18 22:30:00	ES	Futures	1775.03	1775.54	1774.25	1775.28	2623.0
2013-09-18 23:00:00	ES	Futures	1775.28	1775.54	1773.99	1773.99	2560.0
2013-09-18 23:30:00	ES	Futures	1774.25	1774.25	1773.48	1773.74	3241.0
2013-09-18 00:00:00	NQ	Futures	3706.21	3707.08	3705.92	3706.21	107.0
2013-09-18 00:30:00	NQ	Futures	3706.5	3707.08	3705.92	3706.21	114.0
2013-09-18 01:00:00	NQ	Futures	3705.92	3707.08	3705.92	3706.79	54.0

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

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