PREVIEW / stock_1hour / 2009-11-16

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-11-16.parquet
  size:    914 KB
  rows:    44,087
  symbols: 3,433

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
2009-11-16 06:00:00	AAPL	Stock	7.35	7.35	7.35	7.35	2800.0
2009-11-16 07:00:00	AAPL	Stock	7.3543	7.3568	7.3286	7.3286	637028.0
2009-11-16 08:00:00	AAPL	Stock	7.3318	7.354	7.3214	7.343	3518452.0
2009-11-16 09:00:00	AAPL	Stock	7.3425	7.4286	7.3218	7.405	96990964.0
2009-11-16 10:00:00	AAPL	Stock	7.4054	7.4286	7.3861	7.4039	90275696.0
2009-11-16 11:00:00	AAPL	Stock	7.4036	7.415	7.3964	7.4032	33315772.0
2009-11-16 12:00:00	AAPL	Stock	7.4023	7.4068	7.3714	7.4068	37375968.0
2009-11-16 13:00:00	AAPL	Stock	7.4068	7.4221	7.4021	7.4136	40257672.0
2009-11-16 14:00:00	AAPL	Stock	7.4132	7.4189	7.3893	7.3957	43942080.0
2009-11-16 15:00:00	AAPL	Stock	7.3957	7.3992	7.3414	7.3732	97079220.0
2009-11-16 16:00:00	AAPL	Stock	7.3796	7.4139	7.3682	7.3786	28249620.0
2009-11-16 17:00:00	AAPL	Stock	7.3768	7.3796	7.3729	7.3793	135324.0
2009-11-16 18:00:00	AAPL	Stock	7.3796	7.3796	7.37	7.3779	384804.0
2009-11-16 19:00:00	AAPL	Stock	7.3804	7.3811	7.375	7.3804	189588.0
2009-11-16 07:00:00	MSFT	Stock	29.76	29.81	29.64	29.81	5854.0
2009-11-16 08:00:00	MSFT	Stock	29.84	29.84	29.75	29.75	28883.0
2009-11-16 09:00:00	MSFT	Stock	29.75	29.84	29.53	29.75	5414749.0
2009-11-16 10:00:00	MSFT	Stock	29.75	29.8	29.7	29.732	6763776.0
2009-11-16 11:00:00	MSFT	Stock	29.74	29.75	29.68	29.72	5960495.0
2009-11-16 12:00:00	MSFT	Stock	29.728	29.74	29.6	29.68	7505213.0
2009-11-16 13:00:00	MSFT	Stock	29.67	29.7	29.58	29.59	5905278.0
2009-11-16 14:00:00	MSFT	Stock	29.595	29.65	29.5	29.53	5982829.0
2009-11-16 15:00:00	MSFT	Stock	29.522	29.56	29.37	29.54	11638653.0
2009-11-16 16:00:00	MSFT	Stock	29.53	29.62	29.45	29.51	1892009.0
2009-11-16 17:00:00	MSFT	Stock	29.5	29.54	29.45	29.51	10434.0
2009-11-16 18:00:00	MSFT	Stock	29.51	29.54	29.51	29.54	282551.0
2009-11-16 19:00:00	MSFT	Stock	29.5	29.5	29.46	29.5	7800.0
2009-11-16 08:00:00	NVDA	Stock	0.3405	0.3438	0.3402	0.3438	274520.0
2009-11-16 09:00:00	NVDA	Stock	0.344	0.3478	0.3402	0.3458	68037280.0
2009-11-16 10:00:00	NVDA	Stock	0.3458	0.3475	0.3433	0.346	102355280.0
2009-11-16 11:00:00	NVDA	Stock	0.346	0.3465	0.3442	0.346	44220960.0
2009-11-16 12:00:00	NVDA	Stock	0.346	0.3462	0.3442	0.3458	36602760.0
2009-11-16 13:00:00	NVDA	Stock	0.346	0.3462	0.3445	0.3458	27816760.0
2009-11-16 14:00:00	NVDA	Stock	0.346	0.3462	0.3445	0.3453	34899000.0
2009-11-16 15:00:00	NVDA	Stock	0.3455	0.3455	0.3423	0.344	75558280.0
2009-11-16 16:00:00	NVDA	Stock	0.3425	0.3451	0.3425	0.3435	2600480.0
2009-11-16 17:00:00	NVDA	Stock	0.3438	0.3438	0.3438	0.3438	39840.0
2009-11-16 18:00:00	NVDA	Stock	0.3402	0.3402	0.3402	0.3402	4000.0
2009-11-16 19:00:00	NVDA	Stock	0.343	0.343	0.343	0.343	10000.0
2009-11-16 07:00:00	AMZN	Stock	6.7	6.703	6.6595	6.6605	606000.0
2009-11-16 08:00:00	AMZN	Stock	6.6605	6.67	6.611	6.6345	1316200.0
2009-11-16 09:00:00	AMZN	Stock	6.635	6.675	6.576	6.642	30112440.0
2009-11-16 10:00:00	AMZN	Stock	6.6405	6.6735	6.633	6.6625	22806440.0
2009-11-16 11:00:00	AMZN	Stock	6.663	6.728	6.6615	6.7215	20958480.0
2009-11-16 12:00:00	AMZN	Stock	6.7205	6.7255	6.676	6.699	13445680.0
2009-11-16 13:00:00	AMZN	Stock	6.6985	6.709	6.673	6.697	10923540.0
2009-11-16 14:00:00	AMZN	Stock	6.6965	6.7145	6.651	6.6515	20400380.0
2009-11-16 15:00:00	AMZN	Stock	6.6515	6.699	6.549	6.5785	51827520.0
2009-11-16 16:00:00	AMZN	Stock	6.5785	6.677	6.5755	6.5945	4051120.0
2009-11-16 17:00:00	AMZN	Stock	6.6485	6.6485	6.5795	6.58	18120.0

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

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