PREVIEW / etf_1hour / 2023-10-09

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-10-09.parquet
  size:    484 KB
  rows:    17,553

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
2023-10-09 04:00:00	SPY	ETF	426.08	427.15	425.95	427.08	69673.0
2023-10-09 05:00:00	SPY	ETF	427.03	427.61	426.96	427.06	48438.0
2023-10-09 06:00:00	SPY	ETF	427.13	427.59	426.89	426.89	42856.0
2023-10-09 07:00:00	SPY	ETF	427.0	427.14	426.43	426.8	222323.0
2023-10-09 08:00:00	SPY	ETF	427.0608	427.6196	425.5	426.49	651372.0
2023-10-09 09:00:00	SPY	ETF	426.47	429.09	426.46	428.85	7135632.0
2023-10-09 10:00:00	SPY	ETF	428.845	429.14	427.0101	427.365	8623635.0
2023-10-09 11:00:00	SPY	ETF	427.36	429.08	427.28	429.035	5895369.0
2023-10-09 12:00:00	SPY	ETF	429.04	429.98	428.54	428.94	5841466.0
2023-10-09 13:00:00	SPY	ETF	428.97	432.13	428.83	432.11	7052323.0
2023-10-09 14:00:00	SPY	ETF	432.12	432.88	431.695	432.55	8672752.0
2023-10-09 15:00:00	SPY	ETF	432.55	432.68	431.56	432.27	13185425.0
2023-10-09 16:00:00	SPY	ETF	432.27	432.51	428.5063	432.18	3442480.0
2023-10-09 17:00:00	SPY	ETF	432.33	432.35	432.14	432.16	46673.0
2023-10-09 18:00:00	SPY	ETF	432.2	432.24	432.08	432.13	41385.0
2023-10-09 19:00:00	SPY	ETF	432.15	432.28	432.12	432.26	37522.0
2023-10-09 04:00:00	QQQ	ETF	362.47	362.53	361.45	362.37	207314.0
2023-10-09 05:00:00	QQQ	ETF	362.4	362.66	361.95	362.05	57923.0
2023-10-09 06:00:00	QQQ	ETF	362.2	362.47	361.9	361.92	27344.0
2023-10-09 07:00:00	QQQ	ETF	361.95	362.12	361.5	361.85	251011.0
2023-10-09 08:00:00	QQQ	ETF	361.9581	362.73	361.36	361.69	721050.0
2023-10-09 09:00:00	QQQ	ETF	361.68	363.529	360.78	363.3	6386262.0
2023-10-09 10:00:00	QQQ	ETF	363.31	363.6197	361.51	361.79	5566357.0
2023-10-09 11:00:00	QQQ	ETF	361.78	363.22	361.175	363.2	3804046.0
2023-10-09 12:00:00	QQQ	ETF	363.2	364.3	363.06	363.52	3089254.0
2023-10-09 13:00:00	QQQ	ETF	363.52	366.61	363.49	366.59	4428837.0
2023-10-09 14:00:00	QQQ	ETF	366.62	367.11	366.0001	366.76	4600442.0
2023-10-09 15:00:00	QQQ	ETF	366.76	367.08	366.0	366.56	7164270.0
2023-10-09 16:00:00	QQQ	ETF	366.55	366.83	366.49	366.68	677793.0
2023-10-09 17:00:00	QQQ	ETF	366.67	366.7494	366.581	366.7	36431.0
2023-10-09 18:00:00	QQQ	ETF	366.66	366.72	366.55	366.67	25103.0
2023-10-09 19:00:00	QQQ	ETF	366.65	366.83	366.61	366.8	53508.0
2023-10-09 04:00:00	IWM	ETF	171.08	171.58	170.97	171.52	24330.0
2023-10-09 05:00:00	IWM	ETF	171.53	171.9	171.52	171.63	20145.0
2023-10-09 06:00:00	IWM	ETF	171.57	171.79	171.45	171.46	11541.0
2023-10-09 07:00:00	IWM	ETF	171.49	171.54	171.21	171.36	36872.0
2023-10-09 08:00:00	IWM	ETF	171.34	171.62	170.91	171.1	221342.0
2023-10-09 09:00:00	IWM	ETF	171.09	172.86	171.09	172.24	3556353.0
2023-10-09 10:00:00	IWM	ETF	172.24	172.69	171.8131	172.39	3012457.0
2023-10-09 11:00:00	IWM	ETF	172.39	173.325	172.35	173.02	2132207.0
2023-10-09 12:00:00	IWM	ETF	173.03	173.4	172.72	172.87	2169111.0
2023-10-09 13:00:00	IWM	ETF	172.88	174.32	172.795	174.31	2728936.0
2023-10-09 14:00:00	IWM	ETF	174.32	174.545	174.11	174.405	1814542.0
2023-10-09 15:00:00	IWM	ETF	174.41	174.445	173.75	174.01	3826238.0
2023-10-09 16:00:00	IWM	ETF	174.0	174.2	172.8596	173.88	1286649.0
2023-10-09 17:00:00	IWM	ETF	173.89	173.99	173.89	173.9	16738.0
2023-10-09 18:00:00	IWM	ETF	173.93	173.95	173.83	173.89	16051.0
2023-10-09 19:00:00	IWM	ETF	173.84	173.98	173.84	173.98	51177.0
2023-10-09 04:00:00	DIA	ETF	332.93	332.93	331.65	332.16	3682.0
2023-10-09 05:00:00	DIA	ETF	332.37	332.83	332.37	332.51	2050.0

> showing 50 of 17,553 rows — these rows as CSV

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