PREVIEW / stock_1hour / 2002-08-20

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-08-20.parquet
  size:    389 KB
  rows:    18,644
  symbols: 1,461

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
2002-08-20 08:00:00	AAPL	Stock	0.2832	0.2848	0.283	0.2848	161448.0
2002-08-20 09:00:00	AAPL	Stock	0.2848	0.2857	0.2805	0.2813	31470936.0
2002-08-20 10:00:00	AAPL	Stock	0.2813	0.2855	0.2773	0.2845	30178456.0
2002-08-20 11:00:00	AAPL	Stock	0.2839	0.2855	0.2821	0.2852	24840984.0
2002-08-20 12:00:00	AAPL	Stock	0.2852	0.2873	0.2848	0.2854	23680888.0
2002-08-20 13:00:00	AAPL	Stock	0.2852	0.2857	0.2823	0.2848	11312448.0
2002-08-20 14:00:00	AAPL	Stock	0.2848	0.2848	0.2813	0.2845	30879688.0
2002-08-20 15:00:00	AAPL	Stock	0.2845	0.2854	0.2821	0.2848	23357936.0
2002-08-20 16:00:00	AAPL	Stock	0.2843	0.2857	0.2838	0.2845	5269600.0
2002-08-20 17:00:00	AAPL	Stock	0.2841	0.2841	0.2841	0.2841	604800.0
2002-08-20 18:00:00	AAPL	Stock	0.2841	0.2841	0.2841	0.2841	2004800.0
2002-08-20 08:00:00	MSFT	Stock	26.0	26.0	25.751	25.845	45500.0
2002-08-20 09:00:00	MSFT	Stock	25.8	25.995	25.395	25.54	9896980.0
2002-08-20 10:00:00	MSFT	Stock	25.54	25.795	25.465	25.7495	11867458.0
2002-08-20 11:00:00	MSFT	Stock	25.745	25.845	25.5	25.65	8446042.0
2002-08-20 12:00:00	MSFT	Stock	25.655	25.685	25.44	25.6315	6856836.0
2002-08-20 13:00:00	MSFT	Stock	25.62	25.6275	25.375	25.55	7567480.0
2002-08-20 14:00:00	MSFT	Stock	25.55	25.65	25.385	25.59	10294574.0
2002-08-20 15:00:00	MSFT	Stock	25.605	25.705	25.439	25.525	13027742.0
2002-08-20 16:00:00	MSFT	Stock	25.525	25.615	25.5095	25.6	1185682.0
2002-08-20 17:00:00	MSFT	Stock	25.575	25.625	25.52	25.52	97200.0
2002-08-20 18:00:00	MSFT	Stock	25.52	25.59	25.52	25.58	274800.0
2002-08-20 08:00:00	NVDA	Stock	0.1054	0.1071	0.1032	0.1048	6213840.0
2002-08-20 09:00:00	NVDA	Stock	0.1046	0.108	0.1037	0.1079	283158240.0
2002-08-20 10:00:00	NVDA	Stock	0.108	0.1083	0.1055	0.1064	276152880.0
2002-08-20 11:00:00	NVDA	Stock	0.1063	0.1074	0.1023	0.1035	201405000.0
2002-08-20 12:00:00	NVDA	Stock	0.1035	0.1041	0.101	0.1021	149945400.0
2002-08-20 13:00:00	NVDA	Stock	0.1018	0.1021	0.0994	0.1014	161457120.0
2002-08-20 14:00:00	NVDA	Stock	0.1014	0.1029	0.1003	0.1022	119539080.0
2002-08-20 15:00:00	NVDA	Stock	0.1023	0.1031	0.1	0.1008	198945720.0
2002-08-20 16:00:00	NVDA	Stock	0.1008	0.1009	0.1004	0.1008	14531520.0
2002-08-20 17:00:00	NVDA	Stock	0.1007	0.1011	0.1007	0.1007	2503200.0
2002-08-20 18:00:00	NVDA	Stock	0.1007	0.1011	0.1007	0.1011	1729200.0
2002-08-20 08:00:00	AMZN	Stock	0.7725	0.7725	0.7725	0.7725	11280.0
2002-08-20 09:00:00	AMZN	Stock	0.77	0.775	0.7655	0.774	11840860.0
2002-08-20 10:00:00	AMZN	Stock	0.774	0.7835	0.77	0.7825	44415200.0
2002-08-20 11:00:00	AMZN	Stock	0.7825	0.796	0.782	0.796	25370040.0
2002-08-20 12:00:00	AMZN	Stock	0.795	0.7995	0.792	0.796	20477180.0
2002-08-20 13:00:00	AMZN	Stock	0.797	0.7975	0.7855	0.7925	12935520.0
2002-08-20 14:00:00	AMZN	Stock	0.7925	0.7975	0.785	0.7955	11697320.0
2002-08-20 15:00:00	AMZN	Stock	0.796	0.798	0.7885	0.7955	21118460.0
2002-08-20 16:00:00	AMZN	Stock	0.795	0.799	0.7915	0.7955	4206320.0
2002-08-20 17:00:00	AMZN	Stock	0.7915	0.796	0.7915	0.796	364320.0
2002-08-20 18:00:00	AMZN	Stock	0.796	0.796	0.7955	0.7955	388000.0
2002-08-20 09:00:00	CL	Stock	27.325	27.325	27.1	27.155	270400.0
2002-08-20 10:00:00	CL	Stock	27.15	27.265	27.1	27.17	424600.0
2002-08-20 11:00:00	CL	Stock	27.17	27.225	27.025	27.045	393800.0
2002-08-20 12:00:00	CL	Stock	27.015	27.2	27.015	27.115	381600.0
2002-08-20 13:00:00	CL	Stock	27.115	27.15	26.925	27.15	444800.0
2002-08-20 14:00:00	CL	Stock	27.175	27.245	27.1	27.235	352200.0

> showing 50 of 18,644 rows — these rows as CSV

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