PREVIEW / stock_1hour / 2020-09-04

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-09-04.parquet
  size:    1.2 MB
  rows:    56,874
  symbols: 2,467

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-09-04 04:00:00	AAPL	Stock	116.0	120.98	116.0	120.3	249084.0
2020-09-04 05:00:00	AAPL	Stock	120.47	121.4	119.0	121.14	127376.0
2020-09-04 06:00:00	AAPL	Stock	121.11	121.5	119.9	120.0	191041.0
2020-09-04 07:00:00	AAPL	Stock	120.25	120.27	117.19	117.75	1293199.0
2020-09-04 08:00:00	AAPL	Stock	117.67	119.95	117.18	119.15	3028130.0
2020-09-04 09:00:00	AAPL	Stock	119.22	123.7	113.68	116.44	50998917.0
2020-09-04 10:00:00	AAPL	Stock	116.46	118.1	110.89	115.23	63938223.0
2020-09-04 11:00:00	AAPL	Stock	115.19	118.5	113.35	118.5	36027174.0
2020-09-04 12:00:00	AAPL	Stock	118.478	120.68	117.4	118.89	35311201.0
2020-09-04 13:00:00	AAPL	Stock	118.9	118.94	116.33	118.57	21142995.0
2020-09-04 14:00:00	AAPL	Stock	118.57	121.68	118.08	121.51	23309142.0
2020-09-04 15:00:00	AAPL	Stock	121.504	122.7	120.43	120.9	36561602.0
2020-09-04 16:00:00	AAPL	Stock	120.905	121.2	117.841	120.05	12996516.0
2020-09-04 17:00:00	AAPL	Stock	120.07	120.87	119.66	120.1	389880.0
2020-09-04 18:00:00	AAPL	Stock	120.15	120.25	119.77	119.8	131744.0
2020-09-04 19:00:00	AAPL	Stock	119.83	120.06	119.35	120.0	165957.0
2020-09-04 04:00:00	MSFT	Stock	217.4	218.34	216.6	218.01	23271.0
2020-09-04 05:00:00	MSFT	Stock	218.3	218.34	217.0	218.06	15978.0
2020-09-04 06:00:00	MSFT	Stock	218.34	218.37	216.91	217.16	18653.0
2020-09-04 07:00:00	MSFT	Stock	217.04	217.24	214.5	215.1	131475.0
2020-09-04 08:00:00	MSFT	Stock	216.855	217.07	214.5	215.04	213004.0
2020-09-04 09:00:00	MSFT	Stock	215.02	218.3	211.1	213.35	5838009.0
2020-09-04 10:00:00	MSFT	Stock	213.42	214.47	205.19	208.24	9700061.0
2020-09-04 11:00:00	MSFT	Stock	208.26	211.66	206.95	211.66	5358203.0
2020-09-04 12:00:00	MSFT	Stock	211.64	212.73	209.902	211.159	4028514.0
2020-09-04 13:00:00	MSFT	Stock	211.16	211.649	208.94	211.224	2464114.0
2020-09-04 14:00:00	MSFT	Stock	211.243	216.02	210.14	216.0	3707786.0
2020-09-04 15:00:00	MSFT	Stock	215.97	218.36	214.0	214.14	8394393.0
2020-09-04 16:00:00	MSFT	Stock	214.25	214.5	212.5	213.04	4992592.0
2020-09-04 17:00:00	MSFT	Stock	213.04	213.94	213.01	213.85	23208.0
2020-09-04 18:00:00	MSFT	Stock	213.84	213.85	213.5	213.73	13007.0
2020-09-04 19:00:00	MSFT	Stock	213.74	213.74	213.5	213.6	13268.0
2020-09-04 04:00:00	NVDA	Stock	12.8	12.85	12.5998	12.65	777880.0
2020-09-04 05:00:00	NVDA	Stock	12.6525	12.7435	12.6	12.7435	253000.0
2020-09-04 06:00:00	NVDA	Stock	12.7498	12.775	12.6648	12.6745	272640.0
2020-09-04 07:00:00	NVDA	Stock	12.6688	12.6875	12.2888	12.3625	4512440.0
2020-09-04 08:00:00	NVDA	Stock	12.65	12.7238	12.2888	12.5625	9783480.0
2020-09-04 09:00:00	NVDA	Stock	12.55	13.175	12.225	12.3712	248166400.0
2020-09-04 10:00:00	NVDA	Stock	12.3618	12.5175	11.7048	12.0964	283447360.0
2020-09-04 11:00:00	NVDA	Stock	12.0965	12.3321	11.8512	12.3274	162546000.0
2020-09-04 12:00:00	NVDA	Stock	12.3264	12.5894	12.2563	12.4244	141966480.0
2020-09-04 13:00:00	NVDA	Stock	12.428	12.43	12.0502	12.2362	96152760.0
2020-09-04 14:00:00	NVDA	Stock	12.2413	12.6442	12.204	12.6314	126623400.0
2020-09-04 15:00:00	NVDA	Stock	12.6334	12.775	12.55	12.6148	151733400.0
2020-09-04 16:00:00	NVDA	Stock	12.6225	12.625	12.4775	12.525	3951480.0
2020-09-04 17:00:00	NVDA	Stock	12.5252	12.5963	12.5175	12.5405	528600.0
2020-09-04 18:00:00	NVDA	Stock	12.5263	12.5263	12.4775	12.4778	330800.0
2020-09-04 19:00:00	NVDA	Stock	12.4825	12.5	12.4575	12.4888	283960.0
2020-09-04 04:00:00	AMZN	Stock	168.3	168.3	167.979	167.979	18920.0
2020-09-04 05:00:00	AMZN	Stock	168.45	168.5	168.0	168.0	15380.0

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

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