PREVIEW / etf_1hour / 2020-12-22

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-12-22.parquet
  size:    402 KB
  rows:    13,842

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
2020-12-22 04:00:00	SPY	ETF	368.05	368.68	368.01	368.13	20190.0
2020-12-22 05:00:00	SPY	ETF	368.02	368.31	367.71	368.09	18273.0
2020-12-22 06:00:00	SPY	ETF	368.32	368.66	368.23	368.4	42038.0
2020-12-22 07:00:00	SPY	ETF	368.4	368.93	368.35	368.65	157395.0
2020-12-22 08:00:00	SPY	ETF	368.3712	368.96	366.02	368.4	202126.0
2020-12-22 09:00:00	SPY	ETF	368.37	368.5	367.21	367.82	4993842.0
2020-12-22 10:00:00	SPY	ETF	367.83	368.3317	367.06	367.74	6988629.0
2020-12-22 11:00:00	SPY	ETF	367.75	368.08	366.03	367.055	5930623.0
2020-12-22 12:00:00	SPY	ETF	367.055	367.64	366.94	367.47	3809258.0
2020-12-22 13:00:00	SPY	ETF	367.47	368.25	367.42	368.0	3034152.0
2020-12-22 14:00:00	SPY	ETF	368.01	368.15	367.2101	367.565	4382355.0
2020-12-22 15:00:00	SPY	ETF	367.5655	367.67	366.58	367.22	12170792.0
2020-12-22 16:00:00	SPY	ETF	367.23	367.3	366.84	366.94	3867492.0
2020-12-22 17:00:00	SPY	ETF	366.99	367.07	366.93	367.0	12764.0
2020-12-22 18:00:00	SPY	ETF	366.96	367.7	366.88	367.69	77610.0
2020-12-22 19:00:00	SPY	ETF	367.65	367.81	364.55	365.22	385758.0
2020-12-22 04:00:00	QQQ	ETF	309.6	310.27	309.57	309.92	17185.0
2020-12-22 05:00:00	QQQ	ETF	309.98	310.1	309.86	310.02	9014.0
2020-12-22 06:00:00	QQQ	ETF	310.1	310.22	309.97	310.01	30691.0
2020-12-22 07:00:00	QQQ	ETF	310.03	310.79	310.03	310.55	149212.0
2020-12-22 08:00:00	QQQ	ETF	310.17	310.87	308.2	310.44	239534.0
2020-12-22 09:00:00	QQQ	ETF	310.45	310.7105	308.88	310.605	2684960.0
2020-12-22 10:00:00	QQQ	ETF	310.6	310.61	308.96	309.45	3518622.0
2020-12-22 11:00:00	QQQ	ETF	309.457	309.5	306.845	308.33	4032213.0
2020-12-22 12:00:00	QQQ	ETF	308.33	309.06	308.25	308.83	2035499.0
2020-12-22 13:00:00	QQQ	ETF	308.88	309.76	308.84	309.51	2029317.0
2020-12-22 14:00:00	QQQ	ETF	309.54	309.84	309.0	309.355	1474568.0
2020-12-22 15:00:00	QQQ	ETF	309.36	309.76	308.7401	309.75	3469282.0
2020-12-22 16:00:00	QQQ	ETF	309.75	309.78	309.3471	309.57	1038342.0
2020-12-22 17:00:00	QQQ	ETF	309.43	309.69	309.43	309.59	10090.0
2020-12-22 18:00:00	QQQ	ETF	309.55	309.94	309.5	309.9	55226.0
2020-12-22 19:00:00	QQQ	ETF	309.93	309.96	307.74	308.24	147446.0
2020-12-22 04:00:00	IWM	ETF	195.08	195.92	195.0	195.0	15938.0
2020-12-22 05:00:00	IWM	ETF	195.01	195.45	194.9	195.33	15600.0
2020-12-22 06:00:00	IWM	ETF	195.33	195.74	195.2	195.42	23737.0
2020-12-22 07:00:00	IWM	ETF	195.5	195.85	195.44	195.85	40244.0
2020-12-22 08:00:00	IWM	ETF	195.7999	196.22	193.35	195.89	56604.0
2020-12-22 09:00:00	IWM	ETF	195.85	196.59	195.39	196.5201	2013279.0
2020-12-22 10:00:00	IWM	ETF	196.5655	197.61	196.17	196.99	4778730.0
2020-12-22 11:00:00	IWM	ETF	197.0	197.72	195.85	196.41	2395625.0
2020-12-22 12:00:00	IWM	ETF	196.41	197.16	196.18	196.986	1491919.0
2020-12-22 13:00:00	IWM	ETF	197.04	197.21	196.56	196.76	1046356.0
2020-12-22 14:00:00	IWM	ETF	196.77	197.42	196.74	197.405	1398358.0
2020-12-22 15:00:00	IWM	ETF	197.4	197.685	197.02	197.41	3580120.0
2020-12-22 16:00:00	IWM	ETF	197.46	197.61	197.2	197.26	819613.0
2020-12-22 17:00:00	IWM	ETF	197.21	197.46	197.07	197.15	15300.0
2020-12-22 18:00:00	IWM	ETF	197.17	197.66	197.0	197.6	36765.0
2020-12-22 19:00:00	IWM	ETF	197.67	197.71	195.55	195.71	83612.0
2020-12-22 05:00:00	DIA	ETF	301.71	301.71	301.71	301.71	300.0
2020-12-22 06:00:00	DIA	ETF	302.09	302.12	302.08	302.12	2800.0

> showing 50 of 13,842 rows — these rows as CSV

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