PREVIEW / stock_1hour / 2016-10-17

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-10-17.parquet
  size:    1.0 MB
  rows:    47,090
  symbols: 3,184

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-17 04:00:00	AAPL	Stock	29.3775	29.5	29.31	29.3175	8616.0
2016-10-17 05:00:00	AAPL	Stock	29.3	29.325	29.3	29.3	22880.0
2016-10-17 06:00:00	AAPL	Stock	29.3	29.3375	29.3	29.3375	6000.0
2016-10-17 07:00:00	AAPL	Stock	29.3375	29.43	29.3375	29.4125	41300.0
2016-10-17 08:00:00	AAPL	Stock	29.4125	29.475	29.3475	29.44	184704.0
2016-10-17 09:00:00	AAPL	Stock	29.4375	29.4875	29.2125	29.2288	18312552.0
2016-10-17 10:00:00	AAPL	Stock	29.23	29.365	29.195	29.3312	13841504.0
2016-10-17 11:00:00	AAPL	Stock	29.3325	29.39	29.25	29.3175	10709560.0
2016-10-17 12:00:00	AAPL	Stock	29.3175	29.3275	29.2375	29.24	7514112.0
2016-10-17 13:00:00	AAPL	Stock	29.24	29.3	29.2332	29.25	7195964.0
2016-10-17 14:00:00	AAPL	Stock	29.25	29.3325	29.2475	29.3275	7263796.0
2016-10-17 15:00:00	AAPL	Stock	29.33	29.3915	29.3175	29.3875	14822300.0
2016-10-17 16:00:00	AAPL	Stock	29.3875	29.4375	29.277	29.425	8157524.0
2016-10-17 17:00:00	AAPL	Stock	29.4275	29.4375	29.3875	29.435	114508.0
2016-10-17 18:00:00	AAPL	Stock	29.4375	29.45	29.42	29.445	38960.0
2016-10-17 19:00:00	AAPL	Stock	29.445	29.45	29.425	29.4475	24220.0
2016-10-17 04:00:00	MSFT	Stock	57.41	57.41	57.41	57.41	200.0
2016-10-17 05:00:00	MSFT	Stock	57.27	57.27	57.27	57.27	200.0
2016-10-17 07:00:00	MSFT	Stock	57.34	57.35	57.34	57.35	1980.0
2016-10-17 08:00:00	MSFT	Stock	57.42	57.42	57.42	57.42	1370.0
2016-10-17 09:00:00	MSFT	Stock	57.45	57.46	56.9	56.94	4228679.0
2016-10-17 10:00:00	MSFT	Stock	56.94	57.2	56.87	57.145	4018240.0
2016-10-17 11:00:00	MSFT	Stock	57.145	57.23	57.04	57.145	2340666.0
2016-10-17 12:00:00	MSFT	Stock	57.15	57.205	57.07	57.11	1343969.0
2016-10-17 13:00:00	MSFT	Stock	57.11	57.18	57.064	57.11	1471645.0
2016-10-17 14:00:00	MSFT	Stock	57.11	57.27	57.095	57.225	1595709.0
2016-10-17 15:00:00	MSFT	Stock	57.23	57.34	57.17	57.21	3299569.0
2016-10-17 16:00:00	MSFT	Stock	57.21	57.35	57.21	57.23	4039213.0
2016-10-17 17:00:00	MSFT	Stock	57.34	57.35	57.34	57.35	200.0
2016-10-17 18:00:00	MSFT	Stock	57.3	57.3	57.3	57.3	100.0
2016-10-17 19:00:00	MSFT	Stock	57.3	57.3	57.3	57.3	200.0
2016-10-17 08:00:00	NVDA	Stock	1.6512	1.6512	1.6462	1.6462	138400.0
2016-10-17 09:00:00	NVDA	Stock	1.6518	1.665	1.6495	1.6515	34367880.0
2016-10-17 10:00:00	NVDA	Stock	1.6515	1.6578	1.6475	1.6545	25506720.0
2016-10-17 11:00:00	NVDA	Stock	1.6548	1.6582	1.6508	1.6515	23977440.0
2016-10-17 12:00:00	NVDA	Stock	1.6515	1.6532	1.6488	1.6498	18184960.0
2016-10-17 13:00:00	NVDA	Stock	1.6498	1.6512	1.6455	1.6468	13917880.0
2016-10-17 14:00:00	NVDA	Stock	1.6468	1.6498	1.645	1.645	28891760.0
2016-10-17 15:00:00	NVDA	Stock	1.6455	1.6462	1.638	1.6402	36931440.0
2016-10-17 16:00:00	NVDA	Stock	1.6402	1.6415	1.6388	1.6402	10430160.0
2016-10-17 17:00:00	NVDA	Stock	1.638	1.6472	1.6375	1.6425	60000.0
2016-10-17 18:00:00	NVDA	Stock	1.6413	1.647	1.6413	1.6465	150600.0
2016-10-17 19:00:00	NVDA	Stock	1.6472	1.6475	1.6465	1.6475	67480.0
2016-10-17 04:00:00	AMZN	Stock	41.1115	41.1345	41.1115	41.1345	5840.0
2016-10-17 05:00:00	AMZN	Stock	41.1295	41.1295	41.1295	41.1295	2660.0
2016-10-17 06:00:00	AMZN	Stock	41.0055	41.0055	41.0055	41.0055	4000.0
2016-10-17 07:00:00	AMZN	Stock	41.0965	41.125	41.0965	41.125	4000.0
2016-10-17 08:00:00	AMZN	Stock	41.1325	41.1325	41.002	41.075	185720.0
2016-10-17 09:00:00	AMZN	Stock	41.052	41.116	40.6131	40.6382	14943180.0
2016-10-17 10:00:00	AMZN	Stock	40.6255	41.0085	40.6255	40.811	11695260.0

> showing 50 of 47,090 rows — these rows as CSV

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