PREVIEW / etf_1hour / 2022-11-10

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-11-10.parquet
  size:    481 KB
  rows:    17,747

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-11-10 04:00:00	SPY	ETF	374.88	375.36	374.71	375.21	21944.0
2022-11-10 05:00:00	SPY	ETF	375.29	375.5	374.48	375.5	13378.0
2022-11-10 06:00:00	SPY	ETF	375.53	375.8	374.68	375.31	65767.0
2022-11-10 07:00:00	SPY	ETF	375.28	375.48	374.73	375.18	185564.0
2022-11-10 08:00:00	SPY	ETF	375.2	387.07	373.68	386.37	4874849.0
2022-11-10 09:00:00	SPY	ETF	386.37	389.83	385.62	389.78	15930017.0
2022-11-10 10:00:00	SPY	ETF	389.78	390.69	387.92	390.435	14725434.0
2022-11-10 11:00:00	SPY	ETF	390.44	392.04	389.43	391.88	10786346.0
2022-11-10 12:00:00	SPY	ETF	391.87	391.875	388.97	389.09	9640872.0
2022-11-10 13:00:00	SPY	ETF	389.1	391.54	389.095	391.28	8140692.0
2022-11-10 14:00:00	SPY	ETF	391.275	392.35	390.94	392.26	7495456.0
2022-11-10 15:00:00	SPY	ETF	392.27	395.04	391.99	394.64	23281297.0
2022-11-10 16:00:00	SPY	ETF	394.65	395.82	394.41	395.76	13405765.0
2022-11-10 17:00:00	SPY	ETF	395.82	396.0	395.68	395.71	182922.0
2022-11-10 18:00:00	SPY	ETF	395.691	395.94	395.04	395.7	179003.0
2022-11-10 19:00:00	SPY	ETF	395.66	395.81	394.8	395.29	128237.0
2022-11-10 04:00:00	QQQ	ETF	264.06	264.4	263.78	264.09	43785.0
2022-11-10 05:00:00	QQQ	ETF	264.1	264.59	263.6	264.59	37113.0
2022-11-10 06:00:00	QQQ	ETF	264.56	265.0	264.0	264.59	62044.0
2022-11-10 07:00:00	QQQ	ETF	264.61	264.69	264.06	264.41	188357.0
2022-11-10 08:00:00	QQQ	ETF	264.5685	275.01	263.0	274.77	6425452.0
2022-11-10 09:00:00	QQQ	ETF	274.76	278.395	263.5	278.32	15083902.0
2022-11-10 10:00:00	QQQ	ETF	278.34	278.74	276.05	278.2121	12620364.0
2022-11-10 11:00:00	QQQ	ETF	278.23	279.5	277.26	279.3816	7355914.0
2022-11-10 12:00:00	QQQ	ETF	279.39	279.415	277.64	277.72	6653777.0
2022-11-10 13:00:00	QQQ	ETF	277.72	279.7	277.69	279.535	5678173.0
2022-11-10 14:00:00	QQQ	ETF	279.54	280.2297	279.18	280.12	4638721.0
2022-11-10 15:00:00	QQQ	ETF	280.11	283.05	279.83	282.66	14195050.0
2022-11-10 16:00:00	QQQ	ETF	282.67	283.77	279.639	283.75	3934497.0
2022-11-10 17:00:00	QQQ	ETF	283.76	284.12	283.68	283.71	360629.0
2022-11-10 18:00:00	QQQ	ETF	283.7	283.99	282.75	283.77	277626.0
2022-11-10 19:00:00	QQQ	ETF	283.8	283.92	283.01	283.51	190472.0
2022-11-10 04:00:00	IWM	ETF	174.95	175.3	174.9	175.24	10597.0
2022-11-10 05:00:00	IWM	ETF	175.21	175.38	174.9	175.38	5376.0
2022-11-10 06:00:00	IWM	ETF	175.39	175.54	175.0	175.23	13074.0
2022-11-10 07:00:00	IWM	ETF	175.21	175.29	174.93	175.09	63791.0
2022-11-10 08:00:00	IWM	ETF	175.03	181.24	174.92	181.2	1362846.0
2022-11-10 09:00:00	IWM	ETF	181.19	183.93	180.64	183.87	5147360.0
2022-11-10 10:00:00	IWM	ETF	183.87	184.84	183.27	184.77	4681463.0
2022-11-10 11:00:00	IWM	ETF	184.78	185.22	184.37	185.15	3570857.0
2022-11-10 12:00:00	IWM	ETF	185.15	185.15	183.11	183.17	2382260.0
2022-11-10 13:00:00	IWM	ETF	183.19	184.73	183.16	184.47	2387323.0
2022-11-10 14:00:00	IWM	ETF	184.48	184.67	184.26	184.51	2453769.0
2022-11-10 15:00:00	IWM	ETF	184.5	185.445	184.3	185.34	5732608.0
2022-11-10 16:00:00	IWM	ETF	185.33	185.95	185.28	185.9	2241671.0
2022-11-10 17:00:00	IWM	ETF	185.91	186.0	185.62	185.85	13353.0
2022-11-10 18:00:00	IWM	ETF	185.86	186.0	185.38	185.89	55883.0
2022-11-10 19:00:00	IWM	ETF	185.79	185.96	185.41	185.6	42139.0
2022-11-10 04:00:00	DIA	ETF	325.99	325.99	325.73	325.97	2715.0
2022-11-10 05:00:00	DIA	ETF	326.13	326.15	325.6	326.09	1748.0

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

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