PREVIEW / stock_1hour / 2016-09-23

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-09-23.parquet
  size:    1.0 MB
  rows:    47,846
  symbols: 3,222

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-09-23 04:00:00	AAPL	Stock	28.6125	28.6125	28.6125	28.6125	644.0
2016-09-23 05:00:00	AAPL	Stock	28.6125	28.6125	28.6125	28.6125	400.0
2016-09-23 06:00:00	AAPL	Stock	28.5675	28.62	28.5675	28.5825	7324.0
2016-09-23 07:00:00	AAPL	Stock	28.5875	28.62	28.5875	28.6125	22180.0
2016-09-23 08:00:00	AAPL	Stock	28.6	28.655	28.585	28.6225	261664.0
2016-09-23 09:00:00	AAPL	Stock	28.6175	28.7275	28.535	28.5355	16205756.0
2016-09-23 10:00:00	AAPL	Stock	28.5375	28.6225	28.525	28.585	13179340.0
2016-09-23 11:00:00	AAPL	Stock	28.585	28.6575	28.5788	28.625	9598964.0
2016-09-23 12:00:00	AAPL	Stock	28.625	28.6738	28.615	28.6688	6324268.0
2016-09-23 13:00:00	AAPL	Stock	28.6678	28.675	27.8875	27.9825	47841108.0
2016-09-23 14:00:00	AAPL	Stock	27.9825	28.27	27.9	28.2075	64591632.0
2016-09-23 15:00:00	AAPL	Stock	28.2075	28.3025	28.1675	28.1762	30841580.0
2016-09-23 16:00:00	AAPL	Stock	28.175	28.6322	28.075	28.1125	10179088.0
2016-09-23 17:00:00	AAPL	Stock	28.1075	28.11	28.055	28.065	200296.0
2016-09-23 18:00:00	AAPL	Stock	28.0625	28.0725	28.05	28.055	74520.0
2016-09-23 19:00:00	AAPL	Stock	28.0625	28.0725	28.05	28.0575	115268.0
2016-09-23 08:00:00	MSFT	Stock	57.82	57.82	57.75	57.8	2740.0
2016-09-23 09:00:00	MSFT	Stock	57.8	57.91	57.5	57.5	3020020.0
2016-09-23 10:00:00	MSFT	Stock	57.51	57.6	57.41	57.447	2478025.0
2016-09-23 11:00:00	MSFT	Stock	57.44	57.51	57.41	57.45	2037716.0
2016-09-23 12:00:00	MSFT	Stock	57.455	57.54	57.43	57.535	1528241.0
2016-09-23 13:00:00	MSFT	Stock	57.54	57.55	57.38	57.49	1761967.0
2016-09-23 14:00:00	MSFT	Stock	57.49	57.63	57.459	57.545	1889202.0
2016-09-23 15:00:00	MSFT	Stock	57.54	57.6	57.43	57.44	3313056.0
2016-09-23 16:00:00	MSFT	Stock	57.43	57.46	57.37	57.4	2612069.0
2016-09-23 18:00:00	MSFT	Stock	57.39	57.4	57.39	57.4	1130.0
2016-09-23 07:00:00	NVDA	Stock	1.6238	1.6238	1.6238	1.6238	4000.0
2016-09-23 08:00:00	NVDA	Stock	1.6195	1.6195	1.6195	1.6195	8000.0
2016-09-23 09:00:00	NVDA	Stock	1.622	1.628	1.6165	1.6212	32011800.0
2016-09-23 10:00:00	NVDA	Stock	1.621	1.6245	1.6195	1.6214	36112320.0
2016-09-23 11:00:00	NVDA	Stock	1.6212	1.6285	1.6188	1.6274	30430920.0
2016-09-23 12:00:00	NVDA	Stock	1.6272	1.6323	1.6266	1.63	30856240.0
2016-09-23 13:00:00	NVDA	Stock	1.6302	1.6305	1.6223	1.6225	32689240.0
2016-09-23 14:00:00	NVDA	Stock	1.6225	1.6265	1.6195	1.6255	26887400.0
2016-09-23 15:00:00	NVDA	Stock	1.6255	1.6288	1.6228	1.6242	51818840.0
2016-09-23 16:00:00	NVDA	Stock	1.6238	1.6258	1.6238	1.6242	21882560.0
2016-09-23 17:00:00	NVDA	Stock	1.624	1.6258	1.6233	1.6233	136000.0
2016-09-23 04:00:00	AMZN	Stock	40.1705	40.1705	40.1705	40.1705	2000.0
2016-09-23 05:00:00	AMZN	Stock	40.2085	40.2085	40.2085	40.2085	2000.0
2016-09-23 07:00:00	AMZN	Stock	40.15	40.1615	40.101	40.125	28340.0
2016-09-23 08:00:00	AMZN	Stock	40.15	40.216	40.134	40.216	101260.0
2016-09-23 09:00:00	AMZN	Stock	40.217	40.3875	40.1525	40.271	8716540.0
2016-09-23 10:00:00	AMZN	Stock	40.2625	40.2625	40.106	40.172	5545240.0
2016-09-23 11:00:00	AMZN	Stock	40.175	40.308	40.166	40.2787	3745360.0
2016-09-23 12:00:00	AMZN	Stock	40.263	40.3155	40.234	40.2775	2418620.0
2016-09-23 13:00:00	AMZN	Stock	40.2768	40.286	40.175	40.187	2926740.0
2016-09-23 14:00:00	AMZN	Stock	40.1985	40.2825	40.1925	40.254	2253600.0
2016-09-23 15:00:00	AMZN	Stock	40.2505	40.3207	40.215	40.2875	7019580.0
2016-09-23 16:00:00	AMZN	Stock	40.2875	40.2875	40.268	40.2875	2135000.0
2016-09-23 17:00:00	AMZN	Stock	40.2815	40.2875	40.2755	40.2875	16020.0

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

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