PREVIEW / stock_1hour / 2014-03-31

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-03-31.parquet
  size:    1.1 MB
  rows:    50,175
  symbols: 3,565

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-03-31 04:00:00	AAPL	Stock	19.2586	19.2857	19.2586	19.2857	14000.0
2014-03-31 05:00:00	AAPL	Stock	19.2807	19.2857	19.2807	19.2857	5600.0
2014-03-31 07:00:00	AAPL	Stock	19.2875	19.2982	19.255	19.2836	242676.0
2014-03-31 08:00:00	AAPL	Stock	19.2839	19.2893	19.2379	19.2857	804384.0
2014-03-31 09:00:00	AAPL	Stock	19.2857	19.3214	19.2	19.2604	26620216.0
2014-03-31 10:00:00	AAPL	Stock	19.2621	19.2804	19.2057	19.2189	18941244.0
2014-03-31 11:00:00	AAPL	Stock	19.2157	19.2232	19.1454	19.1821	17135580.0
2014-03-31 12:00:00	AAPL	Stock	19.1843	19.2346	19.1607	19.1764	11085424.0
2014-03-31 13:00:00	AAPL	Stock	19.1764	19.1786	19.1404	19.1486	9567068.0
2014-03-31 14:00:00	AAPL	Stock	19.1518	19.2168	19.1454	19.1936	11831120.0
2014-03-31 15:00:00	AAPL	Stock	19.1946	19.2321	19.1468	19.1689	25900504.0
2014-03-31 16:00:00	AAPL	Stock	19.1693	19.2109	19.1607	19.1714	16727816.0
2014-03-31 17:00:00	AAPL	Stock	19.1786	19.1821	19.1693	19.1775	109956.0
2014-03-31 18:00:00	AAPL	Stock	19.1754	19.1821	19.1693	19.1743	1097292.0
2014-03-31 19:00:00	AAPL	Stock	19.1782	19.1786	19.1107	19.1107	280280.0
2014-03-31 05:00:00	MSFT	Stock	40.62	40.62	40.62	40.62	100.0
2014-03-31 07:00:00	MSFT	Stock	40.56	40.56	40.38	40.38	5770.0
2014-03-31 08:00:00	MSFT	Stock	40.4	40.59	40.4	40.59	11926.0
2014-03-31 09:00:00	MSFT	Stock	40.59	41.22	40.3	41.21	6005360.0
2014-03-31 10:00:00	MSFT	Stock	41.2	41.34	41.01	41.19	6812618.0
2014-03-31 11:00:00	MSFT	Stock	41.18	41.47	41.05	41.345	6111956.0
2014-03-31 12:00:00	MSFT	Stock	41.345	41.37	41.24	41.361	3378262.0
2014-03-31 13:00:00	MSFT	Stock	41.365	41.5	41.31	41.37	4429544.0
2014-03-31 14:00:00	MSFT	Stock	41.36	41.47	41.33	41.38	3422028.0
2014-03-31 15:00:00	MSFT	Stock	41.38	41.4	40.96	41.0	10702162.0
2014-03-31 16:00:00	MSFT	Stock	41.005	41.45	40.95	41.0	4616403.0
2014-03-31 17:00:00	MSFT	Stock	41.0	41.09	40.99	41.01	34111.0
2014-03-31 18:00:00	MSFT	Stock	41.01	41.05	40.99	41.01	20698.0
2014-03-31 19:00:00	MSFT	Stock	41.0	41.01	40.98	40.98	8223.0
2014-03-31 09:00:00	NVDA	Stock	0.4498	0.4522	0.4472	0.4508	27514360.0
2014-03-31 10:00:00	NVDA	Stock	0.4508	0.451	0.4451	0.448	56773160.0
2014-03-31 11:00:00	NVDA	Stock	0.4479	0.4508	0.4475	0.4501	23234520.0
2014-03-31 12:00:00	NVDA	Stock	0.4501	0.4504	0.4485	0.4491	20457400.0
2014-03-31 13:00:00	NVDA	Stock	0.449	0.45	0.4476	0.4482	17021160.0
2014-03-31 14:00:00	NVDA	Stock	0.4482	0.45	0.4482	0.4499	11885800.0
2014-03-31 15:00:00	NVDA	Stock	0.4498	0.4508	0.4478	0.448	78520360.0
2014-03-31 16:00:00	NVDA	Stock	0.4475	0.4485	0.4475	0.4479	3408640.0
2014-03-31 04:00:00	AMZN	Stock	16.9	16.97	16.9	16.97	4000.0
2014-03-31 05:00:00	AMZN	Stock	17.0325	17.0325	17.025	17.025	10000.0
2014-03-31 07:00:00	AMZN	Stock	17.0305	17.0305	17.024	17.024	12400.0
2014-03-31 08:00:00	AMZN	Stock	17.03	17.0715	16.9775	17.0715	142660.0
2014-03-31 09:00:00	AMZN	Stock	17.09	17.3145	17.09	17.151	13821840.0
2014-03-31 10:00:00	AMZN	Stock	17.15	17.241	16.988	17.0494	11637740.0
2014-03-31 11:00:00	AMZN	Stock	17.0484	17.0484	16.901	17.0151	7872920.0
2014-03-31 12:00:00	AMZN	Stock	17.0124	17.044	16.95	16.9565	3778040.0
2014-03-31 13:00:00	AMZN	Stock	16.9689	16.9689	16.7185	16.734	9207380.0
2014-03-31 14:00:00	AMZN	Stock	16.7385	16.825	16.726	16.7795	10562420.0
2014-03-31 15:00:00	AMZN	Stock	16.776	16.84	16.703	16.826	16609380.0
2014-03-31 16:00:00	AMZN	Stock	16.826	16.8294	16.795	16.826	2375540.0
2014-03-31 17:00:00	AMZN	Stock	16.826	16.826	16.814	16.814	344360.0

> showing 50 of 50,175 rows — these rows as CSV

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