PREVIEW / stock_1hour / 2010-08-04

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-08-04.parquet
  size:    907 KB
  rows:    43,521
  symbols: 3,491

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
2010-08-04 05:00:00	AAPL	Stock	9.3214	9.3214	9.3214	9.3214	3948.0
2010-08-04 07:00:00	AAPL	Stock	9.3632	9.3632	9.3343	9.3393	86380.0
2010-08-04 08:00:00	AAPL	Stock	9.335	9.3814	9.3214	9.3625	2011884.0
2010-08-04 09:00:00	AAPL	Stock	9.3625	9.4321	9.3625	9.4146	61993960.0
2010-08-04 10:00:00	AAPL	Stock	9.4146	9.4386	9.2968	9.3354	129555216.0
2010-08-04 11:00:00	AAPL	Stock	9.3357	9.3918	9.3339	9.3479	49829276.0
2010-08-04 12:00:00	AAPL	Stock	9.3482	9.3929	9.3482	9.3796	33624948.0
2010-08-04 13:00:00	AAPL	Stock	9.3796	9.3857	9.3464	9.3618	33207776.0
2010-08-04 14:00:00	AAPL	Stock	9.3621	9.3993	9.3608	9.3822	37429728.0
2010-08-04 15:00:00	AAPL	Stock	9.3832	9.3949	9.37	9.3907	63029456.0
2010-08-04 16:00:00	AAPL	Stock	9.3911	9.3946	9.3564	9.3936	7453292.0
2010-08-04 17:00:00	AAPL	Stock	9.3546	9.3929	9.3546	9.3882	84644.0
2010-08-04 18:00:00	AAPL	Stock	9.3893	9.3921	9.3804	9.3854	257656.0
2010-08-04 19:00:00	AAPL	Stock	9.3854	9.3911	9.3839	9.3911	64904.0
2010-08-04 08:00:00	MSFT	Stock	26.11	26.26	26.09	26.23	14271.0
2010-08-04 09:00:00	MSFT	Stock	26.24	26.25	25.71	25.71	10140205.0
2010-08-04 10:00:00	MSFT	Stock	25.72	25.81	25.44	25.675	20597394.0
2010-08-04 11:00:00	MSFT	Stock	25.68	25.78	25.61	25.67	9226396.0
2010-08-04 12:00:00	MSFT	Stock	25.67	25.71	25.61	25.689	6954309.0
2010-08-04 13:00:00	MSFT	Stock	25.685	25.71	25.54	25.565	6900935.0
2010-08-04 14:00:00	MSFT	Stock	25.56	25.68	25.54	25.66	7392215.0
2010-08-04 15:00:00	MSFT	Stock	25.66	25.8	25.63	25.73	14569186.0
2010-08-04 16:00:00	MSFT	Stock	25.73	25.78	25.58	25.75	2053607.0
2010-08-04 17:00:00	MSFT	Stock	26.16	26.16	25.74	25.75	2500.0
2010-08-04 18:00:00	MSFT	Stock	25.75	25.75	25.73	25.74	27042.0
2010-08-04 19:00:00	MSFT	Stock	25.75	25.75	25.67	25.67	16908.0
2010-08-04 05:00:00	NVDA	Stock	0.2243	0.2243	0.2243	0.2243	16000.0
2010-08-04 08:00:00	NVDA	Stock	0.2243	0.226	0.224	0.2258	659880.0
2010-08-04 09:00:00	NVDA	Stock	0.2252	0.229	0.2245	0.226	93830360.0
2010-08-04 10:00:00	NVDA	Stock	0.226	0.2283	0.225	0.2263	164384600.0
2010-08-04 11:00:00	NVDA	Stock	0.2263	0.2295	0.226	0.228	105327440.0
2010-08-04 12:00:00	NVDA	Stock	0.228	0.2292	0.228	0.229	60094760.0
2010-08-04 13:00:00	NVDA	Stock	0.229	0.2315	0.2288	0.2312	107249960.0
2010-08-04 14:00:00	NVDA	Stock	0.2314	0.233	0.231	0.233	83755520.0
2010-08-04 15:00:00	NVDA	Stock	0.2328	0.2338	0.2328	0.233	229872200.0
2010-08-04 16:00:00	NVDA	Stock	0.2328	0.2338	0.2298	0.2332	2304880.0
2010-08-04 17:00:00	NVDA	Stock	0.233	0.2338	0.2325	0.2338	131400.0
2010-08-04 18:00:00	NVDA	Stock	0.2335	0.2338	0.2332	0.2338	197200.0
2010-08-04 19:00:00	NVDA	Stock	0.2332	0.2332	0.2328	0.233	74400.0
2010-08-04 08:00:00	AMZN	Stock	6.138	6.1725	6.1085	6.17	182140.0
2010-08-04 09:00:00	AMZN	Stock	6.16	6.276	6.15	6.2745	25379460.0
2010-08-04 10:00:00	AMZN	Stock	6.276	6.325	6.246	6.2895	37480280.0
2010-08-04 11:00:00	AMZN	Stock	6.289	6.2985	6.2655	6.2956	13007520.0
2010-08-04 12:00:00	AMZN	Stock	6.2955	6.3985	6.2915	6.3843	29731480.0
2010-08-04 13:00:00	AMZN	Stock	6.3845	6.39	6.351	6.3775	18790360.0
2010-08-04 14:00:00	AMZN	Stock	6.378	6.4235	6.372	6.379	30308620.0
2010-08-04 15:00:00	AMZN	Stock	6.3795	6.4015	6.3715	6.3775	27008580.0
2010-08-04 16:00:00	AMZN	Stock	6.3775	6.3839	6.2792	6.377	3185600.0
2010-08-04 17:00:00	AMZN	Stock	6.121	6.375	6.121	6.37	16600.0
2010-08-04 18:00:00	AMZN	Stock	6.3775	6.3825	6.3775	6.3775	306480.0

> showing 50 of 43,521 rows — these rows as CSV

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