PREVIEW / stock_1hour / 2002-07-01

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-07-01.parquet
  size:    428 KB
  rows:    19,830
  symbols: 1,447

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-01 08:00:00	AAPL	Stock	0.3143	0.3164	0.3105	0.3161	1999200.0
2002-07-01 09:00:00	AAPL	Stock	0.3164	0.3193	0.3134	0.3143	24908800.0
2002-07-01 10:00:00	AAPL	Stock	0.3132	0.3157	0.3082	0.3093	24813600.0
2002-07-01 11:00:00	AAPL	Stock	0.3095	0.3104	0.3073	0.3075	24421600.0
2002-07-01 12:00:00	AAPL	Stock	0.3075	0.3105	0.3064	0.3098	18984000.0
2002-07-01 13:00:00	AAPL	Stock	0.31	0.3149	0.3098	0.3113	18911200.0
2002-07-01 14:00:00	AAPL	Stock	0.3113	0.3159	0.3071	0.3071	28280000.0
2002-07-01 15:00:00	AAPL	Stock	0.3073	0.3105	0.3045	0.3048	49112000.0
2002-07-01 16:00:00	AAPL	Stock	0.3046	0.3099	0.3038	0.3046	35778400.0
2002-07-01 17:00:00	AAPL	Stock	0.3046	0.3046	0.3038	0.3038	39200.0
2002-07-01 18:00:00	AAPL	Stock	0.3099	0.3099	0.3046	0.3046	7011200.0
2002-07-01 08:00:00	MSFT	Stock	27.2	27.35	27.0	27.03	170804.0
2002-07-01 09:00:00	MSFT	Stock	27.094	27.32	27.02	27.1	7736400.0
2002-07-01 10:00:00	MSFT	Stock	27.08	27.13	26.725	26.978	10644400.0
2002-07-01 11:00:00	MSFT	Stock	26.98	27.02	26.77	26.79	8137200.0
2002-07-01 12:00:00	MSFT	Stock	26.785	26.82	26.625	26.72	6765000.0
2002-07-01 13:00:00	MSFT	Stock	26.7245	26.99	26.675	26.925	7530600.0
2002-07-01 14:00:00	MSFT	Stock	26.92	27.02	26.685	26.725	7647600.0
2002-07-01 15:00:00	MSFT	Stock	26.725	26.7395	26.29	26.315	13454000.0
2002-07-01 16:00:00	MSFT	Stock	26.33	26.8979	26.25	26.305	2906000.0
2002-07-01 17:00:00	MSFT	Stock	26.275	26.34	26.2	26.2	66000.0
2002-07-01 18:00:00	MSFT	Stock	26.8241	26.8241	26.244	26.244	162600.0
2002-07-01 08:00:00	NVDA	Stock	0.1475	0.1475	0.1433	0.1433	1380000.0
2002-07-01 09:00:00	NVDA	Stock	0.1433	0.1467	0.1398	0.1448	167016000.0
2002-07-01 10:00:00	NVDA	Stock	0.1448	0.1453	0.1405	0.1428	155256000.0
2002-07-01 11:00:00	NVDA	Stock	0.1428	0.1446	0.142	0.1426	197892000.0
2002-07-01 12:00:00	NVDA	Stock	0.1426	0.144	0.1418	0.1437	114012000.0
2002-07-01 13:00:00	NVDA	Stock	0.1437	0.1457	0.1427	0.1438	119964000.0
2002-07-01 14:00:00	NVDA	Stock	0.1439	0.1448	0.1418	0.1422	111048000.0
2002-07-01 15:00:00	NVDA	Stock	0.1424	0.1447	0.1421	0.1428	252432000.0
2002-07-01 16:00:00	NVDA	Stock	0.1428	0.1436	0.1409	0.1425	22632000.0
2002-07-01 17:00:00	NVDA	Stock	0.1422	0.1423	0.1415	0.142	1452000.0
2002-07-01 18:00:00	NVDA	Stock	0.142	0.1428	0.142	0.1428	132000.0
2002-07-01 08:00:00	AMZN	Stock	0.814	0.814	0.808	0.8125	776000.0
2002-07-01 09:00:00	AMZN	Stock	0.8124	0.814	0.79	0.794	38690000.0
2002-07-01 10:00:00	AMZN	Stock	0.7935	0.796	0.767	0.767	25142000.0
2002-07-01 11:00:00	AMZN	Stock	0.7675	0.7705	0.75	0.7509	17036000.0
2002-07-01 12:00:00	AMZN	Stock	0.7514	0.7525	0.7225	0.7285	28762000.0
2002-07-01 13:00:00	AMZN	Stock	0.7275	0.729	0.706	0.709	37280000.0
2002-07-01 14:00:00	AMZN	Stock	0.709	0.7125	0.7025	0.712	32416000.0
2002-07-01 15:00:00	AMZN	Stock	0.712	0.7128	0.676	0.678	61472000.0
2002-07-01 16:00:00	AMZN	Stock	0.6775	0.7715	0.6765	0.6775	14382000.0
2002-07-01 17:00:00	AMZN	Stock	0.6795	0.6825	0.6775	0.6825	166000.0
2002-07-01 18:00:00	AMZN	Stock	0.6825	0.687	0.6775	0.687	36000.0
2002-07-01 09:00:00	CL	Stock	25.125	25.355	25.1	25.355	310600.0
2002-07-01 10:00:00	CL	Stock	25.37	25.7	25.37	25.67	504000.0
2002-07-01 11:00:00	CL	Stock	25.665	25.825	25.605	25.67	650000.0
2002-07-01 12:00:00	CL	Stock	25.67	25.8	25.67	25.75	455400.0
2002-07-01 13:00:00	CL	Stock	25.745	25.925	25.7	25.91	472000.0
2002-07-01 14:00:00	CL	Stock	25.905	25.975	25.865	25.89	674600.0

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

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