PREVIEW / etf_1hour / 2005-11-28

all etf 1-hour files

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

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-28 07:00:00	SPY	ETF	127.39	127.44	127.39	127.42	25500.0
2005-11-28 08:00:00	SPY	ETF	127.4	127.44	127.32	127.34	332500.0
2005-11-28 09:00:00	SPY	ETF	127.35	127.36	126.6	126.65	9577600.0
2005-11-28 10:00:00	SPY	ETF	126.63	126.81	126.47	126.63	9412300.0
2005-11-28 11:00:00	SPY	ETF	126.63	126.8	126.58	126.69	5389700.0
2005-11-28 12:00:00	SPY	ETF	126.69	126.71	126.35	126.36	4724400.0
2005-11-28 13:00:00	SPY	ETF	126.37	126.47	126.31	126.39	4607000.0
2005-11-28 14:00:00	SPY	ETF	126.35	126.44	126.22	126.33	5532500.0
2005-11-28 15:00:00	SPY	ETF	126.32	126.38	126.04	126.15	10272000.0
2005-11-28 16:00:00	SPY	ETF	126.16	126.26	126.06	126.22	1379900.0
2005-11-28 17:00:00	SPY	ETF	126.21	126.27	126.21	126.24	81600.0
2005-11-28 18:00:00	SPY	ETF	126.23	126.25	126.22	126.25	10700.0
2005-11-28 19:00:00	SPY	ETF	126.25	126.31	126.25	126.31	9300.0
2005-11-28 09:00:00	QQQ	ETF	41.97	42.0	41.69	41.7	12054000.0
2005-11-28 10:00:00	QQQ	ETF	41.7	41.74	41.57	41.59	15762400.0
2005-11-28 11:00:00	QQQ	ETF	41.58	41.75	41.57	41.68	10433100.0
2005-11-28 12:00:00	QQQ	ETF	41.69	41.74	41.51	41.52	7744300.0
2005-11-28 13:00:00	QQQ	ETF	41.52	41.61	41.5	41.58	7625100.0
2005-11-28 14:00:00	QQQ	ETF	41.58	41.65	41.54	41.61	5597600.0
2005-11-28 15:00:00	QQQ	ETF	41.59	41.63	41.5	41.55	11215600.0
2005-11-28 08:00:00	IWM	ETF	68.09	68.1	68.02	68.1	48900.0
2005-11-28 09:00:00	IWM	ETF	68.1	68.15	67.48	67.48	3346300.0
2005-11-28 10:00:00	IWM	ETF	67.48	67.58	67.22	67.28	3482200.0
2005-11-28 11:00:00	IWM	ETF	67.28	67.4	67.19	67.24	2330400.0
2005-11-28 12:00:00	IWM	ETF	67.25	67.27	66.91	66.92	5358900.0
2005-11-28 13:00:00	IWM	ETF	66.93	67.0	66.85	66.95	1811200.0
2005-11-28 14:00:00	IWM	ETF	66.94	67.08	66.84	67.0	1304600.0
2005-11-28 15:00:00	IWM	ETF	66.99	67.0	66.81	66.83	5571600.0
2005-11-28 16:00:00	IWM	ETF	66.83	67.09	66.83	66.97	256400.0
2005-11-28 17:00:00	IWM	ETF	67.01	67.01	66.96	67.0	1000.0
2005-11-28 07:00:00	DIA	ETF	109.65	109.65	109.63	109.63	4600.0
2005-11-28 08:00:00	DIA	ETF	109.61	109.65	109.5	109.52	27300.0
2005-11-28 09:00:00	DIA	ETF	109.51	109.55	109.06	109.08	1390300.0
2005-11-28 10:00:00	DIA	ETF	109.08	109.4	108.98	109.12	879900.0
2005-11-28 11:00:00	DIA	ETF	109.11	109.34	109.1	109.24	649300.0
2005-11-28 12:00:00	DIA	ETF	109.24	109.25	109.04	109.08	731100.0
2005-11-28 13:00:00	DIA	ETF	109.07	109.08	108.96	109.0	1286200.0
2005-11-28 14:00:00	DIA	ETF	108.97	109.05	108.9	108.96	844600.0
2005-11-28 15:00:00	DIA	ETF	108.97	109.0	108.76	108.93	1246200.0
2005-11-28 16:00:00	DIA	ETF	108.97	109.06	108.93	109.02	70200.0
2005-11-28 17:00:00	DIA	ETF	109.05	109.05	109.05	109.05	100.0
2005-11-28 18:00:00	DIA	ETF	109.02	109.02	109.02	109.02	300.0
2005-11-28 19:00:00	DIA	ETF	109.02	109.1	109.02	109.06	4500.0
2005-11-28 08:00:00	GLD	ETF	49.6	49.6	49.24	49.25	32900.0
2005-11-28 09:00:00	GLD	ETF	49.28	49.33	49.2	49.3	579100.0
2005-11-28 10:00:00	GLD	ETF	49.3	49.54	49.27	49.34	466700.0
2005-11-28 11:00:00	GLD	ETF	49.34	49.67	49.34	49.61	358000.0
2005-11-28 12:00:00	GLD	ETF	49.61	49.65	49.49	49.56	210700.0
2005-11-28 13:00:00	GLD	ETF	49.5595	49.75	49.55	49.73	183500.0
2005-11-28 14:00:00	GLD	ETF	49.7201	49.75	49.7	49.73	183500.0

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

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