PREVIEW / etf_1hour / 2005-11-16

all etf 1-hour files

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

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-16 07:00:00	SPY	ETF	123.16	123.26	123.16	123.26	900.0
2005-11-16 08:00:00	SPY	ETF	123.2	123.4	123.18	123.39	2001400.0
2005-11-16 09:00:00	SPY	ETF	123.4	123.55	123.26	123.32	7277900.0
2005-11-16 10:00:00	SPY	ETF	123.31	123.35	122.99	123.22	9247900.0
2005-11-16 11:00:00	SPY	ETF	123.22	123.43	122.98	123.35	7817200.0
2005-11-16 12:00:00	SPY	ETF	123.36	123.46	123.2	123.23	3925800.0
2005-11-16 13:00:00	SPY	ETF	123.22	123.32	123.02	123.21	4450900.0
2005-11-16 14:00:00	SPY	ETF	123.21	123.43	123.07	123.36	4356800.0
2005-11-16 15:00:00	SPY	ETF	123.36	123.49	123.26	123.46	7053400.0
2005-11-16 16:00:00	SPY	ETF	123.48	123.55	123.2797	123.49	3711600.0
2005-11-16 17:00:00	SPY	ETF	123.46	123.47	123.44	123.45	8300.0
2005-11-16 18:00:00	SPY	ETF	123.45	123.45	123.45	123.45	500.0
2005-11-16 19:00:00	SPY	ETF	123.44	123.44	123.44	123.44	100.0
2005-11-16 09:00:00	QQQ	ETF	40.64	40.71	40.63	40.64	9106900.0
2005-11-16 10:00:00	QQQ	ETF	40.64	40.66	40.53	40.61	11897500.0
2005-11-16 11:00:00	QQQ	ETF	40.61	40.73	40.46	40.68	13802900.0
2005-11-16 12:00:00	QQQ	ETF	40.68	40.7	40.61	40.63	4184700.0
2005-11-16 13:00:00	QQQ	ETF	40.63	40.67	40.55	40.64	4964600.0
2005-11-16 14:00:00	QQQ	ETF	40.64	40.69	40.57	40.68	4489400.0
2005-11-16 15:00:00	QQQ	ETF	40.68	40.78	40.63	40.77	13109900.0
2005-11-16 08:00:00	IWM	ETF	65.13	65.33	65.13	65.33	26100.0
2005-11-16 09:00:00	IWM	ETF	65.33	65.5	65.11	65.15	3074800.0
2005-11-16 10:00:00	IWM	ETF	65.15	65.17	64.8	64.92	5290700.0
2005-11-16 11:00:00	IWM	ETF	64.92	65.1	64.58	65.02	6094800.0
2005-11-16 12:00:00	IWM	ETF	65.03	65.19	64.97	64.98	2765800.0
2005-11-16 13:00:00	IWM	ETF	64.97	65.06	64.78	64.95	2674000.0
2005-11-16 14:00:00	IWM	ETF	64.95	65.03	64.7	64.98	2849900.0
2005-11-16 15:00:00	IWM	ETF	64.98	65.15	64.88	65.14	3849500.0
2005-11-16 16:00:00	IWM	ETF	65.14	65.37	65.05	65.23	534500.0
2005-11-16 17:00:00	IWM	ETF	65.21	65.21	65.16	65.19	7400.0
2005-11-16 18:00:00	IWM	ETF	65.22	65.25	65.2	65.25	23300.0
2005-11-16 07:00:00	DIA	ETF	107.0	107.0	107.0	107.0	300.0
2005-11-16 08:00:00	DIA	ETF	107.03	107.23	107.01	107.23	46200.0
2005-11-16 09:00:00	DIA	ETF	107.23	107.35	107.1	107.25	2092100.0
2005-11-16 10:00:00	DIA	ETF	107.21	107.25	106.98	107.07	1091900.0
2005-11-16 11:00:00	DIA	ETF	107.0599	107.13	106.85	107.1	1208800.0
2005-11-16 12:00:00	DIA	ETF	107.11	107.12	106.96	106.98	171100.0
2005-11-16 13:00:00	DIA	ETF	106.97	106.99	106.81	106.91	809400.0
2005-11-16 14:00:00	DIA	ETF	106.92	106.98	106.73	106.94	927100.0
2005-11-16 15:00:00	DIA	ETF	106.9	107.0	106.83	106.97	473400.0
2005-11-16 16:00:00	DIA	ETF	106.98	107.06	106.96	107.04	38900.0
2005-11-16 07:00:00	GLD	ETF	47.09	47.11	47.08	47.11	3000.0
2005-11-16 08:00:00	GLD	ETF	47.11	47.36	47.11	47.35	264100.0
2005-11-16 09:00:00	GLD	ETF	47.35	47.43	47.22	47.41	471300.0
2005-11-16 10:00:00	GLD	ETF	47.41	47.66	47.36	47.51	348000.0
2005-11-16 11:00:00	GLD	ETF	47.52	47.65	47.41	47.51	336400.0
2005-11-16 12:00:00	GLD	ETF	47.5201	47.62	47.46	47.59	263600.0
2005-11-16 13:00:00	GLD	ETF	47.6	47.72	47.6	47.69	135400.0
2005-11-16 14:00:00	GLD	ETF	47.69	47.73	47.65	47.66	187800.0
2005-11-16 15:00:00	GLD	ETF	47.65	47.76	47.65	47.76	339900.0

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

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