PREVIEW / stock_1hour / 2017-08-17

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-08-17.parquet
  size:    1.0 MB
  rows:    47,420
  symbols: 2,960

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-08-17 04:00:00	AAPL	Stock	40.21	40.21	40.21	40.21	400.0
2017-08-17 06:00:00	AAPL	Stock	40.175	40.2	40.175	40.2	4800.0
2017-08-17 07:00:00	AAPL	Stock	40.2125	40.22	40.08	40.1	40244.0
2017-08-17 08:00:00	AAPL	Stock	40.1	40.1625	40.065	40.1125	218480.0
2017-08-17 09:00:00	AAPL	Stock	40.125	40.1775	39.91	39.96	12080440.0
2017-08-17 10:00:00	AAPL	Stock	39.96	39.97	39.6005	39.765	20284372.0
2017-08-17 11:00:00	AAPL	Stock	39.77	39.9288	39.745	39.82	10441528.0
2017-08-17 12:00:00	AAPL	Stock	39.82	39.8782	39.635	39.675	9993320.0
2017-08-17 13:00:00	AAPL	Stock	39.6725	39.7975	39.61	39.77	8973896.0
2017-08-17 14:00:00	AAPL	Stock	39.7725	39.794	39.62	39.688	8674136.0
2017-08-17 15:00:00	AAPL	Stock	39.69	39.695	39.46	39.465	20879048.0
2017-08-17 16:00:00	AAPL	Stock	39.48	40.1575	39.465	39.5075	7862132.0
2017-08-17 17:00:00	AAPL	Stock	39.5325	39.55	39.465	39.4875	524620.0
2017-08-17 18:00:00	AAPL	Stock	39.4875	39.5225	39.4825	39.49	111036.0
2017-08-17 19:00:00	AAPL	Stock	39.4875	39.525	39.4875	39.505	123180.0
2017-08-17 06:00:00	MSFT	Stock	73.4	73.4	73.4	73.4	700.0
2017-08-17 07:00:00	MSFT	Stock	73.42	73.42	73.4	73.4	3495.0
2017-08-17 08:00:00	MSFT	Stock	73.55	73.55	73.26	73.41	998.0
2017-08-17 09:00:00	MSFT	Stock	73.31	73.87	73.31	73.76	1779327.0
2017-08-17 10:00:00	MSFT	Stock	73.76	73.79	73.09	73.1	3544890.0
2017-08-17 11:00:00	MSFT	Stock	73.11	73.33	73.09	73.143	1665426.0
2017-08-17 12:00:00	MSFT	Stock	73.145	73.22	72.68	72.74	2214469.0
2017-08-17 13:00:00	MSFT	Stock	72.74	73.0	72.55	72.9	2271353.0
2017-08-17 14:00:00	MSFT	Stock	72.905	72.93	72.63	72.716	1628237.0
2017-08-17 15:00:00	MSFT	Stock	72.72	72.73	72.4	72.41	4672456.0
2017-08-17 16:00:00	MSFT	Stock	72.4	72.47	72.24	72.24	2616365.0
2017-08-17 17:00:00	MSFT	Stock	72.24	72.34	72.24	72.28	4101.0
2017-08-17 18:00:00	MSFT	Stock	72.31	72.33	72.23	72.33	2492.0
2017-08-17 19:00:00	MSFT	Stock	72.33	72.33	72.3	72.31	700.0
2017-08-17 04:00:00	NVDA	Stock	4.1188	4.1188	4.115	4.115	60000.0
2017-08-17 06:00:00	NVDA	Stock	4.1012	4.105	4.0812	4.1	134520.0
2017-08-17 07:00:00	NVDA	Stock	4.0922	4.1112	4.0922	4.0963	419480.0
2017-08-17 08:00:00	NVDA	Stock	4.1	4.1125	4.0875	4.105	1867440.0
2017-08-17 09:00:00	NVDA	Stock	4.101	4.1375	4.0803	4.112	78928960.0
2017-08-17 10:00:00	NVDA	Stock	4.112	4.119	4.07	4.0759	118734920.0
2017-08-17 11:00:00	NVDA	Stock	4.0762	4.1045	4.0752	4.101	45724240.0
2017-08-17 12:00:00	NVDA	Stock	4.1012	4.1072	4.057	4.0666	53206840.0
2017-08-17 13:00:00	NVDA	Stock	4.0673	4.0848	4.0565	4.0748	45494000.0
2017-08-17 14:00:00	NVDA	Stock	4.0744	4.0782	4.058	4.0638	43997920.0
2017-08-17 15:00:00	NVDA	Stock	4.0647	4.0651	4.0345	4.0368	98737120.0
2017-08-17 16:00:00	NVDA	Stock	4.037	4.0417	4.0312	4.0365	3293680.0
2017-08-17 17:00:00	NVDA	Stock	4.0365	4.0505	4.0365	4.0495	731200.0
2017-08-17 18:00:00	NVDA	Stock	4.0495	4.0495	4.042	4.045	2286160.0
2017-08-17 19:00:00	NVDA	Stock	4.0413	4.05	4.0413	4.0488	990800.0
2017-08-17 07:00:00	AMZN	Stock	48.8995	48.8995	48.7845	48.7845	32060.0
2017-08-17 08:00:00	AMZN	Stock	48.8105	48.8105	48.725	48.7705	58040.0
2017-08-17 09:00:00	AMZN	Stock	48.7705	48.892	48.6782	48.693	6770280.0
2017-08-17 10:00:00	AMZN	Stock	48.684	48.72	48.3875	48.3925	12266240.0
2017-08-17 11:00:00	AMZN	Stock	48.3865	48.54	48.296	48.345	6938060.0
2017-08-17 12:00:00	AMZN	Stock	48.3482	48.413	48.1835	48.261	6460720.0

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

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