PREVIEW / stock_1hour / 2001-10-19

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-10-19.parquet
  size:    355 KB
  rows:    17,132
  symbols: 1,329

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
2001-10-19 08:00:00	AAPL	Stock	0.3204	0.3216	0.3204	0.3216	257600.0
2001-10-19 09:00:00	AAPL	Stock	0.3196	0.3252	0.3196	0.3214	24645600.0
2001-10-19 10:00:00	AAPL	Stock	0.3214	0.3229	0.3196	0.3218	24791200.0
2001-10-19 11:00:00	AAPL	Stock	0.3218	0.3218	0.3193	0.3207	24264800.0
2001-10-19 12:00:00	AAPL	Stock	0.3209	0.3217	0.3198	0.32	11502400.0
2001-10-19 13:00:00	AAPL	Stock	0.3198	0.3234	0.3198	0.3221	14347200.0
2001-10-19 14:00:00	AAPL	Stock	0.3221	0.3275	0.3221	0.3234	19168800.0
2001-10-19 15:00:00	AAPL	Stock	0.3234	0.3286	0.322	0.3266	32317600.0
2001-10-19 16:00:00	AAPL	Stock	0.3268	0.3268	0.3238	0.3268	2536800.0
2001-10-19 17:00:00	AAPL	Stock	0.3263	0.3266	0.3263	0.3266	218400.0
2001-10-19 08:00:00	MSFT	Stock	28.325	28.8	28.175	28.775	1215410.0
2001-10-19 09:00:00	MSFT	Stock	28.775	28.8	28.335	28.4	17540400.0
2001-10-19 10:00:00	MSFT	Stock	28.4	28.415	28.11	28.26	16460000.0
2001-10-19 11:00:00	MSFT	Stock	28.25	28.315	27.815	27.825	8425200.0
2001-10-19 12:00:00	MSFT	Stock	27.835	28.1	27.815	27.955	5581000.0
2001-10-19 13:00:00	MSFT	Stock	27.9605	28.2255	27.925	28.135	7358600.0
2001-10-19 14:00:00	MSFT	Stock	28.1055	28.475	28.05	28.26	9154000.0
2001-10-19 15:00:00	MSFT	Stock	28.255	29.005	28.22	28.955	18404600.0
2001-10-19 16:00:00	MSFT	Stock	28.955	29.025	28.2985	28.945	2424000.0
2001-10-19 17:00:00	MSFT	Stock	28.965	28.995	28.92	28.95	17400.0
2001-10-19 18:00:00	MSFT	Stock	28.95	29.0	28.95	28.95	11000.0
2001-10-19 08:00:00	NVDA	Stock	0.3543	0.3622	0.3543	0.3583	624000.0
2001-10-19 09:00:00	NVDA	Stock	0.3583	0.3646	0.3525	0.3601	135120000.0
2001-10-19 10:00:00	NVDA	Stock	0.3601	0.3675	0.3579	0.3662	224100000.0
2001-10-19 11:00:00	NVDA	Stock	0.3663	0.369	0.3575	0.3577	150900000.0
2001-10-19 12:00:00	NVDA	Stock	0.3577	0.3625	0.3575	0.3618	60900000.0
2001-10-19 13:00:00	NVDA	Stock	0.3615	0.3682	0.3602	0.3662	93372000.0
2001-10-19 14:00:00	NVDA	Stock	0.3666	0.3718	0.3653	0.3685	127032000.0
2001-10-19 15:00:00	NVDA	Stock	0.3682	0.375	0.3667	0.3697	181524000.0
2001-10-19 16:00:00	NVDA	Stock	0.3697	0.3733	0.3647	0.3697	42432000.0
2001-10-19 17:00:00	NVDA	Stock	0.3697	0.3699	0.3691	0.3698	228000.0
2001-10-19 18:00:00	NVDA	Stock	0.3692	0.3692	0.3692	0.3692	60000.0
2001-10-19 08:00:00	AMZN	Stock	0.413	0.4235	0.408	0.4225	304000.0
2001-10-19 09:00:00	AMZN	Stock	0.42	0.426	0.4025	0.403	16438000.0
2001-10-19 10:00:00	AMZN	Stock	0.403	0.404	0.375	0.385	35818000.0
2001-10-19 11:00:00	AMZN	Stock	0.385	0.3885	0.38	0.3855	14078000.0
2001-10-19 12:00:00	AMZN	Stock	0.3865	0.395	0.385	0.3895	8704000.0
2001-10-19 13:00:00	AMZN	Stock	0.3895	0.403	0.3875	0.4025	13984000.0
2001-10-19 14:00:00	AMZN	Stock	0.4025	0.41	0.397	0.404	13540000.0
2001-10-19 15:00:00	AMZN	Stock	0.404	0.4075	0.4	0.401	20556000.0
2001-10-19 16:00:00	AMZN	Stock	0.401	0.4075	0.398	0.4005	6316000.0
2001-10-19 17:00:00	AMZN	Stock	0.405	0.405	0.4035	0.4035	22000.0
2001-10-19 18:00:00	AMZN	Stock	0.4045	0.4045	0.402	0.402	20000.0
2001-10-19 09:00:00	CL	Stock	28.805	29.045	28.75	29.035	338400.0
2001-10-19 10:00:00	CL	Stock	29.025	29.145	28.92	29.03	442800.0
2001-10-19 11:00:00	CL	Stock	29.03	29.03	28.75	28.795	317400.0
2001-10-19 12:00:00	CL	Stock	28.8	29.06	28.8	28.89	324200.0
2001-10-19 13:00:00	CL	Stock	28.9	28.99	28.825	28.935	216800.0
2001-10-19 14:00:00	CL	Stock	28.93	29.165	28.93	29.04	892000.0
2001-10-19 15:00:00	CL	Stock	29.04	29.125	29.0	29.08	837600.0

> showing 50 of 17,132 rows — these rows as CSV

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