PREVIEW / stock_1hour / 2006-09-26

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-09-26.parquet
  size:    625 KB
  rows:    30,176
  symbols: 2,380

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-26 04:00:00	AAPL	Stock	2.7057	2.7057	2.7057	2.7057	5600.0
2006-09-26 06:00:00	AAPL	Stock	2.7	2.7	2.7	2.7	2800.0
2006-09-26 07:00:00	AAPL	Stock	2.7057	2.7196	2.7057	2.7196	300832.0
2006-09-26 08:00:00	AAPL	Stock	2.7179	2.7279	2.7054	2.7232	6870304.0
2006-09-26 09:00:00	AAPL	Stock	2.7232	2.7389	2.7161	2.7296	134913828.0
2006-09-26 10:00:00	AAPL	Stock	2.73	2.76	2.7243	2.7464	221008648.0
2006-09-26 11:00:00	AAPL	Stock	2.7464	2.765	2.7429	2.7464	140937076.0
2006-09-26 12:00:00	AAPL	Stock	2.7464	2.7625	2.7436	2.7532	101369240.0
2006-09-26 13:00:00	AAPL	Stock	2.7532	2.7757	2.7507	2.7568	164164196.0
2006-09-26 14:00:00	AAPL	Stock	2.7568	2.7739	2.745	2.7696	139167252.0
2006-09-26 15:00:00	AAPL	Stock	2.7693	2.7779	2.7618	2.7764	173597704.0
2006-09-26 16:00:00	AAPL	Stock	2.7761	2.7771	2.7718	2.7729	4504136.0
2006-09-26 17:00:00	AAPL	Stock	2.7732	2.7764	2.7711	2.7732	547260.0
2006-09-26 18:00:00	AAPL	Stock	2.7732	2.7764	2.7729	2.7761	217728.0
2006-09-26 19:00:00	AAPL	Stock	2.7764	2.7775	2.775	2.775	103320.0
2006-09-26 06:00:00	MSFT	Stock	26.93	26.94	26.93	26.94	800.0
2006-09-26 07:00:00	MSFT	Stock	26.93	26.95	26.92	26.92	600.0
2006-09-26 08:00:00	MSFT	Stock	26.87	26.96	26.87	26.93	135800.0
2006-09-26 09:00:00	MSFT	Stock	26.94	27.06	26.86	26.959	6317760.0
2006-09-26 10:00:00	MSFT	Stock	26.96	27.2	26.93	27.17	9499196.0
2006-09-26 11:00:00	MSFT	Stock	27.17	27.2	27.1	27.16	5506799.0
2006-09-26 12:00:00	MSFT	Stock	27.16	27.25	27.11	27.21	4698430.0
2006-09-26 13:00:00	MSFT	Stock	27.21	27.32	27.12	27.28	6470233.0
2006-09-26 14:00:00	MSFT	Stock	27.272	27.283	27.15	27.25	9088474.0
2006-09-26 15:00:00	MSFT	Stock	27.25	27.27	27.15	27.24	9643665.0
2006-09-26 16:00:00	MSFT	Stock	27.25	27.26	27.2	27.21	282645.0
2006-09-26 17:00:00	MSFT	Stock	27.2	27.25	27.19	27.19	101701.0
2006-09-26 18:00:00	MSFT	Stock	27.19	27.19	27.19	27.19	100.0
2006-09-26 19:00:00	MSFT	Stock	27.18	27.18	27.18	27.18	400.0
2006-09-26 08:00:00	NVDA	Stock	0.5137	0.5187	0.5137	0.5168	120000.0
2006-09-26 09:00:00	NVDA	Stock	0.5167	0.5167	0.5068	0.5108	56998140.0
2006-09-26 10:00:00	NVDA	Stock	0.5108	0.514	0.4985	0.5032	119997180.0
2006-09-26 11:00:00	NVDA	Stock	0.5033	0.5067	0.4995	0.5008	57489360.0
2006-09-26 12:00:00	NVDA	Stock	0.5007	0.5022	0.4973	0.5005	59385900.0
2006-09-26 13:00:00	NVDA	Stock	0.5005	0.5068	0.4992	0.5047	48047640.0
2006-09-26 14:00:00	NVDA	Stock	0.5047	0.5067	0.5025	0.5045	61181340.0
2006-09-26 15:00:00	NVDA	Stock	0.5045	0.5055	0.5023	0.5038	95268840.0
2006-09-26 16:00:00	NVDA	Stock	0.5038	0.505	0.5038	0.505	364260.0
2006-09-26 18:00:00	NVDA	Stock	0.5048	0.5048	0.5017	0.5017	24000.0
2006-09-26 19:00:00	NVDA	Stock	0.5027	0.5027	0.5013	0.5013	90000.0
2006-09-26 08:00:00	AMZN	Stock	1.595	1.5965	1.595	1.5965	28000.0
2006-09-26 09:00:00	AMZN	Stock	1.6	1.602	1.59	1.595	11865920.0
2006-09-26 10:00:00	AMZN	Stock	1.595	1.6105	1.5945	1.5985	26751300.0
2006-09-26 11:00:00	AMZN	Stock	1.5985	1.608	1.5905	1.5905	15663140.0
2006-09-26 12:00:00	AMZN	Stock	1.5905	1.601	1.5905	1.596	13825940.0
2006-09-26 13:00:00	AMZN	Stock	1.596	1.6125	1.591	1.6115	11868820.0
2006-09-26 14:00:00	AMZN	Stock	1.6115	1.6265	1.61	1.626	18193120.0
2006-09-26 15:00:00	AMZN	Stock	1.6265	1.6295	1.6185	1.628	28358340.0
2006-09-26 16:00:00	AMZN	Stock	1.627	1.63	1.624	1.6265	254000.0
2006-09-26 17:00:00	AMZN	Stock	1.6245	1.63	1.61	1.6105	164000.0

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

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