PREVIEW / stock_1hour / 2002-07-19

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-07-19.parquet
  size:    391 KB
  rows:    19,026
  symbols: 1,452

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-07-19 08:00:00	AAPL	Stock	0.2675	0.2675	0.2632	0.2632	173600.0
2002-07-19 09:00:00	AAPL	Stock	0.2629	0.2663	0.2595	0.2643	64243200.0
2002-07-19 10:00:00	AAPL	Stock	0.2643	0.2709	0.2634	0.2666	63632800.0
2002-07-19 11:00:00	AAPL	Stock	0.2661	0.2693	0.2652	0.2677	27333600.0
2002-07-19 12:00:00	AAPL	Stock	0.2677	0.2695	0.2663	0.2673	42599200.0
2002-07-19 13:00:00	AAPL	Stock	0.2671	0.2695	0.266	0.2673	40992000.0
2002-07-19 14:00:00	AAPL	Stock	0.2675	0.2686	0.2664	0.2675	52091200.0
2002-07-19 15:00:00	AAPL	Stock	0.2675	0.2684	0.2654	0.2671	65604000.0
2002-07-19 16:00:00	AAPL	Stock	0.2671	0.2675	0.2661	0.2671	8159200.0
2002-07-19 17:00:00	AAPL	Stock	0.2687	0.2688	0.2664	0.2664	112000.0
2002-07-19 08:00:00	MSFT	Stock	25.25	25.555	25.015	25.275	1391000.0
2002-07-19 09:00:00	MSFT	Stock	25.25	25.515	24.875	25.1385	20884200.0
2002-07-19 10:00:00	MSFT	Stock	25.148	25.445	25.0525	25.235	17792200.0
2002-07-19 11:00:00	MSFT	Stock	25.235	25.28	24.9	24.985	11127400.0
2002-07-19 12:00:00	MSFT	Stock	24.975	25.095	24.935	24.95	8171800.0
2002-07-19 13:00:00	MSFT	Stock	24.95	25.145	24.825	24.985	8959800.0
2002-07-19 14:00:00	MSFT	Stock	24.98	25.121	24.925	25.085	8643600.0
2002-07-19 15:00:00	MSFT	Stock	25.085	25.085	24.406	24.7775	24654800.0
2002-07-19 16:00:00	MSFT	Stock	24.79	25.0	24.65	24.9516	5410200.0
2002-07-19 17:00:00	MSFT	Stock	24.65	24.79	24.605	24.645	547800.0
2002-07-19 18:00:00	MSFT	Stock	24.65	24.78	24.605	24.78	29000.0
2002-07-19 08:00:00	NVDA	Stock	0.1567	0.1567	0.1542	0.1548	2076000.0
2002-07-19 09:00:00	NVDA	Stock	0.1582	0.1582	0.1517	0.1562	130704000.0
2002-07-19 10:00:00	NVDA	Stock	0.1562	0.1595	0.1543	0.1559	184968000.0
2002-07-19 11:00:00	NVDA	Stock	0.1559	0.1567	0.1542	0.1554	68868000.0
2002-07-19 12:00:00	NVDA	Stock	0.1554	0.1567	0.1546	0.1558	72528000.0
2002-07-19 13:00:00	NVDA	Stock	0.1558	0.1562	0.1517	0.1517	106248000.0
2002-07-19 14:00:00	NVDA	Stock	0.1517	0.1563	0.1513	0.156	99912000.0
2002-07-19 15:00:00	NVDA	Stock	0.156	0.1562	0.15	0.1512	126168000.0
2002-07-19 16:00:00	NVDA	Stock	0.1511	0.1517	0.15	0.15	13356000.0
2002-07-19 17:00:00	NVDA	Stock	0.1502	0.1511	0.1502	0.1509	156000.0
2002-07-19 18:00:00	NVDA	Stock	0.1505	0.1505	0.1493	0.1493	348000.0
2002-07-19 08:00:00	AMZN	Stock	0.77	0.7765	0.77	0.7765	32000.0
2002-07-19 09:00:00	AMZN	Stock	0.772	0.772	0.7545	0.761	23230000.0
2002-07-19 10:00:00	AMZN	Stock	0.7615	0.7859	0.759	0.778	26342000.0
2002-07-19 11:00:00	AMZN	Stock	0.7775	0.782	0.7575	0.763	12022000.0
2002-07-19 12:00:00	AMZN	Stock	0.7625	0.765	0.756	0.7565	11790000.0
2002-07-19 13:00:00	AMZN	Stock	0.7565	0.773	0.7535	0.768	15130000.0
2002-07-19 14:00:00	AMZN	Stock	0.768	0.772	0.759	0.768	13576000.0
2002-07-19 15:00:00	AMZN	Stock	0.7685	0.7685	0.758	0.7636	12884000.0
2002-07-19 16:00:00	AMZN	Stock	0.765	0.771	0.76	0.766	4196000.0
2002-07-19 17:00:00	AMZN	Stock	0.766	0.7675	0.7645	0.7645	34000.0
2002-07-19 18:00:00	AMZN	Stock	0.7675	0.7675	0.7645	0.7645	26000.0
2002-07-19 09:00:00	CL	Stock	22.5	22.74	22.5	22.64	1065800.0
2002-07-19 10:00:00	CL	Stock	22.63	22.825	22.255	22.26	978400.0
2002-07-19 11:00:00	CL	Stock	22.255	22.4	22.135	22.38	718600.0
2002-07-19 12:00:00	CL	Stock	22.38	22.6	22.35	22.35	513000.0
2002-07-19 13:00:00	CL	Stock	22.35	22.525	22.2	22.35	475600.0
2002-07-19 14:00:00	CL	Stock	22.35	22.355	22.025	22.34	883200.0
2002-07-19 15:00:00	CL	Stock	22.325	22.475	22.17	22.175	1407200.0

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

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