PREVIEW / stock_1hour / 2014-03-11

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-03-11.parquet
  size:    1.0 MB
  rows:    47,917
  symbols: 3,535

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-11 04:00:00	AAPL	Stock	18.9143	19.1286	18.9143	19.1075	204176.0
2014-03-11 05:00:00	AAPL	Stock	19.1057	19.1057	19.0714	19.0714	49560.0
2014-03-11 06:00:00	AAPL	Stock	19.0589	19.0946	19.0589	19.075	35000.0
2014-03-11 07:00:00	AAPL	Stock	19.0964	19.0964	19.0536	19.075	389564.0
2014-03-11 08:00:00	AAPL	Stock	19.0893	19.0914	19.0446	19.0711	1517096.0
2014-03-11 09:00:00	AAPL	Stock	19.0689	19.21	19.0689	19.1982	53427668.0
2014-03-11 10:00:00	AAPL	Stock	19.2002	19.23	19.1554	19.2268	39363016.0
2014-03-11 11:00:00	AAPL	Stock	19.2268	19.2393	19.1679	19.2214	22371664.0
2014-03-11 12:00:00	AAPL	Stock	19.2211	19.2407	19.1736	19.1864	24677156.0
2014-03-11 13:00:00	AAPL	Stock	19.1825	19.2089	19.1611	19.2054	13819736.0
2014-03-11 14:00:00	AAPL	Stock	19.2082	19.2125	19.0804	19.0877	24263316.0
2014-03-11 15:00:00	AAPL	Stock	19.0864	19.15	19.0211	19.1468	40662384.0
2014-03-11 16:00:00	AAPL	Stock	19.1461	19.1676	19.1422	19.1589	6497540.0
2014-03-11 17:00:00	AAPL	Stock	19.1571	19.1654	19.1461	19.1461	1029560.0
2014-03-11 18:00:00	AAPL	Stock	19.1461	19.1639	19.1461	19.1571	488180.0
2014-03-11 19:00:00	AAPL	Stock	19.1543	19.1607	19.1461	19.1464	93072.0
2014-03-11 07:00:00	MSFT	Stock	37.76	37.76	37.76	37.76	150.0
2014-03-11 08:00:00	MSFT	Stock	37.79	37.87	37.79	37.87	300.0
2014-03-11 09:00:00	MSFT	Stock	37.95	37.98	37.55	37.91	2304334.0
2014-03-11 10:00:00	MSFT	Stock	37.91	38.23	37.83	38.17	3738875.0
2014-03-11 11:00:00	MSFT	Stock	38.17	38.205	38.04	38.115	2927574.0
2014-03-11 12:00:00	MSFT	Stock	38.113	38.14	37.95	37.955	2172560.0
2014-03-11 13:00:00	MSFT	Stock	37.96	38.08	37.92	38.07	2057195.0
2014-03-11 14:00:00	MSFT	Stock	38.07	38.08	37.925	37.97	2502748.0
2014-03-11 15:00:00	MSFT	Stock	37.97	38.02	37.86	38.02	4698560.0
2014-03-11 16:00:00	MSFT	Stock	38.02	38.124	37.91	38.02	4003418.0
2014-03-11 17:00:00	MSFT	Stock	37.92	37.92	37.92	37.92	185.0
2014-03-11 18:00:00	MSFT	Stock	37.92	37.94	37.91	37.94	663.0
2014-03-11 19:00:00	MSFT	Stock	37.98	38.02	37.94	37.94	1000.0
2014-03-11 08:00:00	NVDA	Stock	0.4545	0.4545	0.4545	0.4545	10000.0
2014-03-11 09:00:00	NVDA	Stock	0.455	0.4572	0.453	0.4568	35017000.0
2014-03-11 10:00:00	NVDA	Stock	0.457	0.4603	0.4562	0.4595	43664840.0
2014-03-11 11:00:00	NVDA	Stock	0.4596	0.4608	0.4582	0.4584	24304640.0
2014-03-11 12:00:00	NVDA	Stock	0.4582	0.4585	0.456	0.4576	26442880.0
2014-03-11 13:00:00	NVDA	Stock	0.4575	0.4576	0.4552	0.4569	27615000.0
2014-03-11 14:00:00	NVDA	Stock	0.4569	0.4572	0.454	0.455	25568360.0
2014-03-11 15:00:00	NVDA	Stock	0.4551	0.4572	0.4545	0.457	77245920.0
2014-03-11 16:00:00	NVDA	Stock	0.4568	0.4568	0.4566	0.4568	34510920.0
2014-03-11 17:00:00	NVDA	Stock	0.4568	0.4568	0.4568	0.4568	8000.0
2014-03-11 18:00:00	NVDA	Stock	0.4532	0.4532	0.4532	0.4532	120000.0
2014-03-11 06:00:00	AMZN	Stock	18.519	18.519	18.519	18.519	3600.0
2014-03-11 07:00:00	AMZN	Stock	18.5885	18.5885	18.5885	18.5885	6000.0
2014-03-11 08:00:00	AMZN	Stock	18.5	18.533	18.5	18.5265	35460.0
2014-03-11 09:00:00	AMZN	Stock	18.559	18.6113	18.41	18.47	4840880.0
2014-03-11 10:00:00	AMZN	Stock	18.472	18.5847	18.4394	18.554	5368060.0
2014-03-11 11:00:00	AMZN	Stock	18.554	18.64	18.5465	18.62	6608560.0
2014-03-11 12:00:00	AMZN	Stock	18.624	18.624	18.506	18.506	4809140.0
2014-03-11 13:00:00	AMZN	Stock	18.505	18.5195	18.4375	18.512	3805020.0
2014-03-11 14:00:00	AMZN	Stock	18.5155	18.523	18.4005	18.413	5297740.0
2014-03-11 15:00:00	AMZN	Stock	18.4155	18.456	18.364	18.4415	7838040.0

> showing 50 of 47,917 rows — these rows as CSV

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