PREVIEW / etf_1hour / 2017-09-19

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-09-19.parquet
  size:    277 KB
  rows:    9,150

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
2017-09-19 04:00:00	SPY	ETF	249.74	249.77	249.71	249.77	2630.0
2017-09-19 05:00:00	SPY	ETF	249.86	249.99	249.86	249.96	3867.0
2017-09-19 06:00:00	SPY	ETF	249.99	250.0	249.91	249.98	34982.0
2017-09-19 07:00:00	SPY	ETF	249.96	249.99	249.9	249.9	58625.0
2017-09-19 08:00:00	SPY	ETF	249.92	249.96	249.88	249.91	56088.0
2017-09-19 09:00:00	SPY	ETF	249.89	250.02	249.65	249.71	4029969.0
2017-09-19 10:00:00	SPY	ETF	249.72	249.96	249.68	249.86	6122973.0
2017-09-19 11:00:00	SPY	ETF	249.85	249.97	249.6	249.9	3059950.0
2017-09-19 12:00:00	SPY	ETF	249.9	250.06	249.89	249.95	5006863.0
2017-09-19 13:00:00	SPY	ETF	249.96	250.04	249.87	250.0	3349267.0
2017-09-19 14:00:00	SPY	ETF	250.0	250.06	249.87	249.925	5683331.0
2017-09-19 15:00:00	SPY	ETF	249.93	250.07	249.88	249.97	10243183.0
2017-09-19 16:00:00	SPY	ETF	249.96	249.98	249.82	249.82	8773101.0
2017-09-19 17:00:00	SPY	ETF	249.87	249.89	249.83	249.87	43824.0
2017-09-19 18:00:00	SPY	ETF	249.86	249.86	249.75	249.78	106036.0
2017-09-19 19:00:00	SPY	ETF	249.78	249.88	249.76	249.82	19815.0
2017-09-19 04:00:00	QQQ	ETF	145.52	145.54	145.5	145.51	723.0
2017-09-19 05:00:00	QQQ	ETF	145.61	145.7	145.61	145.7	1800.0
2017-09-19 06:00:00	QQQ	ETF	145.73	145.75	145.67	145.72	6619.0
2017-09-19 07:00:00	QQQ	ETF	145.71	145.77	145.68	145.75	29605.0
2017-09-19 08:00:00	QQQ	ETF	145.66	145.77	145.65	145.66	39645.0
2017-09-19 09:00:00	QQQ	ETF	145.69	145.87	145.31	145.41	3200838.0
2017-09-19 10:00:00	QQQ	ETF	145.41	145.8	145.41	145.74	2924666.0
2017-09-19 11:00:00	QQQ	ETF	145.75	145.76	145.39	145.68	2226262.0
2017-09-19 12:00:00	QQQ	ETF	145.68	146.01	145.68	145.74	1869218.0
2017-09-19 13:00:00	QQQ	ETF	145.73	145.85	145.63	145.81	1163334.0
2017-09-19 14:00:00	QQQ	ETF	145.805	145.9	145.71	145.7201	1049779.0
2017-09-19 15:00:00	QQQ	ETF	145.73	145.87	145.68	145.8	2551306.0
2017-09-19 16:00:00	QQQ	ETF	145.79	145.86	145.4728	145.77	2889019.0
2017-09-19 17:00:00	QQQ	ETF	145.75	145.82	145.67	145.77	16093.0
2017-09-19 18:00:00	QQQ	ETF	145.76	145.76	145.69	145.69	11694.0
2017-09-19 19:00:00	QQQ	ETF	145.69	145.73	145.69	145.71	14703.0
2017-09-19 04:00:00	IWM	ETF	143.54	143.54	143.48	143.48	700.0
2017-09-19 07:00:00	IWM	ETF	143.61	143.63	143.55	143.55	22197.0
2017-09-19 08:00:00	IWM	ETF	143.56	143.63	143.52	143.6	51726.0
2017-09-19 09:00:00	IWM	ETF	143.63	143.6886	143.27	143.35	1804359.0
2017-09-19 10:00:00	IWM	ETF	143.36	143.55	143.23	143.4	1705351.0
2017-09-19 11:00:00	IWM	ETF	143.4	143.4	143.09	143.14	1233910.0
2017-09-19 12:00:00	IWM	ETF	143.13	143.4	143.12	143.32	938499.0
2017-09-19 13:00:00	IWM	ETF	143.31	143.44	143.26	143.34	858247.0
2017-09-19 14:00:00	IWM	ETF	143.34	143.45	143.26	143.28	1221770.0
2017-09-19 15:00:00	IWM	ETF	143.28	143.37	143.2	143.36	1922907.0
2017-09-19 16:00:00	IWM	ETF	143.35	143.5	143.2857	143.38	2594390.0
2017-09-19 17:00:00	IWM	ETF	143.33	143.38	143.32	143.38	1417.0
2017-09-19 18:00:00	IWM	ETF	143.31	143.34	143.27	143.3	5716.0
2017-09-19 19:00:00	IWM	ETF	143.31	143.31	143.3	143.3	4126.0
2017-09-19 05:00:00	DIA	ETF	223.42	223.42	223.42	223.42	470.0
2017-09-19 07:00:00	DIA	ETF	223.35	223.35	223.35	223.35	436.0
2017-09-19 08:00:00	DIA	ETF	223.35	223.35	223.35	223.35	500.0
2017-09-19 09:00:00	DIA	ETF	223.21	223.47	223.21	223.28	190202.0

> showing 50 of 9,150 rows — these rows as CSV

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