PREVIEW / stock_1hour / 2016-08-03

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-08-03.parquet
  size:    1.0 MB
  rows:    48,475
  symbols: 3,248

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-03 04:00:00	AAPL	Stock	26.08	26.1175	26.08	26.08	3172.0
2016-08-03 05:00:00	AAPL	Stock	26.1175	26.15	26.1175	26.15	1600.0
2016-08-03 06:00:00	AAPL	Stock	26.15	26.165	26.135	26.135	19476.0
2016-08-03 07:00:00	AAPL	Stock	26.13	26.15	26.125	26.1325	23408.0
2016-08-03 08:00:00	AAPL	Stock	26.145	26.1975	26.12	26.1675	265164.0
2016-08-03 09:00:00	AAPL	Stock	26.1675	26.4	26.1675	26.39	21016048.0
2016-08-03 10:00:00	AAPL	Stock	26.39	26.46	26.3262	26.348	19434472.0
2016-08-03 11:00:00	AAPL	Stock	26.3488	26.3925	26.325	26.36	10208000.0
2016-08-03 12:00:00	AAPL	Stock	26.36	26.3875	26.3525	26.3725	8305316.0
2016-08-03 13:00:00	AAPL	Stock	26.3748	26.4425	26.3675	26.42	10686168.0
2016-08-03 14:00:00	AAPL	Stock	26.4175	26.4375	26.3725	26.4175	9240024.0
2016-08-03 15:00:00	AAPL	Stock	26.416	26.4575	26.4125	26.45	18806956.0
2016-08-03 16:00:00	AAPL	Stock	26.45	26.4725	26.364	26.4725	7954220.0
2016-08-03 17:00:00	AAPL	Stock	26.4625	26.4725	26.4475	26.45	4723356.0
2016-08-03 18:00:00	AAPL	Stock	26.45	26.4525	26.445	26.4475	35560.0
2016-08-03 19:00:00	AAPL	Stock	26.4475	26.48	26.445	26.47	85416.0
2016-08-03 04:00:00	MSFT	Stock	56.45	56.45	56.45	56.45	625.0
2016-08-03 06:00:00	MSFT	Stock	56.45	56.45	56.45	56.45	375.0
2016-08-03 08:00:00	MSFT	Stock	56.45	56.45	56.45	56.45	175.0
2016-08-03 09:00:00	MSFT	Stock	56.56	56.845	56.49	56.815	2376007.0
2016-08-03 10:00:00	MSFT	Stock	56.82	57.11	56.73	56.855	4042300.0
2016-08-03 11:00:00	MSFT	Stock	56.86	56.919	56.75	56.836	2687870.0
2016-08-03 12:00:00	MSFT	Stock	56.84	56.84	56.75	56.755	1526693.0
2016-08-03 13:00:00	MSFT	Stock	56.755	56.78	56.67	56.765	1784678.0
2016-08-03 14:00:00	MSFT	Stock	56.77	56.845	56.74	56.825	1923373.0
2016-08-03 15:00:00	MSFT	Stock	56.82	56.98	56.81	56.96	4644220.0
2016-08-03 16:00:00	MSFT	Stock	56.97	56.97	56.83	56.96	2099684.0
2016-08-03 17:00:00	MSFT	Stock	56.97	56.97	56.9	56.9	6586.0
2016-08-03 18:00:00	MSFT	Stock	56.9	56.9	56.9	56.9	300.0
2016-08-03 07:00:00	NVDA	Stock	1.4008	1.4008	1.4008	1.4008	19480.0
2016-08-03 08:00:00	NVDA	Stock	1.4	1.4	1.3945	1.3975	108880.0
2016-08-03 09:00:00	NVDA	Stock	1.3975	1.4075	1.3975	1.401	38891880.0
2016-08-03 10:00:00	NVDA	Stock	1.4008	1.4025	1.3915	1.3943	49224680.0
2016-08-03 11:00:00	NVDA	Stock	1.3943	1.4	1.392	1.3998	45672080.0
2016-08-03 12:00:00	NVDA	Stock	1.3995	1.4018	1.3968	1.398	16499560.0
2016-08-03 13:00:00	NVDA	Stock	1.398	1.3995	1.3943	1.3973	20743440.0
2016-08-03 14:00:00	NVDA	Stock	1.397	1.3982	1.3953	1.3958	43265840.0
2016-08-03 15:00:00	NVDA	Stock	1.3958	1.4048	1.3958	1.4045	52944560.0
2016-08-03 16:00:00	NVDA	Stock	1.4048	1.41	1.3992	1.4098	17827880.0
2016-08-03 17:00:00	NVDA	Stock	1.4048	1.4048	1.4048	1.4048	727200.0
2016-08-03 18:00:00	NVDA	Stock	1.41	1.411	1.4075	1.4075	122800.0
2016-08-03 19:00:00	NVDA	Stock	1.4088	1.4125	1.4075	1.4125	104000.0
2016-08-03 07:00:00	AMZN	Stock	37.9055	37.9055	37.9045	37.9045	7860.0
2016-08-03 08:00:00	AMZN	Stock	37.8625	37.945	37.8625	37.94	16800.0
2016-08-03 09:00:00	AMZN	Stock	37.9	37.9445	37.7592	37.8205	10239280.0
2016-08-03 10:00:00	AMZN	Stock	37.824	37.8825	37.725	37.784	11915360.0
2016-08-03 11:00:00	AMZN	Stock	37.7828	37.85	37.6125	37.845	19312600.0
2016-08-03 12:00:00	AMZN	Stock	37.842	37.842	37.65	37.702	4711540.0
2016-08-03 13:00:00	AMZN	Stock	37.703	37.74	37.65	37.6995	3589440.0
2016-08-03 14:00:00	AMZN	Stock	37.6948	37.7835	37.6948	37.765	4611780.0

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

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