PREVIEW / etf_1hour / 2022-10-05

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-10-05.parquet
  size:    456 KB
  rows:    16,921

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-05 04:00:00	SPY	ETF	375.32	376.3	374.0	375.0	94287.0
2022-10-05 05:00:00	SPY	ETF	374.98	375.16	373.81	374.1	121581.0
2022-10-05 06:00:00	SPY	ETF	374.11	375.25	374.11	375.25	105029.0
2022-10-05 07:00:00	SPY	ETF	375.3	375.39	374.19	374.56	253390.0
2022-10-05 08:00:00	SPY	ETF	375.24	376.4	373.7	374.03	780797.0
2022-10-05 09:00:00	SPY	ETF	373.99	375.18	373.2	374.309	7163626.0
2022-10-05 10:00:00	SPY	ETF	374.28	374.34	370.95	371.35	12208343.0
2022-10-05 11:00:00	SPY	ETF	371.34	373.43	371.21	373.0399	6436255.0
2022-10-05 12:00:00	SPY	ETF	373.05	376.02	372.23	375.2539	7363683.0
2022-10-05 13:00:00	SPY	ETF	375.27	377.54	375.145	375.83	7908845.0
2022-10-05 14:00:00	SPY	ETF	375.83	377.75	375.68	377.68	6353485.0
2022-10-05 15:00:00	SPY	ETF	377.69	379.46	376.47	377.15	16712164.0
2022-10-05 16:00:00	SPY	ETF	377.15	377.9462	376.97	377.04	3506258.0
2022-10-05 17:00:00	SPY	ETF	376.94	377.04	376.66	376.92	101392.0
2022-10-05 18:00:00	SPY	ETF	376.92	377.5	376.63	377.4	101665.0
2022-10-05 19:00:00	SPY	ETF	377.5	378.62	377.2	378.59	134721.0
2022-10-05 04:00:00	QQQ	ETF	280.29	280.41	278.89	279.97	151400.0
2022-10-05 05:00:00	QQQ	ETF	279.81	280.07	279.08	279.3	48136.0
2022-10-05 06:00:00	QQQ	ETF	279.45	280.24	279.35	280.23	94764.0
2022-10-05 07:00:00	QQQ	ETF	280.23	280.3	279.43	279.73	202342.0
2022-10-05 08:00:00	QQQ	ETF	280.19	282.341	278.73	278.97	564604.0
2022-10-05 09:00:00	QQQ	ETF	278.93	279.62	277.84	278.6948	5690293.0
2022-10-05 10:00:00	QQQ	ETF	278.66	278.71	275.42	275.86	8573473.0
2022-10-05 11:00:00	QQQ	ETF	275.85	277.755	275.73	277.62	4635427.0
2022-10-05 12:00:00	QQQ	ETF	277.64	280.345	276.9408	279.74	5352887.0
2022-10-05 13:00:00	QQQ	ETF	279.74	281.75	279.64	280.32	4761386.0
2022-10-05 14:00:00	QQQ	ETF	280.3	282.3	280.145	282.24	4254049.0
2022-10-05 15:00:00	QQQ	ETF	282.26	283.81	281.41	281.98	9051607.0
2022-10-05 16:00:00	QQQ	ETF	281.98	282.67	281.84	281.87	2615525.0
2022-10-05 17:00:00	QQQ	ETF	281.83	281.98	281.6	281.71	162107.0
2022-10-05 18:00:00	QQQ	ETF	281.71	282.4	281.52	282.31	102830.0
2022-10-05 19:00:00	QQQ	ETF	282.4	283.53	282.21	283.53	165994.0
2022-10-05 04:00:00	IWM	ETF	174.38	174.47	173.71	174.21	32229.0
2022-10-05 05:00:00	IWM	ETF	174.02	174.2	173.47	173.5	18241.0
2022-10-05 06:00:00	IWM	ETF	173.67	174.3	173.66	174.3	51154.0
2022-10-05 07:00:00	IWM	ETF	174.31	174.46	173.78	173.96	87783.0
2022-10-05 08:00:00	IWM	ETF	173.9201	175.11	173.55	173.73	125776.0
2022-10-05 09:00:00	IWM	ETF	173.73	174.31	173.07	173.32	2934988.0
2022-10-05 10:00:00	IWM	ETF	173.29	173.31	171.42	171.89	2806067.0
2022-10-05 11:00:00	IWM	ETF	171.89	172.935	171.83	172.625	1706518.0
2022-10-05 12:00:00	IWM	ETF	172.63	173.76	172.23	173.475	1881045.0
2022-10-05 13:00:00	IWM	ETF	173.47	174.63	173.38	173.91	2519602.0
2022-10-05 14:00:00	IWM	ETF	173.9	174.65	173.82	174.58	1782570.0
2022-10-05 15:00:00	IWM	ETF	174.58	175.33	174.54	174.75	4607007.0
2022-10-05 16:00:00	IWM	ETF	174.74	175.2	174.6957	174.86	1318017.0
2022-10-05 17:00:00	IWM	ETF	174.85	174.86	174.61	174.64	151819.0
2022-10-05 18:00:00	IWM	ETF	174.8	175.12	174.65	175.03	26286.0
2022-10-05 19:00:00	IWM	ETF	175.02	175.72	174.91	175.64	53876.0
2022-10-05 04:00:00	DIA	ETF	301.22	301.22	300.32	300.79	1910.0
2022-10-05 05:00:00	DIA	ETF	300.77	300.77	300.15	300.15	1200.0

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

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