PREVIEW / etf_1hour / 2022-12-09

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-12-09.parquet
  size:    461 KB
  rows:    16,757

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-12-09 04:00:00	SPY	ETF	397.1	397.9	396.72	396.91	18245.0
2022-12-09 05:00:00	SPY	ETF	396.88	397.59	396.88	397.57	21930.0
2022-12-09 06:00:00	SPY	ETF	397.66	397.96	397.4	397.74	42298.0
2022-12-09 07:00:00	SPY	ETF	397.7	398.63	397.47	398.55	315545.0
2022-12-09 08:00:00	SPY	ETF	397.6	398.7	392.75	395.45	1692917.0
2022-12-09 09:00:00	SPY	ETF	395.44	396.89	394.12	395.7426	5599299.0
2022-12-09 10:00:00	SPY	ETF	395.7	397.16	394.72	397.1121	7610234.0
2022-12-09 11:00:00	SPY	ETF	397.13	397.62	396.2	397.36	5868068.0
2022-12-09 12:00:00	SPY	ETF	397.39	397.47	396.34	396.56	3656370.0
2022-12-09 13:00:00	SPY	ETF	396.53	396.53	395.3495	395.9853	4179949.0
2022-12-09 14:00:00	SPY	ETF	395.97	396.11	395.01	395.85	4622731.0
2022-12-09 15:00:00	SPY	ETF	395.81	396.29	393.15	393.285	14682741.0
2022-12-09 16:00:00	SPY	ETF	393.29	394.0	392.8101	392.85	5398993.0
2022-12-09 17:00:00	SPY	ETF	392.9	393.01	392.85	392.94	59039.0
2022-12-09 18:00:00	SPY	ETF	392.94	393.02	392.94	393.02	38652.0
2022-12-09 19:00:00	SPY	ETF	393.0	393.05	392.55	392.55	39352.0
2022-12-09 04:00:00	QQQ	ETF	284.98	285.21	284.41	284.65	49007.0
2022-12-09 05:00:00	QQQ	ETF	284.6	285.29	284.6	285.15	36749.0
2022-12-09 06:00:00	QQQ	ETF	285.25	285.45	284.97	285.23	25349.0
2022-12-09 07:00:00	QQQ	ETF	285.25	286.06	285.03	285.96	260552.0
2022-12-09 08:00:00	QQQ	ETF	285.3	286.3	280.93	283.21	2611940.0
2022-12-09 09:00:00	QQQ	ETF	283.2	284.27	281.59	283.1763	5688920.0
2022-12-09 10:00:00	QQQ	ETF	283.19	285.34	282.19	285.3101	7099059.0
2022-12-09 11:00:00	QQQ	ETF	285.32	285.64	284.36	285.365	4152716.0
2022-12-09 12:00:00	QQQ	ETF	285.365	285.64	284.71	284.82	2914321.0
2022-12-09 13:00:00	QQQ	ETF	284.82	284.82	283.55	284.295	2342270.0
2022-12-09 14:00:00	QQQ	ETF	284.28	284.48	283.5	284.22	1911030.0
2022-12-09 15:00:00	QQQ	ETF	284.19	284.56	281.99	282.09	5807794.0
2022-12-09 16:00:00	QQQ	ETF	282.09	283.8497	281.63	281.65	1786919.0
2022-12-09 17:00:00	QQQ	ETF	281.64	281.85	281.64	281.8	29190.0
2022-12-09 18:00:00	QQQ	ETF	281.78	281.8	281.73	281.76	5580.0
2022-12-09 19:00:00	QQQ	ETF	281.8	281.91	281.7	281.88	46171.0
2022-12-09 04:00:00	IWM	ETF	180.92	181.13	180.84	180.91	20812.0
2022-12-09 05:00:00	IWM	ETF	180.9	181.34	180.9	181.2	13849.0
2022-12-09 06:00:00	IWM	ETF	181.33	181.45	181.14	181.26	11515.0
2022-12-09 07:00:00	IWM	ETF	181.25	181.7	181.11	181.65	71761.0
2022-12-09 08:00:00	IWM	ETF	181.12	181.73	178.83	180.18	412077.0
2022-12-09 09:00:00	IWM	ETF	180.07	180.81	179.0	180.14	2164173.0
2022-12-09 10:00:00	IWM	ETF	180.12	180.6	179.55	180.35	1576056.0
2022-12-09 11:00:00	IWM	ETF	180.345	180.69	179.87	180.49	1404050.0
2022-12-09 12:00:00	IWM	ETF	180.49	180.53	179.9	180.09	904955.0
2022-12-09 13:00:00	IWM	ETF	180.075	180.08	179.2901	179.44	1050267.0
2022-12-09 14:00:00	IWM	ETF	179.44	179.6101	179.01	179.53	1467764.0
2022-12-09 15:00:00	IWM	ETF	179.52	179.62	178.56	178.61	3202335.0
2022-12-09 16:00:00	IWM	ETF	178.62	178.77	178.46	178.46	975919.0
2022-12-09 17:00:00	IWM	ETF	178.57	178.62	178.42	178.46	6562.0
2022-12-09 18:00:00	IWM	ETF	178.47	178.62	178.47	178.55	6118.0
2022-12-09 19:00:00	IWM	ETF	178.59	178.59	177.8	178.0	33484.0
2022-12-09 04:00:00	DIA	ETF	338.17	338.67	338.17	338.67	615.0
2022-12-09 05:00:00	DIA	ETF	338.74	338.99	338.74	338.99	1147.0

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

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