PREVIEW / stock_1hour / 2011-01-28

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-01-28.parquet
  size:    951 KB
  rows:    45,344
  symbols: 3,520

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-01-28 07:00:00	AAPL	Stock	12.2225	12.2457	12.2082	12.245	49980.0
2011-01-28 08:00:00	AAPL	Stock	12.2411	12.2882	12.2214	12.2732	1912288.0
2011-01-28 09:00:00	AAPL	Stock	12.2654	12.3	12.2218	12.2293	40730256.0
2011-01-28 10:00:00	AAPL	Stock	12.2293	12.2339	12.1025	12.1414	116268964.0
2011-01-28 11:00:00	AAPL	Stock	12.1404	12.1493	11.9643	11.9889	109043144.0
2011-01-28 12:00:00	AAPL	Stock	11.9886	12.0586	11.9117	12.0532	104661564.0
2011-01-28 13:00:00	AAPL	Stock	12.0529	12.055	11.9825	12.0293	54354776.0
2011-01-28 14:00:00	AAPL	Stock	12.0289	12.0344	11.9968	12.0143	36997548.0
2011-01-28 15:00:00	AAPL	Stock	12.0121	12.0179	11.9771	12.0018	102973304.0
2011-01-28 16:00:00	AAPL	Stock	12.0036	12.2437	11.9821	11.9982	6335504.0
2011-01-28 17:00:00	AAPL	Stock	11.9971	11.9971	11.9761	11.9764	328272.0
2011-01-28 18:00:00	AAPL	Stock	11.9786	12.0036	11.9782	11.9839	315364.0
2011-01-28 19:00:00	AAPL	Stock	11.9786	11.98	11.9646	11.9679	527996.0
2011-01-28 04:00:00	MSFT	Stock	28.94	28.99	28.94	28.95	2136.0
2011-01-28 05:00:00	MSFT	Stock	28.95	28.95	28.95	28.95	400.0
2011-01-28 06:00:00	MSFT	Stock	28.9	28.93	28.88	28.93	7400.0
2011-01-28 07:00:00	MSFT	Stock	28.9	28.95	28.77	28.77	88484.0
2011-01-28 08:00:00	MSFT	Stock	28.78	29.0	28.76	28.95	684208.0
2011-01-28 09:00:00	MSFT	Stock	28.94	28.94	28.4	28.442	20354232.0
2011-01-28 10:00:00	MSFT	Stock	28.44	28.458	27.81	27.93	31454664.0
2011-01-28 11:00:00	MSFT	Stock	27.92	28.07	27.61	27.688	21350173.0
2011-01-28 12:00:00	MSFT	Stock	27.68	27.855	27.45	27.72	18796334.0
2011-01-28 13:00:00	MSFT	Stock	27.72	27.73	27.47	27.639	12237647.0
2011-01-28 14:00:00	MSFT	Stock	27.63	27.75	27.51	27.715	10854429.0
2011-01-28 15:00:00	MSFT	Stock	27.72	27.8	27.58	27.76	18378364.0
2011-01-28 16:00:00	MSFT	Stock	27.75	28.83	27.591	27.75	1066542.0
2011-01-28 17:00:00	MSFT	Stock	27.75	28.83	27.7	27.73	54936.0
2011-01-28 18:00:00	MSFT	Stock	27.73	27.75	27.72	27.74	39299.0
2011-01-28 19:00:00	MSFT	Stock	27.74	27.74	27.72	27.72	8300.0
2011-01-28 07:00:00	NVDA	Stock	0.6025	0.605	0.6025	0.605	16480.0
2011-01-28 08:00:00	NVDA	Stock	0.6058	0.612	0.6058	0.612	192400.0
2011-01-28 09:00:00	NVDA	Stock	0.61	0.6235	0.61	0.6162	114469880.0
2011-01-28 10:00:00	NVDA	Stock	0.6162	0.617	0.5955	0.5963	180288360.0
2011-01-28 11:00:00	NVDA	Stock	0.5963	0.5988	0.5825	0.583	232218760.0
2011-01-28 12:00:00	NVDA	Stock	0.583	0.592	0.58	0.5908	149337000.0
2011-01-28 13:00:00	NVDA	Stock	0.5908	0.5938	0.5878	0.5933	99340160.0
2011-01-28 14:00:00	NVDA	Stock	0.5933	0.6018	0.5918	0.5983	131807200.0
2011-01-28 15:00:00	NVDA	Stock	0.5981	0.5988	0.592	0.5945	166500600.0
2011-01-28 16:00:00	NVDA	Stock	0.5945	0.5994	0.5928	0.595	16535880.0
2011-01-28 17:00:00	NVDA	Stock	0.5955	0.5955	0.5938	0.595	258240.0
2011-01-28 18:00:00	NVDA	Stock	0.5948	0.5948	0.5923	0.5923	24680.0
2011-01-28 19:00:00	NVDA	Stock	0.592	0.592	0.5905	0.5905	132000.0
2011-01-28 04:00:00	AMZN	Stock	8.4275	8.4515	8.4275	8.4515	22000.0
2011-01-28 05:00:00	AMZN	Stock	8.423	8.475	8.423	8.475	38000.0
2011-01-28 06:00:00	AMZN	Stock	8.475	8.52	8.46	8.52	146400.0
2011-01-28 07:00:00	AMZN	Stock	8.4855	8.583	8.41	8.55	1680240.0
2011-01-28 08:00:00	AMZN	Stock	8.53	8.645	8.4765	8.642	9447760.0
2011-01-28 09:00:00	AMZN	Stock	8.639	8.6855	8.4655	8.5305	116585700.0
2011-01-28 10:00:00	AMZN	Stock	8.5255	8.5695	8.441	8.4765	80491140.0
2011-01-28 11:00:00	AMZN	Stock	8.4785	8.524	8.3725	8.3765	41764440.0

> showing 50 of 45,344 rows — these rows as CSV

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