PREVIEW / etf_1hour / 2022-10-04

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-10-04.parquet
  size:    474 KB
  rows:    17,603

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-04 04:00:00	SPY	ETF	372.0	372.12	369.18	372.01	104384.0
2022-10-04 05:00:00	SPY	ETF	372.06	372.44	371.0	372.43	56507.0
2022-10-04 06:00:00	SPY	ETF	372.4	373.55	372.12	372.78	165025.0
2022-10-04 07:00:00	SPY	ETF	372.8	372.81	372.1	372.71	384161.0
2022-10-04 08:00:00	SPY	ETF	372.6999	373.4204	369.45	372.43	1013038.0
2022-10-04 09:00:00	SPY	ETF	372.46	376.07	371.86	376.0023	10812013.0
2022-10-04 10:00:00	SPY	ETF	376.01	377.39	375.89	377.2201	12268942.0
2022-10-04 11:00:00	SPY	ETF	377.22	377.66	376.402	377.03	7958915.0
2022-10-04 12:00:00	SPY	ETF	377.03	377.595	375.86	376.17	5988851.0
2022-10-04 13:00:00	SPY	ETF	376.16	376.78	374.1	376.29	8775277.0
2022-10-04 14:00:00	SPY	ETF	376.295	377.41	375.47	377.09	6620106.0
2022-10-04 15:00:00	SPY	ETF	377.0978	378.0	375.46	377.93	18330299.0
2022-10-04 16:00:00	SPY	ETF	377.93	378.26	377.52	377.79	6621887.0
2022-10-04 17:00:00	SPY	ETF	377.84	377.87	377.61	377.68	177536.0
2022-10-04 18:00:00	SPY	ETF	377.66	377.71	376.9	377.11	277258.0
2022-10-04 19:00:00	SPY	ETF	377.1	377.15	376.72	377.05	68461.0
2022-10-04 04:00:00	QQQ	ETF	278.06	278.64	277.56	278.4	84095.0
2022-10-04 05:00:00	QQQ	ETF	278.6	279.0	277.82	278.84	64353.0
2022-10-04 06:00:00	QQQ	ETF	278.93	279.88	278.78	279.26	240473.0
2022-10-04 07:00:00	QQQ	ETF	279.25	279.31	278.78	279.09	305295.0
2022-10-04 08:00:00	QQQ	ETF	279.1401	279.6104	273.735	278.98	817039.0
2022-10-04 09:00:00	QQQ	ETF	278.959	281.53	278.56	281.4599	9118628.0
2022-10-04 10:00:00	QQQ	ETF	281.47	282.85	281.47	282.72	9710488.0
2022-10-04 11:00:00	QQQ	ETF	282.72	282.84	281.65	282.2	5077699.0
2022-10-04 12:00:00	QQQ	ETF	282.205	282.5	280.81	281.1	4385556.0
2022-10-04 13:00:00	QQQ	ETF	281.0599	281.65	279.22	281.2501	6305329.0
2022-10-04 14:00:00	QQQ	ETF	281.26	282.21	280.6207	281.92	4162051.0
2022-10-04 15:00:00	QQQ	ETF	281.9241	282.24	280.5108	282.17	8202689.0
2022-10-04 16:00:00	QQQ	ETF	282.15	282.63	281.468	282.15	2638692.0
2022-10-04 17:00:00	QQQ	ETF	282.14	282.3	282.13	282.13	63446.0
2022-10-04 18:00:00	QQQ	ETF	282.12	282.12	281.5	281.67	198299.0
2022-10-04 19:00:00	QQQ	ETF	281.59	281.7	281.35	281.62	96980.0
2022-10-04 04:00:00	IWM	ETF	170.97	172.56	170.97	172.4	45820.0
2022-10-04 05:00:00	IWM	ETF	172.56	172.59	171.86	172.43	30625.0
2022-10-04 06:00:00	IWM	ETF	172.52	173.0	172.4	172.63	53782.0
2022-10-04 07:00:00	IWM	ETF	172.64	172.89	172.49	172.77	80803.0
2022-10-04 08:00:00	IWM	ETF	172.58	172.87	171.35	172.58	217811.0
2022-10-04 09:00:00	IWM	ETF	172.56	174.89	172.36	174.87	4879650.0
2022-10-04 10:00:00	IWM	ETF	174.88	175.5	174.3	175.34	5546431.0
2022-10-04 11:00:00	IWM	ETF	175.32	175.73	175.03	175.53	2515628.0
2022-10-04 12:00:00	IWM	ETF	175.53	175.69	174.69	174.835	2274808.0
2022-10-04 13:00:00	IWM	ETF	174.83	175.0398	173.82	174.73	2900463.0
2022-10-04 14:00:00	IWM	ETF	174.75	175.17	174.39	175.0881	2223115.0
2022-10-04 15:00:00	IWM	ETF	175.09	176.08	174.52	176.06	5108056.0
2022-10-04 16:00:00	IWM	ETF	176.0	176.06	175.02	175.7	1788160.0
2022-10-04 17:00:00	IWM	ETF	175.6	175.71	175.49	175.54	43862.0
2022-10-04 18:00:00	IWM	ETF	175.53	175.53	175.22	175.35	37862.0
2022-10-04 19:00:00	IWM	ETF	175.28	175.44	175.1	175.34	58717.0
2022-10-04 04:00:00	DIA	ETF	298.49	298.59	298.21	298.23	5360.0
2022-10-04 05:00:00	DIA	ETF	298.03	298.5	297.82	298.5	1120.0

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

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