PREVIEW / stock_1hour / 2023-05-12

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-05-12.parquet
  size:    1.3 MB
  rows:    59,169
  symbols: 1,638

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-12 04:00:00	AAPL	Stock	174.0	174.05	173.77	173.86	12781.0
2023-05-12 05:00:00	AAPL	Stock	173.86	173.95	173.5	173.5	6366.0
2023-05-12 06:00:00	AAPL	Stock	173.57	173.81	173.54	173.69	3929.0
2023-05-12 07:00:00	AAPL	Stock	173.83	173.87	173.55	173.6	28407.0
2023-05-12 08:00:00	AAPL	Stock	173.74	173.85	173.34	173.5	101353.0
2023-05-12 09:00:00	AAPL	Stock	173.47	174.06	172.95	173.08	5021525.0
2023-05-12 10:00:00	AAPL	Stock	173.08	173.26	172.33	172.78	5333134.0
2023-05-12 11:00:00	AAPL	Stock	172.78	172.975	172.32	172.665	3693865.0
2023-05-12 12:00:00	AAPL	Stock	172.67	172.69	171.49	171.54	4109904.0
2023-05-12 13:00:00	AAPL	Stock	171.53	172.015	171.21	171.28	3410953.0
2023-05-12 14:00:00	AAPL	Stock	171.27	171.75	171.0	171.6599	4083282.0
2023-05-12 15:00:00	AAPL	Stock	171.66	172.62	171.56	172.56	7146590.0
2023-05-12 16:00:00	AAPL	Stock	172.57	172.57	172.41	172.48	5105274.0
2023-05-12 17:00:00	AAPL	Stock	172.46	172.5	172.35	172.39	46956.0
2023-05-12 18:00:00	AAPL	Stock	172.4	172.45	172.35	172.3701	10850.0
2023-05-12 19:00:00	AAPL	Stock	172.4	172.45	172.36	172.45	20263.0
2023-05-12 04:00:00	MSFT	Stock	310.2	310.46	310.2	310.29	673.0
2023-05-12 05:00:00	MSFT	Stock	310.35	310.4	310.16	310.2	1034.0
2023-05-12 06:00:00	MSFT	Stock	310.15	310.24	310.15	310.24	226.0
2023-05-12 07:00:00	MSFT	Stock	310.34	310.6	309.52	309.65	11562.0
2023-05-12 08:00:00	MSFT	Stock	309.5306	310.48	309.4	309.84	19395.0
2023-05-12 09:00:00	MSFT	Stock	309.74	310.8	307.6	308.1	2086379.0
2023-05-12 10:00:00	MSFT	Stock	308.2	308.58	306.95	308.07	2487885.0
2023-05-12 11:00:00	MSFT	Stock	308.07	308.79	307.2	308.55	1617322.0
2023-05-12 12:00:00	MSFT	Stock	308.55	308.6	306.86	307.0369	1052494.0
2023-05-12 13:00:00	MSFT	Stock	307.02	308.41	306.97	307.16	1199308.0
2023-05-12 14:00:00	MSFT	Stock	307.15	307.82	306.6	307.5885	1395432.0
2023-05-12 15:00:00	MSFT	Stock	307.6	309.23	307.43	309.02	2177685.0
2023-05-12 16:00:00	MSFT	Stock	308.97	309.06	308.55	308.55	2432167.0
2023-05-12 17:00:00	MSFT	Stock	308.6399	308.6399	308.15	308.2	6256.0
2023-05-12 18:00:00	MSFT	Stock	308.18	308.2999	308.1333	308.28	2728.0
2023-05-12 19:00:00	MSFT	Stock	308.31	308.41	308.31	308.37	8926.0
2023-05-12 04:00:00	NVDA	Stock	28.66	28.7	28.66	28.683	22080.0
2023-05-12 05:00:00	NVDA	Stock	28.683	28.8	28.5	28.5	141580.0
2023-05-12 06:00:00	NVDA	Stock	28.5	28.52	28.369	28.52	88690.0
2023-05-12 07:00:00	NVDA	Stock	28.52	28.585	28.51	28.521	229120.0
2023-05-12 08:00:00	NVDA	Stock	28.5	28.75	28.478	28.545	707490.0
2023-05-12 09:00:00	NVDA	Stock	28.535	28.78	28.488	28.565	33722650.0
2023-05-12 10:00:00	NVDA	Stock	28.562	28.604	28.241	28.293	40024030.0
2023-05-12 11:00:00	NVDA	Stock	28.294	28.393	28.19	28.349	25451190.0
2023-05-12 12:00:00	NVDA	Stock	28.348	28.3485	28.046	28.159	26685310.0
2023-05-12 13:00:00	NVDA	Stock	28.155	28.315	28.12	28.15	25578490.0
2023-05-12 14:00:00	NVDA	Stock	28.15	28.2152	28.1135	28.204	17232010.0
2023-05-12 15:00:00	NVDA	Stock	28.205	28.359	28.1893	28.339	27053570.0
2023-05-12 16:00:00	NVDA	Stock	28.34	28.34	28.288	28.295	12098140.0
2023-05-12 17:00:00	NVDA	Stock	28.292	28.292	28.262	28.274	75530.0
2023-05-12 18:00:00	NVDA	Stock	28.275	28.2798	28.262	28.263	80980.0
2023-05-12 19:00:00	NVDA	Stock	28.262	28.284	28.26	28.27	37510.0
2023-05-12 04:00:00	AMZN	Stock	112.5	112.5	111.93	112.33	11672.0
2023-05-12 05:00:00	AMZN	Stock	112.33	112.33	112.19	112.23	8738.0

> showing 50 of 59,169 rows — these rows as CSV

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