PREVIEW / etf_30min / 2016-03-01

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-03-01.parquet
  size:    404 KB
  rows:    13,599

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-01 04:00:00	SPY	ETF	194.61	194.72	194.35	194.68	31335.0
2016-03-01 04:30:00	SPY	ETF	194.57	194.7	194.48	194.64	8275.0
2016-03-01 05:00:00	SPY	ETF	194.53	195.18	194.5	195.18	16832.0
2016-03-01 05:30:00	SPY	ETF	195.19	195.22	195.01	195.14	7474.0
2016-03-01 06:00:00	SPY	ETF	194.99	195.28	194.85	195.26	128026.0
2016-03-01 06:30:00	SPY	ETF	195.29	195.37	194.95	194.95	48570.0
2016-03-01 07:00:00	SPY	ETF	194.95	195.22	194.95	195.09	173279.0
2016-03-01 07:30:00	SPY	ETF	195.14	195.25	195.04	195.06	194417.0
2016-03-01 08:00:00	SPY	ETF	195.06	195.24	193.055	194.78	524754.0
2016-03-01 08:30:00	SPY	ETF	194.78	194.95	194.78	194.93	325686.0
2016-03-01 09:00:00	SPY	ETF	194.96	195.09	193.56	195.0	844543.0
2016-03-01 09:30:00	SPY	ETF	195.01	195.28	194.4542	194.93	11937444.0
2016-03-01 10:00:00	SPY	ETF	194.93	195.96	194.93	195.9	13503660.0
2016-03-01 10:30:00	SPY	ETF	195.9	196.2	195.66	195.7889	8895638.0
2016-03-01 11:00:00	SPY	ETF	195.79	196.52	195.75	196.47	6846680.0
2016-03-01 11:30:00	SPY	ETF	196.48	197.02	196.43	196.97	9812312.0
2016-03-01 12:00:00	SPY	ETF	196.97	197.41	196.93	197.18	10346381.0
2016-03-01 12:30:00	SPY	ETF	197.18	197.37	197.03	197.36	5159938.0
2016-03-01 13:00:00	SPY	ETF	197.35	197.53	197.12	197.435	5954185.0
2016-03-01 13:30:00	SPY	ETF	197.43	197.73	197.38	197.46	7207033.0
2016-03-01 14:00:00	SPY	ETF	197.46	197.65	197.23	197.4	5510843.0
2016-03-01 14:30:00	SPY	ETF	197.41	197.97	197.33	197.96	7763981.0
2016-03-01 15:00:00	SPY	ETF	197.965	198.16	197.83	197.87	10772094.0
2016-03-01 15:30:00	SPY	ETF	197.8799	198.18	197.62	198.18	20049328.0
2016-03-01 16:00:00	SPY	ETF	198.17	198.49	193.35	198.49	6096112.0
2016-03-01 16:30:00	SPY	ETF	198.48	198.48	198.18	198.35	1428448.0
2016-03-01 17:00:00	SPY	ETF	198.35	198.37	198.3	198.31	407143.0
2016-03-01 17:30:00	SPY	ETF	198.33	198.34	198.11	198.28	533561.0
2016-03-01 18:00:00	SPY	ETF	198.26	198.3	198.15	198.2	73684.0
2016-03-01 18:30:00	SPY	ETF	198.2	198.26	198.15	198.22	94923.0
2016-03-01 19:00:00	SPY	ETF	198.17	198.22	198.04	198.1	123929.0
2016-03-01 19:30:00	SPY	ETF	198.12	198.22	198.1	198.19	66752.0
2016-03-01 04:00:00	QQQ	ETF	103.26	103.26	103.2	103.2	404.0
2016-03-01 04:30:00	QQQ	ETF	103.22	103.28	103.19	103.28	2499.0
2016-03-01 05:00:00	QQQ	ETF	103.2	103.49	103.2	103.49	7400.0
2016-03-01 05:30:00	QQQ	ETF	103.57	103.57	103.57	103.57	100.0
2016-03-01 06:00:00	QQQ	ETF	103.32	103.58	103.32	103.57	1700.0
2016-03-01 06:30:00	QQQ	ETF	103.57	103.58	103.36	103.38	8800.0
2016-03-01 07:00:00	QQQ	ETF	103.36	103.49	103.35	103.41	40287.0
2016-03-01 07:30:00	QQQ	ETF	103.42	103.46	103.37	103.39	102657.0
2016-03-01 08:00:00	QQQ	ETF	103.34	103.4	103.17	103.17	35167.0
2016-03-01 08:30:00	QQQ	ETF	103.27	103.31	103.22	103.3	37271.0
2016-03-01 09:00:00	QQQ	ETF	103.34	103.49	103.31	103.47	257209.0
2016-03-01 09:30:00	QQQ	ETF	103.45	103.6	103.16	103.53	3701456.0
2016-03-01 10:00:00	QQQ	ETF	103.53	104.32	103.53	104.29	3875200.0
2016-03-01 10:30:00	QQQ	ETF	104.29	104.5	104.21	104.272	3492647.0
2016-03-01 11:00:00	QQQ	ETF	104.27	104.685	104.27	104.64	2041775.0
2016-03-01 11:30:00	QQQ	ETF	104.6425	105.0299	104.63	104.98	2249903.0
2016-03-01 12:00:00	QQQ	ETF	104.97	105.26	104.97	105.125	2082737.0
2016-03-01 12:30:00	QQQ	ETF	105.13	105.22	105.03	105.17	1082760.0

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

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