PREVIEW / etf_1hour / 2023-08-03

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-08-03.parquet
  size:    483 KB
  rows:    17,746

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-08-03 04:00:00	SPY	ETF	447.91	450.13	447.87	448.74	45628.0
2023-08-03 05:00:00	SPY	ETF	448.74	449.4	448.74	449.39	40098.0
2023-08-03 06:00:00	SPY	ETF	449.34	449.8	449.2	449.3	59079.0
2023-08-03 07:00:00	SPY	ETF	449.31	449.9	448.97	449.23	121630.0
2023-08-03 08:00:00	SPY	ETF	449.68	450.9	448.0	448.85	603444.0
2023-08-03 09:00:00	SPY	ETF	448.89	449.0	447.63	448.561	6761721.0
2023-08-03 10:00:00	SPY	ETF	448.55	449.3	447.37	448.49	9562814.0
2023-08-03 11:00:00	SPY	ETF	448.49	449.87	448.38	449.275	6694741.0
2023-08-03 12:00:00	SPY	ETF	449.28	450.74	449.13	450.56	4461382.0
2023-08-03 13:00:00	SPY	ETF	450.56	450.79	449.43	449.5101	5138604.0
2023-08-03 14:00:00	SPY	ETF	449.515	450.12	449.2599	449.97	4193197.0
2023-08-03 15:00:00	SPY	ETF	449.99	450.03	448.775	448.84	10053596.0
2023-08-03 16:00:00	SPY	ETF	448.84	451.14	448.58	449.27	3245957.0
2023-08-03 17:00:00	SPY	ETF	449.1	449.39	448.72	449.14	134472.0
2023-08-03 18:00:00	SPY	ETF	449.14	450.03	449.06	449.86	142816.0
2023-08-03 19:00:00	SPY	ETF	449.92	450.2	449.58	449.88	63661.0
2023-08-03 04:00:00	QQQ	ETF	371.74	373.19	371.63	372.7	66827.0
2023-08-03 05:00:00	QQQ	ETF	372.81	373.57	372.81	373.47	47999.0
2023-08-03 06:00:00	QQQ	ETF	373.68	373.83	373.11	373.23	73011.0
2023-08-03 07:00:00	QQQ	ETF	373.25	374.01	372.86	373.04	253358.0
2023-08-03 08:00:00	QQQ	ETF	373.84	374.81	371.61	372.45	880439.0
2023-08-03 09:00:00	QQQ	ETF	372.43	374.36	371.76	373.83	6286904.0
2023-08-03 10:00:00	QQQ	ETF	373.81	374.57	371.83	373.56	6536904.0
2023-08-03 11:00:00	QQQ	ETF	373.555	375.03	373.34	374.22	4628694.0
2023-08-03 12:00:00	QQQ	ETF	374.2219	375.95	373.96	375.59	3333659.0
2023-08-03 13:00:00	QQQ	ETF	375.59	375.75	374.15	374.25	3419692.0
2023-08-03 14:00:00	QQQ	ETF	374.25	374.92	373.91	374.775	2633078.0
2023-08-03 15:00:00	QQQ	ETF	374.8	374.83	373.35	373.78	5224039.0
2023-08-03 16:00:00	QQQ	ETF	373.76	376.62	373.3	374.15	3126133.0
2023-08-03 17:00:00	QQQ	ETF	374.15	374.4	373.19	373.86	315343.0
2023-08-03 18:00:00	QQQ	ETF	373.95	375.03	373.8	374.88	155496.0
2023-08-03 19:00:00	QQQ	ETF	375.02	375.4	374.56	375.0	115878.0
2023-08-03 04:00:00	IWM	ETF	194.01	194.67	193.96	194.3	22367.0
2023-08-03 05:00:00	IWM	ETF	194.45	194.85	194.45	194.84	5323.0
2023-08-03 06:00:00	IWM	ETF	194.81	195.02	194.81	194.82	8259.0
2023-08-03 07:00:00	IWM	ETF	194.94	195.16	194.6	194.75	48052.0
2023-08-03 08:00:00	IWM	ETF	194.84	195.0	194.0796	194.73	213406.0
2023-08-03 09:00:00	IWM	ETF	194.75	194.88	193.375	193.8442	3598746.0
2023-08-03 10:00:00	IWM	ETF	193.84	194.23	193.06	194.02	3677398.0
2023-08-03 11:00:00	IWM	ETF	194.01	194.77	193.97	194.62	2245287.0
2023-08-03 12:00:00	IWM	ETF	194.62	195.54	194.505	195.53	2138727.0
2023-08-03 13:00:00	IWM	ETF	195.54	195.64	194.75	194.84	1943211.0
2023-08-03 14:00:00	IWM	ETF	194.83	195.15	194.675	194.99	1294361.0
2023-08-03 15:00:00	IWM	ETF	194.99	195.02	194.41	194.56	3627633.0
2023-08-03 16:00:00	IWM	ETF	194.56	195.22	194.07	194.34	560861.0
2023-08-03 17:00:00	IWM	ETF	194.27	194.56	194.12	194.55	64958.0
2023-08-03 18:00:00	IWM	ETF	194.55	194.56	194.25	194.55	99907.0
2023-08-03 19:00:00	IWM	ETF	194.58	194.72	194.3	194.48	18249.0
2023-08-03 04:00:00	DIA	ETF	351.98	351.98	351.98	351.98	284.0
2023-08-03 06:00:00	DIA	ETF	352.35	352.51	352.35	352.51	400.0

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

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