PREVIEW / stock_1hour / 2016-10-04

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-10-04.parquet
  size:    1.0 MB
  rows:    48,017
  symbols: 3,206

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-10-04 04:00:00	AAPL	Stock	28.1875	28.1875	28.1875	28.1875	400.0
2016-10-04 05:00:00	AAPL	Stock	28.235	28.2375	28.235	28.2375	3924.0
2016-10-04 06:00:00	AAPL	Stock	28.205	28.205	28.175	28.175	1216.0
2016-10-04 07:00:00	AAPL	Stock	28.155	28.17	28.11	28.11	46484.0
2016-10-04 08:00:00	AAPL	Stock	28.1875	28.1875	28.075	28.175	143684.0
2016-10-04 09:00:00	AAPL	Stock	28.1775	28.5775	28.175	28.5582	23502412.0
2016-10-04 10:00:00	AAPL	Stock	28.5595	28.575	28.4275	28.51	19900236.0
2016-10-04 11:00:00	AAPL	Stock	28.5125	28.52	28.3275	28.3445	17535452.0
2016-10-04 12:00:00	AAPL	Stock	28.3438	28.3825	28.2725	28.275	10705912.0
2016-10-04 13:00:00	AAPL	Stock	28.275	28.3025	28.1775	28.1962	10416776.0
2016-10-04 14:00:00	AAPL	Stock	28.195	28.3	28.165	28.165	9714824.0
2016-10-04 15:00:00	AAPL	Stock	28.165	28.285	28.1575	28.255	14737724.0
2016-10-04 16:00:00	AAPL	Stock	28.25	28.3905	28.2325	28.25	4712952.0
2016-10-04 17:00:00	AAPL	Stock	28.25	28.26	28.2425	28.25	68028.0
2016-10-04 18:00:00	AAPL	Stock	28.2575	28.2575	28.2175	28.23	72716.0
2016-10-04 19:00:00	AAPL	Stock	28.2475	28.25	28.22	28.2475	33420.0
2016-10-04 06:00:00	MSFT	Stock	57.42	57.42	57.4	57.4	400.0
2016-10-04 07:00:00	MSFT	Stock	57.58	57.58	57.41	57.46	1468.0
2016-10-04 08:00:00	MSFT	Stock	57.46	57.5	57.43	57.48	919.0
2016-10-04 09:00:00	MSFT	Stock	57.48	57.595	57.27	57.56	2280738.0
2016-10-04 10:00:00	MSFT	Stock	57.55	57.56	57.205	57.46	2407326.0
2016-10-04 11:00:00	MSFT	Stock	57.47	57.49	57.11	57.265	2861743.0
2016-10-04 12:00:00	MSFT	Stock	57.26	57.4	57.2	57.228	2165387.0
2016-10-04 13:00:00	MSFT	Stock	57.22	57.294	57.0	57.095	1629019.0
2016-10-04 14:00:00	MSFT	Stock	57.09	57.14	56.97	56.99	2152603.0
2016-10-04 15:00:00	MSFT	Stock	56.99	57.27	56.97	57.24	3589467.0
2016-10-04 16:00:00	MSFT	Stock	57.24	57.3	57.19	57.24	1862334.0
2016-10-04 18:00:00	MSFT	Stock	57.22	57.24	57.22	57.24	15203.0
2016-10-04 19:00:00	MSFT	Stock	57.21	57.21	57.21	57.21	150.0
2016-10-04 07:00:00	NVDA	Stock	1.7175	1.7175	1.7175	1.7175	31600.0
2016-10-04 08:00:00	NVDA	Stock	1.7198	1.7198	1.7155	1.718	200400.0
2016-10-04 09:00:00	NVDA	Stock	1.717	1.7425	1.7138	1.7312	57116840.0
2016-10-04 10:00:00	NVDA	Stock	1.731	1.7323	1.716	1.7168	44017560.0
2016-10-04 11:00:00	NVDA	Stock	1.717	1.7212	1.7112	1.7155	30715120.0
2016-10-04 12:00:00	NVDA	Stock	1.7152	1.7165	1.7075	1.7085	26362680.0
2016-10-04 13:00:00	NVDA	Stock	1.7082	1.71	1.7007	1.7025	29296280.0
2016-10-04 14:00:00	NVDA	Stock	1.7023	1.7035	1.6948	1.6962	31845760.0
2016-10-04 15:00:00	NVDA	Stock	1.6962	1.7111	1.6958	1.7075	38465160.0
2016-10-04 16:00:00	NVDA	Stock	1.7075	1.7147	1.7055	1.7072	8842880.0
2016-10-04 17:00:00	NVDA	Stock	1.7085	1.7085	1.708	1.7085	24000.0
2016-10-04 18:00:00	NVDA	Stock	1.708	1.7088	1.708	1.7088	32840.0
2016-10-04 19:00:00	NVDA	Stock	1.7088	1.7088	1.7075	1.7088	84360.0
2016-10-04 04:00:00	AMZN	Stock	42.075	42.079	42.07	42.07	7000.0
2016-10-04 05:00:00	AMZN	Stock	42.0405	42.0405	42.037	42.037	4660.0
2016-10-04 06:00:00	AMZN	Stock	42.0	42.075	42.0	42.0355	14000.0
2016-10-04 07:00:00	AMZN	Stock	42.0065	42.03	41.9765	41.9815	75260.0
2016-10-04 08:00:00	AMZN	Stock	41.9905	42.075	41.945	41.973	221560.0
2016-10-04 09:00:00	AMZN	Stock	41.9845	42.1183	41.825	41.9332	7338940.0
2016-10-04 10:00:00	AMZN	Stock	41.9275	41.942	41.6965	41.7145	8579000.0
2016-10-04 11:00:00	AMZN	Stock	41.717	41.7755	41.582	41.6725	7533500.0

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

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