PREVIEW / stock_1hour / 2001-09-19

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-09-19.parquet
  size:    368 KB
  rows:    18,254
  symbols: 1,350

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-09-19 08:00:00	AAPL	Stock	0.2913	0.2916	0.2911	0.2911	151200.0
2001-09-19 09:00:00	AAPL	Stock	0.2916	0.3009	0.2911	0.2982	38315200.0
2001-09-19 10:00:00	AAPL	Stock	0.2982	0.2996	0.2898	0.2914	41277600.0
2001-09-19 11:00:00	AAPL	Stock	0.2918	0.292	0.2839	0.285	58940000.0
2001-09-19 12:00:00	AAPL	Stock	0.2848	0.2871	0.2813	0.2866	42571200.0
2001-09-19 13:00:00	AAPL	Stock	0.2866	0.2875	0.2805	0.2857	38875200.0
2001-09-19 14:00:00	AAPL	Stock	0.285	0.2857	0.2786	0.2836	46295200.0
2001-09-19 15:00:00	AAPL	Stock	0.2838	0.305	0.2821	0.3045	70375200.0
2001-09-19 16:00:00	AAPL	Stock	0.3041	0.3054	0.3016	0.303	11782400.0
2001-09-19 17:00:00	AAPL	Stock	0.303	0.3039	0.303	0.3039	1164800.0
2001-09-19 08:00:00	MSFT	Stock	27.16	27.3	27.16	27.2	21600.0
2001-09-19 09:00:00	MSFT	Stock	27.2	27.56	27.17	27.305	9154400.0
2001-09-19 10:00:00	MSFT	Stock	27.295	27.56	26.875	27.03	18215000.0
2001-09-19 11:00:00	MSFT	Stock	27.0295	27.06	26.18	26.18	18350800.0
2001-09-19 12:00:00	MSFT	Stock	26.18	26.625	26.0	26.56	12964600.0
2001-09-19 13:00:00	MSFT	Stock	26.5655	26.625	26.0	26.225	10860800.0
2001-09-19 14:00:00	MSFT	Stock	26.23	26.335	25.3	25.95	16732800.0
2001-09-19 15:00:00	MSFT	Stock	25.91	27.03	25.7	26.945	31377000.0
2001-09-19 16:00:00	MSFT	Stock	26.94	27.0	25.525	26.935	2913600.0
2001-09-19 17:00:00	MSFT	Stock	26.925	26.945	26.6262	26.94	193400.0
2001-09-19 18:00:00	MSFT	Stock	26.925	26.925	26.925	26.925	200.0
2001-09-19 08:00:00	NVDA	Stock	0.2661	0.2708	0.2661	0.27	528000.0
2001-09-19 09:00:00	NVDA	Stock	0.2687	0.2721	0.2523	0.2575	168408000.0
2001-09-19 10:00:00	NVDA	Stock	0.2575	0.2642	0.2461	0.2513	226524000.0
2001-09-19 11:00:00	NVDA	Stock	0.2512	0.2533	0.2458	0.2496	250380000.0
2001-09-19 12:00:00	NVDA	Stock	0.2496	0.2542	0.2461	0.2479	148200000.0
2001-09-19 13:00:00	NVDA	Stock	0.2479	0.2498	0.2427	0.2457	101232000.0
2001-09-19 14:00:00	NVDA	Stock	0.2454	0.2458	0.2255	0.2341	242532000.0
2001-09-19 15:00:00	NVDA	Stock	0.2341	0.2644	0.2317	0.2628	335076000.0
2001-09-19 16:00:00	NVDA	Stock	0.2629	0.2637	0.2604	0.2604	25428000.0
2001-09-19 17:00:00	NVDA	Stock	0.2628	0.2629	0.2612	0.2623	816000.0
2001-09-19 18:00:00	NVDA	Stock	0.2628	0.2628	0.2612	0.2612	60000.0
2001-09-19 08:00:00	AMZN	Stock	0.364	0.3675	0.364	0.367	1132000.0
2001-09-19 09:00:00	AMZN	Stock	0.3655	0.3725	0.3635	0.3655	9574000.0
2001-09-19 10:00:00	AMZN	Stock	0.3665	0.3725	0.354	0.3565	21258000.0
2001-09-19 11:00:00	AMZN	Stock	0.356	0.3575	0.3425	0.3435	35038000.0
2001-09-19 12:00:00	AMZN	Stock	0.3435	0.3505	0.3425	0.3445	18226000.0
2001-09-19 13:00:00	AMZN	Stock	0.345	0.346	0.3375	0.34	13176000.0
2001-09-19 14:00:00	AMZN	Stock	0.339	0.343	0.3345	0.3405	18942000.0
2001-09-19 15:00:00	AMZN	Stock	0.3405	0.3665	0.3385	0.3655	48800000.0
2001-09-19 16:00:00	AMZN	Stock	0.366	0.3675	0.362	0.3665	3858000.0
2001-09-19 17:00:00	AMZN	Stock	0.3655	0.3655	0.365	0.365	210000.0
2001-09-19 09:00:00	CL	Stock	29.0	29.005	28.925	28.95	678200.0
2001-09-19 10:00:00	CL	Stock	28.965	29.0	28.885	29.0	889400.0
2001-09-19 11:00:00	CL	Stock	29.0	29.0	28.7	28.8	1157600.0
2001-09-19 12:00:00	CL	Stock	28.8	28.945	28.75	28.9	708200.0
2001-09-19 13:00:00	CL	Stock	28.925	29.0	28.885	28.95	646800.0
2001-09-19 14:00:00	CL	Stock	28.955	28.96	28.195	28.525	1144000.0
2001-09-19 15:00:00	CL	Stock	28.505	28.525	28.25	28.425	950400.0
2001-09-19 16:00:00	CL	Stock	28.475	28.475	28.475	28.475	109800.0

> showing 50 of 18,254 rows — these rows as CSV

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