PREVIEW / stock_1hour / 2006-11-09

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-11-09.parquet
  size:    627 KB
  rows:    30,009
  symbols: 2,425

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-11-09 07:00:00	AAPL	Stock	2.9607	2.9704	2.9571	2.9607	481208.0
2006-11-09 08:00:00	AAPL	Stock	2.9625	2.9679	2.9571	2.9625	3041892.0
2006-11-09 09:00:00	AAPL	Stock	2.9639	2.9707	2.9464	2.9521	120690472.0
2006-11-09 10:00:00	AAPL	Stock	2.9525	2.9989	2.9329	2.9939	201551756.0
2006-11-09 11:00:00	AAPL	Stock	2.9943	3.0011	2.9839	2.9968	110392604.0
2006-11-09 12:00:00	AAPL	Stock	2.9971	3.0246	2.9932	3.0239	121618028.0
2006-11-09 13:00:00	AAPL	Stock	3.0239	3.0239	2.9821	2.995	127885772.0
2006-11-09 14:00:00	AAPL	Stock	2.9954	3.0029	2.9664	2.9796	103101740.0
2006-11-09 15:00:00	AAPL	Stock	2.9796	2.98	2.9582	2.9754	123025308.0
2006-11-09 16:00:00	AAPL	Stock	2.9771	2.9818	2.975	2.9782	1764588.0
2006-11-09 17:00:00	AAPL	Stock	2.9782	2.9782	2.9711	2.975	369348.0
2006-11-09 18:00:00	AAPL	Stock	2.975	2.9754	2.9664	2.9664	156520.0
2006-11-09 19:00:00	AAPL	Stock	2.9704	2.9714	2.9682	2.9714	36260.0
2006-11-09 07:00:00	MSFT	Stock	29.1	29.1	29.05	29.05	2100.0
2006-11-09 08:00:00	MSFT	Stock	29.16	29.18	29.08	29.17	24416.0
2006-11-09 09:00:00	MSFT	Stock	29.14	29.29	29.0	29.23	10253059.0
2006-11-09 10:00:00	MSFT	Stock	29.23	29.26	29.1	29.25	13667212.0
2006-11-09 11:00:00	MSFT	Stock	29.25	29.28	29.17	29.24	9334060.0
2006-11-09 12:00:00	MSFT	Stock	29.24	29.38	29.2	29.38	11227231.0
2006-11-09 13:00:00	MSFT	Stock	29.38	29.4	29.22	29.25	10828555.0
2006-11-09 14:00:00	MSFT	Stock	29.251	29.29	29.15	29.18	9354901.0
2006-11-09 15:00:00	MSFT	Stock	29.17	29.29	29.15	29.26	16279545.0
2006-11-09 16:00:00	MSFT	Stock	29.26	29.3	29.24	29.29	205913.0
2006-11-09 17:00:00	MSFT	Stock	29.29	29.29	29.25	29.29	9965.0
2006-11-09 18:00:00	MSFT	Stock	29.26	29.26	29.26	29.26	1200.0
2006-11-09 19:00:00	MSFT	Stock	29.26	29.26	29.26	29.26	300.0
2006-11-09 07:00:00	NVDA	Stock	0.5817	0.5872	0.5817	0.5833	186000.0
2006-11-09 08:00:00	NVDA	Stock	0.587	0.588	0.5832	0.5875	3876600.0
2006-11-09 09:00:00	NVDA	Stock	0.5867	0.6033	0.5833	0.5933	174782520.0
2006-11-09 10:00:00	NVDA	Stock	0.5935	0.5992	0.5895	0.5973	139274460.0
2006-11-09 11:00:00	NVDA	Stock	0.5975	0.5983	0.5903	0.5903	110986740.0
2006-11-09 12:00:00	NVDA	Stock	0.5905	0.5987	0.5902	0.5983	121504500.0
2006-11-09 13:00:00	NVDA	Stock	0.5985	0.5997	0.5932	0.5933	114325980.0
2006-11-09 14:00:00	NVDA	Stock	0.5933	0.5958	0.5875	0.5892	104213100.0
2006-11-09 15:00:00	NVDA	Stock	0.5892	0.593	0.5832	0.5885	236771640.0
2006-11-09 16:00:00	NVDA	Stock	0.5885	0.6217	0.5828	0.6108	108636120.0
2006-11-09 17:00:00	NVDA	Stock	0.6112	0.6167	0.5892	0.6062	80136120.0
2006-11-09 18:00:00	NVDA	Stock	0.6053	0.6075	0.6033	0.6067	5979960.0
2006-11-09 19:00:00	NVDA	Stock	0.6075	0.609	0.606	0.6083	2706840.0
2006-11-09 08:00:00	AMZN	Stock	1.975	1.9825	1.975	1.975	134000.0
2006-11-09 09:00:00	AMZN	Stock	1.977	1.9885	1.975	1.984	12405560.0
2006-11-09 10:00:00	AMZN	Stock	1.984	1.9875	1.97	1.976	16371500.0
2006-11-09 11:00:00	AMZN	Stock	1.9755	1.9765	1.964	1.974	15584360.0
2006-11-09 12:00:00	AMZN	Stock	1.974	1.9825	1.9675	1.9825	9787900.0
2006-11-09 13:00:00	AMZN	Stock	1.9825	1.9825	1.9705	1.9715	12965100.0
2006-11-09 14:00:00	AMZN	Stock	1.971	1.975	1.951	1.955	14603640.0
2006-11-09 15:00:00	AMZN	Stock	1.9545	1.955	1.9405	1.942	30112680.0
2006-11-09 16:00:00	AMZN	Stock	1.944	1.946	1.942	1.944	145200.0
2006-11-09 17:00:00	AMZN	Stock	1.944	1.9455	1.944	1.9455	25700.0
2006-11-09 18:00:00	AMZN	Stock	1.949	1.9495	1.949	1.9495	22340.0

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

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