PREVIEW / stock_1hour / 2019-11-04

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-11-04.parquet
  size:    1.1 MB
  rows:    51,012
  symbols: 2,498

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-04 04:00:00	AAPL	Stock	64.1375	64.3725	64.1375	64.2975	25652.0
2019-11-04 05:00:00	AAPL	Stock	64.2975	64.375	64.25	64.375	51076.0
2019-11-04 06:00:00	AAPL	Stock	64.38	64.4475	64.2875	64.325	64416.0
2019-11-04 07:00:00	AAPL	Stock	64.3625	64.47	64.325	64.435	487604.0
2019-11-04 08:00:00	AAPL	Stock	64.4	64.5	64.3325	64.45	717244.0
2019-11-04 09:00:00	AAPL	Stock	64.45	64.45	63.845	64.116	24111268.0
2019-11-04 10:00:00	AAPL	Stock	64.115	64.3625	64.0775	64.2388	14413964.0
2019-11-04 11:00:00	AAPL	Stock	64.2388	64.285	64.05	64.0675	8973260.0
2019-11-04 12:00:00	AAPL	Stock	64.065	64.125	63.855	64.0912	8080736.0
2019-11-04 13:00:00	AAPL	Stock	64.0898	64.25	64.05	64.2025	5635192.0
2019-11-04 14:00:00	AAPL	Stock	64.2	64.3425	64.1412	64.3425	6160612.0
2019-11-04 15:00:00	AAPL	Stock	64.3388	64.4613	64.2275	64.37	12897508.0
2019-11-04 16:00:00	AAPL	Stock	64.375	64.4	64.2875	64.375	7058288.0
2019-11-04 17:00:00	AAPL	Stock	64.375	64.395	64.35	64.35	69672.0
2019-11-04 18:00:00	AAPL	Stock	64.35	64.575	64.3	64.53	214108.0
2019-11-04 19:00:00	AAPL	Stock	64.53	64.55	64.475	64.4975	137432.0
2019-11-04 04:00:00	MSFT	Stock	144.05	144.77	144.05	144.77	1597.0
2019-11-04 05:00:00	MSFT	Stock	144.7	144.8	144.65	144.75	5104.0
2019-11-04 06:00:00	MSFT	Stock	144.75	144.75	144.6	144.6	880.0
2019-11-04 07:00:00	MSFT	Stock	144.6	144.67	144.51	144.53	16348.0
2019-11-04 08:00:00	MSFT	Stock	144.63	144.74	144.5	144.55	84102.0
2019-11-04 09:00:00	MSFT	Stock	144.52	145.0	144.22	144.415	2279889.0
2019-11-04 10:00:00	MSFT	Stock	144.41	144.73	144.16	144.43	2062270.0
2019-11-04 11:00:00	MSFT	Stock	144.44	144.75	144.39	144.6	1665823.0
2019-11-04 12:00:00	MSFT	Stock	144.6	144.8	144.524	144.76	1298408.0
2019-11-04 13:00:00	MSFT	Stock	144.767	144.81	144.62	144.65	1162403.0
2019-11-04 14:00:00	MSFT	Stock	144.65	144.69	144.37	144.39	1312994.0
2019-11-04 15:00:00	MSFT	Stock	144.385	144.715	144.26	144.52	2475637.0
2019-11-04 16:00:00	MSFT	Stock	144.5	144.6	144.36	144.53	2470216.0
2019-11-04 17:00:00	MSFT	Stock	144.6	144.7	144.53	144.55	7614.0
2019-11-04 18:00:00	MSFT	Stock	144.62	145.0	144.51	144.86	12729.0
2019-11-04 19:00:00	MSFT	Stock	144.86	144.87	144.65	144.65	4190.0
2019-11-04 04:00:00	NVDA	Stock	5.0788	5.1298	5.0788	5.129	94840.0
2019-11-04 05:00:00	NVDA	Stock	5.125	5.125	5.1225	5.1225	56000.0
2019-11-04 06:00:00	NVDA	Stock	5.125	5.125	5.1212	5.125	57520.0
2019-11-04 07:00:00	NVDA	Stock	5.123	5.123	5.1078	5.122	370920.0
2019-11-04 08:00:00	NVDA	Stock	5.1125	5.1438	5.1062	5.1313	1778600.0
2019-11-04 09:00:00	NVDA	Stock	5.131	5.167	5.1278	5.1519	47254240.0
2019-11-04 10:00:00	NVDA	Stock	5.1515	5.19	5.123	5.1728	57790920.0
2019-11-04 11:00:00	NVDA	Stock	5.173	5.1965	5.1585	5.1641	36006000.0
2019-11-04 12:00:00	NVDA	Stock	5.1648	5.1765	5.1515	5.1702	21571480.0
2019-11-04 13:00:00	NVDA	Stock	5.171	5.1812	5.162	5.1804	16656240.0
2019-11-04 14:00:00	NVDA	Stock	5.1806	5.2273	5.1765	5.2222	50969760.0
2019-11-04 15:00:00	NVDA	Stock	5.2222	5.275	5.2125	5.2643	99572480.0
2019-11-04 16:00:00	NVDA	Stock	5.2625	5.266	5.2563	5.2625	17031360.0
2019-11-04 17:00:00	NVDA	Stock	5.2625	5.266	5.2605	5.2638	230600.0
2019-11-04 18:00:00	NVDA	Stock	5.2655	5.297	5.263	5.295	680280.0
2019-11-04 19:00:00	NVDA	Stock	5.2913	5.2913	5.275	5.2848	523560.0
2019-11-04 04:00:00	AMZN	Stock	89.9	90.1	89.9	90.1	13040.0
2019-11-04 05:00:00	AMZN	Stock	90.2	90.2	90.183	90.183	12240.0

> showing 50 of 51,012 rows — these rows as CSV

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