PREVIEW / etf_1hour / 2005-10-28

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-10-28.parquet
  size:    34 KB
  rows:    1,004

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-28 07:00:00	SPY	ETF	118.21	118.34	118.19	118.31	66000.0
2005-10-28 08:00:00	SPY	ETF	118.29	118.57	117.75	118.47	3975400.0
2005-10-28 09:00:00	SPY	ETF	118.47	118.87	118.41	118.59	8995700.0
2005-10-28 10:00:00	SPY	ETF	118.59	118.77	118.1	118.33	9146600.0
2005-10-28 11:00:00	SPY	ETF	118.32	119.15	118.31	119.12	10529200.0
2005-10-28 12:00:00	SPY	ETF	119.12	119.3	118.91	118.93	5891800.0
2005-10-28 13:00:00	SPY	ETF	118.96	119.26	118.88	119.19	6197600.0
2005-10-28 14:00:00	SPY	ETF	119.19	119.77	119.15	119.7	11063700.0
2005-10-28 15:00:00	SPY	ETF	119.71	119.95	119.57	119.9	13564200.0
2005-10-28 16:00:00	SPY	ETF	119.89	120.03	119.4	119.9	1807700.0
2005-10-28 17:00:00	SPY	ETF	119.9	119.97	119.88	119.89	601300.0
2005-10-28 18:00:00	SPY	ETF	119.89	119.95	119.84	119.85	8500.0
2005-10-28 09:00:00	QQQ	ETF	38.17	38.23	38.13	38.13	12714800.0
2005-10-28 10:00:00	QQQ	ETF	38.13	38.17	37.92	37.98	17717400.0
2005-10-28 11:00:00	QQQ	ETF	37.98	38.25	37.95	38.23	12360600.0
2005-10-28 12:00:00	QQQ	ETF	38.23	38.28	38.12	38.13	10597300.0
2005-10-28 13:00:00	QQQ	ETF	38.13	38.23	38.11	38.2	8742900.0
2005-10-28 14:00:00	QQQ	ETF	38.2	38.35	38.19	38.33	13077500.0
2005-10-28 15:00:00	QQQ	ETF	38.33	38.39	38.25	38.32	11657100.0
2005-10-28 07:00:00	IWM	ETF	62.0	62.0	62.0	62.0	200.0
2005-10-28 08:00:00	IWM	ETF	62.22	62.51	62.14	62.47	118800.0
2005-10-28 09:00:00	IWM	ETF	62.47	62.77	62.4	62.42	6320000.0
2005-10-28 10:00:00	IWM	ETF	62.43	62.53	62.02	62.21	5042800.0
2005-10-28 11:00:00	IWM	ETF	62.22	62.9	62.21	62.89	7855000.0
2005-10-28 12:00:00	IWM	ETF	62.9	63.0	62.56	62.65	3713100.0
2005-10-28 13:00:00	IWM	ETF	62.64	62.85	62.6	62.77	1299300.0
2005-10-28 14:00:00	IWM	ETF	62.77	63.23	62.77	63.17	4049000.0
2005-10-28 15:00:00	IWM	ETF	63.17	63.27	62.92	63.05	6741200.0
2005-10-28 16:00:00	IWM	ETF	63.04	63.21	62.98	63.21	2425000.0
2005-10-28 17:00:00	IWM	ETF	63.14	63.14	63.14	63.14	100.0
2005-10-28 07:00:00	DIA	ETF	102.46	102.46	102.46	102.46	100.0
2005-10-28 08:00:00	DIA	ETF	102.54	102.78	102.53	102.69	64300.0
2005-10-28 09:00:00	DIA	ETF	102.7	102.97	102.65	102.73	1554900.0
2005-10-28 10:00:00	DIA	ETF	102.74	102.83	102.46	102.59	1106700.0
2005-10-28 11:00:00	DIA	ETF	102.57	103.18	102.57	103.169	1349600.0
2005-10-28 12:00:00	DIA	ETF	103.15	103.29	103.05	103.09	503400.0
2005-10-28 13:00:00	DIA	ETF	103.07	103.36	103.05	103.33	1329600.0
2005-10-28 14:00:00	DIA	ETF	103.36	103.85	103.32	103.79	1496900.0
2005-10-28 15:00:00	DIA	ETF	103.8	103.96	103.67	103.9	1000600.0
2005-10-28 16:00:00	DIA	ETF	103.9	103.91	103.78	103.9	66900.0
2005-10-28 17:00:00	DIA	ETF	103.8	103.8	103.8	103.8	300.0
2005-10-28 18:00:00	DIA	ETF	103.8	103.8	103.8	103.8	100.0
2005-10-28 07:00:00	GLD	ETF	47.05	47.05	47.05	47.05	1300.0
2005-10-28 08:00:00	GLD	ETF	47.12	47.16	47.02	47.02	6700.0
2005-10-28 09:00:00	GLD	ETF	47.01	47.01	46.82	46.941	143900.0
2005-10-28 10:00:00	GLD	ETF	46.97	46.98	46.88	46.9	97800.0
2005-10-28 11:00:00	GLD	ETF	46.92	46.99	46.88	46.89	146000.0
2005-10-28 12:00:00	GLD	ETF	46.88	47.16	46.87	47.1	150400.0
2005-10-28 13:00:00	GLD	ETF	47.1	47.22	47.1	47.19	249300.0
2005-10-28 14:00:00	GLD	ETF	47.19	47.22	47.16	47.21	294100.0

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

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