PREVIEW / stock_1hour / 2015-11-23

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-11-23.parquet
  size:    1.0 MB
  rows:    48,691
  symbols: 3,412

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-11-23 04:00:00	AAPL	Stock	29.825	29.825	29.6275	29.7925	15692.0
2015-11-23 05:00:00	AAPL	Stock	29.765	29.765	29.7625	29.7625	1200.0
2015-11-23 06:00:00	AAPL	Stock	29.77	29.77	29.7425	29.7425	3908.0
2015-11-23 07:00:00	AAPL	Stock	29.7975	29.945	29.79	29.9075	80664.0
2015-11-23 08:00:00	AAPL	Stock	29.905	29.95	29.775	29.855	241184.0
2015-11-23 09:00:00	AAPL	Stock	29.8625	29.9325	29.6875	29.8675	17005100.0
2015-11-23 10:00:00	AAPL	Stock	29.865	29.8675	29.695	29.736	16229456.0
2015-11-23 11:00:00	AAPL	Stock	29.735	29.7355	29.5125	29.5575	17602892.0
2015-11-23 12:00:00	AAPL	Stock	29.5588	29.5938	29.45	29.5775	13197756.0
2015-11-23 13:00:00	AAPL	Stock	29.5762	29.6075	29.445	29.4452	11064972.0
2015-11-23 14:00:00	AAPL	Stock	29.445	29.475	29.335	29.4225	14574940.0
2015-11-23 15:00:00	AAPL	Stock	29.4238	29.5225	29.395	29.4375	16228088.0
2015-11-23 16:00:00	AAPL	Stock	29.4375	29.882	29.435	29.45	15390080.0
2015-11-23 17:00:00	AAPL	Stock	29.4575	29.4575	29.4375	29.45	47500.0
2015-11-23 18:00:00	AAPL	Stock	29.4375	29.46	29.425	29.43	20588.0
2015-11-23 19:00:00	AAPL	Stock	29.4275	29.4475	29.4075	29.42	83764.0
2015-11-23 04:00:00	MSFT	Stock	54.18	54.19	54.18	54.18	3400.0
2015-11-23 05:00:00	MSFT	Stock	54.18	54.18	54.16	54.16	3840.0
2015-11-23 06:00:00	MSFT	Stock	54.16	54.16	54.16	54.16	1760.0
2015-11-23 07:00:00	MSFT	Stock	54.17	54.37	54.17	54.31	4800.0
2015-11-23 08:00:00	MSFT	Stock	54.5	54.5	54.25	54.25	18311.0
2015-11-23 09:00:00	MSFT	Stock	54.29	54.46	54.05	54.09	2892707.0
2015-11-23 10:00:00	MSFT	Stock	54.09	54.46	54.07	54.3	3451130.0
2015-11-23 11:00:00	MSFT	Stock	54.29	54.31	54.08	54.12	2768227.0
2015-11-23 12:00:00	MSFT	Stock	54.12	54.2	54.0	54.116	3064793.0
2015-11-23 13:00:00	MSFT	Stock	54.12	54.23	54.075	54.1	2826169.0
2015-11-23 14:00:00	MSFT	Stock	54.1	54.12	53.75	53.875	3692175.0
2015-11-23 15:00:00	MSFT	Stock	53.88	54.25	53.87	54.18	5663805.0
2015-11-23 16:00:00	MSFT	Stock	54.19	54.22	54.16	54.17	2177457.0
2015-11-23 17:00:00	MSFT	Stock	54.11	54.17	54.1	54.1	896.0
2015-11-23 18:00:00	MSFT	Stock	54.17	54.25	54.17	54.25	2045.0
2015-11-23 08:00:00	NVDA	Stock	0.791	0.791	0.791	0.791	9600.0
2015-11-23 09:00:00	NVDA	Stock	0.7852	0.7912	0.773	0.7755	27398080.0
2015-11-23 10:00:00	NVDA	Stock	0.7758	0.7798	0.773	0.7753	35281400.0
2015-11-23 11:00:00	NVDA	Stock	0.775	0.777	0.7708	0.776	30291640.0
2015-11-23 12:00:00	NVDA	Stock	0.776	0.779	0.7748	0.7776	23091120.0
2015-11-23 13:00:00	NVDA	Stock	0.7775	0.7775	0.774	0.777	19590160.0
2015-11-23 14:00:00	NVDA	Stock	0.7768	0.777	0.7701	0.7718	39834160.0
2015-11-23 15:00:00	NVDA	Stock	0.7715	0.775	0.7715	0.7728	37584000.0
2015-11-23 16:00:00	NVDA	Stock	0.773	0.774	0.7728	0.774	13704960.0
2015-11-23 17:00:00	NVDA	Stock	0.773	0.773	0.773	0.773	86200.0
2015-11-23 18:00:00	NVDA	Stock	0.775	0.775	0.775	0.775	5200.0
2015-11-23 04:00:00	AMZN	Stock	33.455	33.5	33.4	33.401	39820.0
2015-11-23 05:00:00	AMZN	Stock	33.4005	33.409	33.4	33.4	14000.0
2015-11-23 07:00:00	AMZN	Stock	33.45	33.4815	33.428	33.459	39100.0
2015-11-23 08:00:00	AMZN	Stock	33.5	33.595	33.45	33.5315	329620.0
2015-11-23 09:00:00	AMZN	Stock	33.525	33.9215	33.5	33.8202	13614640.0
2015-11-23 10:00:00	AMZN	Stock	33.811	34.041	33.714	34.0194	10653760.0
2015-11-23 11:00:00	AMZN	Stock	34.0205	34.0395	33.9276	34.0325	6259760.0
2015-11-23 12:00:00	AMZN	Stock	34.0315	34.1385	33.99	34.0654	9431740.0

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

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