PREVIEW / stock_1hour / 2002-08-21

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-08-21.parquet
  size:    389 KB
  rows:    18,567
  symbols: 1,463

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-21 09:00:00	AAPL	Stock	0.2843	0.29	0.2816	0.2823	33084520.0
2002-08-21 10:00:00	AAPL	Stock	0.2823	0.2845	0.2802	0.2813	34076840.0
2002-08-21 11:00:00	AAPL	Stock	0.2813	0.283	0.2802	0.2827	14689192.0
2002-08-21 12:00:00	AAPL	Stock	0.2827	0.2866	0.2827	0.2862	29525272.0
2002-08-21 13:00:00	AAPL	Stock	0.2859	0.288	0.285	0.2873	21866096.0
2002-08-21 14:00:00	AAPL	Stock	0.287	0.2889	0.283	0.2854	29488256.0
2002-08-21 15:00:00	AAPL	Stock	0.2852	0.2884	0.283	0.288	30256128.0
2002-08-21 16:00:00	AAPL	Stock	0.288	0.2886	0.2871	0.2879	3572408.0
2002-08-21 17:00:00	AAPL	Stock	0.2875	0.2879	0.2875	0.2879	1411200.0
2002-08-21 08:00:00	MSFT	Stock	25.645	25.825	25.5225	25.73	97780.0
2002-08-21 09:00:00	MSFT	Stock	25.75	26.095	25.675	25.96	12088180.0
2002-08-21 10:00:00	MSFT	Stock	25.96	26.015	25.575	25.675	14469220.0
2002-08-21 11:00:00	MSFT	Stock	25.675	25.915	25.575	25.85	10435772.0
2002-08-21 12:00:00	MSFT	Stock	25.85	26.095	25.845	25.99	7407544.0
2002-08-21 13:00:00	MSFT	Stock	25.9905	26.07	25.835	26.015	6919252.0
2002-08-21 14:00:00	MSFT	Stock	26.014	26.19	25.7	25.76	12920154.0
2002-08-21 15:00:00	MSFT	Stock	25.765	26.15	25.6885	26.13	14836384.0
2002-08-21 16:00:00	MSFT	Stock	26.13	26.255	26.085	26.25	1235354.0
2002-08-21 17:00:00	MSFT	Stock	26.234	26.234	26.14	26.185	234226.0
2002-08-21 18:00:00	MSFT	Stock	26.2	26.2	26.165	26.17	12200.0
2002-08-21 08:00:00	NVDA	Stock	0.1021	0.1045	0.1005	0.104	29210520.0
2002-08-21 09:00:00	NVDA	Stock	0.1038	0.1058	0.1027	0.1039	239481000.0
2002-08-21 10:00:00	NVDA	Stock	0.104	0.1042	0.1004	0.1023	222997920.0
2002-08-21 11:00:00	NVDA	Stock	0.1023	0.1039	0.1017	0.1034	104106840.0
2002-08-21 12:00:00	NVDA	Stock	0.1034	0.1054	0.1034	0.1051	120740040.0
2002-08-21 13:00:00	NVDA	Stock	0.1051	0.1067	0.1045	0.1062	84455640.0
2002-08-21 14:00:00	NVDA	Stock	0.1061	0.1074	0.1026	0.1037	184812480.0
2002-08-21 15:00:00	NVDA	Stock	0.1038	0.1062	0.1033	0.1062	171630600.0
2002-08-21 16:00:00	NVDA	Stock	0.1062	0.1071	0.1055	0.1064	32020200.0
2002-08-21 17:00:00	NVDA	Stock	0.1067	0.1069	0.1061	0.1068	3086400.0
2002-08-21 18:00:00	NVDA	Stock	0.1069	0.1071	0.1066	0.1066	903600.0
2002-08-21 08:00:00	AMZN	Stock	0.805	0.805	0.795	0.798	400600.0
2002-08-21 09:00:00	AMZN	Stock	0.798	0.8	0.782	0.789	15000300.0
2002-08-21 10:00:00	AMZN	Stock	0.7895	0.7905	0.7645	0.7785	20808820.0
2002-08-21 11:00:00	AMZN	Stock	0.7785	0.7822	0.764	0.7685	22556020.0
2002-08-21 12:00:00	AMZN	Stock	0.7695	0.7775	0.766	0.77	16629000.0
2002-08-21 13:00:00	AMZN	Stock	0.771	0.779	0.766	0.7755	21998980.0
2002-08-21 14:00:00	AMZN	Stock	0.7775	0.779	0.76	0.766	17941480.0
2002-08-21 15:00:00	AMZN	Stock	0.767	0.7725	0.7625	0.77	15630560.0
2002-08-21 16:00:00	AMZN	Stock	0.77	0.772	0.767	0.769	2332000.0
2002-08-21 17:00:00	AMZN	Stock	0.7715	0.7715	0.769	0.7715	328000.0
2002-08-21 18:00:00	AMZN	Stock	0.77	0.77	0.77	0.77	20000.0
2002-08-21 09:00:00	CL	Stock	27.2	27.4	27.2	27.375	199200.0
2002-08-21 10:00:00	CL	Stock	27.375	27.4	27.21	27.215	390800.0
2002-08-21 11:00:00	CL	Stock	27.215	27.4	27.215	27.375	349200.0
2002-08-21 12:00:00	CL	Stock	27.37	27.41	27.245	27.305	181800.0
2002-08-21 13:00:00	CL	Stock	27.305	27.375	27.225	27.325	195000.0
2002-08-21 14:00:00	CL	Stock	27.365	27.445	27.175	27.23	319800.0
2002-08-21 15:00:00	CL	Stock	27.23	27.375	27.14	27.355	476200.0
2002-08-21 16:00:00	CL	Stock	27.355	27.355	27.35	27.355	43800.0

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

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