PREVIEW / etf_1hour / 2004-06-28

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-06-28.parquet
  size:    25 KB
  rows:    698

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-06-28 08:00:00	SPY	ETF	114.78	114.78	114.46	114.59	230600.0
2004-06-28 09:00:00	SPY	ETF	114.6	114.62	114.29	114.39	5523600.0
2004-06-28 10:00:00	SPY	ETF	114.38	114.61	114.31	114.4	5948700.0
2004-06-28 11:00:00	SPY	ETF	114.41	114.49	114.25	114.44	2713900.0
2004-06-28 12:00:00	SPY	ETF	114.44	114.59	114.36	114.41	1665600.0
2004-06-28 13:00:00	SPY	ETF	114.43	114.57	114.25	114.29	1983900.0
2004-06-28 14:00:00	SPY	ETF	114.29	114.37	113.5	113.66	12080800.0
2004-06-28 15:00:00	SPY	ETF	113.65	113.8	113.43	113.68	6632200.0
2004-06-28 16:00:00	SPY	ETF	113.68	113.72	113.31	113.32	1974000.0
2004-06-28 17:00:00	SPY	ETF	113.32	113.32	113.12	113.18	450900.0
2004-06-28 18:00:00	SPY	ETF	113.17	113.29	113.12	113.29	69000.0
2004-06-28 19:00:00	SPY	ETF	113.29	113.31	113.29	113.3	3700.0
2004-06-28 08:00:00	QQQ	ETF	37.55	37.62	37.48	37.55	630100.0
2004-06-28 09:00:00	QQQ	ETF	37.55	37.55	37.37	37.41	12300500.0
2004-06-28 10:00:00	QQQ	ETF	37.41	37.52	37.35	37.444	13954300.0
2004-06-28 11:00:00	QQQ	ETF	37.44	37.46	37.32	37.432	7376600.0
2004-06-28 12:00:00	QQQ	ETF	37.43	37.5	37.4	37.42	5286300.0
2004-06-28 13:00:00	QQQ	ETF	37.42	37.519	37.36	37.37	6444900.0
2004-06-28 14:00:00	QQQ	ETF	37.378	37.39	37.01	37.034	23076200.0
2004-06-28 15:00:00	QQQ	ETF	37.04	37.13	36.9	37.11	21378300.0
2004-06-28 16:00:00	QQQ	ETF	37.1	37.13	37.0	37.0	2369200.0
2004-06-28 17:00:00	QQQ	ETF	37.0	37.02	36.84	36.93	227600.0
2004-06-28 18:00:00	QQQ	ETF	36.92	36.96	36.92	36.96	62100.0
2004-06-28 19:00:00	QQQ	ETF	36.94	36.94	36.92	36.92	3700.0
2004-06-28 08:00:00	IWM	ETF	58.56	58.56	58.485	58.485	16400.0
2004-06-28 09:00:00	IWM	ETF	58.535	58.555	58.3	58.38	1850200.0
2004-06-28 10:00:00	IWM	ETF	58.38	58.61	58.34	58.52	1203600.0
2004-06-28 11:00:00	IWM	ETF	58.54	58.59	58.415	58.575	732000.0
2004-06-28 12:00:00	IWM	ETF	58.55	58.635	58.55	58.605	1038000.0
2004-06-28 13:00:00	IWM	ETF	58.6	58.705	58.51	58.51	988600.0
2004-06-28 14:00:00	IWM	ETF	58.5	58.57	58.04	58.125	1439600.0
2004-06-28 15:00:00	IWM	ETF	58.125	58.305	58.075	58.25	2252600.0
2004-06-28 16:00:00	IWM	ETF	58.25	58.27	58.18	58.18	5731200.0
2004-06-28 17:00:00	IWM	ETF	58.045	58.05	58.04	58.04	6000.0
2004-06-28 18:00:00	IWM	ETF	58.025	58.045	58.025	58.045	4400.0
2004-06-28 08:00:00	DIA	ETF	104.81	104.82	104.6	104.62	15700.0
2004-06-28 09:00:00	DIA	ETF	104.63	104.68	104.37	104.53	1035400.0
2004-06-28 10:00:00	DIA	ETF	104.56	104.79	104.5	104.63	912400.0
2004-06-28 11:00:00	DIA	ETF	104.62	104.68	104.5	104.67	495800.0
2004-06-28 12:00:00	DIA	ETF	104.65	104.77	104.62	104.64	125200.0
2004-06-28 13:00:00	DIA	ETF	104.65	104.74	104.42	104.44	271500.0
2004-06-28 14:00:00	DIA	ETF	104.44	104.47	103.67	103.8	1505300.0
2004-06-28 15:00:00	DIA	ETF	103.8	103.8	103.5	103.71	1489900.0
2004-06-28 16:00:00	DIA	ETF	103.72	103.75	103.52	103.52	586200.0
2004-06-28 17:00:00	DIA	ETF	103.45	103.51	103.4	103.4	1600.0
2004-06-28 18:00:00	DIA	ETF	103.44	103.44	103.44	103.44	1000.0
2004-06-28 09:00:00	TLT	ETF	82.78	82.86	82.78	82.85	25600.0
2004-06-28 10:00:00	TLT	ETF	82.87	82.87	82.55	82.65	59500.0
2004-06-28 11:00:00	TLT	ETF	82.6	82.64	82.53	82.6	12600.0
2004-06-28 12:00:00	TLT	ETF	82.62	82.68	82.56	82.56	20600.0

> showing 50 of 698 rows — these rows as CSV

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