PREVIEW / etf_30min / 2015-09-10

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-09-10.parquet
  size:    373 KB
  rows:    12,622

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
2015-09-10 04:00:00	SPY	ETF	196.1	196.2	195.13	195.38	104612.0
2015-09-10 04:30:00	SPY	ETF	195.34	195.66	195.09	195.66	43040.0
2015-09-10 05:00:00	SPY	ETF	195.56	196.1	195.56	196.07	40402.0
2015-09-10 05:30:00	SPY	ETF	196.09	197.45	196.09	197.0	89936.0
2015-09-10 06:00:00	SPY	ETF	196.98	197.09	195.54	195.97	145485.0
2015-09-10 06:30:00	SPY	ETF	195.92	195.92	195.46	195.68	119001.0
2015-09-10 07:00:00	SPY	ETF	195.6	195.66	195.13	195.13	131085.0
2015-09-10 07:30:00	SPY	ETF	195.17	195.25	193.72	194.78	890321.0
2015-09-10 08:00:00	SPY	ETF	194.8	195.61	194.28	194.39	2128172.0
2015-09-10 08:30:00	SPY	ETF	194.4	194.58	193.6	194.01	2816145.0
2015-09-10 09:00:00	SPY	ETF	194.01	194.55	194.01	194.52	1227833.0
2015-09-10 09:30:00	SPY	ETF	194.56	195.42	194.43	194.51	14541678.0
2015-09-10 10:00:00	SPY	ETF	194.52	194.95	194.25	194.8399	10741350.0
2015-09-10 10:30:00	SPY	ETF	194.836	196.32	194.814	195.93	13448302.0
2015-09-10 11:00:00	SPY	ETF	195.92	195.95	194.86	195.28	11868687.0
2015-09-10 11:30:00	SPY	ETF	195.29	195.95	195.23	195.73	7663134.0
2015-09-10 12:00:00	SPY	ETF	195.74	196.24	195.465	195.63	7093384.0
2015-09-10 12:30:00	SPY	ETF	195.63	196.1499	195.48	195.86	4441173.0
2015-09-10 13:00:00	SPY	ETF	195.87	196.68	195.64	196.66	6565403.0
2015-09-10 13:30:00	SPY	ETF	196.66	197.22	196.56	196.79	8926903.0
2015-09-10 14:00:00	SPY	ETF	196.79	196.97	196.32	196.51	10024771.0
2015-09-10 14:30:00	SPY	ETF	196.51	196.72	195.91	195.93	5952690.0
2015-09-10 15:00:00	SPY	ETF	195.92	196.235	195.38	195.56	12146819.0
2015-09-10 15:30:00	SPY	ETF	195.56	195.92	195.08	195.88	22254348.0
2015-09-10 16:00:00	SPY	ETF	195.85	196.0	195.43	195.65	6883283.0
2015-09-10 16:30:00	SPY	ETF	195.65	195.9	195.63	195.8	3482854.0
2015-09-10 17:00:00	SPY	ETF	195.85	195.94	195.8	195.85	88175.0
2015-09-10 17:30:00	SPY	ETF	195.84	195.87	195.67	195.69	3743096.0
2015-09-10 18:00:00	SPY	ETF	195.72	195.9	195.61	195.89	74556.0
2015-09-10 18:30:00	SPY	ETF	195.9	196.02	195.89	196.01	47413.0
2015-09-10 19:00:00	SPY	ETF	196.03	196.09	195.75	195.75	19594.0
2015-09-10 19:30:00	SPY	ETF	195.76	195.8	195.5	195.57	107443.0
2015-09-10 04:00:00	QQQ	ETF	104.46	104.54	104.28	104.28	32326.0
2015-09-10 04:30:00	QQQ	ETF	104.1	104.25	104.1	104.25	300.0
2015-09-10 05:00:00	QQQ	ETF	104.4	104.51	104.25	104.51	1300.0
2015-09-10 05:30:00	QQQ	ETF	104.54	105.2	104.54	104.96	4300.0
2015-09-10 06:00:00	QQQ	ETF	104.93	105.0	104.4	104.42	15850.0
2015-09-10 06:30:00	QQQ	ETF	104.41	104.41	104.21	104.25	3200.0
2015-09-10 07:00:00	QQQ	ETF	104.27	104.27	104.07	104.1	36100.0
2015-09-10 07:30:00	QQQ	ETF	104.03	104.06	103.78	103.84	19996.0
2015-09-10 08:00:00	QQQ	ETF	103.85	104.11	103.63	103.69	232766.0
2015-09-10 08:30:00	QQQ	ETF	103.7	103.78	103.26	103.45	218240.0
2015-09-10 09:00:00	QQQ	ETF	103.47	103.78	103.47	103.74	203033.0
2015-09-10 09:30:00	QQQ	ETF	103.74	104.35	103.62	103.94	5535182.0
2015-09-10 10:00:00	QQQ	ETF	103.94	104.21	103.72	104.14	3483855.0
2015-09-10 10:30:00	QQQ	ETF	104.15	105.21	104.12	104.935	4767969.0
2015-09-10 11:00:00	QQQ	ETF	104.93	104.96	104.27	104.53	2877205.0
2015-09-10 11:30:00	QQQ	ETF	104.521	104.88	104.451	104.73	1837698.0
2015-09-10 12:00:00	QQQ	ETF	104.74	105.07	104.66	104.75	1834019.0
2015-09-10 12:30:00	QQQ	ETF	104.75	105.04	104.66	104.89	1406491.0

> showing 50 of 12,622 rows — these rows as CSV

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