PREVIEW / etf_1hour / 2023-07-10

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-07-10.parquet
  size:    480 KB
  rows:    17,349

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-07-10 04:00:00	SPY	ETF	437.14	437.86	437.04	437.54	69046.0
2023-07-10 05:00:00	SPY	ETF	437.56	437.9	437.56	437.65	12643.0
2023-07-10 06:00:00	SPY	ETF	437.64	438.13	437.49	438.13	29438.0
2023-07-10 07:00:00	SPY	ETF	438.15	438.75	438.11	438.69	162274.0
2023-07-10 08:00:00	SPY	ETF	438.16	439.0	436.5	438.32	470791.0
2023-07-10 09:00:00	SPY	ETF	438.35	439.348	438.04	439.095	5268623.0
2023-07-10 10:00:00	SPY	ETF	439.08	439.84	438.37	438.6299	7627040.0
2023-07-10 11:00:00	SPY	ETF	438.6208	439.08	438.01	438.4201	5220324.0
2023-07-10 12:00:00	SPY	ETF	438.44	438.98	437.585	438.88	5154561.0
2023-07-10 13:00:00	SPY	ETF	438.88	439.4	438.77	438.97	3825136.0
2023-07-10 14:00:00	SPY	ETF	438.97	439.435	438.5299	439.26	3837275.0
2023-07-10 15:00:00	SPY	ETF	439.265	439.67	438.61	439.66	9874795.0
2023-07-10 16:00:00	SPY	ETF	439.65	439.96	438.98	439.61	3465844.0
2023-07-10 17:00:00	SPY	ETF	439.61	439.7	439.56	439.61	51746.0
2023-07-10 18:00:00	SPY	ETF	439.61	439.7	439.37	439.66	45644.0
2023-07-10 19:00:00	SPY	ETF	439.63	439.7	439.47	439.7	25319.0
2023-07-10 04:00:00	QQQ	ETF	364.62	365.43	364.57	364.85	65116.0
2023-07-10 05:00:00	QQQ	ETF	364.9	365.24	364.81	364.87	20340.0
2023-07-10 06:00:00	QQQ	ETF	364.84	365.27	364.7	365.25	37657.0
2023-07-10 07:00:00	QQQ	ETF	365.27	366.2	365.21	366.16	152144.0
2023-07-10 08:00:00	QQQ	ETF	365.72	366.64	363.97	365.88	416352.0
2023-07-10 09:00:00	QQQ	ETF	365.93	367.05	363.93	364.64	6274244.0
2023-07-10 10:00:00	QQQ	ETF	364.6497	366.7876	364.55	365.43	6360896.0
2023-07-10 11:00:00	QQQ	ETF	365.42	366.09	364.51	364.67	4013981.0
2023-07-10 12:00:00	QQQ	ETF	364.67	365.635	363.41	365.47	4294948.0
2023-07-10 13:00:00	QQQ	ETF	365.48	366.22	365.21	365.53	2999306.0
2023-07-10 14:00:00	QQQ	ETF	365.54	366.51	365.1	366.4	3464556.0
2023-07-10 15:00:00	QQQ	ETF	366.41	366.47	365.48	366.46	4602982.0
2023-07-10 16:00:00	QQQ	ETF	366.46	367.1	366.36	366.5	1283846.0
2023-07-10 17:00:00	QQQ	ETF	366.5	366.59	366.47	366.52	30444.0
2023-07-10 18:00:00	QQQ	ETF	366.5	366.52	366.2	366.48	46435.0
2023-07-10 19:00:00	QQQ	ETF	366.43	366.5	366.22	366.5	36060.0
2023-07-10 04:00:00	IWM	ETF	183.99	184.56	183.95	184.56	25772.0
2023-07-10 05:00:00	IWM	ETF	184.46	184.68	184.46	184.55	3282.0
2023-07-10 06:00:00	IWM	ETF	184.45	184.77	184.43	184.77	15906.0
2023-07-10 07:00:00	IWM	ETF	184.76	185.09	184.68	185.02	88657.0
2023-07-10 08:00:00	IWM	ETF	184.82	185.22	183.8	184.9	164669.0
2023-07-10 09:00:00	IWM	ETF	184.93	186.86	184.16	186.82	3566144.0
2023-07-10 10:00:00	IWM	ETF	186.81	187.68	186.59	187.25	4039059.0
2023-07-10 11:00:00	IWM	ETF	187.245	187.3747	186.69	187.2867	1934067.0
2023-07-10 12:00:00	IWM	ETF	187.28	187.44	186.8	187.25	1728895.0
2023-07-10 13:00:00	IWM	ETF	187.25	187.575	187.14	187.56	1182032.0
2023-07-10 14:00:00	IWM	ETF	187.57	187.8208	187.345	187.72	1821730.0
2023-07-10 15:00:00	IWM	ETF	187.73	188.05	187.4	188.02	4202058.0
2023-07-10 16:00:00	IWM	ETF	187.87	188.16	187.87	188.11	2326021.0
2023-07-10 17:00:00	IWM	ETF	188.1	188.2	188.1	188.18	76060.0
2023-07-10 18:00:00	IWM	ETF	188.16	188.25	188.08	188.22	43622.0
2023-07-10 19:00:00	IWM	ETF	188.22	188.33	188.14	188.29	29239.0
2023-07-10 04:00:00	DIA	ETF	336.89	337.19	336.62	337.07	4350.0
2023-07-10 05:00:00	DIA	ETF	337.33	337.35	337.33	337.35	1000.0

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

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