PREVIEW / etf_1hour / 2022-11-22

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-11-22.parquet
  size:    461 KB
  rows:    16,732

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-11-22 04:00:00	SPY	ETF	394.2	395.81	394.06	395.75	32616.0
2022-11-22 05:00:00	SPY	ETF	395.67	395.82	395.13	395.34	21580.0
2022-11-22 06:00:00	SPY	ETF	395.36	395.5	394.57	395.03	41367.0
2022-11-22 07:00:00	SPY	ETF	395.13	395.81	394.95	395.7	80690.0
2022-11-22 08:00:00	SPY	ETF	395.68	396.71	393.82	396.62	288197.0
2022-11-22 09:00:00	SPY	ETF	396.69	396.86	395.1527	395.92	4294306.0
2022-11-22 10:00:00	SPY	ETF	395.91	397.7901	395.7092	397.645	7328631.0
2022-11-22 11:00:00	SPY	ETF	397.65	397.73	396.73	397.47	4110951.0
2022-11-22 12:00:00	SPY	ETF	397.46	397.89	397.28	397.46	2711749.0
2022-11-22 13:00:00	SPY	ETF	397.48	398.69	397.33	398.535	3846178.0
2022-11-22 14:00:00	SPY	ETF	398.53	399.0125	398.16	398.9	3684213.0
2022-11-22 15:00:00	SPY	ETF	398.91	400.07	398.83	399.87	13843494.0
2022-11-22 16:00:00	SPY	ETF	399.86	399.92	399.58	399.8	5159354.0
2022-11-22 17:00:00	SPY	ETF	399.85	399.97	399.7	399.95	102518.0
2022-11-22 18:00:00	SPY	ETF	399.89	400.07	399.79	399.96	95836.0
2022-11-22 19:00:00	SPY	ETF	399.97	400.27	399.82	399.86	94767.0
2022-11-22 04:00:00	QQQ	ETF	281.0	282.76	281.0	282.59	77080.0
2022-11-22 05:00:00	QQQ	ETF	282.6	282.68	282.14	282.4	30767.0
2022-11-22 06:00:00	QQQ	ETF	282.56	282.56	281.46	281.8	28388.0
2022-11-22 07:00:00	QQQ	ETF	281.89	282.58	281.74	282.39	243839.0
2022-11-22 08:00:00	QQQ	ETF	281.8	283.21	280.92	283.11	482419.0
2022-11-22 09:00:00	QQQ	ETF	283.14	283.21	280.46	280.93	4878427.0
2022-11-22 10:00:00	QQQ	ETF	280.93	283.54	280.78	283.46	5798813.0
2022-11-22 11:00:00	QQQ	ETF	283.46	283.58	282.63	283.29	4128882.0
2022-11-22 12:00:00	QQQ	ETF	283.29	283.89	283.26	283.55	2555228.0
2022-11-22 13:00:00	QQQ	ETF	283.57	284.68	283.32	284.63	3294129.0
2022-11-22 14:00:00	QQQ	ETF	284.635	284.84	284.06	284.67	3076473.0
2022-11-22 15:00:00	QQQ	ETF	284.666	286.11	284.6	285.92	5013240.0
2022-11-22 16:00:00	QQQ	ETF	285.92	285.98	285.52	285.63	1294355.0
2022-11-22 17:00:00	QQQ	ETF	285.66	285.8	285.55	285.8	41409.0
2022-11-22 18:00:00	QQQ	ETF	285.85	285.95	285.6101	285.75	1631194.0
2022-11-22 19:00:00	QQQ	ETF	285.78	286.0	285.55	285.63	202495.0
2022-11-22 04:00:00	IWM	ETF	182.65	183.45	182.56	183.39	14688.0
2022-11-22 05:00:00	IWM	ETF	183.33	183.39	183.1	183.25	5578.0
2022-11-22 06:00:00	IWM	ETF	183.27	183.33	182.82	183.02	10328.0
2022-11-22 07:00:00	IWM	ETF	183.06	183.48	183.06	183.38	24989.0
2022-11-22 08:00:00	IWM	ETF	183.39	183.77	182.76	183.68	168431.0
2022-11-22 09:00:00	IWM	ETF	183.71	183.88	182.33	182.86	1528585.0
2022-11-22 10:00:00	IWM	ETF	182.84	184.21	182.78	183.82	2090034.0
2022-11-22 11:00:00	IWM	ETF	183.8199	183.87	183.02	183.2322	1175766.0
2022-11-22 12:00:00	IWM	ETF	183.235	183.58	183.1	183.22	872333.0
2022-11-22 13:00:00	IWM	ETF	183.23	183.93	183.1699	183.82	1566153.0
2022-11-22 14:00:00	IWM	ETF	183.83	184.01	183.51	183.96	1563319.0
2022-11-22 15:00:00	IWM	ETF	183.94	184.94	183.91	184.78	2451644.0
2022-11-22 16:00:00	IWM	ETF	184.71	184.78	184.6	184.72	529076.0
2022-11-22 17:00:00	IWM	ETF	184.68	184.79	184.52	184.78	9671.0
2022-11-22 18:00:00	IWM	ETF	184.78	184.88	184.71	184.85	17385.0
2022-11-22 19:00:00	IWM	ETF	184.89	185.0	184.71	184.8	38447.0
2022-11-22 04:00:00	DIA	ETF	337.0	337.0	337.0	337.0	100.0
2022-11-22 05:00:00	DIA	ETF	337.79	337.79	337.68	337.68	200.0

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

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