PREVIEW / etf_1hour / 2006-06-05

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-06-05.parquet
  size:    45 KB
  rows:    1,386

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-06-05 06:00:00	SPY	ETF	128.8	128.8	128.74	128.74	1600.0
2006-06-05 07:00:00	SPY	ETF	128.84	128.87	128.71	128.74	53400.0
2006-06-05 08:00:00	SPY	ETF	128.87	129.0	128.58	128.8	1213500.0
2006-06-05 09:00:00	SPY	ETF	128.79	128.86	128.47	128.64	10588400.0
2006-06-05 10:00:00	SPY	ETF	128.64	128.79	128.45	128.68	5896600.0
2006-06-05 11:00:00	SPY	ETF	128.67	128.79	128.52	128.56	4931400.0
2006-06-05 12:00:00	SPY	ETF	128.57	128.61	128.37	128.49	5008900.0
2006-06-05 13:00:00	SPY	ETF	128.48	128.56	128.21	128.26	6082000.0
2006-06-05 14:00:00	SPY	ETF	128.26	128.32	127.33	127.6	22402600.0
2006-06-05 15:00:00	SPY	ETF	127.57	127.86	126.77	126.91	22813700.0
2006-06-05 16:00:00	SPY	ETF	126.91	127.3	126.68	127.18	3560300.0
2006-06-05 17:00:00	SPY	ETF	127.18	127.34	127.18	127.2	32700.0
2006-06-05 18:00:00	SPY	ETF	127.18	127.2	127.13	127.13	13700.0
2006-06-05 19:00:00	SPY	ETF	127.21	127.24	127.21	127.23	25300.0
2006-06-05 09:00:00	QQQ	ETF	39.55	39.56	39.34	39.4	10554500.0
2006-06-05 10:00:00	QQQ	ETF	39.41	39.54	39.35	39.49	9881700.0
2006-06-05 11:00:00	QQQ	ETF	39.48	39.55	39.42	39.45	7569500.0
2006-06-05 12:00:00	QQQ	ETF	39.45	39.45	39.28	39.33	13899700.0
2006-06-05 13:00:00	QQQ	ETF	39.33	39.38	39.23	39.25	7634600.0
2006-06-05 14:00:00	QQQ	ETF	39.25	39.25	38.9	39.02	25139100.0
2006-06-05 15:00:00	QQQ	ETF	39.01	39.02	38.78	38.79	22644500.0
2006-06-05 08:00:00	IWM	ETF	73.05	73.23	72.95	73.02	754000.0
2006-06-05 09:00:00	IWM	ETF	73.03	73.15	72.74	72.89	4160300.0
2006-06-05 10:00:00	IWM	ETF	72.9	73.0	72.71	72.95	3567600.0
2006-06-05 11:00:00	IWM	ETF	72.96	73.08	72.61	72.66	4984300.0
2006-06-05 12:00:00	IWM	ETF	72.66	72.66	72.26	72.29	4922300.0
2006-06-05 13:00:00	IWM	ETF	72.3	72.38	71.91	71.94	4644600.0
2006-06-05 14:00:00	IWM	ETF	71.94	71.96	71.2	71.47	17012800.0
2006-06-05 15:00:00	IWM	ETF	71.5	71.5	70.86	70.88	17551500.0
2006-06-05 16:00:00	IWM	ETF	70.88	71.23	70.88	71.1	2692700.0
2006-06-05 17:00:00	IWM	ETF	71.1	71.24	71.0	71.24	2550400.0
2006-06-05 18:00:00	IWM	ETF	71.18	71.18	71.15	71.15	1000.0
2006-06-05 19:00:00	IWM	ETF	71.15	71.15	71.15	71.15	500.0
2006-06-05 07:00:00	DIA	ETF	112.23	112.23	112.12	112.12	1200.0
2006-06-05 08:00:00	DIA	ETF	112.14	112.21	112.05	112.1	9000.0
2006-06-05 09:00:00	DIA	ETF	112.13	112.22	111.69	111.8076	569200.0
2006-06-05 10:00:00	DIA	ETF	111.79	111.88	111.55	111.77	781600.0
2006-06-05 11:00:00	DIA	ETF	111.77	111.93	111.68	111.68	563700.0
2006-06-05 12:00:00	DIA	ETF	111.68	111.73	111.57	111.66	437100.0
2006-06-05 13:00:00	DIA	ETF	111.67	111.72	111.43	111.48	464600.0
2006-06-05 14:00:00	DIA	ETF	111.46	111.48	110.82	111.0	2973000.0
2006-06-05 15:00:00	DIA	ETF	111.0	111.48	110.4	110.52	2331100.0
2006-06-05 16:00:00	DIA	ETF	110.54	110.83	110.52	110.83	285900.0
2006-06-05 17:00:00	DIA	ETF	110.75	110.75	110.69	110.69	1487100.0
2006-06-05 07:00:00	GLD	ETF	65.56	65.56	64.08	64.08	33300.0
2006-06-05 08:00:00	GLD	ETF	64.09	65.56	63.65	63.65	316700.0
2006-06-05 09:00:00	GLD	ETF	63.64	64.03	63.64	63.89	1129200.0
2006-06-05 10:00:00	GLD	ETF	63.9	63.92	63.7	63.77	679400.0
2006-06-05 11:00:00	GLD	ETF	63.77	64.09	63.7	64.08	387800.0
2006-06-05 12:00:00	GLD	ETF	64.08	64.14	63.98	64.11	385000.0

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

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