PREVIEW / stock_1hour / 2021-10-20

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-10-20.parquet
  size:    1.4 MB
  rows:    63,881
  symbols: 2,648

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-10-20 04:00:00	AAPL	Stock	148.58	148.66	148.43	148.58	18130.0
2021-10-20 05:00:00	AAPL	Stock	148.59	148.75	148.48	148.72	11227.0
2021-10-20 06:00:00	AAPL	Stock	148.7	148.76	148.64	148.76	6945.0
2021-10-20 07:00:00	AAPL	Stock	148.68	148.76	148.46	148.53	72193.0
2021-10-20 08:00:00	AAPL	Stock	148.53	148.77	148.46	148.65	293255.0
2021-10-20 09:00:00	AAPL	Stock	148.64	149.7539	148.62	148.99	10689861.0
2021-10-20 10:00:00	AAPL	Stock	148.995	149.485	148.7	149.2288	8719777.0
2021-10-20 11:00:00	AAPL	Stock	149.23	149.74	149.065	149.6721	6469729.0
2021-10-20 12:00:00	AAPL	Stock	149.675	149.7	149.03	149.2	4400917.0
2021-10-20 13:00:00	AAPL	Stock	149.19	149.26	148.12	148.48	6269536.0
2021-10-20 14:00:00	AAPL	Stock	148.485	148.86	148.44	148.81	3581660.0
2021-10-20 15:00:00	AAPL	Stock	148.815	149.42	148.75	149.345	7911667.0
2021-10-20 16:00:00	AAPL	Stock	149.34	149.38	148.96	149.08	4169578.0
2021-10-20 17:00:00	AAPL	Stock	149.07	149.07	149.01	149.05	19417.0
2021-10-20 18:00:00	AAPL	Stock	149.09	149.1199	148.95	148.95	21094.0
2021-10-20 19:00:00	AAPL	Stock	148.95	149.06	148.82	148.88	42598.0
2021-10-20 04:00:00	MSFT	Stock	308.7	308.7	308.65	308.65	504.0
2021-10-20 05:00:00	MSFT	Stock	308.67	309.24	308.67	309.24	2182.0
2021-10-20 06:00:00	MSFT	Stock	309.21	309.5	309.0	309.1	2661.0
2021-10-20 07:00:00	MSFT	Stock	309.05	309.4	308.69	309.0	11631.0
2021-10-20 08:00:00	MSFT	Stock	309.4269	309.87	308.77	309.56	36498.0
2021-10-20 09:00:00	MSFT	Stock	309.43	309.7	308.51	308.681	1753648.0
2021-10-20 10:00:00	MSFT	Stock	308.73	308.7873	307.6448	307.7336	1512531.0
2021-10-20 11:00:00	MSFT	Stock	307.75	307.8998	306.98	307.2354	1575316.0
2021-10-20 12:00:00	MSFT	Stock	307.2301	307.38	306.82	307.31	948579.0
2021-10-20 13:00:00	MSFT	Stock	307.33	307.42	306.11	306.766	1177453.0
2021-10-20 14:00:00	MSFT	Stock	306.76	308.32	306.69	307.24	799879.0
2021-10-20 15:00:00	MSFT	Stock	307.25	307.71	306.75	307.49	1875360.0
2021-10-20 16:00:00	MSFT	Stock	307.41	307.65	307.1501	307.1501	1979280.0
2021-10-20 17:00:00	MSFT	Stock	307.1529	307.35	307.15	307.3	953.0
2021-10-20 18:00:00	MSFT	Stock	307.2001	307.3	307.1	307.11	3043.0
2021-10-20 19:00:00	MSFT	Stock	307.12	307.25	307.0	307.1	8915.0
2021-10-20 04:00:00	NVDA	Stock	22.235	22.235	22.22	22.22	5250.0
2021-10-20 05:00:00	NVDA	Stock	22.199	22.235	22.199	22.235	3260.0
2021-10-20 06:00:00	NVDA	Stock	22.268	22.285	22.25	22.25	10220.0
2021-10-20 07:00:00	NVDA	Stock	22.288	22.293	22.24	22.25	72210.0
2021-10-20 08:00:00	NVDA	Stock	22.27	22.3	22.23	22.2892	202940.0
2021-10-20 09:00:00	NVDA	Stock	22.28	22.433	22.216	22.3082	20416610.0
2021-10-20 10:00:00	NVDA	Stock	22.306	22.3749	22.183	22.1905	23621230.0
2021-10-20 11:00:00	NVDA	Stock	22.191	22.243	22.109	22.224	14614230.0
2021-10-20 12:00:00	NVDA	Stock	22.226	22.229	22.151	22.177	6669190.0
2021-10-20 13:00:00	NVDA	Stock	22.178	22.192	21.982	22.1083	11979020.0
2021-10-20 14:00:00	NVDA	Stock	22.107	22.143	22.033	22.047	10586610.0
2021-10-20 15:00:00	NVDA	Stock	22.0475	22.109	22.022	22.108	13770150.0
2021-10-20 16:00:00	NVDA	Stock	22.1085	22.11	22.04	22.085	10338040.0
2021-10-20 17:00:00	NVDA	Stock	22.079	22.086	22.052	22.085	67180.0
2021-10-20 18:00:00	NVDA	Stock	22.083	22.083	22.055	22.075	75280.0
2021-10-20 19:00:00	NVDA	Stock	22.055	22.075	22.04	22.04	48860.0
2021-10-20 05:00:00	AMZN	Stock	171.999	171.999	171.999	171.999	2000.0
2021-10-20 07:00:00	AMZN	Stock	171.96	171.96	171.96	171.96	2000.0

> showing 50 of 63,881 rows — these rows as CSV

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