PREVIEW / etf_1hour / 2005-10-13

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-10-13.parquet
  size:    33 KB
  rows:    998

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-13 04:00:00	SPY	ETF	117.87	117.87	117.84	117.84	1000.0
2005-10-13 05:00:00	SPY	ETF	117.71	117.71	117.71	117.71	500.0
2005-10-13 07:00:00	SPY	ETF	117.77	117.78	117.56	117.56	188300.0
2005-10-13 08:00:00	SPY	ETF	117.64	117.95	117.21	117.57	2601300.0
2005-10-13 09:00:00	SPY	ETF	117.57	117.8	117.3	117.53	13117000.0
2005-10-13 10:00:00	SPY	ETF	117.52	118.08	117.41	117.92	14134200.0
2005-10-13 11:00:00	SPY	ETF	117.92	118.02	116.94	117.03	10938000.0
2005-10-13 12:00:00	SPY	ETF	117.02	117.91	116.88	117.36	12290500.0
2005-10-13 13:00:00	SPY	ETF	117.36	117.36	116.9	117.28	7156500.0
2005-10-13 14:00:00	SPY	ETF	117.28	118.07	117.27	117.72	23040100.0
2005-10-13 15:00:00	SPY	ETF	117.72	117.98	117.6	117.75	11947100.0
2005-10-13 16:00:00	SPY	ETF	117.8	117.85	117.05	117.65	1345400.0
2005-10-13 17:00:00	SPY	ETF	117.63	117.74	117.58	117.68	430200.0
2005-10-13 18:00:00	SPY	ETF	117.68	117.7	117.6	117.6	9000.0
2005-10-13 19:00:00	SPY	ETF	117.6	117.6	117.6	117.6	900.0
2005-10-13 09:00:00	QQQ	ETF	37.47	37.6	37.41	37.54	17923400.0
2005-10-13 10:00:00	QQQ	ETF	37.54	37.64	37.45	37.58	23563400.0
2005-10-13 11:00:00	QQQ	ETF	37.59	37.63	37.39	37.4	12748800.0
2005-10-13 12:00:00	QQQ	ETF	37.4	37.6	37.33	37.56	20163900.0
2005-10-13 13:00:00	QQQ	ETF	37.56	37.59	37.43	37.57	6909200.0
2005-10-13 14:00:00	QQQ	ETF	37.57	37.89	37.56	37.76	23698000.0
2005-10-13 15:00:00	QQQ	ETF	37.76	37.91	37.74	37.78	18246400.0
2005-10-13 07:00:00	IWM	ETF	61.71	61.73	61.65	61.69	260900.0
2005-10-13 08:00:00	IWM	ETF	61.68	62.1	61.38	61.6	709200.0
2005-10-13 09:00:00	IWM	ETF	61.6	62.14	61.21	61.64	7948200.0
2005-10-13 10:00:00	IWM	ETF	61.65	61.8	61.3	61.7	5489800.0
2005-10-13 11:00:00	IWM	ETF	61.69	61.8	61.05	61.1	3814100.0
2005-10-13 12:00:00	IWM	ETF	61.12	61.73	61.1	61.62	9538300.0
2005-10-13 13:00:00	IWM	ETF	61.63	61.64	61.11	61.4	2736500.0
2005-10-13 14:00:00	IWM	ETF	61.41	62.13	61.4	61.89	7706200.0
2005-10-13 15:00:00	IWM	ETF	61.89	62.14	61.8	61.96	5937200.0
2005-10-13 16:00:00	IWM	ETF	61.95	61.9935	61.85	61.86	206800.0
2005-10-13 17:00:00	IWM	ETF	61.87	61.87	61.87	61.87	66000.0
2005-10-13 18:00:00	IWM	ETF	61.85	61.85	61.85	61.85	200.0
2005-10-13 08:00:00	DIA	ETF	102.11	102.27	101.78	102.0	26000.0
2005-10-13 09:00:00	DIA	ETF	102.04	102.3	101.89	102.12	1111700.0
2005-10-13 10:00:00	DIA	ETF	102.12	102.44	101.95	102.3	1496700.0
2005-10-13 11:00:00	DIA	ETF	102.3	102.38	101.69	101.75	967900.0
2005-10-13 12:00:00	DIA	ETF	101.74	102.07	101.6	101.94	1470900.0
2005-10-13 13:00:00	DIA	ETF	101.93	102.03	101.58	101.85	610200.0
2005-10-13 14:00:00	DIA	ETF	101.86	102.42	101.86	102.18	1296900.0
2005-10-13 15:00:00	DIA	ETF	102.15	102.42	102.02	102.21	964200.0
2005-10-13 16:00:00	DIA	ETF	102.12	102.12	101.53	102.03	27000.0
2005-10-13 17:00:00	DIA	ETF	101.96	102.03	101.96	102.03	3300.0
2005-10-13 18:00:00	DIA	ETF	102.03	102.03	102.03	102.03	1000.0
2005-10-13 19:00:00	DIA	ETF	101.96	101.96	101.96	101.96	300.0
2005-10-13 08:00:00	GLD	ETF	46.94	47.05	46.9	46.9	3800.0
2005-10-13 09:00:00	GLD	ETF	46.9	46.98	46.83	46.94	359900.0
2005-10-13 10:00:00	GLD	ETF	46.95	46.95	46.69	46.86	662700.0
2005-10-13 11:00:00	GLD	ETF	46.85	46.96	46.76	46.76	211500.0

> showing 50 of 998 rows — these rows as CSV

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