PREVIEW / stock_1hour / 2020-07-17

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-07-17.parquet
  size:    1.2 MB
  rows:    55,890
  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-07-17 04:00:00	AAPL	Stock	96.2875	96.615	96.255	96.615	6156.0
2020-07-17 05:00:00	AAPL	Stock	96.6325	96.7875	96.5025	96.6525	13460.0
2020-07-17 06:00:00	AAPL	Stock	96.6525	96.7	96.6375	96.7	3600.0
2020-07-17 07:00:00	AAPL	Stock	96.6525	96.825	96.5925	96.7775	104572.0
2020-07-17 08:00:00	AAPL	Stock	96.75	96.9975	96.6028	96.9225	360392.0
2020-07-17 09:00:00	AAPL	Stock	96.875	97.2475	96.225	96.5965	14253072.0
2020-07-17 10:00:00	AAPL	Stock	96.59	96.65	95.84	96.3975	11293344.0
2020-07-17 11:00:00	AAPL	Stock	96.395	96.695	96.23	96.6875	7670024.0
2020-07-17 12:00:00	AAPL	Stock	96.6975	96.87	96.4077	96.4938	6933772.0
2020-07-17 13:00:00	AAPL	Stock	96.4975	96.6025	96.2525	96.2925	6006996.0
2020-07-17 14:00:00	AAPL	Stock	96.2988	96.625	96.295	96.4325	6492636.0
2020-07-17 15:00:00	AAPL	Stock	96.4238	96.68	96.2775	96.2875	11156248.0
2020-07-17 16:00:00	AAPL	Stock	96.29	96.4928	96.0425	96.31	8178304.0
2020-07-17 17:00:00	AAPL	Stock	96.275	96.31	96.2375	96.275	80236.0
2020-07-17 18:00:00	AAPL	Stock	96.275	96.325	96.275	96.2875	50172.0
2020-07-17 19:00:00	AAPL	Stock	96.2875	96.3625	96.2775	96.3625	118052.0
2020-07-17 04:00:00	MSFT	Stock	203.6	204.87	203.6	204.78	2418.0
2020-07-17 05:00:00	MSFT	Stock	204.57	204.69	204.55	204.55	1225.0
2020-07-17 06:00:00	MSFT	Stock	204.4	204.72	204.4	204.56	5282.0
2020-07-17 07:00:00	MSFT	Stock	204.37	204.62	204.05	204.25	27709.0
2020-07-17 08:00:00	MSFT	Stock	204.497	204.88	204.01	204.745	84854.0
2020-07-17 09:00:00	MSFT	Stock	204.666	206.18	201.86	202.82	5260197.0
2020-07-17 10:00:00	MSFT	Stock	202.8	203.05	201.39	202.56	4064924.0
2020-07-17 11:00:00	MSFT	Stock	202.57	202.99	201.922	202.25	2480443.0
2020-07-17 12:00:00	MSFT	Stock	202.25	203.2	202.154	202.69	2562721.0
2020-07-17 13:00:00	MSFT	Stock	202.688	202.915	202.08	202.2	1827096.0
2020-07-17 14:00:00	MSFT	Stock	202.22	203.115	202.193	202.9	2222900.0
2020-07-17 15:00:00	MSFT	Stock	202.9	203.51	202.46	202.87	4335013.0
2020-07-17 16:00:00	MSFT	Stock	202.88	202.88	202.63	202.69	2938993.0
2020-07-17 17:00:00	MSFT	Stock	202.65	202.85	202.51	202.85	25615.0
2020-07-17 18:00:00	MSFT	Stock	202.85	202.88	202.75	202.86	21572.0
2020-07-17 19:00:00	MSFT	Stock	202.85	203.18	202.78	203.18	22973.0
2020-07-17 04:00:00	NVDA	Stock	10.1225	10.131	10.1225	10.131	58960.0
2020-07-17 07:00:00	NVDA	Stock	10.1525	10.1938	10.15	10.1812	655920.0
2020-07-17 08:00:00	NVDA	Stock	10.175	10.2388	10.1521	10.2125	762200.0
2020-07-17 09:00:00	NVDA	Stock	10.2075	10.25	10.0892	10.1688	49430800.0
2020-07-17 10:00:00	NVDA	Stock	10.1652	10.2026	10.0878	10.1309	52396560.0
2020-07-17 11:00:00	NVDA	Stock	10.1327	10.2018	10.1278	10.1885	32309560.0
2020-07-17 12:00:00	NVDA	Stock	10.192	10.224	10.1632	10.1815	30542200.0
2020-07-17 13:00:00	NVDA	Stock	10.1816	10.189	10.1295	10.1628	16711560.0
2020-07-17 14:00:00	NVDA	Stock	10.1628	10.2485	10.1628	10.2288	24744080.0
2020-07-17 15:00:00	NVDA	Stock	10.2288	10.2373	10.1875	10.2025	37700720.0
2020-07-17 16:00:00	NVDA	Stock	10.2015	10.213	10.1888	10.2	6535960.0
2020-07-17 17:00:00	NVDA	Stock	10.1938	10.2	10.1938	10.1998	93800.0
2020-07-17 18:00:00	NVDA	Stock	10.2015	10.2015	10.2015	10.2015	18680.0
2020-07-17 19:00:00	NVDA	Stock	10.2005	10.2125	10.2	10.2025	66320.0
2020-07-17 04:00:00	AMZN	Stock	148.7515	148.7515	148.7515	148.7515	13100.0
2020-07-17 06:00:00	AMZN	Stock	149.499	149.499	149.499	149.499	2000.0
2020-07-17 07:00:00	AMZN	Stock	149.75	149.8	149.3995	149.5	87000.0
2020-07-17 08:00:00	AMZN	Stock	149.6	150.449	149.6	150.15	265080.0

> showing 50 of 55,890 rows — these rows as CSV

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