PREVIEW / stock_1hour / 2014-04-07

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-04-07.parquet
  size:    1.1 MB
  rows:    49,812
  symbols: 3,551

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-04-07 04:00:00	AAPL	Stock	18.8532	18.9054	18.8532	18.9054	45080.0
2014-04-07 06:00:00	AAPL	Stock	18.9004	18.9004	18.8571	18.8571	9128.0
2014-04-07 07:00:00	AAPL	Stock	18.8671	18.8829	18.8568	18.8679	193200.0
2014-04-07 08:00:00	AAPL	Stock	18.8607	18.9282	18.8461	18.9179	641172.0
2014-04-07 09:00:00	AAPL	Stock	18.9121	18.9607	18.8082	18.9029	32418512.0
2014-04-07 10:00:00	AAPL	Stock	18.9014	18.9114	18.7554	18.7818	40087376.0
2014-04-07 11:00:00	AAPL	Stock	18.7836	18.85	18.7382	18.7529	26647180.0
2014-04-07 12:00:00	AAPL	Stock	18.7516	18.7757	18.6943	18.7232	23881284.0
2014-04-07 13:00:00	AAPL	Stock	18.7214	18.7364	18.6589	18.6625	17716580.0
2014-04-07 14:00:00	AAPL	Stock	18.6629	18.7493	18.6389	18.7271	22627444.0
2014-04-07 15:00:00	AAPL	Stock	18.7232	18.8286	18.6918	18.6981	37717624.0
2014-04-07 16:00:00	AAPL	Stock	18.6952	18.7897	18.695	18.7025	35221536.0
2014-04-07 17:00:00	AAPL	Stock	18.7043	18.7143	18.7025	18.7054	127736.0
2014-04-07 18:00:00	AAPL	Stock	18.7054	18.7079	18.6971	18.7079	26600.0
2014-04-07 19:00:00	AAPL	Stock	18.7136	18.7239	18.7136	18.7239	30800.0
2014-04-07 04:00:00	MSFT	Stock	39.87	39.87	39.87	39.87	500.0
2014-04-07 06:00:00	MSFT	Stock	39.74	39.74	39.74	39.74	490.0
2014-04-07 07:00:00	MSFT	Stock	39.73	39.73	39.7	39.7	1015.0
2014-04-07 08:00:00	MSFT	Stock	39.73	39.87	39.67	39.84	9822.0
2014-04-07 09:00:00	MSFT	Stock	39.81	40.2	39.73	40.2	5447016.0
2014-04-07 10:00:00	MSFT	Stock	40.21	40.27	39.9	39.998	6264098.0
2014-04-07 11:00:00	MSFT	Stock	40.0	40.04	39.9	39.98	3054721.0
2014-04-07 12:00:00	MSFT	Stock	39.98	40.11	39.92	40.05	2946820.0
2014-04-07 13:00:00	MSFT	Stock	40.05	40.1	39.82	39.925	2672824.0
2014-04-07 14:00:00	MSFT	Stock	39.92	40.15	39.78	40.085	3414172.0
2014-04-07 15:00:00	MSFT	Stock	40.081	40.2	39.79	39.81	8036849.0
2014-04-07 16:00:00	MSFT	Stock	39.82	39.87	39.73	39.82	3328629.0
2014-04-07 17:00:00	MSFT	Stock	39.8	39.84	39.79	39.8	1000.0
2014-04-07 18:00:00	MSFT	Stock	39.79	39.8	39.79	39.8	1022.0
2014-04-07 19:00:00	MSFT	Stock	39.84	39.84	39.8	39.8	2465.0
2014-04-07 07:00:00	NVDA	Stock	0.454	0.454	0.454	0.454	12000.0
2014-04-07 08:00:00	NVDA	Stock	0.454	0.454	0.454	0.454	8000.0
2014-04-07 09:00:00	NVDA	Stock	0.454	0.4625	0.452	0.4625	96974960.0
2014-04-07 10:00:00	NVDA	Stock	0.4625	0.464	0.4541	0.4551	52013080.0
2014-04-07 11:00:00	NVDA	Stock	0.4551	0.4578	0.4548	0.4559	33126840.0
2014-04-07 12:00:00	NVDA	Stock	0.4558	0.4595	0.4558	0.4593	42107200.0
2014-04-07 13:00:00	NVDA	Stock	0.4593	0.4595	0.4548	0.4552	26569000.0
2014-04-07 14:00:00	NVDA	Stock	0.4551	0.457	0.4515	0.456	34604360.0
2014-04-07 15:00:00	NVDA	Stock	0.456	0.4572	0.4552	0.4552	79951120.0
2014-04-07 16:00:00	NVDA	Stock	0.4552	0.4552	0.4552	0.4552	20647720.0
2014-04-07 05:00:00	AMZN	Stock	16.05	16.05	16.05	16.05	2000.0
2014-04-07 07:00:00	AMZN	Stock	16.0	16.0	15.9605	15.985	111200.0
2014-04-07 08:00:00	AMZN	Stock	15.98	16.1	15.973	16.1	245580.0
2014-04-07 09:00:00	AMZN	Stock	16.077	16.1894	15.838	16.145	19910880.0
2014-04-07 10:00:00	AMZN	Stock	16.1455	16.247	15.87	15.9395	26334420.0
2014-04-07 11:00:00	AMZN	Stock	15.945	16.066	15.783	15.783	16396560.0
2014-04-07 12:00:00	AMZN	Stock	15.781	15.892	15.7085	15.8525	13599700.0
2014-04-07 13:00:00	AMZN	Stock	15.8515	15.9	15.7305	15.7415	10712420.0
2014-04-07 14:00:00	AMZN	Stock	15.7342	15.925	15.6565	15.888	15210560.0
2014-04-07 15:00:00	AMZN	Stock	15.8838	16.068	15.852	15.888	23983600.0

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

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