PREVIEW / stock_1hour / 2015-10-01

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-10-01.parquet
  size:    1.0 MB
  rows:    48,162
  symbols: 3,414

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
2015-10-01 04:00:00	AAPL	Stock	27.5625	27.97	27.5625	27.775	47520.0
2015-10-01 05:00:00	AAPL	Stock	27.77	27.7975	27.7125	27.7475	38816.0
2015-10-01 06:00:00	AAPL	Stock	27.7475	27.7475	27.6125	27.625	89936.0
2015-10-01 07:00:00	AAPL	Stock	27.625	27.6375	27.2175	27.2875	1037152.0
2015-10-01 08:00:00	AAPL	Stock	27.25	27.7425	27.1125	27.125	2523444.0
2015-10-01 09:00:00	AAPL	Stock	27.125	27.575	26.925	26.9862	46335996.0
2015-10-01 10:00:00	AAPL	Stock	26.99	27.125	26.8275	26.8775	46049124.0
2015-10-01 11:00:00	AAPL	Stock	26.88	27.1575	26.85	27.06	35719640.0
2015-10-01 12:00:00	AAPL	Stock	27.0575	27.26	26.9625	27.1465	26387160.0
2015-10-01 13:00:00	AAPL	Stock	27.145	27.15	26.975	27.115	19253128.0
2015-10-01 14:00:00	AAPL	Stock	27.1175	27.3	27.085	27.2878	19428360.0
2015-10-01 15:00:00	AAPL	Stock	27.2885	27.405	27.185	27.3925	33952136.0
2015-10-01 16:00:00	AAPL	Stock	27.3925	27.4025	27.34	27.4	6174616.0
2015-10-01 17:00:00	AAPL	Stock	27.4	27.4125	27.39	27.3975	72580.0
2015-10-01 18:00:00	AAPL	Stock	27.3975	27.405	27.39	27.39	33884.0
2015-10-01 19:00:00	AAPL	Stock	27.395	27.4125	27.3825	27.41	86420.0
2015-10-01 04:00:00	MSFT	Stock	44.79	44.87	44.79	44.87	800.0
2015-10-01 05:00:00	MSFT	Stock	44.7	44.72	44.69	44.72	300.0
2015-10-01 06:00:00	MSFT	Stock	44.65	44.85	44.65	44.71	37862.0
2015-10-01 07:00:00	MSFT	Stock	44.75	44.75	44.51	44.6	23924.0
2015-10-01 08:00:00	MSFT	Stock	44.57	44.7	44.41	44.6	36447.0
2015-10-01 09:00:00	MSFT	Stock	44.56	44.76	43.84	43.87	4142462.0
2015-10-01 10:00:00	MSFT	Stock	43.88	44.36	43.87	43.97	4767079.0
2015-10-01 11:00:00	MSFT	Stock	43.97	44.18	43.87	43.955	3045041.0
2015-10-01 12:00:00	MSFT	Stock	43.95	43.95	43.75	43.875	1936067.0
2015-10-01 13:00:00	MSFT	Stock	43.87	44.13	43.77	44.11	2158886.0
2015-10-01 14:00:00	MSFT	Stock	44.1	44.44	44.07	44.41	2219302.0
2015-10-01 15:00:00	MSFT	Stock	44.41	44.63	44.195	44.61	6342671.0
2015-10-01 16:00:00	MSFT	Stock	44.61	44.88	44.25	44.8	2295708.0
2015-10-01 17:00:00	MSFT	Stock	44.8	44.85	44.75	44.75	5472.0
2015-10-01 18:00:00	MSFT	Stock	44.75	44.75	44.75	44.75	1693.0
2015-10-01 19:00:00	MSFT	Stock	44.76	44.77	44.75	44.75	1629.0
2015-10-01 08:00:00	NVDA	Stock	0.6173	0.6175	0.6105	0.6105	208000.0
2015-10-01 09:00:00	NVDA	Stock	0.6162	0.618	0.5958	0.5959	62703800.0
2015-10-01 10:00:00	NVDA	Stock	0.596	0.6018	0.593	0.5958	62842640.0
2015-10-01 11:00:00	NVDA	Stock	0.5958	0.596	0.5897	0.5903	40575960.0
2015-10-01 12:00:00	NVDA	Stock	0.5903	0.5952	0.5868	0.595	55684120.0
2015-10-01 13:00:00	NVDA	Stock	0.5948	0.6015	0.5929	0.6014	94066360.0
2015-10-01 14:00:00	NVDA	Stock	0.6015	0.6033	0.5978	0.5998	57008880.0
2015-10-01 15:00:00	NVDA	Stock	0.5999	0.6048	0.5995	0.6043	83688000.0
2015-10-01 16:00:00	NVDA	Stock	0.6043	0.606	0.6033	0.606	11837000.0
2015-10-01 04:00:00	AMZN	Stock	25.8495	25.8495	25.818	25.818	14000.0
2015-10-01 05:00:00	AMZN	Stock	25.775	25.8175	25.758	25.758	10500.0
2015-10-01 06:00:00	AMZN	Stock	25.76	25.76	25.703	25.7495	13620.0
2015-10-01 07:00:00	AMZN	Stock	25.725	25.7385	25.5795	25.5795	99900.0
2015-10-01 08:00:00	AMZN	Stock	25.577	25.7	25.4025	25.4055	204680.0
2015-10-01 09:00:00	AMZN	Stock	25.4445	25.6605	25.3	25.488	11189480.0
2015-10-01 10:00:00	AMZN	Stock	25.461	25.9575	25.405	25.7218	16052500.0
2015-10-01 11:00:00	AMZN	Stock	25.7115	25.8673	25.5757	25.6514	5416000.0
2015-10-01 12:00:00	AMZN	Stock	25.66	25.723	25.4684	25.679	6036740.0

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

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