PREVIEW / etf_1hour / 2019-11-07

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-11-07.parquet
  size:    353 KB
  rows:    11,681

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-11-07 04:00:00	SPY	ETF	308.61	308.85	308.55	308.73	121313.0
2019-11-07 05:00:00	SPY	ETF	308.74	308.85	308.59	308.71	159549.0
2019-11-07 06:00:00	SPY	ETF	308.7	308.75	308.46	308.46	44408.0
2019-11-07 07:00:00	SPY	ETF	308.46	308.51	308.32	308.46	98774.0
2019-11-07 08:00:00	SPY	ETF	308.44	308.94	307.02	308.4	235563.0
2019-11-07 09:00:00	SPY	ETF	308.39	309.24	308.38	309.035	5393460.0
2019-11-07 10:00:00	SPY	ETF	309.04	309.4	308.75	309.21	5800255.0
2019-11-07 11:00:00	SPY	ETF	309.2	309.65	308.755	309.38	7501500.0
2019-11-07 12:00:00	SPY	ETF	309.385	309.46	308.87	309.09	5189004.0
2019-11-07 13:00:00	SPY	ETF	309.1	309.12	308.65	308.75	5383076.0
2019-11-07 14:00:00	SPY	ETF	308.7517	308.99	307.93	308.385	6325071.0
2019-11-07 15:00:00	SPY	ETF	308.39	308.56	307.66	308.22	13326564.0
2019-11-07 16:00:00	SPY	ETF	308.23	308.45	308.11	308.37	3209799.0
2019-11-07 17:00:00	SPY	ETF	308.38	308.46	308.31	308.38	185649.0
2019-11-07 18:00:00	SPY	ETF	308.35	308.45	308.2	308.44	317517.0
2019-11-07 19:00:00	SPY	ETF	308.43	308.78	308.07	308.12	127902.0
2019-11-07 04:00:00	QQQ	ETF	200.94	201.17	200.94	201.13	30405.0
2019-11-07 05:00:00	QQQ	ETF	201.18	201.18	200.97	201.08	14570.0
2019-11-07 06:00:00	QQQ	ETF	201.02	201.02	200.83	200.83	30924.0
2019-11-07 07:00:00	QQQ	ETF	200.89	200.99	200.77	200.95	101237.0
2019-11-07 08:00:00	QQQ	ETF	200.82	201.08	199.87	200.73	161258.0
2019-11-07 09:00:00	QQQ	ETF	200.73	201.23	200.6	201.068	1940142.0
2019-11-07 10:00:00	QQQ	ETF	201.07	201.54	200.9	201.4	2585120.0
2019-11-07 11:00:00	QQQ	ETF	201.41	201.72	201.11	201.62	2232821.0
2019-11-07 12:00:00	QQQ	ETF	201.625	201.66	201.19	201.3783	1530464.0
2019-11-07 13:00:00	QQQ	ETF	201.38	201.39	201.1	201.1491	778551.0
2019-11-07 14:00:00	QQQ	ETF	201.15	201.27	200.32	200.61	2235875.0
2019-11-07 15:00:00	QQQ	ETF	200.6	200.74	199.85	200.43	3699702.0
2019-11-07 16:00:00	QQQ	ETF	200.43	200.58	200.39	200.52	446512.0
2019-11-07 17:00:00	QQQ	ETF	200.52	200.57	200.47	200.57	12410.0
2019-11-07 18:00:00	QQQ	ETF	200.52	200.65	200.47	200.65	15629.0
2019-11-07 19:00:00	QQQ	ETF	200.65	200.9	200.31	200.32	61733.0
2019-11-07 04:00:00	IWM	ETF	159.28	159.39	159.28	159.39	5823.0
2019-11-07 05:00:00	IWM	ETF	159.47	159.56	159.46	159.55	6607.0
2019-11-07 06:00:00	IWM	ETF	159.51	159.56	159.51	159.56	700.0
2019-11-07 07:00:00	IWM	ETF	159.5	159.61	159.44	159.61	78042.0
2019-11-07 08:00:00	IWM	ETF	159.58	159.68	158.6	159.51	44103.0
2019-11-07 09:00:00	IWM	ETF	159.52	160.17	159.52	159.815	1782967.0
2019-11-07 10:00:00	IWM	ETF	159.83	159.87	159.27	159.62	1451276.0
2019-11-07 11:00:00	IWM	ETF	159.62	159.6958	158.91	159.47	1494101.0
2019-11-07 12:00:00	IWM	ETF	159.48	159.54	159.07	159.17	1027452.0
2019-11-07 13:00:00	IWM	ETF	159.18	159.18	158.75	158.775	919926.0
2019-11-07 14:00:00	IWM	ETF	158.78	159.02	158.43	158.58	1400901.0
2019-11-07 15:00:00	IWM	ETF	158.58	158.68	158.17	158.67	2876242.0
2019-11-07 16:00:00	IWM	ETF	158.67	158.79	158.54	158.6	655060.0
2019-11-07 17:00:00	IWM	ETF	158.6	158.6	158.49	158.59	41129.0
2019-11-07 18:00:00	IWM	ETF	158.58	158.71	158.58	158.69	28645.0
2019-11-07 19:00:00	IWM	ETF	158.65	158.8	158.49	158.49	15739.0
2019-11-07 05:00:00	DIA	ETF	276.5	276.5	276.5	276.5	100.0
2019-11-07 07:00:00	DIA	ETF	276.28	276.33	276.16	276.31	10801.0

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

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