PREVIEW / stock_1hour / 2017-11-15

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-11-15.parquet
  size:    1.1 MB
  rows:    50,691
  symbols: 2,934

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-11-15 04:00:00	AAPL	Stock	42.61	42.61	42.455	42.46	82040.0
2017-11-15 05:00:00	AAPL	Stock	42.5	42.5225	42.47	42.4875	36724.0
2017-11-15 06:00:00	AAPL	Stock	42.4975	42.575	42.4825	42.5125	52788.0
2017-11-15 07:00:00	AAPL	Stock	42.51	42.6475	42.505	42.6475	208908.0
2017-11-15 08:00:00	AAPL	Stock	42.575	42.67	42.5	42.57	589764.0
2017-11-15 09:00:00	AAPL	Stock	42.555	42.555	42.095	42.25	23833784.0
2017-11-15 10:00:00	AAPL	Stock	42.25	42.58	42.225	42.5625	16382112.0
2017-11-15 11:00:00	AAPL	Stock	42.5675	42.575	42.3612	42.3688	12828640.0
2017-11-15 12:00:00	AAPL	Stock	42.37	42.42	42.28	42.396	8006744.0
2017-11-15 13:00:00	AAPL	Stock	42.3975	42.4025	42.2388	42.2988	7840644.0
2017-11-15 14:00:00	AAPL	Stock	42.3	42.38	42.25	42.3425	6998596.0
2017-11-15 15:00:00	AAPL	Stock	42.34	42.3825	42.1725	42.2725	17233004.0
2017-11-15 16:00:00	AAPL	Stock	42.27	42.3325	42.255	42.3125	9664148.0
2017-11-15 17:00:00	AAPL	Stock	42.305	42.325	42.3	42.3	58908.0
2017-11-15 18:00:00	AAPL	Stock	42.3125	42.3125	42.29	42.3	64444.0
2017-11-15 19:00:00	AAPL	Stock	42.3075	42.345	42.3	42.3375	110736.0
2017-11-15 04:00:00	MSFT	Stock	83.55	83.55	82.61	82.61	3938.0
2017-11-15 05:00:00	MSFT	Stock	82.62	82.92	82.62	82.73	3835.0
2017-11-15 06:00:00	MSFT	Stock	82.88	83.14	82.88	82.93	4521.0
2017-11-15 07:00:00	MSFT	Stock	83.14	83.22	83.11	83.15	5403.0
2017-11-15 08:00:00	MSFT	Stock	83.11	83.59	83.05	83.5	48591.0
2017-11-15 09:00:00	MSFT	Stock	83.41	83.69	82.99	83.029	2606512.0
2017-11-15 10:00:00	MSFT	Stock	83.025	83.365	82.98	83.28	2111002.0
2017-11-15 11:00:00	MSFT	Stock	83.28	83.34	83.19	83.2	1994993.0
2017-11-15 12:00:00	MSFT	Stock	83.21	83.37	83.13	83.269	1275161.0
2017-11-15 13:00:00	MSFT	Stock	83.27	83.28	83.135	83.15	996436.0
2017-11-15 14:00:00	MSFT	Stock	83.16	83.22	83.11	83.18	1351832.0
2017-11-15 15:00:00	MSFT	Stock	83.18	83.21	82.69	82.99	3879295.0
2017-11-15 16:00:00	MSFT	Stock	82.98	83.245	82.82	82.98	3347072.0
2017-11-15 17:00:00	MSFT	Stock	82.99	83.01	82.99	82.99	1000.0
2017-11-15 18:00:00	MSFT	Stock	82.99	83.0	82.98	82.98	6100.0
2017-11-15 19:00:00	MSFT	Stock	83.01	83.14	83.01	83.1	2106.0
2017-11-15 04:00:00	NVDA	Stock	5.317	5.317	5.3	5.3	41680.0
2017-11-15 05:00:00	NVDA	Stock	5.303	5.3062	5.2883	5.3	21120.0
2017-11-15 06:00:00	NVDA	Stock	5.2913	5.301	5.2888	5.2952	206320.0
2017-11-15 07:00:00	NVDA	Stock	5.2902	5.3145	5.2902	5.3145	864640.0
2017-11-15 08:00:00	NVDA	Stock	5.3125	5.322	5.29	5.3002	2946240.0
2017-11-15 09:00:00	NVDA	Stock	5.3025	5.305	5.195	5.2119	109289120.0
2017-11-15 10:00:00	NVDA	Stock	5.2102	5.2625	5.2095	5.239	100362200.0
2017-11-15 11:00:00	NVDA	Stock	5.2392	5.2538	5.2265	5.2523	52159120.0
2017-11-15 12:00:00	NVDA	Stock	5.2525	5.2525	5.2288	5.2376	34791920.0
2017-11-15 13:00:00	NVDA	Stock	5.238	5.257	5.2172	5.25	43559280.0
2017-11-15 14:00:00	NVDA	Stock	5.251	5.2763	5.2483	5.2688	46161320.0
2017-11-15 15:00:00	NVDA	Stock	5.268	5.2733	5.2395	5.2495	59018720.0
2017-11-15 16:00:00	NVDA	Stock	5.2495	5.2613	5.2445	5.2608	15410600.0
2017-11-15 17:00:00	NVDA	Stock	5.2568	5.261	5.2495	5.2575	521760.0
2017-11-15 18:00:00	NVDA	Stock	5.2588	5.26	5.2513	5.2578	447200.0
2017-11-15 19:00:00	NVDA	Stock	5.2502	5.27	5.2502	5.2668	502480.0
2017-11-15 04:00:00	AMZN	Stock	56.65	56.65	56.458	56.458	9000.0
2017-11-15 05:00:00	AMZN	Stock	56.3685	56.3685	56.323	56.323	4000.0

> showing 50 of 50,691 rows — these rows as CSV

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