PREVIEW / stock_1hour / 2007-08-28

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-08-28.parquet
  size:    766 KB
  rows:    38,406
  symbols: 3,099

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-08-28 09:00:00	AAPL	Stock	4.6757	4.7086	4.6514	4.6979	105625940.0
2007-08-28 10:00:00	AAPL	Stock	4.6957	4.7289	4.6627	4.6725	156503228.0
2007-08-28 11:00:00	AAPL	Stock	4.6718	4.6725	4.54	4.5714	246379336.0
2007-08-28 12:00:00	AAPL	Stock	4.5714	4.5986	4.5589	4.5921	112584528.0
2007-08-28 13:00:00	AAPL	Stock	4.5925	4.6321	4.5807	4.6225	97045872.0
2007-08-28 14:00:00	AAPL	Stock	4.6229	4.6293	4.5714	4.5786	142779588.0
2007-08-28 15:00:00	AAPL	Stock	4.5782	4.6236	4.5225	4.5319	197320872.0
2007-08-28 16:00:00	AAPL	Stock	4.5296	4.5329	4.5293	4.5293	14503860.0
2007-08-28 09:00:00	MSFT	Stock	28.3	28.43	28.23	28.29	2289002.0
2007-08-28 10:00:00	MSFT	Stock	28.29	28.39	28.25	28.31	3696282.0
2007-08-28 11:00:00	MSFT	Stock	28.301	28.32	28.21	28.31	3011779.0
2007-08-28 12:00:00	MSFT	Stock	28.3	28.42	28.3	28.4	4620388.0
2007-08-28 13:00:00	MSFT	Stock	28.4	28.41	28.32	28.37	2197729.0
2007-08-28 14:00:00	MSFT	Stock	28.38	28.4	28.15	28.17	3801550.0
2007-08-28 15:00:00	MSFT	Stock	28.178	28.24	27.91	27.93	10013598.0
2007-08-28 16:00:00	MSFT	Stock	27.93	27.93	27.93	27.93	2978236.0
2007-08-28 08:00:00	NVDA	Stock	0.825	0.8263	0.8183	0.8203	781320.0
2007-08-28 09:00:00	NVDA	Stock	0.8225	0.8283	0.8125	0.8178	47240400.0
2007-08-28 10:00:00	NVDA	Stock	0.818	0.8202	0.7977	0.7988	94504140.0
2007-08-28 11:00:00	NVDA	Stock	0.7988	0.799	0.7868	0.79	73094340.0
2007-08-28 12:00:00	NVDA	Stock	0.7898	0.794	0.785	0.7893	53692440.0
2007-08-28 13:00:00	NVDA	Stock	0.7893	0.7893	0.7838	0.7878	40488660.0
2007-08-28 14:00:00	NVDA	Stock	0.788	0.7888	0.7772	0.7787	70667340.0
2007-08-28 15:00:00	NVDA	Stock	0.7787	0.7796	0.7703	0.7723	119029260.0
2007-08-28 16:00:00	NVDA	Stock	0.7723	0.7798	0.7717	0.7798	20252460.0
2007-08-28 17:00:00	NVDA	Stock	0.7787	0.7787	0.7772	0.7773	1986000.0
2007-08-28 18:00:00	NVDA	Stock	0.778	0.778	0.7773	0.778	48000.0
2007-08-28 19:00:00	NVDA	Stock	0.778	0.7792	0.7772	0.7782	68700.0
2007-08-28 08:00:00	AMZN	Stock	3.9155	3.9155	3.905	3.905	146520.0
2007-08-28 09:00:00	AMZN	Stock	3.9025	3.9185	3.8835	3.891	11816300.0
2007-08-28 10:00:00	AMZN	Stock	3.8915	3.9265	3.8585	3.8785	20484560.0
2007-08-28 11:00:00	AMZN	Stock	3.8775	3.8855	3.8535	3.859	11229720.0
2007-08-28 12:00:00	AMZN	Stock	3.858	3.883	3.8535	3.883	7380740.0
2007-08-28 13:00:00	AMZN	Stock	3.8825	3.887	3.8635	3.8795	9630200.0
2007-08-28 14:00:00	AMZN	Stock	3.8805	3.883	3.8355	3.845	12931120.0
2007-08-28 15:00:00	AMZN	Stock	3.8455	3.86	3.804	3.811	28926900.0
2007-08-28 16:00:00	AMZN	Stock	3.811	3.816	3.811	3.816	3897640.0
2007-08-28 17:00:00	AMZN	Stock	3.816	3.8225	3.811	3.8225	2041440.0
2007-08-28 18:00:00	AMZN	Stock	3.8185	3.8225	3.8185	3.8185	6000.0
2007-08-28 19:00:00	AMZN	Stock	3.815	3.815	3.801	3.801	8820.0
2007-08-28 09:00:00	TLT	Stock	88.43	88.46	88.31	88.45	37500.0
2007-08-28 10:00:00	TLT	Stock	88.43	88.47	88.28	88.42	170700.0
2007-08-28 11:00:00	TLT	Stock	88.43	88.74	88.43	88.6	478300.0
2007-08-28 12:00:00	TLT	Stock	88.61	88.62	88.44	88.55	148100.0
2007-08-28 13:00:00	TLT	Stock	88.56	88.56	88.4	88.44	102600.0
2007-08-28 14:00:00	TLT	Stock	88.44	88.58	88.4	88.4	171500.0
2007-08-28 15:00:00	TLT	Stock	88.41	88.56	88.41	88.47	139600.0
2007-08-28 16:00:00	TLT	Stock	88.52	88.52	88.46	88.46	800.0
2007-08-28 09:00:00	CL	Stock	33.045	33.12	32.965	33.03	311000.0
2007-08-28 10:00:00	CL	Stock	33.03	33.04	32.95	32.99	738800.0

> showing 50 of 38,406 rows — these rows as CSV

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