PREVIEW / stock_1hour / 2006-10-02

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-10-02.parquet
  size:    627 KB
  rows:    29,926
  symbols: 2,384

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-10-02 04:00:00	AAPL	Stock	2.7639	2.7679	2.7639	2.7679	10500.0
2006-10-02 05:00:00	AAPL	Stock	2.75	2.7511	2.7271	2.7271	25200.0
2006-10-02 06:00:00	AAPL	Stock	2.6979	2.6979	2.6961	2.6979	170184.0
2006-10-02 07:00:00	AAPL	Stock	2.6982	2.6982	2.6786	2.6857	775124.0
2006-10-02 08:00:00	AAPL	Stock	2.6839	2.6996	2.6839	2.6911	7244720.0
2006-10-02 09:00:00	AAPL	Stock	2.6893	2.6929	2.6536	2.6632	145032692.0
2006-10-02 10:00:00	AAPL	Stock	2.6632	2.6714	2.6564	2.6664	120288560.0
2006-10-02 11:00:00	AAPL	Stock	2.6664	2.6818	2.6639	2.6789	86292472.0
2006-10-02 12:00:00	AAPL	Stock	2.6793	2.7096	2.6786	2.6954	97456268.0
2006-10-02 13:00:00	AAPL	Stock	2.6957	2.6993	2.6657	2.67	79731232.0
2006-10-02 14:00:00	AAPL	Stock	2.6702	2.6871	2.665	2.675	67188072.0
2006-10-02 15:00:00	AAPL	Stock	2.675	2.6839	2.6711	2.6732	83791484.0
2006-10-02 16:00:00	AAPL	Stock	2.6732	2.6782	2.6696	2.6729	1472632.0
2006-10-02 17:00:00	AAPL	Stock	2.6714	2.6736	2.6711	2.6721	1169504.0
2006-10-02 18:00:00	AAPL	Stock	2.6721	2.6736	2.6714	2.6736	283388.0
2006-10-02 19:00:00	AAPL	Stock	2.675	2.675	2.6729	2.675	128940.0
2006-10-02 07:00:00	MSFT	Stock	27.27	27.27	27.27	27.27	1000.0
2006-10-02 08:00:00	MSFT	Stock	27.2	27.35	27.2	27.35	68130.0
2006-10-02 09:00:00	MSFT	Stock	27.22	27.38	27.17	27.37	4275763.0
2006-10-02 10:00:00	MSFT	Stock	27.36	27.48	27.35	27.46	5359908.0
2006-10-02 11:00:00	MSFT	Stock	27.46	27.49	27.38	27.47	5242200.0
2006-10-02 12:00:00	MSFT	Stock	27.47	27.48	27.43	27.44	3487255.0
2006-10-02 13:00:00	MSFT	Stock	27.44	27.46	27.15	27.33	10542143.0
2006-10-02 14:00:00	MSFT	Stock	27.34	27.44	27.3	27.35	6976774.0
2006-10-02 15:00:00	MSFT	Stock	27.36	27.44	27.32	27.34	9029489.0
2006-10-02 16:00:00	MSFT	Stock	27.35	27.37	27.25	27.32	310471.0
2006-10-02 17:00:00	MSFT	Stock	27.3	27.336	27.25	27.3	13093.0
2006-10-02 18:00:00	MSFT	Stock	27.26	27.29	27.26	27.29	2600.0
2006-10-02 08:00:00	NVDA	Stock	0.4938	0.494	0.4932	0.4938	1241400.0
2006-10-02 09:00:00	NVDA	Stock	0.494	0.494	0.4885	0.4908	40411020.0
2006-10-02 10:00:00	NVDA	Stock	0.4908	0.494	0.4867	0.4892	100596180.0
2006-10-02 11:00:00	NVDA	Stock	0.4892	0.4933	0.4877	0.4923	81760860.0
2006-10-02 12:00:00	NVDA	Stock	0.4922	0.4932	0.4885	0.4885	66634020.0
2006-10-02 13:00:00	NVDA	Stock	0.4885	0.4908	0.4775	0.4792	86602140.0
2006-10-02 14:00:00	NVDA	Stock	0.4792	0.4918	0.4767	0.4793	97014060.0
2006-10-02 15:00:00	NVDA	Stock	0.4793	0.4815	0.4782	0.4808	133008720.0
2006-10-02 16:00:00	NVDA	Stock	0.4807	0.4812	0.4755	0.4775	872760.0
2006-10-02 17:00:00	NVDA	Stock	0.4775	0.4806	0.4758	0.4806	177420.0
2006-10-02 18:00:00	NVDA	Stock	0.4772	0.4772	0.4772	0.4772	60000.0
2006-10-02 19:00:00	NVDA	Stock	0.475	0.475	0.4745	0.475	146580.0
2006-10-02 08:00:00	AMZN	Stock	1.6	1.606	1.59	1.606	239200.0
2006-10-02 09:00:00	AMZN	Stock	1.5995	1.606	1.58	1.5945	11867100.0
2006-10-02 10:00:00	AMZN	Stock	1.593	1.599	1.583	1.5835	15210200.0
2006-10-02 11:00:00	AMZN	Stock	1.584	1.5915	1.57	1.587	17189100.0
2006-10-02 12:00:00	AMZN	Stock	1.587	1.59	1.5725	1.5725	11207840.0
2006-10-02 13:00:00	AMZN	Stock	1.5725	1.5725	1.5425	1.549	21071780.0
2006-10-02 14:00:00	AMZN	Stock	1.549	1.597	1.5425	1.5515	23663700.0
2006-10-02 15:00:00	AMZN	Stock	1.5515	1.5515	1.5415	1.5435	29369920.0
2006-10-02 16:00:00	AMZN	Stock	1.541	1.547	1.538	1.547	189220.0
2006-10-02 17:00:00	AMZN	Stock	1.5434	1.5434	1.5434	1.5434	5740.0

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

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