PREVIEW / etf_30min / 2014-06-26

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-06-26.parquet
  size:    323 KB
  rows:    11,164

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
2014-06-26 04:00:00	SPY	ETF	195.36	195.37	195.36	195.37	700.0
2014-06-26 04:30:00	SPY	ETF	195.35	195.35	195.25	195.3	5725.0
2014-06-26 05:30:00	SPY	ETF	195.54	195.54	195.38	195.38	2250.0
2014-06-26 06:00:00	SPY	ETF	195.34	195.42	195.34	195.38	6400.0
2014-06-26 06:30:00	SPY	ETF	195.38	195.38	195.25	195.29	3050.0
2014-06-26 07:00:00	SPY	ETF	195.29	195.3	195.24	195.3	32870.0
2014-06-26 07:30:00	SPY	ETF	195.31	195.42	195.27	195.4	58226.0
2014-06-26 08:00:00	SPY	ETF	195.32	195.5	195.32	195.44	158576.0
2014-06-26 08:30:00	SPY	ETF	195.45	195.54	195.34	195.41	297285.0
2014-06-26 09:00:00	SPY	ETF	195.38	195.73	195.34	195.61	9285749.0
2014-06-26 09:30:00	SPY	ETF	195.61	195.63	194.13	194.46	18356671.0
2014-06-26 10:00:00	SPY	ETF	194.45	194.84	194.36	194.74	11082279.0
2014-06-26 10:30:00	SPY	ETF	194.74	194.76	194.42	194.67	5509326.0
2014-06-26 11:00:00	SPY	ETF	194.67	194.97	194.57	194.7699	5002579.0
2014-06-26 11:30:00	SPY	ETF	194.7699	194.92	194.61	194.89	3644079.0
2014-06-26 12:00:00	SPY	ETF	194.885	194.94	194.72	194.79	1934851.0
2014-06-26 12:30:00	SPY	ETF	194.78	194.92	194.71	194.72	1849132.0
2014-06-26 13:00:00	SPY	ETF	194.72	195.26	194.7	195.195	3312950.0
2014-06-26 13:30:00	SPY	ETF	195.2	195.35	195.17	195.2285	3239214.0
2014-06-26 14:00:00	SPY	ETF	195.22	195.32	195.09	195.27	3468071.0
2014-06-26 14:30:00	SPY	ETF	195.27	195.31	195.17	195.215	2397788.0
2014-06-26 15:00:00	SPY	ETF	195.22	195.48	195.19	195.31	3391868.0
2014-06-26 15:30:00	SPY	ETF	195.3	195.47	195.28	195.44	6929123.0
2014-06-26 16:00:00	SPY	ETF	195.45	195.48	194.7914	195.39	2789244.0
2014-06-26 16:30:00	SPY	ETF	195.39	195.44	195.37	195.44	1153837.0
2014-06-26 17:00:00	SPY	ETF	195.39	195.39	195.34	195.38	45835.0
2014-06-26 17:30:00	SPY	ETF	195.37	195.38	195.32	195.35	12049.0
2014-06-26 18:00:00	SPY	ETF	195.33	195.38	195.29	195.38	14231.0
2014-06-26 18:30:00	SPY	ETF	195.37	195.37	195.36	195.36	700.0
2014-06-26 19:00:00	SPY	ETF	195.38	195.39	195.38	195.38	1000.0
2014-06-26 19:30:00	SPY	ETF	195.37	195.39	195.37	195.37	20923.0
2014-06-26 06:30:00	QQQ	ETF	93.17	93.17	93.17	93.17	2500.0
2014-06-26 07:00:00	QQQ	ETF	93.19	93.19	93.19	93.19	600.0
2014-06-26 07:30:00	QQQ	ETF	93.31	93.31	93.3	93.3	5800.0
2014-06-26 08:00:00	QQQ	ETF	93.3	93.34	93.28	93.33	58200.0
2014-06-26 08:30:00	QQQ	ETF	93.3	93.35	93.25	93.29	21081.0
2014-06-26 09:00:00	QQQ	ETF	93.28	93.41	93.26	93.35	152935.0
2014-06-26 09:30:00	QQQ	ETF	93.35	93.36	92.62	92.83	5079287.0
2014-06-26 10:00:00	QQQ	ETF	92.83	92.98	92.7142	92.91	3122330.0
2014-06-26 10:30:00	QQQ	ETF	92.91	92.94	92.75	92.875	1730980.0
2014-06-26 11:00:00	QQQ	ETF	92.88	93.02	92.84	92.95	1244120.0
2014-06-26 11:30:00	QQQ	ETF	92.95	93.04	92.91	93.0	918152.0
2014-06-26 12:00:00	QQQ	ETF	93.0	93.02	92.89	92.92	876280.0
2014-06-26 12:30:00	QQQ	ETF	92.93	92.989	92.871	92.89	719233.0
2014-06-26 13:00:00	QQQ	ETF	92.892	93.1624	92.89	93.13	1273382.0
2014-06-26 13:30:00	QQQ	ETF	93.13	93.2	93.0907	93.14	1212995.0
2014-06-26 14:00:00	QQQ	ETF	93.15	93.195	93.06	93.13	935987.0
2014-06-26 14:30:00	QQQ	ETF	93.13	93.21	93.09	93.16	927181.0
2014-06-26 15:00:00	QQQ	ETF	93.16	93.31	93.145	93.18	1101790.0
2014-06-26 15:30:00	QQQ	ETF	93.18	93.35	93.18	93.34	1757993.0

> showing 50 of 11,164 rows — these rows as CSV

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