PREVIEW / futures_30min / 2013-07-17

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-07-17.parquet
  size:    77 KB
  rows:    2,818

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-07-17 00:00:00	ES	Futures	1728.81	1729.33	1728.55	1728.81	1029.0
2013-07-17 00:30:00	ES	Futures	1728.81	1729.33	1728.81	1728.81	736.0
2013-07-17 01:00:00	ES	Futures	1728.81	1729.07	1728.55	1729.07	801.0
2013-07-17 01:30:00	ES	Futures	1729.07	1729.07	1727.78	1728.55	2504.0
2013-07-17 02:00:00	ES	Futures	1728.3	1729.33	1727.78	1728.04	3771.0
2013-07-17 02:30:00	ES	Futures	1727.78	1727.78	1727.0	1727.78	2706.0
2013-07-17 03:00:00	ES	Futures	1727.52	1728.81	1726.75	1728.04	9865.0
2013-07-17 03:30:00	ES	Futures	1727.78	1729.07	1727.52	1728.81	6711.0
2013-07-17 04:00:00	ES	Futures	1729.07	1729.33	1727.0	1728.55	8596.0
2013-07-17 04:30:00	ES	Futures	1728.55	1728.81	1723.9	1725.97	18939.0
2013-07-17 05:00:00	ES	Futures	1725.97	1725.97	1722.35	1723.64	12305.0
2013-07-17 05:30:00	ES	Futures	1723.38	1724.16	1723.13	1723.13	5119.0
2013-07-17 06:00:00	ES	Futures	1723.13	1724.94	1723.13	1724.42	4835.0
2013-07-17 06:30:00	ES	Futures	1724.42	1726.75	1724.16	1726.75	6846.0
2013-07-17 07:00:00	ES	Futures	1726.75	1729.85	1726.49	1729.33	19995.0
2013-07-17 07:30:00	ES	Futures	1729.33	1729.33	1726.75	1727.0	13946.0
2013-07-17 08:00:00	ES	Futures	1727.0	1728.55	1727.0	1728.04	13437.0
2013-07-17 08:30:00	ES	Futures	1727.52	1734.5	1727.26	1732.43	88108.0
2013-07-17 09:00:00	ES	Futures	1732.43	1735.79	1732.43	1734.5	43890.0
2013-07-17 09:30:00	ES	Futures	1734.5	1735.53	1730.36	1732.69	177572.0
2013-07-17 10:00:00	ES	Futures	1732.69	1735.53	1732.17	1735.28	108452.0
2013-07-17 10:30:00	ES	Futures	1735.28	1737.6	1731.14	1733.72	160812.0
2013-07-17 11:00:00	ES	Futures	1733.98	1735.53	1731.92	1732.43	81775.0
2013-07-17 11:30:00	ES	Futures	1732.43	1733.47	1730.11	1731.4	65415.0
2013-07-17 12:00:00	ES	Futures	1731.4	1735.28	1731.4	1733.47	57829.0
2013-07-17 12:30:00	ES	Futures	1733.72	1735.02	1733.47	1734.24	30138.0
2013-07-17 13:00:00	ES	Futures	1734.24	1735.79	1733.21	1733.72	46416.0
2013-07-17 13:30:00	ES	Futures	1733.47	1734.5	1732.69	1734.5	49287.0
2013-07-17 14:00:00	ES	Futures	1734.5	1735.02	1733.72	1733.72	34811.0
2013-07-17 14:30:00	ES	Futures	1733.72	1733.98	1730.36	1731.4	64180.0
2013-07-17 15:00:00	ES	Futures	1731.4	1732.69	1730.36	1731.92	55324.0
2013-07-17 15:30:00	ES	Futures	1732.17	1733.47	1729.59	1732.17	110844.0
2013-07-17 16:00:00	ES	Futures	1731.92	1733.98	1731.14	1731.92	75581.0
2013-07-17 16:30:00	ES	Futures	1731.92	1733.21	1731.66	1732.43	7606.0
2013-07-17 17:00:00	ES	Futures	1732.43	1733.98	1732.17	1733.47	2106.0
2013-07-17 18:00:00	ES	Futures	1733.72	1733.98	1732.95	1733.21	2074.0
2013-07-17 18:30:00	ES	Futures	1733.47	1733.47	1732.95	1733.21	455.0
2013-07-17 19:00:00	ES	Futures	1733.21	1733.21	1730.36	1730.62	3150.0
2013-07-17 19:30:00	ES	Futures	1730.62	1731.14	1730.36	1730.88	1702.0
2013-07-17 20:00:00	ES	Futures	1730.88	1731.14	1729.85	1731.14	3410.0
2013-07-17 20:30:00	ES	Futures	1730.88	1731.14	1729.33	1729.33	2534.0
2013-07-17 21:00:00	ES	Futures	1729.59	1730.36	1728.55	1729.33	3696.0
2013-07-17 21:30:00	ES	Futures	1729.59	1730.11	1728.55	1729.85	2748.0
2013-07-17 22:00:00	ES	Futures	1729.85	1730.36	1729.33	1730.36	1103.0
2013-07-17 22:30:00	ES	Futures	1730.11	1730.36	1729.59	1729.59	846.0
2013-07-17 23:00:00	ES	Futures	1729.85	1730.36	1729.59	1729.85	734.0
2013-07-17 23:30:00	ES	Futures	1730.11	1730.36	1729.85	1730.11	1178.0
2013-07-17 00:00:00	NQ	Futures	3593.92	3595.38	3593.92	3594.79	183.0
2013-07-17 00:30:00	NQ	Futures	3594.79	3595.38	3594.5	3595.09	57.0
2013-07-17 01:00:00	NQ	Futures	3595.38	3595.96	3594.79	3595.96	165.0

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

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