PREVIEW / etf_1hour / 2022-08-25

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-08-25.parquet
  size:    439 KB
  rows:    15,851

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-08-25 04:00:00	SPY	ETF	417.63	417.91	416.57	417.21	59427.0
2022-08-25 05:00:00	SPY	ETF	417.24	417.26	415.39	415.61	39567.0
2022-08-25 06:00:00	SPY	ETF	415.5	416.02	415.43	415.95	108055.0
2022-08-25 07:00:00	SPY	ETF	415.87	416.52	415.31	416.13	107785.0
2022-08-25 08:00:00	SPY	ETF	415.86	417.53	414.6	415.43	512866.0
2022-08-25 09:00:00	SPY	ETF	415.4	416.52	414.09	416.4	3754317.0
2022-08-25 10:00:00	SPY	ETF	416.4	417.85	416.1	417.0877	5432114.0
2022-08-25 11:00:00	SPY	ETF	417.08	417.1	415.02	416.1076	4400898.0
2022-08-25 12:00:00	SPY	ETF	416.12	416.18	414.69	415.4719	3014674.0
2022-08-25 13:00:00	SPY	ETF	415.49	416.97	415.25	416.75	2886917.0
2022-08-25 14:00:00	SPY	ETF	416.77	417.0	416.07	416.67	3382532.0
2022-08-25 15:00:00	SPY	ETF	416.63	419.56	416.46	419.51	12027424.0
2022-08-25 16:00:00	SPY	ETF	419.5	419.56	418.72	418.8	4098989.0
2022-08-25 17:00:00	SPY	ETF	418.99	419.25	418.76	419.16	90875.0
2022-08-25 18:00:00	SPY	ETF	419.16	419.25	418.64	418.74	66489.0
2022-08-25 19:00:00	SPY	ETF	418.81	419.3	418.81	418.97	52022.0
2022-08-25 04:00:00	QQQ	ETF	317.53	318.67	317.53	318.12	173478.0
2022-08-25 05:00:00	QQQ	ETF	318.11	318.18	316.51	316.78	144887.0
2022-08-25 06:00:00	QQQ	ETF	316.68	317.37	316.67	317.29	69601.0
2022-08-25 07:00:00	QQQ	ETF	317.22	317.77	316.95	317.29	170612.0
2022-08-25 08:00:00	QQQ	ETF	317.26	318.48	315.246	316.87	454064.0
2022-08-25 09:00:00	QQQ	ETF	316.858	317.85	315.7577	317.7239	4032548.0
2022-08-25 10:00:00	QQQ	ETF	317.74	319.5204	317.68	318.53	4790516.0
2022-08-25 11:00:00	QQQ	ETF	318.53	318.54	316.69	317.76	3263579.0
2022-08-25 12:00:00	QQQ	ETF	317.7507	317.95	316.6	317.36	1756500.0
2022-08-25 13:00:00	QQQ	ETF	317.35	318.93	317.16	318.6	2286834.0
2022-08-25 14:00:00	QQQ	ETF	318.65	318.81	317.69	318.25	1943640.0
2022-08-25 15:00:00	QQQ	ETF	318.26	320.6	317.975	320.53	5554909.0
2022-08-25 16:00:00	QQQ	ETF	320.51	320.58	320.06	320.12	2192242.0
2022-08-25 17:00:00	QQQ	ETF	320.1	320.56	320.1	320.5	93434.0
2022-08-25 18:00:00	QQQ	ETF	320.5	320.6	320.01	320.06	112391.0
2022-08-25 19:00:00	QQQ	ETF	320.11	320.55	320.1	320.21	103618.0
2022-08-25 04:00:00	IWM	ETF	194.78	194.79	194.37	194.54	20776.0
2022-08-25 05:00:00	IWM	ETF	194.53	194.6	193.51	193.51	19140.0
2022-08-25 06:00:00	IWM	ETF	193.51	193.82	193.5	193.65	139023.0
2022-08-25 07:00:00	IWM	ETF	193.55	193.98	193.51	193.71	26277.0
2022-08-25 08:00:00	IWM	ETF	193.7395	193.95	193.05	193.32	63204.0
2022-08-25 09:00:00	IWM	ETF	193.31	194.46	192.98	194.39	1747157.0
2022-08-25 10:00:00	IWM	ETF	194.42	195.33	194.17	194.54	1963233.0
2022-08-25 11:00:00	IWM	ETF	194.55	194.55	193.55	194.28	1377373.0
2022-08-25 12:00:00	IWM	ETF	194.27	194.34	193.66	194.175	710074.0
2022-08-25 13:00:00	IWM	ETF	194.14	194.71	194.05	194.5885	1161220.0
2022-08-25 14:00:00	IWM	ETF	194.59	194.725	194.1575	194.44	748081.0
2022-08-25 15:00:00	IWM	ETF	194.425	195.45	194.26	195.41	2564481.0
2022-08-25 16:00:00	IWM	ETF	195.4	195.41	194.96	195.06	935131.0
2022-08-25 17:00:00	IWM	ETF	195.02	195.33	195.02	195.32	41398.0
2022-08-25 18:00:00	IWM	ETF	195.24	195.24	194.91	195.05	43320.0
2022-08-25 19:00:00	IWM	ETF	195.08	195.3	195.08	195.13	25209.0
2022-08-25 04:00:00	DIA	ETF	332.0	332.14	331.94	332.14	3000.0
2022-08-25 05:00:00	DIA	ETF	331.76	331.76	330.73	330.73	2600.0

> showing 50 of 15,851 rows — these rows as CSV

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