PREVIEW / etf_30min / 2016-09-13

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-09-13.parquet
  size:    415 KB
  rows:    14,104

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-09-13 04:00:00	SPY	ETF	215.4	215.4	214.85	215.04	123227.0
2016-09-13 04:30:00	SPY	ETF	214.99	215.02	214.83	214.99	7842.0
2016-09-13 05:00:00	SPY	ETF	214.97	215.12	214.94	215.06	14783.0
2016-09-13 05:30:00	SPY	ETF	215.12	215.12	214.95	214.98	25766.0
2016-09-13 06:00:00	SPY	ETF	215.06	215.16	215.06	215.15	130986.0
2016-09-13 06:30:00	SPY	ETF	215.18	215.33	215.17	215.28	66835.0
2016-09-13 07:00:00	SPY	ETF	215.28	215.31	215.0	215.0	167983.0
2016-09-13 07:30:00	SPY	ETF	215.02	215.07	214.86	214.99	257454.0
2016-09-13 08:00:00	SPY	ETF	215.02	215.849	214.98	214.98	724378.0
2016-09-13 08:30:00	SPY	ETF	214.98	214.98	214.69	214.79	877143.0
2016-09-13 09:00:00	SPY	ETF	214.79	214.94	214.55	214.83	1445971.0
2016-09-13 09:30:00	SPY	ETF	214.84	215.1499	214.06	214.08	17852918.0
2016-09-13 10:00:00	SPY	ETF	214.08	214.235	213.641	213.765	14576913.0
2016-09-13 10:30:00	SPY	ETF	213.77	214.19	213.44	213.52	13107689.0
2016-09-13 11:00:00	SPY	ETF	213.51	213.6	213.01	213.1	9954915.0
2016-09-13 11:30:00	SPY	ETF	213.1	213.34	212.87	213.2348	10481363.0
2016-09-13 12:00:00	SPY	ETF	213.23	213.76	213.07	213.12	10513642.0
2016-09-13 12:30:00	SPY	ETF	213.1101	213.3	212.64	212.82	9853460.0
2016-09-13 13:00:00	SPY	ETF	212.8325	213.93	212.5	213.85	10899842.0
2016-09-13 13:30:00	SPY	ETF	213.855	214.18	213.04	213.21	10558031.0
2016-09-13 14:00:00	SPY	ETF	213.21	213.34	212.83	212.84	8803091.0
2016-09-13 14:30:00	SPY	ETF	212.85	213.4993	212.63	212.97	11280334.0
2016-09-13 15:00:00	SPY	ETF	212.97	213.56	212.63	213.44	12748827.0
2016-09-13 15:30:00	SPY	ETF	213.44	214.67	212.89	213.23	22642921.0
2016-09-13 16:00:00	SPY	ETF	213.21	213.51	213.07	213.5	10248477.0
2016-09-13 16:30:00	SPY	ETF	213.51	213.85	213.51	213.78	1066580.0
2016-09-13 17:00:00	SPY	ETF	213.77	213.8	213.23	213.72	508576.0
2016-09-13 17:30:00	SPY	ETF	213.73	213.8	213.6	213.71	185105.0
2016-09-13 18:00:00	SPY	ETF	213.71	213.75	213.2287	213.6	280644.0
2016-09-13 18:30:00	SPY	ETF	213.63	213.7	213.62	213.68	26290.0
2016-09-13 19:00:00	SPY	ETF	213.68	213.73	213.62	213.65	15352.0
2016-09-13 19:30:00	SPY	ETF	213.64	213.64	213.48	213.49	59474.0
2016-09-13 04:00:00	QQQ	ETF	115.72	115.72	115.53	115.63	77928.0
2016-09-13 04:30:00	QQQ	ETF	115.58	115.62	115.53	115.62	16400.0
2016-09-13 05:00:00	QQQ	ETF	115.59	115.63	115.57	115.63	40198.0
2016-09-13 05:30:00	QQQ	ETF	115.6	115.6	115.58	115.58	2998.0
2016-09-13 06:00:00	QQQ	ETF	115.69	115.71	115.69	115.7	6247.0
2016-09-13 06:30:00	QQQ	ETF	115.78	115.78	115.78	115.78	1500.0
2016-09-13 07:00:00	QQQ	ETF	115.77	115.77	115.63	115.63	22320.0
2016-09-13 07:30:00	QQQ	ETF	115.67	115.79	115.59	115.79	46688.0
2016-09-13 08:00:00	QQQ	ETF	115.79	115.83	115.72	115.73	63244.0
2016-09-13 08:30:00	QQQ	ETF	115.68	115.7	115.59	115.69	145524.0
2016-09-13 09:00:00	QQQ	ETF	115.7	115.76	115.56	115.72	301333.0
2016-09-13 09:30:00	QQQ	ETF	115.74	116.09	115.46	115.47	4100179.0
2016-09-13 10:00:00	QQQ	ETF	115.47	115.58	115.26	115.35	3381639.0
2016-09-13 10:30:00	QQQ	ETF	115.35	115.63	115.14	115.18	3409841.0
2016-09-13 11:00:00	QQQ	ETF	115.17	115.23	114.922	114.94	2799388.0
2016-09-13 11:30:00	QQQ	ETF	114.95	115.13	114.9	115.06	1573839.0
2016-09-13 12:00:00	QQQ	ETF	115.05	115.35	114.97	115.04	2120608.0
2016-09-13 12:30:00	QQQ	ETF	115.03	115.14	114.83	114.93	1810794.0

> showing 50 of 14,104 rows — these rows as CSV

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