PREVIEW / stock_1hour / 2020-07-27

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-07-27.parquet
  size:    1.2 MB
  rows:    57,018
  symbols: 2,452

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-27 04:00:00	AAPL	Stock	93.0025	93.08	92.83	93.08	21484.0
2020-07-27 05:00:00	AAPL	Stock	93.0825	93.5	93.0825	93.45	10084.0
2020-07-27 06:00:00	AAPL	Stock	93.535	94.0	93.45	93.65	40168.0
2020-07-27 07:00:00	AAPL	Stock	93.625	93.8125	93.3725	93.8125	430800.0
2020-07-27 08:00:00	AAPL	Stock	93.3765	93.825	93.375	93.7375	596928.0
2020-07-27 09:00:00	AAPL	Stock	93.7375	94.875	93.49	94.425	20291836.0
2020-07-27 10:00:00	AAPL	Stock	94.4375	94.766	93.975	94.325	15061728.0
2020-07-27 11:00:00	AAPL	Stock	94.325	94.4625	93.48	93.895	11200208.0
2020-07-27 12:00:00	AAPL	Stock	93.91	94.26	93.76	94.2375	7590100.0
2020-07-27 13:00:00	AAPL	Stock	94.245	94.6112	94.14	94.5445	6925236.0
2020-07-27 14:00:00	AAPL	Stock	94.555	94.75	94.29	94.3225	9736908.0
2020-07-27 15:00:00	AAPL	Stock	94.315	94.905	94.3025	94.8037	15244284.0
2020-07-27 16:00:00	AAPL	Stock	94.805	94.975	94.795	94.9625	9148600.0
2020-07-27 17:00:00	AAPL	Stock	94.81	94.9925	94.81	94.9575	2401264.0
2020-07-27 18:00:00	AAPL	Stock	94.975	95.2375	94.975	95.195	118752.0
2020-07-27 19:00:00	AAPL	Stock	95.195	95.2475	95.045	95.245	118416.0
2020-07-27 04:00:00	MSFT	Stock	202.05	202.66	202.05	202.2	4054.0
2020-07-27 05:00:00	MSFT	Stock	202.32	203.13	202.3	203.13	12935.0
2020-07-27 06:00:00	MSFT	Stock	203.06	203.79	202.62	203.6	4669.0
2020-07-27 07:00:00	MSFT	Stock	203.25	203.45	202.75	203.39	64518.0
2020-07-27 08:00:00	MSFT	Stock	203.4	203.5	201.8	202.6	119875.0
2020-07-27 09:00:00	MSFT	Stock	202.6	203.32	201.0	202.81	3854529.0
2020-07-27 10:00:00	MSFT	Stock	202.81	203.027	200.86	202.6	4256291.0
2020-07-27 11:00:00	MSFT	Stock	202.6	202.735	201.31	201.95	2590784.0
2020-07-27 12:00:00	MSFT	Stock	201.96	202.43	201.55	202.185	1936634.0
2020-07-27 13:00:00	MSFT	Stock	202.185	203.03	202.17	202.64	1858121.0
2020-07-27 14:00:00	MSFT	Stock	202.65	203.51	202.635	202.91	2125914.0
2020-07-27 15:00:00	MSFT	Stock	202.87	203.97	202.86	203.85	3716982.0
2020-07-27 16:00:00	MSFT	Stock	203.85	204.12	203.5	203.96	2573958.0
2020-07-27 17:00:00	MSFT	Stock	204.0	204.09	203.85	203.98	1117023.0
2020-07-27 18:00:00	MSFT	Stock	204.06	204.46	203.95	204.3	22869.0
2020-07-27 19:00:00	MSFT	Stock	204.3	204.5	204.05	204.3	18488.0
2020-07-27 04:00:00	NVDA	Stock	10.2125	10.235	10.1912	10.2	227200.0
2020-07-27 05:00:00	NVDA	Stock	10.2085	10.2262	10.2085	10.2262	102320.0
2020-07-27 06:00:00	NVDA	Stock	10.2248	10.2428	10.2248	10.2428	388920.0
2020-07-27 07:00:00	NVDA	Stock	10.2425	10.25	10.206	10.2222	716720.0
2020-07-27 08:00:00	NVDA	Stock	10.2153	10.271	10.2078	10.215	970240.0
2020-07-27 09:00:00	NVDA	Stock	10.2225	10.4145	10.2138	10.362	57507320.0
2020-07-27 10:00:00	NVDA	Stock	10.361	10.3998	10.328	10.3549	39756360.0
2020-07-27 11:00:00	NVDA	Stock	10.353	10.3623	10.2178	10.3095	40468360.0
2020-07-27 12:00:00	NVDA	Stock	10.305	10.3542	10.278	10.3484	21272360.0
2020-07-27 13:00:00	NVDA	Stock	10.3535	10.4143	10.3482	10.4062	25632600.0
2020-07-27 14:00:00	NVDA	Stock	10.4045	10.4408	10.3882	10.3983	24493960.0
2020-07-27 15:00:00	NVDA	Stock	10.3972	10.4418	10.3903	10.4215	29453920.0
2020-07-27 16:00:00	NVDA	Stock	10.4215	10.4298	10.4	10.4275	14028960.0
2020-07-27 17:00:00	NVDA	Stock	10.4305	10.4325	10.4215	10.4252	3688040.0
2020-07-27 18:00:00	NVDA	Stock	10.4325	10.4433	10.425	10.4433	296800.0
2020-07-27 19:00:00	NVDA	Stock	10.438	10.4438	10.428	10.4438	154320.0
2020-07-27 04:00:00	AMZN	Stock	151.6	151.6	151.6	151.6	2000.0
2020-07-27 05:00:00	AMZN	Stock	152.3945	152.3945	152.3945	152.3945	8200.0

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

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