PREVIEW / stock_1hour / 2008-07-02

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-07-02.parquet
  size:    855 KB
  rows:    41,173
  symbols: 3,333

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
2008-07-02 07:00:00	AAPL	Stock	6.2768	6.2821	6.2643	6.2729	223692.0
2008-07-02 08:00:00	AAPL	Stock	6.2679	6.2775	6.2429	6.2611	3431484.0
2008-07-02 09:00:00	AAPL	Stock	6.2611	6.3375	6.2368	6.2918	121706928.0
2008-07-02 10:00:00	AAPL	Stock	6.2911	6.3104	6.1771	6.2332	158929456.0
2008-07-02 11:00:00	AAPL	Stock	6.2336	6.2679	6.1346	6.1743	134063216.0
2008-07-02 12:00:00	AAPL	Stock	6.1741	6.2321	6.1314	6.1482	85410472.0
2008-07-02 13:00:00	AAPL	Stock	6.1482	6.1996	6.1132	6.1968	73605672.0
2008-07-02 14:00:00	AAPL	Stock	6.1975	6.2004	6.1018	6.125	86081240.0
2008-07-02 15:00:00	AAPL	Stock	6.1239	6.1343	6.0064	6.0069	143306856.0
2008-07-02 16:00:00	AAPL	Stock	6.0064	6.1893	6.0064	6.0068	11048100.0
2008-07-02 17:00:00	AAPL	Stock	6.0071	6.0107	5.9554	5.9714	5894560.0
2008-07-02 18:00:00	AAPL	Stock	5.9714	5.9732	5.9471	5.9696	535780.0
2008-07-02 19:00:00	AAPL	Stock	5.9696	5.975	5.9554	5.9675	484260.0
2008-07-02 20:00:00	AAPL	Stock	6.1461	6.1461	6.1461	6.1461	56000.0
2008-07-02 05:00:00	MSFT	Stock	26.89	26.89	26.89	26.89	100.0
2008-07-02 07:00:00	MSFT	Stock	26.89	27.08	26.89	27.01	889.0
2008-07-02 08:00:00	MSFT	Stock	27.03	27.09	26.99	27.01	24993.0
2008-07-02 09:00:00	MSFT	Stock	27.02	27.07	26.85	26.9	5643091.0
2008-07-02 10:00:00	MSFT	Stock	26.91	26.96	26.65	26.66	10011950.0
2008-07-02 11:00:00	MSFT	Stock	26.66	26.68	26.28	26.34	13097305.0
2008-07-02 12:00:00	MSFT	Stock	26.34	26.48	26.29	26.34	6990655.0
2008-07-02 13:00:00	MSFT	Stock	26.34	26.62	26.27	26.572	9532692.0
2008-07-02 14:00:00	MSFT	Stock	26.58	26.6	26.23	26.24	9225073.0
2008-07-02 15:00:00	MSFT	Stock	26.23	26.33	25.89	25.89	25488749.0
2008-07-02 16:00:00	MSFT	Stock	25.89	26.478	25.8	25.81	2938456.0
2008-07-02 17:00:00	MSFT	Stock	25.85	25.9	25.68	25.7	645595.0
2008-07-02 18:00:00	MSFT	Stock	25.78	25.78	25.71	25.72	5200.0
2008-07-02 19:00:00	MSFT	Stock	25.72	25.74	25.69	25.69	13848.0
2008-07-02 20:00:00	MSFT	Stock	26.39	26.39	26.39	26.39	600.0
2008-07-02 07:00:00	NVDA	Stock	0.4695	0.4695	0.4695	0.4695	4000.0
2008-07-02 08:00:00	NVDA	Stock	0.472	0.475	0.4713	0.475	342040.0
2008-07-02 09:00:00	NVDA	Stock	0.4763	0.48	0.458	0.4588	58045200.0
2008-07-02 10:00:00	NVDA	Stock	0.4588	0.4643	0.4568	0.4605	76249720.0
2008-07-02 11:00:00	NVDA	Stock	0.4603	0.4603	0.4545	0.4565	81659000.0
2008-07-02 12:00:00	NVDA	Stock	0.4568	0.4593	0.4545	0.456	54013160.0
2008-07-02 13:00:00	NVDA	Stock	0.4561	0.4603	0.4545	0.46	48702080.0
2008-07-02 14:00:00	NVDA	Stock	0.46	0.4605	0.4545	0.4558	62066680.0
2008-07-02 15:00:00	NVDA	Stock	0.4558	0.4565	0.45	0.4505	129308480.0
2008-07-02 16:00:00	NVDA	Stock	0.4502	0.4576	0.45	0.4508	940320.0
2008-07-02 17:00:00	NVDA	Stock	0.3998	0.4508	0.3325	0.355	227718720.0
2008-07-02 18:00:00	NVDA	Stock	0.3538	0.3688	0.353	0.3585	12157800.0
2008-07-02 19:00:00	NVDA	Stock	0.3575	0.3585	0.35	0.352	4527560.0
2008-07-02 08:00:00	AMZN	Stock	3.7275	3.7275	3.7275	3.7275	3000.0
2008-07-02 09:00:00	AMZN	Stock	3.681	3.7205	3.676	3.6965	16709440.0
2008-07-02 10:00:00	AMZN	Stock	3.698	3.7085	3.6625	3.69	21033580.0
2008-07-02 11:00:00	AMZN	Stock	3.69	3.6903	3.6	3.611	20817740.0
2008-07-02 12:00:00	AMZN	Stock	3.6125	3.6605	3.6055	3.6217	15894760.0
2008-07-02 13:00:00	AMZN	Stock	3.622	3.6685	3.6165	3.6635	9017200.0
2008-07-02 14:00:00	AMZN	Stock	3.6635	3.686	3.628	3.635	22219780.0
2008-07-02 15:00:00	AMZN	Stock	3.6345	3.645	3.569	3.572	25721260.0

> showing 50 of 41,173 rows — these rows as CSV

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