PREVIEW / stock_1hour / 2014-03-13

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-03-13.parquet
  size:    1.0 MB
  rows:    49,093
  symbols: 3,538

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-13 04:00:00	AAPL	Stock	19.1857	19.1857	19.1857	19.1857	14000.0
2014-03-13 05:00:00	AAPL	Stock	19.2061	19.2061	19.1796	19.1796	5600.0
2014-03-13 07:00:00	AAPL	Stock	19.2	19.2357	19.2	19.2236	152600.0
2014-03-13 08:00:00	AAPL	Stock	19.2064	19.2286	19.19	19.2064	669256.0
2014-03-13 09:00:00	AAPL	Stock	19.2046	19.2475	19.1089	19.2311	33925416.0
2014-03-13 10:00:00	AAPL	Stock	19.2307	19.2736	19.1361	19.1679	36344504.0
2014-03-13 11:00:00	AAPL	Stock	19.1707	19.185	19.0714	19.085	21603176.0
2014-03-13 12:00:00	AAPL	Stock	19.0864	19.0971	18.9736	18.985	30020312.0
2014-03-13 13:00:00	AAPL	Stock	18.9821	19.0168	18.9043	18.9736	33317088.0
2014-03-13 14:00:00	AAPL	Stock	18.9675	18.9907	18.9364	18.9558	18871412.0
2014-03-13 15:00:00	AAPL	Stock	18.9564	18.9779	18.8986	18.9532	32555292.0
2014-03-13 16:00:00	AAPL	Stock	18.9518	19.1299	18.8929	18.915	9509024.0
2014-03-13 17:00:00	AAPL	Stock	18.9161	18.9264	18.8412	18.8996	107240.0
2014-03-13 18:00:00	AAPL	Stock	18.9	18.9021	18.8875	18.8939	132860.0
2014-03-13 19:00:00	AAPL	Stock	18.9018	18.9118	18.8929	18.9057	113428.0
2014-03-13 06:00:00	MSFT	Stock	38.29	38.29	38.29	38.29	930.0
2014-03-13 08:00:00	MSFT	Stock	38.38	38.38	38.27	38.38	4104.0
2014-03-13 09:00:00	MSFT	Stock	38.37	38.45	38.3	38.33	2289445.0
2014-03-13 10:00:00	MSFT	Stock	38.34	38.38	38.14	38.2	3982962.0
2014-03-13 11:00:00	MSFT	Stock	38.195	38.21	38.01	38.095	4345578.0
2014-03-13 12:00:00	MSFT	Stock	38.095	38.11	37.82	37.88	4308577.0
2014-03-13 13:00:00	MSFT	Stock	37.88	37.9	37.69	37.744	4278057.0
2014-03-13 14:00:00	MSFT	Stock	37.74	37.92	37.641	37.83	4120620.0
2014-03-13 15:00:00	MSFT	Stock	37.83	37.91	37.73	37.91	6270079.0
2014-03-13 16:00:00	MSFT	Stock	37.89	37.953	37.81	37.89	1323682.0
2014-03-13 17:00:00	MSFT	Stock	37.89	38.27	37.89	37.9	1726.0
2014-03-13 09:00:00	NVDA	Stock	0.459	0.4608	0.4576	0.4593	19696440.0
2014-03-13 10:00:00	NVDA	Stock	0.4593	0.46	0.4532	0.454	36834640.0
2014-03-13 11:00:00	NVDA	Stock	0.454	0.4545	0.4502	0.451	32546840.0
2014-03-13 12:00:00	NVDA	Stock	0.451	0.4515	0.445	0.4453	53138200.0
2014-03-13 13:00:00	NVDA	Stock	0.4452	0.4465	0.4412	0.4438	59496840.0
2014-03-13 14:00:00	NVDA	Stock	0.4438	0.4468	0.443	0.4445	57544040.0
2014-03-13 15:00:00	NVDA	Stock	0.4446	0.4455	0.443	0.4435	89970440.0
2014-03-13 16:00:00	NVDA	Stock	0.4435	0.4452	0.4434	0.4434	25037280.0
2014-03-13 06:00:00	AMZN	Stock	18.582	18.582	18.582	18.582	2000.0
2014-03-13 07:00:00	AMZN	Stock	18.597	18.6425	18.5885	18.6295	102400.0
2014-03-13 08:00:00	AMZN	Stock	18.603	18.976	18.475	18.913	1776580.0
2014-03-13 09:00:00	AMZN	Stock	18.925	19.05	18.7925	19.049	28494280.0
2014-03-13 10:00:00	AMZN	Stock	19.05	19.1555	18.89	18.9968	22605440.0
2014-03-13 11:00:00	AMZN	Stock	18.9918	19.037	18.8635	18.915	13025680.0
2014-03-13 12:00:00	AMZN	Stock	18.915	18.9265	18.6775	18.713	14788080.0
2014-03-13 13:00:00	AMZN	Stock	18.7125	18.7785	18.59	18.6605	15230820.0
2014-03-13 14:00:00	AMZN	Stock	18.6629	18.6995	18.5425	18.5555	10978260.0
2014-03-13 15:00:00	AMZN	Stock	18.56	18.599	18.404	18.5755	19962540.0
2014-03-13 16:00:00	AMZN	Stock	18.5715	18.8868	18.5555	18.8	1498600.0
2014-03-13 17:00:00	AMZN	Stock	18.7755	18.827	18.7665	18.7665	232000.0
2014-03-13 18:00:00	AMZN	Stock	18.76	18.76	18.5755	18.75	52200.0
2014-03-13 19:00:00	AMZN	Stock	18.74	18.775	18.74	18.7565	24440.0
2014-03-13 04:00:00	META	Stock	71.15	71.45	71.15	71.3	1300.0
2014-03-13 05:00:00	META	Stock	71.1	71.1	71.1	71.1	400.0

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

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