PREVIEW / etf_1hour / 2022-07-22

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-07-22.parquet
  size:    436 KB
  rows:    15,915

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-07-22 04:00:00	SPY	ETF	397.24	397.8	396.67	397.4	8183.0
2022-07-22 05:00:00	SPY	ETF	397.7	398.05	397.44	397.45	21747.0
2022-07-22 06:00:00	SPY	ETF	397.44	398.21	397.43	397.77	54477.0
2022-07-22 07:00:00	SPY	ETF	397.82	398.38	397.49	398.32	195223.0
2022-07-22 08:00:00	SPY	ETF	398.31	398.51	397.07	398.3	365215.0
2022-07-22 09:00:00	SPY	ETF	398.29	400.18	397.91	397.96	7784258.0
2022-07-22 10:00:00	SPY	ETF	397.965	399.26	397.21	398.7	6367004.0
2022-07-22 11:00:00	SPY	ETF	398.715	398.81	395.32	396.2961	6298956.0
2022-07-22 12:00:00	SPY	ETF	396.27	396.63	394.94	395.24	4193548.0
2022-07-22 13:00:00	SPY	ETF	395.25	395.25	393.28	394.0212	5748259.0
2022-07-22 14:00:00	SPY	ETF	394.03	394.14	392.75	393.7078	5350298.0
2022-07-22 15:00:00	SPY	ETF	393.72	395.2	393.38	395.12	11862562.0
2022-07-22 16:00:00	SPY	ETF	395.13	395.14	394.45	394.99	2767655.0
2022-07-22 17:00:00	SPY	ETF	394.9	395.07	394.55	394.8	85347.0
2022-07-22 18:00:00	SPY	ETF	394.83	394.85	394.28	394.42	36309.0
2022-07-22 19:00:00	SPY	ETF	394.42	394.5	394.25	394.4	33629.0
2022-07-22 04:00:00	QQQ	ETF	305.24	305.72	304.73	305.5	81794.0
2022-07-22 05:00:00	QQQ	ETF	305.61	305.97	305.52	305.6	53484.0
2022-07-22 06:00:00	QQQ	ETF	305.53	306.3	305.41	305.94	207537.0
2022-07-22 07:00:00	QQQ	ETF	305.98	306.7	305.5	306.65	419760.0
2022-07-22 08:00:00	QQQ	ETF	305.73	307.61	304.7	306.24	584970.0
2022-07-22 09:00:00	QQQ	ETF	306.26	308.55	305.46	305.74	7632361.0
2022-07-22 10:00:00	QQQ	ETF	305.75	306.55	304.86	305.84	6436593.0
2022-07-22 11:00:00	QQQ	ETF	305.85	305.95	301.93	302.9292	6076678.0
2022-07-22 12:00:00	QQQ	ETF	302.92	303.24	301.57	302.0899	4048516.0
2022-07-22 13:00:00	QQQ	ETF	302.11	302.12	300.42	301.3	4072209.0
2022-07-22 14:00:00	QQQ	ETF	301.3	301.4	300.115	301.11	3703978.0
2022-07-22 15:00:00	QQQ	ETF	301.11	302.18	300.61	302.0	7795078.0
2022-07-22 16:00:00	QQQ	ETF	302.01	302.11	301.65	302.1	1565360.0
2022-07-22 17:00:00	QQQ	ETF	302.1	302.1	301.8	301.82	44751.0
2022-07-22 18:00:00	QQQ	ETF	301.86	301.9	301.62	301.7	22577.0
2022-07-22 19:00:00	QQQ	ETF	301.66	301.66	301.4	301.41	28235.0
2022-07-22 04:00:00	IWM	ETF	181.59	182.18	181.48	182.03	13357.0
2022-07-22 05:00:00	IWM	ETF	182.01	182.31	181.98	182.14	10821.0
2022-07-22 06:00:00	IWM	ETF	182.11	182.44	182.1	182.2	12841.0
2022-07-22 07:00:00	IWM	ETF	182.17	182.57	182.11	182.47	40754.0
2022-07-22 08:00:00	IWM	ETF	182.39	182.55	182.11	182.47	44911.0
2022-07-22 09:00:00	IWM	ETF	182.46	183.25	180.4	180.89	3579940.0
2022-07-22 10:00:00	IWM	ETF	180.9	181.69	180.25	181.3	2325567.0
2022-07-22 11:00:00	IWM	ETF	181.33	181.63	180.24	180.58	1875583.0
2022-07-22 12:00:00	IWM	ETF	180.58	180.68	179.78	179.79	2294424.0
2022-07-22 13:00:00	IWM	ETF	179.78	179.78	178.37	178.58	2970178.0
2022-07-22 14:00:00	IWM	ETF	178.59	178.9	178.05	178.74	2023947.0
2022-07-22 15:00:00	IWM	ETF	178.73	179.59	178.58	179.56	3585301.0
2022-07-22 16:00:00	IWM	ETF	179.51	179.67	179.2	179.51	900836.0
2022-07-22 17:00:00	IWM	ETF	179.52	179.67	179.22	179.25	70325.0
2022-07-22 18:00:00	IWM	ETF	179.25	179.35	179.02	179.21	10012.0
2022-07-22 19:00:00	IWM	ETF	179.24	179.25	177.93	179.07	16358.0
2022-07-22 04:00:00	DIA	ETF	319.85	320.05	319.7	320.05	1500.0
2022-07-22 05:00:00	DIA	ETF	320.41	320.41	320.13	320.13	300.0

> showing 50 of 15,915 rows — these rows as CSV

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