PREVIEW / stock_1hour / 2021-04-29

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-04-29.parquet
  size:    1.4 MB
  rows:    65,332
  symbols: 2,993

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-29 04:00:00	AAPL	Stock	137.0	137.8	136.9	137.64	183320.0
2021-04-29 05:00:00	AAPL	Stock	137.56	137.72	137.18	137.4	77544.0
2021-04-29 06:00:00	AAPL	Stock	137.49	137.65	137.1	137.2	87201.0
2021-04-29 07:00:00	AAPL	Stock	137.22	137.72	137.02	137.1	587371.0
2021-04-29 08:00:00	AAPL	Stock	137.36	137.71	136.6	137.28	1590365.0
2021-04-29 09:00:00	AAPL	Stock	137.3	137.47	133.87	134.23	29204442.0
2021-04-29 10:00:00	AAPL	Stock	134.22	134.56	133.6	134.19	24020906.0
2021-04-29 11:00:00	AAPL	Stock	134.1805	134.66	132.7	133.16	17970918.0
2021-04-29 12:00:00	AAPL	Stock	133.17	133.2	132.45	132.98	14147854.0
2021-04-29 13:00:00	AAPL	Stock	132.985	133.87	132.8	133.82	11335524.0
2021-04-29 14:00:00	AAPL	Stock	133.83	134.57	133.74	134.2082	11783523.0
2021-04-29 15:00:00	AAPL	Stock	134.205	134.43	133.27	133.48	13482291.0
2021-04-29 16:00:00	AAPL	Stock	133.49	133.5	132.88	133.1	5226565.0
2021-04-29 17:00:00	AAPL	Stock	133.1	133.48	133.0	133.02	112448.0
2021-04-29 18:00:00	AAPL	Stock	133.04	133.1	132.92	132.97	138246.0
2021-04-29 19:00:00	AAPL	Stock	132.96	133.0	132.53	132.68	177429.0
2021-04-29 04:00:00	MSFT	Stock	255.4	256.48	255.05	256.19	27594.0
2021-04-29 05:00:00	MSFT	Stock	256.3	256.3	255.05	255.75	23755.0
2021-04-29 06:00:00	MSFT	Stock	255.75	255.75	255.35	255.36	7335.0
2021-04-29 07:00:00	MSFT	Stock	255.64	255.7	254.95	255.01	57932.0
2021-04-29 08:00:00	MSFT	Stock	255.4	255.73	254.69	255.47	131229.0
2021-04-29 09:00:00	MSFT	Stock	255.46	256.1	254.2	254.46	4106205.0
2021-04-29 10:00:00	MSFT	Stock	254.46	254.475	250.13	250.2764	6761072.0
2021-04-29 11:00:00	MSFT	Stock	250.27	250.52	249.0	249.5587	5448608.0
2021-04-29 12:00:00	MSFT	Stock	249.54	251.16	249.24	251.11	2899873.0
2021-04-29 13:00:00	MSFT	Stock	251.1086	251.69	250.63	250.99	2090853.0
2021-04-29 14:00:00	MSFT	Stock	250.9891	252.1	250.88	251.95	2288629.0
2021-04-29 15:00:00	MSFT	Stock	251.94	252.885	251.94	252.45	4745072.0
2021-04-29 16:00:00	MSFT	Stock	252.69	252.69	251.0	251.29	2691073.0
2021-04-29 17:00:00	MSFT	Stock	251.29	251.86	251.2	251.4	25129.0
2021-04-29 18:00:00	MSFT	Stock	251.52	251.74	251.2	251.67	10341.0
2021-04-29 19:00:00	MSFT	Stock	251.5	251.5	251.04	251.16	9803.0
2021-04-29 04:00:00	NVDA	Stock	15.4	15.4875	15.4	15.475	25200.0
2021-04-29 05:00:00	NVDA	Stock	15.4165	15.4525	15.3725	15.3748	32720.0
2021-04-29 06:00:00	NVDA	Stock	15.397	15.397	15.397	15.397	4800.0
2021-04-29 07:00:00	NVDA	Stock	15.3718	15.3938	15.356	15.3928	278240.0
2021-04-29 08:00:00	NVDA	Stock	15.375	15.3995	15.372	15.3803	402640.0
2021-04-29 09:00:00	NVDA	Stock	15.378	15.4365	15.245	15.2929	13624000.0
2021-04-29 10:00:00	NVDA	Stock	15.2858	15.3262	15.1775	15.2848	13274760.0
2021-04-29 11:00:00	NVDA	Stock	15.2839	15.3122	15.1678	15.1686	7815360.0
2021-04-29 12:00:00	NVDA	Stock	15.1702	15.1727	15.0715	15.143	12812960.0
2021-04-29 13:00:00	NVDA	Stock	15.1493	15.2282	15.1129	15.2188	10232000.0
2021-04-29 14:00:00	NVDA	Stock	15.2248	15.2962	15.189	15.2945	10806480.0
2021-04-29 15:00:00	NVDA	Stock	15.2949	15.3302	15.2578	15.325	15269200.0
2021-04-29 16:00:00	NVDA	Stock	15.3248	15.3495	15.2812	15.2875	15157040.0
2021-04-29 17:00:00	NVDA	Stock	15.2803	15.2812	15.28	15.28	67120.0
2021-04-29 18:00:00	NVDA	Stock	15.28	15.28	15.2562	15.2588	133720.0
2021-04-29 19:00:00	NVDA	Stock	15.2562	15.275	15.2538	15.2562	139640.0
2021-04-29 04:00:00	AMZN	Stock	174.9	175.25	174.9	175.249	20500.0
2021-04-29 05:00:00	AMZN	Stock	175.5	175.5	175.1515	175.1515	14680.0

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

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