PREVIEW / stock_1hour / 2018-10-09

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-10-09.parquet
  size:    1.1 MB
  rows:    50,008
  symbols: 2,800

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-10-09 04:00:00	AAPL	Stock	55.8675	55.8675	55.75	55.86	3292.0
2018-10-09 05:00:00	AAPL	Stock	55.8275	55.8325	55.775	55.775	7312.0
2018-10-09 06:00:00	AAPL	Stock	55.695	55.79	55.675	55.79	13020.0
2018-10-09 07:00:00	AAPL	Stock	55.845	55.845	55.435	55.475	246508.0
2018-10-09 08:00:00	AAPL	Stock	55.4975	55.85	55.47	55.8425	548928.0
2018-10-09 09:00:00	AAPL	Stock	55.825	56.2325	55.5615	56.0338	15504588.0
2018-10-09 10:00:00	AAPL	Stock	56.0325	56.7625	55.8325	56.585	19404872.0
2018-10-09 11:00:00	AAPL	Stock	56.59	56.72	56.28	56.6375	10344188.0
2018-10-09 12:00:00	AAPL	Stock	56.6412	56.7175	56.2325	56.356	7090844.0
2018-10-09 13:00:00	AAPL	Stock	56.35	56.555	56.1942	56.4075	6366460.0
2018-10-09 14:00:00	AAPL	Stock	56.4025	56.7048	56.325	56.6655	6556176.0
2018-10-09 15:00:00	AAPL	Stock	56.6675	56.8175	56.57	56.7175	13755136.0
2018-10-09 16:00:00	AAPL	Stock	56.7275	56.7275	56.6325	56.7075	5641616.0
2018-10-09 17:00:00	AAPL	Stock	56.7075	56.7075	56.625	56.685	17792.0
2018-10-09 18:00:00	AAPL	Stock	56.685	56.775	56.6325	56.725	22736.0
2018-10-09 19:00:00	AAPL	Stock	56.75	56.77	56.72	56.7525	40528.0
2018-10-09 05:00:00	MSFT	Stock	110.75	110.75	110.51	110.51	710.0
2018-10-09 06:00:00	MSFT	Stock	110.5	110.8	110.5	110.8	1541.0
2018-10-09 07:00:00	MSFT	Stock	110.67	110.67	110.2	110.2	20622.0
2018-10-09 08:00:00	MSFT	Stock	110.65	110.85	110.2	110.84	54521.0
2018-10-09 09:00:00	MSFT	Stock	110.84	112.2	110.68	111.87	3370610.0
2018-10-09 10:00:00	MSFT	Stock	111.87	113.08	111.4	112.73	4355134.0
2018-10-09 11:00:00	MSFT	Stock	112.735	113.02	112.28	112.73	2681068.0
2018-10-09 12:00:00	MSFT	Stock	112.72	112.8	111.98	111.99	2373136.0
2018-10-09 13:00:00	MSFT	Stock	112.0	112.28	111.63	112.04	1810038.0
2018-10-09 14:00:00	MSFT	Stock	112.04	112.58	111.76	112.5	2105537.0
2018-10-09 15:00:00	MSFT	Stock	112.51	112.76	112.25	112.26	4005497.0
2018-10-09 16:00:00	MSFT	Stock	112.32	112.39	112.2	112.39	2582629.0
2018-10-09 17:00:00	MSFT	Stock	112.3	112.39	112.26	112.27	3705.0
2018-10-09 18:00:00	MSFT	Stock	112.36	112.4	112.36	112.4	2414.0
2018-10-09 19:00:00	MSFT	Stock	112.47	112.59	112.47	112.5	7285.0
2018-10-09 04:00:00	NVDA	Stock	6.6403	6.6475	6.628	6.628	33560.0
2018-10-09 06:00:00	NVDA	Stock	6.6375	6.6375	6.635	6.6362	19240.0
2018-10-09 07:00:00	NVDA	Stock	6.625	6.635	6.5843	6.5875	337920.0
2018-10-09 08:00:00	NVDA	Stock	6.6232	6.6483	6.5758	6.6438	1683440.0
2018-10-09 09:00:00	NVDA	Stock	6.6332	6.719	6.5778	6.6318	58862640.0
2018-10-09 10:00:00	NVDA	Stock	6.6335	6.6933	6.57	6.6612	64557120.0
2018-10-09 11:00:00	NVDA	Stock	6.6602	6.6745	6.622	6.6542	24210920.0
2018-10-09 12:00:00	NVDA	Stock	6.6502	6.659	6.6082	6.6085	23825840.0
2018-10-09 13:00:00	NVDA	Stock	6.608	6.6498	6.5968	6.6323	18907160.0
2018-10-09 14:00:00	NVDA	Stock	6.632	6.6498	6.6095	6.6433	20936640.0
2018-10-09 15:00:00	NVDA	Stock	6.6438	6.6495	6.6125	6.6382	24605160.0
2018-10-09 16:00:00	NVDA	Stock	6.6385	6.6392	6.6292	6.6375	17388840.0
2018-10-09 17:00:00	NVDA	Stock	6.6398	6.6398	6.635	6.6368	47440.0
2018-10-09 18:00:00	NVDA	Stock	6.627	6.647	6.627	6.647	70200.0
2018-10-09 19:00:00	NVDA	Stock	6.647	6.647	6.6398	6.6428	66680.0
2018-10-09 04:00:00	AMZN	Stock	93.2	93.201	93.05	93.05	8060.0
2018-10-09 06:00:00	AMZN	Stock	92.8	92.9	92.8	92.9	30280.0
2018-10-09 07:00:00	AMZN	Stock	92.9125	92.9125	92.4	92.4	330120.0
2018-10-09 08:00:00	AMZN	Stock	92.8	93.05	92.35	93.05	526800.0

> showing 50 of 50,008 rows — these rows as CSV

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