PREVIEW / stock_1hour / 2017-10-18

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-10-18.parquet
  size:    1.0 MB
  rows:    48,062
  symbols: 2,933

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-10-18 07:00:00	AAPL	Stock	40.1575	40.22	40.1575	40.1775	50608.0
2017-10-18 08:00:00	AAPL	Stock	40.22	40.22	40.1625	40.1825	201496.0
2017-10-18 09:00:00	AAPL	Stock	40.185	40.225	39.9525	40.0675	11717304.0
2017-10-18 10:00:00	AAPL	Stock	40.07	40.1112	40.03	40.03	8537804.0
2017-10-18 11:00:00	AAPL	Stock	40.03	40.0425	39.9375	39.9475	6402620.0
2017-10-18 12:00:00	AAPL	Stock	39.9487	40.12	39.945	40.0925	6297492.0
2017-10-18 13:00:00	AAPL	Stock	40.091	40.0975	39.9975	40.08	4481484.0
2017-10-18 14:00:00	AAPL	Stock	40.08	40.09	39.9975	40.02	5597192.0
2017-10-18 15:00:00	AAPL	Stock	40.0188	40.0425	39.9	39.9425	11983364.0
2017-10-18 16:00:00	AAPL	Stock	39.94	39.94	39.9125	39.9375	3343528.0
2017-10-18 17:00:00	AAPL	Stock	39.925	39.94	39.905	39.9125	30612.0
2017-10-18 18:00:00	AAPL	Stock	39.915	39.9225	39.9	39.9225	19920.0
2017-10-18 19:00:00	AAPL	Stock	39.9125	39.925	39.5025	39.575	378328.0
2017-10-18 07:00:00	MSFT	Stock	77.78	77.82	77.76	77.77	1731.0
2017-10-18 08:00:00	MSFT	Stock	77.87	77.87	77.76	77.76	11492.0
2017-10-18 09:00:00	MSFT	Stock	77.76	77.87	77.37	77.53	1670714.0
2017-10-18 10:00:00	MSFT	Stock	77.54	77.85	77.47	77.745	1533418.0
2017-10-18 11:00:00	MSFT	Stock	77.743	77.77	77.64	77.66	1445538.0
2017-10-18 12:00:00	MSFT	Stock	77.66	77.725	77.615	77.645	775724.0
2017-10-18 13:00:00	MSFT	Stock	77.65	77.8	77.625	77.79	1412837.0
2017-10-18 14:00:00	MSFT	Stock	77.78	77.79	77.64	77.695	1315411.0
2017-10-18 15:00:00	MSFT	Stock	77.7	77.82	77.51	77.64	2664224.0
2017-10-18 16:00:00	MSFT	Stock	77.61	77.7	77.61	77.7	1237284.0
2017-10-18 17:00:00	MSFT	Stock	77.65	77.73	77.65	77.66	2102.0
2017-10-18 04:00:00	NVDA	Stock	4.95	4.95	4.95	4.95	4000.0
2017-10-18 05:00:00	NVDA	Stock	4.9495	4.95	4.9495	4.95	23120.0
2017-10-18 07:00:00	NVDA	Stock	4.9513	4.9675	4.9513	4.9575	410480.0
2017-10-18 08:00:00	NVDA	Stock	4.9618	4.966	4.9515	4.9575	1413880.0
2017-10-18 09:00:00	NVDA	Stock	4.955	4.96	4.882	4.8865	92727000.0
2017-10-18 10:00:00	NVDA	Stock	4.8863	4.89	4.833	4.8763	156165640.0
2017-10-18 11:00:00	NVDA	Stock	4.8763	4.8863	4.86	4.8838	38921680.0
2017-10-18 12:00:00	NVDA	Stock	4.8828	4.9298	4.8822	4.9168	75721600.0
2017-10-18 13:00:00	NVDA	Stock	4.9169	4.9295	4.9105	4.9268	33150960.0
2017-10-18 14:00:00	NVDA	Stock	4.9269	4.949	4.9255	4.9435	56085360.0
2017-10-18 15:00:00	NVDA	Stock	4.944	4.947	4.9338	4.9385	46162000.0
2017-10-18 16:00:00	NVDA	Stock	4.9395	4.9412	4.925	4.9362	11399760.0
2017-10-18 17:00:00	NVDA	Stock	4.9362	4.9375	4.93	4.935	278000.0
2017-10-18 18:00:00	NVDA	Stock	4.93	4.9375	4.93	4.933	138760.0
2017-10-18 19:00:00	NVDA	Stock	4.9365	4.9428	4.9325	4.9375	681720.0
2017-10-18 06:00:00	AMZN	Stock	50.475	50.475	50.475	50.475	11840.0
2017-10-18 07:00:00	AMZN	Stock	50.56	50.56	50.5	50.51	29440.0
2017-10-18 08:00:00	AMZN	Stock	50.5405	50.541	50.422	50.525	99860.0
2017-10-18 09:00:00	AMZN	Stock	50.5115	50.575	50.2255	50.32	6466620.0
2017-10-18 10:00:00	AMZN	Stock	50.3465	50.4675	50.2352	50.3863	4498920.0
2017-10-18 11:00:00	AMZN	Stock	50.3845	50.4165	50.268	50.303	3510820.0
2017-10-18 12:00:00	AMZN	Stock	50.3073	50.382	50.253	50.26	3499980.0
2017-10-18 13:00:00	AMZN	Stock	50.2555	50.2735	50.094	50.1145	4312280.0
2017-10-18 14:00:00	AMZN	Stock	50.121	50.15	49.9505	50.019	7355460.0
2017-10-18 15:00:00	AMZN	Stock	50.0185	51.1155	49.8275	49.8495	8557360.0
2017-10-18 16:00:00	AMZN	Stock	49.85	49.9205	49.8	49.9	1611960.0

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

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