PREVIEW / stock_1hour / 2007-09-07

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-09-07.parquet
  size:    754 KB
  rows:    37,595
  symbols: 3,114

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-09-07 09:00:00	AAPL	Stock	4.7146	4.7182	4.6546	4.68	231109620.0
2007-09-07 10:00:00	AAPL	Stock	4.6814	4.7014	4.6429	4.6518	250381404.0
2007-09-07 11:00:00	AAPL	Stock	4.6529	4.7118	4.65	4.7082	197532328.0
2007-09-07 12:00:00	AAPL	Stock	4.7082	4.725	4.6882	4.7007	122588424.0
2007-09-07 13:00:00	AAPL	Stock	4.7011	4.7204	4.69	4.6929	93308684.0
2007-09-07 14:00:00	AAPL	Stock	4.6929	4.6982	4.6571	4.6596	136180688.0
2007-09-07 15:00:00	AAPL	Stock	4.6593	4.7129	4.6579	4.7082	212746044.0
2007-09-07 16:00:00	AAPL	Stock	4.7075	4.7079	4.7061	4.7061	13467776.0
2007-09-07 09:00:00	MSFT	Stock	28.62	28.83	28.58	28.781	4137489.0
2007-09-07 10:00:00	MSFT	Stock	28.78	28.82	28.54	28.59	5587170.0
2007-09-07 11:00:00	MSFT	Stock	28.6	28.65	28.51	28.59	3852581.0
2007-09-07 12:00:00	MSFT	Stock	28.6	28.6	28.51	28.53	2931641.0
2007-09-07 13:00:00	MSFT	Stock	28.52	28.6	28.48	28.505	2935342.0
2007-09-07 14:00:00	MSFT	Stock	28.5	28.53	28.39	28.4	4857450.0
2007-09-07 15:00:00	MSFT	Stock	28.4	28.46	28.32	28.45	10111378.0
2007-09-07 16:00:00	MSFT	Stock	28.44	28.44	28.44	28.44	2235982.0
2007-09-07 08:00:00	NVDA	Stock	0.8772	0.8797	0.8598	0.8667	423120.0
2007-09-07 09:00:00	NVDA	Stock	0.8667	0.8667	0.8434	0.8503	78067560.0
2007-09-07 10:00:00	NVDA	Stock	0.8505	0.8545	0.8278	0.8327	131285880.0
2007-09-07 11:00:00	NVDA	Stock	0.8328	0.844	0.8315	0.8425	86600880.0
2007-09-07 12:00:00	NVDA	Stock	0.8427	0.8447	0.8373	0.8447	57772680.0
2007-09-07 13:00:00	NVDA	Stock	0.8448	0.8467	0.8378	0.8393	63060780.0
2007-09-07 14:00:00	NVDA	Stock	0.8393	0.8442	0.8375	0.8393	44158980.0
2007-09-07 15:00:00	NVDA	Stock	0.8392	0.8458	0.8385	0.8458	86295660.0
2007-09-07 16:00:00	NVDA	Stock	0.8453	0.8472	0.8442	0.8458	286200.0
2007-09-07 17:00:00	NVDA	Stock	0.8458	0.8467	0.8457	0.8467	150480.0
2007-09-07 19:00:00	NVDA	Stock	0.8458	0.8458	0.8447	0.8447	73500.0
2007-09-07 07:00:00	AMZN	Stock	4.325	4.325	4.275	4.278	35660.0
2007-09-07 08:00:00	AMZN	Stock	4.2725	4.298	4.2405	4.2425	1119860.0
2007-09-07 09:00:00	AMZN	Stock	4.244	4.2545	4.189	4.2175	32842080.0
2007-09-07 10:00:00	AMZN	Stock	4.2175	4.2345	4.177	4.191	37505120.0
2007-09-07 11:00:00	AMZN	Stock	4.192	4.2135	4.1605	4.212	25182260.0
2007-09-07 12:00:00	AMZN	Stock	4.212	4.215	4.188	4.203	9578980.0
2007-09-07 13:00:00	AMZN	Stock	4.2035	4.2175	4.191	4.1951	9689940.0
2007-09-07 14:00:00	AMZN	Stock	4.195	4.2145	4.192	4.192	11418840.0
2007-09-07 15:00:00	AMZN	Stock	4.192	4.2265	4.1885	4.2265	27096200.0
2007-09-07 16:00:00	AMZN	Stock	4.2265	4.2305	4.2155	4.23	336800.0
2007-09-07 17:00:00	AMZN	Stock	4.232	4.2325	4.221	4.221	27800.0
2007-09-07 18:00:00	AMZN	Stock	4.2215	4.2215	4.2215	4.2215	4000.0
2007-09-07 19:00:00	AMZN	Stock	4.22	4.235	4.22	4.225	65000.0
2007-09-07 09:00:00	TLT	Stock	89.75	89.84	89.69	89.84	752400.0
2007-09-07 10:00:00	TLT	Stock	89.84	90.34	89.84	90.34	513500.0
2007-09-07 11:00:00	TLT	Stock	90.35	90.5	90.27	90.34	630065.0
2007-09-07 12:00:00	TLT	Stock	90.34	90.42	90.24	90.24	230400.0
2007-09-07 13:00:00	TLT	Stock	90.25	90.37	90.23	90.32	225500.0
2007-09-07 14:00:00	TLT	Stock	90.33	90.38	90.27	90.34	112600.0
2007-09-07 15:00:00	TLT	Stock	90.32	90.33	90.22	90.3	162400.0
2007-09-07 09:00:00	CL	Stock	32.715	33.08	32.605	32.93	383400.0
2007-09-07 10:00:00	CL	Stock	32.92	32.99	32.82	32.99	534000.0
2007-09-07 11:00:00	CL	Stock	32.995	33.01	32.807	32.8805	579000.0

> showing 50 of 37,595 rows — these rows as CSV

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