PREVIEW / etf_1hour / 2022-03-29

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-03-29.parquet
  size:    476 KB
  rows:    17,095

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
2022-03-29 04:00:00	SPY	ETF	456.89	457.31	456.83	457.1	26320.0
2022-03-29 05:00:00	SPY	ETF	457.29	458.25	457.17	457.77	103644.0
2022-03-29 06:00:00	SPY	ETF	457.79	457.8	457.26	457.48	42758.0
2022-03-29 07:00:00	SPY	ETF	457.46	458.85	457.1	458.49	708282.0
2022-03-29 08:00:00	SPY	ETF	457.3999	460.1	456.1	459.66	1202698.0
2022-03-29 09:00:00	SPY	ETF	459.7	461.75	458.68	459.2714	11924469.0
2022-03-29 10:00:00	SPY	ETF	459.3	459.705	457.18	459.19	10415354.0
2022-03-29 11:00:00	SPY	ETF	459.19	459.95	458.25	459.435	5098189.0
2022-03-29 12:00:00	SPY	ETF	459.45	459.485	457.51	458.31	5090575.0
2022-03-29 13:00:00	SPY	ETF	458.31	459.56	457.65	459.55	4816812.0
2022-03-29 14:00:00	SPY	ETF	459.54	460.84	459.09	460.57	6067110.0
2022-03-29 15:00:00	SPY	ETF	460.5618	462.07	460.31	461.59	17914999.0
2022-03-29 16:00:00	SPY	ETF	461.6	461.67	460.87	461.07	3183149.0
2022-03-29 17:00:00	SPY	ETF	460.93	461.02	460.76	460.97	133051.0
2022-03-29 18:00:00	SPY	ETF	460.97	461.08	460.59	460.89	83731.0
2022-03-29 19:00:00	SPY	ETF	460.92	461.1	460.87	461.1	60436.0
2022-03-29 04:00:00	QQQ	ETF	365.46	366.0	365.39	365.8	50924.0
2022-03-29 05:00:00	QQQ	ETF	365.76	367.31	365.74	366.6	91353.0
2022-03-29 06:00:00	QQQ	ETF	366.64	366.64	365.81	365.9	127310.0
2022-03-29 07:00:00	QQQ	ETF	365.94	367.73	365.63	367.44	479321.0
2022-03-29 08:00:00	QQQ	ETF	366.03	369.35	364.59	369.26	1202448.0
2022-03-29 09:00:00	QQQ	ETF	369.3	370.72	367.86	368.96	9756193.0
2022-03-29 10:00:00	QQQ	ETF	368.97	369.7	366.06	368.3989	10692115.0
2022-03-29 11:00:00	QQQ	ETF	368.45	369.4399	367.35	368.88	5202033.0
2022-03-29 12:00:00	QQQ	ETF	368.9	369.069	367.21	368.3001	4403737.0
2022-03-29 13:00:00	QQQ	ETF	368.3	369.88	367.4704	369.8	3628756.0
2022-03-29 14:00:00	QQQ	ETF	369.8	370.84	369.1	370.64	5096079.0
2022-03-29 15:00:00	QQQ	ETF	370.64	371.83	370.2	371.18	10481118.0
2022-03-29 16:00:00	QQQ	ETF	371.16	371.3	370.6	370.76	1991444.0
2022-03-29 17:00:00	QQQ	ETF	370.89	370.94	370.68	370.84	61575.0
2022-03-29 18:00:00	QQQ	ETF	370.78	370.8	370.22	370.4	73303.0
2022-03-29 19:00:00	QQQ	ETF	370.38	370.75	370.38	370.69	83883.0
2022-03-29 04:00:00	IWM	ETF	206.95	207.17	206.83	206.99	12981.0
2022-03-29 05:00:00	IWM	ETF	206.98	207.56	206.98	207.32	8510.0
2022-03-29 06:00:00	IWM	ETF	207.29	207.52	207.02	207.32	75787.0
2022-03-29 07:00:00	IWM	ETF	207.22	207.79	207.0	207.51	82670.0
2022-03-29 08:00:00	IWM	ETF	207.3199	208.4	207.0904	208.11	257554.0
2022-03-29 09:00:00	IWM	ETF	208.14	210.46	207.84	209.72	4049250.0
2022-03-29 10:00:00	IWM	ETF	209.74	210.61	208.22	210.56	3609144.0
2022-03-29 11:00:00	IWM	ETF	210.56	210.74	209.92	210.34	1659007.0
2022-03-29 12:00:00	IWM	ETF	210.35	210.38	209.345	209.65	1185918.0
2022-03-29 13:00:00	IWM	ETF	209.66	210.6484	209.25	210.6484	1172805.0
2022-03-29 14:00:00	IWM	ETF	210.66	211.51	210.55	211.44	2270965.0
2022-03-29 15:00:00	IWM	ETF	211.45	212.25	211.25	211.73	5086920.0
2022-03-29 16:00:00	IWM	ETF	211.73	211.73	211.15	211.5	1391800.0
2022-03-29 17:00:00	IWM	ETF	211.36	211.65	211.23	211.59	22112.0
2022-03-29 18:00:00	IWM	ETF	211.48	211.53	211.12	211.46	26989.0
2022-03-29 19:00:00	IWM	ETF	211.46	211.64	211.42	211.52	44283.0
2022-03-29 04:00:00	DIA	ETF	350.49	350.5	350.4	350.5	652.0
2022-03-29 05:00:00	DIA	ETF	351.09	351.09	350.68	350.75	3100.0

> showing 50 of 17,095 rows — these rows as CSV

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