PREVIEW / stock_1hour / 2023-05-08

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-05-08.parquet
  size:    1.4 MB
  rows:    60,541
  symbols: 1,647

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-05-08 04:00:00	AAPL	Stock	173.1	173.57	173.1	173.42	19111.0
2023-05-08 05:00:00	AAPL	Stock	173.41	173.48	173.3	173.47	7287.0
2023-05-08 06:00:00	AAPL	Stock	173.47	173.54	173.1	173.23	20677.0
2023-05-08 07:00:00	AAPL	Stock	173.2	173.45	173.1	173.16	57868.0
2023-05-08 08:00:00	AAPL	Stock	173.27	173.46	172.76	172.9	254844.0
2023-05-08 09:00:00	AAPL	Stock	172.89	173.57	172.11	172.784	9331889.0
2023-05-08 10:00:00	AAPL	Stock	172.795	173.82	172.7201	173.47	9352613.0
2023-05-08 11:00:00	AAPL	Stock	173.48	173.768	173.15	173.76	4509214.0
2023-05-08 12:00:00	AAPL	Stock	173.77	173.82	173.41	173.44	3374942.0
2023-05-08 13:00:00	AAPL	Stock	173.45	173.85	173.35	173.705	2948744.0
2023-05-08 14:00:00	AAPL	Stock	173.7	173.8	172.96	173.725	4198062.0
2023-05-08 15:00:00	AAPL	Stock	173.725	173.78	173.21	173.52	4985189.0
2023-05-08 16:00:00	AAPL	Stock	173.52	173.53	173.3	173.35	4494748.0
2023-05-08 17:00:00	AAPL	Stock	173.35	173.5	173.35	173.4	1014876.0
2023-05-08 18:00:00	AAPL	Stock	173.38	173.38	173.2622	173.36	18218.0
2023-05-08 19:00:00	AAPL	Stock	173.36	173.43	173.25	173.28	11168.0
2023-05-08 04:00:00	MSFT	Stock	310.11	310.21	309.8	310.19	2205.0
2023-05-08 05:00:00	MSFT	Stock	310.21	310.21	310.21	310.21	404.0
2023-05-08 06:00:00	MSFT	Stock	310.24	310.34	310.2	310.21	1967.0
2023-05-08 07:00:00	MSFT	Stock	310.26	310.46	309.6	309.75	12035.0
2023-05-08 08:00:00	MSFT	Stock	310.21	310.5	309.0	309.45	72876.0
2023-05-08 09:00:00	MSFT	Stock	309.21	310.2	308.24	308.38	2418355.0
2023-05-08 10:00:00	MSFT	Stock	308.42	308.755	307.07	307.475	2520440.0
2023-05-08 11:00:00	MSFT	Stock	307.475	308.03	307.0	307.46	1972898.0
2023-05-08 12:00:00	MSFT	Stock	307.475	307.69	306.67	307.3335	1669109.0
2023-05-08 13:00:00	MSFT	Stock	307.36	307.75	307.03	307.38	1206005.0
2023-05-08 14:00:00	MSFT	Stock	307.39	308.8	306.09	308.77	2042570.0
2023-05-08 15:00:00	MSFT	Stock	308.77	308.85	308.01	308.64	2126989.0
2023-05-08 16:00:00	MSFT	Stock	308.6	308.65	306.8	307.73	2005935.0
2023-05-08 17:00:00	MSFT	Stock	307.76	307.88	307.7	307.88	2506.0
2023-05-08 18:00:00	MSFT	Stock	307.85	307.86	307.6	307.65	3612.0
2023-05-08 19:00:00	MSFT	Stock	307.8	307.84	307.58	307.84	3143.0
2023-05-08 04:00:00	NVDA	Stock	28.7	28.7	28.58	28.58	51520.0
2023-05-08 05:00:00	NVDA	Stock	28.579	28.579	28.53	28.558	50910.0
2023-05-08 06:00:00	NVDA	Stock	28.55	28.562	28.547	28.548	24410.0
2023-05-08 07:00:00	NVDA	Stock	28.55	28.622	28.55	28.595	120050.0
2023-05-08 08:00:00	NVDA	Stock	28.59	28.65	28.511	28.525	816290.0
2023-05-08 09:00:00	NVDA	Stock	28.525	28.613	28.35	28.477	32578070.0
2023-05-08 10:00:00	NVDA	Stock	28.48	28.697	28.373	28.653	44198160.0
2023-05-08 11:00:00	NVDA	Stock	28.6535	28.935	28.64	28.925	44071200.0
2023-05-08 12:00:00	NVDA	Stock	28.9248	28.985	28.833	28.9727	27758930.0
2023-05-08 13:00:00	NVDA	Stock	28.976	29.0582	28.881	28.987	27770170.0
2023-05-08 14:00:00	NVDA	Stock	28.984	29.199	28.817	29.1835	42057830.0
2023-05-08 15:00:00	NVDA	Stock	29.184	29.22	29.129	29.154	46103400.0
2023-05-08 16:00:00	NVDA	Stock	29.151	29.16	29.089	29.113	11664370.0
2023-05-08 17:00:00	NVDA	Stock	29.112	29.127	29.112	29.12	106390.0
2023-05-08 18:00:00	NVDA	Stock	29.115	29.123	29.06	29.08	207650.0
2023-05-08 19:00:00	NVDA	Stock	29.085	29.09	29.065	29.085	163780.0
2023-05-08 04:00:00	AMZN	Stock	105.64	105.77	105.45	105.45	5306.0
2023-05-08 05:00:00	AMZN	Stock	105.4	105.47	105.4	105.44	4691.0

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

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