PREVIEW / stock_1hour / 2021-05-12

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-05-12.parquet
  size:    1.4 MB
  rows:    66,502
  symbols: 2,981

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-12 04:00:00	AAPL	Stock	125.71	125.71	125.05	125.2	12063.0
2021-05-12 05:00:00	AAPL	Stock	125.23	125.4	124.83	125.13	28489.0
2021-05-12 06:00:00	AAPL	Stock	125.13	125.39	124.71	125.0	20831.0
2021-05-12 07:00:00	AAPL	Stock	124.92	125.25	124.89	125.19	108363.0
2021-05-12 08:00:00	AAPL	Stock	125.035	125.8429	123.7	124.09	601732.0
2021-05-12 09:00:00	AAPL	Stock	124.03	124.64	123.09	123.975	11395841.0
2021-05-12 10:00:00	AAPL	Stock	123.975	124.24	122.83	123.1301	15379844.0
2021-05-12 11:00:00	AAPL	Stock	123.13	123.58	122.71	122.812	10876420.0
2021-05-12 12:00:00	AAPL	Stock	122.81	123.1499	122.32	123.1	11275505.0
2021-05-12 13:00:00	AAPL	Stock	123.09	123.445	122.61	122.71	8058756.0
2021-05-12 14:00:00	AAPL	Stock	122.7015	122.96	122.25	122.77	9364943.0
2021-05-12 15:00:00	AAPL	Stock	122.76	123.06	122.26	122.82	18207022.0
2021-05-12 16:00:00	AAPL	Stock	122.82	123.09	122.32	122.3999	13287736.0
2021-05-12 17:00:00	AAPL	Stock	122.4	122.841	122.2801	122.44	135810.0
2021-05-12 18:00:00	AAPL	Stock	122.45	122.94	122.35	122.75	147650.0
2021-05-12 19:00:00	AAPL	Stock	122.75	123.0	122.6401	122.79	143186.0
2021-05-12 04:00:00	MSFT	Stock	245.3	245.48	244.86	244.86	1176.0
2021-05-12 05:00:00	MSFT	Stock	244.85	245.03	244.57	244.57	1184.0
2021-05-12 06:00:00	MSFT	Stock	244.95	245.2	244.05	244.23	2955.0
2021-05-12 07:00:00	MSFT	Stock	244.51	244.98	244.32	244.85	15090.0
2021-05-12 08:00:00	MSFT	Stock	244.4101	246.0988	242.03	242.9	93834.0
2021-05-12 09:00:00	MSFT	Stock	243.1	244.45	242.02	242.348	2976796.0
2021-05-12 10:00:00	MSFT	Stock	242.335	242.34	239.67	240.0358	4618290.0
2021-05-12 11:00:00	MSFT	Stock	240.02	240.9	239.39	239.5	3158918.0
2021-05-12 12:00:00	MSFT	Stock	239.5	239.88	238.77	239.79	2924748.0
2021-05-12 13:00:00	MSFT	Stock	239.79	240.38	238.76	239.29	2358491.0
2021-05-12 14:00:00	MSFT	Stock	239.2899	240.36	239.1	239.405	2330297.0
2021-05-12 15:00:00	MSFT	Stock	239.4	239.75	238.07	239.03	5525380.0
2021-05-12 16:00:00	MSFT	Stock	239.0	239.36	238.6	238.9478	5345992.0
2021-05-12 17:00:00	MSFT	Stock	238.85	238.95	238.55	238.8	11727.0
2021-05-12 18:00:00	MSFT	Stock	238.8	239.4	238.8	239.05	15616.0
2021-05-12 19:00:00	MSFT	Stock	239.18	239.55	239.0	239.5	26250.0
2021-05-12 04:00:00	NVDA	Stock	14.2275	14.2275	14.2	14.2	8000.0
2021-05-12 05:00:00	NVDA	Stock	14.2005	14.2005	14.2005	14.2005	12000.0
2021-05-12 06:00:00	NVDA	Stock	14.2028	14.2028	14.2028	14.2028	4000.0
2021-05-12 07:00:00	NVDA	Stock	14.185	14.225	14.183	14.2	188800.0
2021-05-12 08:00:00	NVDA	Stock	14.2212	14.3139	13.986	13.986	730440.0
2021-05-12 09:00:00	NVDA	Stock	14.0	14.2602	13.9975	14.1215	21304400.0
2021-05-12 10:00:00	NVDA	Stock	14.1215	14.1225	13.9185	13.9583	18623240.0
2021-05-12 11:00:00	NVDA	Stock	13.9608	14.0893	13.886	13.8942	17466480.0
2021-05-12 12:00:00	NVDA	Stock	13.8898	13.9317	13.8235	13.8811	20203920.0
2021-05-12 13:00:00	NVDA	Stock	13.8833	13.9637	13.7778	13.8184	17539720.0
2021-05-12 14:00:00	NVDA	Stock	13.8162	13.851	13.7308	13.775	22261000.0
2021-05-12 15:00:00	NVDA	Stock	13.775	13.801	13.7092	13.7572	41561160.0
2021-05-12 16:00:00	NVDA	Stock	13.7585	13.7775	13.7255	13.7255	28211080.0
2021-05-12 17:00:00	NVDA	Stock	13.7282	13.7405	13.727	13.7275	342920.0
2021-05-12 18:00:00	NVDA	Stock	13.744	13.8018	13.744	13.768	230080.0
2021-05-12 19:00:00	NVDA	Stock	13.7938	13.8125	13.7758	13.81	249760.0
2021-05-12 04:00:00	AMZN	Stock	160.6	160.6	160.6	160.6	2000.0
2021-05-12 05:00:00	AMZN	Stock	160.85	160.85	160.85	160.85	3140.0

> showing 50 of 66,502 rows — these rows as CSV

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