PREVIEW / stock_1hour / 2008-04-01

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-04-01.parquet
  size:    834 KB
  rows:    41,299
  symbols: 3,266

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-04-01 05:00:00	AAPL	Stock	5.1575	5.1646	5.1575	5.1646	6916.0
2008-04-01 06:00:00	AAPL	Stock	5.1464	5.1696	5.1464	5.1696	9352.0
2008-04-01 07:00:00	AAPL	Stock	5.1911	5.1954	5.175	5.1946	526176.0
2008-04-01 08:00:00	AAPL	Stock	5.1875	5.2232	5.125	5.2161	6158936.0
2008-04-01 09:00:00	AAPL	Stock	5.2161	5.2407	5.1979	5.2104	109766412.0
2008-04-01 10:00:00	AAPL	Stock	5.2114	5.2289	5.1782	5.1886	162381716.0
2008-04-01 11:00:00	AAPL	Stock	5.1882	5.2714	5.1861	5.2692	147047320.0
2008-04-01 12:00:00	AAPL	Stock	5.2693	5.2929	5.2589	5.2661	112514416.0
2008-04-01 13:00:00	AAPL	Stock	5.2668	5.2932	5.2546	5.2696	87191636.0
2008-04-01 14:00:00	AAPL	Stock	5.2704	5.2982	5.2468	5.2729	157021340.0
2008-04-01 15:00:00	AAPL	Stock	5.2725	5.345	5.2718	5.3432	212346176.0
2008-04-01 16:00:00	AAPL	Stock	5.3407	5.35	5.125	5.3464	20468196.0
2008-04-01 17:00:00	AAPL	Stock	5.3464	5.3746	5.2628	5.3675	3797444.0
2008-04-01 18:00:00	AAPL	Stock	5.3671	5.3679	5.2661	5.3543	655844.0
2008-04-01 19:00:00	AAPL	Stock	5.3504	5.3643	5.3504	5.3643	452508.0
2008-04-01 07:00:00	MSFT	Stock	28.4	28.69	28.4	28.61	61197.0
2008-04-01 08:00:00	MSFT	Stock	28.6	28.67	28.38	28.61	133432.0
2008-04-01 09:00:00	MSFT	Stock	28.38	28.84	28.38	28.69	5210318.0
2008-04-01 10:00:00	MSFT	Stock	28.7	29.23	28.69	29.21	13745682.0
2008-04-01 11:00:00	MSFT	Stock	29.21	29.33	29.17	29.23	9676731.0
2008-04-01 12:00:00	MSFT	Stock	29.23	29.3	29.15	29.15	4997123.0
2008-04-01 13:00:00	MSFT	Stock	29.15	29.29	29.09	29.26	5332306.0
2008-04-01 14:00:00	MSFT	Stock	29.26	29.42	29.2	29.38	7305316.0
2008-04-01 15:00:00	MSFT	Stock	29.371	29.54	29.31	29.51	13976232.0
2008-04-01 16:00:00	MSFT	Stock	29.51	29.52	28.38	29.49	3906748.0
2008-04-01 17:00:00	MSFT	Stock	29.49	29.53	29.03	29.49	39583.0
2008-04-01 18:00:00	MSFT	Stock	29.52	29.54	29.04	29.54	15643.0
2008-04-01 19:00:00	MSFT	Stock	29.5	29.54	29.49	29.49	10189.0
2008-04-01 08:00:00	NVDA	Stock	0.4998	0.5062	0.4948	0.5062	2184480.0
2008-04-01 09:00:00	NVDA	Stock	0.5062	0.51	0.5022	0.5045	63123600.0
2008-04-01 10:00:00	NVDA	Stock	0.5043	0.5088	0.504	0.5085	96914360.0
2008-04-01 11:00:00	NVDA	Stock	0.5088	0.519	0.5088	0.5185	100428000.0
2008-04-01 12:00:00	NVDA	Stock	0.5185	0.5235	0.516	0.517	73045160.0
2008-04-01 13:00:00	NVDA	Stock	0.5173	0.5225	0.517	0.5198	58185240.0
2008-04-01 14:00:00	NVDA	Stock	0.5198	0.5262	0.5192	0.5222	81644040.0
2008-04-01 15:00:00	NVDA	Stock	0.5222	0.5253	0.5202	0.5242	162126000.0
2008-04-01 16:00:00	NVDA	Stock	0.525	0.525	0.4948	0.5235	20589560.0
2008-04-01 17:00:00	NVDA	Stock	0.525	0.525	0.5062	0.5072	14159320.0
2008-04-01 18:00:00	NVDA	Stock	0.524	0.525	0.5238	0.5238	160000.0
2008-04-01 19:00:00	NVDA	Stock	0.5272	0.5272	0.527	0.527	16000.0
2008-04-01 08:00:00	AMZN	Stock	3.565	3.6245	3.565	3.6245	281020.0
2008-04-01 09:00:00	AMZN	Stock	3.6125	3.775	3.565	3.741	29937800.0
2008-04-01 10:00:00	AMZN	Stock	3.7415	3.77	3.714	3.745	24258500.0
2008-04-01 11:00:00	AMZN	Stock	3.7455	3.7545	3.7305	3.7398	15274120.0
2008-04-01 12:00:00	AMZN	Stock	3.74	3.748	3.7175	3.7305	17349360.0
2008-04-01 13:00:00	AMZN	Stock	3.731	3.7575	3.7125	3.7225	14638920.0
2008-04-01 14:00:00	AMZN	Stock	3.724	3.7535	3.7075	3.734	20070020.0
2008-04-01 15:00:00	AMZN	Stock	3.7345	3.8545	3.7335	3.835	59109000.0
2008-04-01 16:00:00	AMZN	Stock	3.8375	3.84	3.6495	3.8345	11081460.0
2008-04-01 17:00:00	AMZN	Stock	3.835	3.835	3.825	3.835	69580.0

> showing 50 of 41,299 rows — these rows as CSV

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