PREVIEW / stock_1hour / 2012-08-31

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-08-31.parquet
  size:    926 KB
  rows:    43,514
  symbols: 3,455

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
2012-08-31 04:00:00	AAPL	Stock	23.6436	23.6457	23.6229	23.6229	31024.0
2012-08-31 05:00:00	AAPL	Stock	23.6214	23.675	23.6214	23.675	39480.0
2012-08-31 06:00:00	AAPL	Stock	23.6786	23.6954	23.6786	23.6954	9800.0
2012-08-31 07:00:00	AAPL	Stock	23.75	23.8214	23.7464	23.8136	630224.0
2012-08-31 08:00:00	AAPL	Stock	23.8125	23.8571	23.7857	23.8393	2634296.0
2012-08-31 09:00:00	AAPL	Stock	23.8389	23.8571	23.7186	23.735	40120108.0
2012-08-31 10:00:00	AAPL	Stock	23.735	23.8114	23.4732	23.8057	104989220.0
2012-08-31 11:00:00	AAPL	Stock	23.8071	23.8786	23.7143	23.7257	51089528.0
2012-08-31 12:00:00	AAPL	Stock	23.7214	23.7582	23.655	23.7257	28154504.0
2012-08-31 13:00:00	AAPL	Stock	23.7243	23.7389	23.6293	23.6718	23186912.0
2012-08-31 14:00:00	AAPL	Stock	23.6697	23.75	23.6546	23.725	22254008.0
2012-08-31 15:00:00	AAPL	Stock	23.7282	23.775	23.6789	23.7579	46797324.0
2012-08-31 16:00:00	AAPL	Stock	23.7474	23.7669	23.7139	23.7532	14644336.0
2012-08-31 17:00:00	AAPL	Stock	23.7518	23.7589	23.7507	23.7521	171864.0
2012-08-31 18:00:00	AAPL	Stock	23.7521	23.7618	23.7464	23.7536	191576.0
2012-08-31 19:00:00	AAPL	Stock	23.7536	23.76	23.75	23.75	153888.0
2012-08-31 06:00:00	MSFT	Stock	30.4	30.4	30.4	30.4	100.0
2012-08-31 07:00:00	MSFT	Stock	30.54	30.54	30.53	30.53	200.0
2012-08-31 08:00:00	MSFT	Stock	30.5	30.59	30.32	30.57	59600.0
2012-08-31 09:00:00	MSFT	Stock	30.56	30.73	30.32	30.615	3020737.0
2012-08-31 10:00:00	MSFT	Stock	30.61	30.8	30.38	30.78	7533967.0
2012-08-31 11:00:00	MSFT	Stock	30.79	30.909	30.77	30.88	6203445.0
2012-08-31 12:00:00	MSFT	Stock	30.87	30.96	30.73	30.79	3394170.0
2012-08-31 13:00:00	MSFT	Stock	30.79	30.815	30.69	30.81	2553496.0
2012-08-31 14:00:00	MSFT	Stock	30.81	30.96	30.8	30.935	3053735.0
2012-08-31 15:00:00	MSFT	Stock	30.93	30.94	30.755	30.81	6837058.0
2012-08-31 16:00:00	MSFT	Stock	30.815	30.912	30.767	30.83	3224781.0
2012-08-31 17:00:00	MSFT	Stock	30.82	30.82	30.817	30.82	24910.0
2012-08-31 18:00:00	MSFT	Stock	30.79	30.8	30.79	30.8	2500.0
2012-08-31 19:00:00	MSFT	Stock	30.8	30.8	30.79	30.8	3900.0
2012-08-31 08:00:00	NVDA	Stock	0.3542	0.3553	0.354	0.3553	284000.0
2012-08-31 09:00:00	NVDA	Stock	0.3535	0.3562	0.3513	0.3518	34737920.0
2012-08-31 10:00:00	NVDA	Stock	0.352	0.3528	0.3473	0.3525	104140680.0
2012-08-31 11:00:00	NVDA	Stock	0.3524	0.3533	0.351	0.351	46519720.0
2012-08-31 12:00:00	NVDA	Stock	0.351	0.3513	0.348	0.3488	49192960.0
2012-08-31 13:00:00	NVDA	Stock	0.3488	0.3493	0.3473	0.3475	48708400.0
2012-08-31 14:00:00	NVDA	Stock	0.3475	0.3482	0.3473	0.348	61478920.0
2012-08-31 15:00:00	NVDA	Stock	0.348	0.3518	0.3473	0.3508	100657880.0
2012-08-31 16:00:00	NVDA	Stock	0.3505	0.351	0.3496	0.3496	13980280.0
2012-08-31 17:00:00	NVDA	Stock	0.3507	0.3507	0.3507	0.3507	720000.0
2012-08-31 19:00:00	NVDA	Stock	0.3522	0.3522	0.3522	0.3522	8000.0
2012-08-31 06:00:00	AMZN	Stock	12.3775	12.3775	12.3775	12.3775	2000.0
2012-08-31 07:00:00	AMZN	Stock	12.385	12.43	12.385	12.43	86280.0
2012-08-31 08:00:00	AMZN	Stock	12.4035	12.4485	12.4035	12.434	340680.0
2012-08-31 09:00:00	AMZN	Stock	12.445	12.4725	12.3267	12.3305	12687840.0
2012-08-31 10:00:00	AMZN	Stock	12.327	12.41	12.275	12.394	14922740.0
2012-08-31 11:00:00	AMZN	Stock	12.3955	12.4195	12.3755	12.384	7733980.0
2012-08-31 12:00:00	AMZN	Stock	12.382	12.3984	12.351	12.398	5698320.0
2012-08-31 13:00:00	AMZN	Stock	12.396	12.429	12.355	12.424	3991720.0
2012-08-31 14:00:00	AMZN	Stock	12.4245	12.4575	12.3966	12.4325	4499260.0

> showing 50 of 43,514 rows — these rows as CSV

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