PREVIEW / etf_1hour / 2006-09-14

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-09-14.parquet
  size:    49 KB
  rows:    1,589

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-09-14 06:00:00	SPY	ETF	132.24	132.24	132.24	132.24	100.0
2006-09-14 07:00:00	SPY	ETF	132.2	132.2	132.12	132.12	5200.0
2006-09-14 08:00:00	SPY	ETF	132.14	132.27	131.96	131.99	702900.0
2006-09-14 09:00:00	SPY	ETF	131.99	132.17	131.85	131.93	10512400.0
2006-09-14 10:00:00	SPY	ETF	131.94	132.04	131.75	131.93	10435600.0
2006-09-14 11:00:00	SPY	ETF	131.93	132.15	131.85	131.98	6891700.0
2006-09-14 12:00:00	SPY	ETF	132.0	132.1	131.82	132.06	5258100.0
2006-09-14 13:00:00	SPY	ETF	132.06	132.15	131.91	132.07	5394100.0
2006-09-14 14:00:00	SPY	ETF	132.07	132.22	131.92	131.94	5452700.0
2006-09-14 15:00:00	SPY	ETF	131.93	132.12	131.84	132.06	7829900.0
2006-09-14 16:00:00	SPY	ETF	132.07	132.24	131.92	132.18	3433700.0
2006-09-14 17:00:00	SPY	ETF	132.2	132.25	132.2	132.21	94700.0
2006-09-14 18:00:00	SPY	ETF	132.21	132.26	132.2	132.2	6300.0
2006-09-14 19:00:00	SPY	ETF	132.24	132.26	132.24	132.26	9100.0
2006-09-14 09:00:00	QQQ	ETF	39.85	39.94	39.77	39.9	14285900.0
2006-09-14 10:00:00	QQQ	ETF	39.9	39.97	39.81	39.91	19324700.0
2006-09-14 11:00:00	QQQ	ETF	39.91	40.22	39.89	39.98	16569000.0
2006-09-14 12:00:00	QQQ	ETF	39.99	40.04	39.91	39.99	7828000.0
2006-09-14 13:00:00	QQQ	ETF	39.99	40.03	39.92	40.01	8218700.0
2006-09-14 14:00:00	QQQ	ETF	39.97	40.08	39.76	39.97	9572100.0
2006-09-14 15:00:00	QQQ	ETF	39.97	40.02	39.81	39.97	16285600.0
2006-09-14 07:00:00	IWM	ETF	72.5	72.5	72.5	72.5	3000.0
2006-09-14 08:00:00	IWM	ETF	72.69	72.76	72.51	72.61	767000.0
2006-09-14 09:00:00	IWM	ETF	72.6	72.62	72.15	72.33	4930300.0
2006-09-14 10:00:00	IWM	ETF	72.31	72.3899	72.01	72.21	6862200.0
2006-09-14 11:00:00	IWM	ETF	72.22	72.55	72.18	72.4291	4778200.0
2006-09-14 12:00:00	IWM	ETF	72.43	72.55	72.25	72.46	2677200.0
2006-09-14 13:00:00	IWM	ETF	72.45	72.52	72.28	72.4	1322700.0
2006-09-14 14:00:00	IWM	ETF	72.4	72.51	72.2	72.24	4889100.0
2006-09-14 15:00:00	IWM	ETF	72.24	72.46	72.09	72.38	6254000.0
2006-09-14 16:00:00	IWM	ETF	72.38	72.52	72.38	72.47	420900.0
2006-09-14 17:00:00	IWM	ETF	72.48	72.49	72.47	72.47	7300.0
2006-09-14 08:00:00	DIA	ETF	115.39	115.4	115.29	115.29	24300.0
2006-09-14 09:00:00	DIA	ETF	115.29	115.39	115.11	115.18	707300.0
2006-09-14 10:00:00	DIA	ETF	115.18	115.32	115.06	115.27	1191800.0
2006-09-14 11:00:00	DIA	ETF	115.29	115.43	115.2	115.32	444800.0
2006-09-14 12:00:00	DIA	ETF	115.32	115.42	115.18	115.4	250200.0
2006-09-14 13:00:00	DIA	ETF	115.4	115.52	115.29	115.47	308600.0
2006-09-14 14:00:00	DIA	ETF	115.47	115.59	115.33	115.33	457800.0
2006-09-14 15:00:00	DIA	ETF	115.34	115.44	115.26	115.36	690600.0
2006-09-14 16:00:00	DIA	ETF	115.36	115.53	115.36	115.42	91800.0
2006-09-14 17:00:00	DIA	ETF	115.55	115.64	115.55	115.64	2900.0
2006-09-14 07:00:00	GLD	ETF	59.04	59.04	59.04	59.04	200.0
2006-09-14 08:00:00	GLD	ETF	59.07	59.08	58.53	58.73	99200.0
2006-09-14 09:00:00	GLD	ETF	58.7	58.72	58.04	58.14	833300.0
2006-09-14 10:00:00	GLD	ETF	58.1499	58.47	58.0	58.44	1195600.0
2006-09-14 11:00:00	GLD	ETF	58.45	58.48	58.0	58.15	745000.0
2006-09-14 12:00:00	GLD	ETF	58.16	58.24	57.7	57.86	933000.0
2006-09-14 13:00:00	GLD	ETF	57.85	57.85	57.34	57.47	1283900.0
2006-09-14 14:00:00	GLD	ETF	57.4725	57.48	57.1	57.21	1484200.0

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

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