PREVIEW / stock_1hour / 2021-05-04

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-05-04.parquet
  size:    1.4 MB
  rows:    66,036
  symbols: 2,987

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-04 04:00:00	AAPL	Stock	131.88	132.08	131.6	131.83	22881.0
2021-05-04 05:00:00	AAPL	Stock	131.83	132.04	131.71	131.97	15989.0
2021-05-04 06:00:00	AAPL	Stock	131.99	132.01	131.63	131.88	24260.0
2021-05-04 07:00:00	AAPL	Stock	131.92	132.08	131.0	131.07	264418.0
2021-05-04 08:00:00	AAPL	Stock	131.94	132.08	130.87	131.15	596862.0
2021-05-04 09:00:00	AAPL	Stock	131.169	131.4899	128.391	128.53	17151844.0
2021-05-04 10:00:00	AAPL	Stock	128.5313	128.82	127.84	128.195	20270479.0
2021-05-04 11:00:00	AAPL	Stock	128.195	128.27	126.73	126.9301	17508139.0
2021-05-04 12:00:00	AAPL	Stock	126.93	127.48	126.84	126.87	12345394.0
2021-05-04 13:00:00	AAPL	Stock	126.87	127.2999	126.7	126.99	11678002.0
2021-05-04 14:00:00	AAPL	Stock	126.98	127.59	126.87	127.4219	9167233.0
2021-05-04 15:00:00	AAPL	Stock	127.43	128.0	127.14	127.94	18887068.0
2021-05-04 16:00:00	AAPL	Stock	127.92	127.96	127.6	127.68	10367073.0
2021-05-04 17:00:00	AAPL	Stock	127.67	127.85	127.67	127.79	113808.0
2021-05-04 18:00:00	AAPL	Stock	127.78	127.79	127.6	127.68	84675.0
2021-05-04 19:00:00	AAPL	Stock	127.69	127.85	127.52	127.7	101230.0
2021-05-04 04:00:00	MSFT	Stock	251.03	251.26	250.88	250.88	6854.0
2021-05-04 05:00:00	MSFT	Stock	251.05	251.18	251.05	251.17	1806.0
2021-05-04 06:00:00	MSFT	Stock	251.38	251.38	251.1	251.25	3616.0
2021-05-04 07:00:00	MSFT	Stock	251.28	251.36	249.24	250.1	67675.0
2021-05-04 08:00:00	MSFT	Stock	250.2	251.28	249.31	250.1	66512.0
2021-05-04 09:00:00	MSFT	Stock	250.0	251.21	248.8904	249.131	2339191.0
2021-05-04 10:00:00	MSFT	Stock	249.155	249.41	247.761	247.955	3118625.0
2021-05-04 11:00:00	MSFT	Stock	247.95	248.0	245.76	246.11	3084249.0
2021-05-04 12:00:00	MSFT	Stock	246.11	246.76	245.78	245.93	1857908.0
2021-05-04 13:00:00	MSFT	Stock	245.91	247.09	245.8376	246.03	1841032.0
2021-05-04 14:00:00	MSFT	Stock	246.01	246.99	245.925	246.78	1789556.0
2021-05-04 15:00:00	MSFT	Stock	246.785	248.0	246.374	247.93	3682511.0
2021-05-04 16:00:00	MSFT	Stock	247.79	247.96	247.17	247.44	5312938.0
2021-05-04 17:00:00	MSFT	Stock	247.4	247.68	247.0	247.0	19400.0
2021-05-04 18:00:00	MSFT	Stock	247.19	247.49	247.0	247.2	12805.0
2021-05-04 19:00:00	MSFT	Stock	247.23	247.28	246.78	247.1	17115.0
2021-05-04 04:00:00	NVDA	Stock	14.8	14.8	14.79	14.79	11360.0
2021-05-04 05:00:00	NVDA	Stock	14.7798	14.7798	14.7798	14.7798	4480.0
2021-05-04 07:00:00	NVDA	Stock	14.8	14.8	14.6752	14.7038	361080.0
2021-05-04 08:00:00	NVDA	Stock	14.7002	14.7058	14.6252	14.6688	742280.0
2021-05-04 09:00:00	NVDA	Stock	14.653	14.6643	14.2778	14.3106	36654800.0
2021-05-04 10:00:00	NVDA	Stock	14.3062	14.3182	14.1408	14.157	42281400.0
2021-05-04 11:00:00	NVDA	Stock	14.1622	14.2	14.0103	14.0772	45851040.0
2021-05-04 12:00:00	NVDA	Stock	14.0768	14.1912	14.0628	14.121	28071880.0
2021-05-04 13:00:00	NVDA	Stock	14.1184	14.271	14.111	14.2275	21408880.0
2021-05-04 14:00:00	NVDA	Stock	14.223	14.325	14.1942	14.2825	16488720.0
2021-05-04 15:00:00	NVDA	Stock	14.2865	14.3588	14.2252	14.3535	39048960.0
2021-05-04 16:00:00	NVDA	Stock	14.3512	14.45	14.35	14.45	26112480.0
2021-05-04 17:00:00	NVDA	Stock	14.4505	14.475	14.4375	14.4673	330840.0
2021-05-04 18:00:00	NVDA	Stock	14.4545	14.475	14.425	14.475	455080.0
2021-05-04 19:00:00	NVDA	Stock	14.475	14.5	14.3512	14.475	370680.0
2021-05-04 07:00:00	AMZN	Stock	168.76	168.781	167.5	167.81	123500.0
2021-05-04 08:00:00	AMZN	Stock	168.975	168.975	166.75	167.6	506540.0
2021-05-04 09:00:00	AMZN	Stock	167.595	168.3988	166.4	166.7195	9039360.0

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

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