PREVIEW / stock_1hour / 2021-07-21

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-07-21.parquet
  size:    1.4 MB
  rows:    65,079
  symbols: 2,863

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-07-21 04:00:00	AAPL	Stock	146.38	146.58	146.16	146.4	11982.0
2021-07-21 05:00:00	AAPL	Stock	146.32	146.4	146.22	146.22	5226.0
2021-07-21 06:00:00	AAPL	Stock	146.21	146.23	145.95	146.0	15919.0
2021-07-21 07:00:00	AAPL	Stock	146.09	146.18	145.52	145.75	175555.0
2021-07-21 08:00:00	AAPL	Stock	146.0499	146.2	145.57	146.02	488435.0
2021-07-21 09:00:00	AAPL	Stock	146.0	146.13	144.82	145.29	11569337.0
2021-07-21 10:00:00	AAPL	Stock	145.28	145.88	144.63	145.715	10757266.0
2021-07-21 11:00:00	AAPL	Stock	145.715	146.0475	145.02	145.4239	7981048.0
2021-07-21 12:00:00	AAPL	Stock	145.42	145.48	144.96	145.028	5123906.0
2021-07-21 13:00:00	AAPL	Stock	145.025	145.35	144.84	145.28	5086979.0
2021-07-21 14:00:00	AAPL	Stock	145.2701	145.45	145.02	145.435	5167414.0
2021-07-21 15:00:00	AAPL	Stock	145.43	145.53	144.82	145.39	10939765.0
2021-07-21 16:00:00	AAPL	Stock	145.39	145.45	145.1285	145.39	7253361.0
2021-07-21 17:00:00	AAPL	Stock	145.39	145.4	145.35	145.39	38617.0
2021-07-21 18:00:00	AAPL	Stock	145.37	145.39	145.3	145.33	30390.0
2021-07-21 19:00:00	AAPL	Stock	145.33	145.42	145.31	145.35	44177.0
2021-07-21 04:00:00	MSFT	Stock	279.6	279.91	279.6	279.81	1160.0
2021-07-21 05:00:00	MSFT	Stock	279.6	279.68	279.6	279.68	1120.0
2021-07-21 06:00:00	MSFT	Stock	279.68	280.0	279.55	279.7	1704.0
2021-07-21 07:00:00	MSFT	Stock	279.55	279.55	278.3	278.5	26550.0
2021-07-21 08:00:00	MSFT	Stock	279.3	279.33	278.49	278.7006	18460.0
2021-07-21 09:00:00	MSFT	Stock	278.75	280.1	277.29	279.96	2112466.0
2021-07-21 10:00:00	MSFT	Stock	279.98	280.86	279.47	280.66	2406934.0
2021-07-21 11:00:00	MSFT	Stock	280.665	280.97	279.89	280.64	1777909.0
2021-07-21 12:00:00	MSFT	Stock	280.6374	280.665	279.13	279.79	1451129.0
2021-07-21 13:00:00	MSFT	Stock	279.795	280.48	279.44	280.41	1256690.0
2021-07-21 14:00:00	MSFT	Stock	280.42	280.51	280.07	280.35	1123218.0
2021-07-21 15:00:00	MSFT	Stock	280.34	281.52	280.15	281.39	3400097.0
2021-07-21 16:00:00	MSFT	Stock	281.4	281.52	281.19	281.45	3484508.0
2021-07-21 17:00:00	MSFT	Stock	281.52	281.6	281.45	281.5	2791.0
2021-07-21 18:00:00	MSFT	Stock	281.5	281.5	281.45	281.45	2765.0
2021-07-21 19:00:00	MSFT	Stock	281.4	281.79	281.33	281.79	3007.0
2021-07-21 04:00:00	NVDA	Stock	18.9	18.9	18.716	18.791	291240.0
2021-07-21 05:00:00	NVDA	Stock	18.785	18.79	18.738	18.79	71460.0
2021-07-21 06:00:00	NVDA	Stock	18.781	18.79	18.72	18.767	77310.0
2021-07-21 07:00:00	NVDA	Stock	18.759	18.769	18.61	18.64	714930.0
2021-07-21 08:00:00	NVDA	Stock	18.63	18.77	18.612	18.745	827310.0
2021-07-21 09:00:00	NVDA	Stock	18.744	19.388	18.695	19.355	64744790.0
2021-07-21 10:00:00	NVDA	Stock	19.356	19.37	19.156	19.285	43721690.0
2021-07-21 11:00:00	NVDA	Stock	19.2818	19.527	19.274	19.3452	47361300.0
2021-07-21 12:00:00	NVDA	Stock	19.344	19.346	19.081	19.083	29253190.0
2021-07-21 13:00:00	NVDA	Stock	19.0865	19.28	19.06	19.192	25511430.0
2021-07-21 14:00:00	NVDA	Stock	19.196	19.232	19.125	19.203	16207070.0
2021-07-21 15:00:00	NVDA	Stock	19.2065	19.424	19.171	19.41	39365350.0
2021-07-21 16:00:00	NVDA	Stock	19.407	19.485	19.407	19.46	21958350.0
2021-07-21 17:00:00	NVDA	Stock	19.452	19.48	19.412	19.413	287460.0
2021-07-21 18:00:00	NVDA	Stock	19.427	19.44	19.415	19.427	112480.0
2021-07-21 19:00:00	NVDA	Stock	19.431	19.495	19.431	19.475	348890.0
2021-07-21 07:00:00	AMZN	Stock	178.8	178.8	178.3	178.32	66820.0
2021-07-21 08:00:00	AMZN	Stock	178.6496	178.9	178.4	178.5	79020.0

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

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