PREVIEW / stock_1hour / 2013-06-03

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-06-03.parquet
  size:    1.0 MB
  rows:    47,273
  symbols: 3,513

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
2013-06-03 04:00:00	AAPL	Stock	16.0357	16.0357	16.0214	16.0214	19600.0
2013-06-03 05:00:00	AAPL	Stock	16.0136	16.0786	16.0136	16.0786	50400.0
2013-06-03 06:00:00	AAPL	Stock	16.0893	16.1354	16.0714	16.1354	34216.0
2013-06-03 07:00:00	AAPL	Stock	16.1357	16.1679	16.1357	16.1525	1035636.0
2013-06-03 08:00:00	AAPL	Stock	16.1443	16.1643	16.06	16.1368	3072944.0
2013-06-03 09:00:00	AAPL	Stock	16.1336	16.1557	15.8964	15.9943	70473312.0
2013-06-03 10:00:00	AAPL	Stock	15.9982	16.0582	15.88	15.8986	75994940.0
2013-06-03 11:00:00	AAPL	Stock	15.8943	15.9164	15.8029	15.8843	57708560.0
2013-06-03 12:00:00	AAPL	Stock	15.8843	15.9286	15.8157	15.9243	32254488.0
2013-06-03 13:00:00	AAPL	Stock	15.9243	15.9779	15.8914	15.9086	33151104.0
2013-06-03 14:00:00	AAPL	Stock	15.9082	15.9893	15.8989	15.9525	27241284.0
2013-06-03 15:00:00	AAPL	Stock	15.9557	16.0989	15.9464	16.0979	57454852.0
2013-06-03 16:00:00	AAPL	Stock	16.0971	16.1036	15.8446	16.0968	8902936.0
2013-06-03 17:00:00	AAPL	Stock	16.0993	16.1193	16.0979	16.1107	586236.0
2013-06-03 18:00:00	AAPL	Stock	16.1143	16.1339	16.1071	16.1314	384636.0
2013-06-03 19:00:00	AAPL	Stock	16.125	16.125	16.0982	16.1168	265160.0
2013-06-03 04:00:00	MSFT	Stock	34.85	34.85	34.85	34.85	2000.0
2013-06-03 05:00:00	MSFT	Stock	34.85	34.96	34.5	34.5	8790.0
2013-06-03 06:00:00	MSFT	Stock	34.84	34.95	34.84	34.95	2952.0
2013-06-03 07:00:00	MSFT	Stock	34.9	35.15	34.9	35.15	28170.0
2013-06-03 08:00:00	MSFT	Stock	35.11	35.15	35.01	35.05	57842.0
2013-06-03 09:00:00	MSFT	Stock	35.02	35.05	34.83	34.9	5545556.0
2013-06-03 10:00:00	MSFT	Stock	34.89	35.25	34.87	35.235	9405286.0
2013-06-03 11:00:00	MSFT	Stock	35.235	35.27	35.04	35.14	6241528.0
2013-06-03 12:00:00	MSFT	Stock	35.14	35.175	35.045	35.135	3972942.0
2013-06-03 13:00:00	MSFT	Stock	35.135	35.26	35.11	35.235	4221368.0
2013-06-03 14:00:00	MSFT	Stock	35.235	35.35	35.2	35.29	4132464.0
2013-06-03 15:00:00	MSFT	Stock	35.3	35.63	35.28	35.59	12776924.0
2013-06-03 16:00:00	MSFT	Stock	35.592	35.64	34.925	35.58	2826978.0
2013-06-03 17:00:00	MSFT	Stock	35.59	35.59	35.56	35.59	4923.0
2013-06-03 18:00:00	MSFT	Stock	35.59	35.59	35.53	35.53	5376.0
2013-06-03 19:00:00	MSFT	Stock	35.57	35.57	35.54	35.57	1500.0
2013-06-03 08:00:00	NVDA	Stock	0.36	0.36	0.36	0.36	16000.0
2013-06-03 09:00:00	NVDA	Stock	0.3602	0.365	0.3602	0.3612	51641840.0
2013-06-03 10:00:00	NVDA	Stock	0.361	0.3618	0.3572	0.358	75436520.0
2013-06-03 11:00:00	NVDA	Stock	0.358	0.3582	0.3538	0.3572	89878640.0
2013-06-03 12:00:00	NVDA	Stock	0.3572	0.3575	0.3538	0.3544	45541760.0
2013-06-03 13:00:00	NVDA	Stock	0.3545	0.3558	0.354	0.3553	36774040.0
2013-06-03 14:00:00	NVDA	Stock	0.3553	0.3592	0.3553	0.3592	52202800.0
2013-06-03 15:00:00	NVDA	Stock	0.3592	0.3614	0.359	0.3612	71654280.0
2013-06-03 16:00:00	NVDA	Stock	0.3612	0.3627	0.3598	0.3612	13746080.0
2013-06-03 17:00:00	NVDA	Stock	0.3612	0.3612	0.3612	0.3612	8000.0
2013-06-03 19:00:00	NVDA	Stock	0.36	0.36	0.36	0.36	16000.0
2013-06-03 07:00:00	AMZN	Stock	13.5425	13.55	13.5255	13.5265	73220.0
2013-06-03 08:00:00	AMZN	Stock	13.55	13.55	13.5125	13.516	210040.0
2013-06-03 09:00:00	AMZN	Stock	13.505	13.5115	13.2143	13.2825	12586300.0
2013-06-03 10:00:00	AMZN	Stock	13.282	13.348	13.2175	13.2265	9472640.0
2013-06-03 11:00:00	AMZN	Stock	13.2275	13.236	13.1475	13.183	7082600.0
2013-06-03 12:00:00	AMZN	Stock	13.1805	13.234	13.16	13.215	3805060.0
2013-06-03 13:00:00	AMZN	Stock	13.2255	13.231	13.1965	13.2115	3668100.0

> showing 50 of 47,273 rows — these rows as CSV

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