PREVIEW / etf_1hour / 2006-10-12

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-10-12.parquet
  size:    54 KB
  rows:    1,728

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-12 06:00:00	SPY	ETF	135.15	135.15	135.15	135.15	900.0
2006-10-12 07:00:00	SPY	ETF	135.25	135.27	135.24	135.26	60900.0
2006-10-12 08:00:00	SPY	ETF	135.31	135.49	135.24	135.47	2233800.0
2006-10-12 09:00:00	SPY	ETF	135.47	135.6	135.4	135.48	6428300.0
2006-10-12 10:00:00	SPY	ETF	135.48	135.75	135.45	135.66	7504200.0
2006-10-12 11:00:00	SPY	ETF	135.67	135.93	135.6	135.83	9858100.0
2006-10-12 12:00:00	SPY	ETF	135.82	135.87	135.74	135.8	5000000.0
2006-10-12 13:00:00	SPY	ETF	135.81	135.89	135.7	135.85	3450800.0
2006-10-12 14:00:00	SPY	ETF	135.85	136.12	135.82	136.07	9179100.0
2006-10-12 15:00:00	SPY	ETF	136.07	136.39	135.99	136.26	11426300.0
2006-10-12 16:00:00	SPY	ETF	136.27	136.34	135.29	136.29	2191200.0
2006-10-12 17:00:00	SPY	ETF	136.3	136.39	136.3	136.36	207400.0
2006-10-12 18:00:00	SPY	ETF	136.33	136.33	136.28	136.29	14300.0
2006-10-12 19:00:00	SPY	ETF	136.33	136.33	136.33	136.33	13700.0
2006-10-12 09:00:00	QQQ	ETF	41.76	41.83	41.7	41.76	10713900.0
2006-10-12 10:00:00	QQQ	ETF	41.76	41.88	41.74	41.78	10404000.0
2006-10-12 11:00:00	QQQ	ETF	41.78	41.87	41.73	41.82	8796000.0
2006-10-12 12:00:00	QQQ	ETF	41.82	41.87	41.78	41.82	6661100.0
2006-10-12 13:00:00	QQQ	ETF	41.82	41.86	41.76	41.85	6191800.0
2006-10-12 14:00:00	QQQ	ETF	41.84	42.01	41.84	41.96	15973900.0
2006-10-12 15:00:00	QQQ	ETF	41.97	42.25	41.95	42.2	24925400.0
2006-10-12 08:00:00	IWM	ETF	73.92	74.1	73.92	74.1	113300.0
2006-10-12 09:00:00	IWM	ETF	74.1	74.4	74.06	74.35	5817600.0
2006-10-12 10:00:00	IWM	ETF	74.35	74.63	74.28	74.53	8059200.0
2006-10-12 11:00:00	IWM	ETF	74.53	74.7	74.45	74.55	3882100.0
2006-10-12 12:00:00	IWM	ETF	74.55	74.71	74.47	74.63	2154500.0
2006-10-12 13:00:00	IWM	ETF	74.64	74.66	74.41	74.52	4192000.0
2006-10-12 14:00:00	IWM	ETF	74.53	74.79	74.52	74.71	3789800.0
2006-10-12 15:00:00	IWM	ETF	74.71	75.28	74.7	75.24	9626600.0
2006-10-12 16:00:00	IWM	ETF	75.24	75.39	73.698	75.33	1658500.0
2006-10-12 17:00:00	IWM	ETF	75.32	75.33	75.3	75.32	15400.0
2006-10-12 18:00:00	IWM	ETF	75.32	75.32	75.32	75.32	19000.0
2006-10-12 19:00:00	IWM	ETF	75.33	75.33	75.33	75.33	100.0
2006-10-12 07:00:00	DIA	ETF	118.75	118.78	118.75	118.78	600.0
2006-10-12 08:00:00	DIA	ETF	118.82	118.9	118.77	118.9	27700.0
2006-10-12 09:00:00	DIA	ETF	118.9	119.03	118.86	118.98	726100.0
2006-10-12 10:00:00	DIA	ETF	118.97	119.21	118.95	119.13	778600.0
2006-10-12 11:00:00	DIA	ETF	119.12	119.35	119.04	119.29	643000.0
2006-10-12 12:00:00	DIA	ETF	119.3	119.32	119.15	119.21	357900.0
2006-10-12 13:00:00	DIA	ETF	119.21	119.26	119.15	119.24	241100.0
2006-10-12 14:00:00	DIA	ETF	119.23	119.44	119.22	119.3501	982400.0
2006-10-12 15:00:00	DIA	ETF	119.3505	119.58	119.35	119.455	1566200.0
2006-10-12 16:00:00	DIA	ETF	119.44	119.5	119.39	119.5	106500.0
2006-10-12 07:00:00	GLD	ETF	56.99	56.99	56.99	56.99	100.0
2006-10-12 08:00:00	GLD	ETF	56.97	57.05	56.8	56.93	12600.0
2006-10-12 09:00:00	GLD	ETF	56.9	56.96	56.65	56.89	450700.0
2006-10-12 10:00:00	GLD	ETF	56.9	57.23	56.81	57.18	587600.0
2006-10-12 11:00:00	GLD	ETF	57.17	57.43	57.1	57.2201	355100.0
2006-10-12 12:00:00	GLD	ETF	57.24	57.2501	56.99	57.17	293500.0
2006-10-12 13:00:00	GLD	ETF	57.18	57.31	57.07	57.2	331600.0

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

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