PREVIEW / stock_1hour / 2017-05-15

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-05-15.parquet
  size:    1.0 MB
  rows:    48,445
  symbols: 3,030

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-05-15 04:00:00	AAPL	Stock	39.175	39.25	39.125	39.125	7812.0
2017-05-15 05:00:00	AAPL	Stock	39.1525	39.1525	39.0625	39.0625	16348.0
2017-05-15 06:00:00	AAPL	Stock	39.05	39.105	39.0375	39.105	13476.0
2017-05-15 07:00:00	AAPL	Stock	39.0875	39.125	39.0875	39.0875	114660.0
2017-05-15 08:00:00	AAPL	Stock	39.0975	39.125	39.045	39.065	645252.0
2017-05-15 09:00:00	AAPL	Stock	39.0625	39.1625	38.855	38.9225	18360596.0
2017-05-15 10:00:00	AAPL	Stock	38.9225	38.9875	38.7625	38.98	15989360.0
2017-05-15 11:00:00	AAPL	Stock	38.98	38.995	38.7875	38.8175	9638596.0
2017-05-15 12:00:00	AAPL	Stock	38.815	38.855	38.7688	38.795	7341356.0
2017-05-15 13:00:00	AAPL	Stock	38.795	38.8875	38.7775	38.8575	6654900.0
2017-05-15 14:00:00	AAPL	Stock	38.8562	38.86	38.8	38.84	5357532.0
2017-05-15 15:00:00	AAPL	Stock	38.8412	38.9275	38.8332	38.92	14408312.0
2017-05-15 16:00:00	AAPL	Stock	38.925	38.925	38.8683	38.92	14406048.0
2017-05-15 17:00:00	AAPL	Stock	38.9175	38.95	38.9175	38.95	46824.0
2017-05-15 18:00:00	AAPL	Stock	38.9325	38.96	38.9325	38.9375	37608.0
2017-05-15 19:00:00	AAPL	Stock	38.9375	38.9525	38.915	38.915	30148.0
2017-05-15 04:00:00	MSFT	Stock	68.38	68.38	68.38	68.38	423.0
2017-05-15 06:00:00	MSFT	Stock	68.4	68.4	68.29	68.29	2131.0
2017-05-15 07:00:00	MSFT	Stock	68.38	68.38	68.13	68.3	24912.0
2017-05-15 08:00:00	MSFT	Stock	68.3	68.38	68.25	68.27	9682.0
2017-05-15 09:00:00	MSFT	Stock	68.27	68.42	67.73	67.796	4237179.0
2017-05-15 10:00:00	MSFT	Stock	67.795	67.87	67.57	67.835	3852163.0
2017-05-15 11:00:00	MSFT	Stock	67.84	67.91	67.74	67.77	1887736.0
2017-05-15 12:00:00	MSFT	Stock	67.77	67.88	67.7	67.715	2123186.0
2017-05-15 13:00:00	MSFT	Stock	67.72	67.995	67.71	67.97	1982499.0
2017-05-15 14:00:00	MSFT	Stock	67.97	68.33	67.95	68.27	4099813.0
2017-05-15 15:00:00	MSFT	Stock	68.275	68.48	68.21	68.43	5251398.0
2017-05-15 16:00:00	MSFT	Stock	68.43	68.43	68.32	68.4	3936710.0
2017-05-15 17:00:00	MSFT	Stock	68.4	68.5	68.34	68.43	8527.0
2017-05-15 18:00:00	MSFT	Stock	68.52	68.52	68.45	68.45	1000.0
2017-05-15 19:00:00	MSFT	Stock	68.49	68.49	68.44	68.47	2330.0
2017-05-15 04:00:00	NVDA	Stock	3.1925	3.1998	3.1925	3.1998	40280.0
2017-05-15 05:00:00	NVDA	Stock	3.2072	3.2072	3.202	3.2028	88600.0
2017-05-15 06:00:00	NVDA	Stock	3.1983	3.2075	3.1983	3.2075	132280.0
2017-05-15 07:00:00	NVDA	Stock	3.2075	3.235	3.2075	3.2252	1096000.0
2017-05-15 08:00:00	NVDA	Stock	3.2242	3.2272	3.194	3.2238	4490840.0
2017-05-15 09:00:00	NVDA	Stock	3.225	3.3206	3.2238	3.318	235720400.0
2017-05-15 10:00:00	NVDA	Stock	3.3188	3.3312	3.2905	3.3159	219242480.0
2017-05-15 11:00:00	NVDA	Stock	3.316	3.3448	3.312	3.3348	132140680.0
2017-05-15 12:00:00	NVDA	Stock	3.3352	3.355	3.326	3.3528	120912480.0
2017-05-15 13:00:00	NVDA	Stock	3.3525	3.36	3.3406	3.3522	96040840.0
2017-05-15 14:00:00	NVDA	Stock	3.3525	3.3548	3.3242	3.33	93991600.0
2017-05-15 15:00:00	NVDA	Stock	3.3305	3.3602	3.328	3.3578	131197960.0
2017-05-15 16:00:00	NVDA	Stock	3.3578	3.3738	3.3216	3.368	27887600.0
2017-05-15 17:00:00	NVDA	Stock	3.368	3.37	3.3648	3.3675	574640.0
2017-05-15 18:00:00	NVDA	Stock	3.3648	3.3685	3.3625	3.3625	1392120.0
2017-05-15 19:00:00	NVDA	Stock	3.362	3.376	3.355	3.375	1472760.0
2017-05-15 04:00:00	AMZN	Stock	48.25	48.25	48.175	48.175	20920.0
2017-05-15 05:00:00	AMZN	Stock	48.1725	48.1725	48.1	48.1	24340.0
2017-05-15 06:00:00	AMZN	Stock	48.1	48.1405	48.1	48.1	24040.0

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

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