PREVIEW / etf_1hour / 2023-02-02

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-02-02.parquet
  size:    508 KB
  rows:    18,627

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-02-02 04:00:00	SPY	ETF	413.32	413.34	412.24	412.84	176147.0
2023-02-02 05:00:00	SPY	ETF	412.96	413.1	412.57	412.71	30570.0
2023-02-02 06:00:00	SPY	ETF	412.62	413.0	412.21	412.5	32163.0
2023-02-02 07:00:00	SPY	ETF	412.55	413.11	412.07	413.08	312627.0
2023-02-02 08:00:00	SPY	ETF	412.2199	414.83	411.95	414.66	1137807.0
2023-02-02 09:00:00	SPY	ETF	414.63	415.08	413.33	413.555	8027962.0
2023-02-02 10:00:00	SPY	ETF	413.57	417.14	412.88	416.644	12396377.0
2023-02-02 11:00:00	SPY	ETF	416.65	417.07	415.83	415.8592	7630008.0
2023-02-02 12:00:00	SPY	ETF	415.87	416.95	415.6	416.6795	6353214.0
2023-02-02 13:00:00	SPY	ETF	416.67	418.07	416.39	418.055	6497509.0
2023-02-02 14:00:00	SPY	ETF	418.06	418.31	413.67	413.8001	12626220.0
2023-02-02 15:00:00	SPY	ETF	413.8101	416.8	413.23	416.78	17121936.0
2023-02-02 16:00:00	SPY	ETF	416.78	418.13	412.97	414.0	5351681.0
2023-02-02 17:00:00	SPY	ETF	413.94	416.0	413.75	415.31	466256.0
2023-02-02 18:00:00	SPY	ETF	415.25	415.25	413.86	413.99	191828.0
2023-02-02 19:00:00	SPY	ETF	414.07	414.55	414.06	414.45	70340.0
2023-02-02 04:00:00	QQQ	ETF	305.69	306.0	304.58	305.4	240055.0
2023-02-02 05:00:00	QQQ	ETF	305.41	305.61	304.82	304.97	59965.0
2023-02-02 06:00:00	QQQ	ETF	304.97	305.33	304.56	304.86	58359.0
2023-02-02 07:00:00	QQQ	ETF	304.8	305.9	304.49	305.87	364171.0
2023-02-02 08:00:00	QQQ	ETF	305.85	307.18	301.145	307.06	1206156.0
2023-02-02 09:00:00	QQQ	ETF	307.09	309.15	306.71	307.3462	9796918.0
2023-02-02 10:00:00	QQQ	ETF	307.3599	311.05	306.73	310.51	9140538.0
2023-02-02 11:00:00	QQQ	ETF	310.52	311.345	309.95	310.0679	6211414.0
2023-02-02 12:00:00	QQQ	ETF	310.07	311.4199	309.72	311.29	4011135.0
2023-02-02 13:00:00	QQQ	ETF	311.31	313.5	311.155	313.5	4860856.0
2023-02-02 14:00:00	QQQ	ETF	313.5005	313.68	308.34	308.47	7793734.0
2023-02-02 15:00:00	QQQ	ETF	308.48	311.76	307.78	311.76	10486299.0
2023-02-02 16:00:00	QQQ	ETF	311.76	314.0	306.03	307.3	6011009.0
2023-02-02 17:00:00	QQQ	ETF	307.15	311.72	306.6	309.2697	715261.0
2023-02-02 18:00:00	QQQ	ETF	309.2	309.29	306.9	307.07	339646.0
2023-02-02 19:00:00	QQQ	ETF	307.09	307.56	307.06	307.27	267107.0
2023-02-02 04:00:00	IWM	ETF	194.83	195.0	194.2	194.47	48630.0
2023-02-02 05:00:00	IWM	ETF	194.49	194.51	194.34	194.45	8089.0
2023-02-02 06:00:00	IWM	ETF	194.41	194.57	194.16	194.33	13769.0
2023-02-02 07:00:00	IWM	ETF	194.28	194.69	194.1	194.69	62098.0
2023-02-02 08:00:00	IWM	ETF	194.2796	195.78	194.19	195.76	169646.0
2023-02-02 09:00:00	IWM	ETF	195.74	197.45	195.6	196.24	2977059.0
2023-02-02 10:00:00	IWM	ETF	196.25	198.68	195.66	198.55	4050316.0
2023-02-02 11:00:00	IWM	ETF	198.55	198.585	197.8	197.84	2427658.0
2023-02-02 12:00:00	IWM	ETF	197.83	198.3701	197.78	198.23	1742580.0
2023-02-02 13:00:00	IWM	ETF	198.23	199.19	198.18	199.18	1882777.0
2023-02-02 14:00:00	IWM	ETF	199.175	199.26	196.36	196.41	3521815.0
2023-02-02 15:00:00	IWM	ETF	196.41	198.44	196.25	198.38	4796045.0
2023-02-02 16:00:00	IWM	ETF	198.39	198.67	197.5	198.139	1394472.0
2023-02-02 17:00:00	IWM	ETF	198.06	198.32	198.06	198.1	46142.0
2023-02-02 18:00:00	IWM	ETF	198.22	198.32	197.8	197.97	44060.0
2023-02-02 19:00:00	IWM	ETF	198.03	198.29	198.03	198.09	51165.0
2023-02-02 04:00:00	DIA	ETF	340.91	340.91	340.2	340.56	6111.0
2023-02-02 05:00:00	DIA	ETF	340.61	340.62	340.49	340.49	900.0

> showing 50 of 18,627 rows — these rows as CSV

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