PREVIEW / stock_1hour / 2021-05-06

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-05-06.parquet
  size:    1.4 MB
  rows:    65,518
  symbols: 2,984

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
2021-05-06 04:00:00	AAPL	Stock	128.24	128.6	128.24	128.31	12888.0
2021-05-06 05:00:00	AAPL	Stock	128.39	128.51	127.98	128.16	17758.0
2021-05-06 06:00:00	AAPL	Stock	128.2	128.44	128.03	128.13	11122.0
2021-05-06 07:00:00	AAPL	Stock	128.24	128.34	127.96	128.11	86601.0
2021-05-06 08:00:00	AAPL	Stock	128.1499	128.31	127.7	127.91	319034.0
2021-05-06 09:00:00	AAPL	Stock	127.91	128.55	127.13	127.585	9973282.0
2021-05-06 10:00:00	AAPL	Stock	127.585	128.51	127.32	128.13	11631925.0
2021-05-06 11:00:00	AAPL	Stock	128.135	129.06	127.62	128.725	9939233.0
2021-05-06 12:00:00	AAPL	Stock	128.73	129.23	128.149	128.8804	7088583.0
2021-05-06 13:00:00	AAPL	Stock	128.88	129.01	128.5584	128.725	4531348.0
2021-05-06 14:00:00	AAPL	Stock	128.72	129.04	128.325	128.6799	6791069.0
2021-05-06 15:00:00	AAPL	Stock	128.68	129.75	128.6	129.73	11794027.0
2021-05-06 16:00:00	AAPL	Stock	129.655	129.78	129.58	129.65	6715221.0
2021-05-06 17:00:00	AAPL	Stock	129.66	130.23	129.66	130.18	122702.0
2021-05-06 18:00:00	AAPL	Stock	130.18	130.19	129.91	130.02	83786.0
2021-05-06 19:00:00	AAPL	Stock	130.01	130.09	129.89	130.05	91331.0
2021-05-06 04:00:00	MSFT	Stock	246.82	247.44	246.82	247.14	2624.0
2021-05-06 05:00:00	MSFT	Stock	247.01	247.01	246.7	246.7	1370.0
2021-05-06 06:00:00	MSFT	Stock	246.7	247.2	246.4	246.4	2716.0
2021-05-06 07:00:00	MSFT	Stock	246.54	246.8	246.08	246.5	10130.0
2021-05-06 08:00:00	MSFT	Stock	246.94	247.086	245.75	246.0	19945.0
2021-05-06 09:00:00	MSFT	Stock	246.1	246.71	244.69	245.41	2112156.0
2021-05-06 10:00:00	MSFT	Stock	245.41	246.97	244.9	246.4	2457882.0
2021-05-06 11:00:00	MSFT	Stock	246.42	248.4701	245.72	247.81	2510314.0
2021-05-06 12:00:00	MSFT	Stock	247.83	248.35	246.4249	247.85	1536962.0
2021-05-06 13:00:00	MSFT	Stock	247.83	248.09	246.85	247.08	1558683.0
2021-05-06 14:00:00	MSFT	Stock	247.08	247.94	246.61	246.64	1934191.0
2021-05-06 15:00:00	MSFT	Stock	246.645	249.86	246.645	249.73	4043330.0
2021-05-06 16:00:00	MSFT	Stock	249.73	249.75	249.3	249.5	4196207.0
2021-05-06 17:00:00	MSFT	Stock	249.5	249.99	249.41	249.99	27162.0
2021-05-06 18:00:00	MSFT	Stock	249.83	249.9999	249.73	249.81	5534.0
2021-05-06 19:00:00	MSFT	Stock	249.92	249.92	249.44	249.55	10065.0
2021-05-06 04:00:00	NVDA	Stock	14.5305	14.5305	14.5255	14.5255	16000.0
2021-05-06 05:00:00	NVDA	Stock	14.4695	14.4695	14.4695	14.4695	4000.0
2021-05-06 06:00:00	NVDA	Stock	14.525	14.553	14.5248	14.5248	63840.0
2021-05-06 07:00:00	NVDA	Stock	14.525	14.5312	14.4842	14.4875	299080.0
2021-05-06 08:00:00	NVDA	Stock	14.4975	14.5188	14.4028	14.4255	426240.0
2021-05-06 09:00:00	NVDA	Stock	14.4495	14.5	14.308	14.3152	13102400.0
2021-05-06 10:00:00	NVDA	Stock	14.328	14.427	14.2181	14.4096	22480360.0
2021-05-06 11:00:00	NVDA	Stock	14.4104	14.5318	14.2763	14.4995	18529680.0
2021-05-06 12:00:00	NVDA	Stock	14.5045	14.5712	14.4563	14.509	10036280.0
2021-05-06 13:00:00	NVDA	Stock	14.506	14.525	14.3002	14.3125	10399480.0
2021-05-06 14:00:00	NVDA	Stock	14.3088	14.3782	14.2875	14.3258	10496280.0
2021-05-06 15:00:00	NVDA	Stock	14.329	14.542	14.309	14.5235	18995320.0
2021-05-06 16:00:00	NVDA	Stock	14.523	14.545	14.5125	14.5135	14178320.0
2021-05-06 17:00:00	NVDA	Stock	14.5355	14.5355	14.5135	14.5345	80000.0
2021-05-06 18:00:00	NVDA	Stock	14.5375	14.5393	14.5275	14.5393	191000.0
2021-05-06 19:00:00	NVDA	Stock	14.536	14.5475	14.531	14.5475	246880.0
2021-05-06 04:00:00	AMZN	Stock	164.25	164.25	164.25	164.25	8000.0
2021-05-06 06:00:00	AMZN	Stock	163.85	163.85	163.85	163.85	2020.0

> showing 50 of 65,518 rows — these rows as CSV

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