PREVIEW / stock_1hour / 2020-08-19

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-08-19.parquet
  size:    1.2 MB
  rows:    56,638
  symbols: 2,463

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-08-19 04:00:00	AAPL	Stock	115.97	116.0275	115.8675	116.025	11560.0
2020-08-19 05:00:00	AAPL	Stock	116.07	116.125	116.05	116.05	3136.0
2020-08-19 06:00:00	AAPL	Stock	116.0325	116.0625	115.9525	116.0575	26560.0
2020-08-19 07:00:00	AAPL	Stock	116.04	116.075	115.5625	115.795	233412.0
2020-08-19 08:00:00	AAPL	Stock	115.9	116.0625	115.4525	115.625	420712.0
2020-08-19 09:00:00	AAPL	Stock	115.6225	116.594	115.5625	116.1628	15797716.0
2020-08-19 10:00:00	AAPL	Stock	116.165	117.0225	116.1588	116.9815	19643272.0
2020-08-19 11:00:00	AAPL	Stock	116.98	117.1625	116.6375	117.005	13928408.0
2020-08-19 12:00:00	AAPL	Stock	117.0025	117.11	116.6738	116.9688	9460904.0
2020-08-19 13:00:00	AAPL	Stock	116.9725	117.025	116.61	116.775	8706252.0
2020-08-19 14:00:00	AAPL	Stock	116.775	116.825	115.61	116.3712	18807008.0
2020-08-19 15:00:00	AAPL	Stock	116.3725	116.4625	115.61	115.7062	18015908.0
2020-08-19 16:00:00	AAPL	Stock	115.7075	116.95	115.7075	115.95	7966200.0
2020-08-19 17:00:00	AAPL	Stock	115.975	116.1875	115.805	115.92	176172.0
2020-08-19 18:00:00	AAPL	Stock	115.8625	116.05	115.8625	115.95	64596.0
2020-08-19 19:00:00	AAPL	Stock	115.9375	115.9375	115.5875	115.615	212256.0
2020-08-19 04:00:00	MSFT	Stock	211.55	211.61	211.55	211.61	2273.0
2020-08-19 05:00:00	MSFT	Stock	211.7	211.9	211.68	211.85	1845.0
2020-08-19 06:00:00	MSFT	Stock	211.81	211.89	211.61	211.61	1540.0
2020-08-19 07:00:00	MSFT	Stock	211.75	211.75	211.3	211.33	16992.0
2020-08-19 08:00:00	MSFT	Stock	211.366	211.6	210.8	211.0	82588.0
2020-08-19 09:00:00	MSFT	Stock	210.997	211.92	209.45	210.1	2276723.0
2020-08-19 10:00:00	MSFT	Stock	210.03	210.9	209.56	210.39	1855278.0
2020-08-19 11:00:00	MSFT	Stock	210.39	211.82	210.12	211.69	1878338.0
2020-08-19 12:00:00	MSFT	Stock	211.683	211.99	211.345	211.99	1688692.0
2020-08-19 13:00:00	MSFT	Stock	211.985	212.1	211.62	211.84	1448336.0
2020-08-19 14:00:00	MSFT	Stock	211.86	211.96	209.59	210.71	2690586.0
2020-08-19 15:00:00	MSFT	Stock	210.71	211.15	209.25	209.7	3630889.0
2020-08-19 16:00:00	MSFT	Stock	209.7	210.2	209.61	209.94	5248293.0
2020-08-19 17:00:00	MSFT	Stock	209.99	210.0	209.75	209.8	17024.0
2020-08-19 18:00:00	MSFT	Stock	209.9	209.95	209.88	209.9	1289.0
2020-08-19 19:00:00	MSFT	Stock	209.9	209.9	209.27	209.33	17468.0
2020-08-19 04:00:00	NVDA	Stock	12.3213	12.3675	12.3213	12.35	121960.0
2020-08-19 05:00:00	NVDA	Stock	12.3605	12.3605	12.3595	12.3595	24800.0
2020-08-19 06:00:00	NVDA	Stock	12.341	12.3498	12.341	12.3493	50520.0
2020-08-19 07:00:00	NVDA	Stock	12.35	12.35	12.2575	12.2748	1710920.0
2020-08-19 08:00:00	NVDA	Stock	12.275	12.35	12.25	12.3245	3696120.0
2020-08-19 09:00:00	NVDA	Stock	12.3243	12.325	12.1262	12.159	78059960.0
2020-08-19 10:00:00	NVDA	Stock	12.1552	12.2988	12.15	12.2701	60661240.0
2020-08-19 11:00:00	NVDA	Stock	12.2728	12.29	12.2	12.2348	37786720.0
2020-08-19 12:00:00	NVDA	Stock	12.2339	12.2912	12.2265	12.271	36388560.0
2020-08-19 13:00:00	NVDA	Stock	12.2713	12.2733	12.2245	12.2292	32371320.0
2020-08-19 14:00:00	NVDA	Stock	12.2275	12.24	12.098	12.1705	83027720.0
2020-08-19 15:00:00	NVDA	Stock	12.1748	12.1998	12.1175	12.1435	93287320.0
2020-08-19 16:00:00	NVDA	Stock	12.15	12.4998	11.9252	12.075	65428000.0
2020-08-19 17:00:00	NVDA	Stock	12.075	12.1398	11.8753	11.9295	22614480.0
2020-08-19 18:00:00	NVDA	Stock	11.9365	12.0265	11.9275	11.9463	6490600.0
2020-08-19 19:00:00	NVDA	Stock	11.95	11.95	11.875	11.8753	4429160.0
2020-08-19 05:00:00	AMZN	Stock	166.25	166.25	166.25	166.25	4480.0
2020-08-19 06:00:00	AMZN	Stock	166.156	166.3495	166.156	166.3425	16520.0

> showing 50 of 56,638 rows — these rows as CSV

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