PREVIEW / etf_1hour / 2005-04-22

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-04-22.parquet
  size:    30 KB
  rows:    859

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-22 06:00:00	SPY	ETF	115.69	115.76	115.66	115.76	90000.0
2005-04-22 07:00:00	SPY	ETF	115.77	115.82	115.75	115.78	87600.0
2005-04-22 08:00:00	SPY	ETF	115.75	115.91	115.75	115.91	206100.0
2005-04-22 09:00:00	SPY	ETF	115.89	115.91	115.5	115.67	12412100.0
2005-04-22 10:00:00	SPY	ETF	115.67	116.5	115.6	115.8	10191400.0
2005-04-22 11:00:00	SPY	ETF	115.77	115.99	115.6	115.67	5394400.0
2005-04-22 12:00:00	SPY	ETF	115.67	115.98	115.45	115.82	7162000.0
2005-04-22 13:00:00	SPY	ETF	115.8	115.95	115.64	115.87	3503500.0
2005-04-22 14:00:00	SPY	ETF	115.89	115.89	115.0	115.17	14741000.0
2005-04-22 15:00:00	SPY	ETF	115.19	115.32	114.27	115.28	30390300.0
2005-04-22 16:00:00	SPY	ETF	115.31	115.61	115.23	115.51	1254900.0
2005-04-22 17:00:00	SPY	ETF	115.51	115.55	115.46	115.51	23500.0
2005-04-22 09:00:00	QQQ	ETF	35.45	35.46	35.31	35.36	14901700.0
2005-04-22 10:00:00	QQQ	ETF	35.36	35.43	35.26	35.33	21169200.0
2005-04-22 11:00:00	QQQ	ETF	35.32	35.39	35.24	35.29	11865700.0
2005-04-22 12:00:00	QQQ	ETF	35.29	35.31	35.17	35.24	10717100.0
2005-04-22 13:00:00	QQQ	ETF	35.24	35.35	35.2	35.35	7193700.0
2005-04-22 14:00:00	QQQ	ETF	35.34	35.39	35.03	35.08	14311000.0
2005-04-22 15:00:00	QQQ	ETF	35.08	35.12	34.82	35.09	30086300.0
2005-04-22 07:00:00	IWM	ETF	59.505	59.52	59.505	59.52	7800.0
2005-04-22 08:00:00	IWM	ETF	59.475	59.475	59.475	59.475	800.0
2005-04-22 09:00:00	IWM	ETF	59.49	59.56	59.08	59.15	3383000.0
2005-04-22 10:00:00	IWM	ETF	59.16	59.345	58.83	58.885	2938400.0
2005-04-22 11:00:00	IWM	ETF	58.885	59.075	58.805	58.915	2231400.0
2005-04-22 12:00:00	IWM	ETF	58.915	59.1	58.79	59.0	2146200.0
2005-04-22 13:00:00	IWM	ETF	59.0	59.055	58.925	58.975	1190600.0
2005-04-22 14:00:00	IWM	ETF	58.96	58.985	58.375	58.55	3683200.0
2005-04-22 15:00:00	IWM	ETF	58.56	58.675	58.04	58.675	11400200.0
2005-04-22 16:00:00	IWM	ETF	58.675	58.75	58.575	58.7	1336400.0
2005-04-22 07:00:00	DIA	ETF	101.88	101.92	101.88	101.91	1900.0
2005-04-22 08:00:00	DIA	ETF	101.86	101.98	101.86	101.98	4300.0
2005-04-22 09:00:00	DIA	ETF	101.96	102.0	101.66	101.83	858900.0
2005-04-22 10:00:00	DIA	ETF	101.83	102.11	101.78	102.02	720900.0
2005-04-22 11:00:00	DIA	ETF	102.03	102.16	101.81	101.84	382600.0
2005-04-22 12:00:00	DIA	ETF	101.84	102.08	101.62	101.95	575600.0
2005-04-22 13:00:00	DIA	ETF	102.0	102.04	101.82	102.01	124700.0
2005-04-22 14:00:00	DIA	ETF	102.01	102.01	101.23	101.35	980500.0
2005-04-22 15:00:00	DIA	ETF	101.33	101.6	100.62	101.55	2253300.0
2005-04-22 16:00:00	DIA	ETF	101.56	101.83	101.51	101.8	108200.0
2005-04-22 17:00:00	DIA	ETF	101.77	101.8	101.77	101.8	14200.0
2005-04-22 19:00:00	DIA	ETF	101.75	101.75	101.75	101.75	1500.0
2005-04-22 09:00:00	GLD	ETF	43.42	43.48	43.41	43.46	464900.0
2005-04-22 10:00:00	GLD	ETF	43.45	43.48	43.43	43.46	217500.0
2005-04-22 11:00:00	GLD	ETF	43.46	43.5	43.4	43.43	151900.0
2005-04-22 12:00:00	GLD	ETF	43.44	43.45	43.41	43.43	85400.0
2005-04-22 13:00:00	GLD	ETF	43.39	43.39	43.306	43.36	24500.0
2005-04-22 14:00:00	GLD	ETF	43.36	43.4	43.35	43.4	83400.0
2005-04-22 15:00:00	GLD	ETF	43.4	43.45	43.366	43.39	120400.0
2005-04-22 16:00:00	GLD	ETF	43.41	43.41	43.41	43.41	1000.0
2005-04-22 08:00:00	TLT	ETF	91.07	91.18	91.07	91.18	15300.0

> showing 50 of 859 rows — these rows as CSV

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