PREVIEW / etf_1hour / 2012-02-10

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-02-10.parquet
  size:    189 KB
  rows:    5,889

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
2012-02-10 04:00:00	SPY	ETF	134.77	134.77	134.59	134.67	28558.0
2012-02-10 05:00:00	SPY	ETF	134.59	134.59	134.39	134.47	32125.0
2012-02-10 06:00:00	SPY	ETF	134.49	134.57	134.36	134.4	150390.0
2012-02-10 07:00:00	SPY	ETF	134.42	134.42	133.95	134.16	1990549.0
2012-02-10 08:00:00	SPY	ETF	134.16	134.66	133.88	134.07	4952893.0
2012-02-10 09:00:00	SPY	ETF	134.08	134.35	133.98	134.03	24444624.0
2012-02-10 10:00:00	SPY	ETF	134.03	134.23	133.84	134.2	28961793.0
2012-02-10 11:00:00	SPY	ETF	134.21	134.42	134.13	134.28	16173738.0
2012-02-10 12:00:00	SPY	ETF	134.28	134.47	134.215	134.44	9548201.0
2012-02-10 13:00:00	SPY	ETF	134.45	134.46	133.96	133.99	11573568.0
2012-02-10 14:00:00	SPY	ETF	133.98	134.22	133.97	134.125	12173994.0
2012-02-10 15:00:00	SPY	ETF	134.12	134.4	133.87	134.37	38527178.0
2012-02-10 16:00:00	SPY	ETF	134.38	135.3267	134.15	134.75	17262428.0
2012-02-10 17:00:00	SPY	ETF	134.73	134.73	134.47	134.58	443434.0
2012-02-10 18:00:00	SPY	ETF	134.59	134.65	134.53	134.55	46828.0
2012-02-10 19:00:00	SPY	ETF	134.55	134.73	134.55	134.7	106751.0
2012-02-10 04:00:00	QQQ	ETF	62.69	62.69	62.63	62.64	1100.0
2012-02-10 05:00:00	QQQ	ETF	62.64	62.7	62.64	62.65	26000.0
2012-02-10 06:00:00	QQQ	ETF	62.64	62.64	62.56	62.56	19565.0
2012-02-10 07:00:00	QQQ	ETF	62.58	62.58	62.32	62.37	2112536.0
2012-02-10 08:00:00	QQQ	ETF	62.38	62.75	62.34	62.42	2732163.0
2012-02-10 09:00:00	QQQ	ETF	62.43	62.56	62.31	62.37	7205533.0
2012-02-10 10:00:00	QQQ	ETF	62.36	62.53	62.25	62.51	8869868.0
2012-02-10 11:00:00	QQQ	ETF	62.509	62.6	62.46	62.54	5143975.0
2012-02-10 12:00:00	QQQ	ETF	62.55	62.64	62.51	62.62	5747185.0
2012-02-10 13:00:00	QQQ	ETF	62.61	62.61	62.36	62.37	4527958.0
2012-02-10 14:00:00	QQQ	ETF	62.38	62.5	62.37	62.46	4696555.0
2012-02-10 15:00:00	QQQ	ETF	62.459	62.49	62.26	62.465	9920507.0
2012-02-10 16:00:00	QQQ	ETF	62.46	62.8953	62.384	62.63	5997038.0
2012-02-10 17:00:00	QQQ	ETF	62.64	62.68	62.48	62.65	26077.0
2012-02-10 18:00:00	QQQ	ETF	62.6	62.64	62.6	62.61	3264.0
2012-02-10 19:00:00	QQQ	ETF	62.62	62.66	62.6	62.6	2400.0
2012-02-10 04:00:00	IWM	ETF	81.85	81.85	81.8	81.8	400.0
2012-02-10 06:00:00	IWM	ETF	81.84	81.84	81.75	81.75	9400.0
2012-02-10 07:00:00	IWM	ETF	81.64	81.68	81.33	81.38	84608.0
2012-02-10 08:00:00	IWM	ETF	81.39	81.48	81.26	81.35	533324.0
2012-02-10 09:00:00	IWM	ETF	81.34	81.67	81.27	81.33	7192692.0
2012-02-10 10:00:00	IWM	ETF	81.32	81.42	81.08	81.38	7320869.0
2012-02-10 11:00:00	IWM	ETF	81.38	81.56	81.33	81.46	3153495.0
2012-02-10 12:00:00	IWM	ETF	81.46	81.61	81.39	81.61	3695680.0
2012-02-10 13:00:00	IWM	ETF	81.61	81.63	81.2	81.22	2215719.0
2012-02-10 14:00:00	IWM	ETF	81.22	81.41	81.19	81.26	2774059.0
2012-02-10 15:00:00	IWM	ETF	81.26	81.33	81.09	81.24	8945888.0
2012-02-10 16:00:00	IWM	ETF	81.25	81.5	81.25	81.5	4349451.0
2012-02-10 17:00:00	IWM	ETF	81.5	81.5	81.27	81.35	22700.0
2012-02-10 18:00:00	IWM	ETF	81.33	81.33	81.33	81.33	1100.0
2012-02-10 19:00:00	IWM	ETF	81.38	81.46	81.35	81.43	3870.0
2012-02-10 07:00:00	DIA	ETF	128.06	128.06	127.71	127.8	3800.0
2012-02-10 08:00:00	DIA	ETF	127.84	127.87	127.61	127.73	28217.0
2012-02-10 09:00:00	DIA	ETF	127.76	127.88	127.46	127.5	1102958.0

> showing 50 of 5,889 rows — these rows as CSV

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