PREVIEW / stock_1hour / 2021-07-20

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-07-20.parquet
  size:    1.4 MB
  rows:    65,397
  symbols: 2,859

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-20 04:00:00	AAPL	Stock	143.3	143.6	142.99	143.08	45940.0
2021-07-20 05:00:00	AAPL	Stock	143.1	143.29	142.75	142.92	12602.0
2021-07-20 06:00:00	AAPL	Stock	142.9	143.65	142.89	143.65	24887.0
2021-07-20 07:00:00	AAPL	Stock	143.63	143.8	143.3	143.55	166648.0
2021-07-20 08:00:00	AAPL	Stock	143.56	143.8	143.23	143.5	608905.0
2021-07-20 09:00:00	AAPL	Stock	143.5	144.315	142.96	144.22	12613731.0
2021-07-20 10:00:00	AAPL	Stock	144.22	145.25	143.8	145.16	13919669.0
2021-07-20 11:00:00	AAPL	Stock	145.16	145.66	144.915	145.6301	8012059.0
2021-07-20 12:00:00	AAPL	Stock	145.64	146.7	145.54	146.7	8459061.0
2021-07-20 13:00:00	AAPL	Stock	146.7	147.0997	146.19	146.75	9213471.0
2021-07-20 14:00:00	AAPL	Stock	146.751	146.99	146.2	146.4111	7902666.0
2021-07-20 15:00:00	AAPL	Stock	146.42	147.005	146.1	146.1427	12399570.0
2021-07-20 16:00:00	AAPL	Stock	146.15	146.15	145.71	146.11	12123814.0
2021-07-20 17:00:00	AAPL	Stock	146.13	146.15	146.0	146.09	54311.0
2021-07-20 18:00:00	AAPL	Stock	146.09	146.39	145.54	146.2	51622.0
2021-07-20 19:00:00	AAPL	Stock	146.19	146.45	146.18	146.3399	47468.0
2021-07-20 04:00:00	MSFT	Stock	278.0	278.84	278.0	278.63	3580.0
2021-07-20 05:00:00	MSFT	Stock	278.5	278.58	278.2	278.2	21114.0
2021-07-20 06:00:00	MSFT	Stock	278.21	278.6	278.2	278.49	3346.0
2021-07-20 07:00:00	MSFT	Stock	278.55	278.72	278.14	278.33	15723.0
2021-07-20 08:00:00	MSFT	Stock	278.75	278.75	277.88	278.19	34466.0
2021-07-20 09:00:00	MSFT	Stock	278.23	278.48	276.26	277.75	1927097.0
2021-07-20 10:00:00	MSFT	Stock	277.75	278.52	276.54	278.36	2172301.0
2021-07-20 11:00:00	MSFT	Stock	278.37	278.7943	277.8	278.76	1634105.0
2021-07-20 12:00:00	MSFT	Stock	278.74	280.18	278.7	280.17	1842938.0
2021-07-20 13:00:00	MSFT	Stock	280.18	280.19	279.17	279.352	1769263.0
2021-07-20 14:00:00	MSFT	Stock	279.3698	280.7403	279.35	280.31	1522115.0
2021-07-20 15:00:00	MSFT	Stock	280.31	280.97	279.1499	279.32	3470205.0
2021-07-20 16:00:00	MSFT	Stock	279.315	279.42	279.15	279.35	5754424.0
2021-07-20 17:00:00	MSFT	Stock	279.32	279.62	279.32	279.5	13143.0
2021-07-20 18:00:00	MSFT	Stock	279.5	279.64	278.7733	279.63	6031.0
2021-07-20 19:00:00	MSFT	Stock	279.63	279.9	279.63	279.85	5052.0
2021-07-20 04:00:00	NVDA	Stock	18.99	18.99	18.851	18.949	982050.0
2021-07-20 05:00:00	NVDA	Stock	18.949	18.975	18.9	18.917	316650.0
2021-07-20 06:00:00	NVDA	Stock	18.917	18.95	18.845	18.88	514040.0
2021-07-20 07:00:00	NVDA	Stock	18.88	19.02	18.86	18.964	2491380.0
2021-07-20 08:00:00	NVDA	Stock	18.942	19.024	18.513	18.65	5336850.0
2021-07-20 09:00:00	NVDA	Stock	18.65	18.87	18.164	18.4552	60709250.0
2021-07-20 10:00:00	NVDA	Stock	18.456	18.583	18.299	18.311	46856690.0
2021-07-20 11:00:00	NVDA	Stock	18.311	18.478	18.165	18.4205	38951960.0
2021-07-20 12:00:00	NVDA	Stock	18.4185	18.59	18.403	18.562	25304120.0
2021-07-20 13:00:00	NVDA	Stock	18.562	18.575	18.305	18.3725	24827910.0
2021-07-20 14:00:00	NVDA	Stock	18.368	18.638	18.3571	18.61	30513630.0
2021-07-20 15:00:00	NVDA	Stock	18.606	18.838	18.591	18.606	55508090.0
2021-07-20 16:00:00	NVDA	Stock	18.637	18.675	18.59	18.675	16203410.0
2021-07-20 17:00:00	NVDA	Stock	18.684	18.688	18.612	18.68	179050.0
2021-07-20 18:00:00	NVDA	Stock	18.685	18.7	18.675	18.695	92140.0
2021-07-20 19:00:00	NVDA	Stock	18.685	18.748	18.662	18.662	223920.0
2021-07-20 04:00:00	AMZN	Stock	178.45	178.45	178.45	178.45	12200.0
2021-07-20 05:00:00	AMZN	Stock	178.45	178.535	178.45	178.45	19100.0

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

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