PREVIEW / etf_1hour / 2023-06-29

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-06-29.parquet
  size:    477 KB
  rows:    17,270

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-06-29 04:00:00	SPY	ETF	436.33	436.97	436.25	436.94	34044.0
2023-06-29 05:00:00	SPY	ETF	436.9	437.34	436.75	437.32	21485.0
2023-06-29 06:00:00	SPY	ETF	437.29	437.75	437.18	437.6	30585.0
2023-06-29 07:00:00	SPY	ETF	437.59	437.8	437.43	437.55	112157.0
2023-06-29 08:00:00	SPY	ETF	437.6	438.18	436.32	436.75	707225.0
2023-06-29 09:00:00	SPY	ETF	436.77	436.98	435.54	436.7	6196430.0
2023-06-29 10:00:00	SPY	ETF	436.73	437.37	435.91	436.4	8296878.0
2023-06-29 11:00:00	SPY	ETF	436.4	437.88	436.32	437.71	6639559.0
2023-06-29 12:00:00	SPY	ETF	437.72	438.28	437.26	437.68	5568642.0
2023-06-29 13:00:00	SPY	ETF	437.67	437.7699	436.93	437.1	4795292.0
2023-06-29 14:00:00	SPY	ETF	437.095	437.4108	436.39	437.4108	5110557.0
2023-06-29 15:00:00	SPY	ETF	437.42	438.17	437.145	438.14	11226780.0
2023-06-29 16:00:00	SPY	ETF	438.15	438.29	437.99	438.12	2461541.0
2023-06-29 17:00:00	SPY	ETF	438.11	438.25	438.11	438.11	268718.0
2023-06-29 18:00:00	SPY	ETF	438.11	438.21	438.01	438.16	92692.0
2023-06-29 19:00:00	SPY	ETF	438.2	438.39	438.18	438.28	36402.0
2023-06-29 04:00:00	QQQ	ETF	364.52	365.3	364.52	365.26	45365.0
2023-06-29 05:00:00	QQQ	ETF	365.22	365.67	365.0	365.66	15924.0
2023-06-29 06:00:00	QQQ	ETF	365.6	366.16	365.43	365.91	33907.0
2023-06-29 07:00:00	QQQ	ETF	365.85	366.01	365.56	365.76	119516.0
2023-06-29 08:00:00	QQQ	ETF	365.9098	366.25	364.4	364.7	1106575.0
2023-06-29 09:00:00	QQQ	ETF	364.79	364.89	363.3	363.79	5627753.0
2023-06-29 10:00:00	QQQ	ETF	363.81	364.6	362.14	363.1138	6224156.0
2023-06-29 11:00:00	QQQ	ETF	363.1284	364.69	362.98	364.3775	4058404.0
2023-06-29 12:00:00	QQQ	ETF	364.38	364.78	363.2575	363.54	3495024.0
2023-06-29 13:00:00	QQQ	ETF	363.56	363.9	362.76	362.87	3475990.0
2023-06-29 14:00:00	QQQ	ETF	362.86	363.33	362.28	363.3099	3307742.0
2023-06-29 15:00:00	QQQ	ETF	363.31	363.96	362.825	363.85	5030271.0
2023-06-29 16:00:00	QQQ	ETF	363.85	364.2	363.75	364.03	1150098.0
2023-06-29 17:00:00	QQQ	ETF	364.02	364.05	363.87	363.87	28916.0
2023-06-29 18:00:00	QQQ	ETF	363.97	364.1	363.8	363.99	158340.0
2023-06-29 19:00:00	QQQ	ETF	363.99	364.41	363.99	364.22	85469.0
2023-06-29 04:00:00	IWM	ETF	184.44	184.58	184.09	184.51	16222.0
2023-06-29 05:00:00	IWM	ETF	184.61	184.79	184.41	184.79	3714.0
2023-06-29 06:00:00	IWM	ETF	184.75	185.02	184.75	184.89	22443.0
2023-06-29 07:00:00	IWM	ETF	184.92	185.07	184.85	185.05	36420.0
2023-06-29 08:00:00	IWM	ETF	184.94	185.57	184.2	185.43	471885.0
2023-06-29 09:00:00	IWM	ETF	185.44	186.82	184.41	186.61	5262851.0
2023-06-29 10:00:00	IWM	ETF	186.62	187.08	186.14	186.23	4903062.0
2023-06-29 11:00:00	IWM	ETF	186.24	186.7799	185.85	185.9999	2503869.0
2023-06-29 12:00:00	IWM	ETF	186.0	186.905	185.99	186.65	2188579.0
2023-06-29 13:00:00	IWM	ETF	186.64	186.99	186.155	186.48	1754201.0
2023-06-29 14:00:00	IWM	ETF	186.49	186.65	185.95	186.47	1390509.0
2023-06-29 15:00:00	IWM	ETF	186.48	186.715	186.32	186.64	4785363.0
2023-06-29 16:00:00	IWM	ETF	186.38	186.76	186.38	186.54	1170792.0
2023-06-29 17:00:00	IWM	ETF	186.53	186.65	186.51	186.63	2580.0
2023-06-29 18:00:00	IWM	ETF	186.6	186.69	186.5	186.68	14226.0
2023-06-29 19:00:00	IWM	ETF	186.7	186.77	186.67	186.74	15610.0
2023-06-29 04:00:00	DIA	ETF	338.81	339.09	338.79	339.08	1536.0
2023-06-29 05:00:00	DIA	ETF	339.15	339.15	339.15	339.15	100.0

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

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