PREVIEW / etf_1hour / 2023-08-30

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-08-30.parquet
  size:    474 KB
  rows:    17,375

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-30 04:00:00	SPY	ETF	449.32	449.33	448.55	448.61	25662.0
2023-08-30 05:00:00	SPY	ETF	448.65	448.65	448.33	448.65	15971.0
2023-08-30 06:00:00	SPY	ETF	448.57	449.1	448.51	449.0	26193.0
2023-08-30 07:00:00	SPY	ETF	449.0	449.05	448.67	448.79	231379.0
2023-08-30 08:00:00	SPY	ETF	448.9188	450.08	448.3104	449.59	634560.0
2023-08-30 09:00:00	SPY	ETF	449.56	451.3383	449.26	451.23	6279624.0
2023-08-30 10:00:00	SPY	ETF	451.24	451.62	448.78	450.59	11272125.0
2023-08-30 11:00:00	SPY	ETF	450.6	451.17	449.74	451.06	5756810.0
2023-08-30 12:00:00	SPY	ETF	451.06	451.67	450.77	451.42	5231546.0
2023-08-30 13:00:00	SPY	ETF	451.415	451.46	450.33	450.735	4698785.0
2023-08-30 14:00:00	SPY	ETF	450.75	451.24	449.98	451.1585	6076945.0
2023-08-30 15:00:00	SPY	ETF	451.168	451.4	450.53	450.99	12030312.0
2023-08-30 16:00:00	SPY	ETF	451.0	451.4054	450.3032	451.3	5459697.0
2023-08-30 17:00:00	SPY	ETF	451.31	451.35	451.23	451.31	43024.0
2023-08-30 18:00:00	SPY	ETF	451.31	451.31	451.1	451.13	39232.0
2023-08-30 19:00:00	SPY	ETF	451.13	451.15	451.02	451.07	17384.0
2023-08-30 04:00:00	QQQ	ETF	374.9	374.9	373.93	374.0	70660.0
2023-08-30 05:00:00	QQQ	ETF	373.93	373.99	373.55	373.8	55132.0
2023-08-30 06:00:00	QQQ	ETF	373.89	374.4	373.84	374.35	26903.0
2023-08-30 07:00:00	QQQ	ETF	374.33	374.62	374.05	374.34	116962.0
2023-08-30 08:00:00	QQQ	ETF	374.97	375.72	373.6696	375.17	594793.0
2023-08-30 09:00:00	QQQ	ETF	375.14	376.3239	374.13	376.05	4759398.0
2023-08-30 10:00:00	QQQ	ETF	376.07	377.07	373.86	376.25	7580902.0
2023-08-30 11:00:00	QQQ	ETF	376.28	376.845	375.28	376.79	3912869.0
2023-08-30 12:00:00	QQQ	ETF	376.79	377.4467	376.58	377.125	3592916.0
2023-08-30 13:00:00	QQQ	ETF	377.13	377.29	376.05	376.4956	2990101.0
2023-08-30 14:00:00	QQQ	ETF	376.4965	377.17	375.69	377.06	3654674.0
2023-08-30 15:00:00	QQQ	ETF	377.08	377.37	376.37	376.93	5099326.0
2023-08-30 16:00:00	QQQ	ETF	376.925	377.23	376.71	377.2	734488.0
2023-08-30 17:00:00	QQQ	ETF	377.18	377.18	377.0	377.05	50824.0
2023-08-30 18:00:00	QQQ	ETF	377.12	377.18	377.06	377.08	26925.0
2023-08-30 19:00:00	QQQ	ETF	377.08	377.12	376.93	376.97	38355.0
2023-08-30 04:00:00	IWM	ETF	188.25	188.28	187.79	187.84	11489.0
2023-08-30 05:00:00	IWM	ETF	187.82	187.82	187.56	187.7	9521.0
2023-08-30 06:00:00	IWM	ETF	187.68	188.01	187.68	187.99	3921.0
2023-08-30 07:00:00	IWM	ETF	188.0	188.02	187.67	187.67	44407.0
2023-08-30 08:00:00	IWM	ETF	187.92	188.34	187.6	187.88	65833.0
2023-08-30 09:00:00	IWM	ETF	187.78	188.93	187.33	188.86	3087369.0
2023-08-30 10:00:00	IWM	ETF	188.87	189.22	187.84	189.035	3352561.0
2023-08-30 11:00:00	IWM	ETF	189.04	189.41	188.8	189.3	1411001.0
2023-08-30 12:00:00	IWM	ETF	189.28	189.61	189.095	189.275	1266503.0
2023-08-30 13:00:00	IWM	ETF	189.275	189.335	188.855	189.015	874111.0
2023-08-30 14:00:00	IWM	ETF	189.02	189.19	188.75	189.185	1035523.0
2023-08-30 15:00:00	IWM	ETF	189.2	189.24	188.78	188.97	3360359.0
2023-08-30 16:00:00	IWM	ETF	188.94	189.3	188.94	189.23	570089.0
2023-08-30 17:00:00	IWM	ETF	189.3	189.38	189.25	189.34	19463.0
2023-08-30 18:00:00	IWM	ETF	189.27	189.27	189.08	189.1	21969.0
2023-08-30 19:00:00	IWM	ETF	189.11	189.12	189.04	189.0907	8197.0
2023-08-30 04:00:00	DIA	ETF	348.96	348.96	348.96	348.96	100.0
2023-08-30 05:00:00	DIA	ETF	348.45	348.51	348.45	348.51	401.0

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

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