PREVIEW / stock_1hour / 2002-11-04

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-11-04.parquet
  size:    423 KB
  rows:    20,263
  symbols: 1,513

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-04 08:00:00	AAPL	Stock	0.2959	0.2964	0.2946	0.295	210000.0
2002-11-04 09:00:00	AAPL	Stock	0.2964	0.3013	0.292	0.3004	41483064.0
2002-11-04 10:00:00	AAPL	Stock	0.3007	0.3048	0.3004	0.3032	47749912.0
2002-11-04 11:00:00	AAPL	Stock	0.3032	0.3048	0.3018	0.3041	25758320.0
2002-11-04 12:00:00	AAPL	Stock	0.3039	0.3088	0.3038	0.3079	24211768.0
2002-11-04 13:00:00	AAPL	Stock	0.3079	0.3104	0.3063	0.3063	51689008.0
2002-11-04 14:00:00	AAPL	Stock	0.3064	0.3079	0.3038	0.3041	56806456.0
2002-11-04 15:00:00	AAPL	Stock	0.3043	0.3046	0.2975	0.3011	78710464.0
2002-11-04 16:00:00	AAPL	Stock	0.3014	0.302	0.2996	0.3016	7212800.0
2002-11-04 17:00:00	AAPL	Stock	0.3016	0.3016	0.3016	0.3016	1528800.0
2002-11-04 08:00:00	MSFT	Stock	28.5	28.645	28.005	28.47	5208018.0
2002-11-04 09:00:00	MSFT	Stock	28.6	28.6	28.295	28.39	29364830.0
2002-11-04 10:00:00	MSFT	Stock	28.39	28.625	28.39	28.48	25620546.0
2002-11-04 11:00:00	MSFT	Stock	28.485	28.5	28.3	28.335	13273678.0
2002-11-04 12:00:00	MSFT	Stock	28.34	28.49	28.335	28.435	8449408.0
2002-11-04 13:00:00	MSFT	Stock	28.4305	28.455	28.215	28.215	8330312.0
2002-11-04 14:00:00	MSFT	Stock	28.216	28.495	28.155	28.36	12690486.0
2002-11-04 15:00:00	MSFT	Stock	28.335	28.355	27.76	28.05	22906916.0
2002-11-04 16:00:00	MSFT	Stock	28.035	28.125	27.9162	28.025	1915256.0
2002-11-04 17:00:00	MSFT	Stock	28.025	28.3392	27.855	28.02	467700.0
2002-11-04 18:00:00	MSFT	Stock	28.035	28.055	28.0	28.025	13400.0
2002-11-04 08:00:00	NVDA	Stock	0.1229	0.1275	0.1229	0.1267	13500360.0
2002-11-04 09:00:00	NVDA	Stock	0.1267	0.1308	0.1233	0.1307	492862920.0
2002-11-04 10:00:00	NVDA	Stock	0.1306	0.1376	0.1304	0.1356	643483320.0
2002-11-04 11:00:00	NVDA	Stock	0.1357	0.1361	0.1333	0.1337	283387320.0
2002-11-04 12:00:00	NVDA	Stock	0.1337	0.1362	0.1337	0.1352	197212200.0
2002-11-04 13:00:00	NVDA	Stock	0.1353	0.136	0.1342	0.1355	158879640.0
2002-11-04 14:00:00	NVDA	Stock	0.1356	0.1374	0.1347	0.1357	170175720.0
2002-11-04 15:00:00	NVDA	Stock	0.1357	0.1358	0.1293	0.1302	454959000.0
2002-11-04 16:00:00	NVDA	Stock	0.13	0.1325	0.1297	0.131	41457600.0
2002-11-04 17:00:00	NVDA	Stock	0.131	0.1312	0.1302	0.1312	3000000.0
2002-11-04 18:00:00	NVDA	Stock	0.1312	0.1317	0.1311	0.1317	48000.0
2002-11-04 08:00:00	AMZN	Stock	0.97	0.993	0.95	0.9675	1708840.0
2002-11-04 09:00:00	AMZN	Stock	0.9685	0.99	0.9425	0.9785	55993400.0
2002-11-04 10:00:00	AMZN	Stock	0.98	0.99	0.9715	0.974	37509620.0
2002-11-04 11:00:00	AMZN	Stock	0.9745	0.98	0.9725	0.9755	20203420.0
2002-11-04 12:00:00	AMZN	Stock	0.9755	0.987	0.9745	0.9805	20625960.0
2002-11-04 13:00:00	AMZN	Stock	0.9805	0.9821	0.9595	0.96	26150720.0
2002-11-04 14:00:00	AMZN	Stock	0.96	0.967	0.9475	0.948	29848260.0
2002-11-04 15:00:00	AMZN	Stock	0.948	0.9523	0.9295	0.9385	49415760.0
2002-11-04 16:00:00	AMZN	Stock	0.939	0.945	0.9335	0.94	1760920.0
2002-11-04 17:00:00	AMZN	Stock	0.939	0.9405	0.9375	0.9375	321000.0
2002-11-04 18:00:00	AMZN	Stock	0.94	0.94	0.9375	0.9375	20000.0
2002-11-04 09:00:00	CL	Stock	27.45	27.505	27.175	27.18	361400.0
2002-11-04 10:00:00	CL	Stock	27.2	27.275	26.925	26.925	740400.0
2002-11-04 11:00:00	CL	Stock	26.925	26.945	26.7	26.905	916400.0
2002-11-04 12:00:00	CL	Stock	26.895	26.975	26.8	26.85	502200.0
2002-11-04 13:00:00	CL	Stock	26.85	26.855	26.74	26.755	457800.0
2002-11-04 14:00:00	CL	Stock	26.755	26.755	26.57	26.67	767600.0
2002-11-04 15:00:00	CL	Stock	26.665	26.675	26.55	26.645	1020200.0

> showing 50 of 20,263 rows — these rows as CSV

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