PREVIEW / stock_1hour / 2006-08-08

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-08-08.parquet
  size:    615 KB
  rows:    29,465
  symbols: 2,337

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
2006-08-08 06:00:00	AAPL	Stock	2.4036	2.4036	2.3929	2.3929	65800.0
2006-08-08 07:00:00	AAPL	Stock	2.3946	2.3957	2.3946	2.3957	5600.0
2006-08-08 08:00:00	AAPL	Stock	2.4004	2.4004	2.385	2.3964	1875580.0
2006-08-08 09:00:00	AAPL	Stock	2.4	2.4064	2.3618	2.3814	109447128.0
2006-08-08 10:00:00	AAPL	Stock	2.3814	2.3854	2.3675	2.3814	100868404.0
2006-08-08 11:00:00	AAPL	Stock	2.3811	2.3861	2.3736	2.3754	63459508.0
2006-08-08 12:00:00	AAPL	Stock	2.3757	2.3832	2.3739	2.3796	40455828.0
2006-08-08 13:00:00	AAPL	Stock	2.3793	2.3796	2.3557	2.3571	89102748.0
2006-08-08 14:00:00	AAPL	Stock	2.3571	2.3796	2.3229	2.3354	302017436.0
2006-08-08 15:00:00	AAPL	Stock	2.335	2.3771	2.3039	2.3136	272191304.0
2006-08-08 16:00:00	AAPL	Stock	2.3139	2.3271	2.3104	2.3257	6413876.0
2006-08-08 17:00:00	AAPL	Stock	2.3254	2.3282	2.3232	2.3268	519036.0
2006-08-08 18:00:00	AAPL	Stock	2.3268	2.3304	2.3236	2.3236	77000.0
2006-08-08 08:00:00	MSFT	Stock	24.3	24.44	24.3	24.31	5089.0
2006-08-08 09:00:00	MSFT	Stock	24.34	24.46	24.28	24.4	4021350.0
2006-08-08 10:00:00	MSFT	Stock	24.41	24.52	24.35	24.44	7136667.0
2006-08-08 11:00:00	MSFT	Stock	24.43	24.49	24.43	24.43	4828991.0
2006-08-08 12:00:00	MSFT	Stock	24.437	24.49	24.43	24.46	2933637.0
2006-08-08 13:00:00	MSFT	Stock	24.46	24.46	24.38	24.43	3477020.0
2006-08-08 14:00:00	MSFT	Stock	24.43	24.51	24.2	24.32	12353729.0
2006-08-08 15:00:00	MSFT	Stock	24.32	24.42	24.26	24.35	9486143.0
2006-08-08 16:00:00	MSFT	Stock	24.35	24.42	24.32	24.42	68920.0
2006-08-08 17:00:00	MSFT	Stock	24.4	24.4	24.37	24.38	4051.0
2006-08-08 18:00:00	MSFT	Stock	24.4	24.4	24.4	24.4	999.0
2006-08-08 09:00:00	NVDA	Stock	0.3972	0.4058	0.3958	0.4052	71583480.0
2006-08-08 10:00:00	NVDA	Stock	0.405	0.4142	0.4048	0.4103	124211580.0
2006-08-08 11:00:00	NVDA	Stock	0.4105	0.4127	0.4078	0.4093	57695640.0
2006-08-08 12:00:00	NVDA	Stock	0.4093	0.4103	0.4048	0.4102	50636280.0
2006-08-08 13:00:00	NVDA	Stock	0.4102	0.4112	0.4072	0.4097	40584600.0
2006-08-08 14:00:00	NVDA	Stock	0.4097	0.4133	0.3995	0.407	161053140.0
2006-08-08 15:00:00	NVDA	Stock	0.4068	0.4095	0.4023	0.4057	98287620.0
2006-08-08 16:00:00	NVDA	Stock	0.4057	0.41	0.405	0.4092	2360880.0
2006-08-08 17:00:00	NVDA	Stock	0.4092	0.415	0.4092	0.415	1177620.0
2006-08-08 18:00:00	NVDA	Stock	0.4117	0.415	0.411	0.415	938100.0
2006-08-08 09:00:00	AMZN	Stock	1.343	1.35	1.3325	1.343	5316020.0
2006-08-08 10:00:00	AMZN	Stock	1.342	1.351	1.338	1.3435	10556420.0
2006-08-08 11:00:00	AMZN	Stock	1.3435	1.3455	1.3315	1.3325	10644940.0
2006-08-08 12:00:00	AMZN	Stock	1.3325	1.336	1.325	1.3255	10951060.0
2006-08-08 13:00:00	AMZN	Stock	1.3255	1.327	1.3215	1.325	19870100.0
2006-08-08 14:00:00	AMZN	Stock	1.325	1.335	1.3115	1.3135	35050620.0
2006-08-08 15:00:00	AMZN	Stock	1.313	1.324	1.3095	1.316	47668060.0
2006-08-08 16:00:00	AMZN	Stock	1.3175	1.3225	1.315	1.3225	284400.0
2006-08-08 17:00:00	AMZN	Stock	1.3185	1.327	1.3185	1.327	18040.0
2006-08-08 18:00:00	AMZN	Stock	1.324	1.324	1.31	1.3105	170000.0
2006-08-08 09:00:00	CL	Stock	29.56	29.68	29.505	29.545	295200.0
2006-08-08 10:00:00	CL	Stock	29.56	29.58	29.505	29.51	478800.0
2006-08-08 11:00:00	CL	Stock	29.51	29.51	29.375	29.49	614000.0
2006-08-08 12:00:00	CL	Stock	29.495	29.525	29.495	29.51	377600.0
2006-08-08 13:00:00	CL	Stock	29.51	29.515	29.44	29.46	324400.0
2006-08-08 14:00:00	CL	Stock	29.46	29.6	29.325	29.525	746200.0

> showing 50 of 29,465 rows — these rows as CSV

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