PREVIEW / etf_1hour / 2022-03-28

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-03-28.parquet
  size:    459 KB
  rows:    16,320

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-28 04:00:00	SPY	ETF	451.96	452.87	451.24	452.87	33852.0
2022-03-28 05:00:00	SPY	ETF	452.81	452.83	451.83	452.31	15522.0
2022-03-28 06:00:00	SPY	ETF	452.34	452.92	452.2	452.58	27562.0
2022-03-28 07:00:00	SPY	ETF	452.82	453.87	452.82	453.78	138967.0
2022-03-28 08:00:00	SPY	ETF	452.1804	453.86	450.71	452.3	243186.0
2022-03-28 09:00:00	SPY	ETF	452.42	453.649	451.67	453.54	5131634.0
2022-03-28 10:00:00	SPY	ETF	453.55	453.6	451.99	453.27	6816959.0
2022-03-28 11:00:00	SPY	ETF	453.28	453.42	450.27	450.44	6751347.0
2022-03-28 12:00:00	SPY	ETF	450.46	451.75	450.06	451.65	4861877.0
2022-03-28 13:00:00	SPY	ETF	451.66	452.54	451.42	452.4299	3654863.0
2022-03-28 14:00:00	SPY	ETF	452.415	454.42	452.17	454.41	4895507.0
2022-03-28 15:00:00	SPY	ETF	454.41	455.89	453.87	455.8698	13952368.0
2022-03-28 16:00:00	SPY	ETF	455.87	456.2	455.73	456.05	3904693.0
2022-03-28 17:00:00	SPY	ETF	456.05	456.19	455.87	456.0	130822.0
2022-03-28 18:00:00	SPY	ETF	455.94	455.95	455.61	455.9	91075.0
2022-03-28 19:00:00	SPY	ETF	455.9204	456.15	455.77	455.81	132739.0
2022-03-28 04:00:00	QQQ	ETF	358.52	358.82	357.69	358.82	104260.0
2022-03-28 05:00:00	QQQ	ETF	358.7	358.79	357.73	358.35	81214.0
2022-03-28 06:00:00	QQQ	ETF	358.19	359.21	358.19	358.93	46176.0
2022-03-28 07:00:00	QQQ	ETF	359.0	360.68	359.0	360.66	232049.0
2022-03-28 08:00:00	QQQ	ETF	359.9192	360.81	357.5	359.38	384149.0
2022-03-28 09:00:00	QQQ	ETF	359.52	363.19	358.94	362.57	7349417.0
2022-03-28 10:00:00	QQQ	ETF	362.58	362.65	359.97	362.28	8699549.0
2022-03-28 11:00:00	QQQ	ETF	362.28	362.53	358.49	358.89	7572425.0
2022-03-28 12:00:00	QQQ	ETF	358.91	360.24	358.07	360.1	3853525.0
2022-03-28 13:00:00	QQQ	ETF	360.13	361.73	360.04	361.52	3420109.0
2022-03-28 14:00:00	QQQ	ETF	361.5499	363.84	361.19	363.82	4971416.0
2022-03-28 15:00:00	QQQ	ETF	363.83	365.01	363.34	365.0	8652408.0
2022-03-28 16:00:00	QQQ	ETF	364.99	365.19	364.79	364.85	943532.0
2022-03-28 17:00:00	QQQ	ETF	364.83	364.93	364.72	364.83	101115.0
2022-03-28 18:00:00	QQQ	ETF	364.76	364.76	364.47	364.64	76084.0
2022-03-28 19:00:00	QQQ	ETF	364.73	364.96	364.53	364.65	100146.0
2022-03-28 04:00:00	IWM	ETF	205.69	206.21	205.44	206.15	10741.0
2022-03-28 05:00:00	IWM	ETF	206.4	206.4	205.94	206.14	2515.0
2022-03-28 06:00:00	IWM	ETF	206.09	206.17	205.93	206.01	4833.0
2022-03-28 07:00:00	IWM	ETF	206.08	206.42	206.08	206.35	21214.0
2022-03-28 08:00:00	IWM	ETF	206.1	206.32	205.63	205.79	32791.0
2022-03-28 09:00:00	IWM	ETF	205.74	206.05	204.94	205.49	1365582.0
2022-03-28 10:00:00	IWM	ETF	205.47	205.62	204.56	204.99	1981938.0
2022-03-28 11:00:00	IWM	ETF	204.99	205.14	203.23	203.255	2261592.0
2022-03-28 12:00:00	IWM	ETF	203.24	204.2	203.03	204.14	1567280.0
2022-03-28 13:00:00	IWM	ETF	204.16	204.65	203.94	204.48	772759.0
2022-03-28 14:00:00	IWM	ETF	204.49	205.12	203.94	205.1	1733550.0
2022-03-28 15:00:00	IWM	ETF	205.1	206.21	204.77	206.19	3165544.0
2022-03-28 16:00:00	IWM	ETF	206.2	206.36	204.3	206.04	790211.0
2022-03-28 17:00:00	IWM	ETF	206.03	206.08	205.91	206.02	14151.0
2022-03-28 18:00:00	IWM	ETF	206.04	206.15	205.89	206.04	17393.0
2022-03-28 19:00:00	IWM	ETF	206.12	206.19	205.89	205.9	47036.0
2022-03-28 05:00:00	DIA	ETF	348.61	348.61	348.61	348.61	100.0
2022-03-28 06:00:00	DIA	ETF	348.65	348.74	348.65	348.74	855.0

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

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