PREVIEW / etf_1hour / 2022-12-15

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-12-15.parquet
  size:    475 KB
  rows:    17,313

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-12-15 04:00:00	SPY	ETF	396.33	396.5	394.88	395.7	150184.0
2022-12-15 05:00:00	SPY	ETF	395.54	395.9	395.03	395.44	36210.0
2022-12-15 06:00:00	SPY	ETF	395.39	396.2	395.34	396.19	172687.0
2022-12-15 07:00:00	SPY	ETF	396.12	396.31	395.6	396.15	307886.0
2022-12-15 08:00:00	SPY	ETF	396.1008	400.07	393.67	394.57	1450014.0
2022-12-15 09:00:00	SPY	ETF	394.49	395.25	391.17	391.575	9824392.0
2022-12-15 10:00:00	SPY	ETF	391.6	391.94	390.25	390.7	13961820.0
2022-12-15 11:00:00	SPY	ETF	390.7	391.14	388.73	389.26	9772387.0
2022-12-15 12:00:00	SPY	ETF	389.24	390.41	388.62	388.87	7064745.0
2022-12-15 13:00:00	SPY	ETF	388.89	388.975	387.885	388.7501	7305190.0
2022-12-15 14:00:00	SPY	ETF	388.76	390.265	388.12	390.22	8529262.0
2022-12-15 15:00:00	SPY	ETF	390.21	390.88	388.94	389.65	19941764.0
2022-12-15 16:00:00	SPY	ETF	389.64	389.93	388.66	389.18	7209897.0
2022-12-15 17:00:00	SPY	ETF	389.0	389.63	388.9	389.0	222677.0
2022-12-15 18:00:00	SPY	ETF	389.05	389.73	389.05	389.51	246687.0
2022-12-15 19:00:00	SPY	ETF	389.55	389.84	389.45	389.55	93432.0
2022-12-15 04:00:00	QQQ	ETF	286.7	286.7	282.45	283.13	224487.0
2022-12-15 05:00:00	QQQ	ETF	283.08	283.12	282.52	282.55	48062.0
2022-12-15 06:00:00	QQQ	ETF	282.62	283.34	282.49	283.34	121639.0
2022-12-15 07:00:00	QQQ	ETF	283.37	283.59	282.96	283.51	245019.0
2022-12-15 08:00:00	QQQ	ETF	283.43	286.724	281.33	282.24	895384.0
2022-12-15 09:00:00	QQQ	ETF	282.22	283.01	279.29	279.68	6130866.0
2022-12-15 10:00:00	QQQ	ETF	279.7	279.76	278.05	278.37	8201037.0
2022-12-15 11:00:00	QQQ	ETF	278.35	278.775	276.97	277.2101	6095757.0
2022-12-15 12:00:00	QQQ	ETF	277.24	277.95	276.45	276.674	4939138.0
2022-12-15 13:00:00	QQQ	ETF	276.7	276.87	275.67	276.38	4500782.0
2022-12-15 14:00:00	QQQ	ETF	276.37	277.53	275.85	277.47	4304789.0
2022-12-15 15:00:00	QQQ	ETF	277.47	277.89	276.24	276.92	9785985.0
2022-12-15 16:00:00	QQQ	ETF	276.92	277.28	276.37	276.69	1616842.0
2022-12-15 17:00:00	QQQ	ETF	276.77	276.89	276.33	276.49	536766.0
2022-12-15 18:00:00	QQQ	ETF	276.57	276.95	276.52	276.83	78360.0
2022-12-15 19:00:00	QQQ	ETF	276.89	277.1101	276.75	276.79	86919.0
2022-12-15 04:00:00	IWM	ETF	178.74	178.74	178.01	178.36	38177.0
2022-12-15 05:00:00	IWM	ETF	178.15	178.56	178.04	178.38	25279.0
2022-12-15 06:00:00	IWM	ETF	178.35	178.81	178.32	178.79	10673.0
2022-12-15 07:00:00	IWM	ETF	178.72	178.9	178.41	178.72	113501.0
2022-12-15 08:00:00	IWM	ETF	178.79	179.0	177.5	177.96	245783.0
2022-12-15 09:00:00	IWM	ETF	177.94	178.6	176.7401	176.93	2768913.0
2022-12-15 10:00:00	IWM	ETF	176.95	177.66	176.295	176.5501	3554562.0
2022-12-15 11:00:00	IWM	ETF	176.55	176.78	175.44	176.06	2812152.0
2022-12-15 12:00:00	IWM	ETF	176.05	176.84	175.89	175.94	2502186.0
2022-12-15 13:00:00	IWM	ETF	175.94	175.99	175.21	175.56	2256705.0
2022-12-15 14:00:00	IWM	ETF	175.56	176.28	175.04	176.2599	2081096.0
2022-12-15 15:00:00	IWM	ETF	176.26	176.42	175.18	175.73	4089190.0
2022-12-15 16:00:00	IWM	ETF	175.68	175.75	175.1	175.37	1437771.0
2022-12-15 17:00:00	IWM	ETF	175.29	175.48	175.2	175.48	7593.0
2022-12-15 18:00:00	IWM	ETF	175.35	175.66	175.33	175.59	52583.0
2022-12-15 19:00:00	IWM	ETF	175.6	175.81	175.58	175.63	35799.0
2022-12-15 04:00:00	DIA	ETF	338.04	338.04	337.32	337.9	20593.0
2022-12-15 05:00:00	DIA	ETF	337.61	338.13	337.54	338.13	1637.0

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

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