PREVIEW / stock_1hour / 2018-11-15

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-11-15.parquet
  size:    1.1 MB
  rows:    49,621
  symbols: 2,756

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
2018-11-15 04:00:00	AAPL	Stock	47.0	47.15	46.835	46.835	26240.0
2018-11-15 05:00:00	AAPL	Stock	46.7525	46.995	46.75	46.995	35352.0
2018-11-15 06:00:00	AAPL	Stock	47.0225	47.095	46.965	47.0475	26360.0
2018-11-15 07:00:00	AAPL	Stock	47.08	47.175	46.98	47.05	361572.0
2018-11-15 08:00:00	AAPL	Stock	47.065	47.1775	46.93	47.1	1042804.0
2018-11-15 09:00:00	AAPL	Stock	47.1	47.36	46.8125	46.9325	23740912.0
2018-11-15 10:00:00	AAPL	Stock	46.9325	47.2225	46.725	47.13	21608000.0
2018-11-15 11:00:00	AAPL	Stock	47.135	47.72	47.0725	47.557	26825220.0
2018-11-15 12:00:00	AAPL	Stock	47.555	47.6148	47.24	47.315	15387976.0
2018-11-15 13:00:00	AAPL	Stock	47.3125	47.8575	47.225	47.7888	17252984.0
2018-11-15 14:00:00	AAPL	Stock	47.7875	47.98	47.6575	47.8532	13160688.0
2018-11-15 15:00:00	AAPL	Stock	47.8525	47.9925	47.55	47.8525	25595024.0
2018-11-15 16:00:00	AAPL	Stock	47.8525	47.9375	47.575	47.6875	13287496.0
2018-11-15 17:00:00	AAPL	Stock	47.6875	47.8525	47.5025	47.525	160356.0
2018-11-15 18:00:00	AAPL	Stock	47.525	47.61	47.505	47.55	125840.0
2018-11-15 19:00:00	AAPL	Stock	47.55	47.625	47.5125	47.5125	105564.0
2018-11-15 04:00:00	MSFT	Stock	105.04	105.04	105.0	105.0	2171.0
2018-11-15 05:00:00	MSFT	Stock	105.29	105.3	105.29	105.3	600.0
2018-11-15 06:00:00	MSFT	Stock	105.38	105.38	105.35	105.35	200.0
2018-11-15 07:00:00	MSFT	Stock	105.69	105.69	105.22	105.25	8212.0
2018-11-15 08:00:00	MSFT	Stock	105.69	105.75	104.87	104.95	20753.0
2018-11-15 09:00:00	MSFT	Stock	105.11	105.73	104.03	105.03	3363470.0
2018-11-15 10:00:00	MSFT	Stock	105.01	105.33	103.91	105.07	4394557.0
2018-11-15 11:00:00	MSFT	Stock	105.08	105.79	104.86	105.3	3103146.0
2018-11-15 12:00:00	MSFT	Stock	105.29	105.88	105.13	105.4	2608344.0
2018-11-15 13:00:00	MSFT	Stock	105.39	107.21	105.25	107.055	3849766.0
2018-11-15 14:00:00	MSFT	Stock	107.06	107.8	106.88	107.4	3602240.0
2018-11-15 15:00:00	MSFT	Stock	107.39	107.73	106.48	107.28	6719943.0
2018-11-15 16:00:00	MSFT	Stock	107.28	107.64	106.82	107.48	6676336.0
2018-11-15 17:00:00	MSFT	Stock	107.48	107.48	106.9	106.95	43601.0
2018-11-15 18:00:00	MSFT	Stock	106.95	107.23	106.93	107.0	37827.0
2018-11-15 19:00:00	MSFT	Stock	107.0	107.05	106.92	106.96	7716.0
2018-11-15 04:00:00	NVDA	Stock	4.975	4.975	4.961	4.961	29440.0
2018-11-15 05:00:00	NVDA	Stock	4.95	4.9775	4.95	4.975	110360.0
2018-11-15 07:00:00	NVDA	Stock	4.9665	4.9812	4.9653	4.9653	380600.0
2018-11-15 08:00:00	NVDA	Stock	4.985	4.9875	4.9325	4.9375	1363680.0
2018-11-15 09:00:00	NVDA	Stock	4.9362	5.0245	4.8875	4.9875	55543040.0
2018-11-15 10:00:00	NVDA	Stock	4.9845	5.0075	4.9198	4.9525	74254080.0
2018-11-15 11:00:00	NVDA	Stock	4.9492	5.0385	4.932	5.032	50367240.0
2018-11-15 12:00:00	NVDA	Stock	5.0335	5.0712	4.9895	5.0162	53625360.0
2018-11-15 13:00:00	NVDA	Stock	5.015	5.0822	4.9992	5.0714	50148480.0
2018-11-15 14:00:00	NVDA	Stock	5.0738	5.1325	5.069	5.0883	70233840.0
2018-11-15 15:00:00	NVDA	Stock	5.0913	5.0932	5.011	5.0623	119443760.0
2018-11-15 16:00:00	NVDA	Stock	5.0598	5.0875	4.2055	4.2307	173925480.0
2018-11-15 17:00:00	NVDA	Stock	4.2338	4.288	4.091	4.115	69442480.0
2018-11-15 18:00:00	NVDA	Stock	4.1162	4.2545	4.115	4.2025	42094480.0
2018-11-15 19:00:00	NVDA	Stock	4.2022	4.2268	4.193	4.2112	9444400.0
2018-11-15 04:00:00	AMZN	Stock	80.5	80.5	80.287	80.287	9780.0
2018-11-15 05:00:00	AMZN	Stock	80.175	80.4	80.175	80.4	33880.0
2018-11-15 06:00:00	AMZN	Stock	80.5	80.5	80.5	80.5	33440.0

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

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