PREVIEW / stock_1hour / 2006-09-20

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-09-20.parquet
  size:    623 KB
  rows:    29,849
  symbols: 2,375

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-09-20 07:00:00	AAPL	Stock	2.6443	2.6443	2.6429	2.6429	19600.0
2006-09-20 08:00:00	AAPL	Stock	2.65	2.6579	2.6346	2.655	1228640.0
2006-09-20 09:00:00	AAPL	Stock	2.6539	2.6786	2.6507	2.6664	107289616.0
2006-09-20 10:00:00	AAPL	Stock	2.6664	2.6889	2.6575	2.6886	154000364.0
2006-09-20 11:00:00	AAPL	Stock	2.6882	2.7029	2.6861	2.6921	144059664.0
2006-09-20 12:00:00	AAPL	Stock	2.692	2.6982	2.6864	2.6864	50403780.0
2006-09-20 13:00:00	AAPL	Stock	2.6864	2.6936	2.6839	2.69	44144996.0
2006-09-20 14:00:00	AAPL	Stock	2.6904	2.6943	2.6661	2.6771	163543156.0
2006-09-20 15:00:00	AAPL	Stock	2.6768	2.6925	2.6729	2.6921	138985560.0
2006-09-20 16:00:00	AAPL	Stock	2.6918	2.7011	2.6907	2.6936	4387264.0
2006-09-20 17:00:00	AAPL	Stock	2.6929	2.6946	2.6921	2.6946	328860.0
2006-09-20 18:00:00	AAPL	Stock	2.6946	2.6964	2.6943	2.6964	176400.0
2006-09-20 19:00:00	AAPL	Stock	2.6964	2.6964	2.6964	2.6964	21840.0
2006-09-20 07:00:00	MSFT	Stock	27.06	27.1	27.0	27.1	3060.0
2006-09-20 08:00:00	MSFT	Stock	27.1	27.12	26.86	27.04	362835.0
2006-09-20 09:00:00	MSFT	Stock	27.05	27.15	26.99	27.09	6881257.0
2006-09-20 10:00:00	MSFT	Stock	27.098	27.19	27.02	27.16	11322559.0
2006-09-20 11:00:00	MSFT	Stock	27.16	27.19	27.0	27.11	9581092.0
2006-09-20 12:00:00	MSFT	Stock	27.11	27.16	27.1	27.13	5241524.0
2006-09-20 13:00:00	MSFT	Stock	27.13	27.19	27.1	27.17	5298288.0
2006-09-20 14:00:00	MSFT	Stock	27.18	27.2	27.09	27.173	13099038.0
2006-09-20 15:00:00	MSFT	Stock	27.17	27.23	27.11	27.19	15388598.0
2006-09-20 16:00:00	MSFT	Stock	27.19	27.21	27.15	27.16	275841.0
2006-09-20 17:00:00	MSFT	Stock	27.18	27.18	27.16	27.16	2980.0
2006-09-20 18:00:00	MSFT	Stock	27.17	27.17	27.16	27.17	1240.0
2006-09-20 08:00:00	NVDA	Stock	0.5017	0.5022	0.5	0.5022	55200.0
2006-09-20 09:00:00	NVDA	Stock	0.5033	0.5115	0.5017	0.5073	45514500.0
2006-09-20 10:00:00	NVDA	Stock	0.5072	0.51	0.5055	0.5082	50019480.0
2006-09-20 11:00:00	NVDA	Stock	0.5085	0.5087	0.5035	0.5057	32583660.0
2006-09-20 12:00:00	NVDA	Stock	0.5058	0.5083	0.5053	0.508	23940060.0
2006-09-20 13:00:00	NVDA	Stock	0.508	0.5107	0.5077	0.5092	36480120.0
2006-09-20 14:00:00	NVDA	Stock	0.5093	0.5128	0.5078	0.5102	126192180.0
2006-09-20 15:00:00	NVDA	Stock	0.5112	0.5168	0.5102	0.5155	156141060.0
2006-09-20 16:00:00	NVDA	Stock	0.5165	0.517	0.515	0.5167	1007460.0
2006-09-20 17:00:00	NVDA	Stock	0.5155	0.517	0.5155	0.517	342960.0
2006-09-20 18:00:00	NVDA	Stock	0.5162	0.5175	0.515	0.5175	171900.0
2006-09-20 19:00:00	NVDA	Stock	0.5175	0.5175	0.5175	0.5175	30000.0
2006-09-20 08:00:00	AMZN	Stock	1.579	1.579	1.579	1.579	782000.0
2006-09-20 09:00:00	AMZN	Stock	1.59	1.625	1.59	1.614	17679240.0
2006-09-20 10:00:00	AMZN	Stock	1.614	1.625	1.5985	1.623	20909980.0
2006-09-20 11:00:00	AMZN	Stock	1.623	1.636	1.6215	1.6225	24943000.0
2006-09-20 12:00:00	AMZN	Stock	1.623	1.627	1.613	1.613	14841740.0
2006-09-20 13:00:00	AMZN	Stock	1.613	1.6135	1.602	1.6125	10221380.0
2006-09-20 14:00:00	AMZN	Stock	1.612	1.632	1.59	1.599	31559400.0
2006-09-20 15:00:00	AMZN	Stock	1.5985	1.6405	1.5967	1.6055	44561340.0
2006-09-20 16:00:00	AMZN	Stock	1.607	1.609	1.6005	1.607	801000.0
2006-09-20 17:00:00	AMZN	Stock	1.5995	1.5995	1.5995	1.5995	4000.0
2006-09-20 08:00:00	CL	Stock	30.92	30.92	30.92	30.92	4800.0
2006-09-20 09:00:00	CL	Stock	30.9	30.985	30.775	30.875	192200.0
2006-09-20 10:00:00	CL	Stock	30.875	30.92	30.835	30.9	324400.0

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

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