PREVIEW / etf_1hour / 2003-12-22

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-12-22.parquet
  size:    19 KB
  rows:    511

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
2003-12-22 08:00:00	SPY	ETF	108.67	108.78	108.67	108.74	31400.0
2003-12-22 09:00:00	SPY	ETF	108.74	109.4	108.73	109.29	4821900.0
2003-12-22 10:00:00	SPY	ETF	109.29	109.35	109.08	109.19	5550500.0
2003-12-22 11:00:00	SPY	ETF	109.19	109.23	108.87	109.03	3328300.0
2003-12-22 12:00:00	SPY	ETF	109.05	109.09	108.88	109.01	3027700.0
2003-12-22 13:00:00	SPY	ETF	109.01	109.15	108.93	109.15	1332400.0
2003-12-22 14:00:00	SPY	ETF	109.15	109.27	109.02	109.13	2492400.0
2003-12-22 15:00:00	SPY	ETF	109.17	109.47	109.11	109.46	2999500.0
2003-12-22 16:00:00	SPY	ETF	109.47	109.68	109.43	109.62	1004300.0
2003-12-22 17:00:00	SPY	ETF	109.64	109.66	109.421	109.55	217300.0
2003-12-22 18:00:00	SPY	ETF	109.54	109.56	109.54	109.56	1800.0
2003-12-22 19:00:00	SPY	ETF	109.59	109.65	109.56	109.6	4000.0
2003-12-22 08:00:00	QQQ	ETF	35.25	35.35	35.25	35.35	64400.0
2003-12-22 09:00:00	QQQ	ETF	35.35	35.68	35.33	35.58	12512200.0
2003-12-22 10:00:00	QQQ	ETF	35.588	35.64	35.41	35.487	12633600.0
2003-12-22 11:00:00	QQQ	ETF	35.486	35.51	35.32	35.44	6086700.0
2003-12-22 12:00:00	QQQ	ETF	35.44	35.46	35.29	35.377	5295600.0
2003-12-22 13:00:00	QQQ	ETF	35.373	35.48	35.35	35.47	4157000.0
2003-12-22 14:00:00	QQQ	ETF	35.48	35.5	35.33	35.43	4464600.0
2003-12-22 15:00:00	QQQ	ETF	35.42	35.59	35.4	35.58	8242500.0
2003-12-22 16:00:00	QQQ	ETF	35.576	35.607	35.52	35.6	1764000.0
2003-12-22 17:00:00	QQQ	ETF	35.58	35.61	35.57	35.58	69000.0
2003-12-22 18:00:00	QQQ	ETF	35.58	35.6	35.57	35.6	15300.0
2003-12-22 19:00:00	QQQ	ETF	35.59	35.6	35.59	35.6	4500.0
2003-12-22 20:00:00	QQQ	ETF	35.61	35.61	35.61	35.61	1200.0
2003-12-22 08:00:00	IWM	ETF	54.035	54.035	54.035	54.035	7200.0
2003-12-22 09:00:00	IWM	ETF	54.125	54.6	54.03	54.51	1028200.0
2003-12-22 10:00:00	IWM	ETF	54.545	54.575	54.33	54.36	970000.0
2003-12-22 11:00:00	IWM	ETF	54.365	54.415	54.18	54.25	496800.0
2003-12-22 12:00:00	IWM	ETF	54.25	54.275	54.155	54.235	242800.0
2003-12-22 13:00:00	IWM	ETF	54.245	54.355	54.205	54.325	305200.0
2003-12-22 14:00:00	IWM	ETF	54.325	54.425	54.26	54.35	420800.0
2003-12-22 15:00:00	IWM	ETF	54.362	54.715	54.34	54.715	373200.0
2003-12-22 16:00:00	IWM	ETF	54.73	54.838	54.675	54.8175	510400.0
2003-12-22 08:00:00	DIA	ETF	102.52	102.58	102.52	102.58	5700.0
2003-12-22 09:00:00	DIA	ETF	102.55	103.14	102.55	103.0	1176900.0
2003-12-22 10:00:00	DIA	ETF	103.02	103.1	102.94	103.02	919600.0
2003-12-22 11:00:00	DIA	ETF	103.05	103.07	102.8	102.92	482500.0
2003-12-22 12:00:00	DIA	ETF	102.91	102.96	102.8	102.9	267500.0
2003-12-22 13:00:00	DIA	ETF	102.9	103.08	102.84	103.07	682800.0
2003-12-22 14:00:00	DIA	ETF	103.03	103.24	103.03	103.19	668600.0
2003-12-22 15:00:00	DIA	ETF	103.18	103.49	103.17	103.43	1346700.0
2003-12-22 16:00:00	DIA	ETF	103.43	103.64	103.42	103.626	266600.0
2003-12-22 17:00:00	DIA	ETF	103.61	103.69	103.59	103.62	4300.0
2003-12-22 09:00:00	TLT	ETF	87.12	87.34	87.12	87.26	262200.0
2003-12-22 10:00:00	TLT	ETF	87.29	87.34	86.91	86.95	52100.0
2003-12-22 11:00:00	TLT	ETF	86.98	87.01	86.77	86.77	78000.0
2003-12-22 12:00:00	TLT	ETF	86.76	86.84	86.66	86.77	24900.0
2003-12-22 13:00:00	TLT	ETF	86.76	86.87	86.66	86.78	24100.0
2003-12-22 14:00:00	TLT	ETF	86.75	86.78	86.65	86.71	18000.0

> showing 50 of 511 rows — these rows as CSV

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