PREVIEW / stock_1hour / 2013-06-13

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-06-13.parquet
  size:    993 KB
  rows:    45,862
  symbols: 3,488

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-06-13 04:00:00	AAPL	Stock	15.4214	15.4257	15.2696	15.3036	44044.0
2013-06-13 05:00:00	AAPL	Stock	15.2896	15.3286	15.2896	15.3286	91980.0
2013-06-13 06:00:00	AAPL	Stock	15.3896	15.3904	15.3814	15.3814	30212.0
2013-06-13 07:00:00	AAPL	Stock	15.3879	15.4096	15.3486	15.3821	417592.0
2013-06-13 08:00:00	AAPL	Stock	15.3804	15.5357	15.3482	15.52	3765104.0
2013-06-13 09:00:00	AAPL	Stock	15.5196	15.5293	15.3757	15.4579	57829324.0
2013-06-13 10:00:00	AAPL	Stock	15.4636	15.4636	15.3125	15.3671	69325452.0
2013-06-13 11:00:00	AAPL	Stock	15.3696	15.4781	15.3661	15.4643	26831840.0
2013-06-13 12:00:00	AAPL	Stock	15.4646	15.4914	15.4357	15.4911	16628780.0
2013-06-13 13:00:00	AAPL	Stock	15.4907	15.4986	15.4121	15.4493	21105616.0
2013-06-13 14:00:00	AAPL	Stock	15.4479	15.5425	15.4461	15.5293	26159924.0
2013-06-13 15:00:00	AAPL	Stock	15.5271	15.6121	15.5154	15.5714	51407020.0
2013-06-13 16:00:00	AAPL	Stock	15.568	15.5804	15.4555	15.5489	10574424.0
2013-06-13 17:00:00	AAPL	Stock	15.5529	15.5745	15.5482	15.5571	251216.0
2013-06-13 18:00:00	AAPL	Stock	15.5539	15.5643	15.5539	15.5571	134568.0
2013-06-13 19:00:00	AAPL	Stock	15.5618	15.5771	15.5593	15.5714	151004.0
2013-06-13 05:00:00	MSFT	Stock	34.74	34.74	34.7	34.7	2300.0
2013-06-13 06:00:00	MSFT	Stock	34.66	34.74	34.64	34.73	8167.0
2013-06-13 07:00:00	MSFT	Stock	34.7	34.72	34.65	34.72	7000.0
2013-06-13 08:00:00	MSFT	Stock	34.73	34.97	34.7	34.86	34607.0
2013-06-13 09:00:00	MSFT	Stock	34.86	35.03	34.61	34.649	5356855.0
2013-06-13 10:00:00	MSFT	Stock	34.65	34.79	34.59	34.72	6002338.0
2013-06-13 11:00:00	MSFT	Stock	34.72	34.75	34.65	34.71	4613429.0
2013-06-13 12:00:00	MSFT	Stock	34.71	34.75	34.65	34.69	4733000.0
2013-06-13 13:00:00	MSFT	Stock	34.69	34.7	34.63	34.67	3050711.0
2013-06-13 14:00:00	MSFT	Stock	34.67	34.78	34.67	34.73	5828289.0
2013-06-13 15:00:00	MSFT	Stock	34.735	34.78	34.7	34.71	11994699.0
2013-06-13 16:00:00	MSFT	Stock	34.71	34.786	34.66	34.72	2888179.0
2013-06-13 17:00:00	MSFT	Stock	34.7	34.727	34.68	34.727	33601.0
2013-06-13 18:00:00	MSFT	Stock	34.68	34.71	34.68	34.7	12775.0
2013-06-13 19:00:00	MSFT	Stock	34.7	34.72	34.69	34.7	6150.0
2013-06-13 09:00:00	NVDA	Stock	0.35	0.354	0.3498	0.3538	17225400.0
2013-06-13 10:00:00	NVDA	Stock	0.3538	0.357	0.3535	0.356	33925600.0
2013-06-13 11:00:00	NVDA	Stock	0.356	0.3575	0.3558	0.3574	23633680.0
2013-06-13 12:00:00	NVDA	Stock	0.3575	0.3608	0.3571	0.3608	27171720.0
2013-06-13 13:00:00	NVDA	Stock	0.3608	0.361	0.3575	0.3585	25567000.0
2013-06-13 14:00:00	NVDA	Stock	0.3585	0.3605	0.3582	0.359	15321240.0
2013-06-13 15:00:00	NVDA	Stock	0.359	0.3605	0.3585	0.3592	63097240.0
2013-06-13 16:00:00	NVDA	Stock	0.3595	0.36	0.3588	0.3592	29916040.0
2013-06-13 17:00:00	NVDA	Stock	0.3592	0.3593	0.3592	0.3593	107160.0
2013-06-13 18:00:00	NVDA	Stock	0.3592	0.3592	0.3592	0.3592	72000.0
2013-06-13 07:00:00	AMZN	Stock	13.5305	13.5305	13.518	13.522	13880.0
2013-06-13 08:00:00	AMZN	Stock	13.506	13.575	13.505	13.5625	164040.0
2013-06-13 09:00:00	AMZN	Stock	13.5695	13.6825	13.5145	13.6545	7638880.0
2013-06-13 10:00:00	AMZN	Stock	13.6556	13.69	13.5745	13.626	6435840.0
2013-06-13 11:00:00	AMZN	Stock	13.6305	13.713	13.6045	13.6915	3484780.0
2013-06-13 12:00:00	AMZN	Stock	13.6931	13.754	13.6805	13.75	4317160.0
2013-06-13 13:00:00	AMZN	Stock	13.75	13.7595	13.708	13.7295	3255040.0
2013-06-13 14:00:00	AMZN	Stock	13.7295	13.813	13.7295	13.774	16547460.0
2013-06-13 15:00:00	AMZN	Stock	13.772	13.84	13.761	13.7895	8660680.0

> showing 50 of 45,862 rows — these rows as CSV

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