PREVIEW / stock_1hour / 2020-06-23

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-06-23.parquet
  size:    1.2 MB
  rows:    57,195
  symbols: 2,446

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
2020-06-23 04:00:00	AAPL	Stock	90.8525	91.0	90.615	90.785	67096.0
2020-06-23 05:00:00	AAPL	Stock	90.8	90.9875	90.775	90.7775	13732.0
2020-06-23 06:00:00	AAPL	Stock	90.7525	91.125	90.75	90.97	158352.0
2020-06-23 07:00:00	AAPL	Stock	90.89	91.225	90.825	91.1625	580480.0
2020-06-23 08:00:00	AAPL	Stock	91.0625	91.3175	90.875	91.061	1170816.0
2020-06-23 09:00:00	AAPL	Stock	91.065	91.3175	90.5675	91.2628	22388036.0
2020-06-23 10:00:00	AAPL	Stock	91.2625	91.66	91.075	91.3928	23006308.0
2020-06-23 11:00:00	AAPL	Stock	91.3925	92.11	91.23	92.105	17189676.0
2020-06-23 12:00:00	AAPL	Stock	92.1025	92.5	92.0275	92.4062	20775216.0
2020-06-23 13:00:00	AAPL	Stock	92.405	93.095	92.365	92.785	27174936.0
2020-06-23 14:00:00	AAPL	Stock	92.781	92.8175	92.235	92.2375	23077956.0
2020-06-23 15:00:00	AAPL	Stock	92.25	92.3675	91.5075	91.5925	31618316.0
2020-06-23 16:00:00	AAPL	Stock	91.605	91.9962	91.4525	91.5875	8419600.0
2020-06-23 17:00:00	AAPL	Stock	91.5875	91.6	91.4325	91.4375	134492.0
2020-06-23 18:00:00	AAPL	Stock	91.435	91.5	91.1525	91.1575	260380.0
2020-06-23 19:00:00	AAPL	Stock	91.1575	91.4625	91.0875	91.3	139416.0
2020-06-23 04:00:00	MSFT	Stock	202.28	202.88	202.28	202.5	4957.0
2020-06-23 05:00:00	MSFT	Stock	202.57	202.58	202.4	202.58	1470.0
2020-06-23 06:00:00	MSFT	Stock	202.6	203.1	202.54	202.94	14765.0
2020-06-23 07:00:00	MSFT	Stock	202.75	203.15	202.1	202.35	43871.0
2020-06-23 08:00:00	MSFT	Stock	202.66	203.17	202.11	202.3	113026.0
2020-06-23 09:00:00	MSFT	Stock	202.37	203.27	201.425	202.106	5314283.0
2020-06-23 10:00:00	MSFT	Stock	202.125	202.97	201.757	202.23	3453095.0
2020-06-23 11:00:00	MSFT	Stock	202.23	203.54	201.98	203.12	3166855.0
2020-06-23 12:00:00	MSFT	Stock	203.12	203.49	202.88	203.397	2168723.0
2020-06-23 13:00:00	MSFT	Stock	203.4	203.95	203.19	203.458	2483128.0
2020-06-23 14:00:00	MSFT	Stock	203.46	203.6	202.51	202.575	2187446.0
2020-06-23 15:00:00	MSFT	Stock	202.59	202.88	201.43	201.889	4694982.0
2020-06-23 16:00:00	MSFT	Stock	201.91	202.638	201.5	201.65	3082742.0
2020-06-23 17:00:00	MSFT	Stock	201.6	201.7	201.4	201.55	14386.0
2020-06-23 18:00:00	MSFT	Stock	201.5	201.75	201.3	201.3	15515.0
2020-06-23 19:00:00	MSFT	Stock	201.36	201.68	201.17	201.6	17723.0
2020-06-23 04:00:00	NVDA	Stock	9.5998	9.5998	9.5998	9.5998	4000.0
2020-06-23 05:00:00	NVDA	Stock	9.593	9.5985	9.593	9.5985	11120.0
2020-06-23 06:00:00	NVDA	Stock	9.5975	9.5975	9.5975	9.5975	4000.0
2020-06-23 07:00:00	NVDA	Stock	9.5975	9.5985	9.54	9.5622	655920.0
2020-06-23 08:00:00	NVDA	Stock	9.5825	9.5985	9.54	9.5692	1145640.0
2020-06-23 09:00:00	NVDA	Stock	9.57	9.5798	9.4582	9.5278	66361400.0
2020-06-23 10:00:00	NVDA	Stock	9.5238	9.5865	9.4892	9.5669	50258120.0
2020-06-23 11:00:00	NVDA	Stock	9.5659	9.629	9.5565	9.6288	35068480.0
2020-06-23 12:00:00	NVDA	Stock	9.63	9.6425	9.5856	9.606	35144000.0
2020-06-23 13:00:00	NVDA	Stock	9.606	9.6138	9.5632	9.571	31302000.0
2020-06-23 14:00:00	NVDA	Stock	9.57	9.5745	9.5038	9.5076	29637200.0
2020-06-23 15:00:00	NVDA	Stock	9.505	9.5228	9.4075	9.451	66680120.0
2020-06-23 16:00:00	NVDA	Stock	9.45	9.534	9.431	9.4463	5047800.0
2020-06-23 17:00:00	NVDA	Stock	9.4415	9.45	9.4348	9.45	157000.0
2020-06-23 18:00:00	NVDA	Stock	9.4475	9.45	9.4365	9.4365	211480.0
2020-06-23 19:00:00	NVDA	Stock	9.435	9.4388	9.4225	9.425	319360.0
2020-06-23 06:00:00	AMZN	Stock	136.849	136.9995	136.749	136.8	40580.0
2020-06-23 07:00:00	AMZN	Stock	136.843	136.95	136.7	136.7375	138560.0

> showing 50 of 57,195 rows — these rows as CSV

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