PREVIEW / stock_1hour / 2009-04-30

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-04-30.parquet
  size:    871 KB
  rows:    42,683
  symbols: 3,340

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
2009-04-30 04:00:00	AAPL	Stock	4.5046	4.5332	4.5046	4.5286	19600.0
2009-04-30 07:00:00	AAPL	Stock	4.5204	4.5321	4.5054	4.5179	240520.0
2009-04-30 08:00:00	AAPL	Stock	4.5179	4.5304	4.5093	4.5107	1272292.0
2009-04-30 09:00:00	AAPL	Stock	4.5107	4.5214	4.4643	4.5039	79457252.0
2009-04-30 10:00:00	AAPL	Stock	4.5046	4.5279	4.5032	4.5257	62796860.0
2009-04-30 11:00:00	AAPL	Stock	4.5268	4.5357	4.5118	4.5207	53341736.0
2009-04-30 12:00:00	AAPL	Stock	4.52	4.5296	4.4939	4.5086	52270932.0
2009-04-30 13:00:00	AAPL	Stock	4.5086	4.5196	4.4811	4.4936	52556056.0
2009-04-30 14:00:00	AAPL	Stock	4.4943	4.5046	4.4821	4.4907	51055088.0
2009-04-30 15:00:00	AAPL	Stock	4.4907	4.5029	4.4614	4.4929	98787192.0
2009-04-30 16:00:00	AAPL	Stock	4.4943	4.5206	4.4857	4.4893	34154568.0
2009-04-30 17:00:00	AAPL	Stock	4.4939	4.4939	4.4782	4.4839	117656.0
2009-04-30 18:00:00	AAPL	Stock	4.4939	4.4939	4.4821	4.4875	460712.0
2009-04-30 19:00:00	AAPL	Stock	4.4893	4.4943	4.4857	4.4939	92764.0
2009-04-30 07:00:00	MSFT	Stock	20.5	20.5	20.45	20.45	4300.0
2009-04-30 08:00:00	MSFT	Stock	20.5	20.59	20.45	20.54	88453.0
2009-04-30 09:00:00	MSFT	Stock	20.54	20.92	20.54	20.821	10539653.0
2009-04-30 10:00:00	MSFT	Stock	20.82	21.1	20.74	20.96	14692899.0
2009-04-30 11:00:00	MSFT	Stock	20.95	20.99	20.55	20.57	9999273.0
2009-04-30 12:00:00	MSFT	Stock	20.57	20.59	20.27	20.34	8092323.0
2009-04-30 13:00:00	MSFT	Stock	20.34	20.41	20.19	20.27	8314220.0
2009-04-30 14:00:00	MSFT	Stock	20.26	20.36	20.2	20.305	6515493.0
2009-04-30 15:00:00	MSFT	Stock	20.3	20.44	20.01	20.26	15916024.0
2009-04-30 16:00:00	MSFT	Stock	20.27	20.912	20.23	20.25	7060676.0
2009-04-30 17:00:00	MSFT	Stock	20.26	20.266	20.23	20.25	11844.0
2009-04-30 18:00:00	MSFT	Stock	20.25	20.3	20.25	20.25	3720701.0
2009-04-30 19:00:00	MSFT	Stock	20.26	20.36	20.26	20.27	17620.0
2009-04-30 08:00:00	NVDA	Stock	0.2758	0.2825	0.2758	0.2795	543000.0
2009-04-30 09:00:00	NVDA	Stock	0.2788	0.2825	0.275	0.2812	151098000.0
2009-04-30 10:00:00	NVDA	Stock	0.2815	0.288	0.2812	0.2875	210679000.0
2009-04-30 11:00:00	NVDA	Stock	0.2875	0.295	0.2874	0.2912	205333920.0
2009-04-30 12:00:00	NVDA	Stock	0.2912	0.2912	0.287	0.2885	158823920.0
2009-04-30 13:00:00	NVDA	Stock	0.2885	0.29	0.2838	0.2878	100819040.0
2009-04-30 14:00:00	NVDA	Stock	0.2875	0.29	0.2865	0.2888	99483600.0
2009-04-30 15:00:00	NVDA	Stock	0.289	0.289	0.284	0.287	155743880.0
2009-04-30 16:00:00	NVDA	Stock	0.287	0.288	0.2848	0.287	23536600.0
2009-04-30 17:00:00	NVDA	Stock	0.287	0.287	0.2848	0.2848	112000.0
2009-04-30 18:00:00	NVDA	Stock	0.285	0.287	0.285	0.287	219040.0
2009-04-30 04:00:00	AMZN	Stock	4.0245	4.0395	4.0245	4.0395	10000.0
2009-04-30 07:00:00	AMZN	Stock	4.0495	4.0495	4.025	4.0375	12000.0
2009-04-30 08:00:00	AMZN	Stock	4.0375	4.048	4.0275	4.04	290500.0
2009-04-30 09:00:00	AMZN	Stock	4.0375	4.1335	4.007	4.1	37576940.0
2009-04-30 10:00:00	AMZN	Stock	4.1	4.1225	4.0585	4.095	21640220.0
2009-04-30 11:00:00	AMZN	Stock	4.0945	4.1245	4.0815	4.0965	14262360.0
2009-04-30 12:00:00	AMZN	Stock	4.0955	4.1155	4.0505	4.0628	16098120.0
2009-04-30 13:00:00	AMZN	Stock	4.062	4.067	4.0195	4.0375	16255240.0
2009-04-30 14:00:00	AMZN	Stock	4.0378	4.0715	4.034	4.038	15236740.0
2009-04-30 15:00:00	AMZN	Stock	4.0385	4.0565	3.9945	4.026	35714280.0
2009-04-30 16:00:00	AMZN	Stock	4.026	4.0923	3.9895	4.025	2234920.0
2009-04-30 17:00:00	AMZN	Stock	4.025	4.025	4.025	4.025	10000.0

> showing 50 of 42,683 rows — these rows as CSV

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