PREVIEW / etf_30min / 2016-04-21

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-04-21.parquet
  size:    397 KB
  rows:    13,456

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
2016-04-21 04:00:00	SPY	ETF	210.36	210.45	210.36	210.44	4049.0
2016-04-21 04:30:00	SPY	ETF	210.31	210.49	210.29	210.49	3613.0
2016-04-21 05:00:00	SPY	ETF	210.44	210.44	210.21	210.24	5971.0
2016-04-21 05:30:00	SPY	ETF	210.28	210.39	210.24	210.29	10675.0
2016-04-21 06:00:00	SPY	ETF	210.38	210.38	210.09	210.12	6432.0
2016-04-21 06:30:00	SPY	ETF	210.24	210.33	210.15	210.33	18378.0
2016-04-21 07:00:00	SPY	ETF	210.36	210.39	210.28	210.35	33774.0
2016-04-21 07:30:00	SPY	ETF	210.35	210.44	210.17	210.17	109000.0
2016-04-21 08:00:00	SPY	ETF	210.19	210.65	210.15	210.5	168192.0
2016-04-21 08:30:00	SPY	ETF	210.46	210.55	210.1	210.25	514644.0
2016-04-21 09:00:00	SPY	ETF	210.21	210.3	210.02	210.14	425252.0
2016-04-21 09:30:00	SPY	ETF	210.12	210.25	209.52	209.53	7762718.0
2016-04-21 10:00:00	SPY	ETF	209.53	209.86	209.34	209.67	6756927.0
2016-04-21 10:30:00	SPY	ETF	209.67	210.13	209.5301	210.01	4722441.0
2016-04-21 11:00:00	SPY	ETF	210.02	210.17	209.72	209.91	3712191.0
2016-04-21 11:30:00	SPY	ETF	209.92	210.16	209.45	209.47	3234497.0
2016-04-21 12:00:00	SPY	ETF	209.48	209.55	209.29	209.49	4020075.0
2016-04-21 12:30:00	SPY	ETF	209.485	209.7	209.32	209.41	2766586.0
2016-04-21 13:00:00	SPY	ETF	209.4	209.61	209.19	209.2	3437773.0
2016-04-21 13:30:00	SPY	ETF	209.19	209.43	209.0	209.0761	4531257.0
2016-04-21 14:00:00	SPY	ETF	209.0703	209.16	208.93	208.99	6126182.0
2016-04-21 14:30:00	SPY	ETF	208.97	208.9899	208.65	208.94	6206603.0
2016-04-21 15:00:00	SPY	ETF	208.93	209.16	208.68	208.7	5461568.0
2016-04-21 15:30:00	SPY	ETF	208.69	209.14	208.69	208.96	10988112.0
2016-04-21 16:00:00	SPY	ETF	208.96	209.28	208.55	208.62	6976960.0
2016-04-21 16:30:00	SPY	ETF	208.63	208.97	208.28	208.65	3946538.0
2016-04-21 17:00:00	SPY	ETF	208.55	208.64	208.39	208.4	317291.0
2016-04-21 17:30:00	SPY	ETF	208.4	208.43	208.28	208.36	929673.0
2016-04-21 18:00:00	SPY	ETF	208.38	208.4	208.19	208.22	281765.0
2016-04-21 18:30:00	SPY	ETF	208.22	208.53	208.22	208.45	113565.0
2016-04-21 19:00:00	SPY	ETF	208.48	208.54	208.45	208.45	38904.0
2016-04-21 19:30:00	SPY	ETF	208.45	208.6	208.45	208.5	30608.0
2016-04-21 04:00:00	QQQ	ETF	110.72	110.72	110.72	110.72	200.0
2016-04-21 04:30:00	QQQ	ETF	110.73	110.73	110.73	110.73	398.0
2016-04-21 06:00:00	QQQ	ETF	110.51	110.51	110.51	110.51	300.0
2016-04-21 06:30:00	QQQ	ETF	110.57	110.57	110.55	110.55	1280.0
2016-04-21 07:30:00	QQQ	ETF	110.6	110.71	110.6	110.66	4358.0
2016-04-21 08:00:00	QQQ	ETF	110.71	110.8	110.65	110.79	22060.0
2016-04-21 08:30:00	QQQ	ETF	110.75	110.85	110.59	110.61	67809.0
2016-04-21 09:00:00	QQQ	ETF	110.6	110.67	110.54	110.6	94990.0
2016-04-21 09:30:00	QQQ	ETF	110.59	110.65	110.15	110.27	2084025.0
2016-04-21 10:00:00	QQQ	ETF	110.26	110.56	110.17	110.5	1521341.0
2016-04-21 10:30:00	QQQ	ETF	110.5	110.96	110.44	110.935	985836.0
2016-04-21 11:00:00	QQQ	ETF	110.9305	111.05	110.741	110.91	709934.0
2016-04-21 11:30:00	QQQ	ETF	110.9	110.94	110.49	110.52	873636.0
2016-04-21 12:00:00	QQQ	ETF	110.52	110.58	110.37	110.51	760794.0
2016-04-21 12:30:00	QQQ	ETF	110.51	110.66	110.48	110.51	634677.0
2016-04-21 13:00:00	QQQ	ETF	110.51	110.64	110.43	110.52	562868.0
2016-04-21 13:30:00	QQQ	ETF	110.52	110.76	110.49	110.56	705520.0
2016-04-21 14:00:00	QQQ	ETF	110.56	110.61	110.43	110.515	585906.0

> showing 50 of 13,456 rows — these rows as CSV

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