PREVIEW / etf_1hour / 2022-10-18

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-10-18.parquet
  size:    459 KB
  rows:    17,011

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-18 04:00:00	SPY	ETF	373.05	373.19	370.88	371.02	145639.0
2022-10-18 05:00:00	SPY	ETF	370.83	371.53	370.18	371.5	155967.0
2022-10-18 06:00:00	SPY	ETF	371.44	372.94	371.29	371.67	244177.0
2022-10-18 07:00:00	SPY	ETF	371.71	373.86	371.59	373.5	579976.0
2022-10-18 08:00:00	SPY	ETF	371.72	375.3	370.3204	375.14	1569085.0
2022-10-18 09:00:00	SPY	ETF	375.09	375.45	372.45	373.1	10572021.0
2022-10-18 10:00:00	SPY	ETF	373.12	374.37	370.9654	371.5	11486486.0
2022-10-18 11:00:00	SPY	ETF	371.49	371.955	367.52	369.22	11083534.0
2022-10-18 12:00:00	SPY	ETF	369.2	371.44	368.56	370.43	9153516.0
2022-10-18 13:00:00	SPY	ETF	370.44	372.38	369.18	372.04	7493220.0
2022-10-18 14:00:00	SPY	ETF	372.03	372.26	368.11	369.4	8615576.0
2022-10-18 15:00:00	SPY	ETF	369.4	371.3	368.39	371.14	13499140.0
2022-10-18 16:00:00	SPY	ETF	371.13	373.92	370.1	373.55	4250943.0
2022-10-18 17:00:00	SPY	ETF	373.67	374.0	371.13	373.79	197800.0
2022-10-18 18:00:00	SPY	ETF	373.76	373.8	372.94	373.7	106812.0
2022-10-18 19:00:00	SPY	ETF	373.75	375.02	373.71	374.1	169904.0
2022-10-18 04:00:00	QQQ	ETF	274.11	274.85	273.01	273.01	215913.0
2022-10-18 05:00:00	QQQ	ETF	273.01	273.76	272.55	273.76	239325.0
2022-10-18 06:00:00	QQQ	ETF	273.75	274.66	273.59	273.7	185434.0
2022-10-18 07:00:00	QQQ	ETF	273.69	275.35	273.67	275.0	477045.0
2022-10-18 08:00:00	QQQ	ETF	273.75	276.38	269.552	276.24	1154707.0
2022-10-18 09:00:00	QQQ	ETF	276.21	277.21	273.85	274.1989	8326066.0
2022-10-18 10:00:00	QQQ	ETF	274.2	275.1	271.93	272.68	7260246.0
2022-10-18 11:00:00	QQQ	ETF	272.65	272.96	268.7955	270.59	9074864.0
2022-10-18 12:00:00	QQQ	ETF	270.57	272.77	269.9	271.48	5777043.0
2022-10-18 13:00:00	QQQ	ETF	271.5	272.94	270.35	272.65	4283233.0
2022-10-18 14:00:00	QQQ	ETF	272.64	272.79	268.74	270.15	7253710.0
2022-10-18 15:00:00	QQQ	ETF	270.16	272.0	269.15	271.68	7329765.0
2022-10-18 16:00:00	QQQ	ETF	271.68	274.92	270.54	274.6	3105938.0
2022-10-18 17:00:00	QQQ	ETF	274.75	275.45	271.48	274.88	357017.0
2022-10-18 18:00:00	QQQ	ETF	274.87	274.92	274.25	274.79	204233.0
2022-10-18 19:00:00	QQQ	ETF	274.85	276.0	274.82	275.06	195788.0
2022-10-18 04:00:00	IWM	ETF	175.0	175.31	174.23	174.29	35649.0
2022-10-18 05:00:00	IWM	ETF	173.95	174.28	173.66	174.28	40935.0
2022-10-18 06:00:00	IWM	ETF	174.3	175.06	174.21	174.43	58098.0
2022-10-18 07:00:00	IWM	ETF	174.5	175.63	174.47	175.44	159036.0
2022-10-18 08:00:00	IWM	ETF	174.9	176.07	174.46	175.95	188686.0
2022-10-18 09:00:00	IWM	ETF	175.85	177.29	175.14	175.725	4899597.0
2022-10-18 10:00:00	IWM	ETF	175.74	176.41	174.32	174.84	3057923.0
2022-10-18 11:00:00	IWM	ETF	174.81	175.32	172.71	173.87	3366830.0
2022-10-18 12:00:00	IWM	ETF	173.86	174.53	173.33	173.94	2451854.0
2022-10-18 13:00:00	IWM	ETF	173.94	174.87	173.44	174.73	1460290.0
2022-10-18 14:00:00	IWM	ETF	174.71	174.79	172.69	173.29	2372087.0
2022-10-18 15:00:00	IWM	ETF	173.27	174.29	172.97	174.19	2996270.0
2022-10-18 16:00:00	IWM	ETF	174.17	175.27	172.1003	175.1	3663151.0
2022-10-18 17:00:00	IWM	ETF	175.12	175.3	174.17	175.19	2432708.0
2022-10-18 18:00:00	IWM	ETF	175.19	175.2	174.75	175.2	37102.0
2022-10-18 19:00:00	IWM	ETF	175.2	175.88	175.2	175.52	55363.0
2022-10-18 04:00:00	DIA	ETF	306.16	306.16	304.96	305.03	4850.0
2022-10-18 05:00:00	DIA	ETF	304.88	304.94	304.43	304.45	5892.0

> showing 50 of 17,011 rows — these rows as CSV

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