PREVIEW / stock_1hour / 2021-07-01

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-07-01.parquet
  size:    1.4 MB
  rows:    66,304
  symbols: 2,949

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-01 04:00:00	AAPL	Stock	137.27	137.35	136.98	137.06	17098.0
2021-07-01 05:00:00	AAPL	Stock	136.98	136.98	136.76	136.76	8953.0
2021-07-01 06:00:00	AAPL	Stock	136.81	136.85	136.48	136.51	23506.0
2021-07-01 07:00:00	AAPL	Stock	136.59	136.96	136.51	136.94	78727.0
2021-07-01 08:00:00	AAPL	Stock	136.95	137.05	136.61	136.79	281883.0
2021-07-01 09:00:00	AAPL	Stock	136.79	137.19	136.41	136.937	7575629.0
2021-07-01 10:00:00	AAPL	Stock	136.935	136.935	136.26	136.44	7611412.0
2021-07-01 11:00:00	AAPL	Stock	136.4472	136.475	135.76	136.3183	6853935.0
2021-07-01 12:00:00	AAPL	Stock	136.315	136.53	136.04	136.0958	3854877.0
2021-07-01 13:00:00	AAPL	Stock	136.095	136.62	136.03	136.52	3663606.0
2021-07-01 14:00:00	AAPL	Stock	136.5299	137.0	136.4701	136.985	4118069.0
2021-07-01 15:00:00	AAPL	Stock	136.985	137.33	136.88	137.27	7858004.0
2021-07-01 16:00:00	AAPL	Stock	137.27	137.41	134.78	137.27	4701533.0
2021-07-01 17:00:00	AAPL	Stock	137.27	137.29	137.18	137.24	31754.0
2021-07-01 18:00:00	AAPL	Stock	137.21	137.26	137.15	137.22	20856.0
2021-07-01 19:00:00	AAPL	Stock	137.21	137.25	137.11	137.11	26194.0
2021-07-01 04:00:00	MSFT	Stock	271.54	271.65	271.2	271.2	2614.0
2021-07-01 05:00:00	MSFT	Stock	271.0	271.0	270.7	270.75	2721.0
2021-07-01 06:00:00	MSFT	Stock	270.8	270.8	270.13	270.13	4949.0
2021-07-01 07:00:00	MSFT	Stock	270.28	270.58	270.18	270.58	5067.0
2021-07-01 08:00:00	MSFT	Stock	270.38	270.75	270.3	270.38	13958.0
2021-07-01 09:00:00	MSFT	Stock	270.39	270.9	269.51	270.83	1789539.0
2021-07-01 10:00:00	MSFT	Stock	270.8692	271.14	270.21	270.52	1907961.0
2021-07-01 11:00:00	MSFT	Stock	270.54	270.58	269.95	270.54	1115456.0
2021-07-01 12:00:00	MSFT	Stock	270.53	270.67	270.1599	270.35	818000.0
2021-07-01 13:00:00	MSFT	Stock	270.36	270.83	270.1	270.6	947324.0
2021-07-01 14:00:00	MSFT	Stock	270.61	271.08	270.49	270.99	926432.0
2021-07-01 15:00:00	MSFT	Stock	270.99	271.84	270.65	271.72	2341350.0
2021-07-01 16:00:00	MSFT	Stock	271.72	271.75	268.72	271.6	2644806.0
2021-07-01 17:00:00	MSFT	Stock	271.61	271.61	271.45	271.45	2710.0
2021-07-01 18:00:00	MSFT	Stock	271.62	271.62	271.41	271.43	891.0
2021-07-01 19:00:00	MSFT	Stock	271.42	271.42	271.32	271.32	718.0
2021-07-01 04:00:00	NVDA	Stock	20.0908	20.0908	20.0638	20.075	96680.0
2021-07-01 05:00:00	NVDA	Stock	20.0488	20.0498	20.0468	20.0498	38400.0
2021-07-01 06:00:00	NVDA	Stock	19.9783	19.9783	19.9395	19.9578	104560.0
2021-07-01 07:00:00	NVDA	Stock	19.99	20.0838	19.975	20.045	493640.0
2021-07-01 08:00:00	NVDA	Stock	19.9125	20.1087	19.9125	20.103	1251240.0
2021-07-01 09:00:00	NVDA	Stock	20.1085	20.456	20.0875	20.2267	74957240.0
2021-07-01 10:00:00	NVDA	Stock	20.2285	20.2965	20.0878	20.2078	57218120.0
2021-07-01 11:00:00	NVDA	Stock	20.2064	20.225	20.019	20.125	35240440.0
2021-07-01 12:00:00	NVDA	Stock	20.1233	20.2845	20.11	20.206	32042920.0
2021-07-01 13:00:00	NVDA	Stock	20.2118	20.3187	20.1678	20.2382	25820720.0
2021-07-01 14:00:00	NVDA	Stock	20.2401	20.3028	20.2223	20.2605	20775400.0
2021-07-01 15:00:00	NVDA	Stock	20.2628	20.3608	20.1625	20.212	42887040.0
2021-07-01 16:00:00	NVDA	Stock	20.212	20.2215	19.985	20.21	13600640.0
2021-07-01 17:00:00	NVDA	Stock	20.21	20.21	20.1875	20.206	69680.0
2021-07-01 18:00:00	NVDA	Stock	20.1905	20.2008	20.175	20.1753	56720.0
2021-07-01 19:00:00	NVDA	Stock	20.1813	20.1875	20.162	20.162	109640.0
2021-07-01 04:00:00	AMZN	Stock	172.5	172.5	172.5	172.5	2000.0
2021-07-01 05:00:00	AMZN	Stock	172.345	172.35	172.05	172.05	15880.0

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

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