PREVIEW / stock_1hour / 2012-04-12

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-04-12.parquet
  size:    950 KB
  rows:    45,667
  symbols: 3,515

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-04-12 04:00:00	AAPL	Stock	22.4643	22.4643	22.3964	22.4214	107800.0
2012-04-12 05:00:00	AAPL	Stock	22.4214	22.4332	22.3968	22.4332	58800.0
2012-04-12 06:00:00	AAPL	Stock	22.4089	22.45	22.4089	22.45	30800.0
2012-04-12 07:00:00	AAPL	Stock	22.4429	22.4857	22.375	22.4732	747516.0
2012-04-12 08:00:00	AAPL	Stock	22.4786	22.4964	22.2218	22.2971	5502868.0
2012-04-12 09:00:00	AAPL	Stock	22.2968	22.4896	22.1936	22.4293	97649720.0
2012-04-12 10:00:00	AAPL	Stock	22.4311	22.5475	22.3579	22.4714	107481780.0
2012-04-12 11:00:00	AAPL	Stock	22.475	22.4982	22.3304	22.4004	69471472.0
2012-04-12 12:00:00	AAPL	Stock	22.3968	22.4196	22.3164	22.3429	43777776.0
2012-04-12 13:00:00	AAPL	Stock	22.3429	22.3489	22.1682	22.2064	103845840.0
2012-04-12 14:00:00	AAPL	Stock	22.2057	22.3214	22.1607	22.2671	76535816.0
2012-04-12 15:00:00	AAPL	Stock	22.267	22.2889	22.1779	22.2339	92922284.0
2012-04-12 16:00:00	AAPL	Stock	22.2343	22.438	22.2043	22.2418	11675580.0
2012-04-12 17:00:00	AAPL	Stock	22.2343	22.2418	22.1918	22.2036	923104.0
2012-04-12 18:00:00	AAPL	Stock	22.2082	22.2196	22.1786	22.1839	721084.0
2012-04-12 19:00:00	AAPL	Stock	22.1796	22.2046	22.1643	22.1936	551936.0
2012-04-12 07:00:00	MSFT	Stock	30.45	30.54	30.45	30.5	9000.0
2012-04-12 08:00:00	MSFT	Stock	30.52	30.52	30.42	30.48	15287.0
2012-04-12 09:00:00	MSFT	Stock	30.48	30.7	30.34	30.64	4817691.0
2012-04-12 10:00:00	MSFT	Stock	30.64	30.98	30.53	30.88	7185787.0
2012-04-12 11:00:00	MSFT	Stock	30.88	30.96	30.83	30.95	4768346.0
2012-04-12 12:00:00	MSFT	Stock	30.96	30.99	30.88	30.935	4103875.0
2012-04-12 13:00:00	MSFT	Stock	30.93	30.99	30.89	30.96	3466072.0
2012-04-12 14:00:00	MSFT	Stock	30.95	31.03	30.94	30.995	3522807.0
2012-04-12 15:00:00	MSFT	Stock	30.995	31.04	30.97	30.99	7893918.0
2012-04-12 16:00:00	MSFT	Stock	30.975	31.04	30.34	30.98	2164062.0
2012-04-12 17:00:00	MSFT	Stock	30.99	31.0	30.7	30.98	80425.0
2012-04-12 18:00:00	MSFT	Stock	30.98	30.98	30.92	30.92	745.0
2012-04-12 19:00:00	MSFT	Stock	30.95	30.95	30.95	30.95	1600.0
2012-04-12 09:00:00	NVDA	Stock	0.359	0.3625	0.3575	0.362	25652800.0
2012-04-12 10:00:00	NVDA	Stock	0.3618	0.3655	0.361	0.3652	48012960.0
2012-04-12 11:00:00	NVDA	Stock	0.3652	0.3678	0.365	0.3667	58175840.0
2012-04-12 12:00:00	NVDA	Stock	0.3668	0.369	0.366	0.3686	31208560.0
2012-04-12 13:00:00	NVDA	Stock	0.3688	0.3688	0.3665	0.3671	46810160.0
2012-04-12 14:00:00	NVDA	Stock	0.367	0.3679	0.367	0.367	52810920.0
2012-04-12 15:00:00	NVDA	Stock	0.3672	0.368	0.3668	0.3669	106142000.0
2012-04-12 16:00:00	NVDA	Stock	0.367	0.3687	0.365	0.366	6306520.0
2012-04-12 17:00:00	NVDA	Stock	0.367	0.367	0.367	0.367	163200.0
2012-04-12 07:00:00	AMZN	Stock	9.45	9.45	9.425	9.45	20000.0
2012-04-12 08:00:00	AMZN	Stock	9.4645	9.499	9.373	9.3875	479220.0
2012-04-12 09:00:00	AMZN	Stock	9.398	9.51	9.2805	9.4475	16072400.0
2012-04-12 10:00:00	AMZN	Stock	9.449	9.613	9.4386	9.549	18382160.0
2012-04-12 11:00:00	AMZN	Stock	9.5504	9.5595	9.51	9.5375	8024620.0
2012-04-12 12:00:00	AMZN	Stock	9.5366	9.542	9.4885	9.541	7696740.0
2012-04-12 13:00:00	AMZN	Stock	9.5395	9.546	9.45	9.4685	7006900.0
2012-04-12 14:00:00	AMZN	Stock	9.467	9.5415	9.4625	9.5325	5559320.0
2012-04-12 15:00:00	AMZN	Stock	9.5324	9.5725	9.5285	9.529	15099800.0
2012-04-12 16:00:00	AMZN	Stock	9.5345	9.5845	9.461	9.515	539420.0
2012-04-12 17:00:00	AMZN	Stock	9.5345	9.5345	9.5025	9.5025	82820.0
2012-04-12 18:00:00	AMZN	Stock	9.5125	9.525	9.5125	9.525	8000.0

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

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