PREVIEW / stock_1hour / 2002-12-27

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-12-27.parquet
  size:    408 KB
  rows:    19,730
  symbols: 1,538

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-12-27 09:00:00	AAPL	Stock	0.2571	0.2571	0.2539	0.2552	10922408.0
2002-12-27 10:00:00	AAPL	Stock	0.255	0.2559	0.2527	0.2529	11125800.0
2002-12-27 11:00:00	AAPL	Stock	0.2527	0.2537	0.252	0.2529	6110720.0
2002-12-27 12:00:00	AAPL	Stock	0.2529	0.2545	0.2523	0.2539	5630744.0
2002-12-27 13:00:00	AAPL	Stock	0.2539	0.2539	0.252	0.2521	4942672.0
2002-12-27 14:00:00	AAPL	Stock	0.252	0.2527	0.2509	0.2518	9734032.0
2002-12-27 15:00:00	AAPL	Stock	0.2516	0.252	0.2502	0.2518	19309248.0
2002-12-27 16:00:00	AAPL	Stock	0.2518	0.2518	0.2504	0.2509	4271904.0
2002-12-27 17:00:00	AAPL	Stock	0.2511	0.2511	0.2511	0.2511	44800.0
2002-12-27 08:00:00	MSFT	Stock	26.7	26.7505	26.65	26.65	118140.0
2002-12-27 09:00:00	MSFT	Stock	26.65	26.95	26.605	26.915	5969238.0
2002-12-27 10:00:00	MSFT	Stock	26.915	27.0	26.7025	26.7105	7314002.0
2002-12-27 11:00:00	MSFT	Stock	26.71	26.75	26.64	26.6755	3426082.0
2002-12-27 12:00:00	MSFT	Stock	26.675	26.75	26.61	26.7155	3209498.0
2002-12-27 13:00:00	MSFT	Stock	26.72	26.72	26.585	26.62	3261410.0
2002-12-27 14:00:00	MSFT	Stock	26.6155	26.705	26.56	26.595	4786030.0
2002-12-27 15:00:00	MSFT	Stock	26.59	26.615	26.45	26.485	7152370.0
2002-12-27 16:00:00	MSFT	Stock	26.48	26.54	26.305	26.395	1013050.0
2002-12-27 17:00:00	MSFT	Stock	26.36	26.485	26.36	26.43	44000.0
2002-12-27 18:00:00	MSFT	Stock	26.425	26.43	26.425	26.43	5000.0
2002-12-27 08:00:00	NVDA	Stock	0.105	0.113	0.1041	0.1041	1992000.0
2002-12-27 09:00:00	NVDA	Stock	0.1038	0.1063	0.1017	0.1022	87062520.0
2002-12-27 10:00:00	NVDA	Stock	0.1022	0.1037	0.1011	0.1011	111238440.0
2002-12-27 11:00:00	NVDA	Stock	0.1011	0.1017	0.1007	0.1011	59161320.0
2002-12-27 12:00:00	NVDA	Stock	0.1011	0.1016	0.1006	0.1011	56984520.0
2002-12-27 13:00:00	NVDA	Stock	0.1011	0.1012	0.0993	0.0994	97626960.0
2002-12-27 14:00:00	NVDA	Stock	0.0994	0.0999	0.099	0.0992	83668680.0
2002-12-27 15:00:00	NVDA	Stock	0.0991	0.1	0.0987	0.0996	124356120.0
2002-12-27 16:00:00	NVDA	Stock	0.0997	0.1001	0.0994	0.1	7861920.0
2002-12-27 17:00:00	NVDA	Stock	0.1	0.1003	0.0996	0.1	892800.0
2002-12-27 18:00:00	NVDA	Stock	0.1	0.1	0.0998	0.0998	190200.0
2002-12-27 08:00:00	AMZN	Stock	1.0055	1.0055	0.9975	1.0	283720.0
2002-12-27 09:00:00	AMZN	Stock	0.9995	1.013	0.9835	0.9875	43393420.0
2002-12-27 10:00:00	AMZN	Stock	0.9875	0.991	0.9635	0.9735	59570460.0
2002-12-27 11:00:00	AMZN	Stock	0.9735	0.9735	0.9505	0.953	51285240.0
2002-12-27 12:00:00	AMZN	Stock	0.952	0.9595	0.95	0.955	37276800.0
2002-12-27 13:00:00	AMZN	Stock	0.955	0.9555	0.9265	0.9275	75537680.0
2002-12-27 14:00:00	AMZN	Stock	0.9285	0.9355	0.9215	0.9335	54817520.0
2002-12-27 15:00:00	AMZN	Stock	0.9335	0.9495	0.931	0.9426	64639740.0
2002-12-27 16:00:00	AMZN	Stock	0.943	0.9435	0.9405	0.943	1823300.0
2002-12-27 17:00:00	AMZN	Stock	0.9415	0.943	0.9405	0.9405	122520.0
2002-12-27 18:00:00	AMZN	Stock	0.9425	0.943	0.94	0.94	60000.0
2002-12-27 09:00:00	CL	Stock	26.21	26.25	26.135	26.17	82600.0
2002-12-27 10:00:00	CL	Stock	26.16	26.245	26.09	26.17	202800.0
2002-12-27 11:00:00	CL	Stock	26.17	26.225	26.125	26.225	111800.0
2002-12-27 12:00:00	CL	Stock	26.225	26.27	26.19	26.225	103800.0
2002-12-27 13:00:00	CL	Stock	26.225	26.23	26.09	26.105	146400.0
2002-12-27 14:00:00	CL	Stock	26.105	26.115	26.045	26.05	237200.0
2002-12-27 15:00:00	CL	Stock	26.05	26.14	26.005	26.055	370400.0
2002-12-27 16:00:00	CL	Stock	26.05	26.075	26.05	26.075	46000.0

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

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