PREVIEW / stock_1hour / 2011-12-29

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-12-29.parquet
  size:    932 KB
  rows:    44,558
  symbols: 3,564

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-12-29 06:00:00	AAPL	Stock	14.3707	14.375	14.3696	14.375	35000.0
2011-12-29 07:00:00	AAPL	Stock	14.3821	14.4346	14.3821	14.4282	198212.0
2011-12-29 08:00:00	AAPL	Stock	14.4125	14.4464	14.3943	14.4175	886004.0
2011-12-29 09:00:00	AAPL	Stock	14.4111	14.4393	14.3471	14.3607	32410420.0
2011-12-29 10:00:00	AAPL	Stock	14.3646	14.3993	14.3039	14.3904	45087756.0
2011-12-29 11:00:00	AAPL	Stock	14.39	14.4529	14.3807	14.4446	27160028.0
2011-12-29 12:00:00	AAPL	Stock	14.4446	14.4589	14.4297	14.4557	14830424.0
2011-12-29 13:00:00	AAPL	Stock	14.4554	14.4643	14.4404	14.4604	18987192.0
2011-12-29 14:00:00	AAPL	Stock	14.4604	14.4746	14.4404	14.4593	16606100.0
2011-12-29 15:00:00	AAPL	Stock	14.4589	14.4875	14.4554	14.4679	40501888.0
2011-12-29 16:00:00	AAPL	Stock	14.4629	14.4707	14.3571	14.4679	6439104.0
2011-12-29 17:00:00	AAPL	Stock	14.4654	14.47	14.4643	14.47	137508.0
2011-12-29 18:00:00	AAPL	Stock	14.4668	14.4707	14.4664	14.4664	236992.0
2011-12-29 19:00:00	AAPL	Stock	14.4675	14.4679	14.4629	14.4643	180768.0
2011-12-29 07:00:00	MSFT	Stock	25.85	25.85	25.85	25.85	200.0
2011-12-29 08:00:00	MSFT	Stock	25.9	25.9	25.85	25.86	12040.0
2011-12-29 09:00:00	MSFT	Stock	25.9	26.03	25.89	25.9	2710530.0
2011-12-29 10:00:00	MSFT	Stock	25.9	26.01	25.89	25.96	4165436.0
2011-12-29 11:00:00	MSFT	Stock	25.96	25.985	25.86	25.98	2073433.0
2011-12-29 12:00:00	MSFT	Stock	25.99	26.0	25.96	25.996	1370732.0
2011-12-29 13:00:00	MSFT	Stock	25.995	26.05	25.96	25.982	2166477.0
2011-12-29 14:00:00	MSFT	Stock	25.98	26.0	25.95	25.96	1411014.0
2011-12-29 15:00:00	MSFT	Stock	25.96	26.05	25.96	26.01	6646138.0
2011-12-29 16:00:00	MSFT	Stock	26.01	26.03	25.97	25.97	1804744.0
2011-12-29 17:00:00	MSFT	Stock	25.82	26.0	25.82	25.99	1568.0
2011-12-29 18:00:00	MSFT	Stock	26.02	26.02	26.0	26.02	25174.0
2011-12-29 09:00:00	NVDA	Stock	0.3465	0.347	0.3413	0.3428	23847640.0
2011-12-29 10:00:00	NVDA	Stock	0.343	0.35	0.3428	0.3488	48484760.0
2011-12-29 11:00:00	NVDA	Stock	0.3488	0.35	0.3468	0.3494	23026400.0
2011-12-29 12:00:00	NVDA	Stock	0.3493	0.3495	0.3475	0.3475	15333680.0
2011-12-29 13:00:00	NVDA	Stock	0.3475	0.3488	0.3465	0.3471	15557840.0
2011-12-29 14:00:00	NVDA	Stock	0.347	0.3483	0.347	0.3482	21189840.0
2011-12-29 15:00:00	NVDA	Stock	0.3482	0.3494	0.3482	0.349	52884280.0
2011-12-29 16:00:00	NVDA	Stock	0.3493	0.3498	0.3473	0.3498	1976680.0
2011-12-29 17:00:00	NVDA	Stock	0.35	0.3505	0.35	0.3505	38360.0
2011-12-29 18:00:00	NVDA	Stock	0.3495	0.3498	0.3495	0.3498	20000.0
2011-12-29 19:00:00	NVDA	Stock	0.3495	0.3495	0.3495	0.3495	8000.0
2011-12-29 07:00:00	AMZN	Stock	8.716	8.716	8.7	8.7	22000.0
2011-12-29 08:00:00	AMZN	Stock	8.6975	8.701	8.476	8.5035	1869260.0
2011-12-29 09:00:00	AMZN	Stock	8.506	8.51	8.3485	8.395	37973020.0
2011-12-29 10:00:00	AMZN	Stock	8.3985	8.61	8.386	8.57	37413180.0
2011-12-29 11:00:00	AMZN	Stock	8.5685	8.6795	8.5305	8.6504	23120800.0
2011-12-29 12:00:00	AMZN	Stock	8.65	8.7275	8.6255	8.709	16152180.0
2011-12-29 13:00:00	AMZN	Stock	8.709	8.7135	8.6745	8.682	13723300.0
2011-12-29 14:00:00	AMZN	Stock	8.682	8.693	8.6445	8.668	13590320.0
2011-12-29 15:00:00	AMZN	Stock	8.6678	8.7	8.6565	8.693	16899480.0
2011-12-29 16:00:00	AMZN	Stock	8.692	8.704	8.5588	8.6995	585720.0
2011-12-29 17:00:00	AMZN	Stock	8.699	8.6995	8.693	8.698	58760.0
2011-12-29 18:00:00	AMZN	Stock	8.693	8.6955	8.693	8.695	27840.0
2011-12-29 19:00:00	AMZN	Stock	8.6985	8.7045	8.697	8.702	48560.0

> showing 50 of 44,558 rows — these rows as CSV

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