PREVIEW / etf_1hour / 2010-07-26

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-07-26.parquet
  size:    160 KB
  rows:    4,891

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-07-26 04:00:00	SPY	ETF	110.41	110.41	110.25	110.41	4800.0
2010-07-26 05:00:00	SPY	ETF	110.46	110.46	110.36	110.36	6470.0
2010-07-26 06:00:00	SPY	ETF	110.46	110.58	110.35	110.58	5200.0
2010-07-26 07:00:00	SPY	ETF	110.53	110.53	110.24	110.36	518549.0
2010-07-26 08:00:00	SPY	ETF	110.41	110.58	110.25	110.49	2970500.0
2010-07-26 09:00:00	SPY	ETF	110.49	110.79	110.29	110.63	20080781.0
2010-07-26 10:00:00	SPY	ETF	110.63	111.2583	110.63	111.1	36244505.0
2010-07-26 11:00:00	SPY	ETF	111.1	111.47	110.96	111.34	26153864.0
2010-07-26 12:00:00	SPY	ETF	111.35	111.47	110.6	111.33	13526639.0
2010-07-26 13:00:00	SPY	ETF	111.325	111.44	111.2	111.37	11521789.0
2010-07-26 14:00:00	SPY	ETF	111.37	111.37	110.95	111.09	14302272.0
2010-07-26 15:00:00	SPY	ETF	111.09	111.67	111.0	111.58	33283559.0
2010-07-26 16:00:00	SPY	ETF	111.59	111.61	110.4291	111.46	11613915.0
2010-07-26 17:00:00	SPY	ETF	111.45	111.5	110.4291	111.45	5104137.0
2010-07-26 18:00:00	SPY	ETF	111.45	111.57	111.34	111.39	105672.0
2010-07-26 19:00:00	SPY	ETF	111.37	111.43	111.33	111.36	46644.0
2010-07-26 04:00:00	QQQ	ETF	46.06	46.06	46.03	46.03	1700.0
2010-07-26 05:00:00	QQQ	ETF	46.05	46.05	46.05	46.05	150.0
2010-07-26 06:00:00	QQQ	ETF	46.12	46.12	46.1	46.1	1800.0
2010-07-26 07:00:00	QQQ	ETF	46.13	46.13	45.99	46.03	900733.0
2010-07-26 08:00:00	QQQ	ETF	46.03	46.08	45.99	46.08	2581468.0
2010-07-26 09:00:00	QQQ	ETF	46.08	46.22	45.91	46.07	8738933.0
2010-07-26 10:00:00	QQQ	ETF	46.06	46.29	46.05	46.24	10526216.0
2010-07-26 11:00:00	QQQ	ETF	46.24	46.41	46.2	46.33	7969297.0
2010-07-26 12:00:00	QQQ	ETF	46.33	46.35	46.18	46.2501	13508367.0
2010-07-26 13:00:00	QQQ	ETF	46.26	46.32	46.19	46.28	3952109.0
2010-07-26 14:00:00	QQQ	ETF	46.28	46.3	46.14	46.22	3702400.0
2010-07-26 15:00:00	QQQ	ETF	46.22	46.46	46.21	46.435	9420838.0
2010-07-26 16:00:00	QQQ	ETF	46.43	46.45	46.2459	46.42	1047494.0
2010-07-26 17:00:00	QQQ	ETF	46.43	46.46	46.4	46.46	16554.0
2010-07-26 18:00:00	QQQ	ETF	46.41	46.41	46.36	46.37	6100.0
2010-07-26 19:00:00	QQQ	ETF	46.38	46.4	46.37	46.37	9204.0
2010-07-26 05:00:00	IWM	ETF	65.17	65.17	65.11	65.11	2600.0
2010-07-26 06:00:00	IWM	ETF	65.04	65.15	65.04	65.14	11000.0
2010-07-26 07:00:00	IWM	ETF	65.18	65.19	65.01	65.08	57756.0
2010-07-26 08:00:00	IWM	ETF	65.17	65.19	65.01	65.19	189054.0
2010-07-26 09:00:00	IWM	ETF	65.19	65.43	64.92	65.31	7271072.0
2010-07-26 10:00:00	IWM	ETF	65.33	66.14	65.28	65.97	11547090.0
2010-07-26 11:00:00	IWM	ETF	65.98	66.27	65.87	66.19	8251288.0
2010-07-26 12:00:00	IWM	ETF	66.19	66.31	66.09	66.205	4866965.0
2010-07-26 13:00:00	IWM	ETF	66.21	66.37	66.03	66.23	6746768.0
2010-07-26 14:00:00	IWM	ETF	66.23	66.28	65.96	66.06	5307836.0
2010-07-26 15:00:00	IWM	ETF	66.06	66.52	66.04	66.47	12830528.0
2010-07-26 16:00:00	IWM	ETF	66.48	66.5	65.0515	66.47	4227844.0
2010-07-26 17:00:00	IWM	ETF	66.45	66.47	66.44	66.47	15513.0
2010-07-26 18:00:00	IWM	ETF	66.46	66.46	66.39	66.39	12380.0
2010-07-26 19:00:00	IWM	ETF	66.37	66.4	66.37	66.38	2400.0
2010-07-26 06:00:00	DIA	ETF	104.25	104.25	104.25	104.25	100.0
2010-07-26 07:00:00	DIA	ETF	104.27	104.29	104.27	104.29	4055.0
2010-07-26 08:00:00	DIA	ETF	104.28	104.29	104.17	104.21	18400.0

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

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