PREVIEW / stock_1hour / 2014-03-12

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-03-12.parquet
  size:    1.0 MB
  rows:    48,197
  symbols: 3,531

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
2014-03-12 04:00:00	AAPL	Stock	19.1446	19.1446	19.1446	19.1446	2800.0
2014-03-12 06:00:00	AAPL	Stock	19.1082	19.1082	19.0614	19.0614	30800.0
2014-03-12 07:00:00	AAPL	Stock	19.0893	19.1293	19.0893	19.1071	159600.0
2014-03-12 08:00:00	AAPL	Stock	19.0896	19.125	19.0646	19.0646	356244.0
2014-03-12 09:00:00	AAPL	Stock	19.0714	19.1389	19.0	19.017	29566432.0
2014-03-12 10:00:00	AAPL	Stock	19.0196	19.1311	19.0025	19.1311	33934012.0
2014-03-12 11:00:00	AAPL	Stock	19.1311	19.1911	19.1089	19.1346	30149756.0
2014-03-12 12:00:00	AAPL	Stock	19.1346	19.1679	19.1057	19.1593	13288604.0
2014-03-12 13:00:00	AAPL	Stock	19.1639	19.165	19.1243	19.135	12717152.0
2014-03-12 14:00:00	AAPL	Stock	19.1364	19.1457	19.0896	19.0904	12644268.0
2014-03-12 15:00:00	AAPL	Stock	19.09	19.1668	19.085	19.1643	27179852.0
2014-03-12 16:00:00	AAPL	Stock	19.1643	19.1732	19.1093	19.1693	5420520.0
2014-03-12 17:00:00	AAPL	Stock	19.1646	19.1732	19.1636	19.1646	1225140.0
2014-03-12 18:00:00	AAPL	Stock	19.1732	19.1786	19.1679	19.1786	210588.0
2014-03-12 19:00:00	AAPL	Stock	19.1786	19.1857	19.1782	19.1857	76860.0
2014-03-12 07:00:00	MSFT	Stock	37.8	37.81	37.8	37.81	1015.0
2014-03-12 08:00:00	MSFT	Stock	37.8	37.82	37.8	37.82	1100.0
2014-03-12 09:00:00	MSFT	Stock	37.84	38.0	37.44	37.9	3490086.0
2014-03-12 10:00:00	MSFT	Stock	37.9	38.21	37.87	38.17	3672803.0
2014-03-12 11:00:00	MSFT	Stock	38.17	38.35	38.164	38.215	3296207.0
2014-03-12 12:00:00	MSFT	Stock	38.21	38.31	38.09	38.31	2736831.0
2014-03-12 13:00:00	MSFT	Stock	38.31	38.34	38.14	38.323	6241074.0
2014-03-12 14:00:00	MSFT	Stock	38.32	38.43	38.3	38.31	2935076.0
2014-03-12 15:00:00	MSFT	Stock	38.315	38.34	38.2	38.26	4732105.0
2014-03-12 16:00:00	MSFT	Stock	38.26	38.32	37.96	38.21	1678696.0
2014-03-12 17:00:00	MSFT	Stock	38.27	38.28	38.27	38.28	20253.0
2014-03-12 18:00:00	MSFT	Stock	38.29	38.29	38.29	38.29	150.0
2014-03-12 19:00:00	MSFT	Stock	38.2	38.2	38.2	38.2	2000.0
2014-03-12 09:00:00	NVDA	Stock	0.455	0.4608	0.4528	0.455	35707640.0
2014-03-12 10:00:00	NVDA	Stock	0.455	0.4559	0.4532	0.4552	51208520.0
2014-03-12 11:00:00	NVDA	Stock	0.4555	0.46	0.455	0.457	29932440.0
2014-03-12 12:00:00	NVDA	Stock	0.457	0.4585	0.4565	0.4578	22039320.0
2014-03-12 13:00:00	NVDA	Stock	0.458	0.458	0.456	0.4568	12848000.0
2014-03-12 14:00:00	NVDA	Stock	0.4568	0.4593	0.4568	0.4578	18889960.0
2014-03-12 15:00:00	NVDA	Stock	0.4578	0.459	0.457	0.4579	47997360.0
2014-03-12 16:00:00	NVDA	Stock	0.458	0.4581	0.4566	0.458	1397880.0
2014-03-12 17:00:00	NVDA	Stock	0.458	0.458	0.458	0.458	54880.0
2014-03-12 19:00:00	NVDA	Stock	0.46	0.46	0.46	0.46	108000.0
2014-03-12 08:00:00	AMZN	Stock	18.415	18.415	18.3	18.325	132220.0
2014-03-12 09:00:00	AMZN	Stock	18.325	18.409	18.1805	18.233	6898920.0
2014-03-12 10:00:00	AMZN	Stock	18.2345	18.399	18.223	18.385	7540680.0
2014-03-12 11:00:00	AMZN	Stock	18.3985	18.4985	18.3665	18.423	7684840.0
2014-03-12 12:00:00	AMZN	Stock	18.4275	18.493	18.4105	18.493	4090120.0
2014-03-12 13:00:00	AMZN	Stock	18.4898	18.5325	18.429	18.529	3795440.0
2014-03-12 14:00:00	AMZN	Stock	18.528	18.547	18.478	18.478	2809460.0
2014-03-12 15:00:00	AMZN	Stock	18.4873	18.558	18.4485	18.532	5705600.0
2014-03-12 16:00:00	AMZN	Stock	18.532	18.5475	18.4062	18.5357	1580760.0
2014-03-12 17:00:00	AMZN	Stock	18.549	18.549	18.532	18.532	41620.0
2014-03-12 19:00:00	AMZN	Stock	18.5675	18.5675	18.53	18.53	40000.0
2014-03-12 04:00:00	META	Stock	70.02	70.1	69.9	70.1	2850.0

> showing 50 of 48,197 rows — these rows as CSV

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