PREVIEW / etf_1hour / 2006-08-02

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-08-02.parquet
  size:    50 KB
  rows:    1,569

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-02 04:00:00	SPY	ETF	127.47	127.47	127.47	127.47	500.0
2006-08-02 07:00:00	SPY	ETF	127.6	127.65	127.47	127.56	141700.0
2006-08-02 08:00:00	SPY	ETF	127.53	127.64	127.22	127.47	280500.0
2006-08-02 09:00:00	SPY	ETF	127.47	127.91	127.44	127.77	7393000.0
2006-08-02 10:00:00	SPY	ETF	127.77	127.85	127.55	127.68	6846000.0
2006-08-02 11:00:00	SPY	ETF	127.69	128.39	127.68	128.36	12850900.0
2006-08-02 12:00:00	SPY	ETF	128.36	128.46	128.18	128.27	5676800.0
2006-08-02 13:00:00	SPY	ETF	128.28	128.32	128.14	128.25	3345600.0
2006-08-02 14:00:00	SPY	ETF	128.25	128.43	127.9	127.93	7892900.0
2006-08-02 15:00:00	SPY	ETF	127.92	128.02	127.65	127.91	12019700.0
2006-08-02 16:00:00	SPY	ETF	127.9	128.1	127.84	128.01	871100.0
2006-08-02 17:00:00	SPY	ETF	128.01	128.08	127.0076	128.0	5563300.0
2006-08-02 18:00:00	SPY	ETF	128.02	128.07	128.0	128.02	18700.0
2006-08-02 19:00:00	SPY	ETF	128.02	128.03	128.02	128.03	3300.0
2006-08-02 09:00:00	QQQ	ETF	36.61	36.87	36.61	36.79	14303800.0
2006-08-02 10:00:00	QQQ	ETF	36.79	36.82	36.66	36.7	13128100.0
2006-08-02 11:00:00	QQQ	ETF	36.71	37.03	36.7	37.0	11992400.0
2006-08-02 12:00:00	QQQ	ETF	37.0	37.13	36.97	37.07	9425300.0
2006-08-02 13:00:00	QQQ	ETF	37.07	37.08	37.01	37.06	4786400.0
2006-08-02 14:00:00	QQQ	ETF	37.05	37.12	36.89	36.92	14645900.0
2006-08-02 15:00:00	QQQ	ETF	36.92	36.96	36.8	36.89	13740900.0
2006-08-02 07:00:00	IWM	ETF	68.95	68.95	68.95	68.95	1000.0
2006-08-02 08:00:00	IWM	ETF	68.95	69.0	68.59	68.9	60900.0
2006-08-02 09:00:00	IWM	ETF	68.9	69.45	68.9	69.2	9595900.0
2006-08-02 10:00:00	IWM	ETF	69.2	69.27	68.9	69.08	4793900.0
2006-08-02 11:00:00	IWM	ETF	69.09	69.55	68.64	69.51	7593200.0
2006-08-02 12:00:00	IWM	ETF	69.5	69.6	69.42	69.51	4896700.0
2006-08-02 13:00:00	IWM	ETF	69.51	69.57	69.43	69.55	2828000.0
2006-08-02 14:00:00	IWM	ETF	69.55	69.72	69.23	69.25	6966000.0
2006-08-02 15:00:00	IWM	ETF	69.23	69.36	68.9	69.3	7901000.0
2006-08-02 16:00:00	IWM	ETF	69.28	69.5	69.12	69.44	1938200.0
2006-08-02 17:00:00	IWM	ETF	69.5	69.51	69.5	69.5	3000.0
2006-08-02 08:00:00	DIA	ETF	111.48	111.48	111.38	111.4	2900.0
2006-08-02 09:00:00	DIA	ETF	111.39	111.74	111.39	111.6	628900.0
2006-08-02 10:00:00	DIA	ETF	111.6	111.68	111.44	111.6	459000.0
2006-08-02 11:00:00	DIA	ETF	111.61	112.16	111.6	112.11	768100.0
2006-08-02 12:00:00	DIA	ETF	112.12	112.2	111.98	112.04	608000.0
2006-08-02 13:00:00	DIA	ETF	112.05	112.13	111.96	112.05	217900.0
2006-08-02 14:00:00	DIA	ETF	112.06	112.18	111.83	111.88	504900.0
2006-08-02 15:00:00	DIA	ETF	111.85	112.0	111.73	111.87	663800.0
2006-08-02 16:00:00	DIA	ETF	111.86	112.04	111.86	111.9	48300.0
2006-08-02 18:00:00	DIA	ETF	112.0	112.02	112.0	112.02	200.0
2006-08-02 08:00:00	GLD	ETF	64.43	64.77	64.29	64.61	69500.0
2006-08-02 09:00:00	GLD	ETF	64.61	65.22	64.56	65.0499	1005800.0
2006-08-02 10:00:00	GLD	ETF	65.04	65.17	64.8	65.06	968700.0
2006-08-02 11:00:00	GLD	ETF	65.06	65.2	64.51	64.68	866400.0
2006-08-02 12:00:00	GLD	ETF	64.68	64.79	64.4	64.55	557000.0
2006-08-02 13:00:00	GLD	ETF	64.55	64.93	64.53	64.8	707200.0
2006-08-02 14:00:00	GLD	ETF	64.8	64.87	64.67	64.71	426100.0
2006-08-02 15:00:00	GLD	ETF	64.7	64.8	64.65	64.67	438300.0

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

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