PREVIEW / etf_1hour / 2006-08-01

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-08-01.parquet
  size:    49 KB
  rows:    1,536

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-08-01 04:00:00	SPY	ETF	127.71	127.71	127.71	127.71	1500.0
2006-08-01 06:00:00	SPY	ETF	127.67	127.67	127.67	127.67	3000.0
2006-08-01 07:00:00	SPY	ETF	127.67	127.68	127.6	127.65	42100.0
2006-08-01 08:00:00	SPY	ETF	127.65	127.89	127.44	127.45	1815600.0
2006-08-01 09:00:00	SPY	ETF	127.43	127.51	127.02	127.18	8107300.0
2006-08-01 10:00:00	SPY	ETF	127.19	127.21	126.6	126.7	15181500.0
2006-08-01 11:00:00	SPY	ETF	126.7	127.01	126.67	126.91	4693300.0
2006-08-01 12:00:00	SPY	ETF	126.91	127.05	126.82	126.98	4495100.0
2006-08-01 13:00:00	SPY	ETF	127.0	127.01	126.74	126.92	3773200.0
2006-08-01 14:00:00	SPY	ETF	126.9	127.07	126.64	126.85	6558000.0
2006-08-01 15:00:00	SPY	ETF	126.84	127.34	126.7	127.18	14751000.0
2006-08-01 16:00:00	SPY	ETF	127.18	127.28	127.12	127.25	1004800.0
2006-08-01 17:00:00	SPY	ETF	127.24	127.25	127.19	127.24	180100.0
2006-08-01 18:00:00	SPY	ETF	127.23	127.23	127.23	127.23	4700.0
2006-08-01 09:00:00	QQQ	ETF	36.79	36.8	36.65	36.73	10837100.0
2006-08-01 10:00:00	QQQ	ETF	36.73	36.76	36.38	36.38	24305400.0
2006-08-01 11:00:00	QQQ	ETF	36.38	36.54	36.38	36.51	11042100.0
2006-08-01 12:00:00	QQQ	ETF	36.51	36.53	36.42	36.5	5133700.0
2006-08-01 13:00:00	QQQ	ETF	36.49	36.5	36.33	36.41	8103000.0
2006-08-01 14:00:00	QQQ	ETF	36.41	36.47	36.26	36.34	13004300.0
2006-08-01 15:00:00	QQQ	ETF	36.35	36.55	36.28	36.49	18654100.0
2006-08-01 08:00:00	IWM	ETF	69.46	69.68	69.26	69.26	555100.0
2006-08-01 09:00:00	IWM	ETF	69.27	69.68	68.59	68.72	9333400.0
2006-08-01 10:00:00	IWM	ETF	68.71	68.74	68.18	68.35	9296000.0
2006-08-01 11:00:00	IWM	ETF	68.36	68.7	68.35	68.62	3151400.0
2006-08-01 12:00:00	IWM	ETF	68.63	68.76	68.57	68.69	2829100.0
2006-08-01 13:00:00	IWM	ETF	68.7	68.72	68.44	68.58	2627700.0
2006-08-01 14:00:00	IWM	ETF	68.58	68.67	68.28	68.44	2666900.0
2006-08-01 15:00:00	IWM	ETF	68.45	68.92	68.3	68.58	9623300.0
2006-08-01 16:00:00	IWM	ETF	68.57	68.75	68.49	68.69	4056400.0
2006-08-01 17:00:00	IWM	ETF	68.64	68.71	68.64	68.65	353400.0
2006-08-01 08:00:00	DIA	ETF	111.72	111.82	111.57	111.57	32700.0
2006-08-01 09:00:00	DIA	ETF	111.56	111.56	111.25	111.35	568900.0
2006-08-01 10:00:00	DIA	ETF	111.36	111.4	110.89	110.89	1275200.0
2006-08-01 11:00:00	DIA	ETF	110.9	111.09	110.89	111.0	436900.0
2006-08-01 12:00:00	DIA	ETF	111.0	111.13	110.94	111.03	356400.0
2006-08-01 13:00:00	DIA	ETF	111.03	111.06	110.75	110.92	491100.0
2006-08-01 14:00:00	DIA	ETF	110.93	111.05	110.75	110.91	390300.0
2006-08-01 15:00:00	DIA	ETF	110.9	111.31	110.75	111.15	1770600.0
2006-08-01 16:00:00	DIA	ETF	111.16	111.26	111.16	111.21	56100.0
2006-08-01 07:00:00	GLD	ETF	63.05	63.05	63.05	63.05	1000.0
2006-08-01 08:00:00	GLD	ETF	63.05	63.11	62.68	62.68	68000.0
2006-08-01 09:00:00	GLD	ETF	62.76	63.51	62.7	63.4101	605900.0
2006-08-01 10:00:00	GLD	ETF	63.42	63.51	63.15	63.49	823900.0
2006-08-01 11:00:00	GLD	ETF	63.49	64.2	63.47	64.19	1120100.0
2006-08-01 12:00:00	GLD	ETF	64.18	64.35	64.06	64.3	848200.0
2006-08-01 13:00:00	GLD	ETF	64.29	64.35	64.19	64.28	360100.0
2006-08-01 14:00:00	GLD	ETF	64.272	64.46	64.27	64.39	344600.0
2006-08-01 15:00:00	GLD	ETF	64.39	64.44	64.31	64.41	471200.0
2006-08-01 16:00:00	GLD	ETF	64.4	64.4	64.32	64.34	9600.0

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

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