PREVIEW / stock_1hour / 2014-05-27

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-05-27.parquet
  size:    1.0 MB
  rows:    48,606
  symbols: 3,574

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-27 04:00:00	AAPL	Stock	21.9614	22.0732	21.9614	22.0714	79240.0
2014-05-27 05:00:00	AAPL	Stock	22.0993	22.0993	22.0575	22.0679	114884.0
2014-05-27 06:00:00	AAPL	Stock	22.0679	22.0871	22.0375	22.0714	178696.0
2014-05-27 07:00:00	AAPL	Stock	22.0779	22.0836	22.0625	22.0625	437780.0
2014-05-27 08:00:00	AAPL	Stock	22.0625	22.1061	22.0364	22.0879	1717016.0
2014-05-27 09:00:00	AAPL	Stock	22.0886	22.1746	21.9836	22.1364	66372068.0
2014-05-27 10:00:00	AAPL	Stock	22.1346	22.1949	22.1193	22.16	40370820.0
2014-05-27 11:00:00	AAPL	Stock	22.1589	22.1854	22.1282	22.1632	23701076.0
2014-05-27 12:00:00	AAPL	Stock	22.1593	22.2371	22.1521	22.2277	20464416.0
2014-05-27 13:00:00	AAPL	Stock	22.2257	22.3129	22.2179	22.3054	36473388.0
2014-05-27 14:00:00	AAPL	Stock	22.3053	22.3521	22.2996	22.3182	30026724.0
2014-05-27 15:00:00	AAPL	Stock	22.3171	22.3482	22.2964	22.3468	41510196.0
2014-05-27 16:00:00	AAPL	Stock	22.3468	22.3571	22.1519	22.3518	21402164.0
2014-05-27 17:00:00	AAPL	Stock	22.3518	22.3807	22.3518	22.3707	440160.0
2014-05-27 18:00:00	AAPL	Stock	22.3704	22.3704	22.3468	22.3679	1157912.0
2014-05-27 19:00:00	AAPL	Stock	22.3643	22.3657	22.3575	22.3657	88956.0
2014-05-27 04:00:00	MSFT	Stock	40.16	40.29	40.05	40.29	775.0
2014-05-27 07:00:00	MSFT	Stock	40.23	40.23	40.23	40.23	605.0
2014-05-27 08:00:00	MSFT	Stock	40.22	40.22	40.13	40.17	4582.0
2014-05-27 09:00:00	MSFT	Stock	40.16	40.26	39.81	39.91	3763990.0
2014-05-27 10:00:00	MSFT	Stock	39.9	40.02	39.9	39.982	2846022.0
2014-05-27 11:00:00	MSFT	Stock	39.99	40.08	39.93	39.975	2810158.0
2014-05-27 12:00:00	MSFT	Stock	39.98	40.086	39.94	39.955	2373736.0
2014-05-27 13:00:00	MSFT	Stock	39.96	40.0	39.89	39.985	1747888.0
2014-05-27 14:00:00	MSFT	Stock	39.99	39.99	39.91	39.957	1770270.0
2014-05-27 15:00:00	MSFT	Stock	39.957	40.19	39.94	40.18	4704276.0
2014-05-27 16:00:00	MSFT	Stock	40.18	40.198	39.986	40.14	4870251.0
2014-05-27 17:00:00	MSFT	Stock	40.1	40.13	40.1	40.13	400.0
2014-05-27 18:00:00	MSFT	Stock	40.06	40.06	40.05	40.06	440.0
2014-05-27 09:00:00	NVDA	Stock	0.465	0.468	0.4635	0.4666	26212920.0
2014-05-27 10:00:00	NVDA	Stock	0.4665	0.4688	0.4658	0.4683	33543560.0
2014-05-27 11:00:00	NVDA	Stock	0.4682	0.4685	0.4668	0.4675	24668680.0
2014-05-27 12:00:00	NVDA	Stock	0.4678	0.468	0.4662	0.4678	17117200.0
2014-05-27 13:00:00	NVDA	Stock	0.4678	0.4683	0.4675	0.468	24470640.0
2014-05-27 14:00:00	NVDA	Stock	0.468	0.4692	0.4675	0.4688	19791520.0
2014-05-27 15:00:00	NVDA	Stock	0.4686	0.4705	0.468	0.4705	39783000.0
2014-05-27 16:00:00	NVDA	Stock	0.4705	0.4708	0.4705	0.4706	10283040.0
2014-05-27 17:00:00	NVDA	Stock	0.4713	0.4713	0.471	0.471	70000.0
2014-05-27 04:00:00	AMZN	Stock	15.7	15.7	15.7	15.7	24000.0
2014-05-27 05:00:00	AMZN	Stock	15.73	15.745	15.73	15.745	33000.0
2014-05-27 07:00:00	AMZN	Stock	15.7435	15.7435	15.702	15.702	20000.0
2014-05-27 08:00:00	AMZN	Stock	15.7045	15.734	15.55	15.716	266160.0
2014-05-27 09:00:00	AMZN	Stock	15.716	15.7315	15.5015	15.6005	17723440.0
2014-05-27 10:00:00	AMZN	Stock	15.591	15.6344	15.4835	15.4965	11401760.0
2014-05-27 11:00:00	AMZN	Stock	15.4964	15.5235	15.4235	15.4265	25816840.0
2014-05-27 12:00:00	AMZN	Stock	15.431	15.4395	15.3751	15.407	7803620.0
2014-05-27 13:00:00	AMZN	Stock	15.4115	15.4615	15.369	15.4095	7308900.0
2014-05-27 14:00:00	AMZN	Stock	15.4	15.4245	15.3805	15.415	3726960.0
2014-05-27 15:00:00	AMZN	Stock	15.4155	15.5415	15.4125	15.5415	12204900.0
2014-05-27 16:00:00	AMZN	Stock	15.541	15.545	15.5074	15.526	3790740.0

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

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