PREVIEW / etf_1hour / 2015-09-21

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-09-21.parquet
  size:    238 KB
  rows:    7,618

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-21 04:00:00	SPY	ETF	195.57	196.38	195.27	196.29	20452.0
2015-09-21 05:00:00	SPY	ETF	196.39	196.49	196.22	196.33	155084.0
2015-09-21 06:00:00	SPY	ETF	196.34	196.37	195.95	196.27	24583.0
2015-09-21 07:00:00	SPY	ETF	196.27	197.24	196.27	197.12	583267.0
2015-09-21 08:00:00	SPY	ETF	197.1	197.2	195.1	196.84	1672672.0
2015-09-21 09:00:00	SPY	ETF	196.84	197.08	196.19	196.6089	12780003.0
2015-09-21 10:00:00	SPY	ETF	196.63	197.68	196.47	197.35	16017404.0
2015-09-21 11:00:00	SPY	ETF	197.36	197.55	196.41	196.53	11312879.0
2015-09-21 12:00:00	SPY	ETF	196.54	196.545	195.21	195.44	14691680.0
2015-09-21 13:00:00	SPY	ETF	195.45	196.46	195.36	195.92	9397576.0
2015-09-21 14:00:00	SPY	ETF	195.92	196.88	195.66	196.7	8524623.0
2015-09-21 15:00:00	SPY	ETF	196.69	196.78	195.855	196.46	20262999.0
2015-09-21 16:00:00	SPY	ETF	196.47	197.17	196.44	197.11	8886135.0
2015-09-21 17:00:00	SPY	ETF	197.12	197.19	196.4865	197.17	417164.0
2015-09-21 18:00:00	SPY	ETF	197.16	197.19	196.95	196.98	118052.0
2015-09-21 19:00:00	SPY	ETF	196.96	197.13	196.92	197.13	288058.0
2015-09-21 04:00:00	QQQ	ETF	105.35	105.99	105.35	105.99	955.0
2015-09-21 05:00:00	QQQ	ETF	106.02	106.02	105.95	105.96	8500.0
2015-09-21 06:00:00	QQQ	ETF	106.01	106.01	105.8	105.9	159070.0
2015-09-21 07:00:00	QQQ	ETF	105.93	106.38	105.93	106.35	239036.0
2015-09-21 08:00:00	QQQ	ETF	106.32	106.34	106.11	106.17	142201.0
2015-09-21 09:00:00	QQQ	ETF	106.17	106.19	105.71	105.97	4257292.0
2015-09-21 10:00:00	QQQ	ETF	105.98	106.55	105.89	106.3735	3786790.0
2015-09-21 11:00:00	QQQ	ETF	106.38	106.5	105.71	105.75	3537726.0
2015-09-21 12:00:00	QQQ	ETF	105.74	105.75	104.73	104.88	6225385.0
2015-09-21 13:00:00	QQQ	ETF	104.87	105.63	104.81	105.28	3417326.0
2015-09-21 14:00:00	QQQ	ETF	105.27	105.8985	105.13	105.8035	2515220.0
2015-09-21 15:00:00	QQQ	ETF	105.81	105.915	105.32	105.68	4755367.0
2015-09-21 16:00:00	QQQ	ETF	105.66	106.1	105.66	106.1	708829.0
2015-09-21 17:00:00	QQQ	ETF	106.1	106.13	106.03	106.05	19107.0
2015-09-21 18:00:00	QQQ	ETF	106.08	106.16	105.95	105.95	12188.0
2015-09-21 19:00:00	QQQ	ETF	105.97	106.04	105.95	106.04	14500.0
2015-09-21 04:00:00	IWM	ETF	116.19	116.22	116.19	116.22	18800.0
2015-09-21 06:00:00	IWM	ETF	116.4	116.4	116.4	116.4	100.0
2015-09-21 07:00:00	IWM	ETF	116.59	117.01	116.59	116.98	144984.0
2015-09-21 08:00:00	IWM	ETF	116.93	116.98	116.83	116.85	59879.0
2015-09-21 09:00:00	IWM	ETF	116.77	116.87	116.27	116.67	3390256.0
2015-09-21 10:00:00	IWM	ETF	116.68	117.3	116.6	116.8825	4763964.0
2015-09-21 11:00:00	IWM	ETF	116.88	117.02	116.1	116.17	3087933.0
2015-09-21 12:00:00	IWM	ETF	116.17	116.17	115.08	115.285	5102097.0
2015-09-21 13:00:00	IWM	ETF	115.28	116.0	115.18	115.6	2775090.0
2015-09-21 14:00:00	IWM	ETF	115.59	115.96	115.29	115.855	2659975.0
2015-09-21 15:00:00	IWM	ETF	115.86	115.89	115.25	115.53	4597133.0
2015-09-21 16:00:00	IWM	ETF	115.53	116.01	115.4628	115.99	3082283.0
2015-09-21 17:00:00	IWM	ETF	116.03	116.03	115.89	115.98	90337.0
2015-09-21 18:00:00	IWM	ETF	115.91	116.1	115.89	115.99	23262.0
2015-09-21 19:00:00	IWM	ETF	115.95	115.95	115.95	115.95	200.0
2015-09-21 04:00:00	DIA	ETF	164.05	164.17	164.05	164.17	200.0
2015-09-21 06:00:00	DIA	ETF	164.16	164.16	164.16	164.16	300.0
2015-09-21 07:00:00	DIA	ETF	164.35	165.09	164.32	165.0	3738.0

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

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