PREVIEW / stock_1hour / 2014-05-05

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-05-05.parquet
  size:    1.0 MB
  rows:    49,056
  symbols: 3,547

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
2014-05-05 04:00:00	AAPL	Stock	21.1096	21.1096	21.1096	21.1096	5600.0
2014-05-05 05:00:00	AAPL	Stock	21.0396	21.0396	21.0286	21.0286	5600.0
2014-05-05 06:00:00	AAPL	Stock	21.0039	21.0357	21.0004	21.0357	12600.0
2014-05-05 07:00:00	AAPL	Stock	21.0357	21.0961	21.0179	21.0961	138320.0
2014-05-05 08:00:00	AAPL	Stock	21.0961	21.1143	21.0071	21.0839	671272.0
2014-05-05 09:00:00	AAPL	Stock	21.0804	21.2471	21.0618	21.2471	36151780.0
2014-05-05 10:00:00	AAPL	Stock	21.2471	21.3821	21.2404	21.3614	45709776.0
2014-05-05 11:00:00	AAPL	Stock	21.3582	21.3618	21.2711	21.2846	21595896.0
2014-05-05 12:00:00	AAPL	Stock	21.2861	21.3518	21.2746	21.3011	19435276.0
2014-05-05 13:00:00	AAPL	Stock	21.3011	21.39	21.3011	21.3864	19031180.0
2014-05-05 14:00:00	AAPL	Stock	21.3864	21.4054	21.3614	21.3796	28348432.0
2014-05-05 15:00:00	AAPL	Stock	21.3782	21.4643	21.375	21.4618	46185412.0
2014-05-05 16:00:00	AAPL	Stock	21.4629	21.4804	21.3255	21.475	6461280.0
2014-05-05 17:00:00	AAPL	Stock	21.4732	21.5075	21.1124	21.5075	933828.0
2014-05-05 18:00:00	AAPL	Stock	21.4629	21.5179	21.4629	21.5	308812.0
2014-05-05 19:00:00	AAPL	Stock	21.5007	21.5011	21.4929	21.4946	211652.0
2014-05-05 06:00:00	MSFT	Stock	39.69	39.69	39.69	39.69	150.0
2014-05-05 07:00:00	MSFT	Stock	39.58	39.61	39.58	39.59	1415.0
2014-05-05 08:00:00	MSFT	Stock	39.68	39.68	39.59	39.6	12830.0
2014-05-05 09:00:00	MSFT	Stock	39.6	39.63	39.3	39.43	4174312.0
2014-05-05 10:00:00	MSFT	Stock	39.43	39.64	39.36	39.48	3718591.0
2014-05-05 11:00:00	MSFT	Stock	39.48	39.5	39.37	39.42	2155717.0
2014-05-05 12:00:00	MSFT	Stock	39.43	39.44	39.34	39.35	2435208.0
2014-05-05 13:00:00	MSFT	Stock	39.35	39.42	39.33	39.4	1792953.0
2014-05-05 14:00:00	MSFT	Stock	39.41	39.47	39.38	39.43	2379922.0
2014-05-05 15:00:00	MSFT	Stock	39.43	39.48	39.4	39.43	3233928.0
2014-05-05 16:00:00	MSFT	Stock	39.43	39.45	39.35	39.35	966560.0
2014-05-05 17:00:00	MSFT	Stock	39.45	39.45	39.45	39.45	400.0
2014-05-05 18:00:00	MSFT	Stock	39.43	39.45	39.38	39.38	9271.0
2014-05-05 19:00:00	MSFT	Stock	39.44	39.44	39.3	39.4	12710.0
2014-05-05 09:00:00	NVDA	Stock	0.4578	0.465	0.4578	0.4648	24601640.0
2014-05-05 10:00:00	NVDA	Stock	0.4649	0.467	0.4643	0.4656	33698480.0
2014-05-05 11:00:00	NVDA	Stock	0.4656	0.4683	0.4638	0.4683	32403800.0
2014-05-05 12:00:00	NVDA	Stock	0.468	0.4692	0.4658	0.466	35147800.0
2014-05-05 13:00:00	NVDA	Stock	0.4659	0.4668	0.4645	0.4658	20634280.0
2014-05-05 14:00:00	NVDA	Stock	0.466	0.4665	0.4649	0.466	28450200.0
2014-05-05 15:00:00	NVDA	Stock	0.466	0.467	0.4648	0.4655	52770600.0
2014-05-05 16:00:00	NVDA	Stock	0.4658	0.4662	0.4658	0.4658	3953160.0
2014-05-05 04:00:00	AMZN	Stock	15.405	15.405	15.35	15.35	7700.0
2014-05-05 07:00:00	AMZN	Stock	15.3555	15.366	15.3	15.3055	20000.0
2014-05-05 08:00:00	AMZN	Stock	15.323	15.3485	15.291	15.32	51500.0
2014-05-05 09:00:00	AMZN	Stock	15.303	15.4715	15.25	15.4189	9834100.0
2014-05-05 10:00:00	AMZN	Stock	15.4375	15.4405	15.3345	15.3725	7495200.0
2014-05-05 11:00:00	AMZN	Stock	15.3834	15.437	15.3325	15.4295	4648760.0
2014-05-05 12:00:00	AMZN	Stock	15.4267	15.461	15.4095	15.437	3895000.0
2014-05-05 13:00:00	AMZN	Stock	15.4365	15.456	15.3915	15.443	3297100.0
2014-05-05 14:00:00	AMZN	Stock	15.4435	15.4825	15.4205	15.4635	4290060.0
2014-05-05 15:00:00	AMZN	Stock	15.4595	15.5115	15.438	15.5025	9167520.0
2014-05-05 16:00:00	AMZN	Stock	15.5025	15.5056	15.3704	15.3704	2361420.0
2014-05-05 17:00:00	AMZN	Stock	15.3705	15.513	15.3705	15.513	44120.0

> showing 50 of 49,056 rows — these rows as CSV

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