PREVIEW / etf_1hour / 2023-08-23

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-08-23.parquet
  size:    481 KB
  rows:    17,580

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-08-23 04:00:00	SPY	ETF	439.81	440.67	439.74	440.45	30101.0
2023-08-23 05:00:00	SPY	ETF	440.39	440.62	440.04	440.41	21477.0
2023-08-23 06:00:00	SPY	ETF	440.36	440.49	439.2	439.36	46172.0
2023-08-23 07:00:00	SPY	ETF	439.4	439.41	438.5	439.01	415781.0
2023-08-23 08:00:00	SPY	ETF	439.19	440.6	438.17	438.54	624947.0
2023-08-23 09:00:00	SPY	ETF	438.55	440.62	438.51	440.3701	6048678.0
2023-08-23 10:00:00	SPY	ETF	440.37	442.0	440.21	441.92	8612341.0
2023-08-23 11:00:00	SPY	ETF	441.925	442.395	441.52	442.3	5987681.0
2023-08-23 12:00:00	SPY	ETF	442.295	442.67	441.92	442.2001	3580547.0
2023-08-23 13:00:00	SPY	ETF	442.2	443.67	442.13	443.55	5462348.0
2023-08-23 14:00:00	SPY	ETF	443.555	443.58	442.46	442.7075	4632077.0
2023-08-23 15:00:00	SPY	ETF	442.7	443.44	442.39	442.97	12649144.0
2023-08-23 16:00:00	SPY	ETF	442.98	445.73	442.68	445.72	3748216.0
2023-08-23 17:00:00	SPY	ETF	445.59	445.79	445.38	445.45	179007.0
2023-08-23 18:00:00	SPY	ETF	445.38	445.38	444.66	445.08	142313.0
2023-08-23 19:00:00	SPY	ETF	445.1	445.22	444.95	445.09	58825.0
2023-08-23 04:00:00	QQQ	ETF	365.61	366.35	365.36	365.96	50658.0
2023-08-23 05:00:00	QQQ	ETF	366.05	366.21	365.51	365.73	33816.0
2023-08-23 06:00:00	QQQ	ETF	365.68	365.7	364.66	364.83	32473.0
2023-08-23 07:00:00	QQQ	ETF	364.83	364.92	363.4	364.0	319737.0
2023-08-23 08:00:00	QQQ	ETF	364.82	366.2096	363.39	363.985	559881.0
2023-08-23 09:00:00	QQQ	ETF	363.99	366.92	363.99	366.602	5248204.0
2023-08-23 10:00:00	QQQ	ETF	366.6	368.81	366.35	368.66	6350207.0
2023-08-23 11:00:00	QQQ	ETF	368.67	369.34	368.38	369.198	4866297.0
2023-08-23 12:00:00	QQQ	ETF	369.2	369.24	368.43	368.65	2536418.0
2023-08-23 13:00:00	QQQ	ETF	368.64	370.22	368.52	370.08	3602158.0
2023-08-23 14:00:00	QQQ	ETF	370.07	370.0896	368.85	369.33	2976836.0
2023-08-23 15:00:00	QQQ	ETF	369.31	370.0	368.83	369.17	6272712.0
2023-08-23 16:00:00	QQQ	ETF	369.16	372.95	369.0	372.93	6494029.0
2023-08-23 17:00:00	QQQ	ETF	372.95	373.3	372.36	372.4	442070.0
2023-08-23 18:00:00	QQQ	ETF	372.4	372.67	371.54	372.13	250123.0
2023-08-23 19:00:00	QQQ	ETF	372.08	372.58	372.08	372.46	157753.0
2023-08-23 04:00:00	IWM	ETF	184.74	185.03	184.7	184.9	15475.0
2023-08-23 05:00:00	IWM	ETF	184.9	184.96	184.57	184.82	12740.0
2023-08-23 06:00:00	IWM	ETF	184.75	184.75	184.17	184.18	12628.0
2023-08-23 07:00:00	IWM	ETF	184.29	184.3	184.01	184.3	32488.0
2023-08-23 08:00:00	IWM	ETF	184.17	184.77	183.7	183.8	159666.0
2023-08-23 09:00:00	IWM	ETF	183.8	184.53	183.425	184.3	2631378.0
2023-08-23 10:00:00	IWM	ETF	184.3	185.16	184.27	185.1	2811370.0
2023-08-23 11:00:00	IWM	ETF	185.1	185.7499	185.0	185.605	2244560.0
2023-08-23 12:00:00	IWM	ETF	185.6	185.94	185.45	185.68	1245079.0
2023-08-23 13:00:00	IWM	ETF	185.68	186.11	185.63	185.985	1425648.0
2023-08-23 14:00:00	IWM	ETF	185.98	186.01	185.683	185.81	1917161.0
2023-08-23 15:00:00	IWM	ETF	185.8	185.96	185.505	185.74	3728580.0
2023-08-23 16:00:00	IWM	ETF	185.79	186.04	185.43	186.02	1582011.0
2023-08-23 17:00:00	IWM	ETF	186.02	186.2	185.86	185.86	87206.0
2023-08-23 18:00:00	IWM	ETF	185.95	185.99	185.66	185.87	45421.0
2023-08-23 19:00:00	IWM	ETF	185.83	185.95	185.73	185.82	17058.0
2023-08-23 04:00:00	DIA	ETF	344.04	344.3	344.04	344.28	2244.0
2023-08-23 05:00:00	DIA	ETF	344.09	344.12	344.03	344.12	2170.0

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

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