PREVIEW / etf_1hour / 2022-10-17

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-10-17.parquet
  size:    452 KB
  rows:    16,684

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-10-17 04:00:00	SPY	ETF	360.02	361.46	360.02	360.76	83545.0
2022-10-17 05:00:00	SPY	ETF	361.01	361.76	360.72	361.67	44922.0
2022-10-17 06:00:00	SPY	ETF	361.64	362.61	361.5	362.17	144318.0
2022-10-17 07:00:00	SPY	ETF	362.19	362.29	361.38	361.95	585120.0
2022-10-17 08:00:00	SPY	ETF	362.08	362.84	358.88	362.65	981992.0
2022-10-17 09:00:00	SPY	ETF	362.69	367.38	362.69	365.87	12012970.0
2022-10-17 10:00:00	SPY	ETF	365.85	367.9799	364.8895	365.45	11948258.0
2022-10-17 11:00:00	SPY	ETF	365.45	367.48	364.6	366.905	7755982.0
2022-10-17 12:00:00	SPY	ETF	366.9	367.6	365.96	366.5137	5807736.0
2022-10-17 13:00:00	SPY	ETF	366.515	367.69	365.91	367.41	5926811.0
2022-10-17 14:00:00	SPY	ETF	367.4	367.92	366.25	366.82	5606444.0
2022-10-17 15:00:00	SPY	ETF	366.81	367.61	366.22	366.8	15844029.0
2022-10-17 16:00:00	SPY	ETF	366.8	368.0	366.61	367.69	5196710.0
2022-10-17 17:00:00	SPY	ETF	367.69	368.24	367.6	368.2	193900.0
2022-10-17 18:00:00	SPY	ETF	368.2	369.48	366.82	369.22	470101.0
2022-10-17 19:00:00	SPY	ETF	369.22	370.02	369.12	369.78	231970.0
2022-10-17 04:00:00	QQQ	ETF	263.16	263.99	262.96	263.51	116036.0
2022-10-17 05:00:00	QQQ	ETF	263.61	264.05	263.31	263.95	86829.0
2022-10-17 06:00:00	QQQ	ETF	263.82	264.69	263.76	264.48	132962.0
2022-10-17 07:00:00	QQQ	ETF	264.43	264.57	263.85	264.4	286253.0
2022-10-17 08:00:00	QQQ	ETF	264.39	265.55	260.935	265.42	1134787.0
2022-10-17 09:00:00	QQQ	ETF	265.42	269.56	265.42	268.52	10966557.0
2022-10-17 10:00:00	QQQ	ETF	268.52	269.96	267.4	267.85	7797620.0
2022-10-17 11:00:00	QQQ	ETF	267.85	270.0	267.2709	269.5	5323616.0
2022-10-17 12:00:00	QQQ	ETF	269.49	269.91	268.6	269.03	4119793.0
2022-10-17 13:00:00	QQQ	ETF	269.03	270.02	268.6	269.835	4018717.0
2022-10-17 14:00:00	QQQ	ETF	269.83	270.24	269.0998	269.48	4073290.0
2022-10-17 15:00:00	QQQ	ETF	269.48	270.09	268.88	269.49	8517629.0
2022-10-17 16:00:00	QQQ	ETF	269.48	270.25	269.28	270.01	2527520.0
2022-10-17 17:00:00	QQQ	ETF	270.07	270.48	269.94	270.46	122046.0
2022-10-17 18:00:00	QQQ	ETF	270.46	271.49	269.35	271.27	320431.0
2022-10-17 19:00:00	QQQ	ETF	271.27	272.0	271.22	271.83	218617.0
2022-10-17 04:00:00	IWM	ETF	168.0	169.02	168.0	168.73	21731.0
2022-10-17 05:00:00	IWM	ETF	168.89	169.26	168.79	169.14	26890.0
2022-10-17 06:00:00	IWM	ETF	169.21	169.64	169.11	169.44	28720.0
2022-10-17 07:00:00	IWM	ETF	169.41	169.51	169.15	169.21	61661.0
2022-10-17 08:00:00	IWM	ETF	169.1715	170.0	168.72	169.72	137880.0
2022-10-17 09:00:00	IWM	ETF	169.84	172.51	169.75	171.67	4627604.0
2022-10-17 10:00:00	IWM	ETF	171.67	172.62	170.71	171.02	3195620.0
2022-10-17 11:00:00	IWM	ETF	171.02	172.535	171.0	172.22	2051889.0
2022-10-17 12:00:00	IWM	ETF	172.22	172.54	171.28	171.58	1687276.0
2022-10-17 13:00:00	IWM	ETF	171.59	172.02	171.17	171.7675	888656.0
2022-10-17 14:00:00	IWM	ETF	171.76	171.94	171.32	171.5844	1190741.0
2022-10-17 15:00:00	IWM	ETF	171.57	172.5298	171.28	172.15	4730778.0
2022-10-17 16:00:00	IWM	ETF	172.13	172.71	172.06	172.52	2496855.0
2022-10-17 17:00:00	IWM	ETF	172.54	172.94	172.5	172.94	33140.0
2022-10-17 18:00:00	IWM	ETF	172.98	173.48	172.13	173.3	37091.0
2022-10-17 19:00:00	IWM	ETF	173.34	173.74	173.26	173.65	50110.0
2022-10-17 04:00:00	DIA	ETF	299.25	299.25	298.57	298.57	1297.0
2022-10-17 05:00:00	DIA	ETF	299.52	299.58	299.38	299.55	1900.0

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

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