PREVIEW / etf_1hour / 2015-11-25

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-11-25.parquet
  size:    232 KB
  rows:    7,457

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-11-25 04:00:00	SPY	ETF	209.5	209.96	209.48	209.78	27748.0
2015-11-25 05:00:00	SPY	ETF	209.73	209.84	209.64	209.81	12811.0
2015-11-25 06:00:00	SPY	ETF	209.77	209.82	209.5	209.67	23222.0
2015-11-25 07:00:00	SPY	ETF	209.65	209.7	209.45	209.57	145892.0
2015-11-25 08:00:00	SPY	ETF	209.57	209.94	208.96	209.56	552613.0
2015-11-25 09:00:00	SPY	ETF	209.56	209.66	209.01	209.55	8155929.0
2015-11-25 10:00:00	SPY	ETF	209.55	209.73	209.3	209.5	10072249.0
2015-11-25 11:00:00	SPY	ETF	209.5	209.56	209.31	209.51	7561740.0
2015-11-25 12:00:00	SPY	ETF	209.515	209.74	209.51	209.62	5488502.0
2015-11-25 13:00:00	SPY	ETF	209.63	209.66	209.38	209.5625	4046957.0
2015-11-25 14:00:00	SPY	ETF	209.56	209.65	209.44	209.57	4149813.0
2015-11-25 15:00:00	SPY	ETF	209.58	209.66	209.27	209.32	8895350.0
2015-11-25 16:00:00	SPY	ETF	209.33	209.63	209.29	209.55	2107652.0
2015-11-25 17:00:00	SPY	ETF	209.55	209.61	209.47	209.6	121800.0
2015-11-25 18:00:00	SPY	ETF	209.6	209.64	209.57	209.6	82170.0
2015-11-25 19:00:00	SPY	ETF	209.58	209.69	209.57	209.68	21571.0
2015-11-25 04:00:00	QQQ	ETF	114.3	114.33	114.3	114.33	1500.0
2015-11-25 05:00:00	QQQ	ETF	114.25	114.3	114.21	114.3	2300.0
2015-11-25 06:00:00	QQQ	ETF	114.26	114.26	114.19	114.19	1050.0
2015-11-25 07:00:00	QQQ	ETF	114.24	114.24	114.14	114.19	12900.0
2015-11-25 08:00:00	QQQ	ETF	114.21	114.32	114.2	114.2	52555.0
2015-11-25 09:00:00	QQQ	ETF	114.18	114.29	113.91	114.27	2937869.0
2015-11-25 10:00:00	QQQ	ETF	114.26	114.36	114.07	114.16	2281619.0
2015-11-25 11:00:00	QQQ	ETF	114.159	114.31	114.0	114.29	1785137.0
2015-11-25 12:00:00	QQQ	ETF	114.29	114.36	114.24	114.29	1681790.0
2015-11-25 13:00:00	QQQ	ETF	114.3	114.32	114.15	114.25	724839.0
2015-11-25 14:00:00	QQQ	ETF	114.25	114.32	114.189	114.26	728017.0
2015-11-25 15:00:00	QQQ	ETF	114.265	114.31	114.0158	114.13	2610602.0
2015-11-25 16:00:00	QQQ	ETF	114.13	114.32	114.13	114.25	380417.0
2015-11-25 17:00:00	QQQ	ETF	114.28	114.28	114.19	114.2	415.0
2015-11-25 18:00:00	QQQ	ETF	114.25	114.31	114.25	114.31	3896.0
2015-11-25 19:00:00	QQQ	ETF	114.3	114.33	114.25	114.25	1862.0
2015-11-25 04:00:00	IWM	ETF	118.41	118.41	118.41	118.41	100.0
2015-11-25 05:00:00	IWM	ETF	118.57	118.57	118.57	118.57	100.0
2015-11-25 07:00:00	IWM	ETF	118.4	118.45	118.35	118.35	400.0
2015-11-25 08:00:00	IWM	ETF	118.36	118.52	118.36	118.37	55319.0
2015-11-25 09:00:00	IWM	ETF	118.39	118.6	118.11	118.58	2037506.0
2015-11-25 10:00:00	IWM	ETF	118.57	118.975	118.39	118.85	3995166.0
2015-11-25 11:00:00	IWM	ETF	118.85	118.955	118.57	118.94	1864271.0
2015-11-25 12:00:00	IWM	ETF	118.94	119.28	118.94	119.005	2047941.0
2015-11-25 13:00:00	IWM	ETF	119.0	119.1564	118.87	119.14	1546714.0
2015-11-25 14:00:00	IWM	ETF	119.14	119.27	119.07	119.18	1919194.0
2015-11-25 15:00:00	IWM	ETF	119.18	119.32	119.14	119.2	3751024.0
2015-11-25 16:00:00	IWM	ETF	119.2	119.3	119.15	119.3	674270.0
2015-11-25 17:00:00	IWM	ETF	119.28	119.28	119.21	119.21	1900.0
2015-11-25 19:00:00	IWM	ETF	119.16	119.16	119.16	119.16	500.0
2015-11-25 06:00:00	DIA	ETF	178.38	178.38	178.38	178.38	250.0
2015-11-25 08:00:00	DIA	ETF	178.15	178.15	178.15	178.15	115.0
2015-11-25 09:00:00	DIA	ETF	178.01	178.22	177.79	178.2	335119.0
2015-11-25 10:00:00	DIA	ETF	178.18	178.33	177.97	178.19	454026.0

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

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