PREVIEW / stock_1hour / 2010-03-17

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-03-17.parquet
  size:    911 KB
  rows:    43,277
  symbols: 3,473

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
2010-03-17 04:00:00	AAPL	Stock	8.0221	8.025	8.0221	8.025	16800.0
2010-03-17 05:00:00	AAPL	Stock	8.0214	8.0339	8.0211	8.0339	67200.0
2010-03-17 07:00:00	AAPL	Stock	8.0357	8.0389	8.0304	8.0321	40404.0
2010-03-17 08:00:00	AAPL	Stock	8.0329	8.0357	8.0143	8.0289	1233064.0
2010-03-17 09:00:00	AAPL	Stock	8.0321	8.0875	8.0218	8.0768	69905024.0
2010-03-17 10:00:00	AAPL	Stock	8.0775	8.0832	8.0596	8.0725	56035336.0
2010-03-17 11:00:00	AAPL	Stock	8.0725	8.075	8.0607	8.0689	31859212.0
2010-03-17 12:00:00	AAPL	Stock	8.0696	8.0739	8.0604	8.0675	25543812.0
2010-03-17 13:00:00	AAPL	Stock	8.0675	8.0704	8.0418	8.0521	32784528.0
2010-03-17 14:00:00	AAPL	Stock	8.0525	8.0536	7.9814	7.9839	84936124.0
2010-03-17 15:00:00	AAPL	Stock	7.985	8.0107	7.9739	8.0025	87182620.0
2010-03-17 16:00:00	AAPL	Stock	8.0029	8.0707	7.9961	7.9982	7321748.0
2010-03-17 17:00:00	AAPL	Stock	7.9982	8.0036	7.9943	7.9964	446264.0
2010-03-17 18:00:00	AAPL	Stock	8.0018	8.0043	7.9948	8.0029	123088.0
2010-03-17 19:00:00	AAPL	Stock	8.0	8.0079	7.9968	8.0079	508872.0
2010-03-17 07:00:00	MSFT	Stock	29.5	29.5	29.45	29.46	900.0
2010-03-17 08:00:00	MSFT	Stock	29.41	29.45	29.39	29.45	23415.0
2010-03-17 09:00:00	MSFT	Stock	29.45	29.69	29.4	29.64	6172100.0
2010-03-17 10:00:00	MSFT	Stock	29.638	29.785	29.62	29.672	9559599.0
2010-03-17 11:00:00	MSFT	Stock	29.67	29.73	29.56	29.62	6450938.0
2010-03-17 12:00:00	MSFT	Stock	29.63	29.745	29.61	29.72	3685949.0
2010-03-17 13:00:00	MSFT	Stock	29.72	29.87	29.71	29.8	5196715.0
2010-03-17 14:00:00	MSFT	Stock	29.8	29.822	29.55	29.58	8785933.0
2010-03-17 15:00:00	MSFT	Stock	29.58	29.66	29.53	29.63	8128573.0
2010-03-17 16:00:00	MSFT	Stock	29.64	29.684	29.535	29.63	1069037.0
2010-03-17 17:00:00	MSFT	Stock	29.37	29.63	29.37	29.63	300.0
2010-03-17 18:00:00	MSFT	Stock	29.59	29.63	29.59	29.59	10700.0
2010-03-17 19:00:00	MSFT	Stock	29.59	29.63	29.53	29.53	668.0
2010-03-17 08:00:00	NVDA	Stock	0.4462	0.4462	0.4455	0.4462	48000.0
2010-03-17 09:00:00	NVDA	Stock	0.4462	0.4535	0.4462	0.4492	95626840.0
2010-03-17 10:00:00	NVDA	Stock	0.4495	0.4538	0.4492	0.453	127893480.0
2010-03-17 11:00:00	NVDA	Stock	0.4532	0.4542	0.4508	0.4518	62080400.0
2010-03-17 12:00:00	NVDA	Stock	0.452	0.4535	0.4512	0.4522	64529080.0
2010-03-17 13:00:00	NVDA	Stock	0.4523	0.4585	0.4522	0.457	111339440.0
2010-03-17 14:00:00	NVDA	Stock	0.4568	0.4575	0.4518	0.452	60063960.0
2010-03-17 15:00:00	NVDA	Stock	0.452	0.4538	0.451	0.4525	106754520.0
2010-03-17 16:00:00	NVDA	Stock	0.4522	0.4528	0.4515	0.4525	6595760.0
2010-03-17 17:00:00	NVDA	Stock	0.4525	0.4525	0.4525	0.4525	17000.0
2010-03-17 18:00:00	NVDA	Stock	0.4525	0.4525	0.4525	0.4525	15358640.0
2010-03-17 19:00:00	NVDA	Stock	0.455	0.455	0.455	0.455	32000.0
2010-03-17 08:00:00	AMZN	Stock	6.6345	6.6345	6.608	6.6125	30100.0
2010-03-17 09:00:00	AMZN	Stock	6.6145	6.625	6.57	6.5855	12631280.0
2010-03-17 10:00:00	AMZN	Stock	6.5855	6.6347	6.581	6.615	14561080.0
2010-03-17 11:00:00	AMZN	Stock	6.616	6.633	6.607	6.621	8213120.0
2010-03-17 12:00:00	AMZN	Stock	6.62	6.6315	6.615	6.628	5541300.0
2010-03-17 13:00:00	AMZN	Stock	6.628	6.632	6.617	6.6275	6506320.0
2010-03-17 14:00:00	AMZN	Stock	6.6265	6.628	6.5805	6.588	12883920.0
2010-03-17 15:00:00	AMZN	Stock	6.5885	6.597	6.561	6.57	21774000.0
2010-03-17 16:00:00	AMZN	Stock	6.5705	6.6156	6.5685	6.5695	307960.0
2010-03-17 17:00:00	AMZN	Stock	6.5895	6.5895	6.589	6.589	10000.0

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

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