PREVIEW / etf_1hour / 2015-09-25

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-09-25.parquet
  size:    240 KB
  rows:    7,703

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-25 04:00:00	SPY	ETF	193.85	195.9	193.85	195.51	101455.0
2015-09-25 05:00:00	SPY	ETF	195.4	195.72	195.3	195.5	29856.0
2015-09-25 06:00:00	SPY	ETF	195.43	195.49	194.94	194.94	258121.0
2015-09-25 07:00:00	SPY	ETF	195.0	195.53	194.65	195.4	1571433.0
2015-09-25 08:00:00	SPY	ETF	195.39	195.44	192.77	194.86	2425165.0
2015-09-25 09:00:00	SPY	ETF	194.85	195.3349	193.95	194.43	18631318.0
2015-09-25 10:00:00	SPY	ETF	194.42	194.7	193.85	194.67	17176508.0
2015-09-25 11:00:00	SPY	ETF	194.67	194.7	194.135	194.455	10545979.0
2015-09-25 12:00:00	SPY	ETF	194.46	194.61	193.94	194.51	10073731.0
2015-09-25 13:00:00	SPY	ETF	194.515	195.0	194.36	194.481	13744367.0
2015-09-25 14:00:00	SPY	ETF	194.49	194.72	192.31	193.02	25799174.0
2015-09-25 15:00:00	SPY	ETF	193.03	193.26	191.81	192.81	36614543.0
2015-09-25 16:00:00	SPY	ETF	192.81	192.99	192.21	192.31	16772128.0
2015-09-25 17:00:00	SPY	ETF	192.32	193.1549	192.16	192.17	257994.0
2015-09-25 18:00:00	SPY	ETF	192.17	192.41	192.16	192.32	88569.0
2015-09-25 19:00:00	SPY	ETF	192.36	192.41	192.3	192.3	23429.0
2015-09-25 04:00:00	QQQ	ETF	104.29	105.27	104.29	105.27	24520.0
2015-09-25 05:00:00	QQQ	ETF	105.29	105.32	105.05	105.05	52385.0
2015-09-25 06:00:00	QQQ	ETF	105.0	105.03	104.85	104.95	117563.0
2015-09-25 07:00:00	QQQ	ETF	104.9	105.14	104.73	105.1	168011.0
2015-09-25 08:00:00	QQQ	ETF	105.1	105.14	104.86	104.97	211314.0
2015-09-25 09:00:00	QQQ	ETF	104.94	105.03	104.46	104.68	5008677.0
2015-09-25 10:00:00	QQQ	ETF	104.68	104.81	104.17	104.709	4689427.0
2015-09-25 11:00:00	QQQ	ETF	104.7	104.78	104.26	104.419	2067690.0
2015-09-25 12:00:00	QQQ	ETF	104.405	104.4185	104.0	104.37	2716245.0
2015-09-25 13:00:00	QQQ	ETF	104.38	104.64	104.12	104.17	2921513.0
2015-09-25 14:00:00	QQQ	ETF	104.17	104.33	102.7	103.15	7754565.0
2015-09-25 15:00:00	QQQ	ETF	103.15	103.22	102.28	102.94	11497082.0
2015-09-25 16:00:00	QQQ	ETF	102.93	103.04	102.74	102.75	690385.0
2015-09-25 17:00:00	QQQ	ETF	102.74	102.92	102.67	102.67	324895.0
2015-09-25 18:00:00	QQQ	ETF	102.66	102.8	102.66	102.8	11710.0
2015-09-25 19:00:00	QQQ	ETF	102.82	102.85	102.7	102.7	10683.0
2015-09-25 04:00:00	IWM	ETF	113.65	114.09	113.65	114.09	1698.0
2015-09-25 05:00:00	IWM	ETF	114.2	114.47	114.2	114.3	700.0
2015-09-25 06:00:00	IWM	ETF	114.34	114.34	114.15	114.15	10700.0
2015-09-25 07:00:00	IWM	ETF	114.15	114.39	113.99	114.27	118500.0
2015-09-25 08:00:00	IWM	ETF	114.3	114.37	113.87	113.94	118006.0
2015-09-25 09:00:00	IWM	ETF	113.97	113.97	113.08	113.285	4007659.0
2015-09-25 10:00:00	IWM	ETF	113.3	113.43	112.625	113.385	5542109.0
2015-09-25 11:00:00	IWM	ETF	113.39	113.4	112.78	112.89	2302653.0
2015-09-25 12:00:00	IWM	ETF	112.89	112.9	112.38	112.64	2900579.0
2015-09-25 13:00:00	IWM	ETF	112.65	112.88	112.39	112.71	2272115.0
2015-09-25 14:00:00	IWM	ETF	112.72	112.86	111.2	111.7	7443050.0
2015-09-25 15:00:00	IWM	ETF	111.69	111.72	110.93	111.4	11758897.0
2015-09-25 16:00:00	IWM	ETF	111.4	112.9866	111.0	111.04	3343346.0
2015-09-25 17:00:00	IWM	ETF	111.02	111.11	110.8	111.11	33976.0
2015-09-25 18:00:00	IWM	ETF	111.15	111.47	111.15	111.44	64301.0
2015-09-25 19:00:00	IWM	ETF	111.33	111.35	111.32	111.35	456.0
2015-09-25 04:00:00	DIA	ETF	163.45	164.25	163.45	164.25	400.0
2015-09-25 05:00:00	DIA	ETF	164.37	164.4	164.37	164.4	200.0

> showing 50 of 7,703 rows — these rows as CSV

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