PREVIEW / stock_1hour / 2020-08-04

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-08-04.parquet
  size:    1.2 MB
  rows:    57,139
  symbols: 2,434

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-04 04:00:00	AAPL	Stock	108.805	108.805	108.29	108.4275	28376.0
2020-08-04 05:00:00	AAPL	Stock	108.625	108.8675	108.625	108.8125	15104.0
2020-08-04 06:00:00	AAPL	Stock	108.785	108.85	108.7275	108.75	11960.0
2020-08-04 07:00:00	AAPL	Stock	108.75	109.33	108.575	108.67	327360.0
2020-08-04 08:00:00	AAPL	Stock	109.0882	109.33	108.5	109.1325	1011136.0
2020-08-04 09:00:00	AAPL	Stock	109.1578	109.845	108.3875	109.5275	22749428.0
2020-08-04 10:00:00	AAPL	Stock	109.52	110.79	109.44	109.7125	33409804.0
2020-08-04 11:00:00	AAPL	Stock	109.72	110.08	109.375	109.9925	17591680.0
2020-08-04 12:00:00	AAPL	Stock	109.9988	110.125	109.52	109.725	13323632.0
2020-08-04 13:00:00	AAPL	Stock	109.7275	110.1775	109.6325	110.0812	10337696.0
2020-08-04 14:00:00	AAPL	Stock	110.0875	110.14	108.99	109.3712	16932732.0
2020-08-04 15:00:00	AAPL	Stock	109.37	109.7375	109.115	109.7025	15921728.0
2020-08-04 16:00:00	AAPL	Stock	109.665	109.73	109.55	109.7125	6001800.0
2020-08-04 17:00:00	AAPL	Stock	109.7	109.7	109.6375	109.665	20068.0
2020-08-04 18:00:00	AAPL	Stock	109.625	109.665	109.555	109.625	40464.0
2020-08-04 19:00:00	AAPL	Stock	109.6725	109.7175	109.6025	109.6625	49432.0
2020-08-04 04:00:00	MSFT	Stock	215.6	215.6	214.53	214.9	22314.0
2020-08-04 05:00:00	MSFT	Stock	214.82	215.4	214.73	215.15	6592.0
2020-08-04 06:00:00	MSFT	Stock	215.13	215.22	214.1	214.37	20064.0
2020-08-04 07:00:00	MSFT	Stock	214.3	214.65	213.17	213.17	210027.0
2020-08-04 08:00:00	MSFT	Stock	214.258	216.54	212.46	213.12	301944.0
2020-08-04 09:00:00	MSFT	Stock	213.13	214.88	212.14	212.95	5976748.0
2020-08-04 10:00:00	MSFT	Stock	212.96	214.17	211.36	211.93	7764556.0
2020-08-04 11:00:00	MSFT	Stock	211.94	212.1	210.31	211.4	5101089.0
2020-08-04 12:00:00	MSFT	Stock	211.42	212.19	210.94	212.13	3549900.0
2020-08-04 13:00:00	MSFT	Stock	212.13	213.15	211.76	212.992	2721153.0
2020-08-04 14:00:00	MSFT	Stock	213.01	213.21	211.13	211.97	3296821.0
2020-08-04 15:00:00	MSFT	Stock	211.97	213.37	211.25	213.35	5179767.0
2020-08-04 16:00:00	MSFT	Stock	213.3	213.3	212.61	212.85	2944333.0
2020-08-04 17:00:00	MSFT	Stock	212.9	212.96	212.68	212.94	13777.0
2020-08-04 18:00:00	MSFT	Stock	212.83	213.0	212.8	212.92	6170.0
2020-08-04 19:00:00	MSFT	Stock	212.95	213.0	212.9	213.0	19646.0
2020-08-04 04:00:00	NVDA	Stock	11.0103	11.0103	10.9998	10.9998	43120.0
2020-08-04 05:00:00	NVDA	Stock	11.0	11.0	11.0	11.0	8000.0
2020-08-04 06:00:00	NVDA	Stock	10.995	10.995	10.9748	10.975	52000.0
2020-08-04 07:00:00	NVDA	Stock	10.9755	10.98	10.96	10.9625	294160.0
2020-08-04 08:00:00	NVDA	Stock	10.9608	11.0045	10.9565	10.995	673600.0
2020-08-04 09:00:00	NVDA	Stock	10.995	11.109	10.906	11.1071	43609160.0
2020-08-04 10:00:00	NVDA	Stock	11.111	11.1738	11.0823	11.1552	45009200.0
2020-08-04 11:00:00	NVDA	Stock	11.1551	11.1559	11.0605	11.1124	32517880.0
2020-08-04 12:00:00	NVDA	Stock	11.1164	11.1425	11.063	11.1288	20807560.0
2020-08-04 13:00:00	NVDA	Stock	11.129	11.1673	11.1063	11.1595	13898960.0
2020-08-04 14:00:00	NVDA	Stock	11.1591	11.1945	11.08	11.1343	29214360.0
2020-08-04 15:00:00	NVDA	Stock	11.1358	11.2278	11.1115	11.2278	35059040.0
2020-08-04 16:00:00	NVDA	Stock	11.2278	11.238	11.2002	11.2375	17239840.0
2020-08-04 17:00:00	NVDA	Stock	11.2305	11.2375	11.2188	11.2188	99200.0
2020-08-04 18:00:00	NVDA	Stock	11.2188	11.2188	11.2075	11.2128	89520.0
2020-08-04 19:00:00	NVDA	Stock	11.2175	11.225	11.2062	11.225	286600.0
2020-08-04 06:00:00	AMZN	Stock	155.65	155.65	154.4005	154.5	84880.0
2020-08-04 07:00:00	AMZN	Stock	155.0	155.244	154.6105	154.692	246340.0

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

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