PREVIEW / stock_1hour / 2023-03-14

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-03-14.parquet
  size:    1.4 MB
  rows:    61,676
  symbols: 1,773

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
2023-03-14 04:00:00	AAPL	Stock	150.95	151.32	150.67	151.07	15126.0
2023-03-14 05:00:00	AAPL	Stock	151.08	151.18	150.82	151.0	12513.0
2023-03-14 06:00:00	AAPL	Stock	150.98	151.15	150.92	151.14	13300.0
2023-03-14 07:00:00	AAPL	Stock	151.14	151.8	151.14	151.56	28525.0
2023-03-14 08:00:00	AAPL	Stock	151.18	152.68	150.0	152.19	412410.0
2023-03-14 09:00:00	AAPL	Stock	152.16	152.79	150.99	152.5399	7028208.0
2023-03-14 10:00:00	AAPL	Stock	152.52	153.2	152.188	152.65	6829917.0
2023-03-14 11:00:00	AAPL	Stock	152.64	153.4	152.62	152.68	5167096.0
2023-03-14 12:00:00	AAPL	Stock	152.675	153.0687	152.3	152.56	4867422.0
2023-03-14 13:00:00	AAPL	Stock	152.5699	152.8015	150.52	150.9833	8417066.0
2023-03-14 14:00:00	AAPL	Stock	150.98	151.64	150.43	151.01	5819320.0
2023-03-14 15:00:00	AAPL	Stock	151.0125	152.81	150.1	152.55	12626688.0
2023-03-14 16:00:00	AAPL	Stock	152.5	152.82	152.445	152.78	12682309.0
2023-03-14 17:00:00	AAPL	Stock	152.75	152.8099	152.44	152.51	59968.0
2023-03-14 18:00:00	AAPL	Stock	152.55	152.67	152.47	152.58	34222.0
2023-03-14 19:00:00	AAPL	Stock	152.6	152.77	152.6	152.77	23645.0
2023-03-14 04:00:00	MSFT	Stock	255.19	255.7	255.0	255.0	2082.0
2023-03-14 05:00:00	MSFT	Stock	255.03	255.17	255.03	255.17	880.0
2023-03-14 06:00:00	MSFT	Stock	255.0	255.1	254.58	255.0	4220.0
2023-03-14 07:00:00	MSFT	Stock	254.99	256.37	254.99	255.43	17372.0
2023-03-14 08:00:00	MSFT	Stock	255.22	256.92	251.65	255.99	117135.0
2023-03-14 09:00:00	MSFT	Stock	256.24	258.49	255.0	256.735	2845868.0
2023-03-14 10:00:00	MSFT	Stock	256.8	258.3467	256.68	257.9	2812364.0
2023-03-14 11:00:00	MSFT	Stock	257.91	260.33	257.9	260.025	2685240.0
2023-03-14 12:00:00	MSFT	Stock	260.0	260.1754	259.07	259.66	2017688.0
2023-03-14 13:00:00	MSFT	Stock	259.7	259.91	258.01	258.596	2267866.0
2023-03-14 14:00:00	MSFT	Stock	258.5983	259.42	257.64	258.7901	2127639.0
2023-03-14 15:00:00	MSFT	Stock	258.8	261.07	257.38	260.79	4662289.0
2023-03-14 16:00:00	MSFT	Stock	260.79	262.0	260.22	260.62	6196760.0
2023-03-14 17:00:00	MSFT	Stock	260.78	260.79	260.452	260.46	9479.0
2023-03-14 18:00:00	MSFT	Stock	260.54	260.71	260.29	260.29	5245.0
2023-03-14 19:00:00	MSFT	Stock	260.65	260.99	260.64	260.78	13345.0
2023-03-14 04:00:00	NVDA	Stock	23.037	23.1	23.002	23.1	80160.0
2023-03-14 05:00:00	NVDA	Stock	23.096	23.1	23.016	23.016	113060.0
2023-03-14 06:00:00	NVDA	Stock	23.015	23.06	23.0	23.06	54470.0
2023-03-14 07:00:00	NVDA	Stock	23.05	23.275	23.05	23.214	389060.0
2023-03-14 08:00:00	NVDA	Stock	23.0701	23.545	22.8	23.365	3050370.0
2023-03-14 09:00:00	NVDA	Stock	23.38	23.9164	23.301	23.802	56434850.0
2023-03-14 10:00:00	NVDA	Stock	23.804	24.11	23.74	23.951	71331980.0
2023-03-14 11:00:00	NVDA	Stock	23.954	24.219	23.94	24.161	45398080.0
2023-03-14 12:00:00	NVDA	Stock	24.158	24.215	24.068	24.143	37818440.0
2023-03-14 13:00:00	NVDA	Stock	24.145	24.178	23.846	23.869	41085370.0
2023-03-14 14:00:00	NVDA	Stock	23.869	23.928	23.711	23.776	38409000.0
2023-03-14 15:00:00	NVDA	Stock	23.778	24.097	23.5958	24.062	57312160.0
2023-03-14 16:00:00	NVDA	Stock	24.063	24.2	24.01	24.064	33717080.0
2023-03-14 17:00:00	NVDA	Stock	24.059	24.07	24.041	24.055	314320.0
2023-03-14 18:00:00	NVDA	Stock	24.065	24.08	24.045	24.061	269230.0
2023-03-14 19:00:00	NVDA	Stock	24.058	24.103	24.053	24.103	263340.0
2023-03-14 04:00:00	AMZN	Stock	92.68	93.38	92.68	93.23	12314.0
2023-03-14 05:00:00	AMZN	Stock	93.25	93.25	92.99	93.19	7278.0

> showing 50 of 61,676 rows — these rows as CSV

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