PREVIEW / etf_1hour / 2005-10-11

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-10-11.parquet
  size:    33 KB
  rows:    1,000

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-10-11 06:00:00	SPY	ETF	119.11	119.11	119.11	119.11	1700.0
2005-10-11 07:00:00	SPY	ETF	119.04	119.12	119.03	119.05	39600.0
2005-10-11 08:00:00	SPY	ETF	119.04	119.12	118.6	119.07	1169200.0
2005-10-11 09:00:00	SPY	ETF	119.06	119.39	118.95	119.22	8120600.0
2005-10-11 10:00:00	SPY	ETF	119.26	119.39	118.79	118.94	10999100.0
2005-10-11 11:00:00	SPY	ETF	118.92	119.01	118.63	118.81	7447400.0
2005-10-11 12:00:00	SPY	ETF	118.79	118.88	118.43	118.72	9514100.0
2005-10-11 13:00:00	SPY	ETF	118.75	118.99	118.69	118.8	6121000.0
2005-10-11 14:00:00	SPY	ETF	118.8	119.24	118.49	118.68	14104600.0
2005-10-11 15:00:00	SPY	ETF	118.66	118.84	118.32	118.54	11277700.0
2005-10-11 16:00:00	SPY	ETF	118.53	118.61	118.25	118.3	1289500.0
2005-10-11 17:00:00	SPY	ETF	118.29	118.29	118.16	118.24	135900.0
2005-10-11 18:00:00	SPY	ETF	118.25	118.33	118.25	118.33	13300.0
2005-10-11 19:00:00	SPY	ETF	118.24	118.26	118.24	118.26	800.0
2005-10-11 09:00:00	QQQ	ETF	38.21	38.24	38.13	38.17	10555900.0
2005-10-11 10:00:00	QQQ	ETF	38.16	38.23	38.01	38.06	12396700.0
2005-10-11 11:00:00	QQQ	ETF	38.06	38.07	37.92	37.99	13840200.0
2005-10-11 12:00:00	QQQ	ETF	37.99	38.01	37.82	37.91	11385700.0
2005-10-11 13:00:00	QQQ	ETF	37.92	38.05	37.89	37.93	10062300.0
2005-10-11 14:00:00	QQQ	ETF	37.94	38.13	37.84	37.93	22441800.0
2005-10-11 15:00:00	QQQ	ETF	37.93	37.98	37.8	37.93	18003800.0
2005-10-11 08:00:00	IWM	ETF	63.79	63.79	63.69	63.75	25600.0
2005-10-11 09:00:00	IWM	ETF	63.77	63.91	63.56	63.74	2482500.0
2005-10-11 10:00:00	IWM	ETF	63.74	63.78	63.35	63.43	1803900.0
2005-10-11 11:00:00	IWM	ETF	63.43	63.46	63.03	63.12	4104800.0
2005-10-11 12:00:00	IWM	ETF	63.12	63.19	62.84	62.94	4974400.0
2005-10-11 13:00:00	IWM	ETF	62.95	63.35	62.9	63.22	4219600.0
2005-10-11 14:00:00	IWM	ETF	63.23	63.52	62.93	63.15	4989300.0
2005-10-11 15:00:00	IWM	ETF	63.13	63.23	62.6	62.66	9551500.0
2005-10-11 16:00:00	IWM	ETF	62.66	62.69	62.38	62.42	1827000.0
2005-10-11 17:00:00	IWM	ETF	62.43	62.44	62.15	62.22	33700.0
2005-10-11 18:00:00	IWM	ETF	62.28	62.35	62.25	62.25	1400.0
2005-10-11 07:00:00	DIA	ETF	102.65	102.65	102.65	102.65	1000.0
2005-10-11 08:00:00	DIA	ETF	102.74	102.8	102.71	102.76	64600.0
2005-10-11 09:00:00	DIA	ETF	102.75	103.04	102.68	102.93	1022900.0
2005-10-11 10:00:00	DIA	ETF	102.93	103.05	102.62	102.71	1092500.0
2005-10-11 11:00:00	DIA	ETF	102.71	102.8	102.55	102.68	829800.0
2005-10-11 12:00:00	DIA	ETF	102.7	102.83	102.47	102.73	732400.0
2005-10-11 13:00:00	DIA	ETF	102.72	102.91	102.68	102.81	668100.0
2005-10-11 14:00:00	DIA	ETF	102.77	103.18	102.55	102.72	1576900.0
2005-10-11 15:00:00	DIA	ETF	102.72	102.84	102.35	102.56	1878700.0
2005-10-11 16:00:00	DIA	ETF	102.56	102.62	102.4	102.41	13600.0
2005-10-11 17:00:00	DIA	ETF	102.41	102.41	102.35	102.35	6500.0
2005-10-11 08:00:00	GLD	ETF	47.41	47.46	47.3	47.46	13400.0
2005-10-11 09:00:00	GLD	ETF	47.42	47.52	47.38	47.47	322900.0
2005-10-11 10:00:00	GLD	ETF	47.5	47.56	47.38	47.44	353400.0
2005-10-11 11:00:00	GLD	ETF	47.46	47.7	47.41	47.67	291900.0
2005-10-11 12:00:00	GLD	ETF	47.69	47.72	47.55	47.6	830300.0
2005-10-11 13:00:00	GLD	ETF	47.61	47.62	47.4	47.45	391700.0
2005-10-11 14:00:00	GLD	ETF	47.44	47.52	47.41	47.44	348100.0

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

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