PREVIEW / etf_1hour / 2023-07-12

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-07-12.parquet
  size:    493 KB
  rows:    17,928

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-07-12 04:00:00	SPY	ETF	443.12	443.34	443.0	443.29	20755.0
2023-07-12 05:00:00	SPY	ETF	443.32	443.57	443.32	443.46	13307.0
2023-07-12 06:00:00	SPY	ETF	443.45	443.45	443.24	443.3	14898.0
2023-07-12 07:00:00	SPY	ETF	443.22	443.83	443.21	443.69	114637.0
2023-07-12 08:00:00	SPY	ETF	443.2501	446.22	442.78	445.66	2281607.0
2023-07-12 09:00:00	SPY	ETF	445.66	447.07	442.4	446.93	8996951.0
2023-07-12 10:00:00	SPY	ETF	446.9401	447.4799	446.52	446.9894	9065562.0
2023-07-12 11:00:00	SPY	ETF	446.98	447.12	444.98	445.175	9572297.0
2023-07-12 12:00:00	SPY	ETF	445.17	446.2	444.91	445.835	7303178.0
2023-07-12 13:00:00	SPY	ETF	445.835	446.46	445.65	446.34	3957328.0
2023-07-12 14:00:00	SPY	ETF	446.34	446.75	446.0	446.27	5078769.0
2023-07-12 15:00:00	SPY	ETF	446.27	446.385	445.15	446.01	15432909.0
2023-07-12 16:00:00	SPY	ETF	446.01	446.31	445.7982	446.09	3652703.0
2023-07-12 17:00:00	SPY	ETF	446.12	446.25	446.02	446.11	240160.0
2023-07-12 18:00:00	SPY	ETF	446.11	446.64	446.06	446.45	117124.0
2023-07-12 19:00:00	SPY	ETF	446.42	446.5	446.35	446.4	30886.0
2023-07-12 04:00:00	QQQ	ETF	369.0	369.16	368.88	368.96	26433.0
2023-07-12 05:00:00	QQQ	ETF	369.0	369.32	368.95	369.17	31640.0
2023-07-12 06:00:00	QQQ	ETF	369.11	369.15	368.89	368.93	28964.0
2023-07-12 07:00:00	QQQ	ETF	368.94	369.62	368.89	369.51	138297.0
2023-07-12 08:00:00	QQQ	ETF	368.96	372.2	368.3	371.67	1826609.0
2023-07-12 09:00:00	QQQ	ETF	371.67	373.29	371.55	373.11	8356564.0
2023-07-12 10:00:00	QQQ	ETF	373.11	374.19	372.76	373.05	7337231.0
2023-07-12 11:00:00	QQQ	ETF	373.05	373.46	370.3	370.705	7800981.0
2023-07-12 12:00:00	QQQ	ETF	370.7	372.45	370.43	371.9575	5798593.0
2023-07-12 13:00:00	QQQ	ETF	371.98	373.1	371.7	372.95	3927989.0
2023-07-12 14:00:00	QQQ	ETF	372.94	373.495	372.605	372.89	3663131.0
2023-07-12 15:00:00	QQQ	ETF	372.88	373.34	372.135	372.9	6827216.0
2023-07-12 16:00:00	QQQ	ETF	372.89	373.21	372.69	373.03	2542204.0
2023-07-12 17:00:00	QQQ	ETF	373.04	373.15	372.82	373.1	221355.0
2023-07-12 18:00:00	QQQ	ETF	373.1	373.64	373.01	373.38	39870.0
2023-07-12 19:00:00	QQQ	ETF	373.35	373.48	373.24	373.34	28143.0
2023-07-12 04:00:00	IWM	ETF	190.37	190.54	190.32	190.54	23881.0
2023-07-12 05:00:00	IWM	ETF	190.52	190.78	190.52	190.74	13020.0
2023-07-12 06:00:00	IWM	ETF	190.69	190.8	190.57	190.8	10458.0
2023-07-12 07:00:00	IWM	ETF	190.78	191.0	190.66	190.92	28026.0
2023-07-12 08:00:00	IWM	ETF	190.6502	192.39	189.8	192.39	1058161.0
2023-07-12 09:00:00	IWM	ETF	192.39	193.5	191.6706	192.16	5557315.0
2023-07-12 10:00:00	IWM	ETF	192.16	192.615	191.365	192.295	4549929.0
2023-07-12 11:00:00	IWM	ETF	192.315	192.59	191.5	191.77	2659441.0
2023-07-12 12:00:00	IWM	ETF	191.74	192.42	191.53	192.22	2619574.0
2023-07-12 13:00:00	IWM	ETF	192.22	192.59	192.105	192.59	1515784.0
2023-07-12 14:00:00	IWM	ETF	192.59	192.67	192.35	192.555	1756760.0
2023-07-12 15:00:00	IWM	ETF	192.56	192.6	191.65	191.86	5530143.0
2023-07-12 16:00:00	IWM	ETF	191.85	192.0	191.8	191.83	2416108.0
2023-07-12 17:00:00	IWM	ETF	191.84	191.88	191.67	191.82	307214.0
2023-07-12 18:00:00	IWM	ETF	191.85	192.15	191.85	192.05	24467.0
2023-07-12 19:00:00	IWM	ETF	192.09	192.16	192.0	192.07	28492.0
2023-07-12 04:00:00	DIA	ETF	342.95	343.11	342.95	343.09	6930.0
2023-07-12 07:00:00	DIA	ETF	343.009	343.36	343.009	343.25	3295.0

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

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