PREVIEW / etf_1hour / 2022-11-03

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-11-03.parquet
  size:    465 KB
  rows:    16,971

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-11-03 04:00:00	SPY	ETF	375.05	375.77	373.98	374.6	103250.0
2022-11-03 05:00:00	SPY	ETF	374.6	375.0	373.76	374.26	68286.0
2022-11-03 06:00:00	SPY	ETF	374.62	374.62	372.44	372.95	113844.0
2022-11-03 07:00:00	SPY	ETF	372.94	372.98	371.83	372.19	402074.0
2022-11-03 08:00:00	SPY	ETF	372.76	376.35	371.08	371.14	1032519.0
2022-11-03 09:00:00	SPY	ETF	371.2	372.25	369.04	369.17	9117470.0
2022-11-03 10:00:00	SPY	ETF	369.22	373.59	368.79	373.5	13065117.0
2022-11-03 11:00:00	SPY	ETF	373.49	373.69	371.02	371.721	8159980.0
2022-11-03 12:00:00	SPY	ETF	371.73	374.2	371.4	373.8899	5533008.0
2022-11-03 13:00:00	SPY	ETF	373.87	374.0483	372.245	372.2622	4582299.0
2022-11-03 14:00:00	SPY	ETF	372.27	373.67	371.87	373.5272	5294690.0
2022-11-03 15:00:00	SPY	ETF	373.5201	373.62	370.92	371.02	10648223.0
2022-11-03 16:00:00	SPY	ETF	371.01	371.49	370.8	370.93	5408245.0
2022-11-03 17:00:00	SPY	ETF	370.9501	371.01	370.5802	370.67	730337.0
2022-11-03 18:00:00	SPY	ETF	370.65	370.77	369.95	370.39	185831.0
2022-11-03 19:00:00	SPY	ETF	370.35	370.59	370.18	370.42	138171.0
2022-11-03 04:00:00	QQQ	ETF	266.0	266.32	264.7	265.21	158114.0
2022-11-03 05:00:00	QQQ	ETF	265.26	265.58	264.58	265.1	85409.0
2022-11-03 06:00:00	QQQ	ETF	265.1	265.28	263.65	263.98	267041.0
2022-11-03 07:00:00	QQQ	ETF	263.97	264.04	262.79	263.06	405349.0
2022-11-03 08:00:00	QQQ	ETF	263.69	266.89	262.4	262.45	1064791.0
2022-11-03 09:00:00	QQQ	ETF	262.55	265.68	260.47	260.5479	8112383.0
2022-11-03 10:00:00	QQQ	ETF	260.57	264.35	260.1	264.0	11927144.0
2022-11-03 11:00:00	QQQ	ETF	263.99	264.5	261.25	261.587	5999363.0
2022-11-03 12:00:00	QQQ	ETF	261.57	263.86	261.22	263.63	5477373.0
2022-11-03 13:00:00	QQQ	ETF	263.61	263.7799	261.8299	261.86	3039520.0
2022-11-03 14:00:00	QQQ	ETF	261.84	262.78	261.5	262.5886	3320293.0
2022-11-03 15:00:00	QQQ	ETF	262.58	262.645	260.37	260.5	8102561.0
2022-11-03 16:00:00	QQQ	ETF	260.5	260.91	260.35	260.65	2735685.0
2022-11-03 17:00:00	QQQ	ETF	260.61	260.8	260.15	260.2499	634398.0
2022-11-03 18:00:00	QQQ	ETF	260.23	260.35	259.78	260.16	207335.0
2022-11-03 19:00:00	QQQ	ETF	260.22	260.35	260.05	260.15	148334.0
2022-11-03 04:00:00	IWM	ETF	177.27	177.87	176.96	177.29	23192.0
2022-11-03 05:00:00	IWM	ETF	177.44	177.59	177.06	177.2	7560.0
2022-11-03 06:00:00	IWM	ETF	177.42	177.47	176.18	176.37	38093.0
2022-11-03 07:00:00	IWM	ETF	176.31	176.44	175.87	176.19	224138.0
2022-11-03 08:00:00	IWM	ETF	176.06	177.81	175.371	175.371	108752.0
2022-11-03 09:00:00	IWM	ETF	175.39	175.99	174.11	174.21	3671971.0
2022-11-03 10:00:00	IWM	ETF	174.21	177.57	174.11	177.52	4607567.0
2022-11-03 11:00:00	IWM	ETF	177.53	177.58	176.26	176.52	3211103.0
2022-11-03 12:00:00	IWM	ETF	176.53	177.94	176.38	177.78	1904801.0
2022-11-03 13:00:00	IWM	ETF	177.76	177.885	176.98	177.01	1720096.0
2022-11-03 14:00:00	IWM	ETF	177.02	177.61	176.84	177.51	1236870.0
2022-11-03 15:00:00	IWM	ETF	177.51	177.63	176.43	176.45	2786809.0
2022-11-03 16:00:00	IWM	ETF	176.47	176.74	176.29	176.43	2219486.0
2022-11-03 17:00:00	IWM	ETF	176.34	176.54	176.11	176.12	13269.0
2022-11-03 18:00:00	IWM	ETF	176.25	176.45	175.92	176.07	27595.0
2022-11-03 19:00:00	IWM	ETF	176.1	176.19	175.91	176.11	11771.0
2022-11-03 04:00:00	DIA	ETF	321.72	321.85	320.85	321.25	5520.0
2022-11-03 05:00:00	DIA	ETF	321.41	321.45	321.11	321.41	6449.0

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

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