PREVIEW / stock_1hour / 2022-11-08

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-11-08.parquet
  size:    1.4 MB
  rows:    60,873
  symbols: 2,080

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
2022-11-08 04:00:00	AAPL	Stock	139.04	139.49	138.64	139.4	24907.0
2022-11-08 05:00:00	AAPL	Stock	139.35	139.65	139.2	139.2	13658.0
2022-11-08 06:00:00	AAPL	Stock	139.27	139.93	139.27	139.75	92664.0
2022-11-08 07:00:00	AAPL	Stock	139.7	139.75	139.22	139.74	110061.0
2022-11-08 08:00:00	AAPL	Stock	139.675	140.08	138.6515	139.94	283103.0
2022-11-08 09:00:00	AAPL	Stock	139.95	140.49	138.44	139.16	8039608.0
2022-11-08 10:00:00	AAPL	Stock	139.16	139.52	138.04	139.4913	10259932.0
2022-11-08 11:00:00	AAPL	Stock	139.49	140.89	139.2	140.875	8697482.0
2022-11-08 12:00:00	AAPL	Stock	140.88	141.32	140.39	141.1105	7297996.0
2022-11-08 13:00:00	AAPL	Stock	141.1209	141.43	138.5	138.77	9041176.0
2022-11-08 14:00:00	AAPL	Stock	138.76	139.16	137.49	138.615	8652004.0
2022-11-08 15:00:00	AAPL	Stock	138.62	140.64	138.55	139.51	11213369.0
2022-11-08 16:00:00	AAPL	Stock	139.5	139.65	139.1001	139.52	8397850.0
2022-11-08 17:00:00	AAPL	Stock	139.54	139.66	139.5	139.59	39134.0
2022-11-08 18:00:00	AAPL	Stock	139.59	139.9	139.59	139.83	37641.0
2022-11-08 19:00:00	AAPL	Stock	139.85	140.0	139.55	139.98	34862.0
2022-11-08 04:00:00	MSFT	Stock	227.77	228.71	227.14	228.71	2053.0
2022-11-08 05:00:00	MSFT	Stock	228.66	229.36	228.0	228.1	2862.0
2022-11-08 06:00:00	MSFT	Stock	228.4	229.1	228.4	229.0	8383.0
2022-11-08 07:00:00	MSFT	Stock	229.0	229.15	228.44	228.88	16069.0
2022-11-08 08:00:00	MSFT	Stock	229.0999	229.55	228.42	229.1	39648.0
2022-11-08 09:00:00	MSFT	Stock	229.37	230.41	227.5285	229.65	2592300.0
2022-11-08 10:00:00	MSFT	Stock	229.58	230.73	228.68	229.35	2546439.0
2022-11-08 11:00:00	MSFT	Stock	229.37	231.54	228.45	231.025	2387246.0
2022-11-08 12:00:00	MSFT	Stock	231.03	231.65	230.38	230.82	1687599.0
2022-11-08 13:00:00	MSFT	Stock	230.81	231.3	227.05	227.36	2097815.0
2022-11-08 14:00:00	MSFT	Stock	227.33	228.21	225.84	227.68	2312799.0
2022-11-08 15:00:00	MSFT	Stock	227.675	230.5	227.63	228.83	3600563.0
2022-11-08 16:00:00	MSFT	Stock	228.87	228.95	228.4	228.6829	3202681.0
2022-11-08 17:00:00	MSFT	Stock	228.85	228.85	228.67	228.7702	11245.0
2022-11-08 18:00:00	MSFT	Stock	228.9	229.95	228.9	229.55	7522.0
2022-11-08 19:00:00	MSFT	Stock	229.5	229.72	229.0	229.6	6450.0
2022-11-08 04:00:00	NVDA	Stock	14.436	14.509	14.39	14.488	266140.0
2022-11-08 05:00:00	NVDA	Stock	14.495	14.53	14.472	14.501	309050.0
2022-11-08 06:00:00	NVDA	Stock	14.501	14.724	14.501	14.65	575510.0
2022-11-08 07:00:00	NVDA	Stock	14.652	14.759	14.64	14.753	1032920.0
2022-11-08 08:00:00	NVDA	Stock	14.6408	14.835	14.3367	14.79	3190790.0
2022-11-08 09:00:00	NVDA	Stock	14.79	14.891	14.026	14.634	93656420.0
2022-11-08 10:00:00	NVDA	Stock	14.63	14.674	14.439	14.626	92085440.0
2022-11-08 11:00:00	NVDA	Stock	14.628	14.867	14.602	14.753	64748260.0
2022-11-08 12:00:00	NVDA	Stock	14.7565	14.8	14.678	14.737	34535880.0
2022-11-08 13:00:00	NVDA	Stock	14.7371	14.778	14.41	14.4513	50964540.0
2022-11-08 14:00:00	NVDA	Stock	14.449	14.507	14.216	14.451	65682950.0
2022-11-08 15:00:00	NVDA	Stock	14.451	14.6905	14.436	14.602	76532700.0
2022-11-08 16:00:00	NVDA	Stock	14.602	14.615	14.581	14.581	18169110.0
2022-11-08 17:00:00	NVDA	Stock	14.585	14.595	14.564	14.595	242840.0
2022-11-08 18:00:00	NVDA	Stock	14.584	14.65	14.58	14.645	184590.0
2022-11-08 19:00:00	NVDA	Stock	14.632	14.65	14.581	14.649	290610.0
2022-11-08 04:00:00	AMZN	Stock	90.7	90.85	90.41	90.85	22828.0
2022-11-08 05:00:00	AMZN	Stock	90.87	91.0	90.6	90.64	16385.0

> showing 50 of 60,873 rows — these rows as CSV

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