PREVIEW / stock_1hour / 2006-09-11

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-09-11.parquet
  size:    604 KB
  rows:    28,867
  symbols: 2,353

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-11 06:00:00	AAPL	Stock	2.5875	2.5875	2.5804	2.5804	81200.0
2006-09-11 07:00:00	AAPL	Stock	2.5807	2.5939	2.5804	2.5939	110600.0
2006-09-11 08:00:00	AAPL	Stock	2.5896	2.595	2.5804	2.5925	2670920.0
2006-09-11 09:00:00	AAPL	Stock	2.5936	2.605	2.5714	2.5811	116367692.0
2006-09-11 10:00:00	AAPL	Stock	2.5807	2.5861	2.5507	2.5596	148889916.0
2006-09-11 11:00:00	AAPL	Stock	2.5593	2.5814	2.5554	2.5771	110373508.0
2006-09-11 12:00:00	AAPL	Stock	2.5768	2.6196	2.5761	2.6175	163806608.0
2006-09-11 13:00:00	AAPL	Stock	2.6179	2.6332	2.6136	2.6146	126474796.0
2006-09-11 14:00:00	AAPL	Stock	2.6146	2.6168	2.5911	2.6093	118901048.0
2006-09-11 15:00:00	AAPL	Stock	2.6093	2.6121	2.5829	2.5893	151856208.0
2006-09-11 16:00:00	AAPL	Stock	2.5893	2.5893	2.5779	2.5864	4037936.0
2006-09-11 17:00:00	AAPL	Stock	2.5843	2.5893	2.5832	2.5879	490252.0
2006-09-11 18:00:00	AAPL	Stock	2.5879	2.5893	2.5857	2.5861	169708.0
2006-09-11 07:00:00	MSFT	Stock	25.55	25.55	25.47	25.52	1650.0
2006-09-11 08:00:00	MSFT	Stock	25.5	25.5	25.46	25.47	30819.0
2006-09-11 09:00:00	MSFT	Stock	25.48	25.78	25.42	25.7	7443814.0
2006-09-11 10:00:00	MSFT	Stock	25.72	25.93	25.57	25.86	11454419.0
2006-09-11 11:00:00	MSFT	Stock	25.86	25.9	25.78	25.82	5936575.0
2006-09-11 12:00:00	MSFT	Stock	25.81	25.87	25.76	25.81	5000602.0
2006-09-11 13:00:00	MSFT	Stock	25.81	25.92	25.8	25.89	8193384.0
2006-09-11 14:00:00	MSFT	Stock	25.89	25.94	25.86	25.91	5622906.0
2006-09-11 15:00:00	MSFT	Stock	25.91	25.95	25.85	25.92	9606567.0
2006-09-11 16:00:00	MSFT	Stock	25.91	25.96	25.86	25.94	153432.0
2006-09-11 17:00:00	MSFT	Stock	25.95	25.95	25.92	25.93	2025.0
2006-09-11 18:00:00	MSFT	Stock	25.95	25.95	25.95	25.95	3948.0
2006-09-11 08:00:00	NVDA	Stock	0.4622	0.4625	0.4513	0.4525	1689780.0
2006-09-11 09:00:00	NVDA	Stock	0.452	0.46	0.4462	0.4538	78370020.0
2006-09-11 10:00:00	NVDA	Stock	0.4538	0.4568	0.4487	0.4512	69997140.0
2006-09-11 11:00:00	NVDA	Stock	0.4512	0.4582	0.4498	0.4575	50841060.0
2006-09-11 12:00:00	NVDA	Stock	0.4575	0.464	0.4573	0.4623	63871020.0
2006-09-11 13:00:00	NVDA	Stock	0.4625	0.4742	0.4625	0.4726	126471660.0
2006-09-11 14:00:00	NVDA	Stock	0.4723	0.473	0.4688	0.4697	80199660.0
2006-09-11 15:00:00	NVDA	Stock	0.4698	0.4712	0.4647	0.469	114664020.0
2006-09-11 16:00:00	NVDA	Stock	0.47	0.47	0.4667	0.4667	545760.0
2006-09-11 17:00:00	NVDA	Stock	0.4668	0.4683	0.4667	0.4683	408000.0
2006-09-11 18:00:00	NVDA	Stock	0.4683	0.4683	0.4657	0.4682	180000.0
2006-09-11 08:00:00	AMZN	Stock	1.5275	1.5275	1.5185	1.52	51000.0
2006-09-11 09:00:00	AMZN	Stock	1.5165	1.525	1.498	1.5125	14194120.0
2006-09-11 10:00:00	AMZN	Stock	1.5125	1.5145	1.486	1.502	19700980.0
2006-09-11 11:00:00	AMZN	Stock	1.5025	1.511	1.4935	1.507	13406640.0
2006-09-11 12:00:00	AMZN	Stock	1.507	1.531	1.506	1.526	16745860.0
2006-09-11 13:00:00	AMZN	Stock	1.5265	1.5535	1.5265	1.544	21653780.0
2006-09-11 14:00:00	AMZN	Stock	1.5441	1.5565	1.5345	1.5415	24624000.0
2006-09-11 15:00:00	AMZN	Stock	1.5415	1.5465	1.534	1.539	22599880.0
2006-09-11 16:00:00	AMZN	Stock	1.5395	1.5395	1.539	1.5395	62160.0
2006-09-11 09:00:00	CL	Stock	30.35	30.6	30.35	30.595	347000.0
2006-09-11 10:00:00	CL	Stock	30.6	30.84	30.55	30.76	530600.0
2006-09-11 11:00:00	CL	Stock	30.775	30.835	30.675	30.725	565000.0
2006-09-11 12:00:00	CL	Stock	30.725	30.79	30.685	30.715	655800.0
2006-09-11 13:00:00	CL	Stock	30.71	30.83	30.66	30.825	555400.0

> showing 50 of 28,867 rows — these rows as CSV

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