PREVIEW / etf_1hour / 2023-09-08

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-09-08.parquet
  size:    464 KB
  rows:    16,847

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-08 04:00:00	SPY	ETF	445.75	445.86	444.35	444.38	31285.0
2023-09-08 05:00:00	SPY	ETF	444.13	444.27	443.78	443.97	27094.0
2023-09-08 06:00:00	SPY	ETF	443.88	444.61	443.88	444.55	43900.0
2023-09-08 07:00:00	SPY	ETF	444.65	444.66	443.84	444.29	56886.0
2023-09-08 08:00:00	SPY	ETF	444.25	446.0	443.8796	444.84	212381.0
2023-09-08 09:00:00	SPY	ETF	444.78	446.1	444.78	445.8199	4464929.0
2023-09-08 10:00:00	SPY	ETF	445.84	447.11	445.75	445.905	7974587.0
2023-09-08 11:00:00	SPY	ETF	445.91	446.899	445.77	446.1799	4760603.0
2023-09-08 12:00:00	SPY	ETF	446.18	446.78	445.58	446.101	4441962.0
2023-09-08 13:00:00	SPY	ETF	446.11	446.19	445.52	445.881	4068396.0
2023-09-08 14:00:00	SPY	ETF	445.88	446.22	444.87	444.92	5410815.0
2023-09-08 15:00:00	SPY	ETF	444.905	445.61	444.53	445.51	10894354.0
2023-09-08 16:00:00	SPY	ETF	445.51	446.5173	444.0	445.68	2895771.0
2023-09-08 17:00:00	SPY	ETF	445.68	445.94	445.52	445.89	442658.0
2023-09-08 18:00:00	SPY	ETF	445.87	445.87	445.55	445.56	202208.0
2023-09-08 19:00:00	SPY	ETF	445.5698	445.58	445.1	445.11	191035.0
2023-09-08 04:00:00	QQQ	ETF	373.19	373.35	371.79	371.81	62928.0
2023-09-08 05:00:00	QQQ	ETF	371.77	371.77	371.0	371.0	39644.0
2023-09-08 06:00:00	QQQ	ETF	371.03	371.77	371.03	371.72	36635.0
2023-09-08 07:00:00	QQQ	ETF	371.75	371.86	370.811	371.34	119658.0
2023-09-08 08:00:00	QQQ	ETF	371.35	373.61	370.92	371.97	345360.0
2023-09-08 09:00:00	QQQ	ETF	371.9699	374.4	371.89	373.44	4121263.0
2023-09-08 10:00:00	QQQ	ETF	373.46	374.85	372.61	372.61	6095517.0
2023-09-08 11:00:00	QQQ	ETF	372.6	374.35	372.36	373.66	3297094.0
2023-09-08 12:00:00	QQQ	ETF	373.67	374.2	372.72	373.36	2776198.0
2023-09-08 13:00:00	QQQ	ETF	373.35	373.522	372.69	373.31	1681842.0
2023-09-08 14:00:00	QQQ	ETF	373.32	373.699	371.925	371.97	3089598.0
2023-09-08 15:00:00	QQQ	ETF	371.94	372.67	371.6	372.55	5169539.0
2023-09-08 16:00:00	QQQ	ETF	372.54	373.38	372.53	373.0	1004338.0
2023-09-08 17:00:00	QQQ	ETF	373.0	373.09	372.95	373.08	60329.0
2023-09-08 18:00:00	QQQ	ETF	373.0271	373.12	373.0271	373.06	8930.0
2023-09-08 19:00:00	QQQ	ETF	373.06	373.1	372.9	372.9	33132.0
2023-09-08 04:00:00	IWM	ETF	184.84	184.89	184.18	184.2	21247.0
2023-09-08 05:00:00	IWM	ETF	184.15	184.32	184.08	184.1	5401.0
2023-09-08 06:00:00	IWM	ETF	184.17	184.41	184.08	184.31	3761.0
2023-09-08 07:00:00	IWM	ETF	184.32	184.44	183.94	184.33	22506.0
2023-09-08 08:00:00	IWM	ETF	184.2504	184.84	184.2504	184.49	99376.0
2023-09-08 09:00:00	IWM	ETF	184.51	184.83	183.45	183.8	2852142.0
2023-09-08 10:00:00	IWM	ETF	183.81	184.625	183.77	184.14	2545748.0
2023-09-08 11:00:00	IWM	ETF	184.13	184.64	184.09	184.4	1304002.0
2023-09-08 12:00:00	IWM	ETF	184.41	184.7	184.26	184.425	1466360.0
2023-09-08 13:00:00	IWM	ETF	184.425	184.5558	184.21	184.38	1343201.0
2023-09-08 14:00:00	IWM	ETF	184.38	184.515	183.98	184.115	1102237.0
2023-09-08 15:00:00	IWM	ETF	184.115	184.145	183.81	183.98	3118882.0
2023-09-08 16:00:00	IWM	ETF	183.98	184.24	183.9	183.97	519799.0
2023-09-08 17:00:00	IWM	ETF	183.99	184.05	183.8	183.95	22506.0
2023-09-08 18:00:00	IWM	ETF	184.05	184.07	183.93	184.0	9098.0
2023-09-08 19:00:00	IWM	ETF	184.0	184.0	183.85	183.95	4515.0
2023-09-08 04:00:00	DIA	ETF	346.31	346.39	345.26	345.26	1183.0
2023-09-08 05:00:00	DIA	ETF	345.04	345.04	344.95	344.95	250.0

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

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