PREVIEW / etf_1hour / 2022-11-21

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-11-21.parquet
  size:    458 KB
  rows:    16,704

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-21 04:00:00	SPY	ETF	394.36	394.45	393.7	394.12	41014.0
2022-11-21 05:00:00	SPY	ETF	394.12	394.45	393.78	394.04	35220.0
2022-11-21 06:00:00	SPY	ETF	394.03	394.34	393.72	393.93	61715.0
2022-11-21 07:00:00	SPY	ETF	393.94	394.33	393.64	394.2	117543.0
2022-11-21 08:00:00	SPY	ETF	394.06	395.06	393.7804	394.87	337033.0
2022-11-21 09:00:00	SPY	ETF	394.9	395.82	394.28	395.205	4012598.0
2022-11-21 10:00:00	SPY	ETF	395.21	395.538	393.23	393.88	5918415.0
2022-11-21 11:00:00	SPY	ETF	393.89	394.35	392.66	393.215	4198797.0
2022-11-21 12:00:00	SPY	ETF	393.215	394.68	393.12	393.92	3816345.0
2022-11-21 13:00:00	SPY	ETF	393.92	395.62	393.9	394.7401	5083087.0
2022-11-21 14:00:00	SPY	ETF	394.74	395.37	394.31	394.4801	4544371.0
2022-11-21 15:00:00	SPY	ETF	394.48	395.12	394.005	394.58	7972588.0
2022-11-21 16:00:00	SPY	ETF	394.58	400.0	394.45	394.58	2301716.0
2022-11-21 17:00:00	SPY	ETF	394.57	394.7	394.5	394.55	53198.0
2022-11-21 18:00:00	SPY	ETF	394.55	394.79	394.46	394.71	98417.0
2022-11-21 19:00:00	SPY	ETF	394.73	395.4	394.72	395.1	89953.0
2022-11-21 04:00:00	QQQ	ETF	283.94	283.94	282.63	282.98	62471.0
2022-11-21 05:00:00	QQQ	ETF	283.03	283.22	282.48	282.7	39883.0
2022-11-21 06:00:00	QQQ	ETF	282.57	282.86	282.27	282.43	40339.0
2022-11-21 07:00:00	QQQ	ETF	282.45	282.77	282.1	282.73	132238.0
2022-11-21 08:00:00	QQQ	ETF	282.55	285.033	282.1	283.45	353996.0
2022-11-21 09:00:00	QQQ	ETF	283.5	284.58	282.87	283.68	4676513.0
2022-11-21 10:00:00	QQQ	ETF	283.68	283.9799	281.5655	282.13	5271613.0
2022-11-21 11:00:00	QQQ	ETF	282.1	282.87	281.32	281.64	3370378.0
2022-11-21 12:00:00	QQQ	ETF	281.65	282.1725	281.04	281.19	3674730.0
2022-11-21 13:00:00	QQQ	ETF	281.18	282.985	281.1405	282.16	3417577.0
2022-11-21 14:00:00	QQQ	ETF	282.16	282.66	281.67	281.9	2719150.0
2022-11-21 15:00:00	QQQ	ETF	281.88	282.46	281.61	281.83	5627915.0
2022-11-21 16:00:00	QQQ	ETF	281.83	282.08	281.79	281.91	1413777.0
2022-11-21 17:00:00	QQQ	ETF	281.99	281.99	281.79	281.8	148402.0
2022-11-21 18:00:00	QQQ	ETF	281.81	282.03	281.76	281.96	39227.0
2022-11-21 19:00:00	QQQ	ETF	282.0	282.69	282.0	282.38	125178.0
2022-11-21 04:00:00	IWM	ETF	182.79	182.9	182.62	182.82	9015.0
2022-11-21 05:00:00	IWM	ETF	182.99	183.07	182.72	182.89	44459.0
2022-11-21 06:00:00	IWM	ETF	182.82	183.09	182.74	182.74	7931.0
2022-11-21 07:00:00	IWM	ETF	182.86	183.04	182.69	182.97	18375.0
2022-11-21 08:00:00	IWM	ETF	182.99	183.31	182.8	183.12	27466.0
2022-11-21 09:00:00	IWM	ETF	183.14	183.28	182.26	182.59	1497825.0
2022-11-21 10:00:00	IWM	ETF	182.6	182.86	181.72	182.16	1750428.0
2022-11-21 11:00:00	IWM	ETF	182.18	182.28	181.43	181.55	1287395.0
2022-11-21 12:00:00	IWM	ETF	181.53	182.74	181.51	182.31	1112834.0
2022-11-21 13:00:00	IWM	ETF	182.29	182.995	182.28	182.48	1178085.0
2022-11-21 14:00:00	IWM	ETF	182.48	182.77	182.06	182.23	794724.0
2022-11-21 15:00:00	IWM	ETF	182.2	182.91	182.01	182.73	2504408.0
2022-11-21 16:00:00	IWM	ETF	182.76	182.89	182.66	182.77	1665700.0
2022-11-21 17:00:00	IWM	ETF	182.7	182.77	182.66	182.76	2755.0
2022-11-21 18:00:00	IWM	ETF	182.76	182.82	182.65	182.73	17865.0
2022-11-21 19:00:00	IWM	ETF	182.83	183.14	182.77	182.99	24546.0
2022-11-21 04:00:00	DIA	ETF	336.31	336.31	336.28	336.3	760.0
2022-11-21 05:00:00	DIA	ETF	336.48	336.48	336.48	336.48	750.0

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

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