PREVIEW / stock_1hour / 2008-03-07

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-03-07.parquet
  size:    795 KB
  rows:    40,115
  symbols: 3,264

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
2008-03-07 07:00:00	AAPL	Stock	4.3607	4.3607	4.3446	4.3589	390432.0
2008-03-07 08:00:00	AAPL	Stock	4.3575	4.3786	4.3032	4.3157	8647744.0
2008-03-07 09:00:00	AAPL	Stock	4.3161	4.3589	4.2739	4.3464	189172844.0
2008-03-07 10:00:00	AAPL	Stock	4.345	4.3921	4.3321	4.3664	223900824.0
2008-03-07 11:00:00	AAPL	Stock	4.3664	4.3757	4.3257	4.3314	131694332.0
2008-03-07 12:00:00	AAPL	Stock	4.3311	4.3382	4.2954	4.3193	109040652.0
2008-03-07 13:00:00	AAPL	Stock	4.3196	4.3209	4.2582	4.2582	128132760.0
2008-03-07 14:00:00	AAPL	Stock	4.2589	4.3129	4.2518	4.3129	150993752.0
2008-03-07 15:00:00	AAPL	Stock	4.3124	4.3868	4.2936	4.3718	271358220.0
2008-03-07 16:00:00	AAPL	Stock	4.3721	4.3746	4.3145	4.3536	16080260.0
2008-03-07 17:00:00	AAPL	Stock	4.3536	4.3725	4.3468	4.36	1244712.0
2008-03-07 18:00:00	AAPL	Stock	4.36	4.3607	4.3507	4.3571	101976.0
2008-03-07 19:00:00	AAPL	Stock	4.3554	4.3554	4.3496	4.3536	146384.0
2008-03-07 07:00:00	MSFT	Stock	27.58	27.62	27.58	27.62	3982.0
2008-03-07 08:00:00	MSFT	Stock	27.6	27.68	27.35	27.44	70388.0
2008-03-07 09:00:00	MSFT	Stock	27.45	27.86	27.31	27.8	9791691.0
2008-03-07 10:00:00	MSFT	Stock	27.81	28.02	27.63	27.95	14359677.0
2008-03-07 11:00:00	MSFT	Stock	27.96	27.982	27.58	27.65	8378886.0
2008-03-07 12:00:00	MSFT	Stock	27.655	27.73	27.61	27.67	5387714.0
2008-03-07 13:00:00	MSFT	Stock	27.67	27.69	27.54	27.56	5807155.0
2008-03-07 14:00:00	MSFT	Stock	27.55	27.76	27.46	27.76	11323108.0
2008-03-07 15:00:00	MSFT	Stock	27.76	28.07	27.62	27.87	19775810.0
2008-03-07 16:00:00	MSFT	Stock	27.89	27.92	27.752	27.87	2623714.0
2008-03-07 17:00:00	MSFT	Stock	27.86	27.89	27.355	27.496	101860.0
2008-03-07 18:00:00	MSFT	Stock	27.85	27.85	27.8	27.83	6000.0
2008-03-07 19:00:00	MSFT	Stock	27.83	27.83	27.82	27.82	3482.0
2008-03-07 08:00:00	NVDA	Stock	0.4975	0.5	0.4868	0.4868	851680.0
2008-03-07 09:00:00	NVDA	Stock	0.487	0.5065	0.4843	0.5045	95980400.0
2008-03-07 10:00:00	NVDA	Stock	0.5048	0.508	0.5008	0.5022	166560480.0
2008-03-07 11:00:00	NVDA	Stock	0.5022	0.5025	0.4918	0.4935	89623040.0
2008-03-07 12:00:00	NVDA	Stock	0.4935	0.4963	0.4885	0.4932	62544240.0
2008-03-07 13:00:00	NVDA	Stock	0.493	0.4932	0.4832	0.4845	73975240.0
2008-03-07 14:00:00	NVDA	Stock	0.4848	0.4898	0.4793	0.4898	94575800.0
2008-03-07 15:00:00	NVDA	Stock	0.4895	0.4972	0.475	0.4888	145998760.0
2008-03-07 16:00:00	NVDA	Stock	0.4892	0.4942	0.4875	0.4888	29348400.0
2008-03-07 17:00:00	NVDA	Stock	0.4888	0.4888	0.4862	0.4862	374600.0
2008-03-07 18:00:00	NVDA	Stock	0.4865	0.4875	0.4865	0.4875	40000.0
2008-03-07 08:00:00	AMZN	Stock	3.13	3.153	3.1	3.101	72600.0
2008-03-07 09:00:00	AMZN	Stock	3.1025	3.1905	3.075	3.1775	25619540.0
2008-03-07 10:00:00	AMZN	Stock	3.177	3.2435	3.1555	3.196	33730380.0
2008-03-07 11:00:00	AMZN	Stock	3.1955	3.2	3.1275	3.1285	26150660.0
2008-03-07 12:00:00	AMZN	Stock	3.1295	3.1715	3.106	3.1585	22951220.0
2008-03-07 13:00:00	AMZN	Stock	3.158	3.16	3.119	3.1198	18613300.0
2008-03-07 14:00:00	AMZN	Stock	3.12	3.166	3.1175	3.166	27303460.0
2008-03-07 15:00:00	AMZN	Stock	3.1665	3.224	3.161	3.2045	49841340.0
2008-03-07 16:00:00	AMZN	Stock	3.2075	3.211	3.169	3.2	4421920.0
2008-03-07 17:00:00	AMZN	Stock	3.2045	3.2045	3.1118	3.1118	78340.0
2008-03-07 18:00:00	AMZN	Stock	3.201	3.201	3.2	3.2	20000.0
2008-03-07 19:00:00	AMZN	Stock	3.198	3.198	3.1975	3.1975	20000.0
2008-03-07 08:00:00	TLT	Stock	92.98	93.43	92.98	93.36	7800.0

> showing 50 of 40,115 rows — these rows as CSV

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