PREVIEW / stock_1hour / 2016-09-30

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-09-30.parquet
  size:    1.0 MB
  rows:    47,996
  symbols: 3,210

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-30 04:00:00	AAPL	Stock	27.9375	27.9425	27.8875	27.9425	6368.0
2016-09-30 05:00:00	AAPL	Stock	27.93	27.9625	27.93	27.9625	1096.0
2016-09-30 06:00:00	AAPL	Stock	27.975	28.0	27.975	28.0	26932.0
2016-09-30 07:00:00	AAPL	Stock	28.0775	28.2125	28.0625	28.1275	162176.0
2016-09-30 08:00:00	AAPL	Stock	28.1275	28.1975	27.9825	28.185	228080.0
2016-09-30 09:00:00	AAPL	Stock	28.185	28.3075	28.1125	28.2112	19333300.0
2016-09-30 10:00:00	AAPL	Stock	28.2112	28.23	27.95	28.135	26335844.0
2016-09-30 11:00:00	AAPL	Stock	28.135	28.2275	28.1325	28.195	16702656.0
2016-09-30 12:00:00	AAPL	Stock	28.195	28.2775	28.195	28.2452	10359572.0
2016-09-30 13:00:00	AAPL	Stock	28.245	28.305	28.23	28.3	8012108.0
2016-09-30 14:00:00	AAPL	Stock	28.3012	28.3175	28.265	28.3125	8594472.0
2016-09-30 15:00:00	AAPL	Stock	28.31	28.3425	28.225	28.2575	23216644.0
2016-09-30 16:00:00	AAPL	Stock	28.2525	28.2628	28.2125	28.25	21256968.0
2016-09-30 17:00:00	AAPL	Stock	28.2425	28.26	28.2425	28.2525	26648.0
2016-09-30 18:00:00	AAPL	Stock	28.2525	28.2675	28.25	28.2575	66176.0
2016-09-30 19:00:00	AAPL	Stock	28.2575	28.2625	28.2575	28.2625	48868.0
2016-09-30 08:00:00	MSFT	Stock	57.3	57.68	57.3	57.68	3285.0
2016-09-30 09:00:00	MSFT	Stock	57.66	57.68	57.34	57.35	3252348.0
2016-09-30 10:00:00	MSFT	Stock	57.35	57.52	57.35	57.49	2861472.0
2016-09-30 11:00:00	MSFT	Stock	57.49	57.67	57.48	57.52	2182810.0
2016-09-30 12:00:00	MSFT	Stock	57.514	57.645	57.49	57.49	1669455.0
2016-09-30 13:00:00	MSFT	Stock	57.49	57.61	57.455	57.55	1316674.0
2016-09-30 14:00:00	MSFT	Stock	57.548	57.63	57.514	57.576	1920989.0
2016-09-30 15:00:00	MSFT	Stock	57.58	57.77	57.57	57.59	6451998.0
2016-09-30 16:00:00	MSFT	Stock	57.58	57.605	57.41	57.45	7481052.0
2016-09-30 17:00:00	MSFT	Stock	57.42	57.57	57.42	57.5	2251.0
2016-09-30 18:00:00	MSFT	Stock	57.56	57.61	57.56	57.6	4866.0
2016-09-30 19:00:00	MSFT	Stock	57.59	57.59	57.59	57.59	200.0
2016-09-30 04:00:00	NVDA	Stock	1.686	1.686	1.684	1.684	16000.0
2016-09-30 08:00:00	NVDA	Stock	1.6863	1.6962	1.684	1.6962	116760.0
2016-09-30 09:00:00	NVDA	Stock	1.6962	1.714	1.6843	1.7132	65195040.0
2016-09-30 10:00:00	NVDA	Stock	1.7134	1.7264	1.713	1.7189	94735360.0
2016-09-30 11:00:00	NVDA	Stock	1.7188	1.726	1.717	1.7205	38728640.0
2016-09-30 12:00:00	NVDA	Stock	1.7206	1.7298	1.7189	1.7245	31083280.0
2016-09-30 13:00:00	NVDA	Stock	1.7242	1.7278	1.7192	1.7227	22189840.0
2016-09-30 14:00:00	NVDA	Stock	1.7228	1.723	1.7168	1.7168	32589200.0
2016-09-30 15:00:00	NVDA	Stock	1.7168	1.718	1.71	1.7128	69052600.0
2016-09-30 16:00:00	NVDA	Stock	1.713	1.7152	1.7108	1.7125	15916600.0
2016-09-30 17:00:00	NVDA	Stock	1.7125	1.7198	1.7125	1.7125	125400.0
2016-09-30 18:00:00	NVDA	Stock	1.7138	1.7138	1.7138	1.7138	4000.0
2016-09-30 19:00:00	NVDA	Stock	1.7192	1.7192	1.7145	1.7175	24000.0
2016-09-30 06:00:00	AMZN	Stock	41.422	41.4995	41.422	41.4995	33860.0
2016-09-30 07:00:00	AMZN	Stock	41.4995	41.6325	41.4995	41.574	30740.0
2016-09-30 08:00:00	AMZN	Stock	41.574	41.685	41.37	41.6775	406440.0
2016-09-30 09:00:00	AMZN	Stock	41.684	41.762	41.62	41.7345	11313820.0
2016-09-30 10:00:00	AMZN	Stock	41.7375	41.888	41.71	41.8815	12255140.0
2016-09-30 11:00:00	AMZN	Stock	41.875	41.992	41.843	41.9039	9701540.0
2016-09-30 12:00:00	AMZN	Stock	41.896	41.989	41.8855	41.917	4274220.0
2016-09-30 13:00:00	AMZN	Stock	41.9115	41.9245	41.826	41.869	5835340.0
2016-09-30 14:00:00	AMZN	Stock	41.871	41.9975	41.8655	41.9655	5920960.0

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

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