PREVIEW / etf_1hour / 2006-08-04

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-08-04.parquet
  size:    51 KB
  rows:    1,595

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-04 05:00:00	SPY	ETF	128.24	128.24	128.24	128.24	1500.0
2006-08-04 06:00:00	SPY	ETF	128.27	128.27	128.27	128.27	1000.0
2006-08-04 07:00:00	SPY	ETF	128.37	128.37	128.28	128.34	136000.0
2006-08-04 08:00:00	SPY	ETF	128.37	129.44	128.24	129.27	13525800.0
2006-08-04 09:00:00	SPY	ETF	129.27	129.43	128.77	128.95	15764400.0
2006-08-04 10:00:00	SPY	ETF	128.94	129.11	128.66	128.87	13020900.0
2006-08-04 11:00:00	SPY	ETF	128.87	129.03	128.48	128.51	6870000.0
2006-08-04 12:00:00	SPY	ETF	128.51	128.65	128.18	128.3	12572700.0
2006-08-04 13:00:00	SPY	ETF	128.31	128.39	127.65	127.8	10663900.0
2006-08-04 14:00:00	SPY	ETF	127.83	128.05	127.5	127.57	7218000.0
2006-08-04 15:00:00	SPY	ETF	127.57	128.13	127.48	128.08	10606700.0
2006-08-04 16:00:00	SPY	ETF	128.07	128.3	128.0	128.22	2105500.0
2006-08-04 17:00:00	SPY	ETF	128.2	128.23	128.11	128.2	12900.0
2006-08-04 18:00:00	SPY	ETF	128.2	128.23	128.2	128.21	900.0
2006-08-04 19:00:00	SPY	ETF	128.21	128.21	128.21	128.21	1500.0
2006-08-04 09:00:00	QQQ	ETF	37.42	37.63	37.36	37.47	15928100.0
2006-08-04 10:00:00	QQQ	ETF	37.47	37.5	37.28	37.39	15912200.0
2006-08-04 11:00:00	QQQ	ETF	37.39	37.43	37.18	37.19	9732100.0
2006-08-04 12:00:00	QQQ	ETF	37.19	37.22	36.89	36.94	15483600.0
2006-08-04 13:00:00	QQQ	ETF	36.95	37.5	36.72	36.81	19273000.0
2006-08-04 14:00:00	QQQ	ETF	36.81	36.92	36.66	36.69	13132300.0
2006-08-04 15:00:00	QQQ	ETF	36.69	36.97	36.62	36.96	18334600.0
2006-08-04 07:00:00	IWM	ETF	70.28	70.28	70.28	70.28	1000.0
2006-08-04 08:00:00	IWM	ETF	70.3	71.32	70.23	71.23	4650300.0
2006-08-04 09:00:00	IWM	ETF	71.23	71.31	70.87	71.04	11908400.0
2006-08-04 10:00:00	IWM	ETF	71.04	71.19	70.49	70.54	13024500.0
2006-08-04 11:00:00	IWM	ETF	70.54	70.64	70.14	70.15	6676600.0
2006-08-04 12:00:00	IWM	ETF	70.15	70.21	69.6	69.67	7747500.0
2006-08-04 13:00:00	IWM	ETF	69.67	69.82	69.2	69.33	9365100.0
2006-08-04 14:00:00	IWM	ETF	69.31	69.49	69.01	69.08	10027200.0
2006-08-04 15:00:00	IWM	ETF	69.08	69.74	68.97	69.69	9693700.0
2006-08-04 16:00:00	IWM	ETF	69.68	70.09	69.5	70.0468	1470200.0
2006-08-04 17:00:00	IWM	ETF	69.5	69.62	69.5	69.62	1100.0
2006-08-04 07:00:00	DIA	ETF	112.56	112.56	112.52	112.52	3000.0
2006-08-04 08:00:00	DIA	ETF	112.57	113.4	112.56	113.24	252000.0
2006-08-04 09:00:00	DIA	ETF	113.28	113.37	112.88	112.97	916700.0
2006-08-04 10:00:00	DIA	ETF	112.97	113.26	112.9	113.08	870500.0
2006-08-04 11:00:00	DIA	ETF	113.09	113.12	112.7	112.7	410400.0
2006-08-04 12:00:00	DIA	ETF	112.7	112.84	112.57	112.7	1432900.0
2006-08-04 13:00:00	DIA	ETF	112.7	112.75	112.04	112.15	1703500.0
2006-08-04 14:00:00	DIA	ETF	112.13	112.31	111.82	111.88	985500.0
2006-08-04 15:00:00	DIA	ETF	111.871	112.44	111.82	112.38	1060800.0
2006-08-04 16:00:00	DIA	ETF	112.37	112.55	112.33	112.55	6400.0
2006-08-04 17:00:00	DIA	ETF	112.48	112.48	112.48	112.48	1000.0
2006-08-04 08:00:00	GLD	ETF	64.19	65.02	64.19	64.98	559500.0
2006-08-04 09:00:00	GLD	ETF	64.97	64.99	64.68	64.9	802400.0
2006-08-04 10:00:00	GLD	ETF	64.895	64.94	64.35	64.78	935700.0
2006-08-04 11:00:00	GLD	ETF	64.78	64.7801	64.25	64.55	724500.0
2006-08-04 12:00:00	GLD	ETF	64.55	64.58	64.3306	64.47	250600.0
2006-08-04 13:00:00	GLD	ETF	64.47	64.7	64.01	64.06	517500.0

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

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