PREVIEW / etf_1hour / 2005-04-25

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-04-25.parquet
  size:    29 KB
  rows:    866

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-25 07:00:00	SPY	ETF	115.57	115.57	115.46	115.5	32300.0
2005-04-25 08:00:00	SPY	ETF	115.47	115.87	115.47	115.79	322500.0
2005-04-25 09:00:00	SPY	ETF	115.8	115.99	115.72	115.87	5541700.0
2005-04-25 10:00:00	SPY	ETF	115.89	116.5	115.82	116.16	13610100.0
2005-04-25 11:00:00	SPY	ETF	116.16	116.42	116.05	116.35	5685800.0
2005-04-25 12:00:00	SPY	ETF	116.35	116.4	116.07	116.09	3705300.0
2005-04-25 13:00:00	SPY	ETF	116.1	116.39	115.99	116.03	4540800.0
2005-04-25 14:00:00	SPY	ETF	116.03	116.3	115.98	116.0	5004800.0
2005-04-25 15:00:00	SPY	ETF	115.98	116.3	115.75	116.27	11179200.0
2005-04-25 16:00:00	SPY	ETF	116.28	116.46	116.24	116.38	1467800.0
2005-04-25 17:00:00	SPY	ETF	116.38	116.38	116.33	116.37	27600.0
2005-04-25 18:00:00	SPY	ETF	116.35	116.35	116.3	116.32	5800.0
2005-04-25 19:00:00	SPY	ETF	116.28	116.31	116.28	116.31	2100.0
2005-04-25 09:00:00	QQQ	ETF	35.29	35.33	35.2	35.25	9269900.0
2005-04-25 10:00:00	QQQ	ETF	35.25	35.46	35.22	35.34	15939800.0
2005-04-25 11:00:00	QQQ	ETF	35.33	35.44	35.31	35.43	7245900.0
2005-04-25 12:00:00	QQQ	ETF	35.42	35.45	35.31	35.33	6072100.0
2005-04-25 13:00:00	QQQ	ETF	35.33	35.43	35.28	35.28	4724600.0
2005-04-25 14:00:00	QQQ	ETF	35.29	35.39	35.27	35.27	6319600.0
2005-04-25 15:00:00	QQQ	ETF	35.27	35.4	35.15	35.38	15565500.0
2005-04-25 08:00:00	IWM	ETF	58.825	58.94	58.825	58.935	16600.0
2005-04-25 09:00:00	IWM	ETF	58.9	59.09	58.805	58.86	3104800.0
2005-04-25 10:00:00	IWM	ETF	58.87	59.3	58.815	59.0	4090800.0
2005-04-25 11:00:00	IWM	ETF	59.005	59.285	58.95	59.26	2105600.0
2005-04-25 12:00:00	IWM	ETF	59.255	59.315	59.08	59.19	1575800.0
2005-04-25 13:00:00	IWM	ETF	59.19	59.3	58.98	58.985	1644400.0
2005-04-25 14:00:00	IWM	ETF	58.98	59.2	58.965	58.985	2166400.0
2005-04-25 15:00:00	IWM	ETF	58.97	59.275	58.75	59.235	3532600.0
2005-04-25 16:00:00	IWM	ETF	59.235	59.325	59.215	59.31	407200.0
2005-04-25 17:00:00	IWM	ETF	59.235	59.235	59.235	59.235	1000.0
2005-04-25 19:00:00	IWM	ETF	59.275	59.275	59.275	59.275	200.0
2005-04-25 07:00:00	DIA	ETF	101.7	101.7	101.7	101.7	1000.0
2005-04-25 08:00:00	DIA	ETF	101.78	102.01	101.78	102.01	37000.0
2005-04-25 09:00:00	DIA	ETF	102.04	102.11	101.88	102.04	518800.0
2005-04-25 10:00:00	DIA	ETF	102.03	102.55	102.0	102.33	1199700.0
2005-04-25 11:00:00	DIA	ETF	102.33	102.54	102.21	102.52	505700.0
2005-04-25 12:00:00	DIA	ETF	102.51	102.53	102.29	102.36	308000.0
2005-04-25 13:00:00	DIA	ETF	102.37	102.53	102.22	102.24	511300.0
2005-04-25 14:00:00	DIA	ETF	102.22	102.5	102.22	102.23	478800.0
2005-04-25 15:00:00	DIA	ETF	102.23	102.45	101.99	102.39	945100.0
2005-04-25 16:00:00	DIA	ETF	102.45	102.59	102.45	102.53	54500.0
2005-04-25 08:00:00	GLD	ETF	43.24	43.24	43.23	43.23	1000.0
2005-04-25 09:00:00	GLD	ETF	43.35	43.36	43.3	43.3	81200.0
2005-04-25 10:00:00	GLD	ETF	43.32	43.32	43.22	43.31	97900.0
2005-04-25 11:00:00	GLD	ETF	43.31	43.44	43.26	43.43	193800.0
2005-04-25 12:00:00	GLD	ETF	43.43	43.45	43.39	43.4	134600.0
2005-04-25 13:00:00	GLD	ETF	43.42	43.43	43.39	43.42	38900.0
2005-04-25 14:00:00	GLD	ETF	43.42	43.44	43.4	43.43	107800.0
2005-04-25 15:00:00	GLD	ETF	43.41	43.45	43.4	43.43	214000.0
2005-04-25 16:00:00	GLD	ETF	43.43	43.43	43.43	43.43	31000.0

> showing 50 of 866 rows — these rows as CSV

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