PREVIEW / etf_1hour / 2021-12-20

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-12-20.parquet
  size:    465 KB
  rows:    16,649

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
2021-12-20 04:00:00	SPY	ETF	453.6	458.1	451.76	452.82	228589.0
2021-12-20 05:00:00	SPY	ETF	453.34	454.78	453.29	454.59	124872.0
2021-12-20 06:00:00	SPY	ETF	454.4	455.34	454.01	455.29	145386.0
2021-12-20 07:00:00	SPY	ETF	455.37	455.87	454.33	454.33	483448.0
2021-12-20 08:00:00	SPY	ETF	454.29	460.214	451.8596	454.25	824393.0
2021-12-20 09:00:00	SPY	ETF	454.25	455.05	452.54	454.09	11718871.0
2021-12-20 10:00:00	SPY	ETF	454.06	454.37	451.63	451.9301	11839367.0
2021-12-20 11:00:00	SPY	ETF	451.92	452.93	451.14	452.87	8393369.0
2021-12-20 12:00:00	SPY	ETF	452.87	453.44	451.75	451.85	5648620.0
2021-12-20 13:00:00	SPY	ETF	451.84	454.055	451.55	453.41	6861499.0
2021-12-20 14:00:00	SPY	ETF	453.38	454.39	452.89	453.6213	7193257.0
2021-12-20 15:00:00	SPY	ETF	453.64	455.4	453.44	454.98	18711385.0
2021-12-20 16:00:00	SPY	ETF	454.98	456.3	454.61	456.02	7952687.0
2021-12-20 17:00:00	SPY	ETF	456.05	456.11	455.95	456.06	97918.0
2021-12-20 18:00:00	SPY	ETF	456.06	457.13	454.98	456.9	264944.0
2021-12-20 19:00:00	SPY	ETF	456.86	456.92	456.09	456.46	93401.0
2021-12-20 04:00:00	QQQ	ETF	382.05	382.05	377.73	378.86	266401.0
2021-12-20 05:00:00	QQQ	ETF	378.86	379.46	378.45	379.29	120956.0
2021-12-20 06:00:00	QQQ	ETF	379.2	379.93	378.87	379.85	86218.0
2021-12-20 07:00:00	QQQ	ETF	379.96	380.5	379.21	379.22	283144.0
2021-12-20 08:00:00	QQQ	ETF	380.1	380.79	377.8696	379.2	691701.0
2021-12-20 09:00:00	QQQ	ETF	379.2	381.5	378.69	380.81	7872049.0
2021-12-20 10:00:00	QQQ	ETF	380.81	381.1296	378.34	378.73	8613554.0
2021-12-20 11:00:00	QQQ	ETF	378.7	379.42	377.47	379.37	5847406.0
2021-12-20 12:00:00	QQQ	ETF	379.37	380.08	378.01	378.1	3392949.0
2021-12-20 13:00:00	QQQ	ETF	378.12	380.04	377.81	379.28	4252920.0
2021-12-20 14:00:00	QQQ	ETF	379.27	380.58	379.0005	379.93	4924647.0
2021-12-20 15:00:00	QQQ	ETF	379.95	381.27	379.42	380.64	7780028.0
2021-12-20 16:00:00	QQQ	ETF	380.63	382.25	379.74	381.86	2588290.0
2021-12-20 17:00:00	QQQ	ETF	381.8	381.8996	380.69	381.76	102527.0
2021-12-20 18:00:00	QQQ	ETF	381.74	383.08	381.74	382.93	127516.0
2021-12-20 19:00:00	QQQ	ETF	382.94	382.96	382.24	382.65	99862.0
2021-12-20 04:00:00	IWM	ETF	213.14	213.14	209.53	210.76	72069.0
2021-12-20 05:00:00	IWM	ETF	210.8	212.03	210.77	212.02	46750.0
2021-12-20 06:00:00	IWM	ETF	211.96	212.49	211.39	212.37	102281.0
2021-12-20 07:00:00	IWM	ETF	212.43	212.66	211.22	211.22	136428.0
2021-12-20 08:00:00	IWM	ETF	212.4	212.49	209.7396	212.09	218146.0
2021-12-20 09:00:00	IWM	ETF	212.14	212.55	209.42	210.96	6823521.0
2021-12-20 10:00:00	IWM	ETF	210.94	211.95	209.1	209.64	6140078.0
2021-12-20 11:00:00	IWM	ETF	209.62	210.54	208.76	210.5	4868754.0
2021-12-20 12:00:00	IWM	ETF	210.49	210.5	209.18	209.29	2367869.0
2021-12-20 13:00:00	IWM	ETF	209.29	211.08	209.09	210.75	3693470.0
2021-12-20 14:00:00	IWM	ETF	210.75	211.56	210.57	211.335	4302748.0
2021-12-20 15:00:00	IWM	ETF	211.35	212.94	211.34	212.09	7875506.0
2021-12-20 16:00:00	IWM	ETF	212.12	212.78	211.92	212.45	1621981.0
2021-12-20 17:00:00	IWM	ETF	212.4	212.67	212.12	212.6	62747.0
2021-12-20 18:00:00	IWM	ETF	212.6	213.2296	212.12	212.95	83893.0
2021-12-20 19:00:00	IWM	ETF	212.9	212.91	212.3	212.6	48577.0
2021-12-20 04:00:00	DIA	ETF	349.5	349.5	347.42	347.85	6040.0
2021-12-20 05:00:00	DIA	ETF	348.54	349.95	348.54	349.94	4425.0

> showing 50 of 16,649 rows — these rows as CSV

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