PREVIEW / stock_1hour / 2002-11-01

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-11-01.parquet
  size:    421 KB
  rows:    19,875
  symbols: 1,491

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-11-01 08:00:00	AAPL	Stock	0.287	0.287	0.287	0.287	403200.0
2002-11-01 09:00:00	AAPL	Stock	0.2861	0.287	0.2839	0.2866	19318320.0
2002-11-01 10:00:00	AAPL	Stock	0.2861	0.2929	0.2838	0.2921	47336072.0
2002-11-01 11:00:00	AAPL	Stock	0.2923	0.2945	0.2913	0.2934	23692368.0
2002-11-01 12:00:00	AAPL	Stock	0.2932	0.2946	0.2929	0.2936	16065672.0
2002-11-01 13:00:00	AAPL	Stock	0.2936	0.2946	0.2913	0.2929	12704832.0
2002-11-01 14:00:00	AAPL	Stock	0.2929	0.2938	0.2907	0.2923	18360608.0
2002-11-01 15:00:00	AAPL	Stock	0.2923	0.2946	0.292	0.2921	31344432.0
2002-11-01 16:00:00	AAPL	Stock	0.2921	0.2932	0.2911	0.2925	6260800.0
2002-11-01 17:00:00	AAPL	Stock	0.2946	0.2946	0.2921	0.2921	145600.0
2002-11-01 08:00:00	MSFT	Stock	26.15	26.74	25.63	26.13	848228.0
2002-11-01 09:00:00	MSFT	Stock	26.14	26.7	26.05	26.19	11576510.0
2002-11-01 10:00:00	MSFT	Stock	26.185	26.35	25.95	26.27	20941608.0
2002-11-01 11:00:00	MSFT	Stock	26.27	26.475	26.22	26.29	11007322.0
2002-11-01 12:00:00	MSFT	Stock	26.29	26.425	26.235	26.3445	8381524.0
2002-11-01 13:00:00	MSFT	Stock	26.335	26.375	26.125	26.195	6657586.0
2002-11-01 14:00:00	MSFT	Stock	26.2	26.3	26.075	26.175	8806216.0
2002-11-01 15:00:00	MSFT	Stock	26.1755	26.62	26.15	26.505	17407160.0
2002-11-01 16:00:00	MSFT	Stock	26.505	28.0	26.5	27.755	8066298.0
2002-11-01 17:00:00	MSFT	Stock	27.765	28.59	26.3872	28.135	2862614.0
2002-11-01 18:00:00	MSFT	Stock	28.135	28.175	27.99	28.165	290004.0
2002-11-01 08:00:00	NVDA	Stock	0.0983	0.0992	0.0979	0.0983	2808000.0
2002-11-01 09:00:00	NVDA	Stock	0.0983	0.1042	0.0974	0.1029	239786160.0
2002-11-01 10:00:00	NVDA	Stock	0.103	0.1079	0.1028	0.1076	406629600.0
2002-11-01 11:00:00	NVDA	Stock	0.1075	0.1079	0.1056	0.1078	171791280.0
2002-11-01 12:00:00	NVDA	Stock	0.1078	0.1102	0.1067	0.1095	201299400.0
2002-11-01 13:00:00	NVDA	Stock	0.1097	0.1098	0.1078	0.1087	112054800.0
2002-11-01 14:00:00	NVDA	Stock	0.1087	0.1127	0.1085	0.1122	169527960.0
2002-11-01 15:00:00	NVDA	Stock	0.1122	0.1189	0.1119	0.1173	511879080.0
2002-11-01 16:00:00	NVDA	Stock	0.1173	0.1208	0.1164	0.12	48972600.0
2002-11-01 17:00:00	NVDA	Stock	0.1196	0.1208	0.1196	0.1208	2996400.0
2002-11-01 18:00:00	NVDA	Stock	0.1208	0.1208	0.1201	0.1206	1134000.0
2002-11-01 08:00:00	AMZN	Stock	0.9615	0.968	0.955	0.965	331360.0
2002-11-01 09:00:00	AMZN	Stock	0.9625	0.966	0.9575	0.9575	9456520.0
2002-11-01 10:00:00	AMZN	Stock	0.9575	0.975	0.9545	0.975	18703180.0
2002-11-01 11:00:00	AMZN	Stock	0.975	0.986	0.9745	0.983	18914360.0
2002-11-01 12:00:00	AMZN	Stock	0.983	0.9855	0.98	0.9822	10495260.0
2002-11-01 13:00:00	AMZN	Stock	0.982	0.984	0.9785	0.979	7153060.0
2002-11-01 14:00:00	AMZN	Stock	0.9785	0.986	0.9785	0.9835	8149840.0
2002-11-01 15:00:00	AMZN	Stock	0.984	0.995	0.984	0.99	22152520.0
2002-11-01 16:00:00	AMZN	Stock	0.9895	0.9995	0.989	0.9995	1455300.0
2002-11-01 17:00:00	AMZN	Stock	0.995	1.0	0.99	0.9955	374400.0
2002-11-01 18:00:00	AMZN	Stock	0.9955	0.9955	0.9955	0.9955	11000.0
2002-11-01 09:00:00	CL	Stock	27.615	27.615	27.3	27.3	261800.0
2002-11-01 10:00:00	CL	Stock	27.3	27.37	27.07	27.305	655000.0
2002-11-01 11:00:00	CL	Stock	27.275	27.375	27.2	27.22	437200.0
2002-11-01 12:00:00	CL	Stock	27.22	27.345	27.135	27.29	324800.0
2002-11-01 13:00:00	CL	Stock	27.29	27.29	27.16	27.275	527600.0
2002-11-01 14:00:00	CL	Stock	27.275	27.295	27.145	27.165	551200.0
2002-11-01 15:00:00	CL	Stock	27.18	27.555	27.18	27.5	879200.0

> showing 50 of 19,875 rows — these rows as CSV

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