PREVIEW / etf_1hour / 2005-04-15

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-04-15.parquet
  size:    32 KB
  rows:    900

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
2005-04-15 04:00:00	SPY	ETF	115.58	115.58	115.51	115.51	3000.0
2005-04-15 06:00:00	SPY	ETF	115.63	115.63	115.53	115.53	30000.0
2005-04-15 07:00:00	SPY	ETF	115.53	115.57	115.41	115.54	223500.0
2005-04-15 08:00:00	SPY	ETF	115.53	115.95	115.53	115.86	896300.0
2005-04-15 09:00:00	SPY	ETF	115.86	116.14	115.5	116.0	17916200.0
2005-04-15 10:00:00	SPY	ETF	115.99	116.2	115.65	116.12	15885300.0
2005-04-15 11:00:00	SPY	ETF	116.12	116.13	115.4	115.6	13467200.0
2005-04-15 12:00:00	SPY	ETF	115.6	115.78	114.93	114.97	18261000.0
2005-04-15 13:00:00	SPY	ETF	114.96	115.58	114.92	115.24	17070700.0
2005-04-15 14:00:00	SPY	ETF	115.24	115.62	114.9	115.18	12826000.0
2005-04-15 15:00:00	SPY	ETF	115.18	115.91	114.16	114.27	26215900.0
2005-04-15 16:00:00	SPY	ETF	114.25	114.48	113.97	114.0	4020600.0
2005-04-15 17:00:00	SPY	ETF	114.04	114.28	113.96	114.15	684200.0
2005-04-15 18:00:00	SPY	ETF	114.15	114.2	114.01	114.19	63900.0
2005-04-15 19:00:00	SPY	ETF	114.18	114.2	114.15	114.19	7500.0
2005-04-15 09:00:00	QQQ	ETF	35.24	36.15	35.12	35.28	27786300.0
2005-04-15 10:00:00	QQQ	ETF	35.28	35.35	35.14	35.27	20809500.0
2005-04-15 11:00:00	QQQ	ETF	35.27	35.28	35.04	35.1	14968700.0
2005-04-15 12:00:00	QQQ	ETF	35.11	35.17	34.87	34.89	19661500.0
2005-04-15 13:00:00	QQQ	ETF	34.89	35.15	34.88	35.0	16680800.0
2005-04-15 14:00:00	QQQ	ETF	35.01	35.15	34.91	34.98	15756000.0
2005-04-15 15:00:00	QQQ	ETF	34.98	35.01	34.68	34.75	37816900.0
2005-04-15 08:00:00	IWM	ETF	58.46	58.65	58.46	58.65	8800.0
2005-04-15 09:00:00	IWM	ETF	58.675	58.975	58.385	58.785	5141000.0
2005-04-15 10:00:00	IWM	ETF	58.79	58.885	58.53	58.785	6218800.0
2005-04-15 11:00:00	IWM	ETF	58.78	58.815	58.2	58.29	6870200.0
2005-04-15 12:00:00	IWM	ETF	58.29	58.435	57.755	57.775	6775600.0
2005-04-15 13:00:00	IWM	ETF	57.77	58.305	57.74	58.1	8036200.0
2005-04-15 14:00:00	IWM	ETF	58.105	58.4	57.96	58.09	4648600.0
2005-04-15 15:00:00	IWM	ETF	58.075	58.135	57.5	57.735	9071800.0
2005-04-15 16:00:00	IWM	ETF	57.73	57.865	57.62	57.85	3635000.0
2005-04-15 17:00:00	IWM	ETF	57.75	57.82	57.75	57.82	3600.0
2005-04-15 19:00:00	IWM	ETF	57.8	57.8	57.8	57.8	800.0
2005-04-15 07:00:00	DIA	ETF	102.08	102.08	101.93	102.03	2600.0
2005-04-15 08:00:00	DIA	ETF	101.96	102.31	101.96	102.28	91400.0
2005-04-15 09:00:00	DIA	ETF	102.27	102.6	101.99	102.44	1678400.0
2005-04-15 10:00:00	DIA	ETF	102.44	102.59	102.1	102.4	1820500.0
2005-04-15 11:00:00	DIA	ETF	102.41	102.43	101.8	101.97	1584200.0
2005-04-15 12:00:00	DIA	ETF	102.0	102.13	101.44	101.46	1496700.0
2005-04-15 13:00:00	DIA	ETF	101.5	101.95	101.48	101.64	1608700.0
2005-04-15 14:00:00	DIA	ETF	101.65	101.91	101.39	101.59	1118000.0
2005-04-15 15:00:00	DIA	ETF	101.56	101.66	100.62	100.8	2366400.0
2005-04-15 16:00:00	DIA	ETF	100.8	100.83	100.53	100.57	81500.0
2005-04-15 17:00:00	DIA	ETF	100.59	100.71	100.53	100.62	40500.0
2005-04-15 18:00:00	DIA	ETF	100.7	100.74	100.7	100.74	2100.0
2005-04-15 19:00:00	DIA	ETF	100.77	100.77	100.77	100.77	300.0
2005-04-15 09:00:00	GLD	ETF	42.38	42.45	42.37	42.44	343200.0
2005-04-15 10:00:00	GLD	ETF	42.43	42.52	42.41	42.52	577800.0
2005-04-15 11:00:00	GLD	ETF	42.52	42.56	42.49	42.49	33900.0
2005-04-15 12:00:00	GLD	ETF	42.5	42.52	42.41	42.423	281700.0

> showing 50 of 900 rows — these rows as CSV

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