PREVIEW / etf_1hour / 2023-01-17

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-01-17.parquet
  size:    479 KB
  rows:    17,564

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-17 04:00:00	SPY	ETF	397.95	397.95	396.88	397.31	58571.0
2023-01-17 05:00:00	SPY	ETF	397.33	397.8	397.09	397.69	26897.0
2023-01-17 06:00:00	SPY	ETF	397.56	397.82	397.38	397.75	28526.0
2023-01-17 07:00:00	SPY	ETF	397.79	398.09	397.23	397.39	164863.0
2023-01-17 08:00:00	SPY	ETF	397.64	398.11	397.03	397.45	344076.0
2023-01-17 09:00:00	SPY	ETF	397.56	399.1	397.55	398.55	5301831.0
2023-01-17 10:00:00	SPY	ETF	398.56	400.23	397.83	398.23	8387410.0
2023-01-17 11:00:00	SPY	ETF	398.23	398.46	397.06	398.2186	6437504.0
2023-01-17 12:00:00	SPY	ETF	398.23	398.64	397.49	398.11	3931219.0
2023-01-17 13:00:00	SPY	ETF	398.12	398.8	397.9012	398.655	3891329.0
2023-01-17 14:00:00	SPY	ETF	398.66	398.84	397.59	398.1	5316002.0
2023-01-17 15:00:00	SPY	ETF	398.1176	398.56	397.155	397.76	10816900.0
2023-01-17 16:00:00	SPY	ETF	397.76	398.04	397.63	397.66	6015289.0
2023-01-17 17:00:00	SPY	ETF	397.61	397.82	397.5	397.54	27535.0
2023-01-17 18:00:00	SPY	ETF	397.58	397.58	396.5	396.81	135926.0
2023-01-17 19:00:00	SPY	ETF	396.82	396.86	396.44	396.72	119473.0
2023-01-17 04:00:00	QQQ	ETF	279.88	280.41	279.35	279.7	54114.0
2023-01-17 05:00:00	QQQ	ETF	279.73	280.26	279.54	280.07	40631.0
2023-01-17 06:00:00	QQQ	ETF	280.08	280.11	279.79	280.08	22401.0
2023-01-17 07:00:00	QQQ	ETF	280.11	280.53	279.64	279.82	200297.0
2023-01-17 08:00:00	QQQ	ETF	280.13	280.5	279.4	279.9	613964.0
2023-01-17 09:00:00	QQQ	ETF	279.96	281.455	279.581	281.16	4610936.0
2023-01-17 10:00:00	QQQ	ETF	281.15	282.85	280.44	281.03	5479649.0
2023-01-17 11:00:00	QQQ	ETF	281.03	281.46	279.7	281.2294	3214709.0
2023-01-17 12:00:00	QQQ	ETF	281.26	281.64	280.52	281.45	2353479.0
2023-01-17 13:00:00	QQQ	ETF	281.45	281.99	281.25	281.89	1857258.0
2023-01-17 14:00:00	QQQ	ETF	281.9	282.01	280.92	281.4399	2602673.0
2023-01-17 15:00:00	QQQ	ETF	281.44	281.85	280.8609	281.45	4048143.0
2023-01-17 16:00:00	QQQ	ETF	281.44	281.7	281.26	281.33	898725.0
2023-01-17 17:00:00	QQQ	ETF	281.34	281.34	281.17	281.17	18570.0
2023-01-17 18:00:00	QQQ	ETF	281.19	281.25	280.4	280.65	129918.0
2023-01-17 19:00:00	QQQ	ETF	280.66	280.74	280.38	280.58	60849.0
2023-01-17 04:00:00	IWM	ETF	186.49	186.65	186.13	186.36	13777.0
2023-01-17 05:00:00	IWM	ETF	186.38	186.47	186.22	186.41	3685.0
2023-01-17 06:00:00	IWM	ETF	186.38	186.56	186.3	186.55	6800.0
2023-01-17 07:00:00	IWM	ETF	186.55	186.7	186.32	186.48	34789.0
2023-01-17 08:00:00	IWM	ETF	186.56	186.84	186.3	186.61	57384.0
2023-01-17 09:00:00	IWM	ETF	186.66	187.36	186.235	187.04	2247416.0
2023-01-17 10:00:00	IWM	ETF	187.05	187.84	186.4	186.81	2237269.0
2023-01-17 11:00:00	IWM	ETF	186.81	186.96	186.24	186.56	2103041.0
2023-01-17 12:00:00	IWM	ETF	186.57	186.855	186.33	186.71	1244209.0
2023-01-17 13:00:00	IWM	ETF	186.71	186.9101	186.5	186.82	1126887.0
2023-01-17 14:00:00	IWM	ETF	186.82	186.95	186.25	186.56	1001504.0
2023-01-17 15:00:00	IWM	ETF	186.55	186.97	186.525	186.82	2172172.0
2023-01-17 16:00:00	IWM	ETF	186.82	186.92	186.71	186.78	2485969.0
2023-01-17 17:00:00	IWM	ETF	186.8	186.8	186.64	186.75	2611.0
2023-01-17 18:00:00	IWM	ETF	186.62	186.65	186.16	186.36	26776.0
2023-01-17 19:00:00	IWM	ETF	186.36	186.42	186.15	186.33	13687.0
2023-01-17 06:00:00	DIA	ETF	342.39	342.42	342.39	342.42	1350.0
2023-01-17 07:00:00	DIA	ETF	342.59	342.63	341.81	341.82	14116.0

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

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