PREVIEW / stock_1hour / 2002-10-17

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-10-17.parquet
  size:    420 KB
  rows:    19,907
  symbols: 1,503

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-10-17 08:00:00	AAPL	Stock	0.2538	0.2596	0.25	0.2534	2489368.0
2002-10-17 09:00:00	AAPL	Stock	0.2545	0.2596	0.2503	0.2536	78984360.0
2002-10-17 10:00:00	AAPL	Stock	0.2536	0.2546	0.2511	0.2518	88419072.0
2002-10-17 11:00:00	AAPL	Stock	0.2518	0.2529	0.2509	0.252	50307432.0
2002-10-17 12:00:00	AAPL	Stock	0.2518	0.252	0.25	0.2507	60661328.0
2002-10-17 13:00:00	AAPL	Stock	0.2507	0.2521	0.2505	0.2518	33017992.0
2002-10-17 14:00:00	AAPL	Stock	0.2517	0.2518	0.2496	0.2509	52220168.0
2002-10-17 15:00:00	AAPL	Stock	0.2503	0.2521	0.2503	0.252	74776856.0
2002-10-17 16:00:00	AAPL	Stock	0.2519	0.2555	0.2504	0.2552	11847136.0
2002-10-17 17:00:00	AAPL	Stock	0.2541	0.2555	0.252	0.2552	240800.0
2002-10-17 08:00:00	MSFT	Stock	26.475	26.505	25.9255	26.05	1281062.0
2002-10-17 09:00:00	MSFT	Stock	26.05	26.25	25.54	25.625	19957266.0
2002-10-17 10:00:00	MSFT	Stock	25.625	25.735	25.36	25.675	22122176.0
2002-10-17 11:00:00	MSFT	Stock	25.675	25.795	25.5575	25.63	10747674.0
2002-10-17 12:00:00	MSFT	Stock	25.635	25.8	25.45	25.7	13948112.0
2002-10-17 13:00:00	MSFT	Stock	25.71	25.95	25.67	25.905	8913190.0
2002-10-17 14:00:00	MSFT	Stock	25.91	25.925	25.075	25.3	33454040.0
2002-10-17 15:00:00	MSFT	Stock	25.3	25.597	25.03	25.38	39302596.0
2002-10-17 16:00:00	MSFT	Stock	25.375	27.0	25.0	26.425	24938902.0
2002-10-17 17:00:00	MSFT	Stock	26.425	26.8	25.3855	26.5405	4531866.0
2002-10-17 18:00:00	MSFT	Stock	26.55	26.5978	26.43	26.57	508956.0
2002-10-17 08:00:00	NVDA	Stock	0.0771	0.0792	0.0758	0.0787	6612000.0
2002-10-17 09:00:00	NVDA	Stock	0.0791	0.0804	0.0764	0.0775	126150960.0
2002-10-17 10:00:00	NVDA	Stock	0.0775	0.0792	0.0765	0.0781	120367560.0
2002-10-17 11:00:00	NVDA	Stock	0.078	0.0795	0.0774	0.0776	64909080.0
2002-10-17 12:00:00	NVDA	Stock	0.0777	0.079	0.0771	0.0789	56037240.0
2002-10-17 13:00:00	NVDA	Stock	0.0789	0.0794	0.0786	0.0794	31937640.0
2002-10-17 14:00:00	NVDA	Stock	0.0792	0.0795	0.0779	0.0781	51532800.0
2002-10-17 15:00:00	NVDA	Stock	0.0781	0.0787	0.0776	0.0778	82654440.0
2002-10-17 16:00:00	NVDA	Stock	0.0776	0.0812	0.0774	0.0792	26803200.0
2002-10-17 17:00:00	NVDA	Stock	0.0795	0.0808	0.0775	0.0787	4584600.0
2002-10-17 18:00:00	NVDA	Stock	0.0792	0.0792	0.0787	0.0792	144000.0
2002-10-17 08:00:00	AMZN	Stock	0.9995	1.0125	0.99	1.01	1422000.0
2002-10-17 09:00:00	AMZN	Stock	1.01	1.015	0.9956	1.0075	50017940.0
2002-10-17 10:00:00	AMZN	Stock	1.0075	1.0075	0.9855	0.992	36188340.0
2002-10-17 11:00:00	AMZN	Stock	0.992	1.0	0.9885	0.996	16247460.0
2002-10-17 12:00:00	AMZN	Stock	0.996	0.9975	0.9745	0.9745	34130020.0
2002-10-17 13:00:00	AMZN	Stock	0.9745	0.9785	0.942	0.945	54696540.0
2002-10-17 14:00:00	AMZN	Stock	0.9455	0.9555	0.923	0.9315	34469740.0
2002-10-17 15:00:00	AMZN	Stock	0.9315	0.9395	0.9215	0.937	35401340.0
2002-10-17 16:00:00	AMZN	Stock	0.9365	0.96	0.925	0.955	6470220.0
2002-10-17 17:00:00	AMZN	Stock	0.95	0.958	0.937	0.937	2428000.0
2002-10-17 18:00:00	AMZN	Stock	0.9525	0.9525	0.9525	0.9525	10000.0
2002-10-17 09:00:00	CL	Stock	28.15	28.165	27.77	27.975	913600.0
2002-10-17 10:00:00	CL	Stock	27.985	27.985	27.515	27.725	869800.0
2002-10-17 11:00:00	CL	Stock	27.725	27.925	27.575	27.775	1202200.0
2002-10-17 12:00:00	CL	Stock	27.775	27.81	27.605	27.655	556600.0
2002-10-17 13:00:00	CL	Stock	27.65	27.775	27.63	27.775	232400.0
2002-10-17 14:00:00	CL	Stock	27.775	27.835	27.675	27.835	477800.0
2002-10-17 15:00:00	CL	Stock	27.835	27.96	27.825	27.875	511800.0

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

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