PREVIEW / etf_1hour / 2023-09-14

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-09-14.parquet
  size:    476 KB
  rows:    17,225

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-09-14 04:00:00	SPY	ETF	447.19	447.87	447.16	447.71	8190.0
2023-09-14 05:00:00	SPY	ETF	447.63	448.08	447.63	447.96	9575.0
2023-09-14 06:00:00	SPY	ETF	448.02	448.57	447.95	448.4	85262.0
2023-09-14 07:00:00	SPY	ETF	448.53	448.68	448.07	448.12	147610.0
2023-09-14 08:00:00	SPY	ETF	448.13	448.96	447.6	448.8	685049.0
2023-09-14 09:00:00	SPY	ETF	448.75	449.59	448.0696	448.915	7041997.0
2023-09-14 10:00:00	SPY	ETF	448.93	449.6	447.715	449.488	9383081.0
2023-09-14 11:00:00	SPY	ETF	449.48	450.03	449.03	449.895	7288988.0
2023-09-14 12:00:00	SPY	ETF	449.895	450.68	449.74	450.63	5514305.0
2023-09-14 13:00:00	SPY	ETF	450.63	450.66	450.14	450.15	4146140.0
2023-09-14 14:00:00	SPY	ETF	450.15	450.62	449.925	450.575	4510042.0
2023-09-14 15:00:00	SPY	ETF	450.58	451.08	450.1129	450.39	15644825.0
2023-09-14 16:00:00	SPY	ETF	450.395	451.05	450.26	450.7	3807009.0
2023-09-14 17:00:00	SPY	ETF	450.66	450.8	450.36	450.64	423589.0
2023-09-14 18:00:00	SPY	ETF	450.64	450.74	450.57	450.68	42886.0
2023-09-14 19:00:00	SPY	ETF	450.64	450.87	450.6	450.67	36962.0
2023-09-14 04:00:00	QQQ	ETF	375.57	375.72	374.76	375.52	29671.0
2023-09-14 05:00:00	QQQ	ETF	375.45	375.72	375.26	375.4	12977.0
2023-09-14 06:00:00	QQQ	ETF	375.49	376.14	375.49	375.93	54211.0
2023-09-14 07:00:00	QQQ	ETF	375.93	376.29	375.55	375.72	107843.0
2023-09-14 08:00:00	QQQ	ETF	375.9104	376.37	374.49	375.92	536480.0
2023-09-14 09:00:00	QQQ	ETF	376.0	376.63	374.0	375.1	4809925.0
2023-09-14 10:00:00	QQQ	ETF	375.1	377.17	373.89	376.805	6810795.0
2023-09-14 11:00:00	QQQ	ETF	376.81	377.78	376.16	377.43	4733782.0
2023-09-14 12:00:00	QQQ	ETF	377.42	378.13	376.77	378.04	3745196.0
2023-09-14 13:00:00	QQQ	ETF	378.03	378.07	377.43	377.44	2799747.0
2023-09-14 14:00:00	QQQ	ETF	377.441	377.67	376.81	377.595	2748765.0
2023-09-14 15:00:00	QQQ	ETF	377.605	378.27	377.12	377.28	5074818.0
2023-09-14 16:00:00	QQQ	ETF	377.27	377.88	377.19	377.4	1118671.0
2023-09-14 17:00:00	QQQ	ETF	377.33	377.55	377.27	377.44	161392.0
2023-09-14 18:00:00	QQQ	ETF	377.45	377.58	377.32	377.48	28123.0
2023-09-14 19:00:00	QQQ	ETF	377.45	377.66	377.38	377.41	51318.0
2023-09-14 04:00:00	IWM	ETF	183.39	183.64	183.3	183.62	4223.0
2023-09-14 05:00:00	IWM	ETF	183.65	183.85	183.65	183.79	4865.0
2023-09-14 06:00:00	IWM	ETF	183.83	184.08	183.81	184.04	44141.0
2023-09-14 07:00:00	IWM	ETF	184.03	184.12	183.89	183.94	45344.0
2023-09-14 08:00:00	IWM	ETF	184.02	184.6	183.44	184.48	186139.0
2023-09-14 09:00:00	IWM	ETF	184.5	186.07	184.42	185.35	5142654.0
2023-09-14 10:00:00	IWM	ETF	185.35	185.895	184.24	185.79	4448535.0
2023-09-14 11:00:00	IWM	ETF	185.79	185.89	185.045	185.29	2236733.0
2023-09-14 12:00:00	IWM	ETF	185.28	185.41	184.985	185.315	1265521.0
2023-09-14 13:00:00	IWM	ETF	185.32	185.59	185.28	185.32	1370190.0
2023-09-14 14:00:00	IWM	ETF	185.32	185.68	185.2901	185.665	1644221.0
2023-09-14 15:00:00	IWM	ETF	185.665	185.86	185.305	185.58	4069366.0
2023-09-14 16:00:00	IWM	ETF	185.55	185.9	185.54	185.77	856363.0
2023-09-14 17:00:00	IWM	ETF	185.77	185.78	185.69	185.69	8724.0
2023-09-14 18:00:00	IWM	ETF	185.69	185.79	185.6	185.7	10339.0
2023-09-14 19:00:00	IWM	ETF	185.72	185.76	185.64	185.68	10775.0
2023-09-14 04:00:00	DIA	ETF	346.98	346.98	346.98	346.98	450.0
2023-09-14 05:00:00	DIA	ETF	347.5	347.53	347.5	347.53	900.0

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

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