PREVIEW / stock_1hour / 2016-02-24

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-02-24.parquet
  size:    1.0 MB
  rows:    48,511
  symbols: 3,338

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-02-24 04:00:00	AAPL	Stock	23.55	23.55	23.4975	23.4975	2392.0
2016-02-24 05:00:00	AAPL	Stock	23.5075	23.5125	23.4575	23.4575	10840.0
2016-02-24 06:00:00	AAPL	Stock	23.4575	23.475	23.35	23.375	43220.0
2016-02-24 07:00:00	AAPL	Stock	23.3725	23.445	23.3625	23.445	149824.0
2016-02-24 08:00:00	AAPL	Stock	23.4475	23.6725	23.375	23.495	595404.0
2016-02-24 09:00:00	AAPL	Stock	23.4875	23.625	23.38	23.385	21785004.0
2016-02-24 10:00:00	AAPL	Stock	23.385	23.55	23.33	23.525	21548120.0
2016-02-24 11:00:00	AAPL	Stock	23.5275	23.5825	23.3762	23.5575	12853112.0
2016-02-24 12:00:00	AAPL	Stock	23.5575	23.72	23.5525	23.6895	11772892.0
2016-02-24 13:00:00	AAPL	Stock	23.69	23.8325	23.6875	23.75	14953720.0
2016-02-24 14:00:00	AAPL	Stock	23.75	23.9375	23.7475	23.9325	14799056.0
2016-02-24 15:00:00	AAPL	Stock	23.9325	24.095	23.8975	24.025	26602876.0
2016-02-24 16:00:00	AAPL	Stock	24.025	24.0675	23.6485	24.04	7325408.0
2016-02-24 17:00:00	AAPL	Stock	24.04	24.0625	24.035	24.0525	63584.0
2016-02-24 18:00:00	AAPL	Stock	24.0525	24.0675	24.035	24.0675	81052.0
2016-02-24 19:00:00	AAPL	Stock	24.0625	24.0775	24.0525	24.07	87508.0
2016-02-24 06:00:00	MSFT	Stock	50.33	50.5	50.31	50.5	4860.0
2016-02-24 07:00:00	MSFT	Stock	50.5	50.74	50.49	50.74	48896.0
2016-02-24 08:00:00	MSFT	Stock	50.75	51.18	50.52	50.53	14943.0
2016-02-24 09:00:00	MSFT	Stock	50.55	50.73	50.3	50.385	2771435.0
2016-02-24 10:00:00	MSFT	Stock	50.38	50.72	50.2	50.66	4178574.0
2016-02-24 11:00:00	MSFT	Stock	50.67	51.01	50.46	50.85	2656859.0
2016-02-24 12:00:00	MSFT	Stock	50.85	50.93	50.64	50.836	2413281.0
2016-02-24 13:00:00	MSFT	Stock	50.84	50.99	50.72	50.789	2020550.0
2016-02-24 14:00:00	MSFT	Stock	50.8	51.22	50.735	51.213	5585802.0
2016-02-24 15:00:00	MSFT	Stock	51.22	51.5	51.18	51.355	8718342.0
2016-02-24 16:00:00	MSFT	Stock	51.36	51.75	51.31	51.75	1612828.0
2016-02-24 17:00:00	MSFT	Stock	51.74	51.95	51.36	51.84	803563.0
2016-02-24 18:00:00	MSFT	Stock	51.84	51.84	51.71	51.79	32462.0
2016-02-24 19:00:00	MSFT	Stock	51.77	51.86	51.55	51.81	36997.0
2016-02-24 08:00:00	NVDA	Stock	0.7755	0.7825	0.7755	0.7758	90000.0
2016-02-24 09:00:00	NVDA	Stock	0.79	0.79	0.7692	0.7706	40314240.0
2016-02-24 10:00:00	NVDA	Stock	0.7708	0.7775	0.765	0.7763	56348240.0
2016-02-24 11:00:00	NVDA	Stock	0.7765	0.7815	0.7702	0.7807	46409440.0
2016-02-24 12:00:00	NVDA	Stock	0.7807	0.7844	0.7806	0.782	34007040.0
2016-02-24 13:00:00	NVDA	Stock	0.7822	0.7874	0.7818	0.7868	35104680.0
2016-02-24 14:00:00	NVDA	Stock	0.7868	0.792	0.786	0.7888	39832680.0
2016-02-24 15:00:00	NVDA	Stock	0.789	0.7967	0.7889	0.7954	62423000.0
2016-02-24 16:00:00	NVDA	Stock	0.7955	0.7955	0.7952	0.7952	11187440.0
2016-02-24 17:00:00	NVDA	Stock	0.8	0.8	0.791	0.791	48000.0
2016-02-24 18:00:00	NVDA	Stock	0.8	0.8	0.8	0.8	12000.0
2016-02-24 19:00:00	NVDA	Stock	0.8	0.8	0.8	0.8	4000.0
2016-02-24 04:00:00	AMZN	Stock	27.368	27.368	27.368	27.368	2000.0
2016-02-24 05:00:00	AMZN	Stock	27.3225	27.3225	27.3125	27.3125	7800.0
2016-02-24 06:00:00	AMZN	Stock	27.362	27.362	27.325	27.325	26000.0
2016-02-24 07:00:00	AMZN	Stock	27.3255	27.3485	27.2505	27.304	87100.0
2016-02-24 08:00:00	AMZN	Stock	27.3	27.351	27.186	27.2095	385660.0
2016-02-24 09:00:00	AMZN	Stock	27.2	27.2935	26.6575	26.7955	19959660.0
2016-02-24 10:00:00	AMZN	Stock	26.8052	26.9335	26.709	26.8575	12607560.0
2016-02-24 11:00:00	AMZN	Stock	26.8645	27.05	26.7305	27.0035	10423060.0

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

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