PREVIEW / etf_1hour / 2010-03-01

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-03-01.parquet
  size:    154 KB
  rows:    4,841

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
2010-03-01 04:00:00	SPY	ETF	111.49	111.49	111.33	111.41	6422.0
2010-03-01 05:00:00	SPY	ETF	111.46	111.48	111.29	111.29	35500.0
2010-03-01 06:00:00	SPY	ETF	111.27	111.29	110.93	111.1	164950.0
2010-03-01 07:00:00	SPY	ETF	111.06	111.24	110.91	110.91	917976.0
2010-03-01 08:00:00	SPY	ETF	110.94	111.45	110.93	111.19	2707977.0
2010-03-01 09:00:00	SPY	ETF	111.19	111.57	111.16	111.35	18424196.0
2010-03-01 10:00:00	SPY	ETF	111.34	111.81	111.21	111.6	33240112.0
2010-03-01 11:00:00	SPY	ETF	111.6	111.92	111.6	111.81	21466833.0
2010-03-01 12:00:00	SPY	ETF	111.809	111.96	111.68	111.75	12624317.0
2010-03-01 13:00:00	SPY	ETF	111.74	111.905	111.6182	111.875	12116839.0
2010-03-01 14:00:00	SPY	ETF	111.87	112.0	111.75	111.805	13653986.0
2010-03-01 15:00:00	SPY	ETF	111.81	111.94	111.67	111.895	25342013.0
2010-03-01 16:00:00	SPY	ETF	111.89	111.95	111.82	111.95	5373844.0
2010-03-01 17:00:00	SPY	ETF	111.92	112.01	111.9	111.93	291823.0
2010-03-01 18:00:00	SPY	ETF	111.93	111.96	111.86	111.9	86005.0
2010-03-01 19:00:00	SPY	ETF	111.9	111.96	111.9	111.92	116320.0
2010-03-01 04:00:00	QQQ	ETF	45.05	45.06	45.05	45.06	200.0
2010-03-01 05:00:00	QQQ	ETF	45.0	45.0	45.0	45.0	1800.0
2010-03-01 06:00:00	QQQ	ETF	44.88	44.88	44.88	44.88	2000.0
2010-03-01 07:00:00	QQQ	ETF	44.89	44.96	44.85	44.85	74712.0
2010-03-01 08:00:00	QQQ	ETF	44.87	44.91	44.76	44.9	3209466.0
2010-03-01 09:00:00	QQQ	ETF	44.9	45.13	44.9	45.05	9947248.0
2010-03-01 10:00:00	QQQ	ETF	45.05	45.35	44.99	45.315	15907345.0
2010-03-01 11:00:00	QQQ	ETF	45.3105	45.42	45.31	45.37	10099691.0
2010-03-01 12:00:00	QQQ	ETF	45.37	45.45	45.34	45.37	5223998.0
2010-03-01 13:00:00	QQQ	ETF	45.37	45.45	45.34	45.43	4232778.0
2010-03-01 14:00:00	QQQ	ETF	45.43	45.49	45.37	45.4	5460786.0
2010-03-01 15:00:00	QQQ	ETF	45.4	45.45	45.35	45.41	10703944.0
2010-03-01 16:00:00	QQQ	ETF	45.41	45.42	44.7614	45.41	6178776.0
2010-03-01 17:00:00	QQQ	ETF	45.41	45.42	45.4	45.4	45769.0
2010-03-01 18:00:00	QQQ	ETF	45.41	45.43	45.4	45.4	10500.0
2010-03-01 19:00:00	QQQ	ETF	45.41	45.43	45.39	45.42	48667.0
2010-03-01 04:00:00	IWM	ETF	63.22	63.22	63.22	63.22	200.0
2010-03-01 07:00:00	IWM	ETF	63.2	63.29	63.09	63.1	210435.0
2010-03-01 08:00:00	IWM	ETF	63.12	63.35	62.8	63.26	1000784.0
2010-03-01 09:00:00	IWM	ETF	63.26	63.84	63.22	63.7201	11976667.0
2010-03-01 10:00:00	IWM	ETF	63.72	64.08	63.58	63.99	12156626.0
2010-03-01 11:00:00	IWM	ETF	63.99	64.16	63.9	64.09	9359007.0
2010-03-01 12:00:00	IWM	ETF	64.1	64.19	64.03	64.06	4905581.0
2010-03-01 13:00:00	IWM	ETF	64.06	64.27	64.01	64.26	5096584.0
2010-03-01 14:00:00	IWM	ETF	64.25	64.31	64.05	64.11	6000674.0
2010-03-01 15:00:00	IWM	ETF	64.11	64.32	63.94	64.24	14325007.0
2010-03-01 16:00:00	IWM	ETF	64.24	64.3158	62.8546	64.23	2669345.0
2010-03-01 17:00:00	IWM	ETF	64.24	64.32	64.24	64.32	20700.0
2010-03-01 18:00:00	IWM	ETF	64.26	64.26	64.23	64.23	900.0
2010-03-01 19:00:00	IWM	ETF	64.3	64.32	64.23	64.29	2454.0
2010-03-01 07:00:00	DIA	ETF	103.61	103.61	103.5	103.5	9600.0
2010-03-01 08:00:00	DIA	ETF	103.49	103.64	103.48	103.64	103250.0
2010-03-01 09:00:00	DIA	ETF	103.64	103.9	103.5	103.69	998881.0
2010-03-01 10:00:00	DIA	ETF	103.7	104.085	103.58	103.97	1623803.0

> showing 50 of 4,841 rows — these rows as CSV

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