PREVIEW / stock_1hour / 2021-04-30

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-04-30.parquet
  size:    1.4 MB
  rows:    65,052
  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-04-30 04:00:00	AAPL	Stock	132.7	133.31	132.7	133.0	30772.0
2021-04-30 05:00:00	AAPL	Stock	132.95	133.08	132.66	132.75	19986.0
2021-04-30 06:00:00	AAPL	Stock	132.75	132.75	131.86	132.25	74838.0
2021-04-30 07:00:00	AAPL	Stock	132.27	132.5	131.86	132.0	313501.0
2021-04-30 08:00:00	AAPL	Stock	132.3001	132.49	131.55	131.99	728872.0
2021-04-30 09:00:00	AAPL	Stock	131.99	132.84	131.36	132.76	11660960.0
2021-04-30 10:00:00	AAPL	Stock	132.75	133.56	132.2	133.455	13002729.0
2021-04-30 11:00:00	AAPL	Stock	133.46	133.48	133.0	133.0301	8594156.0
2021-04-30 12:00:00	AAPL	Stock	133.03	133.18	132.28	132.435	8040459.0
2021-04-30 13:00:00	AAPL	Stock	132.43	132.64	131.64	131.74	9188333.0
2021-04-30 14:00:00	AAPL	Stock	131.75	132.07	131.49	131.86	8382520.0
2021-04-30 15:00:00	AAPL	Stock	131.865	132.14	131.065	131.52	16814791.0
2021-04-30 16:00:00	AAPL	Stock	131.52	131.57	131.34	131.5	9272708.0
2021-04-30 17:00:00	AAPL	Stock	131.46	131.57	131.44	131.56	71215.0
2021-04-30 18:00:00	AAPL	Stock	131.56	131.56	131.46	131.4799	35865.0
2021-04-30 19:00:00	AAPL	Stock	131.47	131.52	131.38	131.52	84954.0
2021-04-30 04:00:00	MSFT	Stock	251.28	251.54	251.2	251.54	1473.0
2021-04-30 05:00:00	MSFT	Stock	251.36	251.36	250.5	250.94	2765.0
2021-04-30 06:00:00	MSFT	Stock	250.98	251.3	249.5	250.0	19722.0
2021-04-30 07:00:00	MSFT	Stock	250.28	250.4	249.98	250.2	24689.0
2021-04-30 08:00:00	MSFT	Stock	250.1499	250.6	249.59	250.35	60276.0
2021-04-30 09:00:00	MSFT	Stock	250.3	251.45	249.45	250.63	3894470.0
2021-04-30 10:00:00	MSFT	Stock	250.63	253.08	250.51	251.63	3374394.0
2021-04-30 11:00:00	MSFT	Stock	251.64	251.97	250.72	251.88	2387255.0
2021-04-30 12:00:00	MSFT	Stock	251.87	252.18	251.245	251.39	1344666.0
2021-04-30 13:00:00	MSFT	Stock	251.39	252.1299	251.08	251.36	1322133.0
2021-04-30 14:00:00	MSFT	Stock	251.351	252.29	251.15	252.05	1427752.0
2021-04-30 15:00:00	MSFT	Stock	252.05	252.65	251.45	252.18	4816493.0
2021-04-30 16:00:00	MSFT	Stock	252.18	252.39	251.65	252.2972	4232773.0
2021-04-30 17:00:00	MSFT	Stock	252.35	252.75	252.04	252.18	21637.0
2021-04-30 18:00:00	MSFT	Stock	252.25	252.5	252.1	252.18	9047.0
2021-04-30 19:00:00	MSFT	Stock	252.3	252.3	252.06	252.18	3131.0
2021-04-30 06:00:00	NVDA	Stock	15.1625	15.1625	15.1	15.1498	63080.0
2021-04-30 07:00:00	NVDA	Stock	15.1308	15.1652	15.1305	15.1475	152280.0
2021-04-30 08:00:00	NVDA	Stock	15.15	15.175	15.1025	15.125	514120.0
2021-04-30 09:00:00	NVDA	Stock	15.135	15.29	15.1	15.2024	12785920.0
2021-04-30 10:00:00	NVDA	Stock	15.197	15.365	15.1375	15.24	15549800.0
2021-04-30 11:00:00	NVDA	Stock	15.232	15.254	15.1608	15.2155	9060520.0
2021-04-30 12:00:00	NVDA	Stock	15.2148	15.2425	15.174	15.2015	5091720.0
2021-04-30 13:00:00	NVDA	Stock	15.2035	15.2035	15.0252	15.046	9261280.0
2021-04-30 14:00:00	NVDA	Stock	15.0423	15.1092	15.022	15.0838	10713920.0
2021-04-30 15:00:00	NVDA	Stock	15.0812	15.1155	14.997	15.0093	28588800.0
2021-04-30 16:00:00	NVDA	Stock	15.0095	15.047	15.0095	15.015	35272760.0
2021-04-30 17:00:00	NVDA	Stock	15.025	15.025	15.015	15.025	100160.0
2021-04-30 18:00:00	NVDA	Stock	15.0183	15.0183	15.0095	15.0095	84360.0
2021-04-30 19:00:00	NVDA	Stock	15.0095	15.0115	15.0018	15.0055	138560.0
2021-04-30 04:00:00	AMZN	Stock	177.576	177.886	177.275	177.886	108600.0
2021-04-30 05:00:00	AMZN	Stock	177.761	177.761	177.33	177.33	8000.0
2021-04-30 06:00:00	AMZN	Stock	177.315	177.75	176.825	177.65	118080.0
2021-04-30 07:00:00	AMZN	Stock	177.525	178.3695	177.101	178.1	444240.0

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

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