PREVIEW / etf_1hour / 2023-12-01

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-12-01.parquet
  size:    515 KB
  rows:    18,919

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-12-01 04:00:00	SPY	ETF	456.2	457.28	456.2	457.05	51071.0
2023-12-01 05:00:00	SPY	ETF	457.03	457.03	456.65	456.65	19425.0
2023-12-01 06:00:00	SPY	ETF	456.64	456.78	456.45	456.54	75653.0
2023-12-01 07:00:00	SPY	ETF	456.53	456.54	455.45	455.58	181469.0
2023-12-01 08:00:00	SPY	ETF	455.55	457.3104	455.45	455.5299	225606.0
2023-12-01 09:00:00	SPY	ETF	455.51	456.22	455.18	456.105	4691437.0
2023-12-01 10:00:00	SPY	ETF	456.11	457.13	455.33	456.33	8723140.0
2023-12-01 11:00:00	SPY	ETF	456.34	458.75	455.16	458.33	12324842.0
2023-12-01 12:00:00	SPY	ETF	458.34	459.65	458.15	459.41	8183903.0
2023-12-01 13:00:00	SPY	ETF	459.415	459.49	458.19	458.31	6479554.0
2023-12-01 14:00:00	SPY	ETF	458.32	459.09	458.195	459.08	5114810.0
2023-12-01 15:00:00	SPY	ETF	459.07	459.32	458.38	459.035	13251848.0
2023-12-01 16:00:00	SPY	ETF	459.03	459.36	458.7734	459.31	6737855.0
2023-12-01 17:00:00	SPY	ETF	459.24	459.74	459.24	459.7	764807.0
2023-12-01 18:00:00	SPY	ETF	459.69	459.9	459.62	459.75	142729.0
2023-12-01 19:00:00	SPY	ETF	459.73	459.89	459.73	459.82	27369.0
2023-12-01 04:00:00	QQQ	ETF	388.89	389.35	388.6	388.98	69341.0
2023-12-01 05:00:00	QQQ	ETF	388.98	389.04	388.63	388.63	10492.0
2023-12-01 06:00:00	QQQ	ETF	388.57	388.79	388.36	388.51	22098.0
2023-12-01 07:00:00	QQQ	ETF	388.46	388.46	387.4	387.52	115958.0
2023-12-01 08:00:00	QQQ	ETF	388.6604	389.2296	387.4	387.63	165795.0
2023-12-01 09:00:00	QQQ	ETF	387.64	387.99	386.33	387.25	3491810.0
2023-12-01 10:00:00	QQQ	ETF	387.27	388.46	386.0726	387.3	5324373.0
2023-12-01 11:00:00	QQQ	ETF	387.3077	389.78	386.55	389.195	8054534.0
2023-12-01 12:00:00	QQQ	ETF	389.2	390.54	388.85	390.261	4019255.0
2023-12-01 13:00:00	QQQ	ETF	390.26	390.36	389.0	389.21	3089157.0
2023-12-01 14:00:00	QQQ	ETF	389.24	390.125	389.1	390.11	2301599.0
2023-12-01 15:00:00	QQQ	ETF	390.1	390.25	389.4035	389.97	5128510.0
2023-12-01 16:00:00	QQQ	ETF	389.97	390.22	389.587	390.1	978357.0
2023-12-01 17:00:00	QQQ	ETF	390.1	390.54	390.1	390.4617	34339.0
2023-12-01 18:00:00	QQQ	ETF	390.51	390.74	390.43	390.63	37984.0
2023-12-01 19:00:00	QQQ	ETF	390.6513	390.73	390.54	390.73	13791.0
2023-12-01 04:00:00	IWM	ETF	180.41	180.68	180.41	180.55	15576.0
2023-12-01 05:00:00	IWM	ETF	180.45	180.45	180.0	180.01	16986.0
2023-12-01 06:00:00	IWM	ETF	179.98	180.03	179.8	179.92	78220.0
2023-12-01 07:00:00	IWM	ETF	179.9	179.91	179.17	179.2	446348.0
2023-12-01 08:00:00	IWM	ETF	179.84	180.6896	179.15	179.18	138663.0
2023-12-01 09:00:00	IWM	ETF	179.21	180.19	178.21	180.09	3793538.0
2023-12-01 10:00:00	IWM	ETF	180.1	181.72	180.1	181.608	6108063.0
2023-12-01 11:00:00	IWM	ETF	181.61	183.8397	180.64	183.67	11080689.0
2023-12-01 12:00:00	IWM	ETF	183.67	184.71	183.57	184.6395	5660686.0
2023-12-01 13:00:00	IWM	ETF	184.63	184.67	183.76	183.98	4585167.0
2023-12-01 14:00:00	IWM	ETF	183.99	184.36	183.8	184.07	3415349.0
2023-12-01 15:00:00	IWM	ETF	184.06	185.18	183.82	184.96	11192586.0
2023-12-01 16:00:00	IWM	ETF	184.91	185.29	184.91	185.17	1577646.0
2023-12-01 17:00:00	IWM	ETF	185.14	185.23	184.91	185.18	113773.0
2023-12-01 18:00:00	IWM	ETF	185.18	185.3398	185.08	185.22	28233.0
2023-12-01 19:00:00	IWM	ETF	185.23	185.39	185.08	185.39	25588.0
2023-12-01 05:00:00	DIA	ETF	360.68	360.68	360.68	360.68	500.0
2023-12-01 06:00:00	DIA	ETF	360.39	360.64	360.39	360.58	1300.0

> showing 50 of 18,919 rows — these rows as CSV

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