PREVIEW / stock_1hour / 2021-08-20

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-08-20.parquet
  size:    1.4 MB
  rows:    64,535
  symbols: 2,822

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-08-20 04:00:00	AAPL	Stock	146.0	146.49	145.9	146.24	15319.0
2021-08-20 05:00:00	AAPL	Stock	146.22	146.5	146.15	146.43	12928.0
2021-08-20 06:00:00	AAPL	Stock	146.35	146.49	146.3	146.48	2373.0
2021-08-20 07:00:00	AAPL	Stock	146.46	146.65	146.11	146.5	86406.0
2021-08-20 08:00:00	AAPL	Stock	146.5133	147.4	146.15	147.34	399003.0
2021-08-20 09:00:00	AAPL	Stock	147.35	147.98	146.7	147.49	9924623.0
2021-08-20 10:00:00	AAPL	Stock	147.5	148.5	147.35	147.8707	9380569.0
2021-08-20 11:00:00	AAPL	Stock	147.87	148.035	147.12	147.35	5697871.0
2021-08-20 12:00:00	AAPL	Stock	147.345	148.07	147.24	147.895	4953760.0
2021-08-20 13:00:00	AAPL	Stock	147.91	148.0299	147.55	147.7467	3277453.0
2021-08-20 14:00:00	AAPL	Stock	147.74	147.96	147.56	147.9599	3545913.0
2021-08-20 15:00:00	AAPL	Stock	147.9592	148.29	147.8	148.19	7618575.0
2021-08-20 16:00:00	AAPL	Stock	148.19	148.3	148.06	148.1501	7510232.0
2021-08-20 17:00:00	AAPL	Stock	148.16	148.28	148.12	148.19	290441.0
2021-08-20 18:00:00	AAPL	Stock	148.19	148.4	148.17	148.2	33039.0
2021-08-20 19:00:00	AAPL	Stock	148.16	148.31	148.15	148.31	37221.0
2021-08-20 04:00:00	MSFT	Stock	295.0	295.79	295.0	295.76	5417.0
2021-08-20 05:00:00	MSFT	Stock	295.45	296.04	295.45	295.99	4235.0
2021-08-20 06:00:00	MSFT	Stock	295.9	296.2	295.9	296.14	4082.0
2021-08-20 07:00:00	MSFT	Stock	296.12	296.77	295.82	296.39	20777.0
2021-08-20 08:00:00	MSFT	Stock	296.0	298.84	295.82	298.84	74245.0
2021-08-20 09:00:00	MSFT	Stock	298.74	303.54	298.06	302.58	6350989.0
2021-08-20 10:00:00	MSFT	Stock	302.5969	305.84	302.32	304.125	8360685.0
2021-08-20 11:00:00	MSFT	Stock	304.12	304.3	303.15	303.74	3903059.0
2021-08-20 12:00:00	MSFT	Stock	303.72	305.0999	303.57	304.24	3032936.0
2021-08-20 13:00:00	MSFT	Stock	304.2438	304.64	303.66	304.18	1836707.0
2021-08-20 14:00:00	MSFT	Stock	304.2	304.67	304.04	304.33	1659019.0
2021-08-20 15:00:00	MSFT	Stock	304.325	305.1	304.16	304.26	4007694.0
2021-08-20 16:00:00	MSFT	Stock	304.27	304.59	304.1	304.35	3631216.0
2021-08-20 17:00:00	MSFT	Stock	304.35	304.36	304.14	304.28	51482.0
2021-08-20 18:00:00	MSFT	Stock	304.28	304.35	304.2	304.24	9189.0
2021-08-20 19:00:00	MSFT	Stock	304.35	304.6	304.33	304.6	9536.0
2021-08-20 04:00:00	NVDA	Stock	19.785	19.801	19.72	19.766	44980.0
2021-08-20 05:00:00	NVDA	Stock	19.751	19.864	19.734	19.734	32620.0
2021-08-20 06:00:00	NVDA	Stock	19.765	19.851	19.765	19.851	57160.0
2021-08-20 07:00:00	NVDA	Stock	19.836	19.912	19.794	19.9	584170.0
2021-08-20 08:00:00	NVDA	Stock	19.81	19.948	19.692	19.845	1812390.0
2021-08-20 09:00:00	NVDA	Stock	19.86	20.324	19.852	20.3185	79770100.0
2021-08-20 10:00:00	NVDA	Stock	20.319	20.593	20.175	20.457	99679100.0
2021-08-20 11:00:00	NVDA	Stock	20.4584	20.489	20.178	20.237	63885460.0
2021-08-20 12:00:00	NVDA	Stock	20.239	20.5359	20.16	20.506	50215500.0
2021-08-20 13:00:00	NVDA	Stock	20.511	20.5881	20.439	20.545	44340080.0
2021-08-20 14:00:00	NVDA	Stock	20.547	20.8651	20.546	20.794	109837960.0
2021-08-20 15:00:00	NVDA	Stock	20.795	20.855	20.724	20.816	93802070.0
2021-08-20 16:00:00	NVDA	Stock	20.816	20.86	20.77	20.836	18455440.0
2021-08-20 17:00:00	NVDA	Stock	20.835	20.866	20.816	20.84	1163330.0
2021-08-20 18:00:00	NVDA	Stock	20.85	20.87	20.825	20.84	338030.0
2021-08-20 19:00:00	NVDA	Stock	20.84	20.85	20.807	20.849	326950.0
2021-08-20 04:00:00	AMZN	Stock	159.1	159.1	159.05	159.05	4480.0
2021-08-20 05:00:00	AMZN	Stock	159.0115	159.0115	159.0	159.0	6920.0

> showing 50 of 64,535 rows — these rows as CSV

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