PREVIEW / stock_1hour / 2019-09-18

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-09-18.parquet
  size:    1.1 MB
  rows:    50,476
  symbols: 2,552

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-09-18 04:00:00	AAPL	Stock	55.25	55.25	55.2	55.25	15784.0
2019-09-18 05:00:00	AAPL	Stock	55.2	55.2325	55.1875	55.2325	5792.0
2019-09-18 06:00:00	AAPL	Stock	55.225	55.225	55.1175	55.175	14052.0
2019-09-18 07:00:00	AAPL	Stock	55.2	55.245	55.0125	55.125	118324.0
2019-09-18 08:00:00	AAPL	Stock	55.175	55.3375	55.1125	55.3125	207756.0
2019-09-18 09:00:00	AAPL	Stock	55.32	55.5275	55.17	55.465	12308036.0
2019-09-18 10:00:00	AAPL	Stock	55.4648	55.63	55.46	55.5425	11661576.0
2019-09-18 11:00:00	AAPL	Stock	55.5425	55.575	55.4275	55.4675	5239660.0
2019-09-18 12:00:00	AAPL	Stock	55.465	55.495	55.2875	55.295	5476104.0
2019-09-18 13:00:00	AAPL	Stock	55.295	55.3308	55.1475	55.3008	6277264.0
2019-09-18 14:00:00	AAPL	Stock	55.306	55.4575	54.86	55.2	18410472.0
2019-09-18 15:00:00	AAPL	Stock	55.2	55.7125	55.175	55.6925	18147784.0
2019-09-18 16:00:00	AAPL	Stock	55.6925	55.75	55.4022	55.7375	7332528.0
2019-09-18 17:00:00	AAPL	Stock	55.73	55.7425	55.7	55.705	29488.0
2019-09-18 18:00:00	AAPL	Stock	55.7075	55.7125	55.66	55.6875	78268.0
2019-09-18 19:00:00	AAPL	Stock	55.675	55.6825	55.575	55.59	50224.0
2019-09-18 07:00:00	MSFT	Stock	137.37	137.44	137.06	137.15	9210.0
2019-09-18 08:00:00	MSFT	Stock	137.3	137.73	137.1	137.32	14689.0
2019-09-18 09:00:00	MSFT	Stock	137.27	137.43	136.585	137.304	1651906.0
2019-09-18 10:00:00	MSFT	Stock	137.3	137.81	137.13	137.805	1778087.0
2019-09-18 11:00:00	MSFT	Stock	137.8	138.07	137.6	137.78	1447001.0
2019-09-18 12:00:00	MSFT	Stock	137.78	138.17	137.72	137.73	1403829.0
2019-09-18 13:00:00	MSFT	Stock	137.74	137.77	137.38	137.766	1178097.0
2019-09-18 14:00:00	MSFT	Stock	137.78	138.05	136.53	137.13	4043716.0
2019-09-18 15:00:00	MSFT	Stock	137.12	138.67	136.9	138.53	3986176.0
2019-09-18 16:00:00	MSFT	Stock	138.52	140.4	138.52	140.3	4953140.0
2019-09-18 17:00:00	MSFT	Stock	140.3	140.4	140.15	140.32	71785.0
2019-09-18 18:00:00	MSFT	Stock	140.26	140.45	140.21	140.35	25883.0
2019-09-18 19:00:00	MSFT	Stock	140.35	140.4	140.15	140.17	27827.0
2019-09-18 04:00:00	NVDA	Stock	4.5212	4.525	4.5212	4.525	40120.0
2019-09-18 07:00:00	NVDA	Stock	4.5175	4.5222	4.5112	4.5112	87680.0
2019-09-18 08:00:00	NVDA	Stock	4.5222	4.5455	4.5125	4.5375	206320.0
2019-09-18 09:00:00	NVDA	Stock	4.537	4.537	4.5088	4.51	32129400.0
2019-09-18 10:00:00	NVDA	Stock	4.5102	4.5205	4.4942	4.4989	25018640.0
2019-09-18 11:00:00	NVDA	Stock	4.4994	4.508	4.486	4.4898	14633960.0
2019-09-18 12:00:00	NVDA	Stock	4.4894	4.499	4.4835	4.4838	11992720.0
2019-09-18 13:00:00	NVDA	Stock	4.4842	4.4915	4.4655	4.4732	17612360.0
2019-09-18 14:00:00	NVDA	Stock	4.4738	4.4888	4.4125	4.4338	43272680.0
2019-09-18 15:00:00	NVDA	Stock	4.4324	4.5013	4.429	4.4998	48239080.0
2019-09-18 16:00:00	NVDA	Stock	4.4995	4.5063	4.4781	4.505	19123640.0
2019-09-18 17:00:00	NVDA	Stock	4.5	4.5085	4.5	4.5078	207680.0
2019-09-18 18:00:00	NVDA	Stock	4.5058	4.5058	4.4975	4.5	411280.0
2019-09-18 19:00:00	NVDA	Stock	4.5	4.5	4.4948	4.4948	122640.0
2019-09-18 04:00:00	AMZN	Stock	91.1055	91.1055	91.1055	91.1055	2000.0
2019-09-18 07:00:00	AMZN	Stock	90.95	90.978	90.8525	90.8525	45700.0
2019-09-18 08:00:00	AMZN	Stock	90.9037	91.355	90.8005	91.02	100340.0
2019-09-18 09:00:00	AMZN	Stock	91.0005	91.103	90.7625	90.8802	4655780.0
2019-09-18 10:00:00	AMZN	Stock	90.8722	90.955	90.5765	90.732	4665160.0
2019-09-18 11:00:00	AMZN	Stock	90.7378	90.7415	90.526	90.6025	2713020.0
2019-09-18 12:00:00	AMZN	Stock	90.608	90.635	90.2834	90.327	3359380.0

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

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