PREVIEW / etf_1hour / 2022-02-09

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-02-09.parquet
  size:    458 KB
  rows:    16,361

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-02-09 04:00:00	SPY	ETF	453.43	454.04	453.43	453.69	41943.0
2022-02-09 05:00:00	SPY	ETF	453.55	454.25	453.55	454.0	27009.0
2022-02-09 06:00:00	SPY	ETF	453.95	454.45	453.67	454.41	41079.0
2022-02-09 07:00:00	SPY	ETF	454.31	454.91	454.18	454.69	173276.0
2022-02-09 08:00:00	SPY	ETF	454.4	455.25	451.278	454.9	346801.0
2022-02-09 09:00:00	SPY	ETF	454.99	456.37	454.9	455.35	9664452.0
2022-02-09 10:00:00	SPY	ETF	455.35	456.79	455.13	456.775	9716169.0
2022-02-09 11:00:00	SPY	ETF	456.77	457.029	455.52	455.87	7054998.0
2022-02-09 12:00:00	SPY	ETF	455.88	456.7	455.35	456.66	5317190.0
2022-02-09 13:00:00	SPY	ETF	456.66	456.86	456.1	456.76	3948823.0
2022-02-09 14:00:00	SPY	ETF	456.7701	457.59	456.6026	456.66	6578189.0
2022-02-09 15:00:00	SPY	ETF	456.66	457.88	455.76	457.5	19013119.0
2022-02-09 16:00:00	SPY	ETF	457.49	458.02	457.02	457.69	4754005.0
2022-02-09 17:00:00	SPY	ETF	457.69	457.79	457.61	457.79	44274.0
2022-02-09 18:00:00	SPY	ETF	457.79	457.87	457.22	457.46	88508.0
2022-02-09 19:00:00	SPY	ETF	457.4	457.51	456.77	456.78	159833.0
2022-02-09 04:00:00	QQQ	ETF	360.77	362.34	360.77	361.9	142608.0
2022-02-09 05:00:00	QQQ	ETF	361.85	362.71	361.84	362.59	66795.0
2022-02-09 06:00:00	QQQ	ETF	362.54	363.48	362.25	363.31	67805.0
2022-02-09 07:00:00	QQQ	ETF	363.31	364.09	363.18	363.8	295187.0
2022-02-09 08:00:00	QQQ	ETF	363.65	364.38	359.389	363.67	409555.0
2022-02-09 09:00:00	QQQ	ETF	363.72	364.54	362.42	362.76	6967871.0
2022-02-09 10:00:00	QQQ	ETF	362.79	364.46	362.12	364.43	6794534.0
2022-02-09 11:00:00	QQQ	ETF	364.44	364.92	363.62	363.96	5244309.0
2022-02-09 12:00:00	QQQ	ETF	363.96	365.4	363.54	365.36	4297878.0
2022-02-09 13:00:00	QQQ	ETF	365.38	365.57	364.73	365.295	2795044.0
2022-02-09 14:00:00	QQQ	ETF	365.3	366.3	365.29	365.475	3781812.0
2022-02-09 15:00:00	QQQ	ETF	365.48	366.8	364.46	366.77	10099017.0
2022-02-09 16:00:00	QQQ	ETF	366.79	367.34	366.38	367.03	2224617.0
2022-02-09 17:00:00	QQQ	ETF	367.03	367.1	366.91	367.05	64281.0
2022-02-09 18:00:00	QQQ	ETF	367.06	367.15	366.53	366.77	101115.0
2022-02-09 19:00:00	QQQ	ETF	366.79	366.84	365.95	366.0	193321.0
2022-02-09 04:00:00	IWM	ETF	203.48	204.63	203.48	204.19	16708.0
2022-02-09 05:00:00	IWM	ETF	204.14	204.55	204.14	204.4	7988.0
2022-02-09 06:00:00	IWM	ETF	204.33	204.5	204.2	204.47	14872.0
2022-02-09 07:00:00	IWM	ETF	204.42	204.71	204.4	204.44	45294.0
2022-02-09 08:00:00	IWM	ETF	204.2396	204.86	204.2104	204.64	73874.0
2022-02-09 09:00:00	IWM	ETF	204.66	205.81	204.3	205.01	3889218.0
2022-02-09 10:00:00	IWM	ETF	205.02	206.0	205.01	205.91	3603836.0
2022-02-09 11:00:00	IWM	ETF	205.9	206.0	205.14	205.74	2485729.0
2022-02-09 12:00:00	IWM	ETF	205.73	205.91	204.995	205.86	1966423.0
2022-02-09 13:00:00	IWM	ETF	205.86	205.99	205.495	205.855	1563187.0
2022-02-09 14:00:00	IWM	ETF	205.855	206.42	205.855	206.115	1811259.0
2022-02-09 15:00:00	IWM	ETF	206.11	206.65	205.57	206.63	3759080.0
2022-02-09 16:00:00	IWM	ETF	206.63	206.69	206.25	206.57	769587.0
2022-02-09 17:00:00	IWM	ETF	206.61	206.74	206.3	206.7	43992.0
2022-02-09 18:00:00	IWM	ETF	206.63	206.7	206.39	206.55	76595.0
2022-02-09 19:00:00	IWM	ETF	206.51	206.59	206.1	206.2	23047.0
2022-02-09 04:00:00	DIA	ETF	356.57	356.6	356.45	356.51	2830.0
2022-02-09 05:00:00	DIA	ETF	356.29	356.51	356.29	356.47	888.0

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

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