PREVIEW / stock_1hour / 2003-02-27

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-02-27.parquet
  size:    400 KB
  rows:    19,513
  symbols: 1,549

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
2003-02-27 08:00:00	AAPL	Stock	0.2598	0.26	0.2598	0.26	308000.0
2003-02-27 09:00:00	AAPL	Stock	0.26	0.2613	0.2591	0.2605	17084760.0
2003-02-27 10:00:00	AAPL	Stock	0.2605	0.2664	0.2593	0.2663	29213296.0
2003-02-27 11:00:00	AAPL	Stock	0.2663	0.267	0.2646	0.2661	18062296.0
2003-02-27 12:00:00	AAPL	Stock	0.2661	0.2679	0.2651	0.2677	18889752.0
2003-02-27 13:00:00	AAPL	Stock	0.2677	0.2677	0.265	0.267	12115208.0
2003-02-27 14:00:00	AAPL	Stock	0.2668	0.2677	0.2645	0.2655	13203008.0
2003-02-27 15:00:00	AAPL	Stock	0.2655	0.2671	0.2652	0.2655	23292528.0
2003-02-27 16:00:00	AAPL	Stock	0.2655	0.2661	0.2652	0.2654	5672800.0
2003-02-27 08:00:00	MSFT	Stock	23.55	23.96	23.55	23.93	284973.0
2003-02-27 09:00:00	MSFT	Stock	23.91	24.03	23.6	23.7	6145157.0
2003-02-27 10:00:00	MSFT	Stock	23.68	24.179	23.55	24.09	12997154.0
2003-02-27 11:00:00	MSFT	Stock	24.08	24.21	23.81	23.9	7509950.0
2003-02-27 12:00:00	MSFT	Stock	23.9	24.0	23.84	23.91	5124331.0
2003-02-27 13:00:00	MSFT	Stock	23.91	23.923	23.66	23.74	5492996.0
2003-02-27 14:00:00	MSFT	Stock	23.74	23.77	23.3	23.512	12393836.0
2003-02-27 15:00:00	MSFT	Stock	23.51	23.65	23.36	23.59	11629378.0
2003-02-27 16:00:00	MSFT	Stock	23.59	23.7586	23.48	23.49	1440706.0
2003-02-27 17:00:00	MSFT	Stock	23.49	24.63	23.49	23.58	153545.0
2003-02-27 18:00:00	MSFT	Stock	23.57	23.64	23.565	23.62	13120.0
2003-02-27 08:00:00	NVDA	Stock	0.1037	0.1042	0.1033	0.1042	1308000.0
2003-02-27 09:00:00	NVDA	Stock	0.1042	0.1042	0.1019	0.1022	112641000.0
2003-02-27 10:00:00	NVDA	Stock	0.1022	0.1051	0.1019	0.1045	166556040.0
2003-02-27 11:00:00	NVDA	Stock	0.1046	0.1047	0.1037	0.1045	70087680.0
2003-02-27 12:00:00	NVDA	Stock	0.1044	0.105	0.1041	0.1047	39792840.0
2003-02-27 13:00:00	NVDA	Stock	0.1048	0.105	0.1042	0.1049	45372360.0
2003-02-27 14:00:00	NVDA	Stock	0.1049	0.105	0.1032	0.1042	75780480.0
2003-02-27 15:00:00	NVDA	Stock	0.1042	0.1048	0.1041	0.1047	111689040.0
2003-02-27 16:00:00	NVDA	Stock	0.1047	0.1052	0.1046	0.1047	5817960.0
2003-02-27 17:00:00	NVDA	Stock	0.1052	0.1053	0.1049	0.1053	360000.0
2003-02-27 18:00:00	NVDA	Stock	0.1054	0.1054	0.1054	0.1054	12000.0
2003-02-27 08:00:00	AMZN	Stock	1.075	1.0815	1.07	1.078	238000.0
2003-02-27 09:00:00	AMZN	Stock	1.081	1.087	1.056	1.068	15209860.0
2003-02-27 10:00:00	AMZN	Stock	1.067	1.083	1.063	1.0825	16721000.0
2003-02-27 11:00:00	AMZN	Stock	1.082	1.0885	1.07	1.075	14419060.0
2003-02-27 12:00:00	AMZN	Stock	1.0745	1.0805	1.07	1.071	5736420.0
2003-02-27 13:00:00	AMZN	Stock	1.0705	1.075	1.067	1.0745	7620900.0
2003-02-27 14:00:00	AMZN	Stock	1.074	1.079	1.063	1.0675	10055300.0
2003-02-27 15:00:00	AMZN	Stock	1.0675	1.0825	1.0665	1.0815	13625480.0
2003-02-27 16:00:00	AMZN	Stock	1.083	1.0895	1.0795	1.0845	1201680.0
2003-02-27 17:00:00	AMZN	Stock	1.0835	1.0835	1.081	1.0815	46000.0
2003-02-27 18:00:00	AMZN	Stock	1.0845	1.0845	1.0845	1.0845	12000.0
2003-02-27 09:00:00	CL	Stock	25.48	25.49	25.35	25.37	143800.0
2003-02-27 10:00:00	CL	Stock	25.37	25.57	25.285	25.54	432600.0
2003-02-27 11:00:00	CL	Stock	25.55	25.7	25.49	25.53	321400.0
2003-02-27 12:00:00	CL	Stock	25.54	25.605	25.415	25.51	216200.0
2003-02-27 13:00:00	CL	Stock	25.515	25.535	25.405	25.45	199200.0
2003-02-27 14:00:00	CL	Stock	25.435	25.455	25.23	25.27	328200.0
2003-02-27 15:00:00	CL	Stock	25.26	25.45	25.22	25.385	382400.0
2003-02-27 16:00:00	CL	Stock	25.39	25.395	25.39	25.395	51800.0

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

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