PREVIEW / stock_1hour / 2006-06-30

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-06-30.parquet
  size:    666 KB
  rows:    31,247
  symbols: 2,309

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-06-30 04:00:00	AAPL	Stock	2.05	2.05	2.05	2.05	30800.0
2006-06-30 06:00:00	AAPL	Stock	2.05	2.05	2.05	2.05	28000.0
2006-06-30 07:00:00	AAPL	Stock	2.0604	2.0632	2.0536	2.0604	113008.0
2006-06-30 08:00:00	AAPL	Stock	2.0568	2.0611	2.0368	2.055	8478372.0
2006-06-30 09:00:00	AAPL	Stock	2.0546	2.0661	2.0336	2.0346	148640940.0
2006-06-30 10:00:00	AAPL	Stock	2.0346	2.0482	2.0179	2.03	191647736.0
2006-06-30 11:00:00	AAPL	Stock	2.03	2.0479	2.0286	2.0439	108144792.0
2006-06-30 12:00:00	AAPL	Stock	2.0439	2.0529	2.0371	2.0482	43889804.0
2006-06-30 13:00:00	AAPL	Stock	2.0486	2.0625	2.0482	2.0529	62156304.0
2006-06-30 14:00:00	AAPL	Stock	2.0529	2.0579	2.0446	2.0511	44278472.0
2006-06-30 15:00:00	AAPL	Stock	2.0511	2.0514	2.0218	2.0457	95429432.0
2006-06-30 16:00:00	AAPL	Stock	2.0439	2.0464	2.0388	2.0464	2784068.0
2006-06-30 17:00:00	AAPL	Stock	2.0461	2.0482	2.0374	2.0454	1394988.0
2006-06-30 18:00:00	AAPL	Stock	2.0404	2.0536	2.0404	2.0536	410620.0
2006-06-30 08:00:00	MSFT	Stock	23.43	23.55	23.4	23.52	115583.0
2006-06-30 09:00:00	MSFT	Stock	23.52	23.63	23.5	23.53	7734256.0
2006-06-30 10:00:00	MSFT	Stock	23.54	23.65	23.42	23.62	9832795.0
2006-06-30 11:00:00	MSFT	Stock	23.62	23.63	23.54	23.56	7296732.0
2006-06-30 12:00:00	MSFT	Stock	23.56	23.568	23.45	23.47	4731441.0
2006-06-30 13:00:00	MSFT	Stock	23.47	23.52	23.38	23.5	6021708.0
2006-06-30 14:00:00	MSFT	Stock	23.502	23.6	23.48	23.58	4897361.0
2006-06-30 15:00:00	MSFT	Stock	23.59	23.59	23.3	23.31	12242472.0
2006-06-30 16:00:00	MSFT	Stock	23.39	23.4	23.28	23.38	2025112.0
2006-06-30 17:00:00	MSFT	Stock	23.38	23.39	23.27	23.38	734693.0
2006-06-30 18:00:00	MSFT	Stock	23.38	23.38	23.36	23.36	300.0
2006-06-30 06:00:00	NVDA	Stock	0.3582	0.36	0.3582	0.36	60000.0
2006-06-30 08:00:00	NVDA	Stock	0.3548	0.3598	0.3548	0.3598	159900.0
2006-06-30 09:00:00	NVDA	Stock	0.3597	0.3673	0.3582	0.3618	83508540.0
2006-06-30 10:00:00	NVDA	Stock	0.3618	0.3618	0.3527	0.3552	114310020.0
2006-06-30 11:00:00	NVDA	Stock	0.3552	0.3565	0.3533	0.3552	68616600.0
2006-06-30 12:00:00	NVDA	Stock	0.3553	0.3553	0.3533	0.3537	35057220.0
2006-06-30 13:00:00	NVDA	Stock	0.3537	0.355	0.3522	0.3532	27094500.0
2006-06-30 14:00:00	NVDA	Stock	0.3532	0.3558	0.3528	0.3558	32466000.0
2006-06-30 15:00:00	NVDA	Stock	0.3558	0.3558	0.3537	0.3552	56929800.0
2006-06-30 16:00:00	NVDA	Stock	0.3552	0.3558	0.3548	0.3548	2792940.0
2006-06-30 17:00:00	NVDA	Stock	0.3542	0.3557	0.3542	0.3548	862800.0
2006-06-30 18:00:00	NVDA	Stock	0.3547	0.3547	0.3547	0.3547	36360.0
2006-06-30 08:00:00	AMZN	Stock	1.928	1.93	1.928	1.93	6000.0
2006-06-30 09:00:00	AMZN	Stock	1.93	1.9345	1.915	1.916	7987840.0
2006-06-30 10:00:00	AMZN	Stock	1.9165	1.9165	1.8915	1.911	15506280.0
2006-06-30 11:00:00	AMZN	Stock	1.9105	1.914	1.9	1.9125	6067480.0
2006-06-30 12:00:00	AMZN	Stock	1.912	1.916	1.9025	1.9055	6112140.0
2006-06-30 13:00:00	AMZN	Stock	1.9055	1.919	1.903	1.9185	5293140.0
2006-06-30 14:00:00	AMZN	Stock	1.9185	1.942	1.9175	1.94	12804060.0
2006-06-30 15:00:00	AMZN	Stock	1.9405	1.941	1.928	1.9335	20106860.0
2006-06-30 16:00:00	AMZN	Stock	1.9345	1.9355	1.9324	1.935	5185400.0
2006-06-30 17:00:00	AMZN	Stock	1.9305	1.9341	1.9305	1.934	768640.0
2006-06-30 09:00:00	CL	Stock	30.15	30.16	30.05	30.05	393800.0
2006-06-30 10:00:00	CL	Stock	30.045	30.15	29.88	29.93	661000.0
2006-06-30 11:00:00	CL	Stock	29.94	30.01	29.93	30.0	641000.0

> showing 50 of 31,247 rows — these rows as CSV

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