PREVIEW / stock_1hour / 2007-01-30

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-01-30.parquet
  size:    644 KB
  rows:    30,639
  symbols: 2,518

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
2007-01-30 07:00:00	AAPL	Stock	3.0893	3.1	3.0804	3.095	572684.0
2007-01-30 08:00:00	AAPL	Stock	3.0936	3.0982	3.0893	3.0939	3044216.0
2007-01-30 09:00:00	AAPL	Stock	3.0936	3.0943	3.0557	3.065	110871096.0
2007-01-30 10:00:00	AAPL	Stock	3.0646	3.0714	3.0504	3.0614	130598132.0
2007-01-30 11:00:00	AAPL	Stock	3.0614	3.0711	3.0561	3.0586	74121964.0
2007-01-30 12:00:00	AAPL	Stock	3.0589	3.0596	3.0471	3.0579	69905528.0
2007-01-30 13:00:00	AAPL	Stock	3.0575	3.0593	3.0446	3.0589	62326740.0
2007-01-30 14:00:00	AAPL	Stock	3.0586	3.0587	3.0489	3.0536	43941324.0
2007-01-30 15:00:00	AAPL	Stock	3.0539	3.0621	3.0518	3.0554	71669892.0
2007-01-30 16:00:00	AAPL	Stock	3.0568	3.06	3.0536	3.0582	2548504.0
2007-01-30 17:00:00	AAPL	Stock	3.0589	3.0596	3.0536	3.0536	771092.0
2007-01-30 18:00:00	AAPL	Stock	3.0536	3.0554	3.0518	3.0518	530572.0
2007-01-30 19:00:00	AAPL	Stock	3.0536	3.0586	3.0536	3.0536	231700.0
2007-01-30 07:00:00	MSFT	Stock	30.65	30.67	30.65	30.67	775.0
2007-01-30 08:00:00	MSFT	Stock	30.61	30.67	30.55	30.57	55877.0
2007-01-30 09:00:00	MSFT	Stock	30.57	30.65	30.14	30.32	9211115.0
2007-01-30 10:00:00	MSFT	Stock	30.32	30.33	30.16	30.26	9777475.0
2007-01-30 11:00:00	MSFT	Stock	30.26	30.41	30.18	30.32	7224010.0
2007-01-30 12:00:00	MSFT	Stock	30.31	30.39	30.27	30.38	5892655.0
2007-01-30 13:00:00	MSFT	Stock	30.39	30.45	30.33	30.39	8754527.0
2007-01-30 14:00:00	MSFT	Stock	30.36	30.46	30.3	30.44	6706111.0
2007-01-30 15:00:00	MSFT	Stock	30.439	30.6	30.33	30.49	12063184.0
2007-01-30 16:00:00	MSFT	Stock	30.5	30.52	30.4	30.41	671075.0
2007-01-30 17:00:00	MSFT	Stock	30.41	30.43	30.41	30.43	6526.0
2007-01-30 18:00:00	MSFT	Stock	30.43	30.46	30.43	30.44	15690.0
2007-01-30 19:00:00	MSFT	Stock	30.42	30.48	30.42	30.43	6637.0
2007-01-30 08:00:00	NVDA	Stock	0.5067	0.5082	0.504	0.505	294000.0
2007-01-30 09:00:00	NVDA	Stock	0.5048	0.5088	0.5018	0.5067	72721980.0
2007-01-30 10:00:00	NVDA	Stock	0.5068	0.511	0.503	0.5083	125207760.0
2007-01-30 11:00:00	NVDA	Stock	0.5083	0.5145	0.508	0.511	113546640.0
2007-01-30 12:00:00	NVDA	Stock	0.511	0.5138	0.5088	0.513	67104600.0
2007-01-30 13:00:00	NVDA	Stock	0.513	0.5153	0.5108	0.5152	64592400.0
2007-01-30 14:00:00	NVDA	Stock	0.515	0.516	0.512	0.5132	69569100.0
2007-01-30 15:00:00	NVDA	Stock	0.5132	0.5145	0.511	0.5127	104318040.0
2007-01-30 16:00:00	NVDA	Stock	0.513	0.5183	0.5123	0.5175	2246460.0
2007-01-30 17:00:00	NVDA	Stock	0.5173	0.5173	0.5133	0.5133	235200.0
2007-01-30 18:00:00	NVDA	Stock	0.5133	0.5133	0.5117	0.5117	718200.0
2007-01-30 19:00:00	NVDA	Stock	0.5133	0.5133	0.5133	0.5133	30000.0
2007-01-30 08:00:00	AMZN	Stock	1.8625	1.8625	1.862	1.862	16000.0
2007-01-30 09:00:00	AMZN	Stock	1.8665	1.871	1.8535	1.8605	10284420.0
2007-01-30 10:00:00	AMZN	Stock	1.861	1.8645	1.8535	1.8565	12271220.0
2007-01-30 11:00:00	AMZN	Stock	1.8565	1.857	1.8435	1.844	15497660.0
2007-01-30 12:00:00	AMZN	Stock	1.8445	1.847	1.8375	1.8385	8727200.0
2007-01-30 13:00:00	AMZN	Stock	1.8385	1.846	1.8315	1.845	14766340.0
2007-01-30 14:00:00	AMZN	Stock	1.845	1.8535	1.8385	1.8535	13950960.0
2007-01-30 15:00:00	AMZN	Stock	1.854	1.86	1.8515	1.8525	16294260.0
2007-01-30 16:00:00	AMZN	Stock	1.852	1.853	1.851	1.853	219140.0
2007-01-30 18:00:00	AMZN	Stock	1.8565	1.8565	1.8565	1.8565	8000.0
2007-01-30 08:00:00	CL	Stock	33.5	33.5	33.5	33.5	200.0
2007-01-30 09:00:00	CL	Stock	33.5	33.5	33.0	33.11	1920200.0

> showing 50 of 30,639 rows — these rows as CSV

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