PREVIEW / etf_1hour / 2022-08-30

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-08-30.parquet
  size:    448 KB
  rows:    16,172

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-08-30 04:00:00	SPY	ETF	404.9	406.73	404.9	406.0	196610.0
2022-08-30 05:00:00	SPY	ETF	406.05	406.39	405.47	406.15	178453.0
2022-08-30 06:00:00	SPY	ETF	406.13	406.65	405.81	405.81	289174.0
2022-08-30 07:00:00	SPY	ETF	405.71	406.03	405.08	405.22	268078.0
2022-08-30 08:00:00	SPY	ETF	405.25	406.37	403.36	404.04	654355.0
2022-08-30 09:00:00	SPY	ETF	404.06	404.3	401.5415	401.865	5532252.0
2022-08-30 10:00:00	SPY	ETF	401.88	402.4	396.38	398.3699	12998768.0
2022-08-30 11:00:00	SPY	ETF	398.38	399.605	397.78	398.731	9073443.0
2022-08-30 12:00:00	SPY	ETF	398.74	399.96	397.41	398.0	6042487.0
2022-08-30 13:00:00	SPY	ETF	398.01	398.4	396.0	397.395	6025897.0
2022-08-30 14:00:00	SPY	ETF	397.4	398.08	396.84	397.33	6470718.0
2022-08-30 15:00:00	SPY	ETF	397.336	399.38	397.08	398.18	14631294.0
2022-08-30 16:00:00	SPY	ETF	398.17	398.75	397.97	398.23	3355170.0
2022-08-30 17:00:00	SPY	ETF	398.16	398.22	398.0	398.17	48744.0
2022-08-30 18:00:00	SPY	ETF	398.19	398.46	397.91	398.4	81328.0
2022-08-30 19:00:00	SPY	ETF	398.4	398.4	397.8	398.34	144596.0
2022-08-30 04:00:00	QQQ	ETF	307.0	308.39	307.0	307.81	87656.0
2022-08-30 05:00:00	QQQ	ETF	307.82	308.14	307.33	307.95	174505.0
2022-08-30 06:00:00	QQQ	ETF	307.69	308.27	307.69	307.7	53422.0
2022-08-30 07:00:00	QQQ	ETF	307.72	307.89	307.03	307.2	439601.0
2022-08-30 08:00:00	QQQ	ETF	307.2	308.3796	304.638	306.1	401618.0
2022-08-30 09:00:00	QQQ	ETF	306.08	306.73	303.68	304.09	5120959.0
2022-08-30 10:00:00	QQQ	ETF	304.13	304.48	298.97	300.83	9564430.0
2022-08-30 11:00:00	QQQ	ETF	300.83	301.69	299.88	300.815	5895161.0
2022-08-30 12:00:00	QQQ	ETF	300.76	302.0283	299.48	300.05	3557389.0
2022-08-30 13:00:00	QQQ	ETF	300.06	300.43	298.44	299.7	4305561.0
2022-08-30 14:00:00	QQQ	ETF	299.7	300.32	299.22	299.85	3082328.0
2022-08-30 15:00:00	QQQ	ETF	299.87	301.79	299.7617	301.0	8152651.0
2022-08-30 16:00:00	QQQ	ETF	300.99	301.63	300.95	301.16	1094804.0
2022-08-30 17:00:00	QQQ	ETF	301.14	301.29	301.1	301.29	35126.0
2022-08-30 18:00:00	QQQ	ETF	301.28	301.4	300.9	301.37	80905.0
2022-08-30 19:00:00	QQQ	ETF	301.36	301.45	300.9	301.34	67547.0
2022-08-30 04:00:00	IWM	ETF	188.91	189.19	188.72	188.86	44751.0
2022-08-30 05:00:00	IWM	ETF	188.84	189.08	188.53	188.95	14253.0
2022-08-30 06:00:00	IWM	ETF	188.89	189.06	188.6	188.6	8566.0
2022-08-30 07:00:00	IWM	ETF	188.61	188.78	188.28	188.39	150498.0
2022-08-30 08:00:00	IWM	ETF	188.66	188.7	187.8	187.89	106921.0
2022-08-30 09:00:00	IWM	ETF	187.91	188.01	186.08	186.19	2308967.0
2022-08-30 10:00:00	IWM	ETF	186.17	186.51	184.01	185.06	3392658.0
2022-08-30 11:00:00	IWM	ETF	185.05	185.4	184.29	184.93	2053259.0
2022-08-30 12:00:00	IWM	ETF	184.88	185.41	184.12	184.375	1295761.0
2022-08-30 13:00:00	IWM	ETF	184.375	184.6	183.535	184.18	1868309.0
2022-08-30 14:00:00	IWM	ETF	184.16	184.57	183.92	184.2	1300982.0
2022-08-30 15:00:00	IWM	ETF	184.16	185.14	184.07	184.59	4122952.0
2022-08-30 16:00:00	IWM	ETF	184.62	184.85	184.49	184.62	952639.0
2022-08-30 17:00:00	IWM	ETF	184.58	184.61	184.39	184.55	27379.0
2022-08-30 18:00:00	IWM	ETF	184.58	184.69	184.35	184.69	62467.0
2022-08-30 19:00:00	IWM	ETF	184.68	184.71	184.37	184.58	16075.0
2022-08-30 04:00:00	DIA	ETF	323.53	323.71	323.41	323.71	4300.0
2022-08-30 05:00:00	DIA	ETF	323.0	323.56	322.95	323.47	1800.0

> showing 50 of 16,172 rows — these rows as CSV

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