PREVIEW / stock_1hour / 2010-09-01

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-09-01.parquet
  size:    941 KB
  rows:    45,390
  symbols: 3,483

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-09-01 05:00:00	AAPL	Stock	8.7679	8.7679	8.7571	8.7571	42000.0
2010-09-01 06:00:00	AAPL	Stock	8.7554	8.7754	8.7554	8.7714	44800.0
2010-09-01 07:00:00	AAPL	Stock	8.7679	8.7857	8.7575	8.7775	556668.0
2010-09-01 08:00:00	AAPL	Stock	8.775	8.8157	8.6821	8.7921	4267228.0
2010-09-01 09:00:00	AAPL	Stock	8.7943	8.8561	8.7893	8.8357	79349228.0
2010-09-01 10:00:00	AAPL	Stock	8.8339	8.9339	8.8279	8.9268	134401596.0
2010-09-01 11:00:00	AAPL	Stock	8.9261	8.9786	8.9254	8.9714	79349732.0
2010-09-01 12:00:00	AAPL	Stock	8.9714	8.9739	8.9393	8.9418	60090800.0
2010-09-01 13:00:00	AAPL	Stock	8.9418	8.9807	8.9225	8.9461	113658076.0
2010-09-01 14:00:00	AAPL	Stock	8.9468	8.9589	8.8829	8.9039	103434996.0
2010-09-01 15:00:00	AAPL	Stock	8.9043	8.9464	8.8886	8.9382	96916372.0
2010-09-01 16:00:00	AAPL	Stock	8.9393	8.955	8.9171	8.9375	20742568.0
2010-09-01 17:00:00	AAPL	Stock	8.9542	8.9542	8.9357	8.9446	2278248.0
2010-09-01 18:00:00	AAPL	Stock	8.9421	8.9571	8.9421	8.9464	445396.0
2010-09-01 19:00:00	AAPL	Stock	8.9443	8.9532	8.9393	8.95	561288.0
2010-09-01 07:00:00	MSFT	Stock	23.75	23.79	23.7	23.71	10702.0
2010-09-01 08:00:00	MSFT	Stock	23.78	23.78	23.48	23.74	53327.0
2010-09-01 09:00:00	MSFT	Stock	23.75	23.89	23.54	23.565	9667664.0
2010-09-01 10:00:00	MSFT	Stock	23.62	23.93	23.58	23.89	13725703.0
2010-09-01 11:00:00	MSFT	Stock	23.89	23.91	23.81	23.81	5871186.0
2010-09-01 12:00:00	MSFT	Stock	23.82	23.83	23.76	23.79	5143829.0
2010-09-01 13:00:00	MSFT	Stock	23.795	23.84	23.75	23.83	5610193.0
2010-09-01 14:00:00	MSFT	Stock	23.835	23.85	23.77	23.821	5941143.0
2010-09-01 15:00:00	MSFT	Stock	23.82	23.95	23.8	23.92	13918567.0
2010-09-01 16:00:00	MSFT	Stock	23.91	23.95	23.782	23.9	4328847.0
2010-09-01 17:00:00	MSFT	Stock	23.849	23.96	23.849	23.96	283721.0
2010-09-01 18:00:00	MSFT	Stock	23.94	23.96	23.92	23.96	4950.0
2010-09-01 19:00:00	MSFT	Stock	23.9	23.99	23.9	23.96	135801.0
2010-09-01 07:00:00	NVDA	Stock	0.2358	0.2368	0.2358	0.2368	24000.0
2010-09-01 08:00:00	NVDA	Stock	0.236	0.2375	0.2358	0.2375	138320.0
2010-09-01 09:00:00	NVDA	Stock	0.2372	0.238	0.2336	0.2354	96714560.0
2010-09-01 10:00:00	NVDA	Stock	0.236	0.2398	0.2355	0.238	175510200.0
2010-09-01 11:00:00	NVDA	Stock	0.238	0.239	0.2378	0.238	126298280.0
2010-09-01 12:00:00	NVDA	Stock	0.2381	0.2382	0.235	0.2361	92083600.0
2010-09-01 13:00:00	NVDA	Stock	0.2362	0.2372	0.236	0.2368	52047920.0
2010-09-01 14:00:00	NVDA	Stock	0.2365	0.237	0.2355	0.2355	77710280.0
2010-09-01 15:00:00	NVDA	Stock	0.2358	0.2365	0.235	0.235	205682960.0
2010-09-01 16:00:00	NVDA	Stock	0.235	0.2382	0.235	0.2355	23219920.0
2010-09-01 17:00:00	NVDA	Stock	0.2355	0.2355	0.2352	0.2355	1418360.0
2010-09-01 18:00:00	NVDA	Stock	0.2355	0.2355	0.2355	0.2355	8680.0
2010-09-01 19:00:00	NVDA	Stock	0.236	0.236	0.2358	0.2358	16000.0
2010-09-01 05:00:00	AMZN	Stock	6.275	6.275	6.275	6.275	2000.0
2010-09-01 06:00:00	AMZN	Stock	6.2985	6.2985	6.2985	6.2985	2000.0
2010-09-01 07:00:00	AMZN	Stock	6.2755	6.2755	6.2755	6.2755	2000.0
2010-09-01 08:00:00	AMZN	Stock	6.2775	6.3	6.2415	6.297	107440.0
2010-09-01 09:00:00	AMZN	Stock	6.299	6.387	6.2905	6.385	13049100.0
2010-09-01 10:00:00	AMZN	Stock	6.3845	6.561	6.3805	6.547	35324820.0
2010-09-01 11:00:00	AMZN	Stock	6.547	6.5585	6.512	6.528	16107100.0
2010-09-01 12:00:00	AMZN	Stock	6.5305	6.5415	6.5175	6.5326	8120840.0
2010-09-01 13:00:00	AMZN	Stock	6.532	6.5424	6.522	6.5295	7508860.0

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

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