PREVIEW / stock_1hour / 2016-08-04

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-08-04.parquet
  size:    1.1 MB
  rows:    48,872
  symbols: 3,250

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-04 04:00:00	AAPL	Stock	26.355	26.395	26.355	26.375	18800.0
2016-08-04 05:00:00	AAPL	Stock	26.3725	26.3725	26.325	26.3375	15600.0
2016-08-04 06:00:00	AAPL	Stock	26.3325	26.375	26.3325	26.36	43280.0
2016-08-04 07:00:00	AAPL	Stock	26.36	26.4125	26.35	26.38	149000.0
2016-08-04 08:00:00	AAPL	Stock	26.3825	26.4225	26.3325	26.385	567092.0
2016-08-04 09:00:00	AAPL	Stock	26.385	26.5	26.3275	26.38	21132024.0
2016-08-04 10:00:00	AAPL	Stock	26.3775	26.465	26.32	26.45	18109332.0
2016-08-04 11:00:00	AAPL	Stock	26.45	26.48	26.38	26.4275	11260108.0
2016-08-04 12:00:00	AAPL	Stock	26.4285	26.45	26.3925	26.4065	6433528.0
2016-08-04 13:00:00	AAPL	Stock	26.405	26.455	26.385	26.4462	7047920.0
2016-08-04 14:00:00	AAPL	Stock	26.4462	26.475	26.3925	26.4622	9153676.0
2016-08-04 15:00:00	AAPL	Stock	26.46	26.5	26.425	26.4725	14953664.0
2016-08-04 16:00:00	AAPL	Stock	26.4675	26.4775	26.4575	26.4575	4180052.0
2016-08-04 17:00:00	AAPL	Stock	26.4625	26.4675	26.395	26.455	761556.0
2016-08-04 18:00:00	AAPL	Stock	26.455	26.475	26.455	26.4625	53248.0
2016-08-04 19:00:00	AAPL	Stock	26.47	26.47	26.4625	26.47	36932.0
2016-08-04 07:00:00	MSFT	Stock	56.99	57.03	56.92	56.96	1520.0
2016-08-04 08:00:00	MSFT	Stock	56.95	56.99	56.92	56.92	1900.0
2016-08-04 09:00:00	MSFT	Stock	56.96	56.97	56.67	56.81	1920012.0
2016-08-04 10:00:00	MSFT	Stock	56.815	57.13	56.79	57.12	2547153.0
2016-08-04 11:00:00	MSFT	Stock	57.12	57.29	57.07	57.27	2790777.0
2016-08-04 12:00:00	MSFT	Stock	57.27	57.519	57.26	57.42	3329099.0
2016-08-04 13:00:00	MSFT	Stock	57.425	57.46	57.305	57.36	2759452.0
2016-08-04 14:00:00	MSFT	Stock	57.37	57.48	57.34	57.465	3154950.0
2016-08-04 15:00:00	MSFT	Stock	57.465	57.51	57.34	57.39	6026070.0
2016-08-04 16:00:00	MSFT	Stock	57.39	57.54	57.39	57.54	1750909.0
2016-08-04 17:00:00	MSFT	Stock	57.45	57.45	56.825	56.825	4400.0
2016-08-04 18:00:00	MSFT	Stock	57.48	57.48	57.45	57.45	350.0
2016-08-04 19:00:00	MSFT	Stock	57.45	57.45	57.45	57.45	505.0
2016-08-04 06:00:00	NVDA	Stock	1.4128	1.4128	1.4128	1.4128	4000.0
2016-08-04 07:00:00	NVDA	Stock	1.4188	1.4188	1.4188	1.4188	20000.0
2016-08-04 08:00:00	NVDA	Stock	1.4173	1.4173	1.413	1.4135	52800.0
2016-08-04 09:00:00	NVDA	Stock	1.4113	1.42	1.4088	1.415	24300480.0
2016-08-04 10:00:00	NVDA	Stock	1.4153	1.4238	1.412	1.4224	36694240.0
2016-08-04 11:00:00	NVDA	Stock	1.4222	1.4325	1.422	1.4322	44813640.0
2016-08-04 12:00:00	NVDA	Stock	1.4325	1.4373	1.4315	1.4352	33643560.0
2016-08-04 13:00:00	NVDA	Stock	1.4351	1.4368	1.4338	1.436	22107680.0
2016-08-04 14:00:00	NVDA	Stock	1.4358	1.436	1.4288	1.4305	25085160.0
2016-08-04 15:00:00	NVDA	Stock	1.4302	1.4328	1.4279	1.4308	42794280.0
2016-08-04 16:00:00	NVDA	Stock	1.4308	1.4322	1.4288	1.4308	12176040.0
2016-08-04 17:00:00	NVDA	Stock	1.4308	1.435	1.4145	1.4348	506000.0
2016-08-04 18:00:00	NVDA	Stock	1.4348	1.4373	1.4345	1.4345	263000.0
2016-08-04 19:00:00	NVDA	Stock	1.4345	1.4345	1.4328	1.4328	53200.0
2016-08-04 06:00:00	AMZN	Stock	37.725	37.725	37.725	37.725	2000.0
2016-08-04 07:00:00	AMZN	Stock	37.84	37.849	37.7475	37.775	33200.0
2016-08-04 08:00:00	AMZN	Stock	37.83	37.83	37.75	37.763	55700.0
2016-08-04 09:00:00	AMZN	Stock	37.775	37.785	37.6	37.6895	9124680.0
2016-08-04 10:00:00	AMZN	Stock	37.6896	38.125	37.5175	38.1032	19528880.0
2016-08-04 11:00:00	AMZN	Stock	38.0945	38.1915	38.0325	38.185	9190180.0
2016-08-04 12:00:00	AMZN	Stock	38.185	38.24	38.0835	38.085	4908080.0

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

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