PREVIEW / etf_1hour / 2005-11-10

all etf 1-hour files

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

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-10 07:00:00	SPY	ETF	122.37	122.37	122.35	122.37	2400.0
2005-11-10 08:00:00	SPY	ETF	122.37	122.41	122.23	122.29	1580800.0
2005-11-10 09:00:00	SPY	ETF	122.29	122.58	122.23	122.35	6749600.0
2005-11-10 10:00:00	SPY	ETF	122.36	122.38	121.75	122.01	14873300.0
2005-11-10 11:00:00	SPY	ETF	122.0	122.26	121.82	122.09	5948400.0
2005-11-10 12:00:00	SPY	ETF	122.09	122.33	122.02	122.23	5283700.0
2005-11-10 13:00:00	SPY	ETF	122.23	123.23	122.21	123.12	18640300.0
2005-11-10 14:00:00	SPY	ETF	123.12	123.86	123.03	123.46	12022200.0
2005-11-10 15:00:00	SPY	ETF	123.45	123.52	123.24	123.35	11104400.0
2005-11-10 16:00:00	SPY	ETF	123.35	123.4	123.3	123.38	797700.0
2005-11-10 17:00:00	SPY	ETF	123.34	123.35	123.31	123.35	2500.0
2005-11-10 18:00:00	SPY	ETF	123.35	123.38	123.32	123.38	80500.0
2005-11-10 19:00:00	SPY	ETF	123.36	123.41	123.36	123.41	4800.0
2005-11-10 09:00:00	QQQ	ETF	40.18	40.28	40.12	40.14	7611100.0
2005-11-10 10:00:00	QQQ	ETF	40.13	40.15	39.92	40.06	19219700.0
2005-11-10 11:00:00	QQQ	ETF	40.06	40.09	39.95	40.06	8922900.0
2005-11-10 12:00:00	QQQ	ETF	40.06	40.14	40.02	40.11	5846200.0
2005-11-10 13:00:00	QQQ	ETF	40.12	40.54	40.11	40.5	23923900.0
2005-11-10 14:00:00	QQQ	ETF	40.49	40.65	40.46	40.63	17496800.0
2005-11-10 15:00:00	QQQ	ETF	40.62	40.69	40.53	40.6	25000600.0
2005-11-10 08:00:00	IWM	ETF	65.67	65.67	65.57	65.57	23300.0
2005-11-10 09:00:00	IWM	ETF	65.59	65.69	65.3	65.34	2543100.0
2005-11-10 10:00:00	IWM	ETF	65.35	65.4	64.74	65.04	7802800.0
2005-11-10 11:00:00	IWM	ETF	65.04	65.14	64.85	65.02	4190300.0
2005-11-10 12:00:00	IWM	ETF	65.03	65.2	64.96	65.07	3063700.0
2005-11-10 13:00:00	IWM	ETF	65.06	65.93	65.06	65.86	4762600.0
2005-11-10 14:00:00	IWM	ETF	65.86	66.25	65.84	66.22	5433700.0
2005-11-10 15:00:00	IWM	ETF	66.22	66.24	66.04	66.14	5753400.0
2005-11-10 16:00:00	IWM	ETF	66.08	66.16	65.4	66.08	233000.0
2005-11-10 17:00:00	IWM	ETF	66.05	66.05	66.05	66.05	300.0
2005-11-10 18:00:00	IWM	ETF	66.07	66.08	66.07	66.08	1100.0
2005-11-10 19:00:00	IWM	ETF	66.02	66.02	66.02	66.02	100.0
2005-11-10 08:00:00	DIA	ETF	105.6	105.6	105.5	105.5	54000.0
2005-11-10 09:00:00	DIA	ETF	105.56	105.89	105.55	105.76	604500.0
2005-11-10 10:00:00	DIA	ETF	105.72	105.77	105.33	105.5199	1447200.0
2005-11-10 11:00:00	DIA	ETF	105.53	105.65	105.46	105.65	835500.0
2005-11-10 12:00:00	DIA	ETF	105.64	105.79	105.58	105.7	666300.0
2005-11-10 13:00:00	DIA	ETF	105.69	106.52	105.69	106.4401	1571600.0
2005-11-10 14:00:00	DIA	ETF	106.46	106.68	106.34	106.65	1114100.0
2005-11-10 15:00:00	DIA	ETF	106.65	106.68	106.49	106.58	1070500.0
2005-11-10 16:00:00	DIA	ETF	106.57	106.6	106.52	106.59	131400.0
2005-11-10 08:00:00	GLD	ETF	46.57	46.75	46.57	46.6	62300.0
2005-11-10 09:00:00	GLD	ETF	46.62	46.82	46.55	46.56	218000.0
2005-11-10 10:00:00	GLD	ETF	46.56	46.65	46.48	46.63	135300.0
2005-11-10 11:00:00	GLD	ETF	46.6	46.62	46.36	46.52	145600.0
2005-11-10 12:00:00	GLD	ETF	46.51	46.59	46.4801	46.55	65000.0
2005-11-10 13:00:00	GLD	ETF	46.54	46.54	46.41	46.54	41800.0
2005-11-10 14:00:00	GLD	ETF	46.51	46.58	46.5	46.5012	66300.0
2005-11-10 15:00:00	GLD	ETF	46.52	46.55	46.46	46.46	76400.0
2005-11-10 16:00:00	GLD	ETF	46.48	46.48	46.48	46.48	100.0

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

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