PREVIEW / etf_1hour / 2012-05-10

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-05-10.parquet
  size:    186 KB
  rows:    5,788

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-05-10 04:00:00	SPY	ETF	136.14	136.14	135.72	136.0	4400.0
2012-05-10 05:00:00	SPY	ETF	135.78	135.78	135.39	135.51	60700.0
2012-05-10 06:00:00	SPY	ETF	135.54	136.04	135.54	136.0	88196.0
2012-05-10 07:00:00	SPY	ETF	135.94	136.48	135.7	136.47	779967.0
2012-05-10 08:00:00	SPY	ETF	136.48	136.85	135.45	136.58	2922161.0
2012-05-10 09:00:00	SPY	ETF	136.58	136.92	136.41	136.62	16182554.0
2012-05-10 10:00:00	SPY	ETF	136.62	136.79	135.92	136.12	29360356.0
2012-05-10 11:00:00	SPY	ETF	136.12	136.52	135.92	136.22	18229784.0
2012-05-10 12:00:00	SPY	ETF	136.22	136.64	135.92	136.59	17565652.0
2012-05-10 13:00:00	SPY	ETF	136.59	136.73	136.29	136.355	13877140.0
2012-05-10 14:00:00	SPY	ETF	136.34	136.51	136.22	136.25	9421431.0
2012-05-10 15:00:00	SPY	ETF	136.25	136.35	135.71	136.03	26061792.0
2012-05-10 16:00:00	SPY	ETF	136.01	136.4802	135.35	135.67	12900704.0
2012-05-10 17:00:00	SPY	ETF	135.69	135.7	134.97	135.32	2102438.0
2012-05-10 18:00:00	SPY	ETF	135.26	135.44	135.19	135.42	332331.0
2012-05-10 19:00:00	SPY	ETF	135.42	135.49	135.18	135.29	188238.0
2012-05-10 04:00:00	QQQ	ETF	63.82	64.36	63.82	64.33	13700.0
2012-05-10 05:00:00	QQQ	ETF	64.2	64.2	64.2	64.2	1000.0
2012-05-10 06:00:00	QQQ	ETF	64.12	64.34	64.12	64.32	43800.0
2012-05-10 07:00:00	QQQ	ETF	64.33	64.55	64.24	64.55	171355.0
2012-05-10 08:00:00	QQQ	ETF	64.56	64.74	64.14	64.61	769884.0
2012-05-10 09:00:00	QQQ	ETF	64.62	64.75	64.26	64.35	8129815.0
2012-05-10 10:00:00	QQQ	ETF	64.36	64.425	64.0	64.13	9104704.0
2012-05-10 11:00:00	QQQ	ETF	64.14	64.3	64.05	64.1295	4357000.0
2012-05-10 12:00:00	QQQ	ETF	64.128	64.38	63.95	64.37	6336441.0
2012-05-10 13:00:00	QQQ	ETF	64.37	64.44	64.21	64.24	4917679.0
2012-05-10 14:00:00	QQQ	ETF	64.2384	64.39	64.229	64.27	2918034.0
2012-05-10 15:00:00	QQQ	ETF	64.27	64.32	64.02	64.18	7186810.0
2012-05-10 16:00:00	QQQ	ETF	64.18	64.48	64.04	64.11	3285904.0
2012-05-10 17:00:00	QQQ	ETF	64.11	64.14	63.91	64.0	89749.0
2012-05-10 18:00:00	QQQ	ETF	64.0	64.09	64.0	64.06	59643.0
2012-05-10 19:00:00	QQQ	ETF	64.06	64.07	63.96	63.98	13219.0
2012-05-10 04:00:00	IWM	ETF	78.87	78.87	78.87	78.87	800.0
2012-05-10 05:00:00	IWM	ETF	78.5	78.5	78.44	78.44	4000.0
2012-05-10 06:00:00	IWM	ETF	78.69	78.9	78.69	78.9	5390.0
2012-05-10 07:00:00	IWM	ETF	78.88	79.22	78.69	79.2	72451.0
2012-05-10 08:00:00	IWM	ETF	79.2	79.5	78.39	79.3	675896.0
2012-05-10 09:00:00	IWM	ETF	79.33	79.54	79.05	79.3	5313479.0
2012-05-10 10:00:00	IWM	ETF	79.31	79.44	78.67	78.83	6717155.0
2012-05-10 11:00:00	IWM	ETF	78.83	79.19	78.63	78.95	5592433.0
2012-05-10 12:00:00	IWM	ETF	78.955	79.47	78.705	79.43	7421065.0
2012-05-10 13:00:00	IWM	ETF	79.43	79.55	79.14	79.19	4773175.0
2012-05-10 14:00:00	IWM	ETF	79.188	79.38	79.17	79.2	2398754.0
2012-05-10 15:00:00	IWM	ETF	79.2	79.2652	78.84	79.1	7027203.0
2012-05-10 16:00:00	IWM	ETF	79.1	79.29	78.66	78.76	2114710.0
2012-05-10 17:00:00	IWM	ETF	78.78	78.78	78.35	78.36	278242.0
2012-05-10 18:00:00	IWM	ETF	78.53	78.54	78.49	78.49	979.0
2012-05-10 19:00:00	IWM	ETF	78.54	78.58	78.54	78.58	1176.0
2012-05-10 07:00:00	DIA	ETF	128.47	128.52	128.47	128.52	2109.0
2012-05-10 08:00:00	DIA	ETF	128.72	128.96	128.64	128.77	21523.0

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

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