PREVIEW / stock_1hour / 2016-08-29

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-08-29.parquet
  size:    1.0 MB
  rows:    48,376
  symbols: 3,259

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
2016-08-29 04:00:00	AAPL	Stock	26.675	26.675	26.64	26.675	1200.0
2016-08-29 06:00:00	AAPL	Stock	26.6675	26.7025	26.6675	26.7025	4732.0
2016-08-29 07:00:00	AAPL	Stock	26.7	26.7275	26.7	26.725	54956.0
2016-08-29 08:00:00	AAPL	Stock	26.7325	26.775	26.6775	26.74	124324.0
2016-08-29 09:00:00	AAPL	Stock	26.735	26.7675	26.5725	26.705	13210640.0
2016-08-29 10:00:00	AAPL	Stock	26.7025	26.75	26.64	26.64	11972736.0
2016-08-29 11:00:00	AAPL	Stock	26.6425	26.7075	26.625	26.6925	10105120.0
2016-08-29 12:00:00	AAPL	Stock	26.6925	26.8575	26.6855	26.8425	13073892.0
2016-08-29 13:00:00	AAPL	Stock	26.845	26.86	26.7675	26.7925	12390308.0
2016-08-29 14:00:00	AAPL	Stock	26.7925	26.8025	26.6825	26.716	8414748.0
2016-08-29 15:00:00	AAPL	Stock	26.7175	26.7225	26.675	26.705	12156692.0
2016-08-29 16:00:00	AAPL	Stock	26.705	26.72	26.695	26.6975	11524760.0
2016-08-29 17:00:00	AAPL	Stock	26.7	26.705	26.6525	26.6525	542608.0
2016-08-29 18:00:00	AAPL	Stock	26.6525	26.6725	26.63	26.6525	34332.0
2016-08-29 19:00:00	AAPL	Stock	26.6625	26.6625	26.65	26.655	16676.0
2016-08-29 05:00:00	MSFT	Stock	57.99	58.07	57.99	58.07	2036.0
2016-08-29 06:00:00	MSFT	Stock	58.08	58.08	58.08	58.08	100.0
2016-08-29 08:00:00	MSFT	Stock	58.08	58.08	58.05	58.08	10900.0
2016-08-29 09:00:00	MSFT	Stock	58.1	58.6	58.1	58.48	2427090.0
2016-08-29 10:00:00	MSFT	Stock	58.485	58.5	58.29	58.306	1848339.0
2016-08-29 11:00:00	MSFT	Stock	58.31	58.467	58.24	58.463	1736505.0
2016-08-29 12:00:00	MSFT	Stock	58.46	58.48	58.28	58.34	1054764.0
2016-08-29 13:00:00	MSFT	Stock	58.34	58.35	58.26	58.305	991989.0
2016-08-29 14:00:00	MSFT	Stock	58.305	58.34	58.24	58.27	1046662.0
2016-08-29 15:00:00	MSFT	Stock	58.27	58.27	58.1	58.1	2484322.0
2016-08-29 16:00:00	MSFT	Stock	58.1	58.22	58.05	58.13	3678308.0
2016-08-29 17:00:00	MSFT	Stock	58.12	58.12	58.1	58.12	159898.0
2016-08-29 18:00:00	MSFT	Stock	58.12	58.12	58.12	58.12	2450.0
2016-08-29 19:00:00	MSFT	Stock	58.2	58.2	58.2	58.2	3000.0
2016-08-29 06:00:00	NVDA	Stock	1.57	1.57	1.57	1.57	4000.0
2016-08-29 07:00:00	NVDA	Stock	1.562	1.5668	1.5595	1.5668	50000.0
2016-08-29 08:00:00	NVDA	Stock	1.556	1.556	1.556	1.556	32000.0
2016-08-29 09:00:00	NVDA	Stock	1.5588	1.5648	1.5492	1.5563	31873040.0
2016-08-29 10:00:00	NVDA	Stock	1.5563	1.557	1.5471	1.553	45909360.0
2016-08-29 11:00:00	NVDA	Stock	1.553	1.5599	1.5524	1.556	37310120.0
2016-08-29 12:00:00	NVDA	Stock	1.556	1.5615	1.554	1.5575	32712840.0
2016-08-29 13:00:00	NVDA	Stock	1.5575	1.5605	1.5568	1.5605	22038680.0
2016-08-29 14:00:00	NVDA	Stock	1.5604	1.5608	1.5528	1.5535	20975480.0
2016-08-29 15:00:00	NVDA	Stock	1.5535	1.554	1.549	1.5498	39109240.0
2016-08-29 16:00:00	NVDA	Stock	1.5498	1.5573	1.5492	1.55	1297360.0
2016-08-29 17:00:00	NVDA	Stock	1.549	1.5498	1.5488	1.549	483600.0
2016-08-29 18:00:00	NVDA	Stock	1.549	1.55	1.549	1.55	127440.0
2016-08-29 19:00:00	NVDA	Stock	1.55	1.55	1.548	1.548	54000.0
2016-08-29 04:00:00	AMZN	Stock	38.473	38.473	38.473	38.473	2000.0
2016-08-29 08:00:00	AMZN	Stock	38.45	38.4695	38.43	38.4675	77240.0
2016-08-29 09:00:00	AMZN	Stock	38.4675	38.6395	38.43	38.6	8095580.0
2016-08-29 10:00:00	AMZN	Stock	38.5995	38.7115	38.5625	38.5705	7296900.0
2016-08-29 11:00:00	AMZN	Stock	38.5785	38.6915	38.559	38.665	3996180.0
2016-08-29 12:00:00	AMZN	Stock	38.6689	38.711	38.626	38.6811	3826700.0
2016-08-29 13:00:00	AMZN	Stock	38.681	38.749	38.663	38.7235	3210000.0

> showing 50 of 48,376 rows — these rows as CSV

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