PREVIEW / etf_1hour / 2023-09-07

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-09-07.parquet
  size:    477 KB
  rows:    17,247

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-07 04:00:00	SPY	ETF	445.6	445.6	444.6	445.19	35984.0
2023-09-07 05:00:00	SPY	ETF	445.13	445.74	445.13	445.47	13175.0
2023-09-07 06:00:00	SPY	ETF	445.4	445.5	444.66	444.92	76855.0
2023-09-07 07:00:00	SPY	ETF	444.98	445.26	444.41	444.45	179025.0
2023-09-07 08:00:00	SPY	ETF	444.9799	446.07	442.7942	443.11	556874.0
2023-09-07 09:00:00	SPY	ETF	443.02	444.4	442.805	443.425	6824892.0
2023-09-07 10:00:00	SPY	ETF	443.43	444.66	442.75	444.0299	8600630.0
2023-09-07 11:00:00	SPY	ETF	444.05	445.01	443.86	443.995	5489189.0
2023-09-07 12:00:00	SPY	ETF	443.99	445.24	443.905	444.4817	4171703.0
2023-09-07 13:00:00	SPY	ETF	444.49	445.22	444.305	445.07	3991475.0
2023-09-07 14:00:00	SPY	ETF	445.08	445.35	444.1	444.975	5774740.0
2023-09-07 15:00:00	SPY	ETF	444.98	445.55	444.27	444.84	15090926.0
2023-09-07 16:00:00	SPY	ETF	444.83	445.0607	444.53	445.01	4555794.0
2023-09-07 17:00:00	SPY	ETF	445.13	445.18	444.85	445.1	344481.0
2023-09-07 18:00:00	SPY	ETF	445.11	445.159	445.0	445.08	15176.0
2023-09-07 19:00:00	SPY	ETF	445.11	445.12	444.81	445.03	28138.0
2023-09-07 04:00:00	QQQ	ETF	373.57	373.59	371.99	372.51	95896.0
2023-09-07 05:00:00	QQQ	ETF	372.6	373.39	372.52	372.81	71763.0
2023-09-07 06:00:00	QQQ	ETF	372.9	373.05	372.35	372.45	74239.0
2023-09-07 07:00:00	QQQ	ETF	372.5	372.9	372.02	372.1	235332.0
2023-09-07 08:00:00	QQQ	ETF	372.56	375.021	369.92	370.23	887449.0
2023-09-07 09:00:00	QQQ	ETF	370.2	371.16	369.15	370.0	7662970.0
2023-09-07 10:00:00	QQQ	ETF	370.0	372.15	369.26	371.0	6977970.0
2023-09-07 11:00:00	QQQ	ETF	371.01	371.91	370.1202	370.31	4452892.0
2023-09-07 12:00:00	QQQ	ETF	370.31	371.94	370.19	371.16	3195956.0
2023-09-07 13:00:00	QQQ	ETF	371.15	372.31	370.99	372.12	2801339.0
2023-09-07 14:00:00	QQQ	ETF	372.12	372.54	371.31	372.3467	3935901.0
2023-09-07 15:00:00	QQQ	ETF	372.36	372.85	371.63	372.03	6538939.0
2023-09-07 16:00:00	QQQ	ETF	372.03	372.27	371.71	372.27	1113312.0
2023-09-07 17:00:00	QQQ	ETF	372.23	372.26	372.1	372.2293	47136.0
2023-09-07 18:00:00	QQQ	ETF	372.24	372.34	372.21	372.23	33506.0
2023-09-07 19:00:00	QQQ	ETF	372.2	372.33	371.92	372.16	47975.0
2023-09-07 04:00:00	IWM	ETF	185.93	186.09	185.7	186.04	14065.0
2023-09-07 05:00:00	IWM	ETF	186.09	186.3	186.01	186.13	13641.0
2023-09-07 06:00:00	IWM	ETF	186.09	186.23	185.88	185.95	17683.0
2023-09-07 07:00:00	IWM	ETF	185.92	186.08	185.66	185.67	21955.0
2023-09-07 08:00:00	IWM	ETF	186.01	186.0104	184.94	185.31	239050.0
2023-09-07 09:00:00	IWM	ETF	185.2	185.46	183.82	183.895	3244125.0
2023-09-07 10:00:00	IWM	ETF	183.895	184.33	183.59	184.0	3667822.0
2023-09-07 11:00:00	IWM	ETF	184.03	184.25	183.79	183.845	2094813.0
2023-09-07 12:00:00	IWM	ETF	183.84	184.375	183.82	184.1	1812428.0
2023-09-07 13:00:00	IWM	ETF	184.1	184.57	184.07	184.5	1735369.0
2023-09-07 14:00:00	IWM	ETF	184.5	184.64	184.25	184.435	1800030.0
2023-09-07 15:00:00	IWM	ETF	184.43	184.67	184.2	184.37	3542211.0
2023-09-07 16:00:00	IWM	ETF	184.375	184.57	184.27	184.57	1101002.0
2023-09-07 17:00:00	IWM	ETF	184.56	184.69	184.43	184.4501	10339.0
2023-09-07 18:00:00	IWM	ETF	184.52	184.61	184.52	184.55	18208.0
2023-09-07 19:00:00	IWM	ETF	184.55	184.59	184.46	184.57	18544.0
2023-09-07 04:00:00	DIA	ETF	344.94	345.04	344.78	344.79	2335.0
2023-09-07 05:00:00	DIA	ETF	345.29	345.59	345.29	345.57	2702.0

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

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