PREVIEW / etf_1hour / 2023-06-20

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-06-20.parquet
  size:    491 KB
  rows:    17,779

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
2023-06-20 04:00:00	SPY	ETF	438.66	438.7	437.2	437.33	65470.0
2023-06-20 05:00:00	SPY	ETF	437.29	437.56	437.22	437.56	29689.0
2023-06-20 06:00:00	SPY	ETF	437.5	437.81	437.46	437.81	124309.0
2023-06-20 07:00:00	SPY	ETF	437.84	438.12	437.6	438.0	122444.0
2023-06-20 08:00:00	SPY	ETF	437.9101	439.46	437.71	438.33	328484.0
2023-06-20 09:00:00	SPY	ETF	438.35	438.44	437.09	437.27	6229272.0
2023-06-20 10:00:00	SPY	ETF	437.275	437.39	435.03	435.76	11747938.0
2023-06-20 11:00:00	SPY	ETF	435.77	436.42	435.69	436.06	5585342.0
2023-06-20 12:00:00	SPY	ETF	436.06	437.98	435.85	437.825	7197191.0
2023-06-20 13:00:00	SPY	ETF	437.83	438.37	437.3	437.44	5597887.0
2023-06-20 14:00:00	SPY	ETF	437.44	438.025	437.22	437.5801	4211216.0
2023-06-20 15:00:00	SPY	ETF	437.6	438.0	437.1	437.23	12496622.0
2023-06-20 16:00:00	SPY	ETF	437.23	437.38	436.69	436.98	3005719.0
2023-06-20 17:00:00	SPY	ETF	436.98	437.18	436.91	436.95	957712.0
2023-06-20 18:00:00	SPY	ETF	436.94	437.2	436.94	437.01	54499.0
2023-06-20 19:00:00	SPY	ETF	437.04	437.46	437.04	437.39	43237.0
2023-06-20 04:00:00	QQQ	ETF	367.07	367.83	364.95	365.17	89584.0
2023-06-20 05:00:00	QQQ	ETF	365.23	365.53	365.05	365.49	52835.0
2023-06-20 06:00:00	QQQ	ETF	365.39	366.01	365.39	365.98	110343.0
2023-06-20 07:00:00	QQQ	ETF	365.99	366.49	365.87	366.27	137999.0
2023-06-20 08:00:00	QQQ	ETF	365.9882	367.4261	365.1004	366.92	336842.0
2023-06-20 09:00:00	QQQ	ETF	366.94	368.32	365.8	366.2795	5410312.0
2023-06-20 10:00:00	QQQ	ETF	366.27	366.87	363.8899	364.42	7102228.0
2023-06-20 11:00:00	QQQ	ETF	364.435	365.54	364.428	364.82	3843749.0
2023-06-20 12:00:00	QQQ	ETF	364.81	367.41	364.66	367.065	3961492.0
2023-06-20 13:00:00	QQQ	ETF	367.08	367.7	366.4201	366.524	3291548.0
2023-06-20 14:00:00	QQQ	ETF	366.54	367.32	366.37	366.8188	2680506.0
2023-06-20 15:00:00	QQQ	ETF	366.82	367.735	366.3606	366.935	5740026.0
2023-06-20 16:00:00	QQQ	ETF	366.935	367.0	366.3782	366.74	1095132.0
2023-06-20 17:00:00	QQQ	ETF	366.74	367.4	366.65	366.75	272394.0
2023-06-20 18:00:00	QQQ	ETF	366.78	366.93	366.58	366.67	44371.0
2023-06-20 19:00:00	QQQ	ETF	366.68	367.18	366.68	367.1	62325.0
2023-06-20 04:00:00	IWM	ETF	185.86	185.87	185.03	185.1	14747.0
2023-06-20 05:00:00	IWM	ETF	185.03	185.19	184.99	185.19	16295.0
2023-06-20 06:00:00	IWM	ETF	185.22	185.32	185.12	185.28	11466.0
2023-06-20 07:00:00	IWM	ETF	185.36	185.46	185.17	185.33	66039.0
2023-06-20 08:00:00	IWM	ETF	185.37	185.64	184.97	185.6	52993.0
2023-06-20 09:00:00	IWM	ETF	185.67	185.67	184.61	184.85	5259418.0
2023-06-20 10:00:00	IWM	ETF	184.845	185.17	183.761	184.41	5200889.0
2023-06-20 11:00:00	IWM	ETF	184.42	184.85	184.12	184.53	2144340.0
2023-06-20 12:00:00	IWM	ETF	184.53	185.22	184.33	185.17	1835973.0
2023-06-20 13:00:00	IWM	ETF	185.18	185.3901	185.02	185.05	1799963.0
2023-06-20 14:00:00	IWM	ETF	185.06	185.14	184.72	185.125	1813242.0
2023-06-20 15:00:00	IWM	ETF	185.13	185.57	185.0043	185.12	4796839.0
2023-06-20 16:00:00	IWM	ETF	185.13	185.2	184.82	184.95	624386.0
2023-06-20 17:00:00	IWM	ETF	184.97	185.13	184.97	185.07	888666.0
2023-06-20 18:00:00	IWM	ETF	185.01	185.13	184.94	185.07	23474.0
2023-06-20 19:00:00	IWM	ETF	185.08	185.28	185.05	185.24	11115.0
2023-06-20 04:00:00	DIA	ETF	342.15	342.15	341.55	341.55	2256.0
2023-06-20 05:00:00	DIA	ETF	341.57	341.64	341.55	341.64	1400.0

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

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