PREVIEW / stock_1hour / 2020-07-29

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-07-29.parquet
  size:    1.2 MB
  rows:    57,062
  symbols: 2,443

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-29 04:00:00	AAPL	Stock	93.85	93.9225	93.8025	93.8725	5192.0
2020-07-29 05:00:00	AAPL	Stock	93.75	93.75	93.75	93.75	2552.0
2020-07-29 06:00:00	AAPL	Stock	93.8925	93.945	93.7825	93.885	19364.0
2020-07-29 07:00:00	AAPL	Stock	93.925	94.03	93.8275	93.8975	145848.0
2020-07-29 08:00:00	AAPL	Stock	93.9265	94.125	93.7975	93.905	346336.0
2020-07-29 09:00:00	AAPL	Stock	93.9125	94.425	93.2525	94.2625	11078304.0
2020-07-29 10:00:00	AAPL	Stock	94.2725	94.82	94.255	94.605	12451600.0
2020-07-29 11:00:00	AAPL	Stock	94.6025	94.6575	94.35	94.56	6342712.0
2020-07-29 12:00:00	AAPL	Stock	94.5525	94.5525	94.09	94.3472	5643384.0
2020-07-29 13:00:00	AAPL	Stock	94.35	94.426	94.0875	94.165	5140672.0
2020-07-29 14:00:00	AAPL	Stock	94.1642	95.1442	94.0425	94.7575	11116404.0
2020-07-29 15:00:00	AAPL	Stock	94.7652	95.23	94.4425	95.0675	13192440.0
2020-07-29 16:00:00	AAPL	Stock	95.04	95.58	94.97	95.37	4539336.0
2020-07-29 17:00:00	AAPL	Stock	95.375	95.43	95.3125	95.4	110552.0
2020-07-29 18:00:00	AAPL	Stock	95.375	95.375	95.1	95.2225	249480.0
2020-07-29 19:00:00	AAPL	Stock	95.1875	95.2475	95.125	95.225	85628.0
2020-07-29 04:00:00	MSFT	Stock	202.9	202.99	202.88	202.89	1442.0
2020-07-29 05:00:00	MSFT	Stock	202.9	202.9	202.9	202.9	100.0
2020-07-29 07:00:00	MSFT	Stock	203.01	203.1	202.65	203.1	25682.0
2020-07-29 08:00:00	MSFT	Stock	203.06	203.48	201.976	203.0	67836.0
2020-07-29 09:00:00	MSFT	Stock	203.0	203.38	202.01	203.36	2678297.0
2020-07-29 10:00:00	MSFT	Stock	203.37	204.48	203.33	203.74	3106898.0
2020-07-29 11:00:00	MSFT	Stock	203.76	204.055	203.27	203.626	1435077.0
2020-07-29 12:00:00	MSFT	Stock	203.62	203.794	203.08	203.76	1206924.0
2020-07-29 13:00:00	MSFT	Stock	203.76	204.16	203.47	203.565	1192699.0
2020-07-29 14:00:00	MSFT	Stock	203.55	204.59	203.23	203.85	1918353.0
2020-07-29 15:00:00	MSFT	Stock	203.86	204.65	203.3	204.06	3239113.0
2020-07-29 16:00:00	MSFT	Stock	204.06	204.25	203.93	204.2	1555090.0
2020-07-29 17:00:00	MSFT	Stock	204.19	204.27	204.06	204.1	10006.0
2020-07-29 18:00:00	MSFT	Stock	204.08	204.15	204.0	204.14	7491.0
2020-07-29 19:00:00	MSFT	Stock	204.15	204.16	203.94	204.04	6444.0
2020-07-29 04:00:00	NVDA	Stock	10.3748	10.3748	10.3608	10.3608	18160.0
2020-07-29 05:00:00	NVDA	Stock	10.3552	10.3552	10.3552	10.3552	8000.0
2020-07-29 06:00:00	NVDA	Stock	10.36	10.37	10.36	10.3648	50080.0
2020-07-29 07:00:00	NVDA	Stock	10.3565	10.3848	10.355	10.3848	203040.0
2020-07-29 08:00:00	NVDA	Stock	10.3738	10.3992	10.3625	10.3785	431240.0
2020-07-29 09:00:00	NVDA	Stock	10.3825	10.469	10.2155	10.4025	52576120.0
2020-07-29 10:00:00	NVDA	Stock	10.4043	10.4852	10.3675	10.4664	42887320.0
2020-07-29 11:00:00	NVDA	Stock	10.4677	10.5162	10.4488	10.4638	32799600.0
2020-07-29 12:00:00	NVDA	Stock	10.4625	10.479	10.409	10.474	23548160.0
2020-07-29 13:00:00	NVDA	Stock	10.4741	10.4883	10.4398	10.4559	18304600.0
2020-07-29 14:00:00	NVDA	Stock	10.4575	10.5162	10.4305	10.474	30139800.0
2020-07-29 15:00:00	NVDA	Stock	10.4748	10.5	10.4303	10.4655	45908760.0
2020-07-29 16:00:00	NVDA	Stock	10.4655	10.51	10.4655	10.5075	1587040.0
2020-07-29 17:00:00	NVDA	Stock	10.506	10.507	10.4892	10.4892	127040.0
2020-07-29 18:00:00	NVDA	Stock	10.49	10.4998	10.4848	10.4848	179960.0
2020-07-29 19:00:00	NVDA	Stock	10.4832	10.4943	10.4655	10.4655	277480.0
2020-07-29 06:00:00	AMZN	Stock	151.0	151.0	151.0	151.0	4000.0
2020-07-29 07:00:00	AMZN	Stock	151.3415	151.6	151.0	151.6	102840.0
2020-07-29 08:00:00	AMZN	Stock	151.7	152.3	151.665	151.825	230160.0

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

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