PREVIEW / stock_1hour / 2011-02-11

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-02-11.parquet
  size:    935 KB
  rows:    44,495
  symbols: 3,536

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
2011-02-11 04:00:00	AAPL	Stock	12.6032	12.615	12.5929	12.6036	22400.0
2011-02-11 05:00:00	AAPL	Stock	12.6043	12.6043	12.6043	12.6043	5600.0
2011-02-11 06:00:00	AAPL	Stock	12.5786	12.6089	12.5786	12.5857	16912.0
2011-02-11 07:00:00	AAPL	Stock	12.6071	12.6582	12.6071	12.6554	318976.0
2011-02-11 08:00:00	AAPL	Stock	12.6446	12.7132	12.64	12.7018	2375576.0
2011-02-11 09:00:00	AAPL	Stock	12.7014	12.7446	12.6264	12.7214	69103972.0
2011-02-11 10:00:00	AAPL	Stock	12.7214	12.7393	12.705	12.7302	57688008.0
2011-02-11 11:00:00	AAPL	Stock	12.7282	12.7421	12.7071	12.7307	47927628.0
2011-02-11 12:00:00	AAPL	Stock	12.7307	12.7786	12.7171	12.7686	44998044.0
2011-02-11 13:00:00	AAPL	Stock	12.7682	12.7771	12.7357	12.7643	32958716.0
2011-02-11 14:00:00	AAPL	Stock	12.7643	12.7689	12.7393	12.7468	29348984.0
2011-02-11 15:00:00	AAPL	Stock	12.7471	12.7582	12.7325	12.745	62954808.0
2011-02-11 16:00:00	AAPL	Stock	12.745	12.7521	12.6584	12.7375	9828000.0
2011-02-11 17:00:00	AAPL	Stock	12.7224	12.7407	12.7224	12.7357	164136.0
2011-02-11 18:00:00	AAPL	Stock	12.7343	12.7446	12.7339	12.7436	137648.0
2011-02-11 19:00:00	AAPL	Stock	12.7436	12.7518	12.7436	12.7464	237748.0
2011-02-11 04:00:00	MSFT	Stock	27.5	27.5	27.5	27.5	100.0
2011-02-11 05:00:00	MSFT	Stock	27.38	27.38	27.38	27.38	100.0
2011-02-11 06:00:00	MSFT	Stock	27.48	27.5	27.48	27.5	5100.0
2011-02-11 07:00:00	MSFT	Stock	27.49	27.88	27.48	27.83	158755.0
2011-02-11 08:00:00	MSFT	Stock	27.83	27.95	27.59	27.84	368273.0
2011-02-11 09:00:00	MSFT	Stock	27.85	27.9	27.24	27.3	13391309.0
2011-02-11 10:00:00	MSFT	Stock	27.3	27.47	27.17	27.465	12891677.0
2011-02-11 11:00:00	MSFT	Stock	27.468	27.5	27.23	27.26	9694013.0
2011-02-11 12:00:00	MSFT	Stock	27.26	27.29	27.07	27.09	11837657.0
2011-02-11 13:00:00	MSFT	Stock	27.09	27.28	27.085	27.26	7011921.0
2011-02-11 14:00:00	MSFT	Stock	27.26	27.32	27.24	27.3	9378365.0
2011-02-11 15:00:00	MSFT	Stock	27.3	27.33	27.24	27.25	14804123.0
2011-02-11 16:00:00	MSFT	Stock	27.25	27.31	27.242	27.28	1691956.0
2011-02-11 17:00:00	MSFT	Stock	27.28	27.31	27.28	27.28	11209.0
2011-02-11 18:00:00	MSFT	Stock	27.25	27.3	27.25	27.25	10462.0
2011-02-11 19:00:00	MSFT	Stock	27.32	27.32	27.3	27.31	7534.0
2011-02-11 07:00:00	NVDA	Stock	0.5672	0.5672	0.5672	0.5672	4000.0
2011-02-11 08:00:00	NVDA	Stock	0.5662	0.5692	0.566	0.5692	178000.0
2011-02-11 09:00:00	NVDA	Stock	0.5692	0.575	0.5592	0.575	132789320.0
2011-02-11 10:00:00	NVDA	Stock	0.5748	0.597	0.5712	0.597	400847480.0
2011-02-11 11:00:00	NVDA	Stock	0.597	0.5992	0.5903	0.5992	196788520.0
2011-02-11 12:00:00	NVDA	Stock	0.5992	0.6053	0.5965	0.5973	192306680.0
2011-02-11 13:00:00	NVDA	Stock	0.5973	0.5973	0.5908	0.595	111997840.0
2011-02-11 14:00:00	NVDA	Stock	0.595	0.5968	0.592	0.5923	73104400.0
2011-02-11 15:00:00	NVDA	Stock	0.5921	0.5935	0.585	0.5868	232311280.0
2011-02-11 16:00:00	NVDA	Stock	0.5868	0.5918	0.5858	0.5918	12497120.0
2011-02-11 17:00:00	NVDA	Stock	0.5875	0.5875	0.587	0.5875	81480.0
2011-02-11 18:00:00	NVDA	Stock	0.5875	0.5878	0.578	0.585	3944440.0
2011-02-11 19:00:00	NVDA	Stock	0.5838	0.5845	0.5815	0.583	243040.0
2011-02-11 05:00:00	AMZN	Stock	9.2685	9.2685	9.2685	9.2685	2000.0
2011-02-11 07:00:00	AMZN	Stock	9.2745	9.3005	9.2745	9.295	40000.0
2011-02-11 08:00:00	AMZN	Stock	9.284	9.315	9.2815	9.2875	179020.0
2011-02-11 09:00:00	AMZN	Stock	9.2795	9.339	9.267	9.3285	10736220.0
2011-02-11 10:00:00	AMZN	Stock	9.3265	9.3535	9.276	9.35	17381960.0

> showing 50 of 44,495 rows — these rows as CSV

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