PREVIEW / etf_1hour / 2004-07-21

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-07-21.parquet
  size:    26 KB
  rows:    704

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-07-21 08:00:00	SPY	ETF	111.79	111.84	111.73	111.76	57300.0
2004-07-21 09:00:00	SPY	ETF	111.75	111.95	111.67	111.75	7433200.0
2004-07-21 10:00:00	SPY	ETF	111.75	112.06	111.65	111.8	6338400.0
2004-07-21 11:00:00	SPY	ETF	111.79	111.81	111.45	111.45	4962100.0
2004-07-21 12:00:00	SPY	ETF	111.45	111.49	111.23	111.37	5744700.0
2004-07-21 13:00:00	SPY	ETF	111.38	111.43	110.93	111.0	4640800.0
2004-07-21 14:00:00	SPY	ETF	110.98	111.01	110.65	110.67	6140500.0
2004-07-21 15:00:00	SPY	ETF	110.67	110.7	109.76	109.79	11091200.0
2004-07-21 16:00:00	SPY	ETF	109.81	109.94	109.4	109.5	2551200.0
2004-07-21 17:00:00	SPY	ETF	109.5	109.59	109.45	109.5	696800.0
2004-07-21 18:00:00	SPY	ETF	109.5	109.52	109.46	109.51	15400.0
2004-07-21 19:00:00	SPY	ETF	109.55	109.55	109.53	109.53	700.0
2004-07-21 08:00:00	QQQ	ETF	35.68	35.68	35.53	35.55	295600.0
2004-07-21 09:00:00	QQQ	ETF	35.57	35.7	35.35	35.4	19962400.0
2004-07-21 10:00:00	QQQ	ETF	35.394	35.58	35.32	35.38	13673300.0
2004-07-21 11:00:00	QQQ	ETF	35.378	35.39	35.206	35.206	14327000.0
2004-07-21 12:00:00	QQQ	ETF	35.22	35.22	35.02	35.096	19808200.0
2004-07-21 13:00:00	QQQ	ETF	35.09	35.11	34.81	34.86	15894100.0
2004-07-21 14:00:00	QQQ	ETF	34.86	34.93	34.75	34.779	11926900.0
2004-07-21 15:00:00	QQQ	ETF	34.78	34.79	34.5	34.53	29854400.0
2004-07-21 16:00:00	QQQ	ETF	34.52	34.54	34.22	34.35	7489600.0
2004-07-21 17:00:00	QQQ	ETF	34.35	34.39	34.34	34.38	246500.0
2004-07-21 18:00:00	QQQ	ETF	34.37	34.4	34.36	34.4	37800.0
2004-07-21 19:00:00	QQQ	ETF	34.38	34.41	34.38	34.38	9300.0
2004-07-21 08:00:00	IWM	ETF	56.555	56.555	56.555	56.555	1000.0
2004-07-21 09:00:00	IWM	ETF	56.5	56.55	56.11	56.135	1972600.0
2004-07-21 10:00:00	IWM	ETF	56.125	56.35	56.025	56.165	2594600.0
2004-07-21 11:00:00	IWM	ETF	56.15	56.15	55.675	55.675	2621800.0
2004-07-21 12:00:00	IWM	ETF	55.665	55.665	55.39	55.495	1216400.0
2004-07-21 13:00:00	IWM	ETF	55.485	55.515	55.15	55.225	1199200.0
2004-07-21 14:00:00	IWM	ETF	55.21	55.21	55.01	55.06	2637400.0
2004-07-21 15:00:00	IWM	ETF	55.035	55.075	54.595	54.6	4375400.0
2004-07-21 16:00:00	IWM	ETF	54.59	54.67	54.5	54.5	742800.0
2004-07-21 17:00:00	IWM	ETF	54.575	54.575	54.515	54.545	1800.0
2004-07-21 18:00:00	IWM	ETF	54.545	54.545	54.545	54.545	200.0
2004-07-21 08:00:00	DIA	ETF	102.08	102.13	102.08	102.13	300.0
2004-07-21 09:00:00	DIA	ETF	102.11	102.35	102.09	102.25	781300.0
2004-07-21 10:00:00	DIA	ETF	102.23	102.55	102.16	102.44	847800.0
2004-07-21 11:00:00	DIA	ETF	102.41	102.42	102.14	102.2	1342400.0
2004-07-21 12:00:00	DIA	ETF	102.2	102.22	102.01	102.14	756400.0
2004-07-21 13:00:00	DIA	ETF	102.13	102.18	101.74	101.8	1388200.0
2004-07-21 14:00:00	DIA	ETF	101.79	101.85	101.51	101.58	800600.0
2004-07-21 15:00:00	DIA	ETF	101.56	101.58	100.57	100.63	2731500.0
2004-07-21 16:00:00	DIA	ETF	100.62	100.68	100.35	100.42	384100.0
2004-07-21 17:00:00	DIA	ETF	100.43	100.49	100.43	100.49	3500.0
2004-07-21 18:00:00	DIA	ETF	100.48	100.5	100.48	100.5	1600.0
2004-07-21 09:00:00	TLT	ETF	84.41	84.54	84.35	84.54	69400.0
2004-07-21 10:00:00	TLT	ETF	84.54	84.56	84.19	84.25	159200.0
2004-07-21 11:00:00	TLT	ETF	84.25	84.33	84.21	84.32	58900.0
2004-07-21 12:00:00	TLT	ETF	84.36	84.4	84.34	84.37	8100.0

> showing 50 of 704 rows — these rows as CSV

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