PREVIEW / etf_1hour / 2023-06-08

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-06-08.parquet
  size:    470 KB
  rows:    16,898

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-08 04:00:00	SPY	ETF	426.53	427.08	426.41	426.81	33848.0
2023-06-08 05:00:00	SPY	ETF	426.92	427.09	426.75	427.06	11566.0
2023-06-08 06:00:00	SPY	ETF	427.05	427.21	426.72	426.77	21744.0
2023-06-08 07:00:00	SPY	ETF	426.68	426.83	426.46	426.8	129522.0
2023-06-08 08:00:00	SPY	ETF	426.63	427.23	425.75	426.98	303005.0
2023-06-08 09:00:00	SPY	ETF	426.94	427.12	425.82	426.5	5091623.0
2023-06-08 10:00:00	SPY	ETF	426.505	428.03	426.31	427.97	7631205.0
2023-06-08 11:00:00	SPY	ETF	427.98	428.35	427.78	428.0	5218271.0
2023-06-08 12:00:00	SPY	ETF	428.0	429.2	427.71	428.6215	6093392.0
2023-06-08 13:00:00	SPY	ETF	428.63	428.83	427.71	428.21	4760224.0
2023-06-08 14:00:00	SPY	ETF	428.215	429.08	427.99	428.95	4897220.0
2023-06-08 15:00:00	SPY	ETF	428.96	429.6	428.81	429.125	11611601.0
2023-06-08 16:00:00	SPY	ETF	429.11	429.31	428.84	429.13	3793970.0
2023-06-08 17:00:00	SPY	ETF	429.15	429.35	428.87	429.04	186182.0
2023-06-08 18:00:00	SPY	ETF	429.07	429.07	428.82	428.98	243547.0
2023-06-08 19:00:00	SPY	ETF	428.98	428.99	428.8	428.84	65749.0
2023-06-08 04:00:00	QQQ	ETF	348.03	349.0	347.9	348.76	54683.0
2023-06-08 05:00:00	QQQ	ETF	348.79	349.34	348.72	349.29	39151.0
2023-06-08 06:00:00	QQQ	ETF	349.3	349.45	348.81	348.99	101365.0
2023-06-08 07:00:00	QQQ	ETF	348.92	349.06	348.45	348.7	137348.0
2023-06-08 08:00:00	QQQ	ETF	349.01	349.92	347.36	349.64	953313.0
2023-06-08 09:00:00	QQQ	ETF	349.74	350.555	348.89	350.09	6025478.0
2023-06-08 10:00:00	QQQ	ETF	350.1	352.069	349.8	352.01	6108345.0
2023-06-08 11:00:00	QQQ	ETF	352.02	353.41	351.94	352.93	5216920.0
2023-06-08 12:00:00	QQQ	ETF	352.93	353.62	352.35	352.6077	3951220.0
2023-06-08 13:00:00	QQQ	ETF	352.6	352.88	351.13	351.76	4258282.0
2023-06-08 14:00:00	QQQ	ETF	351.77	352.8	351.5099	352.6705	2874975.0
2023-06-08 15:00:00	QQQ	ETF	352.6625	353.435	352.56	353.065	5229065.0
2023-06-08 16:00:00	QQQ	ETF	353.06	353.71	352.88	353.57	1487441.0
2023-06-08 17:00:00	QQQ	ETF	353.57	353.57	353.3	353.43	37106.0
2023-06-08 18:00:00	QQQ	ETF	353.45	353.5	353.2	353.31	34350.0
2023-06-08 19:00:00	QQQ	ETF	353.31	353.4	353.01	353.12	48817.0
2023-06-08 04:00:00	IWM	ETF	187.72	188.03	187.6	187.84	26976.0
2023-06-08 05:00:00	IWM	ETF	187.83	187.86	187.56	187.72	12586.0
2023-06-08 06:00:00	IWM	ETF	187.72	187.86	187.5	187.5	5067.0
2023-06-08 07:00:00	IWM	ETF	187.48	187.7	187.45	187.67	40353.0
2023-06-08 08:00:00	IWM	ETF	187.4712	187.9796	187.01	187.2	300003.0
2023-06-08 09:00:00	IWM	ETF	187.12	187.375	184.98	185.6	6458529.0
2023-06-08 10:00:00	IWM	ETF	185.61	185.87	185.27	185.51	3827513.0
2023-06-08 11:00:00	IWM	ETF	185.51	186.18	184.91	185.74	3587495.0
2023-06-08 12:00:00	IWM	ETF	185.74	186.31	185.57	186.155	1962664.0
2023-06-08 13:00:00	IWM	ETF	186.155	186.69	186.01	186.35	2588697.0
2023-06-08 14:00:00	IWM	ETF	186.36	187.0097	186.05	186.805	2617996.0
2023-06-08 15:00:00	IWM	ETF	186.81	186.87	186.22	186.47	4478833.0
2023-06-08 16:00:00	IWM	ETF	186.54	186.54	186.26	186.42	1359665.0
2023-06-08 17:00:00	IWM	ETF	186.41	186.51	185.94	186.03	214213.0
2023-06-08 18:00:00	IWM	ETF	186.18	186.4	186.12	186.4	85605.0
2023-06-08 19:00:00	IWM	ETF	186.42	186.54	186.37	186.4	59148.0
2023-06-08 04:00:00	DIA	ETF	337.48	337.6	337.48	337.6	1000.0
2023-06-08 05:00:00	DIA	ETF	337.21	337.21	337.21	337.21	100.0

> showing 50 of 16,898 rows — these rows as CSV

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