PREVIEW / etf_1hour / 2005-04-18

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-04-18.parquet
  size:    31 KB
  rows:    898

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-18 04:00:00	SPY	ETF	113.48	113.48	113.48	113.48	1000.0
2005-04-18 07:00:00	SPY	ETF	113.67	114.22	113.64	114.2	508600.0
2005-04-18 08:00:00	SPY	ETF	114.2	114.43	114.2	114.28	481700.0
2005-04-18 09:00:00	SPY	ETF	114.26	114.48	113.96	114.38	16968000.0
2005-04-18 10:00:00	SPY	ETF	114.38	114.8	114.2	114.57	27456300.0
2005-04-18 11:00:00	SPY	ETF	114.55	114.82	114.02	114.21	11573900.0
2005-04-18 12:00:00	SPY	ETF	114.21	114.89	114.08	114.75	9930800.0
2005-04-18 13:00:00	SPY	ETF	114.74	114.96	114.3	114.65	7854800.0
2005-04-18 14:00:00	SPY	ETF	114.64	114.9	114.28	114.56	7883700.0
2005-04-18 15:00:00	SPY	ETF	114.55	114.94	114.48	114.6	13017500.0
2005-04-18 16:00:00	SPY	ETF	114.6	114.75	114.33	114.75	1155800.0
2005-04-18 17:00:00	SPY	ETF	114.75	114.85	114.5	114.75	121100.0
2005-04-18 18:00:00	SPY	ETF	114.75	114.8	114.75	114.8	2500.0
2005-04-18 19:00:00	SPY	ETF	114.76	114.8	114.76	114.79	1900.0
2005-04-18 09:00:00	QQQ	ETF	34.74	34.88	34.64	34.85	20517600.0
2005-04-18 10:00:00	QQQ	ETF	34.85	35.1	34.69	34.87	20934400.0
2005-04-18 11:00:00	QQQ	ETF	34.86	34.97	34.65	34.7	14059200.0
2005-04-18 12:00:00	QQQ	ETF	34.7	34.93	34.66	34.89	9960200.0
2005-04-18 13:00:00	QQQ	ETF	34.88	34.95	34.77	34.81	10192400.0
2005-04-18 14:00:00	QQQ	ETF	34.81	34.92	34.66	34.76	11093700.0
2005-04-18 15:00:00	QQQ	ETF	34.75	34.91	34.73	34.74	12651200.0
2005-04-18 07:00:00	IWM	ETF	57.595	57.75	57.595	57.75	24400.0
2005-04-18 08:00:00	IWM	ETF	57.775	57.905	57.75	57.89	107400.0
2005-04-18 09:00:00	IWM	ETF	57.89	57.95	57.31	57.68	6888600.0
2005-04-18 10:00:00	IWM	ETF	57.675	58.21	57.435	57.975	9568200.0
2005-04-18 11:00:00	IWM	ETF	57.975	58.085	57.57	57.695	4305000.0
2005-04-18 12:00:00	IWM	ETF	57.69	58.31	57.66	58.3	3298000.0
2005-04-18 13:00:00	IWM	ETF	58.3	58.37	58.005	58.16	3895000.0
2005-04-18 14:00:00	IWM	ETF	58.15	58.38	57.85	58.075	2797800.0
2005-04-18 15:00:00	IWM	ETF	58.075	58.38	58.005	58.14	3850600.0
2005-04-18 16:00:00	IWM	ETF	58.135	58.31	58.135	58.3	145600.0
2005-04-18 17:00:00	IWM	ETF	58.3	58.33	58.215	58.215	53200.0
2005-04-18 07:00:00	DIA	ETF	100.35	100.62	100.35	100.62	3000.0
2005-04-18 08:00:00	DIA	ETF	100.78	100.99	100.75	100.76	111300.0
2005-04-18 09:00:00	DIA	ETF	100.75	100.9	100.29	100.61	3001200.0
2005-04-18 10:00:00	DIA	ETF	100.6	100.99	100.34	100.58	3115100.0
2005-04-18 11:00:00	DIA	ETF	100.57	100.79	100.12	100.32	1358800.0
2005-04-18 12:00:00	DIA	ETF	100.31	100.99	100.21	100.87	1786200.0
2005-04-18 13:00:00	DIA	ETF	100.87	101.01	100.62	100.77	753000.0
2005-04-18 14:00:00	DIA	ETF	100.74	100.97	100.44	100.68	1171300.0
2005-04-18 15:00:00	DIA	ETF	100.69	100.92	100.56	100.61	1486900.0
2005-04-18 16:00:00	DIA	ETF	100.92	100.92	100.55	100.7	11800.0
2005-04-18 17:00:00	DIA	ETF	100.7	100.7	100.68	100.7	2300.0
2005-04-18 19:00:00	DIA	ETF	100.8	100.8	100.8	100.8	200.0
2005-04-18 09:00:00	GLD	ETF	42.51	42.63	42.44	42.62	235800.0
2005-04-18 10:00:00	GLD	ETF	42.62	42.68	42.56	42.68	134800.0
2005-04-18 11:00:00	GLD	ETF	42.66	42.78	42.66	42.76	119600.0
2005-04-18 12:00:00	GLD	ETF	42.76	42.76	42.68	42.71	148300.0
2005-04-18 13:00:00	GLD	ETF	42.69	42.74	42.65	42.74	90700.0
2005-04-18 14:00:00	GLD	ETF	42.73	42.73	42.7	42.7	116600.0

> showing 50 of 898 rows — these rows as CSV

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