PREVIEW / stock_1hour / 2017-02-09

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-02-09.parquet
  size:    1.0 MB
  rows:    48,300
  symbols: 3,105

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
2017-02-09 04:00:00	AAPL	Stock	32.9925	32.9925	32.95	32.95	7176.0
2017-02-09 05:00:00	AAPL	Stock	32.9525	32.9525	32.9375	32.9375	8400.0
2017-02-09 06:00:00	AAPL	Stock	32.9475	32.95	32.9375	32.9475	34344.0
2017-02-09 07:00:00	AAPL	Stock	32.95	32.95	32.88	32.915	102796.0
2017-02-09 08:00:00	AAPL	Stock	32.915	32.975	32.8875	32.925	433544.0
2017-02-09 09:00:00	AAPL	Stock	32.9225	33.04	32.855	32.8575	16676992.0
2017-02-09 10:00:00	AAPL	Stock	32.8575	32.9075	32.78	32.885	12626920.0
2017-02-09 11:00:00	AAPL	Stock	32.885	32.9862	32.875	32.969	9708220.0
2017-02-09 12:00:00	AAPL	Stock	32.9688	32.975	32.94	32.9675	4930888.0
2017-02-09 13:00:00	AAPL	Stock	32.97	33.0225	32.96	33.015	6806228.0
2017-02-09 14:00:00	AAPL	Stock	33.0162	33.1	33.0162	33.0912	10688984.0
2017-02-09 15:00:00	AAPL	Stock	33.0925	33.1112	33.05	33.1025	17910900.0
2017-02-09 16:00:00	AAPL	Stock	33.1025	33.105	33.0675	33.0775	16593884.0
2017-02-09 17:00:00	AAPL	Stock	33.0775	33.1025	33.0775	33.1	41264.0
2017-02-09 18:00:00	AAPL	Stock	33.095	33.105	33.085	33.105	16236.0
2017-02-09 19:00:00	AAPL	Stock	33.105	33.1175	33.095	33.1125	76232.0
2017-02-09 08:00:00	MSFT	Stock	63.37	63.47	63.33	63.47	4172.0
2017-02-09 09:00:00	MSFT	Stock	63.34	63.58	63.32	63.525	2130168.0
2017-02-09 10:00:00	MSFT	Stock	63.525	63.8	63.46	63.795	3321240.0
2017-02-09 11:00:00	MSFT	Stock	63.8	64.435	63.77	64.316	4532461.0
2017-02-09 12:00:00	MSFT	Stock	64.31	64.33	64.09	64.15	2603104.0
2017-02-09 13:00:00	MSFT	Stock	64.14	64.19	64.115	64.165	1301582.0
2017-02-09 14:00:00	MSFT	Stock	64.165	64.205	64.13	64.19	1472103.0
2017-02-09 15:00:00	MSFT	Stock	64.195	64.2	64.0	64.05	3735694.0
2017-02-09 16:00:00	MSFT	Stock	64.06	64.06	63.96	64.0	1848934.0
2017-02-09 17:00:00	MSFT	Stock	64.0	64.04	63.98	64.0	4383.0
2017-02-09 18:00:00	MSFT	Stock	64.0	64.0	63.98	63.98	1314.0
2017-02-09 19:00:00	MSFT	Stock	64.03	64.03	63.98	63.98	5499.0
2017-02-09 04:00:00	NVDA	Stock	2.97	2.97	2.97	2.97	12880.0
2017-02-09 05:00:00	NVDA	Stock	2.9575	2.9575	2.9575	2.9575	28000.0
2017-02-09 06:00:00	NVDA	Stock	2.9283	2.9575	2.9283	2.955	79600.0
2017-02-09 07:00:00	NVDA	Stock	2.9488	2.9688	2.9438	2.9625	428040.0
2017-02-09 08:00:00	NVDA	Stock	2.95	2.9795	2.95	2.9753	1651400.0
2017-02-09 09:00:00	NVDA	Stock	2.9755	2.9788	2.9478	2.9638	69374960.0
2017-02-09 10:00:00	NVDA	Stock	2.9638	2.9645	2.9212	2.9328	142556280.0
2017-02-09 11:00:00	NVDA	Stock	2.9328	2.9485	2.9288	2.9409	68458560.0
2017-02-09 12:00:00	NVDA	Stock	2.9412	2.951	2.9345	2.9443	57794920.0
2017-02-09 13:00:00	NVDA	Stock	2.9443	2.955	2.9412	2.9484	47378760.0
2017-02-09 14:00:00	NVDA	Stock	2.948	2.9508	2.9318	2.9355	65094640.0
2017-02-09 15:00:00	NVDA	Stock	2.9355	2.9368	2.89	2.9113	181355920.0
2017-02-09 16:00:00	NVDA	Stock	2.9095	2.944	2.675	2.825	103410320.0
2017-02-09 17:00:00	NVDA	Stock	2.8253	2.8938	2.7925	2.8803	42825480.0
2017-02-09 18:00:00	NVDA	Stock	2.8815	2.9425	2.8772	2.9138	21911320.0
2017-02-09 19:00:00	NVDA	Stock	2.9175	2.9225	2.9003	2.9172	5912280.0
2017-02-09 08:00:00	AMZN	Stock	41.0425	41.095	41.0025	41.0835	109040.0
2017-02-09 09:00:00	AMZN	Stock	41.0825	41.25	40.9855	41.137	10234460.0
2017-02-09 10:00:00	AMZN	Stock	41.1358	41.2235	41.0365	41.207	8121360.0
2017-02-09 11:00:00	AMZN	Stock	41.2176	41.239	41.157	41.1723	4549120.0
2017-02-09 12:00:00	AMZN	Stock	41.1775	41.189	41.0931	41.1565	3793120.0
2017-02-09 13:00:00	AMZN	Stock	41.161	41.1965	41.145	41.189	1938320.0

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

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