PREVIEW / stock_1hour / 2011-05-20

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-05-20.parquet
  size:    923 KB
  rows:    43,544
  symbols: 3,534

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-05-20 04:00:00	AAPL	Stock	12.1664	12.1664	12.1664	12.1664	2800.0
2011-05-20 05:00:00	AAPL	Stock	12.1643	12.1643	12.1429	12.1429	14000.0
2011-05-20 07:00:00	AAPL	Stock	12.1429	12.165	12.1346	12.1346	75320.0
2011-05-20 08:00:00	AAPL	Stock	12.1375	12.1618	12.1286	12.1429	309316.0
2011-05-20 09:00:00	AAPL	Stock	12.1432	12.1768	12.0986	12.1114	45343368.0
2011-05-20 10:00:00	AAPL	Stock	12.1114	12.1286	12.0368	12.0618	63158676.0
2011-05-20 11:00:00	AAPL	Stock	12.0618	12.0907	12.0536	12.0643	31195024.0
2011-05-20 12:00:00	AAPL	Stock	12.0643	12.1029	12.0507	12.0764	34823628.0
2011-05-20 13:00:00	AAPL	Stock	12.075	12.1061	12.075	12.0876	26760020.0
2011-05-20 14:00:00	AAPL	Stock	12.0879	12.09	12.0071	12.0075	30574908.0
2011-05-20 15:00:00	AAPL	Stock	12.0071	12.0296	11.965	11.9696	87985828.0
2011-05-20 16:00:00	AAPL	Stock	11.9725	12.0655	11.9607	11.9639	9547552.0
2011-05-20 17:00:00	AAPL	Stock	11.9643	11.9679	11.96	11.9679	245476.0
2011-05-20 18:00:00	AAPL	Stock	11.9646	12.0	11.9646	11.965	156268.0
2011-05-20 19:00:00	AAPL	Stock	11.9643	11.9704	11.9607	11.9625	68208.0
2011-05-20 07:00:00	MSFT	Stock	24.7	24.7	24.65	24.65	200.0
2011-05-20 08:00:00	MSFT	Stock	24.61	24.7	24.61	24.7	1400.0
2011-05-20 09:00:00	MSFT	Stock	24.7	24.87	24.66	24.765	6385046.0
2011-05-20 10:00:00	MSFT	Stock	24.765	24.77	24.62	24.67	7763041.0
2011-05-20 11:00:00	MSFT	Stock	24.67	24.69	24.53	24.54	4712462.0
2011-05-20 12:00:00	MSFT	Stock	24.54	24.698	24.52	24.61	4875871.0
2011-05-20 13:00:00	MSFT	Stock	24.615	24.74	24.61	24.698	4071416.0
2011-05-20 14:00:00	MSFT	Stock	24.7	24.71	24.62	24.63	2842139.0
2011-05-20 15:00:00	MSFT	Stock	24.63	24.64	24.44	24.49	12144989.0
2011-05-20 16:00:00	MSFT	Stock	24.5	24.635	24.4	24.45	1849326.0
2011-05-20 17:00:00	MSFT	Stock	24.45	24.45	24.42	24.44	7403.0
2011-05-20 18:00:00	MSFT	Stock	24.43	24.49	24.43	24.45	19117.0
2011-05-20 19:00:00	MSFT	Stock	24.46	24.46	24.45	24.46	3813.0
2011-05-20 08:00:00	NVDA	Stock	0.4445	0.4445	0.4415	0.4415	184800.0
2011-05-20 09:00:00	NVDA	Stock	0.444	0.4522	0.4415	0.4492	89667120.0
2011-05-20 10:00:00	NVDA	Stock	0.4494	0.4495	0.4415	0.4445	97493200.0
2011-05-20 11:00:00	NVDA	Stock	0.4443	0.4482	0.444	0.4464	56085720.0
2011-05-20 12:00:00	NVDA	Stock	0.4462	0.4508	0.4462	0.4485	57594040.0
2011-05-20 13:00:00	NVDA	Stock	0.4485	0.4512	0.4482	0.4498	34879680.0
2011-05-20 14:00:00	NVDA	Stock	0.4496	0.453	0.4488	0.4512	89318160.0
2011-05-20 15:00:00	NVDA	Stock	0.4512	0.4532	0.451	0.452	137437880.0
2011-05-20 16:00:00	NVDA	Stock	0.4515	0.4527	0.4502	0.4527	1576160.0
2011-05-20 17:00:00	NVDA	Stock	0.4512	0.4512	0.4512	0.4512	40000.0
2011-05-20 19:00:00	NVDA	Stock	0.4508	0.4522	0.4508	0.451	116000.0
2011-05-20 08:00:00	AMZN	Stock	9.925	9.938	9.91	9.915	29100.0
2011-05-20 09:00:00	AMZN	Stock	9.92	9.99	9.875	9.931	13405240.0
2011-05-20 10:00:00	AMZN	Stock	9.931	9.9455	9.862	9.8791	10739400.0
2011-05-20 11:00:00	AMZN	Stock	9.8796	9.912	9.876	9.8925	6204880.0
2011-05-20 12:00:00	AMZN	Stock	9.8945	9.951	9.8905	9.924	5952360.0
2011-05-20 13:00:00	AMZN	Stock	9.923	9.966	9.9225	9.9475	8289200.0
2011-05-20 14:00:00	AMZN	Stock	9.948	9.9585	9.9148	9.92	5712280.0
2011-05-20 15:00:00	AMZN	Stock	9.918	9.9515	9.91	9.929	14886920.0
2011-05-20 16:00:00	AMZN	Stock	9.9315	9.9315	9.9	9.92	653580.0
2011-05-20 17:00:00	AMZN	Stock	9.92	9.92	9.8875	9.8995	45020.0
2011-05-20 18:00:00	AMZN	Stock	9.9325	9.9325	9.8995	9.8995	6400.0

> showing 50 of 43,544 rows — these rows as CSV

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