PREVIEW / etf_1hour / 2005-12-27

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-12-27.parquet
  size:    39 KB
  rows:    1,194

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-12-27 05:00:00	SPY	ETF	127.1	127.1	127.1	127.1	100.0
2005-12-27 07:00:00	SPY	ETF	127.04	127.06	127.02	127.05	9600.0
2005-12-27 08:00:00	SPY	ETF	127.07	127.09	127.01	127.03	135400.0
2005-12-27 09:00:00	SPY	ETF	127.03	127.05	126.9	127.0	3397100.0
2005-12-27 10:00:00	SPY	ETF	127.0	127.02	126.76	126.77	3910200.0
2005-12-27 11:00:00	SPY	ETF	126.77	126.8	126.08	126.1	7506600.0
2005-12-27 12:00:00	SPY	ETF	126.1	126.17	125.92	126.01	5536700.0
2005-12-27 13:00:00	SPY	ETF	126.01	126.12	125.5	125.61	8374700.0
2005-12-27 14:00:00	SPY	ETF	125.61	125.92	125.59	125.71	6381400.0
2005-12-27 15:00:00	SPY	ETF	125.72	125.86	125.48	125.51	6838400.0
2005-12-27 16:00:00	SPY	ETF	125.51	125.56	125.35	125.45	911600.0
2005-12-27 17:00:00	SPY	ETF	125.47	125.52	125.42	125.45	64200.0
2005-12-27 18:00:00	SPY	ETF	125.46	125.51	125.46	125.51	700.0
2005-12-27 19:00:00	SPY	ETF	125.47	125.52	125.47	125.52	4200.0
2005-12-27 09:00:00	QQQ	ETF	41.52	41.68	41.49	41.62	7521400.0
2005-12-27 10:00:00	QQQ	ETF	41.61	41.62	41.44	41.44	5992600.0
2005-12-27 11:00:00	QQQ	ETF	41.44	41.51	41.12	41.13	9913900.0
2005-12-27 12:00:00	QQQ	ETF	41.13	41.18	41.06	41.13	8026200.0
2005-12-27 13:00:00	QQQ	ETF	41.13	41.18	40.97	41.01	6762500.0
2005-12-27 14:00:00	QQQ	ETF	41.0	41.17	40.99	41.1	5056300.0
2005-12-27 15:00:00	QQQ	ETF	41.1	41.15	40.99	41.04	7143400.0
2005-12-27 08:00:00	IWM	ETF	68.33	68.41	68.33	68.41	26300.0
2005-12-27 09:00:00	IWM	ETF	68.35	68.43	68.2	68.23	1889700.0
2005-12-27 10:00:00	IWM	ETF	68.23	68.23	67.9	67.95	1861600.0
2005-12-27 11:00:00	IWM	ETF	67.91	67.98	67.44	67.45	4413100.0
2005-12-27 12:00:00	IWM	ETF	67.44	67.51	67.28	67.39	4838000.0
2005-12-27 13:00:00	IWM	ETF	67.39	67.5	67.15	67.2	3164900.0
2005-12-27 14:00:00	IWM	ETF	67.2	67.44	67.17	67.26	3043100.0
2005-12-27 15:00:00	IWM	ETF	67.26	67.35	67.07	67.26	5887100.0
2005-12-27 16:00:00	IWM	ETF	67.26	67.33	67.0	67.18	562100.0
2005-12-27 17:00:00	IWM	ETF	67.17	67.29	67.17	67.29	1100.0
2005-12-27 19:00:00	IWM	ETF	67.22	67.22	67.22	67.22	1100.0
2005-12-27 08:00:00	DIA	ETF	108.97	109.0	108.97	109.0	1500.0
2005-12-27 09:00:00	DIA	ETF	108.99	109.25	108.89	109.18	617900.0
2005-12-27 10:00:00	DIA	ETF	109.2	109.25	108.96	108.98	1217300.0
2005-12-27 11:00:00	DIA	ETF	108.97	109.02	108.38	108.4	2027500.0
2005-12-27 12:00:00	DIA	ETF	108.39	108.4	108.17	108.24	1262500.0
2005-12-27 13:00:00	DIA	ETF	108.24	108.31	107.71	107.79	1276700.0
2005-12-27 14:00:00	DIA	ETF	107.78	108.05	107.77	107.83	969200.0
2005-12-27 15:00:00	DIA	ETF	107.84	107.92	107.64	107.745	718500.0
2005-12-27 16:00:00	DIA	ETF	107.73	107.77	107.65	107.7	32600.0
2005-12-27 17:00:00	DIA	ETF	107.73	107.73	107.73	107.73	100.0
2005-12-27 19:00:00	DIA	ETF	107.73	107.75	107.73	107.75	1000.0
2005-12-27 08:00:00	GLD	ETF	50.53	50.54	50.35	50.45	23900.0
2005-12-27 09:00:00	GLD	ETF	50.48	50.66	50.48	50.55	1415100.0
2005-12-27 10:00:00	GLD	ETF	50.5699	50.67	50.5101	50.6	1797800.0
2005-12-27 11:00:00	GLD	ETF	50.61	50.64	50.51	50.5101	248200.0
2005-12-27 12:00:00	GLD	ETF	50.51	50.68	50.5	50.62	164200.0
2005-12-27 13:00:00	GLD	ETF	50.62	50.7	50.6	50.69	188400.0
2005-12-27 14:00:00	GLD	ETF	50.68	50.69	50.6	50.6676	109300.0

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

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