PREVIEW / stock_1hour / 2013-12-19

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-12-19.parquet
  size:    1.0 MB
  rows:    48,044
  symbols: 3,532

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
2013-12-19 04:00:00	AAPL	Stock	19.6786	19.7014	19.6429	19.6571	65492.0
2013-12-19 05:00:00	AAPL	Stock	19.6518	19.6518	19.6439	19.6518	38416.0
2013-12-19 06:00:00	AAPL	Stock	19.6429	19.6429	19.6232	19.6232	14000.0
2013-12-19 07:00:00	AAPL	Stock	19.6132	19.6375	19.5625	19.6314	295540.0
2013-12-19 08:00:00	AAPL	Stock	19.5982	19.6575	19.5661	19.6393	1082536.0
2013-12-19 09:00:00	AAPL	Stock	19.6314	19.65	19.4839	19.5182	44060380.0
2013-12-19 10:00:00	AAPL	Stock	19.5182	19.6225	19.4929	19.5239	57682576.0
2013-12-19 11:00:00	AAPL	Stock	19.5257	19.5746	19.5032	19.5096	30196124.0
2013-12-19 12:00:00	AAPL	Stock	19.5104	19.5196	19.4407	19.4729	36126384.0
2013-12-19 13:00:00	AAPL	Stock	19.4732	19.4925	19.4189	19.4614	27710116.0
2013-12-19 14:00:00	AAPL	Stock	19.4639	19.5261	19.4329	19.4989	23285024.0
2013-12-19 15:00:00	AAPL	Stock	19.4964	19.5025	19.4286	19.4446	34408388.0
2013-12-19 16:00:00	AAPL	Stock	19.4461	19.5445	19.4218	19.4282	16904720.0
2013-12-19 17:00:00	AAPL	Stock	19.445	19.4489	19.4036	19.4111	1152648.0
2013-12-19 18:00:00	AAPL	Stock	19.4268	19.4414	19.42	19.4393	294924.0
2013-12-19 19:00:00	AAPL	Stock	19.4364	19.4432	19.4304	19.4321	45892.0
2013-12-19 06:00:00	MSFT	Stock	36.55	36.55	36.55	36.55	200.0
2013-12-19 07:00:00	MSFT	Stock	36.53	36.54	36.53	36.54	669.0
2013-12-19 08:00:00	MSFT	Stock	36.57	36.58	36.45	36.46	6293.0
2013-12-19 09:00:00	MSFT	Stock	36.5	36.64	36.195	36.285	4250295.0
2013-12-19 10:00:00	MSFT	Stock	36.28	36.43	36.195	36.27	5315753.0
2013-12-19 11:00:00	MSFT	Stock	36.27	36.41	36.25	36.38	4022649.0
2013-12-19 12:00:00	MSFT	Stock	36.375	36.39	36.2	36.2	2770578.0
2013-12-19 13:00:00	MSFT	Stock	36.205	36.26	36.16	36.22	2972111.0
2013-12-19 14:00:00	MSFT	Stock	36.219	36.29	36.132	36.18	3857353.0
2013-12-19 15:00:00	MSFT	Stock	36.18	36.3	36.08	36.26	6901065.0
2013-12-19 16:00:00	MSFT	Stock	36.26	36.29	36.19	36.29	2911403.0
2013-12-19 17:00:00	MSFT	Stock	36.267	36.28	36.16	36.28	39141.0
2013-12-19 19:00:00	MSFT	Stock	36.26	36.26	36.26	36.26	1600.0
2013-12-19 08:00:00	NVDA	Stock	0.3828	0.3828	0.3828	0.3828	4000.0
2013-12-19 09:00:00	NVDA	Stock	0.3813	0.3835	0.38	0.3828	34227120.0
2013-12-19 10:00:00	NVDA	Stock	0.3828	0.3831	0.3805	0.3816	42090400.0
2013-12-19 11:00:00	NVDA	Stock	0.3818	0.3838	0.3814	0.3838	26222880.0
2013-12-19 12:00:00	NVDA	Stock	0.3836	0.3848	0.3833	0.3845	11613480.0
2013-12-19 13:00:00	NVDA	Stock	0.3842	0.385	0.3838	0.3844	30759920.0
2013-12-19 14:00:00	NVDA	Stock	0.3845	0.385	0.384	0.3845	15292160.0
2013-12-19 15:00:00	NVDA	Stock	0.3842	0.3848	0.3835	0.3845	49343480.0
2013-12-19 16:00:00	NVDA	Stock	0.3845	0.3845	0.3822	0.3842	12503680.0
2013-12-19 17:00:00	NVDA	Stock	0.3846	0.3846	0.3846	0.3846	12560.0
2013-12-19 19:00:00	NVDA	Stock	0.3833	0.3833	0.3833	0.3833	80000.0
2013-12-19 06:00:00	AMZN	Stock	19.7	19.7445	19.7	19.7445	6000.0
2013-12-19 07:00:00	AMZN	Stock	19.7625	19.7625	19.7625	19.7625	4000.0
2013-12-19 08:00:00	AMZN	Stock	19.77	19.775	19.7	19.715	192000.0
2013-12-19 09:00:00	AMZN	Stock	19.69	19.8475	19.654	19.7795	7129560.0
2013-12-19 10:00:00	AMZN	Stock	19.7745	19.8345	19.63	19.794	9757480.0
2013-12-19 11:00:00	AMZN	Stock	19.8005	19.825	19.7705	19.776	3524480.0
2013-12-19 12:00:00	AMZN	Stock	19.7695	19.8065	19.725	19.777	4234900.0
2013-12-19 13:00:00	AMZN	Stock	19.7925	19.8645	19.7725	19.8135	4134020.0
2013-12-19 14:00:00	AMZN	Stock	19.81	19.857	19.7725	19.8	2714120.0
2013-12-19 15:00:00	AMZN	Stock	19.789	19.803	19.7145	19.751	6711860.0

> showing 50 of 48,044 rows — these rows as CSV

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