PREVIEW / stock_1hour / 2023-03-01

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-03-01.parquet
  size:    1.4 MB
  rows:    61,067
  symbols: 1,814

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-01 04:00:00	AAPL	Stock	147.66	148.33	147.66	148.17	21260.0
2023-03-01 05:00:00	AAPL	Stock	148.16	148.45	148.12	148.37	11339.0
2023-03-01 06:00:00	AAPL	Stock	148.4	148.49	148.19	148.24	18693.0
2023-03-01 07:00:00	AAPL	Stock	148.19	148.25	148.04	148.09	49627.0
2023-03-01 08:00:00	AAPL	Stock	148.1401	148.2001	147.05	147.05	201166.0
2023-03-01 09:00:00	AAPL	Stock	147.07	147.31	146.31	146.92	5624830.0
2023-03-01 10:00:00	AAPL	Stock	146.93	147.15	145.49	146.49	7401633.0
2023-03-01 11:00:00	AAPL	Stock	146.47	146.63	145.41	146.4487	4974943.0
2023-03-01 12:00:00	AAPL	Stock	146.46	146.88	146.31	146.385	3023047.0
2023-03-01 13:00:00	AAPL	Stock	146.3801	146.4	145.72	145.88	2926647.0
2023-03-01 14:00:00	AAPL	Stock	145.875	145.93	145.26	145.49	4022145.0
2023-03-01 15:00:00	AAPL	Stock	145.49	145.686	145.01	145.33	9352809.0
2023-03-01 16:00:00	AAPL	Stock	145.33	145.55	145.22	145.32	9733706.0
2023-03-01 17:00:00	AAPL	Stock	145.33	145.4	145.11	145.2198	38529.0
2023-03-01 18:00:00	AAPL	Stock	145.21	145.4	145.16	145.33	61083.0
2023-03-01 19:00:00	AAPL	Stock	145.35	145.75	145.1	145.12	46954.0
2023-03-01 04:00:00	MSFT	Stock	250.78	251.89	250.71	250.84	7953.0
2023-03-01 05:00:00	MSFT	Stock	251.21	251.63	251.0	251.46	5241.0
2023-03-01 06:00:00	MSFT	Stock	251.5	251.85	251.35	251.79	8190.0
2023-03-01 07:00:00	MSFT	Stock	251.79	251.79	251.06	251.41	27650.0
2023-03-01 08:00:00	MSFT	Stock	251.58	251.7513	249.94	250.5	55934.0
2023-03-01 09:00:00	MSFT	Stock	250.6	252.15	247.77	249.6	3189842.0
2023-03-01 10:00:00	MSFT	Stock	249.63	249.93	247.25	248.35	2726201.0
2023-03-01 11:00:00	MSFT	Stock	248.35	248.64	246.57	248.42	2290088.0
2023-03-01 12:00:00	MSFT	Stock	248.43	248.62	247.71	247.81	1614460.0
2023-03-01 13:00:00	MSFT	Stock	247.816	247.89	246.93	247.15	1329468.0
2023-03-01 14:00:00	MSFT	Stock	247.1678	247.19	246.31	246.4868	1373456.0
2023-03-01 15:00:00	MSFT	Stock	246.49	246.9	245.79	246.4	3710409.0
2023-03-01 16:00:00	MSFT	Stock	246.4	247.23	246.12	247.23	4885797.0
2023-03-01 17:00:00	MSFT	Stock	247.13	247.35	246.7205	246.8798	8791.0
2023-03-01 18:00:00	MSFT	Stock	246.85	247.35	246.27	247.23	29968.0
2023-03-01 19:00:00	MSFT	Stock	247.35	248.4	247.1	247.22	29436.0
2023-03-01 04:00:00	NVDA	Stock	22.913	23.06	22.875	22.912	444880.0
2023-03-01 05:00:00	NVDA	Stock	22.92	23.025	22.91	23.024	233030.0
2023-03-01 06:00:00	NVDA	Stock	23.037	23.037	22.97	22.97	260010.0
2023-03-01 07:00:00	NVDA	Stock	22.951	23.151	22.946	23.084	1086420.0
2023-03-01 08:00:00	NVDA	Stock	23.013	23.188	22.927	23.118	2983810.0
2023-03-01 09:00:00	NVDA	Stock	23.128	23.274	22.981	23.003	62700580.0
2023-03-01 10:00:00	NVDA	Stock	23.009	23.0559	22.613	22.7185	76144040.0
2023-03-01 11:00:00	NVDA	Stock	22.717	22.782	22.508	22.724	51737680.0
2023-03-01 12:00:00	NVDA	Stock	22.7281	22.836	22.67	22.763	28675260.0
2023-03-01 13:00:00	NVDA	Stock	22.765	22.773	22.6237	22.72	25376010.0
2023-03-01 14:00:00	NVDA	Stock	22.72	22.784	22.646	22.689	28672770.0
2023-03-01 15:00:00	NVDA	Stock	22.692	22.816	22.665	22.699	46436860.0
2023-03-01 16:00:00	NVDA	Stock	22.6995	22.818	22.672	22.753	24193920.0
2023-03-01 17:00:00	NVDA	Stock	22.76	22.78	22.675	22.706	312780.0
2023-03-01 18:00:00	NVDA	Stock	22.72	22.75	22.701	22.731	195470.0
2023-03-01 19:00:00	NVDA	Stock	22.732	22.78	22.732	22.745	466260.0
2023-03-01 04:00:00	AMZN	Stock	94.65	94.95	94.65	94.82	13995.0
2023-03-01 05:00:00	AMZN	Stock	94.74	94.95	94.71	94.95	16393.0

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

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