PREVIEW / stock_1hour / 2011-02-28

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-02-28.parquet
  size:    968 KB
  rows:    45,431
  symbols: 3,560

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-28 04:00:00	AAPL	Stock	12.5	12.5821	12.5	12.5821	68600.0
2011-02-28 05:00:00	AAPL	Stock	12.5643	12.5793	12.4464	12.575	48020.0
2011-02-28 06:00:00	AAPL	Stock	12.5732	12.5889	12.5714	12.5889	44800.0
2011-02-28 07:00:00	AAPL	Stock	12.5804	12.5804	12.5186	12.5468	647052.0
2011-02-28 08:00:00	AAPL	Stock	12.5464	12.5786	12.5421	12.5482	2849224.0
2011-02-28 09:00:00	AAPL	Stock	12.5475	12.6804	12.5386	12.6407	95145568.0
2011-02-28 10:00:00	AAPL	Stock	12.64	12.6561	12.5925	12.6157	65657088.0
2011-02-28 11:00:00	AAPL	Stock	12.6157	12.6286	12.5739	12.6107	42413280.0
2011-02-28 12:00:00	AAPL	Stock	12.61	12.6307	12.5643	12.575	33394592.0
2011-02-28 13:00:00	AAPL	Stock	12.5739	12.5839	12.5482	12.5528	31708572.0
2011-02-28 14:00:00	AAPL	Stock	12.5496	12.6157	12.545	12.6043	35081732.0
2011-02-28 15:00:00	AAPL	Stock	12.6036	12.6261	12.5807	12.6246	57675660.0
2011-02-28 16:00:00	AAPL	Stock	12.6221	12.6427	12.4343	12.62	26956496.0
2011-02-28 17:00:00	AAPL	Stock	12.6189	12.6357	12.6071	12.6357	534072.0
2011-02-28 18:00:00	AAPL	Stock	12.635	12.6411	12.6146	12.6393	348208.0
2011-02-28 19:00:00	AAPL	Stock	12.6418	12.6429	12.6375	12.6429	418432.0
2011-02-28 04:00:00	MSFT	Stock	26.6	26.6	26.6	26.6	200.0
2011-02-28 07:00:00	MSFT	Stock	26.6	26.68	26.52	26.59	7892.0
2011-02-28 08:00:00	MSFT	Stock	26.65	26.65	26.6	26.62	25789.0
2011-02-28 09:00:00	MSFT	Stock	26.63	26.86	26.6	26.75	6688777.0
2011-02-28 10:00:00	MSFT	Stock	26.75	26.79	26.71	26.78	7357766.0
2011-02-28 11:00:00	MSFT	Stock	26.79	26.8	26.62	26.63	5059560.0
2011-02-28 12:00:00	MSFT	Stock	26.62	26.67	26.54	26.6	5645742.0
2011-02-28 13:00:00	MSFT	Stock	26.59	26.62	26.51	26.548	4501826.0
2011-02-28 14:00:00	MSFT	Stock	26.54	26.61	26.53	26.59	4083992.0
2011-02-28 15:00:00	MSFT	Stock	26.59	26.64	26.525	26.58	10092773.0
2011-02-28 16:00:00	MSFT	Stock	26.58	26.69	26.55	26.593	6878363.0
2011-02-28 17:00:00	MSFT	Stock	26.6	26.65	26.58	26.65	18875.0
2011-02-28 18:00:00	MSFT	Stock	26.61	26.65	26.58	26.58	13541.0
2011-02-28 07:00:00	NVDA	Stock	0.58	0.582	0.5762	0.582	68000.0
2011-02-28 08:00:00	NVDA	Stock	0.58	0.5885	0.58	0.5863	3443680.0
2011-02-28 09:00:00	NVDA	Stock	0.5863	0.59	0.5775	0.5798	91543560.0
2011-02-28 10:00:00	NVDA	Stock	0.5798	0.5808	0.5662	0.573	172279320.0
2011-02-28 11:00:00	NVDA	Stock	0.573	0.5738	0.5655	0.569	120289720.0
2011-02-28 12:00:00	NVDA	Stock	0.569	0.5692	0.5618	0.562	82486560.0
2011-02-28 13:00:00	NVDA	Stock	0.5621	0.5625	0.5535	0.5538	147444480.0
2011-02-28 14:00:00	NVDA	Stock	0.5538	0.564	0.5535	0.5635	123734400.0
2011-02-28 15:00:00	NVDA	Stock	0.5635	0.5665	0.5608	0.5662	123952040.0
2011-02-28 16:00:00	NVDA	Stock	0.5665	0.5682	0.5622	0.5668	34063040.0
2011-02-28 17:00:00	NVDA	Stock	0.5645	0.567	0.5632	0.5645	505920.0
2011-02-28 18:00:00	NVDA	Stock	0.565	0.565	0.5648	0.5648	63360.0
2011-02-28 19:00:00	NVDA	Stock	0.5645	0.5662	0.5642	0.5662	110120.0
2011-02-28 04:00:00	AMZN	Stock	8.794	8.824	8.7485	8.765	334000.0
2011-02-28 05:00:00	AMZN	Stock	8.75	8.766	8.7	8.7275	71600.0
2011-02-28 06:00:00	AMZN	Stock	8.7075	8.725	8.654	8.697	162540.0
2011-02-28 07:00:00	AMZN	Stock	8.7035	8.745	8.656	8.7405	375960.0
2011-02-28 08:00:00	AMZN	Stock	8.747	8.75	8.685	8.718	803680.0
2011-02-28 09:00:00	AMZN	Stock	8.718	8.7945	8.6855	8.714	26184800.0
2011-02-28 10:00:00	AMZN	Stock	8.715	8.728	8.6625	8.696	26574500.0
2011-02-28 11:00:00	AMZN	Stock	8.6965	8.698	8.6475	8.6485	11560320.0

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

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