PREVIEW / stock_1hour / 2007-09-05

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-09-05.parquet
  size:    767 KB
  rows:    38,311
  symbols: 3,102

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-05 09:00:00	AAPL	Stock	5.1775	5.2086	5.1171	5.1521	223580868.0
2007-09-05 10:00:00	AAPL	Stock	5.1525	5.1864	5.1386	5.1851	185063536.0
2007-09-05 11:00:00	AAPL	Stock	5.185	5.1857	5.1332	5.1614	153331248.0
2007-09-05 12:00:00	AAPL	Stock	5.1614	5.1775	5.1389	5.1532	113550976.0
2007-09-05 13:00:00	AAPL	Stock	5.1529	5.1686	4.9286	5.0725	518733544.0
2007-09-05 14:00:00	AAPL	Stock	5.0721	5.0825	4.9179	4.9721	464528484.0
2007-09-05 15:00:00	AAPL	Stock	4.9707	4.9946	4.8607	4.8843	456041488.0
2007-09-05 16:00:00	AAPL	Stock	4.885	4.8854	4.8836	4.8843	11846156.0
2007-09-05 09:00:00	MSFT	Stock	28.65	28.73	28.58	28.59	3293647.0
2007-09-05 10:00:00	MSFT	Stock	28.59	28.63	28.48	28.55	5513603.0
2007-09-05 11:00:00	MSFT	Stock	28.55	28.57	28.42	28.56	4845557.0
2007-09-05 12:00:00	MSFT	Stock	28.57	28.65	28.5	28.65	3330359.0
2007-09-05 13:00:00	MSFT	Stock	28.65	28.65	28.47	28.47	4078557.0
2007-09-05 14:00:00	MSFT	Stock	28.47	28.52	28.43	28.5	5501815.0
2007-09-05 15:00:00	MSFT	Stock	28.49	28.58	28.44	28.47	8644680.0
2007-09-05 16:00:00	MSFT	Stock	28.47	28.48	28.47	28.48	2214238.0
2007-09-05 08:00:00	NVDA	Stock	0.8733	0.879	0.8667	0.879	746040.0
2007-09-05 09:00:00	NVDA	Stock	0.8685	0.9	0.8683	0.8942	100339920.0
2007-09-05 10:00:00	NVDA	Stock	0.8942	0.8942	0.8788	0.8845	116435580.0
2007-09-05 11:00:00	NVDA	Stock	0.8842	0.8853	0.8767	0.881	96318540.0
2007-09-05 12:00:00	NVDA	Stock	0.8808	0.885	0.8792	0.8818	52386300.0
2007-09-05 13:00:00	NVDA	Stock	0.8815	0.8842	0.8772	0.8792	54624480.0
2007-09-05 14:00:00	NVDA	Stock	0.8788	0.8802	0.8722	0.8763	75451560.0
2007-09-05 15:00:00	NVDA	Stock	0.8763	0.88	0.8717	0.8725	100123140.0
2007-09-05 16:00:00	NVDA	Stock	0.8723	0.8748	0.8718	0.8748	22040760.0
2007-09-05 17:00:00	NVDA	Stock	0.8748	0.8752	0.8748	0.8752	127200.0
2007-09-05 18:00:00	NVDA	Stock	0.8775	0.8778	0.8775	0.8775	60000.0
2007-09-05 19:00:00	NVDA	Stock	0.8775	0.878	0.8758	0.878	606660.0
2007-09-05 07:00:00	AMZN	Stock	4.15	4.1895	4.1345	4.145	267800.0
2007-09-05 08:00:00	AMZN	Stock	4.1475	4.1475	4.1185	4.122	704960.0
2007-09-05 09:00:00	AMZN	Stock	4.12	4.237	4.111	4.1926	32585420.0
2007-09-05 10:00:00	AMZN	Stock	4.193	4.2445	4.1705	4.236	36767660.0
2007-09-05 11:00:00	AMZN	Stock	4.236	4.236	4.1645	4.1949	24129440.0
2007-09-05 12:00:00	AMZN	Stock	4.195	4.23	4.192	4.2245	12991780.0
2007-09-05 13:00:00	AMZN	Stock	4.2245	4.2395	4.2	4.2165	16324580.0
2007-09-05 14:00:00	AMZN	Stock	4.217	4.225	4.1645	4.1885	22752920.0
2007-09-05 15:00:00	AMZN	Stock	4.1885	4.2095	4.1735	4.1825	22141340.0
2007-09-05 16:00:00	AMZN	Stock	4.178	4.19	4.175	4.19	729900.0
2007-09-05 18:00:00	AMZN	Stock	4.1875	4.19	4.1875	4.1875	36060.0
2007-09-05 19:00:00	AMZN	Stock	4.1875	4.1895	4.186	4.1895	15560.0
2007-09-05 09:00:00	TLT	Stock	88.76	88.83	88.72	88.8	65000.0
2007-09-05 10:00:00	TLT	Stock	88.82	89.23	88.81	89.19	314900.0
2007-09-05 11:00:00	TLT	Stock	89.2	89.35	89.17	89.25	94700.0
2007-09-05 12:00:00	TLT	Stock	89.26	89.29	89.18	89.18	187300.0
2007-09-05 13:00:00	TLT	Stock	89.18	89.22	89.17	89.2	49500.0
2007-09-05 14:00:00	TLT	Stock	89.2	89.26	89.15	89.23	261200.0
2007-09-05 15:00:00	TLT	Stock	89.24	89.31	89.17	89.27	242700.0
2007-09-05 16:00:00	TLT	Stock	89.31	89.31	89.27	89.27	2000.0
2007-09-05 08:00:00	CL	Stock	32.945	32.945	32.945	32.945	1200.0
2007-09-05 09:00:00	CL	Stock	32.75	32.75	32.5	32.63	520000.0

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

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