PREVIEW / stock_1hour / 2011-12-05

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-12-05.parquet
  size:    961 KB
  rows:    46,533
  symbols: 3,534

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-05 04:00:00	AAPL	Stock	14.0179	14.0286	14.0179	14.0286	14644.0
2011-12-05 05:00:00	AAPL	Stock	14.0179	14.0179	14.0179	14.0179	12880.0
2011-12-05 06:00:00	AAPL	Stock	14.0	14.0	13.9818	13.9821	37716.0
2011-12-05 07:00:00	AAPL	Stock	13.9818	14.0357	13.9818	14.0171	250432.0
2011-12-05 08:00:00	AAPL	Stock	14.0161	14.025	13.9818	14.0032	1821540.0
2011-12-05 09:00:00	AAPL	Stock	14.0029	14.1221	14.0	14.1079	55717312.0
2011-12-05 10:00:00	AAPL	Stock	14.1068	14.1575	14.0857	14.1332	57263556.0
2011-12-05 11:00:00	AAPL	Stock	14.1325	14.1454	14.0675	14.0975	37783508.0
2011-12-05 12:00:00	AAPL	Stock	14.0986	14.1393	14.0968	14.1293	24924228.0
2011-12-05 13:00:00	AAPL	Stock	14.1293	14.1375	14.0686	14.0771	38534272.0
2011-12-05 14:00:00	AAPL	Stock	14.0768	14.0775	14.0121	14.0496	46748492.0
2011-12-05 15:00:00	AAPL	Stock	14.0471	14.0693	13.9424	14.036	76664476.0
2011-12-05 16:00:00	AAPL	Stock	14.0361	14.1215	13.9662	14.0236	4928308.0
2011-12-05 17:00:00	AAPL	Stock	14.0254	14.0518	14.0218	14.0357	3267264.0
2011-12-05 18:00:00	AAPL	Stock	14.0386	14.0386	14.0179	14.0179	122388.0
2011-12-05 19:00:00	AAPL	Stock	14.0275	14.0275	14.0007	14.0093	75236.0
2011-12-05 05:00:00	MSFT	Stock	25.45	25.55	25.45	25.55	1900.0
2011-12-05 07:00:00	MSFT	Stock	25.49	25.58	25.45	25.58	25479.0
2011-12-05 08:00:00	MSFT	Stock	25.53	25.64	25.5	25.61	74201.0
2011-12-05 09:00:00	MSFT	Stock	25.62	25.79	25.5	25.62	6730595.0
2011-12-05 10:00:00	MSFT	Stock	25.61	25.78	25.56	25.66	9935057.0
2011-12-05 11:00:00	MSFT	Stock	25.666	25.79	25.66	25.72	8234697.0
2011-12-05 12:00:00	MSFT	Stock	25.72	25.79	25.69	25.769	5609189.0
2011-12-05 13:00:00	MSFT	Stock	25.76	25.8	25.63	25.69	5520164.0
2011-12-05 14:00:00	MSFT	Stock	25.695	25.73	25.62	25.715	4204021.0
2011-12-05 15:00:00	MSFT	Stock	25.71	25.77	25.605	25.69	13060711.0
2011-12-05 16:00:00	MSFT	Stock	25.7	25.77	25.62	25.7	1598772.0
2011-12-05 17:00:00	MSFT	Stock	25.7	25.75	25.68	25.7	218887.0
2011-12-05 18:00:00	MSFT	Stock	25.7	25.7	25.68	25.69	35913.0
2011-12-05 19:00:00	MSFT	Stock	25.69	25.76	25.68	25.71	3576.0
2011-12-05 07:00:00	NVDA	Stock	0.4013	0.4022	0.4013	0.4022	72000.0
2011-12-05 08:00:00	NVDA	Stock	0.4013	0.4013	0.4	0.4008	254880.0
2011-12-05 09:00:00	NVDA	Stock	0.4008	0.4025	0.3925	0.3967	65954800.0
2011-12-05 10:00:00	NVDA	Stock	0.3965	0.3993	0.395	0.3978	78357320.0
2011-12-05 11:00:00	NVDA	Stock	0.3975	0.3982	0.395	0.396	42417880.0
2011-12-05 12:00:00	NVDA	Stock	0.396	0.3973	0.3955	0.3958	31932520.0
2011-12-05 13:00:00	NVDA	Stock	0.3958	0.3965	0.3913	0.392	54045960.0
2011-12-05 14:00:00	NVDA	Stock	0.392	0.3922	0.389	0.3901	96401720.0
2011-12-05 15:00:00	NVDA	Stock	0.3901	0.391	0.3838	0.3868	251917480.0
2011-12-05 16:00:00	NVDA	Stock	0.3868	0.3935	0.3852	0.3915	14977160.0
2011-12-05 17:00:00	NVDA	Stock	0.3862	0.3868	0.3862	0.3868	28000.0
2011-12-05 18:00:00	NVDA	Stock	0.3868	0.3868	0.3862	0.3862	80000.0
2011-12-05 19:00:00	NVDA	Stock	0.3875	0.3875	0.387	0.387	12000.0
2011-12-05 04:00:00	AMZN	Stock	9.8635	9.8635	9.8635	9.8635	2000.0
2011-12-05 06:00:00	AMZN	Stock	9.875	9.875	9.875	9.875	2000.0
2011-12-05 07:00:00	AMZN	Stock	9.9	9.9695	9.9	9.9695	141800.0
2011-12-05 08:00:00	AMZN	Stock	9.938	9.95	9.89	9.9425	410240.0
2011-12-05 09:00:00	AMZN	Stock	9.9405	9.95	9.6834	9.75	24429140.0
2011-12-05 10:00:00	AMZN	Stock	9.743	9.923	9.7325	9.861	26991740.0
2011-12-05 11:00:00	AMZN	Stock	9.861	9.885	9.8	9.8107	10960860.0

> showing 50 of 46,533 rows — these rows as CSV

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