PREVIEW / stock_1hour / 2017-12-19

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-12-19.parquet
  size:    1.1 MB
  rows:    49,658
  symbols: 2,949

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-12-19 04:00:00	AAPL	Stock	43.845	43.845	43.59	43.7075	30260.0
2017-12-19 05:00:00	AAPL	Stock	43.6975	43.7125	43.6625	43.6625	30044.0
2017-12-19 06:00:00	AAPL	Stock	43.69	43.7475	43.57	43.66	110300.0
2017-12-19 07:00:00	AAPL	Stock	43.66	43.785	43.65	43.745	371236.0
2017-12-19 08:00:00	AAPL	Stock	43.745	43.795	43.65	43.7	780316.0
2017-12-19 09:00:00	AAPL	Stock	43.69	43.8475	43.5225	43.7325	22028632.0
2017-12-19 10:00:00	AAPL	Stock	43.7325	43.775	43.555	43.605	15348572.0
2017-12-19 11:00:00	AAPL	Stock	43.605	43.744	43.565	43.6287	10502412.0
2017-12-19 12:00:00	AAPL	Stock	43.63	43.675	43.5525	43.6525	8072552.0
2017-12-19 13:00:00	AAPL	Stock	43.6538	43.7685	43.6452	43.69	6475856.0
2017-12-19 14:00:00	AAPL	Stock	43.69	43.725	43.605	43.6175	6616660.0
2017-12-19 15:00:00	AAPL	Stock	43.617	43.67	43.555	43.6325	16830492.0
2017-12-19 16:00:00	AAPL	Stock	43.6325	43.645	43.575	43.59	7203972.0
2017-12-19 17:00:00	AAPL	Stock	43.5975	43.6	43.585	43.5875	25680.0
2017-12-19 18:00:00	AAPL	Stock	43.5825	43.6	43.5675	43.6	56512.0
2017-12-19 19:00:00	AAPL	Stock	43.5925	43.67	43.5925	43.66	90488.0
2017-12-19 07:00:00	MSFT	Stock	86.5	86.5	86.45	86.49	1155.0
2017-12-19 08:00:00	MSFT	Stock	86.48	86.51	86.35	86.39	18933.0
2017-12-19 09:00:00	MSFT	Stock	86.3	86.42	85.79	85.935	3046447.0
2017-12-19 10:00:00	MSFT	Stock	85.935	86.06	85.33	85.545	3097018.0
2017-12-19 11:00:00	MSFT	Stock	85.545	85.74	85.29	85.313	2127553.0
2017-12-19 12:00:00	MSFT	Stock	85.31	85.75	85.27	85.75	1673378.0
2017-12-19 13:00:00	MSFT	Stock	85.742	85.77	85.62	85.715	1372104.0
2017-12-19 14:00:00	MSFT	Stock	85.725	85.74	85.47	85.52	1852570.0
2017-12-19 15:00:00	MSFT	Stock	85.53	85.92	85.425	85.83	3821710.0
2017-12-19 16:00:00	MSFT	Stock	85.83	85.83	85.61	85.76	3466492.0
2017-12-19 17:00:00	MSFT	Stock	85.75	85.88	85.7	85.88	2291.0
2017-12-19 18:00:00	MSFT	Stock	85.82	85.82	85.75	85.75	300.0
2017-12-19 19:00:00	MSFT	Stock	85.82	85.9	85.82	85.9	2488.0
2017-12-19 04:00:00	NVDA	Stock	4.9785	4.9785	4.9785	4.9785	4120.0
2017-12-19 05:00:00	NVDA	Stock	4.9758	4.9758	4.9738	4.9738	32280.0
2017-12-19 06:00:00	NVDA	Stock	4.9625	4.9628	4.9625	4.9625	54680.0
2017-12-19 07:00:00	NVDA	Stock	4.9625	4.9725	4.9602	4.9715	472440.0
2017-12-19 08:00:00	NVDA	Stock	4.9608	4.9845	4.958	4.959	2352880.0
2017-12-19 09:00:00	NVDA	Stock	4.958	4.958	4.8855	4.9264	91630600.0
2017-12-19 10:00:00	NVDA	Stock	4.9252	4.9415	4.8912	4.9105	69320920.0
2017-12-19 11:00:00	NVDA	Stock	4.9118	4.9312	4.9008	4.9024	41269800.0
2017-12-19 12:00:00	NVDA	Stock	4.901	4.911	4.8943	4.9094	28733680.0
2017-12-19 13:00:00	NVDA	Stock	4.9088	4.9245	4.9015	4.9178	24257960.0
2017-12-19 14:00:00	NVDA	Stock	4.9178	4.919	4.8875	4.8927	28737920.0
2017-12-19 15:00:00	NVDA	Stock	4.8925	4.9065	4.874	4.9025	53925280.0
2017-12-19 16:00:00	NVDA	Stock	4.9028	4.926	4.9	4.9158	4485280.0
2017-12-19 17:00:00	NVDA	Stock	4.9175	4.9243	4.915	4.9225	982360.0
2017-12-19 18:00:00	NVDA	Stock	4.9235	4.925	4.92	4.9238	612440.0
2017-12-19 19:00:00	NVDA	Stock	4.9263	4.93	4.9225	4.93	280560.0
2017-12-19 04:00:00	AMZN	Stock	59.75	59.75	59.75	59.75	5000.0
2017-12-19 06:00:00	AMZN	Stock	59.694	59.694	59.694	59.694	5140.0
2017-12-19 07:00:00	AMZN	Stock	59.6265	59.6565	59.62	59.62	51660.0
2017-12-19 08:00:00	AMZN	Stock	59.6	59.65	59.55	59.55	237140.0
2017-12-19 09:00:00	AMZN	Stock	59.534	59.6485	58.957	59.242	10676940.0

> showing 50 of 49,658 rows — these rows as CSV

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