PREVIEW / etf_1hour / 2019-11-06

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-11-06.parquet
  size:    334 KB
  rows:    11,044

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-06 04:00:00	SPY	ETF	307.21	307.23	306.56	306.72	13710.0
2019-11-06 05:00:00	SPY	ETF	306.67	306.92	306.67	306.9	33739.0
2019-11-06 06:00:00	SPY	ETF	306.89	307.0	306.82	306.9	25663.0
2019-11-06 07:00:00	SPY	ETF	306.92	307.27	306.92	307.18	79225.0
2019-11-06 08:00:00	SPY	ETF	306.94	307.41	306.89	307.3	277662.0
2019-11-06 09:00:00	SPY	ETF	307.25	307.29	306.4501	306.955	3548508.0
2019-11-06 10:00:00	SPY	ETF	306.96	307.18	306.74	306.78	4786659.0
2019-11-06 11:00:00	SPY	ETF	306.78	307.4	306.06	306.36	9411908.0
2019-11-06 12:00:00	SPY	ETF	306.36	306.69	306.32	306.48	3464120.0
2019-11-06 13:00:00	SPY	ETF	306.4741	307.155	306.3	307.1	4521480.0
2019-11-06 14:00:00	SPY	ETF	307.1	307.16	306.86	307.045	3167952.0
2019-11-06 15:00:00	SPY	ETF	307.045	307.19	306.86	307.14	10021448.0
2019-11-06 16:00:00	SPY	ETF	307.14	307.5	307.07	307.43	6032756.0
2019-11-06 17:00:00	SPY	ETF	307.47	307.47	307.1	307.43	121745.0
2019-11-06 18:00:00	SPY	ETF	307.44	307.46	307.15	307.15	50396.0
2019-11-06 19:00:00	SPY	ETF	307.17	307.3	307.13	307.18	33381.0
2019-11-06 04:00:00	QQQ	ETF	200.2	200.24	199.84	199.84	15980.0
2019-11-06 05:00:00	QQQ	ETF	199.88	200.06	199.88	200.06	3770.0
2019-11-06 06:00:00	QQQ	ETF	200.05	200.08	199.91	200.0	18183.0
2019-11-06 07:00:00	QQQ	ETF	200.04	200.22	200.03	200.18	21650.0
2019-11-06 08:00:00	QQQ	ETF	200.0401	200.36	200.0401	200.23	303877.0
2019-11-06 09:00:00	QQQ	ETF	200.23	200.23	199.46	199.7	2359194.0
2019-11-06 10:00:00	QQQ	ETF	199.71	199.82	199.2001	199.27	2851426.0
2019-11-06 11:00:00	QQQ	ETF	199.26	199.87	198.785	199.036	3139720.0
2019-11-06 12:00:00	QQQ	ETF	199.07	199.31	198.99	199.21	1325519.0
2019-11-06 13:00:00	QQQ	ETF	199.21	199.67	199.11	199.64	1404879.0
2019-11-06 14:00:00	QQQ	ETF	199.65	199.685	199.44	199.6241	1540542.0
2019-11-06 15:00:00	QQQ	ETF	199.62	199.76	199.46	199.75	3090846.0
2019-11-06 16:00:00	QQQ	ETF	199.74	200.07	199.71	200.07	1723664.0
2019-11-06 17:00:00	QQQ	ETF	200.08	200.08	199.94	199.96	9252.0
2019-11-06 18:00:00	QQQ	ETF	200.0	200.08	199.78	199.81	44762.0
2019-11-06 19:00:00	QQQ	ETF	199.81	199.92	199.8	199.8	21988.0
2019-11-06 04:00:00	IWM	ETF	158.99	158.99	158.99	158.99	1200.0
2019-11-06 05:00:00	IWM	ETF	158.95	159.09	158.95	159.09	8800.0
2019-11-06 06:00:00	IWM	ETF	159.14	159.15	159.1	159.15	8000.0
2019-11-06 07:00:00	IWM	ETF	159.13	159.33	159.13	159.21	12000.0
2019-11-06 08:00:00	IWM	ETF	159.31	159.33	159.14	159.26	12716.0
2019-11-06 09:00:00	IWM	ETF	159.22	159.22	158.18	158.77	1405187.0
2019-11-06 10:00:00	IWM	ETF	158.75	158.99	158.29	158.37	2028460.0
2019-11-06 11:00:00	IWM	ETF	158.41	158.68	157.88	158.0667	1949558.0
2019-11-06 12:00:00	IWM	ETF	158.08	158.26	157.84	157.93	833374.0
2019-11-06 13:00:00	IWM	ETF	157.9283	158.53	157.81	158.49	806015.0
2019-11-06 14:00:00	IWM	ETF	158.5	158.6238	158.32	158.38	914853.0
2019-11-06 15:00:00	IWM	ETF	158.39	158.51	158.14	158.21	2505517.0
2019-11-06 16:00:00	IWM	ETF	158.21	158.49	158.16	158.45	2239195.0
2019-11-06 17:00:00	IWM	ETF	158.43	158.48	158.23	158.43	14340.0
2019-11-06 18:00:00	IWM	ETF	158.43	158.43	158.28	158.28	4098.0
2019-11-06 19:00:00	IWM	ETF	158.29	158.41	158.27	158.33	14800.0
2019-11-06 04:00:00	DIA	ETF	274.9	274.9	274.9	274.9	500.0
2019-11-06 05:00:00	DIA	ETF	274.65	274.65	274.65	274.65	600.0

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

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