PREVIEW / stock_1hour / 2012-01-05

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-01-05.parquet
  size:    933 KB
  rows:    44,743
  symbols: 3,515

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
2012-01-05 04:00:00	AAPL	Stock	14.7504	14.7504	14.7504	14.7504	5600.0
2012-01-05 05:00:00	AAPL	Stock	14.7339	14.7339	14.7143	14.7143	62020.0
2012-01-05 06:00:00	AAPL	Stock	14.7143	14.7143	14.6786	14.6971	46200.0
2012-01-05 07:00:00	AAPL	Stock	14.7054	14.7761	14.7054	14.7704	423948.0
2012-01-05 08:00:00	AAPL	Stock	14.7743	14.8364	14.7382	14.8204	2919728.0
2012-01-05 09:00:00	AAPL	Stock	14.8129	14.8436	14.7382	14.8046	53465412.0
2012-01-05 10:00:00	AAPL	Stock	14.8036	14.8346	14.7821	14.8071	37107364.0
2012-01-05 11:00:00	AAPL	Stock	14.8043	14.835	14.7918	14.8236	22090432.0
2012-01-05 12:00:00	AAPL	Stock	14.8236	14.8693	14.8179	14.8621	27300560.0
2012-01-05 13:00:00	AAPL	Stock	14.8629	14.9254	14.8596	14.9196	32884404.0
2012-01-05 14:00:00	AAPL	Stock	14.9223	14.9468	14.8868	14.8939	37107420.0
2012-01-05 15:00:00	AAPL	Stock	14.8941	14.9482	14.8821	14.9271	47774048.0
2012-01-05 16:00:00	AAPL	Stock	14.9304	14.9375	14.8591	14.9286	5988304.0
2012-01-05 17:00:00	AAPL	Stock	14.9286	14.9296	14.9186	14.9254	625072.0
2012-01-05 18:00:00	AAPL	Stock	14.9236	14.9325	14.9196	14.9321	82796.0
2012-01-05 19:00:00	AAPL	Stock	14.9329	14.9343	14.9143	14.9143	297220.0
2012-01-05 07:00:00	MSFT	Stock	27.11	27.31	27.11	27.3	14300.0
2012-01-05 08:00:00	MSFT	Stock	27.28	27.48	27.28	27.37	71095.0
2012-01-05 09:00:00	MSFT	Stock	27.37	27.5	27.3	27.4	6563321.0
2012-01-05 10:00:00	MSFT	Stock	27.39	27.48	27.29	27.38	8748597.0
2012-01-05 11:00:00	MSFT	Stock	27.38	27.5	27.37	27.445	7259115.0
2012-01-05 12:00:00	MSFT	Stock	27.44	27.58	27.41	27.56	7198706.0
2012-01-05 13:00:00	MSFT	Stock	27.563	27.728	27.53	27.67	6752591.0
2012-01-05 14:00:00	MSFT	Stock	27.665	27.7	27.62	27.63	4939448.0
2012-01-05 15:00:00	MSFT	Stock	27.635	27.69	27.56	27.67	11077556.0
2012-01-05 16:00:00	MSFT	Stock	27.68	27.7	27.385	27.68	1950861.0
2012-01-05 17:00:00	MSFT	Stock	27.4	27.68	27.4	27.6	247080.0
2012-01-05 18:00:00	MSFT	Stock	27.58	27.68	27.58	27.62	25617.0
2012-01-05 19:00:00	MSFT	Stock	27.62	27.67	27.59	27.67	425.0
2012-01-05 09:00:00	NVDA	Stock	0.3538	0.3585	0.3518	0.3535	40448240.0
2012-01-05 10:00:00	NVDA	Stock	0.3535	0.3572	0.3518	0.357	59295600.0
2012-01-05 11:00:00	NVDA	Stock	0.357	0.3645	0.356	0.3628	77024600.0
2012-01-05 12:00:00	NVDA	Stock	0.363	0.365	0.361	0.3648	61420360.0
2012-01-05 13:00:00	NVDA	Stock	0.3648	0.3695	0.3632	0.3678	95567840.0
2012-01-05 14:00:00	NVDA	Stock	0.3679	0.369	0.3638	0.3648	79988120.0
2012-01-05 15:00:00	NVDA	Stock	0.3649	0.3685	0.3645	0.3678	131402880.0
2012-01-05 16:00:00	NVDA	Stock	0.3679	0.3688	0.3624	0.3678	14602920.0
2012-01-05 17:00:00	NVDA	Stock	0.3678	0.3678	0.3678	0.3678	348640.0
2012-01-05 18:00:00	NVDA	Stock	0.3678	0.3678	0.3662	0.3662	218160.0
2012-01-05 04:00:00	AMZN	Stock	8.86	8.86	8.86	8.86	2000.0
2012-01-05 07:00:00	AMZN	Stock	8.813	8.85	8.805	8.8295	67600.0
2012-01-05 08:00:00	AMZN	Stock	8.8295	8.8725	8.81	8.854	279680.0
2012-01-05 09:00:00	AMZN	Stock	8.854	8.854	8.7025	8.7565	12299680.0
2012-01-05 10:00:00	AMZN	Stock	8.7525	8.8225	8.733	8.7708	12048640.0
2012-01-05 11:00:00	AMZN	Stock	8.7725	8.825	8.738	8.7955	8844840.0
2012-01-05 12:00:00	AMZN	Stock	8.798	8.817	8.7635	8.7975	6217400.0
2012-01-05 13:00:00	AMZN	Stock	8.7985	8.897	8.786	8.8755	9886700.0
2012-01-05 14:00:00	AMZN	Stock	8.8755	8.9125	8.8545	8.8715	8520880.0
2012-01-05 15:00:00	AMZN	Stock	8.8735	8.889	8.8325	8.8815	11725080.0
2012-01-05 16:00:00	AMZN	Stock	8.881	8.8845	8.8149	8.8725	2966700.0

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

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