PREVIEW / etf_30min / 2014-04-29

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-04-29.parquet
  size:    321 KB
  rows:    11,254

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-04-29 04:00:00	SPY	ETF	187.48	187.54	187.46	187.51	1390.0
2014-04-29 04:30:00	SPY	ETF	187.45	187.58	187.42	187.58	5924.0
2014-04-29 05:00:00	SPY	ETF	187.47	187.58	187.47	187.54	6040.0
2014-04-29 05:30:00	SPY	ETF	187.61	187.7	187.61	187.7	4328.0
2014-04-29 06:00:00	SPY	ETF	187.73	187.77	187.68	187.77	5871.0
2014-04-29 06:30:00	SPY	ETF	187.77	187.78	187.68	187.77	56081.0
2014-04-29 07:00:00	SPY	ETF	187.76	187.78	187.7	187.75	38782.0
2014-04-29 07:30:00	SPY	ETF	187.7	187.75	187.6	187.71	80256.0
2014-04-29 08:00:00	SPY	ETF	187.7	187.77	187.61	187.7	247306.0
2014-04-29 08:30:00	SPY	ETF	187.7	187.77	187.53	187.56	269183.0
2014-04-29 09:00:00	SPY	ETF	187.56	187.67	187.46	187.47	810266.0
2014-04-29 09:30:00	SPY	ETF	187.48	187.97	187.35	187.71	12019671.0
2014-04-29 10:00:00	SPY	ETF	187.7	187.86	187.09	187.12	10839001.0
2014-04-29 10:30:00	SPY	ETF	187.11	187.72	187.08	187.54	7383593.0
2014-04-29 11:00:00	SPY	ETF	187.5301	187.78	187.34	187.75	4914894.0
2014-04-29 11:30:00	SPY	ETF	187.75	187.845	187.61	187.73	3866644.0
2014-04-29 12:00:00	SPY	ETF	187.73	187.895	187.63	187.86	3945843.0
2014-04-29 12:30:00	SPY	ETF	187.86	188.04	187.81	187.955	4048854.0
2014-04-29 13:00:00	SPY	ETF	187.96	187.98	187.67	187.8	3607888.0
2014-04-29 13:30:00	SPY	ETF	187.8	187.985	187.66	187.94	4079408.0
2014-04-29 14:00:00	SPY	ETF	187.94	187.97	187.78	187.81	2664114.0
2014-04-29 14:30:00	SPY	ETF	187.81	187.86	187.7701	187.815	2187330.0
2014-04-29 15:00:00	SPY	ETF	187.82	187.93	187.81	187.91	2811746.0
2014-04-29 15:30:00	SPY	ETF	187.91	187.915	187.68	187.73	9894082.0
2014-04-29 16:00:00	SPY	ETF	187.73	187.8023	186.8954	187.67	6921209.0
2014-04-29 16:30:00	SPY	ETF	187.63	187.69	187.56	187.56	912606.0
2014-04-29 17:00:00	SPY	ETF	187.58	187.62	187.56	187.6	86537.0
2014-04-29 17:30:00	SPY	ETF	187.6	187.66	187.59	187.62	56398.0
2014-04-29 18:00:00	SPY	ETF	187.62	187.63	187.55	187.58	45790.0
2014-04-29 18:30:00	SPY	ETF	187.59	187.62	187.55	187.62	69860.0
2014-04-29 19:00:00	SPY	ETF	187.59	187.62	187.59	187.62	4840.0
2014-04-29 19:30:00	SPY	ETF	187.62	187.62	187.48	187.51	22970.0
2014-04-29 04:00:00	QQQ	ETF	86.75	86.75	86.75	86.75	199.0
2014-04-29 04:30:00	QQQ	ETF	86.82	86.87	86.82	86.87	200.0
2014-04-29 05:00:00	QQQ	ETF	86.87	86.87	86.87	86.87	100.0
2014-04-29 05:30:00	QQQ	ETF	86.88	86.95	86.87	86.95	5800.0
2014-04-29 06:00:00	QQQ	ETF	87.01	87.01	86.97	86.97	400.0
2014-04-29 06:30:00	QQQ	ETF	86.98	86.99	86.98	86.98	9900.0
2014-04-29 07:00:00	QQQ	ETF	86.98	87.02	86.96	87.02	47007.0
2014-04-29 07:30:00	QQQ	ETF	86.97	86.97	86.87	86.92	12100.0
2014-04-29 08:00:00	QQQ	ETF	86.91	87.04	86.88	86.89	90575.0
2014-04-29 08:30:00	QQQ	ETF	86.88	86.91	86.71	86.73	116452.0
2014-04-29 09:00:00	QQQ	ETF	86.74	86.84	86.7	86.74	117973.0
2014-04-29 09:30:00	QQQ	ETF	86.75	87.04	86.505	86.77	8485093.0
2014-04-29 10:00:00	QQQ	ETF	86.7701	86.88	86.32	86.35	4802628.0
2014-04-29 10:30:00	QQQ	ETF	86.35	86.9	86.31	86.75	3830205.0
2014-04-29 11:00:00	QQQ	ETF	86.76	87.0	86.58	86.99	2704499.0
2014-04-29 11:30:00	QQQ	ETF	86.99	87.04	86.85	86.93	1614949.0
2014-04-29 12:00:00	QQQ	ETF	86.93	87.16	86.901	87.14	1617350.0
2014-04-29 12:30:00	QQQ	ETF	87.15	87.32	87.12	87.22	1504894.0

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

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