PREVIEW / etf_1hour / 2017-09-12

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-09-12.parquet
  size:    276 KB
  rows:    9,122

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-12 04:00:00	SPY	ETF	249.41	249.58	249.4	249.57	30926.0
2017-09-12 05:00:00	SPY	ETF	249.51	249.58	249.49	249.53	15600.0
2017-09-12 06:00:00	SPY	ETF	249.56	249.62	249.56	249.59	11245.0
2017-09-12 07:00:00	SPY	ETF	249.58	249.73	249.58	249.72	171483.0
2017-09-12 08:00:00	SPY	ETF	249.72	249.72	249.45	249.52	268583.0
2017-09-12 09:00:00	SPY	ETF	249.53	249.975	249.52	249.78	7098276.0
2017-09-12 10:00:00	SPY	ETF	249.78	249.86	249.42	249.595	6986436.0
2017-09-12 11:00:00	SPY	ETF	249.585	249.77	249.51	249.7	5670960.0
2017-09-12 12:00:00	SPY	ETF	249.7	249.93	249.65	249.895	4197149.0
2017-09-12 13:00:00	SPY	ETF	249.895	250.05	249.8	249.8	4286279.0
2017-09-12 14:00:00	SPY	ETF	249.8	249.88	249.66	249.77	5962085.0
2017-09-12 15:00:00	SPY	ETF	249.775	250.07	249.6	250.07	14516140.0
2017-09-12 16:00:00	SPY	ETF	250.06	250.14	249.95	250.11	6409898.0
2017-09-12 17:00:00	SPY	ETF	250.11	250.18	250.05	250.17	217895.0
2017-09-12 18:00:00	SPY	ETF	250.18	250.19	250.11	250.15	104899.0
2017-09-12 19:00:00	SPY	ETF	250.15	250.17	250.1	250.12	99428.0
2017-09-12 04:00:00	QQQ	ETF	146.04	146.2	146.04	146.12	3000.0
2017-09-12 05:00:00	QQQ	ETF	146.15	146.17	146.09	146.11	6850.0
2017-09-12 06:00:00	QQQ	ETF	146.2	146.25	146.15	146.15	27500.0
2017-09-12 07:00:00	QQQ	ETF	146.15	146.3	146.14	146.3	25467.0
2017-09-12 08:00:00	QQQ	ETF	146.3	146.32	146.04	146.08	213931.0
2017-09-12 09:00:00	QQQ	ETF	146.09	146.41	145.8	145.95	4001772.0
2017-09-12 10:00:00	QQQ	ETF	145.96	145.98	145.65	145.81	3463816.0
2017-09-12 11:00:00	QQQ	ETF	145.8	145.97	145.77	145.84	2099382.0
2017-09-12 12:00:00	QQQ	ETF	145.84	146.05	145.77	145.97	2283200.0
2017-09-12 13:00:00	QQQ	ETF	145.97	146.29	145.97	146.08	2366915.0
2017-09-12 14:00:00	QQQ	ETF	146.09	146.225	145.58	145.71	4155051.0
2017-09-12 15:00:00	QQQ	ETF	145.71	146.21	145.53	146.21	5668572.0
2017-09-12 16:00:00	QQQ	ETF	146.21	146.36	146.0066	146.32	2664287.0
2017-09-12 17:00:00	QQQ	ETF	146.31	146.31	146.22	146.27	784702.0
2017-09-12 18:00:00	QQQ	ETF	146.3	146.31	146.27	146.29	4403.0
2017-09-12 19:00:00	QQQ	ETF	146.31	146.31	146.28	146.3	6890.0
2017-09-12 04:00:00	IWM	ETF	140.98	141.13	140.98	141.13	1322.0
2017-09-12 05:00:00	IWM	ETF	141.13	141.13	141.12	141.12	1006.0
2017-09-12 06:00:00	IWM	ETF	141.14	141.17	141.13	141.13	2173.0
2017-09-12 07:00:00	IWM	ETF	141.13	141.17	141.12	141.17	3200.0
2017-09-12 08:00:00	IWM	ETF	141.08	141.18	140.95	141.02	60823.0
2017-09-12 09:00:00	IWM	ETF	141.05	141.29	140.82	141.24	3823396.0
2017-09-12 10:00:00	IWM	ETF	141.24	141.37	141.15	141.18	2581237.0
2017-09-12 11:00:00	IWM	ETF	141.17	141.5925	141.08	141.47	2183812.0
2017-09-12 12:00:00	IWM	ETF	141.47	141.65	141.435	141.53	1247763.0
2017-09-12 13:00:00	IWM	ETF	141.53	141.69	141.45	141.45	1112813.0
2017-09-12 14:00:00	IWM	ETF	141.45	141.56	141.43	141.55	1283218.0
2017-09-12 15:00:00	IWM	ETF	141.55	141.58	141.34	141.54	3862143.0
2017-09-12 16:00:00	IWM	ETF	141.54	141.66	141.42	141.66	1196467.0
2017-09-12 17:00:00	IWM	ETF	141.54	141.66	141.54	141.65	264419.0
2017-09-12 19:00:00	IWM	ETF	141.65	141.65	141.63	141.64	8642.0
2017-09-12 04:00:00	DIA	ETF	221.0	221.0	221.0	221.0	200.0
2017-09-12 06:00:00	DIA	ETF	221.04	221.15	221.04	221.15	464.0
2017-09-12 08:00:00	DIA	ETF	221.34	221.34	221.29	221.29	2533.0

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

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