PREVIEW / stock_1hour / 2023-08-30

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-08-30.parquet
  size:    1.3 MB
  rows:    58,454
  symbols: 1,460

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-08-30 04:00:00	AAPL	Stock	184.3	184.53	183.14	184.06	13463.0
2023-08-30 05:00:00	AAPL	Stock	184.06	184.1	183.53	183.6	26706.0
2023-08-30 06:00:00	AAPL	Stock	183.63	184.06	183.63	184.01	16360.0
2023-08-30 07:00:00	AAPL	Stock	184.01	184.32	183.86	184.21	42560.0
2023-08-30 08:00:00	AAPL	Stock	184.07	185.17	183.85	184.66	247278.0
2023-08-30 09:00:00	AAPL	Stock	184.66	186.43	184.38	186.37	7650070.0
2023-08-30 10:00:00	AAPL	Stock	186.37	187.67	185.85	186.685	12282749.0
2023-08-30 11:00:00	AAPL	Stock	186.6889	187.33	186.18	187.16	4596513.0
2023-08-30 12:00:00	AAPL	Stock	187.15	187.77	187.01	187.44	4768548.0
2023-08-30 13:00:00	AAPL	Stock	187.435	187.59	186.89	187.1026	3090460.0
2023-08-30 14:00:00	AAPL	Stock	187.11	187.61	186.65	187.56	5074348.0
2023-08-30 15:00:00	AAPL	Stock	187.56	187.79	187.31	187.67	7995456.0
2023-08-30 16:00:00	AAPL	Stock	187.68	187.85	187.36	187.65	6949915.0
2023-08-30 17:00:00	AAPL	Stock	187.65	187.66	187.57	187.64	30327.0
2023-08-30 18:00:00	AAPL	Stock	187.65	187.66	187.6095	187.66	21018.0
2023-08-30 19:00:00	AAPL	Stock	187.66	187.66	187.6	187.66	25070.0
2023-08-30 04:00:00	MSFT	Stock	328.75	328.75	327.29	327.29	3080.0
2023-08-30 05:00:00	MSFT	Stock	327.17	327.3	327.17	327.3	2362.0
2023-08-30 06:00:00	MSFT	Stock	327.68	327.91	327.68	327.91	694.0
2023-08-30 07:00:00	MSFT	Stock	327.88	328.0	327.48	327.7	3937.0
2023-08-30 08:00:00	MSFT	Stock	328.0	329.44	327.27	328.82	21053.0
2023-08-30 09:00:00	MSFT	Stock	328.82	329.81	327.24	329.44	1415730.0
2023-08-30 10:00:00	MSFT	Stock	329.46	329.76	326.445	328.57	1753749.0
2023-08-30 11:00:00	MSFT	Stock	328.6	328.72	327.575	328.35	875012.0
2023-08-30 12:00:00	MSFT	Stock	328.35	329.07	328.07	328.865	798272.0
2023-08-30 13:00:00	MSFT	Stock	328.855	328.885	328.0456	328.5058	711127.0
2023-08-30 14:00:00	MSFT	Stock	328.49	329.03	327.38	328.81	842511.0
2023-08-30 15:00:00	MSFT	Stock	328.81	329.1212	328.02	328.73	1399473.0
2023-08-30 16:00:00	MSFT	Stock	328.79	329.38	328.79	328.96	2489748.0
2023-08-30 17:00:00	MSFT	Stock	328.95	329.12	328.82	328.82	10171.0
2023-08-30 18:00:00	MSFT	Stock	328.93	329.11	328.82	329.1	10161.0
2023-08-30 19:00:00	MSFT	Stock	328.94	329.09	328.85	329.09	1765.0
2023-08-30 04:00:00	NVDA	Stock	48.797	48.797	48.45	48.467	142170.0
2023-08-30 05:00:00	NVDA	Stock	48.486	48.486	48.35	48.4	115230.0
2023-08-30 06:00:00	NVDA	Stock	48.402	48.6	48.402	48.597	76020.0
2023-08-30 07:00:00	NVDA	Stock	48.632	49.165	48.597	49.079	1613550.0
2023-08-30 08:00:00	NVDA	Stock	48.626	49.333	48.6	49.149	5787870.0
2023-08-30 09:00:00	NVDA	Stock	49.146	49.5	48.425	48.951	93172700.0
2023-08-30 10:00:00	NVDA	Stock	48.963	49.622	48.638	49.5715	112158820.0
2023-08-30 11:00:00	NVDA	Stock	49.5758	49.766	49.356	49.512	74599730.0
2023-08-30 12:00:00	NVDA	Stock	49.5124	49.845	49.484	49.726	54324260.0
2023-08-30 13:00:00	NVDA	Stock	49.717	49.927	49.52	49.634	50099130.0
2023-08-30 14:00:00	NVDA	Stock	49.62	49.677	49.08	49.5055	75116200.0
2023-08-30 15:00:00	NVDA	Stock	49.499	49.572	48.9338	49.265	69478040.0
2023-08-30 16:00:00	NVDA	Stock	49.283	49.287	49.16	49.26	16667620.0
2023-08-30 17:00:00	NVDA	Stock	49.259	49.434	49.257	49.3943	1062980.0
2023-08-30 18:00:00	NVDA	Stock	49.4142	49.415	49.27	49.27	358360.0
2023-08-30 19:00:00	NVDA	Stock	49.288	49.385	49.28	49.345	529580.0
2023-08-30 04:00:00	AMZN	Stock	134.9	134.9	134.6	134.6	8198.0
2023-08-30 05:00:00	AMZN	Stock	134.7	134.7	134.5	134.7	4426.0

> showing 50 of 58,454 rows — these rows as CSV

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