PREVIEW / stock_1hour / 2009-05-08

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-05-08.parquet
  size:    858 KB
  rows:    41,767
  symbols: 3,370

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-05-08 05:00:00	AAPL	Stock	4.6536	4.6536	4.6536	4.6536	5600.0
2009-05-08 06:00:00	AAPL	Stock	4.6607	4.6607	4.6554	4.6554	28000.0
2009-05-08 07:00:00	AAPL	Stock	4.6607	4.6696	4.6386	4.6393	154364.0
2009-05-08 08:00:00	AAPL	Stock	4.6382	4.6604	4.6161	4.6343	1345792.0
2009-05-08 09:00:00	AAPL	Stock	4.635	4.6869	4.5689	4.6495	77067480.0
2009-05-08 10:00:00	AAPL	Stock	4.6475	4.6489	4.5093	4.5396	113292956.0
2009-05-08 11:00:00	AAPL	Stock	4.5396	4.5839	4.5396	4.5618	50887088.0
2009-05-08 12:00:00	AAPL	Stock	4.5604	4.6161	4.5504	4.6143	49299152.0
2009-05-08 13:00:00	AAPL	Stock	4.6144	4.6193	4.5643	4.5878	35376348.0
2009-05-08 14:00:00	AAPL	Stock	4.5864	4.6468	4.5857	4.6389	47412064.0
2009-05-08 15:00:00	AAPL	Stock	4.6396	4.6436	4.6036	4.6154	73486532.0
2009-05-08 16:00:00	AAPL	Stock	4.6157	4.621	4.5625	4.6132	15614032.0
2009-05-08 17:00:00	AAPL	Stock	4.6143	4.6196	4.6125	4.6196	84252.0
2009-05-08 18:00:00	AAPL	Stock	4.6193	4.625	4.6193	4.62	39900.0
2009-05-08 19:00:00	AAPL	Stock	4.6261	4.6264	4.6146	4.6146	30156.0
2009-05-08 04:00:00	MSFT	Stock	19.75	19.75	19.75	19.75	600.0
2009-05-08 06:00:00	MSFT	Stock	19.63	19.63	19.63	19.63	1000.0
2009-05-08 07:00:00	MSFT	Stock	19.61	19.61	19.5	19.5	1400.0
2009-05-08 08:00:00	MSFT	Stock	19.5	19.65	19.46	19.5	25370.0
2009-05-08 09:00:00	MSFT	Stock	19.51	19.64	19.38	19.56	8450558.0
2009-05-08 10:00:00	MSFT	Stock	19.56	19.57	19.24	19.38	13787524.0
2009-05-08 11:00:00	MSFT	Stock	19.38	19.43	19.28	19.32	5006833.0
2009-05-08 12:00:00	MSFT	Stock	19.32	19.37	19.22	19.3	7454490.0
2009-05-08 13:00:00	MSFT	Stock	19.3	19.35	19.14	19.19	6616196.0
2009-05-08 14:00:00	MSFT	Stock	19.19	19.4	19.18	19.39	5608808.0
2009-05-08 15:00:00	MSFT	Stock	19.4	19.63	19.32	19.42	16317011.0
2009-05-08 16:00:00	MSFT	Stock	19.42	19.672	19.26	19.4	3166094.0
2009-05-08 17:00:00	MSFT	Stock	19.4	19.4	19.36	19.4	4443.0
2009-05-08 18:00:00	MSFT	Stock	19.42	19.42	19.36	19.36	14253.0
2009-05-08 19:00:00	MSFT	Stock	19.38	19.44	19.3	19.44	3975.0
2009-05-08 05:00:00	NVDA	Stock	0.2688	0.2688	0.2688	0.2688	40000.0
2009-05-08 08:00:00	NVDA	Stock	0.2685	0.2688	0.2588	0.2643	4288600.0
2009-05-08 09:00:00	NVDA	Stock	0.264	0.2645	0.2438	0.2445	604624760.0
2009-05-08 10:00:00	NVDA	Stock	0.2445	0.246	0.2378	0.2392	543335800.0
2009-05-08 11:00:00	NVDA	Stock	0.239	0.2428	0.2355	0.2358	294347800.0
2009-05-08 12:00:00	NVDA	Stock	0.2358	0.2442	0.2338	0.2412	295955960.0
2009-05-08 13:00:00	NVDA	Stock	0.2412	0.2415	0.2278	0.2289	275147360.0
2009-05-08 14:00:00	NVDA	Stock	0.229	0.2385	0.2278	0.235	364029040.0
2009-05-08 15:00:00	NVDA	Stock	0.235	0.237	0.2278	0.2312	484642120.0
2009-05-08 16:00:00	NVDA	Stock	0.2303	0.2389	0.2285	0.2335	14241160.0
2009-05-08 17:00:00	NVDA	Stock	0.2332	0.2338	0.2325	0.2335	745400.0
2009-05-08 18:00:00	NVDA	Stock	0.2335	0.2342	0.231	0.2332	905040.0
2009-05-08 19:00:00	NVDA	Stock	0.2338	0.2352	0.2315	0.2328	498880.0
2009-05-08 06:00:00	AMZN	Stock	3.9945	4.0	3.9945	4.0	10040.0
2009-05-08 07:00:00	AMZN	Stock	4.025	4.025	4.025	4.025	6000.0
2009-05-08 08:00:00	AMZN	Stock	3.99	4.0125	3.99	3.995	104000.0
2009-05-08 09:00:00	AMZN	Stock	3.988	4.0115	3.9485	3.95	22601980.0
2009-05-08 10:00:00	AMZN	Stock	3.95	3.9645	3.8155	3.8222	45699180.0
2009-05-08 11:00:00	AMZN	Stock	3.8225	3.9675	3.8224	3.8675	21756020.0
2009-05-08 12:00:00	AMZN	Stock	3.868	3.913	3.8565	3.9056	16557460.0

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

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