PREVIEW / etf_1hour / 2004-08-16

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-08-16.parquet
  size:    24 KB
  rows:    652

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
2004-08-16 08:00:00	SPY	ETF	107.29	107.31	107.15	107.26	64800.0
2004-08-16 09:00:00	SPY	ETF	107.22	107.77	107.1	107.65	5947400.0
2004-08-16 10:00:00	SPY	ETF	107.65	108.25	107.59	108.15	7686700.0
2004-08-16 11:00:00	SPY	ETF	108.16	108.43	108.14	108.19	4432400.0
2004-08-16 12:00:00	SPY	ETF	108.2	108.31	108.11	108.28	4694800.0
2004-08-16 13:00:00	SPY	ETF	108.27	108.45	108.21	108.34	4411000.0
2004-08-16 14:00:00	SPY	ETF	108.36	108.64	108.32	108.51	5093500.0
2004-08-16 15:00:00	SPY	ETF	108.52	108.56	108.28	108.53	7648400.0
2004-08-16 16:00:00	SPY	ETF	108.54	108.55	108.2	108.27	2548800.0
2004-08-16 17:00:00	SPY	ETF	108.27	108.28	108.23	108.23	10700.0
2004-08-16 18:00:00	SPY	ETF	108.23	108.32	108.23	108.32	3900.0
2004-08-16 19:00:00	SPY	ETF	108.31	108.31	108.31	108.31	900.0
2004-08-16 08:00:00	QQQ	ETF	32.67	32.7	32.65	32.69	93000.0
2004-08-16 09:00:00	QQQ	ETF	32.68	32.87	32.586	32.809	12820000.0
2004-08-16 10:00:00	QQQ	ETF	32.83	32.99	32.777	32.94	13994000.0
2004-08-16 11:00:00	QQQ	ETF	32.93	33.09	32.91	32.98	9848500.0
2004-08-16 12:00:00	QQQ	ETF	32.98	33.02	32.93	33.02	4994000.0
2004-08-16 13:00:00	QQQ	ETF	33.013	33.05	32.94	33.0206	5350800.0
2004-08-16 14:00:00	QQQ	ETF	33.02	33.19	33.02	33.12	11564600.0
2004-08-16 15:00:00	QQQ	ETF	33.13	33.15	32.97	32.98	12432900.0
2004-08-16 16:00:00	QQQ	ETF	32.983	33.0	32.801	32.85	3111500.0
2004-08-16 17:00:00	QQQ	ETF	32.83	32.85	32.83	32.84	92500.0
2004-08-16 18:00:00	QQQ	ETF	32.84	32.87	32.84	32.87	25100.0
2004-08-16 19:00:00	QQQ	ETF	32.87	32.88	32.83	32.83	50900.0
2004-08-16 08:00:00	IWM	ETF	51.725	51.725	51.725	51.725	1000.0
2004-08-16 09:00:00	IWM	ETF	51.75	52.34	51.715	52.28	2702200.0
2004-08-16 10:00:00	IWM	ETF	52.27	52.65	52.25	52.575	2954400.0
2004-08-16 11:00:00	IWM	ETF	52.565	52.66	52.45	52.46	920200.0
2004-08-16 12:00:00	IWM	ETF	52.47	52.52	52.435	52.48	753800.0
2004-08-16 13:00:00	IWM	ETF	52.475	52.545	52.46	52.495	364800.0
2004-08-16 14:00:00	IWM	ETF	52.515	52.685	52.51	52.62	1116800.0
2004-08-16 15:00:00	IWM	ETF	52.625	52.685	52.35	52.635	2442000.0
2004-08-16 16:00:00	IWM	ETF	52.64	52.675	52.505	52.54	200000.0
2004-08-16 17:00:00	IWM	ETF	52.56	52.56	52.56	52.56	1000.0
2004-08-16 19:00:00	IWM	ETF	52.53	52.53	52.53	52.53	800.0
2004-08-16 08:00:00	DIA	ETF	98.85	98.85	98.7	98.78	3700.0
2004-08-16 09:00:00	DIA	ETF	98.75	99.18	98.66	99.09	1252200.0
2004-08-16 10:00:00	DIA	ETF	99.09	99.66	99.05	99.61	848700.0
2004-08-16 11:00:00	DIA	ETF	99.61	99.85	99.58	99.65	493800.0
2004-08-16 12:00:00	DIA	ETF	99.64	99.74	99.56	99.7	517000.0
2004-08-16 13:00:00	DIA	ETF	99.71	99.82	99.64	99.76	394700.0
2004-08-16 14:00:00	DIA	ETF	99.76	100.03	99.73	99.88	560900.0
2004-08-16 15:00:00	DIA	ETF	99.87	99.91	99.65	99.89	1021800.0
2004-08-16 16:00:00	DIA	ETF	99.9	99.92	99.7	99.73	150100.0
2004-08-16 19:00:00	DIA	ETF	99.9	99.9	99.7	99.7	500.0
2004-08-16 08:00:00	TLT	ETF	86.55	86.55	86.55	86.55	20000.0
2004-08-16 09:00:00	TLT	ETF	86.47	86.53	86.34	86.34	17300.0
2004-08-16 10:00:00	TLT	ETF	86.32	86.35	86.26	86.33	24300.0
2004-08-16 11:00:00	TLT	ETF	86.3	86.3	86.0215	86.03	158500.0
2004-08-16 12:00:00	TLT	ETF	86.12	86.18	86.06	86.16	24300.0

> showing 50 of 652 rows — these rows as CSV

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