PREVIEW / stock_1hour / 2021-04-26

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-04-26.parquet
  size:    1.4 MB
  rows:    65,724
  symbols: 2,970

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-26 04:00:00	AAPL	Stock	133.9	134.19	133.75	134.09	39420.0
2021-04-26 05:00:00	AAPL	Stock	134.16	134.16	133.9	133.94	8785.0
2021-04-26 06:00:00	AAPL	Stock	133.92	134.07	133.82	133.88	8511.0
2021-04-26 07:00:00	AAPL	Stock	133.97	134.55	133.73	134.46	276804.0
2021-04-26 08:00:00	AAPL	Stock	134.0501	134.68	133.82	134.61	441754.0
2021-04-26 09:00:00	AAPL	Stock	134.62	134.96	133.56	134.09	11284600.0
2021-04-26 10:00:00	AAPL	Stock	134.08	134.8	134.0305	134.48	8941510.0
2021-04-26 11:00:00	AAPL	Stock	134.481	134.83	134.44	134.5001	5408755.0
2021-04-26 12:00:00	AAPL	Stock	134.5012	134.64	134.2083	134.49	5061153.0
2021-04-26 13:00:00	AAPL	Stock	134.485	134.69	134.35	134.405	4463058.0
2021-04-26 14:00:00	AAPL	Stock	134.405	135.06	134.4	135.025	6114249.0
2021-04-26 15:00:00	AAPL	Stock	135.025	135.06	134.43	134.73	8844998.0
2021-04-26 16:00:00	AAPL	Stock	134.72	134.84	134.51	134.73	7405545.0
2021-04-26 17:00:00	AAPL	Stock	134.74	134.76	134.67	134.6901	101868.0
2021-04-26 18:00:00	AAPL	Stock	134.71	134.75	134.68	134.72	105981.0
2021-04-26 19:00:00	AAPL	Stock	134.72	134.9	134.7	134.9	64367.0
2021-04-26 04:00:00	MSFT	Stock	261.16	261.73	260.5	260.5	5500.0
2021-04-26 05:00:00	MSFT	Stock	260.71	260.85	260.34	260.34	3985.0
2021-04-26 06:00:00	MSFT	Stock	260.61	260.67	260.52	260.56	2847.0
2021-04-26 07:00:00	MSFT	Stock	260.63	261.09	260.3	260.51	55801.0
2021-04-26 08:00:00	MSFT	Stock	261.0	261.41	260.3	261.13	60724.0
2021-04-26 09:00:00	MSFT	Stock	261.08	262.435	260.17	261.33	2434530.0
2021-04-26 10:00:00	MSFT	Stock	261.29	261.8	260.42	260.77	2130566.0
2021-04-26 11:00:00	MSFT	Stock	260.77	261.6	260.77	261.05	1400464.0
2021-04-26 12:00:00	MSFT	Stock	261.055	261.4	260.87	261.1648	1103511.0
2021-04-26 13:00:00	MSFT	Stock	261.18	261.45	261.06	261.27	971431.0
2021-04-26 14:00:00	MSFT	Stock	261.27	262.0	261.16	261.8679	1277021.0
2021-04-26 15:00:00	MSFT	Stock	261.87	261.99	260.99	261.58	2654698.0
2021-04-26 16:00:00	MSFT	Stock	261.55	261.74	261.0	261.66	2767451.0
2021-04-26 17:00:00	MSFT	Stock	261.7	261.74	261.48	261.7	10163.0
2021-04-26 18:00:00	MSFT	Stock	261.6999	261.73	261.5	261.73	14564.0
2021-04-26 19:00:00	MSFT	Stock	261.74	261.9	261.61	261.9	9323.0
2021-04-26 04:00:00	NVDA	Stock	15.2062	15.2062	15.178	15.178	12080.0
2021-04-26 07:00:00	NVDA	Stock	15.1842	15.1842	15.1438	15.1512	127520.0
2021-04-26 08:00:00	NVDA	Stock	15.1625	15.2212	15.1625	15.2125	519760.0
2021-04-26 09:00:00	NVDA	Stock	15.1998	15.2525	15.125	15.197	21617080.0
2021-04-26 10:00:00	NVDA	Stock	15.1968	15.3308	15.1928	15.296	21015200.0
2021-04-26 11:00:00	NVDA	Stock	15.297	15.443	15.2948	15.3564	21279480.0
2021-04-26 12:00:00	NVDA	Stock	15.3575	15.3898	15.3035	15.3811	8577520.0
2021-04-26 13:00:00	NVDA	Stock	15.383	15.405	15.3548	15.3888	7422360.0
2021-04-26 14:00:00	NVDA	Stock	15.3881	15.4562	15.3758	15.4492	10777640.0
2021-04-26 15:00:00	NVDA	Stock	15.4482	15.479	15.408	15.479	21524040.0
2021-04-26 16:00:00	NVDA	Stock	15.478	15.478	15.4625	15.478	11310440.0
2021-04-26 17:00:00	NVDA	Stock	15.4775	15.4868	15.47	15.47	98720.0
2021-04-26 18:00:00	NVDA	Stock	15.47	15.48	15.47	15.4745	77280.0
2021-04-26 19:00:00	NVDA	Stock	15.4675	15.4848	15.463	15.4848	36080.0
2021-04-26 04:00:00	AMZN	Stock	167.0	167.0	166.7655	166.7655	8440.0
2021-04-26 06:00:00	AMZN	Stock	166.9945	166.9945	166.9945	166.9945	2180.0
2021-04-26 07:00:00	AMZN	Stock	166.9945	167.1425	166.705	167.1425	27140.0
2021-04-26 08:00:00	AMZN	Stock	166.9	167.3895	166.85	167.2985	50900.0

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

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