PREVIEW / stock_1hour / 2013-08-19

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-08-19.parquet
  size:    1.0 MB
  rows:    48,773
  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
2013-08-19 04:00:00	AAPL	Stock	18.0696	18.0696	18.0214	18.0214	67340.0
2013-08-19 05:00:00	AAPL	Stock	18.0196	18.0511	18.0189	18.0275	54572.0
2013-08-19 06:00:00	AAPL	Stock	18.0357	18.0518	18.0089	18.0232	274204.0
2013-08-19 07:00:00	AAPL	Stock	18.0239	18.0464	18.0004	18.0179	435680.0
2013-08-19 08:00:00	AAPL	Stock	18.0039	18.0482	17.9404	18.0286	2571408.0
2013-08-19 09:00:00	AAPL	Stock	18.0254	18.2039	18.0	18.1807	95568592.0
2013-08-19 10:00:00	AAPL	Stock	18.1818	18.3479	18.1607	18.3189	101003364.0
2013-08-19 11:00:00	AAPL	Stock	18.3189	18.3443	18.2575	18.2946	58909536.0
2013-08-19 12:00:00	AAPL	Stock	18.295	18.3257	18.2446	18.3089	37659748.0
2013-08-19 13:00:00	AAPL	Stock	18.3068	18.3411	18.2679	18.2929	33733952.0
2013-08-19 14:00:00	AAPL	Stock	18.2911	18.315	18.1857	18.2761	61907608.0
2013-08-19 15:00:00	AAPL	Stock	18.2764	18.2804	18.1329	18.1382	70647696.0
2013-08-19 16:00:00	AAPL	Stock	18.1382	18.2464	18.1271	18.1407	41817356.0
2013-08-19 17:00:00	AAPL	Stock	18.1393	18.1929	18.1336	18.1768	1208144.0
2013-08-19 18:00:00	AAPL	Stock	18.1768	18.1814	18.1621	18.1621	300132.0
2013-08-19 19:00:00	AAPL	Stock	18.1643	18.1896	18.1643	18.175	303604.0
2013-08-19 07:00:00	MSFT	Stock	31.81	31.83	31.75	31.8	900.0
2013-08-19 08:00:00	MSFT	Stock	31.74	31.74	31.74	31.74	200.0
2013-08-19 09:00:00	MSFT	Stock	31.77	31.78	31.51	31.7	4755744.0
2013-08-19 10:00:00	MSFT	Stock	31.7	31.97	31.695	31.8	4623986.0
2013-08-19 11:00:00	MSFT	Stock	31.8	31.83	31.66	31.67	3143623.0
2013-08-19 12:00:00	MSFT	Stock	31.675	31.79	31.64	31.75	1858411.0
2013-08-19 13:00:00	MSFT	Stock	31.75	31.76	31.68	31.74	1640205.0
2013-08-19 14:00:00	MSFT	Stock	31.74	31.75	31.55	31.58	2605119.0
2013-08-19 15:00:00	MSFT	Stock	31.585	31.59	31.38	31.4	6558474.0
2013-08-19 16:00:00	MSFT	Stock	31.41	31.777	31.3	31.39	1408657.0
2013-08-19 17:00:00	MSFT	Stock	31.35	31.38	31.3	31.3	425.0
2013-08-19 18:00:00	MSFT	Stock	31.39	31.4	31.39	31.4	5700.0
2013-08-19 19:00:00	MSFT	Stock	31.39	31.39	31.39	31.39	300.0
2013-08-19 09:00:00	NVDA	Stock	0.3798	0.38	0.3753	0.3764	85606880.0
2013-08-19 10:00:00	NVDA	Stock	0.3763	0.3773	0.3745	0.3753	83944960.0
2013-08-19 11:00:00	NVDA	Stock	0.3751	0.3768	0.3748	0.3748	41788920.0
2013-08-19 12:00:00	NVDA	Stock	0.3748	0.3765	0.3745	0.3761	38989840.0
2013-08-19 13:00:00	NVDA	Stock	0.3761	0.3768	0.3745	0.375	40202240.0
2013-08-19 14:00:00	NVDA	Stock	0.375	0.3753	0.374	0.3748	30310960.0
2013-08-19 15:00:00	NVDA	Stock	0.3748	0.375	0.3735	0.3736	57366320.0
2013-08-19 16:00:00	NVDA	Stock	0.3738	0.376	0.3737	0.3743	12983680.0
2013-08-19 05:00:00	AMZN	Stock	14.2495	14.2495	14.2495	14.2495	2000.0
2013-08-19 06:00:00	AMZN	Stock	14.2585	14.2585	14.2585	14.2585	2000.0
2013-08-19 07:00:00	AMZN	Stock	14.235	14.235	14.231	14.231	48000.0
2013-08-19 08:00:00	AMZN	Stock	14.2315	14.241	14.2265	14.2355	73240.0
2013-08-19 09:00:00	AMZN	Stock	14.235	14.2955	14.174	14.269	8918560.0
2013-08-19 10:00:00	AMZN	Stock	14.2685	14.478	14.2602	14.3985	12379140.0
2013-08-19 11:00:00	AMZN	Stock	14.4035	14.437	14.3865	14.4055	6273420.0
2013-08-19 12:00:00	AMZN	Stock	14.4035	14.461	14.3912	14.434	3080180.0
2013-08-19 13:00:00	AMZN	Stock	14.432	14.444	14.3815	14.403	3639100.0
2013-08-19 14:00:00	AMZN	Stock	14.4025	14.412	14.3076	14.317	5226420.0
2013-08-19 15:00:00	AMZN	Stock	14.32	14.324	14.255	14.275	8848680.0
2013-08-19 16:00:00	AMZN	Stock	14.2785	14.3536	14.27	14.2875	83720.0
2013-08-19 17:00:00	AMZN	Stock	14.2805	14.2805	14.2805	14.2805	2000.0

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

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