PREVIEW / etf_1hour / 2023-01-13

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-01-13.parquet
  size:    470 KB
  rows:    17,024

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-01-13 04:00:00	SPY	ETF	396.92	397.23	396.5	397.05	51415.0
2023-01-13 05:00:00	SPY	ETF	397.06	397.31	396.84	397.07	21822.0
2023-01-13 06:00:00	SPY	ETF	397.0	397.0	395.38	395.51	146237.0
2023-01-13 07:00:00	SPY	ETF	395.56	395.79	393.43	393.5	333726.0
2023-01-13 08:00:00	SPY	ETF	395.65	397.1504	392.97	393.34	508563.0
2023-01-13 09:00:00	SPY	ETF	393.5	395.22	393.02	394.73	5632192.0
2023-01-13 10:00:00	SPY	ETF	394.75	396.76	394.33	396.38	8497724.0
2023-01-13 11:00:00	SPY	ETF	396.3799	396.58	395.23	395.8	5159119.0
2023-01-13 12:00:00	SPY	ETF	395.81	396.835	395.715	396.7	3516140.0
2023-01-13 13:00:00	SPY	ETF	396.695	397.67	396.0901	397.52	4764467.0
2023-01-13 14:00:00	SPY	ETF	397.5125	397.84	397.16	397.64	5164189.0
2023-01-13 15:00:00	SPY	ETF	397.66	399.1	397.6	398.47	11526511.0
2023-01-13 16:00:00	SPY	ETF	398.48	398.66	398.11	398.6	2805307.0
2023-01-13 17:00:00	SPY	ETF	398.5	398.7	398.3	398.4	735087.0
2023-01-13 18:00:00	SPY	ETF	398.4	398.49	398.25	398.3	17540.0
2023-01-13 19:00:00	SPY	ETF	398.3	398.5	398.2	398.4	15729.0
2023-01-13 04:00:00	QQQ	ETF	278.95	279.0	278.29	278.93	36098.0
2023-01-13 05:00:00	QQQ	ETF	278.74	279.075	278.58	278.75	23190.0
2023-01-13 06:00:00	QQQ	ETF	278.62	278.62	277.36	277.74	188261.0
2023-01-13 07:00:00	QQQ	ETF	277.74	277.9	276.06	276.2	331173.0
2023-01-13 08:00:00	QQQ	ETF	276.25	278.88	275.81	276.05	628567.0
2023-01-13 09:00:00	QQQ	ETF	276.08	277.81	275.71	277.32	5095747.0
2023-01-13 10:00:00	QQQ	ETF	277.3	279.27	276.97	278.77	5934397.0
2023-01-13 11:00:00	QQQ	ETF	278.76	278.96	277.2301	277.9999	3748955.0
2023-01-13 12:00:00	QQQ	ETF	277.98	279.04	277.8899	278.95	2435857.0
2023-01-13 13:00:00	QQQ	ETF	278.96	279.99	278.47	279.82	3063354.0
2023-01-13 14:00:00	QQQ	ETF	279.85	280.24	279.52	279.92	2958527.0
2023-01-13 15:00:00	QQQ	ETF	279.96	281.219	279.87	280.94	7193059.0
2023-01-13 16:00:00	QQQ	ETF	280.95	281.01	280.45	280.81	2526496.0
2023-01-13 17:00:00	QQQ	ETF	280.81	280.81	280.62	280.68	32835.0
2023-01-13 18:00:00	QQQ	ETF	280.68	280.75	280.5899	280.68	11430.0
2023-01-13 19:00:00	QQQ	ETF	280.68	280.68	280.4	280.61	63674.0
2023-01-13 04:00:00	IWM	ETF	185.93	186.29	185.91	186.29	11722.0
2023-01-13 05:00:00	IWM	ETF	186.24	186.37	186.09	186.27	8084.0
2023-01-13 06:00:00	IWM	ETF	186.21	186.21	185.43	185.51	26829.0
2023-01-13 07:00:00	IWM	ETF	185.51	185.61	184.4	184.42	83247.0
2023-01-13 08:00:00	IWM	ETF	185.53	186.02	184.09	184.2	110792.0
2023-01-13 09:00:00	IWM	ETF	184.27	185.34	184.05	185.1313	2286924.0
2023-01-13 10:00:00	IWM	ETF	185.13	186.35	184.88	186.21	2941285.0
2023-01-13 11:00:00	IWM	ETF	186.215	186.44	185.715	186.105	1621694.0
2023-01-13 12:00:00	IWM	ETF	186.1009	186.7	186.02	186.57	932012.0
2023-01-13 13:00:00	IWM	ETF	186.58	187.11	186.23	186.945	1204122.0
2023-01-13 14:00:00	IWM	ETF	186.95	187.01	186.3	186.36	1232145.0
2023-01-13 15:00:00	IWM	ETF	186.375	187.34	186.34	187.04	3726261.0
2023-01-13 16:00:00	IWM	ETF	187.05	187.11	186.71	186.96	1466917.0
2023-01-13 17:00:00	IWM	ETF	186.93	187.03	186.84	186.92	11283.0
2023-01-13 18:00:00	IWM	ETF	186.93	186.97	186.83	186.87	3792.0
2023-01-13 19:00:00	IWM	ETF	186.92	187.0	186.86	187.0	11103.0
2023-01-13 04:00:00	DIA	ETF	342.02	342.06	342.02	342.02	12121.0
2023-01-13 06:00:00	DIA	ETF	341.64	341.78	341.0	341.01	15419.0

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

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