PREVIEW / stock_1hour / 2002-10-21

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-10-21.parquet
  size:    402 KB
  rows:    19,084
  symbols: 1,501

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-21 08:00:00	AAPL	Stock	0.2561	0.2561	0.2561	0.2561	5600.0
2002-10-21 09:00:00	AAPL	Stock	0.2554	0.2563	0.2536	0.2541	15485232.0
2002-10-21 10:00:00	AAPL	Stock	0.2541	0.2545	0.2502	0.2511	41051192.0
2002-10-21 11:00:00	AAPL	Stock	0.2513	0.2532	0.25	0.2518	45978744.0
2002-10-21 12:00:00	AAPL	Stock	0.252	0.2554	0.2518	0.2539	46191936.0
2002-10-21 13:00:00	AAPL	Stock	0.2538	0.2554	0.2534	0.2545	19596752.0
2002-10-21 14:00:00	AAPL	Stock	0.2543	0.2561	0.2539	0.2559	14012936.0
2002-10-21 15:00:00	AAPL	Stock	0.2559	0.2613	0.2557	0.2602	47589080.0
2002-10-21 16:00:00	AAPL	Stock	0.2602	0.2613	0.2591	0.26	3824800.0
2002-10-21 17:00:00	AAPL	Stock	0.2596	0.2596	0.2596	0.2596	28000.0
2002-10-21 18:00:00	AAPL	Stock	0.2563	0.2563	0.2563	0.2563	112000.0
2002-10-21 08:00:00	MSFT	Stock	26.05	26.57	25.87	26.13	284966.0
2002-10-21 09:00:00	MSFT	Stock	26.13	26.57	25.78	25.985	17140524.0
2002-10-21 10:00:00	MSFT	Stock	25.975	25.985	25.68	25.85	19205108.0
2002-10-21 11:00:00	MSFT	Stock	25.85	26.22	25.82	26.135	16477878.0
2002-10-21 12:00:00	MSFT	Stock	26.135	26.46	26.0305	26.34	12868674.0
2002-10-21 13:00:00	MSFT	Stock	26.3375	26.385	26.148	26.335	9700148.0
2002-10-21 14:00:00	MSFT	Stock	26.32	26.495	26.255	26.285	11728268.0
2002-10-21 15:00:00	MSFT	Stock	26.285	26.49	26.135	26.255	20739096.0
2002-10-21 16:00:00	MSFT	Stock	26.255	26.325	25.5	26.0	1412994.0
2002-10-21 17:00:00	MSFT	Stock	26.07	26.255	25.91	25.95	110530.0
2002-10-21 18:00:00	MSFT	Stock	25.95	26.0	25.95	26.0	12060.0
2002-10-21 08:00:00	NVDA	Stock	0.0777	0.0777	0.0777	0.0777	185520.0
2002-10-21 09:00:00	NVDA	Stock	0.0772	0.078	0.0755	0.0772	55726320.0
2002-10-21 10:00:00	NVDA	Stock	0.0772	0.0782	0.0759	0.0778	72939840.0
2002-10-21 11:00:00	NVDA	Stock	0.0777	0.0832	0.0772	0.0826	153976320.0
2002-10-21 12:00:00	NVDA	Stock	0.0825	0.0842	0.0816	0.0832	153598920.0
2002-10-21 13:00:00	NVDA	Stock	0.0833	0.0862	0.0832	0.0852	140037120.0
2002-10-21 14:00:00	NVDA	Stock	0.0852	0.0859	0.0844	0.0857	103868400.0
2002-10-21 15:00:00	NVDA	Stock	0.0858	0.0882	0.085	0.0855	213620880.0
2002-10-21 16:00:00	NVDA	Stock	0.0856	0.0861	0.0827	0.0842	30158400.0
2002-10-21 17:00:00	NVDA	Stock	0.0842	0.0845	0.0817	0.0821	2415600.0
2002-10-21 18:00:00	NVDA	Stock	0.0821	0.0829	0.0814	0.0829	468000.0
2002-10-21 08:00:00	AMZN	Stock	0.9464	0.9464	0.9464	0.9464	10000.0
2002-10-21 09:00:00	AMZN	Stock	0.947	0.959	0.9363	0.958	15272260.0
2002-10-21 10:00:00	AMZN	Stock	0.958	0.959	0.941	0.9495	21023540.0
2002-10-21 11:00:00	AMZN	Stock	0.9495	0.9555	0.9443	0.9555	16543600.0
2002-10-21 12:00:00	AMZN	Stock	0.9555	0.97	0.9515	0.9685	27222420.0
2002-10-21 13:00:00	AMZN	Stock	0.969	0.9765	0.9645	0.9645	19829640.0
2002-10-21 14:00:00	AMZN	Stock	0.9645	0.972	0.958	0.9695	14823920.0
2002-10-21 15:00:00	AMZN	Stock	0.969	0.9725	0.963	0.963	13739600.0
2002-10-21 16:00:00	AMZN	Stock	0.963	0.965	0.958	0.958	3018180.0
2002-10-21 17:00:00	AMZN	Stock	0.963	0.963	0.958	0.958	528000.0
2002-10-21 09:00:00	CL	Stock	28.34	28.34	28.145	28.18	287600.0
2002-10-21 10:00:00	CL	Stock	28.195	28.575	28.175	28.455	702800.0
2002-10-21 11:00:00	CL	Stock	28.475	28.58	28.38	28.55	479800.0
2002-10-21 12:00:00	CL	Stock	28.555	28.725	28.5	28.505	525200.0
2002-10-21 13:00:00	CL	Stock	28.515	28.69	28.495	28.6	403600.0
2002-10-21 14:00:00	CL	Stock	28.6	28.865	28.55	28.805	526600.0
2002-10-21 15:00:00	CL	Stock	28.805	28.995	28.75	28.93	955000.0

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

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