PREVIEW / stock_1hour / 2019-11-18

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-11-18.parquet
  size:    1.1 MB
  rows:    50,563
  symbols: 2,522

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
2019-11-18 04:00:00	AAPL	Stock	66.525	66.675	66.525	66.625	20284.0
2019-11-18 05:00:00	AAPL	Stock	66.6	66.635	66.5625	66.5625	9000.0
2019-11-18 06:00:00	AAPL	Stock	66.5875	66.625	66.55	66.625	27592.0
2019-11-18 07:00:00	AAPL	Stock	66.625	66.8	66.625	66.79	238688.0
2019-11-18 08:00:00	AAPL	Stock	66.6725	66.81	66.42	66.55	1145788.0
2019-11-18 09:00:00	AAPL	Stock	66.555	66.5725	66.0575	66.1525	12513840.0
2019-11-18 10:00:00	AAPL	Stock	66.15	66.4225	66.14	66.31	9880180.0
2019-11-18 11:00:00	AAPL	Stock	66.3105	66.52	66.285	66.4975	7361964.0
2019-11-18 12:00:00	AAPL	Stock	66.4925	66.6225	66.3625	66.5875	5538180.0
2019-11-18 13:00:00	AAPL	Stock	66.5888	66.7475	66.5425	66.7085	6251628.0
2019-11-18 14:00:00	AAPL	Stock	66.7125	66.8575	66.64	66.799	7147184.0
2019-11-18 15:00:00	AAPL	Stock	66.7988	66.8175	66.65	66.78	11044480.0
2019-11-18 16:00:00	AAPL	Stock	66.775	66.945	66.73	66.9	10299036.0
2019-11-18 17:00:00	AAPL	Stock	66.9125	66.9125	66.7925	66.8125	148624.0
2019-11-18 18:00:00	AAPL	Stock	66.8125	66.825	66.78	66.82	34832.0
2019-11-18 19:00:00	AAPL	Stock	66.795	66.8	66.685	66.75	66716.0
2019-11-18 04:00:00	MSFT	Stock	150.0	150.69	150.0	150.4	2032.0
2019-11-18 05:00:00	MSFT	Stock	150.4	150.44	150.26	150.26	11423.0
2019-11-18 06:00:00	MSFT	Stock	150.28	150.45	150.28	150.36	5258.0
2019-11-18 07:00:00	MSFT	Stock	150.4	150.44	150.2	150.43	34848.0
2019-11-18 08:00:00	MSFT	Stock	150.35	150.45	149.9	149.96	101175.0
2019-11-18 09:00:00	MSFT	Stock	150.0	150.16	149.15	149.3	2554113.0
2019-11-18 10:00:00	MSFT	Stock	149.3	149.53	148.98	149.44	2706859.0
2019-11-18 11:00:00	MSFT	Stock	149.44	149.86	149.19	149.86	2178390.0
2019-11-18 12:00:00	MSFT	Stock	149.855	150.04	149.59	149.726	1303842.0
2019-11-18 13:00:00	MSFT	Stock	149.73	150.32	149.67	150.29	1340128.0
2019-11-18 14:00:00	MSFT	Stock	150.297	150.55	150.2	150.4	1630583.0
2019-11-18 15:00:00	MSFT	Stock	150.407	150.44	150.07	150.34	2955364.0
2019-11-18 16:00:00	MSFT	Stock	150.34	150.55	150.15	150.55	3504518.0
2019-11-18 17:00:00	MSFT	Stock	150.47	150.5	150.39	150.4	4013.0
2019-11-18 18:00:00	MSFT	Stock	150.45	150.45	150.28	150.32	4112.0
2019-11-18 19:00:00	MSFT	Stock	150.3	150.32	150.2	150.32	14927.0
2019-11-18 04:00:00	NVDA	Stock	5.1048	5.1368	5.1048	5.1322	168360.0
2019-11-18 05:00:00	NVDA	Stock	5.125	5.125	5.125	5.125	4000.0
2019-11-18 07:00:00	NVDA	Stock	5.13	5.13	5.1125	5.1195	516000.0
2019-11-18 08:00:00	NVDA	Stock	5.1246	5.125	5.0818	5.0938	1972240.0
2019-11-18 09:00:00	NVDA	Stock	5.0975	5.2245	5.0763	5.2202	82433840.0
2019-11-18 10:00:00	NVDA	Stock	5.2202	5.2915	5.2008	5.2835	103098240.0
2019-11-18 11:00:00	NVDA	Stock	5.284	5.3173	5.2755	5.2925	76800200.0
2019-11-18 12:00:00	NVDA	Stock	5.2925	5.3	5.2712	5.2925	45918080.0
2019-11-18 13:00:00	NVDA	Stock	5.2928	5.319	5.284	5.3162	45599920.0
2019-11-18 14:00:00	NVDA	Stock	5.316	5.3275	5.3089	5.32	43458400.0
2019-11-18 15:00:00	NVDA	Stock	5.3198	5.3338	5.2878	5.3068	84950200.0
2019-11-18 16:00:00	NVDA	Stock	5.307	5.3123	5.2642	5.3095	6642440.0
2019-11-18 17:00:00	NVDA	Stock	5.3112	5.3112	5.3038	5.3068	5940440.0
2019-11-18 18:00:00	NVDA	Stock	5.307	5.311	5.3045	5.31	322440.0
2019-11-18 19:00:00	NVDA	Stock	5.3098	5.3098	5.3038	5.3038	357360.0
2019-11-18 06:00:00	AMZN	Stock	87.149	87.149	87.149	87.149	2560.0
2019-11-18 07:00:00	AMZN	Stock	87.1	87.1	87.0675	87.1	24300.0
2019-11-18 08:00:00	AMZN	Stock	87.141	87.189	86.8	86.8982	153640.0

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

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