PREVIEW / etf_1hour / 2022-09-23

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-09-23.parquet
  size:    475 KB
  rows:    17,986

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-09-23 04:00:00	SPY	ETF	372.84	373.48	371.86	371.88	65109.0
2022-09-23 05:00:00	SPY	ETF	371.83	371.87	370.31	371.28	146073.0
2022-09-23 06:00:00	SPY	ETF	371.31	371.32	368.99	369.08	321408.0
2022-09-23 07:00:00	SPY	ETF	369.07	369.77	368.87	369.6	798483.0
2022-09-23 08:00:00	SPY	ETF	369.17	374.14	368.65	369.13	1021210.0
2022-09-23 09:00:00	SPY	ETF	369.12	371.04	367.7	367.79	11770289.0
2022-09-23 10:00:00	SPY	ETF	367.8	368.81	367.35	367.4675	11378858.0
2022-09-23 11:00:00	SPY	ETF	367.46	368.82	366.16	366.82	8038510.0
2022-09-23 12:00:00	SPY	ETF	366.82	366.925	364.83	366.63	9026076.0
2022-09-23 13:00:00	SPY	ETF	366.6414	367.19	365.48	366.1599	6900661.0
2022-09-23 14:00:00	SPY	ETF	366.16	366.65	363.29	363.495	9829481.0
2022-09-23 15:00:00	SPY	ETF	363.48	368.235	363.41	367.92	24846354.0
2022-09-23 16:00:00	SPY	ETF	367.91	368.49	367.49	368.29	4478279.0
2022-09-23 17:00:00	SPY	ETF	368.3	368.65	367.95	368.4	231308.0
2022-09-23 18:00:00	SPY	ETF	368.35	368.5	367.95	367.95	77682.0
2022-09-23 19:00:00	SPY	ETF	368.1	368.25	368.03	368.24	45688.0
2022-09-23 04:00:00	QQQ	ETF	279.46	279.46	277.89	277.91	85917.0
2022-09-23 05:00:00	QQQ	ETF	277.93	278.02	276.63	277.49	142978.0
2022-09-23 06:00:00	QQQ	ETF	277.5	277.5	275.8	275.97	286615.0
2022-09-23 07:00:00	QQQ	ETF	275.94	276.57	275.7	276.4	674833.0
2022-09-23 08:00:00	QQQ	ETF	276.08	279.7	275.7	276.37	897906.0
2022-09-23 09:00:00	QQQ	ETF	276.39	278.07	274.97	275.0399	10004145.0
2022-09-23 10:00:00	QQQ	ETF	275.02	276.57	274.66	275.6	8807421.0
2022-09-23 11:00:00	QQQ	ETF	275.6	276.78	274.63	275.22	5523999.0
2022-09-23 12:00:00	QQQ	ETF	275.2	275.34	273.6501	275.02	6552784.0
2022-09-23 13:00:00	QQQ	ETF	275.03	275.4399	273.91	274.42	4131540.0
2022-09-23 14:00:00	QQQ	ETF	274.41	274.83	272.02	272.19	6921040.0
2022-09-23 15:00:00	QQQ	ETF	272.14	275.7995	272.13	275.52	12259093.0
2022-09-23 16:00:00	QQQ	ETF	275.51	275.95	275.4	275.84	2985121.0
2022-09-23 17:00:00	QQQ	ETF	275.94	276.0	275.51	275.89	477951.0
2022-09-23 18:00:00	QQQ	ETF	275.88	275.98	275.8	275.87	34175.0
2022-09-23 19:00:00	QQQ	ETF	275.88	275.93	274.62	275.68	40486.0
2022-09-23 04:00:00	IWM	ETF	170.54	170.78	170.11	170.11	22310.0
2022-09-23 05:00:00	IWM	ETF	170.17	170.2	169.34	169.83	38950.0
2022-09-23 06:00:00	IWM	ETF	169.76	169.77	168.53	168.54	66146.0
2022-09-23 07:00:00	IWM	ETF	168.57	168.94	168.47	168.91	101349.0
2022-09-23 08:00:00	IWM	ETF	168.72	171.39	168.51	168.79	245710.0
2022-09-23 09:00:00	IWM	ETF	168.79	169.49	167.09	167.15	3297654.0
2022-09-23 10:00:00	IWM	ETF	167.1	167.46	166.33	166.615	4747001.0
2022-09-23 11:00:00	IWM	ETF	166.54	167.65	166.18	166.56	2954575.0
2022-09-23 12:00:00	IWM	ETF	166.565	166.59	165.32	166.4101	2843612.0
2022-09-23 13:00:00	IWM	ETF	166.42	166.8	165.82	166.25	2922415.0
2022-09-23 14:00:00	IWM	ETF	166.24	166.58	165.0	165.13	2790774.0
2022-09-23 15:00:00	IWM	ETF	165.13	167.51	165.05	167.26	6625477.0
2022-09-23 16:00:00	IWM	ETF	167.27	167.59	167.07	167.49	1407578.0
2022-09-23 17:00:00	IWM	ETF	167.49	167.55	167.31	167.53	791710.0
2022-09-23 18:00:00	IWM	ETF	167.41	167.48	167.35	167.41	7857.0
2022-09-23 19:00:00	IWM	ETF	167.37	167.65	167.01	167.49	27198.0
2022-09-23 04:00:00	DIA	ETF	299.73	299.77	299.02	299.02	3000.0
2022-09-23 05:00:00	DIA	ETF	298.95	298.95	297.97	297.97	5000.0

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

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