PREVIEW / etf_1hour / 2006-10-10

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-10-10.parquet
  size:    52 KB
  rows:    1,688

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
2006-10-10 07:00:00	SPY	ETF	135.15	135.23	135.07	135.22	96700.0
2006-10-10 08:00:00	SPY	ETF	135.2	135.24	135.07	135.15	316100.0
2006-10-10 09:00:00	SPY	ETF	135.17	135.25	134.94	134.95	7813400.0
2006-10-10 10:00:00	SPY	ETF	134.95	135.24	134.89	135.19	8175100.0
2006-10-10 11:00:00	SPY	ETF	135.19	135.45	135.1	135.28	11186600.0
2006-10-10 12:00:00	SPY	ETF	135.27	135.34	134.95	135.06	5344500.0
2006-10-10 13:00:00	SPY	ETF	135.07	135.16	134.84	134.95	7831700.0
2006-10-10 14:00:00	SPY	ETF	134.95	135.24	134.91	135.17	7022600.0
2006-10-10 15:00:00	SPY	ETF	135.18	135.36	135.11	135.33	6524600.0
2006-10-10 16:00:00	SPY	ETF	135.33	135.4	135.13	135.18	1017500.0
2006-10-10 17:00:00	SPY	ETF	135.18	135.19	135.1	135.11	301300.0
2006-10-10 18:00:00	SPY	ETF	135.14	135.15	135.12	135.14	23400.0
2006-10-10 19:00:00	SPY	ETF	135.14	135.14	135.04	135.12	12700.0
2006-10-10 09:00:00	QQQ	ETF	41.61	41.69	41.55	41.55	17648800.0
2006-10-10 10:00:00	QQQ	ETF	41.56	41.61	41.42	41.6	18742500.0
2006-10-10 11:00:00	QQQ	ETF	41.6	41.75	41.56	41.64	11190900.0
2006-10-10 12:00:00	QQQ	ETF	41.64	41.68	41.45	41.5	10300300.0
2006-10-10 13:00:00	QQQ	ETF	41.5	41.54	41.31	41.4	11679400.0
2006-10-10 14:00:00	QQQ	ETF	41.39	41.59	41.35	41.51	11106700.0
2006-10-10 15:00:00	QQQ	ETF	41.5	41.63	41.46	41.62	10845000.0
2006-10-10 08:00:00	IWM	ETF	74.15	74.19	74.08	74.08	36200.0
2006-10-10 09:00:00	IWM	ETF	74.1	74.15	73.67	73.69	5588100.0
2006-10-10 10:00:00	IWM	ETF	73.69	74.15	73.66	74.06	5686900.0
2006-10-10 11:00:00	IWM	ETF	74.07	74.36	73.93	74.19	4322800.0
2006-10-10 12:00:00	IWM	ETF	74.17	74.25	73.84	73.96	3253700.0
2006-10-10 13:00:00	IWM	ETF	73.96	74.05	73.64	73.79	6324700.0
2006-10-10 14:00:00	IWM	ETF	73.78	74.07	73.75	73.94	2868300.0
2006-10-10 15:00:00	IWM	ETF	73.95	74.19	73.93	74.08	4321800.0
2006-10-10 16:00:00	IWM	ETF	74.13	74.18	74.0	74.06	231200.0
2006-10-10 17:00:00	IWM	ETF	74.07	74.12	74.05	74.12	29000.0
2006-10-10 18:00:00	IWM	ETF	74.05	74.05	74.05	74.05	1000.0
2006-10-10 19:00:00	IWM	ETF	74.06	74.06	74.06	74.06	200.0
2006-10-10 07:00:00	DIA	ETF	118.64	118.72	118.64	118.72	1700.0
2006-10-10 08:00:00	DIA	ETF	118.71	118.72	118.59	118.61	162700.0
2006-10-10 09:00:00	DIA	ETF	118.66	118.71	118.4	118.41	529900.0
2006-10-10 10:00:00	DIA	ETF	118.41	118.52	118.33	118.49	1002500.0
2006-10-10 11:00:00	DIA	ETF	118.49	118.77	118.44	118.63	831700.0
2006-10-10 12:00:00	DIA	ETF	118.63	118.69	118.36	118.44	351400.0
2006-10-10 13:00:00	DIA	ETF	118.45	118.49	118.3	118.38	346300.0
2006-10-10 14:00:00	DIA	ETF	118.38	118.59	118.36	118.52	290300.0
2006-10-10 15:00:00	DIA	ETF	118.55	118.69	118.43	118.67	1229100.0
2006-10-10 16:00:00	DIA	ETF	118.66	118.7	118.31	118.45	804000.0
2006-10-10 17:00:00	DIA	ETF	118.54	118.54	118.34	118.34	700.0
2006-10-10 18:00:00	DIA	ETF	118.33	118.33	118.33	118.33	100.0
2006-10-10 19:00:00	DIA	ETF	118.4	118.4	118.4	118.4	400.0
2006-10-10 07:00:00	GLD	ETF	57.01	57.03	56.94	56.94	2100.0
2006-10-10 08:00:00	GLD	ETF	57.01	57.08	56.91	56.97	19700.0
2006-10-10 09:00:00	GLD	ETF	56.8	56.84	56.48	56.67	479600.0
2006-10-10 10:00:00	GLD	ETF	56.64	57.28	56.6	57.14	855200.0
2006-10-10 11:00:00	GLD	ETF	57.14	57.16	56.64	56.84	740000.0

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

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