PREVIEW / etf_1hour / 2015-06-26

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-06-26.parquet
  size:    239 KB
  rows:    7,645

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-06-26 04:00:00	SPY	ETF	209.71	209.9	209.71	209.9	1100.0
2015-06-26 05:00:00	SPY	ETF	209.88	209.97	209.73	209.79	10676.0
2015-06-26 06:00:00	SPY	ETF	209.8	210.24	209.77	210.24	21657.0
2015-06-26 07:00:00	SPY	ETF	210.2	210.43	210.08	210.36	227406.0
2015-06-26 08:00:00	SPY	ETF	210.34	210.36	209.75	210.3	949229.0
2015-06-26 09:00:00	SPY	ETF	210.29	210.47	209.64	210.36	10689691.0
2015-06-26 10:00:00	SPY	ETF	210.37	210.58	209.825	209.87	13887812.0
2015-06-26 11:00:00	SPY	ETF	209.87	210.33	209.83	209.96	8002907.0
2015-06-26 12:00:00	SPY	ETF	209.96	210.17	209.4	209.415	8069952.0
2015-06-26 13:00:00	SPY	ETF	209.42	209.825	209.16	209.64	13093734.0
2015-06-26 14:00:00	SPY	ETF	209.64	209.78	209.44	209.63	7256448.0
2015-06-26 15:00:00	SPY	ETF	209.63	210.13	209.61	209.83	24092788.0
2015-06-26 16:00:00	SPY	ETF	209.83	210.5	209.78	210.13	15863272.0
2015-06-26 17:00:00	SPY	ETF	210.13	210.14	209.8	209.86	714903.0
2015-06-26 18:00:00	SPY	ETF	209.86	209.94	209.66	209.68	274678.0
2015-06-26 19:00:00	SPY	ETF	209.67	209.69	209.26	209.35	252446.0
2015-06-26 04:00:00	QQQ	ETF	109.9	109.9	109.9	109.9	100.0
2015-06-26 05:00:00	QQQ	ETF	109.95	109.95	109.95	109.95	100.0
2015-06-26 06:00:00	QQQ	ETF	110.05	110.05	110.05	110.05	100.0
2015-06-26 07:00:00	QQQ	ETF	109.99	110.22	109.99	110.15	27280.0
2015-06-26 08:00:00	QQQ	ETF	110.16	110.16	109.87	110.0	75906.0
2015-06-26 09:00:00	QQQ	ETF	109.98	110.11	109.56	110.07	5143398.0
2015-06-26 10:00:00	QQQ	ETF	110.08	110.23	109.47	109.48	4000982.0
2015-06-26 11:00:00	QQQ	ETF	109.48	109.78	109.45	109.51	2135238.0
2015-06-26 12:00:00	QQQ	ETF	109.505	109.595	108.9488	108.97	2883405.0
2015-06-26 13:00:00	QQQ	ETF	108.96	109.27	108.86	109.15	3041201.0
2015-06-26 14:00:00	QQQ	ETF	109.15	109.22	108.96	109.16	2008382.0
2015-06-26 15:00:00	QQQ	ETF	109.155	109.5	109.145	109.28	4679416.0
2015-06-26 16:00:00	QQQ	ETF	109.29	109.39	109.18	109.36	900715.0
2015-06-26 17:00:00	QQQ	ETF	109.38	109.38	109.27	109.29	539228.0
2015-06-26 18:00:00	QQQ	ETF	109.29	109.32	109.2	109.28	7634.0
2015-06-26 19:00:00	QQQ	ETF	109.16	109.16	108.9	109.08	41924.0
2015-06-26 04:00:00	IWM	ETF	127.8	127.85	127.8	127.85	300.0
2015-06-26 05:00:00	IWM	ETF	127.9	127.9	127.9	127.9	100.0
2015-06-26 06:00:00	IWM	ETF	128.0	128.0	128.0	128.0	100.0
2015-06-26 07:00:00	IWM	ETF	128.08	128.16	128.08	128.16	18100.0
2015-06-26 08:00:00	IWM	ETF	128.15	128.16	127.96	128.07	77249.0
2015-06-26 09:00:00	IWM	ETF	128.02	128.3	127.59	128.22	2473465.0
2015-06-26 10:00:00	IWM	ETF	128.23	128.34	127.41	127.46	3024884.0
2015-06-26 11:00:00	IWM	ETF	127.46	127.84	127.43	127.595	2066532.0
2015-06-26 12:00:00	IWM	ETF	127.59	127.71	126.85	126.91	2234262.0
2015-06-26 13:00:00	IWM	ETF	126.92	127.59	126.82	127.435	4046171.0
2015-06-26 14:00:00	IWM	ETF	127.44	127.46	127.1	127.28	2744504.0
2015-06-26 15:00:00	IWM	ETF	127.28	127.74	127.07	127.47	10776847.0
2015-06-26 16:00:00	IWM	ETF	127.48	127.86	127.44	127.64	2849092.0
2015-06-26 17:00:00	IWM	ETF	127.64	127.64	127.49	127.6	1064915.0
2015-06-26 18:00:00	IWM	ETF	127.52	127.52	127.46	127.46	1405.0
2015-06-26 19:00:00	IWM	ETF	127.42	127.49	126.99	127.0	48718.0
2015-06-26 07:00:00	DIA	ETF	179.05	179.05	179.05	179.05	1400.0
2015-06-26 08:00:00	DIA	ETF	179.1	179.1	178.85	179.01	3700.0

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

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