PREVIEW / etf_1hour / 2022-10-26

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-10-26.parquet
  size:    464 KB
  rows:    17,131

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-10-26 04:00:00	SPY	ETF	382.15	383.22	381.86	383.13	109372.0
2022-10-26 05:00:00	SPY	ETF	382.9	382.96	381.8	381.81	42467.0
2022-10-26 06:00:00	SPY	ETF	381.86	382.73	381.54	382.55	153910.0
2022-10-26 07:00:00	SPY	ETF	382.53	383.27	381.77	382.03	327599.0
2022-10-26 08:00:00	SPY	ETF	382.48	383.27	381.06	381.7	574749.0
2022-10-26 09:00:00	SPY	ETF	381.63	383.15	381.35	381.69	7687444.0
2022-10-26 10:00:00	SPY	ETF	381.72	385.95	381.72	385.04	11253727.0
2022-10-26 11:00:00	SPY	ETF	385.03	387.58	385.03	386.82	7494526.0
2022-10-26 12:00:00	SPY	ETF	386.81	387.24	384.05	384.34	7184104.0
2022-10-26 13:00:00	SPY	ETF	384.33	384.4499	382.72	383.78	8479539.0
2022-10-26 14:00:00	SPY	ETF	383.7778	384.3399	381.97	382.4099	7419144.0
2022-10-26 15:00:00	SPY	ETF	382.4	383.01	381.47	382.08	15604787.0
2022-10-26 16:00:00	SPY	ETF	382.09	383.56	381.91	383.17	5186413.0
2022-10-26 17:00:00	SPY	ETF	383.17	383.17	382.02	382.5518	377279.0
2022-10-26 18:00:00	SPY	ETF	382.55	383.081	382.02	382.95	228741.0
2022-10-26 19:00:00	SPY	ETF	383.05	384.04	383.0	383.86	124881.0
2022-10-26 04:00:00	QQQ	ETF	279.32	280.72	279.32	280.58	203085.0
2022-10-26 05:00:00	QQQ	ETF	280.49	280.49	279.38	279.58	87275.0
2022-10-26 06:00:00	QQQ	ETF	279.53	280.03	279.29	279.88	157458.0
2022-10-26 07:00:00	QQQ	ETF	279.89	280.4	279.16	279.46	444735.0
2022-10-26 08:00:00	QQQ	ETF	279.86	284.423	278.58	279.21	830401.0
2022-10-26 09:00:00	QQQ	ETF	279.2	279.79	277.43	278.6601	7887989.0
2022-10-26 10:00:00	QQQ	ETF	278.64	282.8	278.64	281.595	9505323.0
2022-10-26 11:00:00	QQQ	ETF	281.59	283.98	281.59	283.08	6069777.0
2022-10-26 12:00:00	QQQ	ETF	283.0701	283.41	280.19	280.44	5577006.0
2022-10-26 13:00:00	QQQ	ETF	280.38	280.382	278.38	279.65	6187438.0
2022-10-26 14:00:00	QQQ	ETF	279.66	280.085	278.04	278.55	4372654.0
2022-10-26 15:00:00	QQQ	ETF	278.5	278.655	277.53	277.91	8755216.0
2022-10-26 16:00:00	QQQ	ETF	277.91	279.94	277.0	278.4	2625652.0
2022-10-26 17:00:00	QQQ	ETF	278.39	278.42	277.31	277.48	643678.0
2022-10-26 18:00:00	QQQ	ETF	277.29	278.16	277.03	278.16	476715.0
2022-10-26 19:00:00	QQQ	ETF	278.1	279.17	278.1	279.0	215610.0
2022-10-26 04:00:00	IWM	ETF	178.71	179.49	178.68	179.26	46654.0
2022-10-26 05:00:00	IWM	ETF	179.21	179.22	178.6	178.65	59265.0
2022-10-26 06:00:00	IWM	ETF	178.69	179.35	178.59	179.29	89196.0
2022-10-26 07:00:00	IWM	ETF	179.19	179.66	178.98	179.11	63212.0
2022-10-26 08:00:00	IWM	ETF	179.1509	179.58	178.27	178.85	224628.0
2022-10-26 09:00:00	IWM	ETF	178.85	179.86	178.33	178.41	4627977.0
2022-10-26 10:00:00	IWM	ETF	178.42	181.3	178.42	180.74	5079673.0
2022-10-26 11:00:00	IWM	ETF	180.75	182.26	180.75	181.8	3459997.0
2022-10-26 12:00:00	IWM	ETF	181.805	182.37	180.47	180.68	2862078.0
2022-10-26 13:00:00	IWM	ETF	180.67	180.805	179.84	180.57	2484052.0
2022-10-26 14:00:00	IWM	ETF	180.58	180.82	179.45	179.78	2011944.0
2022-10-26 15:00:00	IWM	ETF	179.77	179.81	178.95	179.05	3893210.0
2022-10-26 16:00:00	IWM	ETF	179.05	179.99	179.05	179.85	2055771.0
2022-10-26 17:00:00	IWM	ETF	179.78	179.85	179.44	179.44	12731.0
2022-10-26 18:00:00	IWM	ETF	179.51	180.01	179.05	179.98	163683.0
2022-10-26 19:00:00	IWM	ETF	179.97	180.38	179.97	180.25	46587.0
2022-10-26 04:00:00	DIA	ETF	318.13	318.5	318.1	318.28	3891.0
2022-10-26 05:00:00	DIA	ETF	318.14	318.14	317.89	317.93	5083.0

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

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