PREVIEW / etf_1hour / 2010-09-09

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-09-09.parquet
  size:    159 KB
  rows:    4,863

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-09-09 04:00:00	SPY	ETF	110.41	110.75	110.37	110.75	2063.0
2010-09-09 05:00:00	SPY	ETF	110.75	110.86	110.74	110.85	12000.0
2010-09-09 06:00:00	SPY	ETF	110.85	110.9	110.82	110.89	9570.0
2010-09-09 07:00:00	SPY	ETF	110.88	110.94	110.76	110.78	142149.0
2010-09-09 08:00:00	SPY	ETF	110.78	111.42	110.65	111.26	3878396.0
2010-09-09 09:00:00	SPY	ETF	111.27	111.73	111.23	111.47	28543338.0
2010-09-09 10:00:00	SPY	ETF	111.47	111.5	111.07	111.07	17292906.0
2010-09-09 11:00:00	SPY	ETF	111.08	111.47	111.04	111.319	10496906.0
2010-09-09 12:00:00	SPY	ETF	111.31	111.4	110.95	110.96	10117753.0
2010-09-09 13:00:00	SPY	ETF	110.96	111.06	110.62	110.7201	21002991.0
2010-09-09 14:00:00	SPY	ETF	110.72	111.03	110.635	111.0	13778768.0
2010-09-09 15:00:00	SPY	ETF	111.0	111.46	110.89	110.93	28735393.0
2010-09-09 16:00:00	SPY	ETF	110.93	111.55	110.725	110.74	8709596.0
2010-09-09 17:00:00	SPY	ETF	110.75	110.88	110.63	110.79	1696888.0
2010-09-09 18:00:00	SPY	ETF	110.78	110.94	110.71	110.79	556617.0
2010-09-09 19:00:00	SPY	ETF	110.8	110.84	110.75	110.79	26557.0
2010-09-09 04:00:00	QQQ	ETF	46.28	46.28	46.28	46.28	3800.0
2010-09-09 06:00:00	QQQ	ETF	46.37	46.37	46.37	46.37	200.0
2010-09-09 07:00:00	QQQ	ETF	46.4	46.41	46.35	46.35	46852.0
2010-09-09 08:00:00	QQQ	ETF	46.33	46.58	46.2	46.54	1852461.0
2010-09-09 09:00:00	QQQ	ETF	46.54	46.7	46.51	46.58	9321425.0
2010-09-09 10:00:00	QQQ	ETF	46.58	46.65	46.44	46.44	9924103.0
2010-09-09 11:00:00	QQQ	ETF	46.44	46.67	46.44	46.62	3628356.0
2010-09-09 12:00:00	QQQ	ETF	46.62	46.68	46.53	46.53	4284052.0
2010-09-09 13:00:00	QQQ	ETF	46.53	46.5775	46.36	46.4	8253700.0
2010-09-09 14:00:00	QQQ	ETF	46.4	46.51	46.32	46.5	3968153.0
2010-09-09 15:00:00	QQQ	ETF	46.5	46.58	46.4	46.43	8529086.0
2010-09-09 16:00:00	QQQ	ETF	46.43	46.5706	46.2648	46.39	3831752.0
2010-09-09 17:00:00	QQQ	ETF	46.35	46.41	46.34	46.41	16468.0
2010-09-09 18:00:00	QQQ	ETF	46.4	46.41	46.38	46.4	6870.0
2010-09-09 19:00:00	QQQ	ETF	46.41	46.41	46.38	46.4	32571.0
2010-09-09 07:00:00	IWM	ETF	63.83	63.83	63.72	63.72	7400.0
2010-09-09 08:00:00	IWM	ETF	63.7	64.12	63.61	64.05	1129633.0
2010-09-09 09:00:00	IWM	ETF	64.05	64.55	64.04	64.18	5607238.0
2010-09-09 10:00:00	IWM	ETF	64.17	64.21	63.71	63.72	6631803.0
2010-09-09 11:00:00	IWM	ETF	63.72	64.09	63.71	63.93	3239175.0
2010-09-09 12:00:00	IWM	ETF	63.93	64.04	63.56	63.57	2599684.0
2010-09-09 13:00:00	IWM	ETF	63.57	63.655	63.09	63.12	8706570.0
2010-09-09 14:00:00	IWM	ETF	63.11	63.3799	63.04	63.36	4633970.0
2010-09-09 15:00:00	IWM	ETF	63.36	63.68	63.33	63.52	7671259.0
2010-09-09 16:00:00	IWM	ETF	63.53	63.73	63.46	63.46	5306613.0
2010-09-09 17:00:00	IWM	ETF	63.45	63.52	63.44	63.49	4879.0
2010-09-09 18:00:00	IWM	ETF	63.49	63.49	63.4	63.44	993.0
2010-09-09 19:00:00	IWM	ETF	63.49	63.49	63.42	63.42	300.0
2010-09-09 08:00:00	DIA	ETF	104.35	104.82	104.31	104.66	62078.0
2010-09-09 09:00:00	DIA	ETF	104.67	105.03	104.55	104.75	690881.0
2010-09-09 10:00:00	DIA	ETF	104.74	104.76	104.43	104.44	826509.0
2010-09-09 11:00:00	DIA	ETF	104.44	104.75	104.44	104.638	264159.0
2010-09-09 12:00:00	DIA	ETF	104.64	104.7	104.27	104.27	267555.0
2010-09-09 13:00:00	DIA	ETF	104.26	104.36	103.97	104.04	411176.0

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

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