PREVIEW / stock_1hour / 2015-08-18

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-08-18.parquet
  size:    1.0 MB
  rows:    47,852
  symbols: 3,444

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
2015-08-18 04:00:00	AAPL	Stock	29.205	29.285	29.205	29.245	19632.0
2015-08-18 05:00:00	AAPL	Stock	29.225	29.225	29.1325	29.1325	9708.0
2015-08-18 06:00:00	AAPL	Stock	29.1625	29.2	29.14	29.2	37512.0
2015-08-18 07:00:00	AAPL	Stock	29.2	29.2	29.085	29.1125	95056.0
2015-08-18 08:00:00	AAPL	Stock	29.1125	29.19	29.0825	29.1575	601428.0
2015-08-18 09:00:00	AAPL	Stock	29.1575	29.2325	29.0025	29.1212	24376320.0
2015-08-18 10:00:00	AAPL	Stock	29.1202	29.285	29.0725	29.2848	23627808.0
2015-08-18 11:00:00	AAPL	Stock	29.2825	29.325	29.14	29.275	19384552.0
2015-08-18 12:00:00	AAPL	Stock	29.2725	29.36	29.2675	29.2925	10456432.0
2015-08-18 13:00:00	AAPL	Stock	29.29	29.295	29.135	29.1875	12373780.0
2015-08-18 14:00:00	AAPL	Stock	29.1852	29.25	29.08	29.1	13105016.0
2015-08-18 15:00:00	AAPL	Stock	29.1002	29.1575	29.0775	29.125	21243844.0
2015-08-18 16:00:00	AAPL	Stock	29.125	29.185	29.1175	29.165	5136364.0
2015-08-18 17:00:00	AAPL	Stock	29.16	29.16	29.125	29.125	33520.0
2015-08-18 18:00:00	AAPL	Stock	29.1275	29.1425	29.1258	29.1325	49496.0
2015-08-18 19:00:00	AAPL	Stock	29.1325	29.145	29.13	29.1425	44844.0
2015-08-18 04:00:00	MSFT	Stock	47.0	47.0	47.0	47.0	200.0
2015-08-18 08:00:00	MSFT	Stock	47.0	47.03	46.95	47.01	26516.0
2015-08-18 09:00:00	MSFT	Stock	47.05	47.09	46.7	46.99	3620106.0
2015-08-18 10:00:00	MSFT	Stock	46.985	47.3	46.91	47.27	3733027.0
2015-08-18 11:00:00	MSFT	Stock	47.27	47.365	47.18	47.33	1654685.0
2015-08-18 12:00:00	MSFT	Stock	47.32	47.43	47.25	47.27	1669267.0
2015-08-18 13:00:00	MSFT	Stock	47.26	47.27	47.1	47.166	2038430.0
2015-08-18 14:00:00	MSFT	Stock	47.17	47.26	47.11	47.138	1698855.0
2015-08-18 15:00:00	MSFT	Stock	47.135	47.32	47.08	47.27	4989383.0
2015-08-18 16:00:00	MSFT	Stock	47.27	47.348	47.21	47.21	2362936.0
2015-08-18 17:00:00	MSFT	Stock	47.21	47.21	47.21	47.21	600.0
2015-08-18 18:00:00	MSFT	Stock	47.29	47.29	47.29	47.29	350.0
2015-08-18 08:00:00	NVDA	Stock	0.5825	0.5828	0.5825	0.5825	20000.0
2015-08-18 09:00:00	NVDA	Stock	0.5825	0.5845	0.5755	0.5766	28642200.0
2015-08-18 10:00:00	NVDA	Stock	0.5768	0.5772	0.5732	0.5765	39073200.0
2015-08-18 11:00:00	NVDA	Stock	0.5765	0.5768	0.5725	0.575	26560800.0
2015-08-18 12:00:00	NVDA	Stock	0.575	0.5762	0.5728	0.574	20313440.0
2015-08-18 13:00:00	NVDA	Stock	0.5738	0.576	0.5728	0.5734	20617920.0
2015-08-18 14:00:00	NVDA	Stock	0.5735	0.5768	0.573	0.5764	23268440.0
2015-08-18 15:00:00	NVDA	Stock	0.5762	0.5788	0.576	0.577	97819880.0
2015-08-18 16:00:00	NVDA	Stock	0.577	0.581	0.577	0.581	1495560.0
2015-08-18 17:00:00	NVDA	Stock	0.581	0.581	0.581	0.581	9480.0
2015-08-18 18:00:00	NVDA	Stock	0.5788	0.5788	0.5788	0.5788	4000.0
2015-08-18 08:00:00	AMZN	Stock	26.69	26.7095	26.674	26.7095	28400.0
2015-08-18 09:00:00	AMZN	Stock	26.75	26.91	26.675	26.8385	6185580.0
2015-08-18 10:00:00	AMZN	Stock	26.8455	26.9485	26.8125	26.94	5572220.0
2015-08-18 11:00:00	AMZN	Stock	26.921	26.9745	26.8555	26.882	6642860.0
2015-08-18 12:00:00	AMZN	Stock	26.8803	26.888	26.7125	26.7215	3885340.0
2015-08-18 13:00:00	AMZN	Stock	26.712	26.771	26.65	26.706	3734740.0
2015-08-18 14:00:00	AMZN	Stock	26.6907	26.7955	26.675	26.75	4389820.0
2015-08-18 15:00:00	AMZN	Stock	26.7456	26.7935	26.711	26.751	7340700.0
2015-08-18 16:00:00	AMZN	Stock	26.751	26.751	26.725	26.725	907300.0
2015-08-18 19:00:00	AMZN	Stock	26.752	26.752	26.7385	26.7385	7000.0
2015-08-18 09:00:00	GOOGL	Stock	34.6875	34.7878	34.5015	34.508	3208780.0

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

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