PREVIEW / etf_1hour / 2005-11-30

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-11-30.parquet
  size:    38 KB
  rows:    1,164

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
2005-11-30 06:00:00	SPY	ETF	126.11	126.11	126.06	126.06	25500.0
2005-11-30 07:00:00	SPY	ETF	126.05	126.1	126.02	126.03	4700.0
2005-11-30 08:00:00	SPY	ETF	126.02	126.27	126.0	126.17	585100.0
2005-11-30 09:00:00	SPY	ETF	126.17	126.44	126.09	126.32	5010300.0
2005-11-30 10:00:00	SPY	ETF	126.32	126.52	126.0	126.29	10234100.0
2005-11-30 11:00:00	SPY	ETF	126.29	126.39	125.89	126.01	4579200.0
2005-11-30 12:00:00	SPY	ETF	126.0	126.08	125.82	126.04	3772500.0
2005-11-30 13:00:00	SPY	ETF	126.03	126.15	125.65	125.69	4535000.0
2005-11-30 14:00:00	SPY	ETF	125.69	126.04	125.62	125.79	7163300.0
2005-11-30 15:00:00	SPY	ETF	125.78	125.9	125.29	125.33	10813200.0
2005-11-30 16:00:00	SPY	ETF	125.33	125.49	125.28	125.4	2683800.0
2005-11-30 17:00:00	SPY	ETF	125.43	126.138	125.4	125.5	853400.0
2005-11-30 18:00:00	SPY	ETF	125.48	126.1383	125.48	125.58	3970100.0
2005-11-30 19:00:00	SPY	ETF	125.58	125.63	125.58	125.61	2900.0
2005-11-30 09:00:00	QQQ	ETF	41.29	41.46	41.28	41.38	12079200.0
2005-11-30 10:00:00	QQQ	ETF	41.38	41.49	41.26	41.4	17874400.0
2005-11-30 11:00:00	QQQ	ETF	41.41	41.43	41.24	41.32	10898700.0
2005-11-30 12:00:00	QQQ	ETF	41.32	41.44	41.28	41.42	7421200.0
2005-11-30 13:00:00	QQQ	ETF	41.41	41.48	41.23	41.25	11364200.0
2005-11-30 14:00:00	QQQ	ETF	41.24	41.36	41.22	41.32	8648800.0
2005-11-30 15:00:00	QQQ	ETF	41.32	41.34	41.19	41.24	11461100.0
2005-11-30 08:00:00	IWM	ETF	67.18	67.18	67.15	67.15	1600.0
2005-11-30 09:00:00	IWM	ETF	67.12	67.49	67.08	67.37	4473900.0
2005-11-30 10:00:00	IWM	ETF	67.37	67.7	67.07	67.67	5687300.0
2005-11-30 11:00:00	IWM	ETF	67.6792	67.78	67.35	67.44	5685900.0
2005-11-30 12:00:00	IWM	ETF	67.43	67.63	67.31	67.56	2310600.0
2005-11-30 13:00:00	IWM	ETF	67.56	67.67	67.3	67.32	2522500.0
2005-11-30 14:00:00	IWM	ETF	67.32	67.59	67.26	67.53	4373600.0
2005-11-30 15:00:00	IWM	ETF	67.53	67.57	67.19	67.27	7897600.0
2005-11-30 16:00:00	IWM	ETF	67.3	67.45	67.24	67.4	3858500.0
2005-11-30 17:00:00	IWM	ETF	67.4	67.4	67.4	67.4	300.0
2005-11-30 18:00:00	IWM	ETF	67.46	67.46	67.46	67.46	1000.0
2005-11-30 07:00:00	DIA	ETF	108.89	108.9	108.89	108.9	28600.0
2005-11-30 08:00:00	DIA	ETF	108.89	109.08	108.86	109.05	362400.0
2005-11-30 09:00:00	DIA	ETF	109.04	109.21	108.95	109.1	316600.0
2005-11-30 10:00:00	DIA	ETF	109.11	109.28	108.86	109.13	1130300.0
2005-11-30 11:00:00	DIA	ETF	109.13	109.2	108.75	108.84	465700.0
2005-11-30 12:00:00	DIA	ETF	108.84	108.88	108.67	108.85	467500.0
2005-11-30 13:00:00	DIA	ETF	108.85	108.94	108.5	108.57	584400.0
2005-11-30 14:00:00	DIA	ETF	108.54	108.85	108.45	108.56	617300.0
2005-11-30 15:00:00	DIA	ETF	108.55	108.58	108.07	108.12	1958000.0
2005-11-30 16:00:00	DIA	ETF	108.11	108.22	108.05	108.22	86300.0
2005-11-30 17:00:00	DIA	ETF	108.19	108.21	108.19	108.21	700.0
2005-11-30 18:00:00	DIA	ETF	108.21	108.21	108.21	108.21	300.0
2005-11-30 19:00:00	DIA	ETF	108.28	108.3	108.28	108.3	2200.0
2005-11-30 07:00:00	GLD	ETF	49.31	49.31	49.31	49.31	100.0
2005-11-30 08:00:00	GLD	ETF	49.39	49.43	49.2	49.25	147700.0
2005-11-30 09:00:00	GLD	ETF	49.23	49.5	49.2	49.42	354200.0
2005-11-30 10:00:00	GLD	ETF	49.42	49.43	49.34	49.38	191900.0
2005-11-30 11:00:00	GLD	ETF	49.37	49.46	49.3	49.37	158000.0

> showing 50 of 1,164 rows — these rows as CSV

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