PREVIEW / etf_1hour / 2023-12-05

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-12-05.parquet
  size:    511 KB
  rows:    18,823

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-05 04:00:00	SPY	ETF	455.63	455.88	455.59	455.75	13932.0
2023-12-05 05:00:00	SPY	ETF	455.58	455.64	454.9	455.06	25051.0
2023-12-05 06:00:00	SPY	ETF	455.06	455.44	454.7	454.72	62738.0
2023-12-05 07:00:00	SPY	ETF	454.71	455.24	454.62	454.99	98150.0
2023-12-05 08:00:00	SPY	ETF	454.84	455.9104	454.68	455.04	275295.0
2023-12-05 09:00:00	SPY	ETF	455.03	455.7883	454.63	455.475	4668776.0
2023-12-05 10:00:00	SPY	ETF	455.46	457.41	455.38	457.3895	10089886.0
2023-12-05 11:00:00	SPY	ETF	457.39	457.59	455.365	456.045	7589473.0
2023-12-05 12:00:00	SPY	ETF	456.06	456.44	455.23	456.2362	5087175.0
2023-12-05 13:00:00	SPY	ETF	456.23	456.57	455.87	456.19	4678346.0
2023-12-05 14:00:00	SPY	ETF	456.2	456.7	455.9	456.6482	4627396.0
2023-12-05 15:00:00	SPY	ETF	456.65	456.79	456.09	456.58	12221344.0
2023-12-05 16:00:00	SPY	ETF	456.58	456.83	456.27	456.32	2642757.0
2023-12-05 17:00:00	SPY	ETF	456.35	456.5	456.26	456.41	54162.0
2023-12-05 18:00:00	SPY	ETF	456.4	456.84	456.2	456.84	27581.0
2023-12-05 19:00:00	SPY	ETF	456.85	457.49	456.84	457.47	78403.0
2023-12-05 04:00:00	QQQ	ETF	384.69	385.08	384.46	384.62	30392.0
2023-12-05 05:00:00	QQQ	ETF	384.55	384.61	383.75	384.01	34734.0
2023-12-05 06:00:00	QQQ	ETF	383.98	384.45	383.67	383.71	94009.0
2023-12-05 07:00:00	QQQ	ETF	383.78	384.47	383.73	384.17	138866.0
2023-12-05 08:00:00	QQQ	ETF	384.71	386.609	383.71	384.56	235624.0
2023-12-05 09:00:00	QQQ	ETF	384.6	386.15	383.89	385.9267	4247317.0
2023-12-05 10:00:00	QQQ	ETF	385.89	388.49	385.8	388.28	7857361.0
2023-12-05 11:00:00	QQQ	ETF	388.28	388.5	385.4	386.27	5300418.0
2023-12-05 12:00:00	QQQ	ETF	386.29	386.96	385.29	386.3799	3222725.0
2023-12-05 13:00:00	QQQ	ETF	386.37	386.83	385.94	386.365	2467637.0
2023-12-05 14:00:00	QQQ	ETF	386.375	387.13	386.01	387.01	2786842.0
2023-12-05 15:00:00	QQQ	ETF	387.0	387.31	386.62	387.295	5237893.0
2023-12-05 16:00:00	QQQ	ETF	387.29	387.62	386.94	387.01	1236823.0
2023-12-05 17:00:00	QQQ	ETF	386.99	387.13	386.9	386.98	197495.0
2023-12-05 18:00:00	QQQ	ETF	386.91	387.7	386.8	387.67	61947.0
2023-12-05 19:00:00	QQQ	ETF	387.68	388.6	387.68	388.59	110797.0
2023-12-05 04:00:00	IWM	ETF	186.65	187.12	186.27	186.68	16013.0
2023-12-05 05:00:00	IWM	ETF	186.56	186.81	186.31	186.37	11830.0
2023-12-05 06:00:00	IWM	ETF	186.41	186.7	186.09	186.39	135998.0
2023-12-05 07:00:00	IWM	ETF	186.46	186.89	186.4	186.42	146683.0
2023-12-05 08:00:00	IWM	ETF	186.73	187.1096	185.88	186.08	227087.0
2023-12-05 09:00:00	IWM	ETF	186.06	186.22	184.505	185.03	4501349.0
2023-12-05 10:00:00	IWM	ETF	185.02	185.85	184.5	185.37	5309752.0
2023-12-05 11:00:00	IWM	ETF	185.37	185.78	184.59	184.88	3352289.0
2023-12-05 12:00:00	IWM	ETF	184.885	184.985	183.98	184.64	3353444.0
2023-12-05 13:00:00	IWM	ETF	184.6294	184.93	184.37	184.5401	2545688.0
2023-12-05 14:00:00	IWM	ETF	184.54	184.97	184.44	184.8	2502325.0
2023-12-05 15:00:00	IWM	ETF	184.81	184.87	184.19	184.4	5843132.0
2023-12-05 16:00:00	IWM	ETF	184.39	184.51	184.35	184.41	2293370.0
2023-12-05 17:00:00	IWM	ETF	184.43	184.48	184.35	184.48	15741.0
2023-12-05 18:00:00	IWM	ETF	184.38	184.78	184.32	184.78	44373.0
2023-12-05 19:00:00	IWM	ETF	184.78	185.1208	184.78	185.12	49468.0
2023-12-05 04:00:00	DIA	ETF	362.25	362.41	362.25	362.36	1228.0
2023-12-05 06:00:00	DIA	ETF	362.13	362.13	361.85	361.85	884.0

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

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