PREVIEW / etf_30min / 2016-03-07

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-03-07.parquet
  size:    396 KB
  rows:    13,429

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-03-07 04:00:00	SPY	ETF	199.85	200.16	199.72	200.02	17755.0
2016-03-07 04:30:00	SPY	ETF	199.94	199.94	199.45	199.45	8301.0
2016-03-07 05:00:00	SPY	ETF	199.45	199.5	199.19	199.33	5553.0
2016-03-07 05:30:00	SPY	ETF	199.35	199.37	199.19	199.2	15031.0
2016-03-07 06:00:00	SPY	ETF	199.28	199.43	199.27	199.43	9088.0
2016-03-07 06:30:00	SPY	ETF	199.39	199.4	199.27	199.29	24216.0
2016-03-07 07:00:00	SPY	ETF	199.29	199.55	199.28	199.48	82570.0
2016-03-07 07:30:00	SPY	ETF	199.46	199.53	199.29	199.49	148236.0
2016-03-07 08:00:00	SPY	ETF	199.38	199.78	199.25	199.46	395699.0
2016-03-07 08:30:00	SPY	ETF	199.43	199.43	199.08	199.24	625447.0
2016-03-07 09:00:00	SPY	ETF	199.23	199.415	199.23	199.35	539915.0
2016-03-07 09:30:00	SPY	ETF	199.34	199.86	199.25	199.47	10223901.0
2016-03-07 10:00:00	SPY	ETF	199.47	200.1	199.33	199.81	7151614.0
2016-03-07 10:30:00	SPY	ETF	199.8	200.44	199.7601	200.07	7040020.0
2016-03-07 11:00:00	SPY	ETF	200.07	200.41	199.93	200.27	6100881.0
2016-03-07 11:30:00	SPY	ETF	200.26	200.98	200.25	200.65	5937446.0
2016-03-07 12:00:00	SPY	ETF	200.64	200.77	200.44	200.62	3948046.0
2016-03-07 12:30:00	SPY	ETF	200.625	200.86	200.6043	200.75	3659727.0
2016-03-07 13:00:00	SPY	ETF	200.7425	201.07	200.5	200.51	4244525.0
2016-03-07 13:30:00	SPY	ETF	200.51	200.53	200.18	200.3776	4245035.0
2016-03-07 14:00:00	SPY	ETF	200.38	200.53	199.83	199.92	4560310.0
2016-03-07 14:30:00	SPY	ETF	199.91	199.94	199.49	199.82	6688439.0
2016-03-07 15:00:00	SPY	ETF	199.8101	200.39	199.48	200.25	7502663.0
2016-03-07 15:30:00	SPY	ETF	200.26	200.66	200.14	200.59	12212823.0
2016-03-07 16:00:00	SPY	ETF	200.61	200.8	200.3191	200.57	11688969.0
2016-03-07 16:30:00	SPY	ETF	200.56	200.66	200.49	200.62	1192431.0
2016-03-07 17:00:00	SPY	ETF	200.6	200.65	200.53	200.57	124941.0
2016-03-07 17:30:00	SPY	ETF	200.57	200.59	200.36	200.58	267348.0
2016-03-07 18:00:00	SPY	ETF	200.56	200.56	200.4	200.48	97333.0
2016-03-07 18:30:00	SPY	ETF	200.48	200.63	200.48	200.59	28050.0
2016-03-07 19:00:00	SPY	ETF	200.62	200.62	200.38	200.38	55590.0
2016-03-07 19:30:00	SPY	ETF	200.38	200.43	200.25	200.26	202454.0
2016-03-07 04:00:00	QQQ	ETF	105.27	105.35	105.27	105.35	716.0
2016-03-07 04:30:00	QQQ	ETF	105.35	105.35	105.24	105.24	460.0
2016-03-07 05:00:00	QQQ	ETF	105.15	105.15	105.02	105.08	2300.0
2016-03-07 05:30:00	QQQ	ETF	105.02	105.04	105.02	105.04	204.0
2016-03-07 06:00:00	QQQ	ETF	105.1	105.1	105.04	105.05	2498.0
2016-03-07 06:30:00	QQQ	ETF	105.05	105.08	105.05	105.08	5300.0
2016-03-07 07:00:00	QQQ	ETF	105.03	105.14	105.02	105.14	6398.0
2016-03-07 07:30:00	QQQ	ETF	105.12	105.22	105.1	105.22	22962.0
2016-03-07 08:00:00	QQQ	ETF	105.24	105.24	105.1	105.15	21692.0
2016-03-07 08:30:00	QQQ	ETF	105.16	105.16	105.0	105.04	26178.0
2016-03-07 09:00:00	QQQ	ETF	105.08	105.17	105.07	105.08	24957.0
2016-03-07 09:30:00	QQQ	ETF	105.12	105.3025	104.76	104.79	3134039.0
2016-03-07 10:00:00	QQQ	ETF	104.77	105.07	104.66	104.75	2014388.0
2016-03-07 10:30:00	QQQ	ETF	104.755	105.15	104.729	105.02	1604769.0
2016-03-07 11:00:00	QQQ	ETF	105.02	105.35	104.9	105.23	1557673.0
2016-03-07 11:30:00	QQQ	ETF	105.2301	105.74	105.2301	105.48	1807995.0
2016-03-07 12:00:00	QQQ	ETF	105.48	105.55	105.35	105.4464	1011996.0
2016-03-07 12:30:00	QQQ	ETF	105.45	105.6	105.44	105.46	751443.0

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

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