PREVIEW / stock_1hour / 2020-08-14

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-08-14.parquet
  size:    1.2 MB
  rows:    56,389
  symbols: 2,436

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-14 04:00:00	AAPL	Stock	114.8675	114.875	114.415	114.5275	16092.0
2020-08-14 05:00:00	AAPL	Stock	114.525	114.65	114.3175	114.65	17688.0
2020-08-14 06:00:00	AAPL	Stock	114.6325	114.9675	114.4175	114.925	46704.0
2020-08-14 07:00:00	AAPL	Stock	114.915	115.395	114.5	115.2875	490692.0
2020-08-14 08:00:00	AAPL	Stock	114.7932	115.385	114.575	115.12	526128.0
2020-08-14 09:00:00	AAPL	Stock	115.135	115.1775	113.4225	113.88	21377776.0
2020-08-14 10:00:00	AAPL	Stock	113.8525	114.0625	113.226	113.3075	19564420.0
2020-08-14 11:00:00	AAPL	Stock	113.3025	114.0575	113.045	113.945	20279564.0
2020-08-14 12:00:00	AAPL	Stock	113.95	114.8675	113.8862	114.586	18924180.0
2020-08-14 13:00:00	AAPL	Stock	114.5825	114.835	114.35	114.6555	13649920.0
2020-08-14 14:00:00	AAPL	Stock	114.6462	114.6775	114.14	114.2882	9736516.0
2020-08-14 15:00:00	AAPL	Stock	114.2818	115.0	113.9725	114.945	18134140.0
2020-08-14 16:00:00	AAPL	Stock	114.9075	114.91	114.78	114.8	5797296.0
2020-08-14 17:00:00	AAPL	Stock	114.8	114.875	114.75	114.875	86956.0
2020-08-14 18:00:00	AAPL	Stock	114.875	114.875	114.8	114.8	23812.0
2020-08-14 19:00:00	AAPL	Stock	114.7875	114.825	114.7775	114.8225	85804.0
2020-08-14 04:00:00	MSFT	Stock	209.34	209.34	208.61	209.0	4639.0
2020-08-14 05:00:00	MSFT	Stock	208.86	209.0	208.7	208.8	1980.0
2020-08-14 06:00:00	MSFT	Stock	208.77	209.3	208.11	209.29	7831.0
2020-08-14 07:00:00	MSFT	Stock	209.2	209.47	208.98	209.4	14997.0
2020-08-14 08:00:00	MSFT	Stock	209.1	209.64	208.872	209.21	34009.0
2020-08-14 09:00:00	MSFT	Stock	209.1	209.59	208.05	208.5	1939755.0
2020-08-14 10:00:00	MSFT	Stock	208.509	208.75	207.51	207.815	1938195.0
2020-08-14 11:00:00	MSFT	Stock	207.82	209.05	207.69	208.253	1793171.0
2020-08-14 12:00:00	MSFT	Stock	208.31	209.24	208.28	208.9	1213166.0
2020-08-14 13:00:00	MSFT	Stock	208.92	209.005	208.218	208.71	1073233.0
2020-08-14 14:00:00	MSFT	Stock	208.71	208.88	208.21	208.55	1194583.0
2020-08-14 15:00:00	MSFT	Stock	208.55	209.12	207.75	208.89	2429321.0
2020-08-14 16:00:00	MSFT	Stock	208.9	208.9	208.3	208.55	1813655.0
2020-08-14 17:00:00	MSFT	Stock	208.7	208.9	208.53	208.71	19794.0
2020-08-14 18:00:00	MSFT	Stock	208.55	208.71	208.52	208.59	2885.0
2020-08-14 19:00:00	MSFT	Stock	208.6	208.8	208.58	208.75	2563.0
2020-08-14 04:00:00	NVDA	Stock	11.443	11.443	11.443	11.443	4800.0
2020-08-14 06:00:00	NVDA	Stock	11.426	11.4375	11.426	11.4375	48240.0
2020-08-14 07:00:00	NVDA	Stock	11.4625	11.54	11.4525	11.5272	612040.0
2020-08-14 08:00:00	NVDA	Stock	11.5	11.5475	11.4625	11.5188	983600.0
2020-08-14 09:00:00	NVDA	Stock	11.525	11.7048	11.497	11.6115	80285280.0
2020-08-14 10:00:00	NVDA	Stock	11.6112	11.652	11.5101	11.5458	52512240.0
2020-08-14 11:00:00	NVDA	Stock	11.5477	11.605	11.4518	11.4801	44872840.0
2020-08-14 12:00:00	NVDA	Stock	11.485	11.5705	11.4631	11.5344	34941680.0
2020-08-14 13:00:00	NVDA	Stock	11.5344	11.5448	11.4405	11.4785	31743840.0
2020-08-14 14:00:00	NVDA	Stock	11.4765	11.5079	11.4655	11.4927	24131600.0
2020-08-14 15:00:00	NVDA	Stock	11.4878	11.5656	11.4608	11.5639	36526800.0
2020-08-14 16:00:00	NVDA	Stock	11.564	11.575	11.5532	11.5625	9951440.0
2020-08-14 17:00:00	NVDA	Stock	11.565	11.5858	11.5628	11.5698	459520.0
2020-08-14 18:00:00	NVDA	Stock	11.5698	11.596	11.565	11.596	418880.0
2020-08-14 19:00:00	NVDA	Stock	11.5928	11.6	11.5882	11.5988	314160.0
2020-08-14 05:00:00	AMZN	Stock	157.5	157.5	157.5	157.5	8640.0
2020-08-14 07:00:00	AMZN	Stock	158.3	158.787	158.3	158.787	161340.0
2020-08-14 08:00:00	AMZN	Stock	158.75	158.9	158.687	158.8682	273600.0

> showing 50 of 56,389 rows — these rows as CSV

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