PREVIEW / futures_30min / 2013-09-30

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-09-30.parquet
  size:    76 KB
  rows:    2,847

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-30 00:00:00	ES	Futures	1729.37	1729.37	1727.82	1728.08	1317.0
2013-09-30 00:30:00	ES	Futures	1728.08	1728.59	1728.08	1728.08	730.0
2013-09-30 01:00:00	ES	Futures	1728.33	1729.11	1728.08	1728.33	2068.0
2013-09-30 01:30:00	ES	Futures	1728.33	1729.37	1728.08	1728.59	2580.0
2013-09-30 02:00:00	ES	Futures	1728.59	1728.59	1726.01	1727.04	9584.0
2013-09-30 02:30:00	ES	Futures	1727.04	1727.3	1724.47	1726.01	6257.0
2013-09-30 03:00:00	ES	Futures	1726.01	1728.85	1725.24	1728.08	17696.0
2013-09-30 03:30:00	ES	Futures	1728.33	1728.33	1725.24	1726.27	10434.0
2013-09-30 04:00:00	ES	Futures	1726.53	1728.33	1725.76	1727.82	8987.0
2013-09-30 04:30:00	ES	Futures	1727.82	1728.85	1727.3	1727.82	7910.0
2013-09-30 05:00:00	ES	Futures	1728.08	1729.11	1727.56	1727.56	6722.0
2013-09-30 05:30:00	ES	Futures	1727.82	1727.82	1726.53	1726.79	4628.0
2013-09-30 06:00:00	ES	Futures	1726.79	1727.82	1725.76	1726.01	8688.0
2013-09-30 06:30:00	ES	Futures	1726.01	1726.27	1723.95	1724.98	12590.0
2013-09-30 07:00:00	ES	Futures	1724.98	1726.79	1724.47	1726.01	10426.0
2013-09-30 07:30:00	ES	Futures	1726.01	1727.04	1723.69	1723.95	19256.0
2013-09-30 08:00:00	ES	Futures	1724.21	1725.24	1723.69	1724.47	16422.0
2013-09-30 08:30:00	ES	Futures	1724.72	1724.98	1722.66	1724.21	33833.0
2013-09-30 09:00:00	ES	Futures	1724.21	1724.98	1722.66	1723.18	24752.0
2013-09-30 09:30:00	ES	Futures	1723.18	1727.3	1719.82	1724.47	233505.0
2013-09-30 10:00:00	ES	Futures	1724.72	1730.14	1724.47	1728.59	133278.0
2013-09-30 10:30:00	ES	Futures	1728.85	1731.69	1727.82	1730.4	130124.0
2013-09-30 11:00:00	ES	Futures	1730.4	1730.91	1727.56	1729.11	112630.0
2013-09-30 11:30:00	ES	Futures	1729.11	1731.95	1729.11	1731.43	105109.0
2013-09-30 12:00:00	ES	Futures	1731.69	1731.69	1727.82	1728.85	87690.0
2013-09-30 12:30:00	ES	Futures	1728.85	1730.91	1728.33	1729.62	59322.0
2013-09-30 13:00:00	ES	Futures	1729.62	1734.53	1729.62	1731.43	112381.0
2013-09-30 13:30:00	ES	Futures	1731.69	1734.53	1727.82	1729.62	126083.0
2013-09-30 14:00:00	ES	Futures	1729.62	1731.69	1728.85	1730.14	61785.0
2013-09-30 14:30:00	ES	Futures	1730.14	1732.72	1729.88	1730.14	83310.0
2013-09-30 15:00:00	ES	Futures	1730.14	1730.4	1724.98	1727.3	142911.0
2013-09-30 15:30:00	ES	Futures	1727.3	1729.11	1724.47	1729.11	329580.0
2013-09-30 16:00:00	ES	Futures	1729.11	1732.98	1728.59	1731.43	147078.0
2013-09-30 16:30:00	ES	Futures	1731.43	1732.2	1729.88	1731.17	9832.0
2013-09-30 17:00:00	ES	Futures	1731.17	1732.46	1730.91	1732.2	2704.0
2013-09-30 18:00:00	ES	Futures	1731.95	1733.24	1730.91	1730.91	5466.0
2013-09-30 18:30:00	ES	Futures	1731.17	1732.46	1730.91	1731.17	2466.0
2013-09-30 19:00:00	ES	Futures	1731.43	1731.95	1731.17	1731.43	1003.0
2013-09-30 19:30:00	ES	Futures	1731.69	1731.69	1730.66	1730.91	2579.0
2013-09-30 20:00:00	ES	Futures	1730.66	1731.95	1730.66	1731.69	2016.0
2013-09-30 20:30:00	ES	Futures	1731.43	1732.46	1730.66	1731.95	5041.0
2013-09-30 21:00:00	ES	Futures	1731.95	1733.24	1730.91	1732.46	4527.0
2013-09-30 21:30:00	ES	Futures	1732.46	1735.3	1732.46	1734.78	6402.0
2013-09-30 22:00:00	ES	Futures	1734.78	1737.62	1734.78	1736.33	11203.0
2013-09-30 22:30:00	ES	Futures	1736.07	1736.33	1732.46	1732.98	10394.0
2013-09-30 23:00:00	ES	Futures	1732.98	1732.98	1729.88	1732.2	6419.0
2013-09-30 23:30:00	ES	Futures	1732.2	1732.2	1729.88	1729.88	2647.0
2013-09-30 00:00:00	NQ	Futures	3727.99	3728.28	3725.09	3725.38	213.0
2013-09-30 00:30:00	NQ	Futures	3725.96	3726.54	3725.38	3725.67	146.0
2013-09-30 01:00:00	NQ	Futures	3725.96	3727.7	3725.09	3725.38	238.0

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

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