PREVIEW / stock_1hour / 2007-06-12

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-06-12.parquet
  size:    752 KB
  rows:    36,780
  symbols: 3,026

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
2007-06-12 09:00:00	AAPL	Stock	4.2625	4.3121	4.2254	4.2829	272237224.0
2007-06-12 10:00:00	AAPL	Stock	4.2832	4.3314	4.2796	4.2886	280516572.0
2007-06-12 11:00:00	AAPL	Stock	4.2886	4.3214	4.2629	4.3207	173897276.0
2007-06-12 12:00:00	AAPL	Stock	4.3211	4.3407	4.3057	4.3121	154008624.0
2007-06-12 13:00:00	AAPL	Stock	4.3118	4.3439	4.2971	4.3393	120016764.0
2007-06-12 14:00:00	AAPL	Stock	4.3396	4.3468	4.3096	4.3207	139558720.0
2007-06-12 15:00:00	AAPL	Stock	4.32	4.3275	4.285	4.3014	215539268.0
2007-06-12 16:00:00	AAPL	Stock	4.2993	4.3011	4.2993	4.2993	5456948.0
2007-06-12 09:00:00	MSFT	Stock	29.96	29.96	29.87	29.89	5265069.0
2007-06-12 10:00:00	MSFT	Stock	29.89	29.94	29.79	29.83	8126119.0
2007-06-12 11:00:00	MSFT	Stock	29.83	29.91	29.77	29.9	5730297.0
2007-06-12 12:00:00	MSFT	Stock	29.9	29.98	29.8	29.965	4563167.0
2007-06-12 13:00:00	MSFT	Stock	29.96	30.15	29.96	30.13	8100125.0
2007-06-12 14:00:00	MSFT	Stock	30.13	30.24	30.04	30.11	8254570.0
2007-06-12 15:00:00	MSFT	Stock	30.1	30.15	29.73	29.85	11369781.0
2007-06-12 16:00:00	MSFT	Stock	29.85	29.85	29.85	29.85	1084591.0
2007-06-12 08:00:00	NVDA	Stock	0.6083	0.6083	0.6083	0.6083	18000.0
2007-06-12 09:00:00	NVDA	Stock	0.6083	0.6142	0.5967	0.6113	66419760.0
2007-06-12 10:00:00	NVDA	Stock	0.6113	0.615	0.6103	0.6132	91971240.0
2007-06-12 11:00:00	NVDA	Stock	0.6132	0.6167	0.611	0.6155	83120340.0
2007-06-12 12:00:00	NVDA	Stock	0.6155	0.6155	0.6108	0.6113	53645940.0
2007-06-12 13:00:00	NVDA	Stock	0.6113	0.6142	0.6102	0.6138	49353540.0
2007-06-12 14:00:00	NVDA	Stock	0.614	0.6152	0.6102	0.6123	50964780.0
2007-06-12 15:00:00	NVDA	Stock	0.6123	0.613	0.6047	0.6057	110230320.0
2007-06-12 16:00:00	NVDA	Stock	0.6053	0.6075	0.605	0.6065	10360380.0
2007-06-12 17:00:00	NVDA	Stock	0.6078	0.6083	0.605	0.6083	901020.0
2007-06-12 19:00:00	NVDA	Stock	0.606	0.606	0.606	0.606	60000.0
2007-06-12 07:00:00	AMZN	Stock	3.55	3.55	3.545	3.545	7600.0
2007-06-12 08:00:00	AMZN	Stock	3.55	3.555	3.525	3.5275	436580.0
2007-06-12 09:00:00	AMZN	Stock	3.526	3.538	3.506	3.5075	31739800.0
2007-06-12 10:00:00	AMZN	Stock	3.508	3.5225	3.4775	3.485	49459040.0
2007-06-12 11:00:00	AMZN	Stock	3.4855	3.5135	3.471	3.5115	36162200.0
2007-06-12 12:00:00	AMZN	Stock	3.512	3.521	3.503	3.5095	15454300.0
2007-06-12 13:00:00	AMZN	Stock	3.509	3.5315	3.4915	3.524	24099720.0
2007-06-12 14:00:00	AMZN	Stock	3.5235	3.535	3.496	3.5145	22484540.0
2007-06-12 15:00:00	AMZN	Stock	3.5145	3.519	3.489	3.504	38694680.0
2007-06-12 16:00:00	AMZN	Stock	3.5035	3.5229	3.4975	3.4985	8148180.0
2007-06-12 17:00:00	AMZN	Stock	3.5	3.5035	3.4975	3.4975	435420.0
2007-06-12 18:00:00	AMZN	Stock	3.499	3.504	3.4975	3.504	97380.0
2007-06-12 19:00:00	AMZN	Stock	3.4975	3.5075	3.4875	3.4875	165480.0
2007-06-12 09:00:00	TLT	Stock	82.91	83.02	82.82	82.97	858800.0
2007-06-12 10:00:00	TLT	Stock	82.97	83.0	82.2	82.85	1518800.0
2007-06-12 11:00:00	TLT	Stock	82.84	82.97	82.78	82.94	427500.0
2007-06-12 12:00:00	TLT	Stock	82.94	82.97	82.75	82.77	362826.0
2007-06-12 13:00:00	TLT	Stock	82.78	83.42	82.62	83.04	2205920.0
2007-06-12 14:00:00	TLT	Stock	83.05	83.05	82.44	82.56	2044400.0
2007-06-12 15:00:00	TLT	Stock	82.56	82.56	82.3	82.44	1403600.0
2007-06-12 16:00:00	TLT	Stock	82.44	82.44	82.35	82.35	21900.0
2007-06-12 09:00:00	CL	Stock	33.61	33.61	33.42	33.525	335000.0
2007-06-12 10:00:00	CL	Stock	33.53	33.63	33.51	33.55	674400.0

> showing 50 of 36,780 rows — these rows as CSV

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