PREVIEW / etf_1hour / 2019-09-03

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-09-03.parquet
  size:    338 KB
  rows:    11,178

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
2019-09-03 04:00:00	SPY	ETF	290.04	291.18	289.91	290.85	35783.0
2019-09-03 05:00:00	SPY	ETF	290.79	291.04	289.65	289.77	80232.0
2019-09-03 06:00:00	SPY	ETF	289.79	290.65	289.79	290.62	79513.0
2019-09-03 07:00:00	SPY	ETF	290.68	290.87	290.35	290.53	246676.0
2019-09-03 08:00:00	SPY	ETF	290.467	292.45	289.68	290.9	1214511.0
2019-09-03 09:00:00	SPY	ETF	290.91	292.45	290.28	291.35	7787680.0
2019-09-03 10:00:00	SPY	ETF	291.16	291.365	289.27	290.85	16847949.0
2019-09-03 11:00:00	SPY	ETF	290.85	291.07	289.79	290.63	7543462.0
2019-09-03 12:00:00	SPY	ETF	290.625	290.81	290.19	290.28	4174100.0
2019-09-03 13:00:00	SPY	ETF	290.28	290.55	289.59	289.78	5280589.0
2019-09-03 14:00:00	SPY	ETF	289.77	290.28	289.72	290.19	4195608.0
2019-09-03 15:00:00	SPY	ETF	290.1934	291.06	289.99	290.77	10428001.0
2019-09-03 16:00:00	SPY	ETF	290.76	290.95	290.55	290.63	9862926.0
2019-09-03 17:00:00	SPY	ETF	290.64	290.74	290.45	290.47	159558.0
2019-09-03 18:00:00	SPY	ETF	290.49	290.85	290.49	290.78	93399.0
2019-09-03 19:00:00	SPY	ETF	290.8	290.9	290.37	290.46	53453.0
2019-09-03 04:00:00	QQQ	ETF	185.54	186.5	185.41	185.99	60063.0
2019-09-03 05:00:00	QQQ	ETF	186.02	186.22	185.15	185.27	41886.0
2019-09-03 06:00:00	QQQ	ETF	185.22	186.12	185.22	186.0	30283.0
2019-09-03 07:00:00	QQQ	ETF	186.15	186.29	185.88	185.99	194071.0
2019-09-03 08:00:00	QQQ	ETF	185.96	186.78	185.47	186.49	244213.0
2019-09-03 09:00:00	QQQ	ETF	186.47	187.18	186.0	186.975	3326666.0
2019-09-03 10:00:00	QQQ	ETF	186.96	186.96	185.26	186.46	7273630.0
2019-09-03 11:00:00	QQQ	ETF	186.46	186.465	185.555	186.13	2464423.0
2019-09-03 12:00:00	QQQ	ETF	186.13	186.3	185.67	185.77	1715096.0
2019-09-03 13:00:00	QQQ	ETF	185.77	185.95	185.03	185.11	2200076.0
2019-09-03 14:00:00	QQQ	ETF	185.11	185.415	185.07	185.27	2176198.0
2019-09-03 15:00:00	QQQ	ETF	185.275	185.97	185.1405	185.66	4208970.0
2019-09-03 16:00:00	QQQ	ETF	185.66	185.88	185.54	185.79	1077527.0
2019-09-03 17:00:00	QQQ	ETF	185.76	185.76	185.54	185.67	12002.0
2019-09-03 18:00:00	QQQ	ETF	185.65	185.9	185.65	185.85	42053.0
2019-09-03 19:00:00	QQQ	ETF	185.88	185.94	185.57	185.61	24608.0
2019-09-03 04:00:00	IWM	ETF	147.05	147.46	147.05	147.46	1327.0
2019-09-03 05:00:00	IWM	ETF	147.01	147.01	146.87	146.87	1300.0
2019-09-03 06:00:00	IWM	ETF	147.31	147.37	147.31	147.37	5000.0
2019-09-03 07:00:00	IWM	ETF	147.48	147.64	147.36	147.36	21100.0
2019-09-03 08:00:00	IWM	ETF	147.47	147.88	147.42	147.63	58283.0
2019-09-03 09:00:00	IWM	ETF	147.7	148.315	147.38	147.8	2174798.0
2019-09-03 10:00:00	IWM	ETF	147.795	147.795	146.31	147.07	5345972.0
2019-09-03 11:00:00	IWM	ETF	147.08	147.12	146.27	146.88	2384236.0
2019-09-03 12:00:00	IWM	ETF	146.87	147.245	146.55	146.59	1426742.0
2019-09-03 13:00:00	IWM	ETF	146.58	146.66	146.0	146.23	1636459.0
2019-09-03 14:00:00	IWM	ETF	146.23	146.46	146.08	146.42	1515662.0
2019-09-03 15:00:00	IWM	ETF	146.42	146.94	146.27	146.65	3345127.0
2019-09-03 16:00:00	IWM	ETF	146.64	146.68	146.38	146.45	790492.0
2019-09-03 17:00:00	IWM	ETF	146.5	146.58	146.42	146.42	7355.0
2019-09-03 18:00:00	IWM	ETF	146.4	146.58	146.36	146.55	16880.0
2019-09-03 19:00:00	IWM	ETF	146.6	146.6	146.31	146.33	9330.0
2019-09-03 04:00:00	DIA	ETF	262.18	262.18	262.18	262.18	100.0
2019-09-03 05:00:00	DIA	ETF	262.62	262.62	261.85	261.85	1500.0

> showing 50 of 11,178 rows — these rows as CSV

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