PREVIEW / stock_1hour / 2009-04-24

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-04-24.parquet
  size:    819 KB
  rows:    40,041
  symbols: 3,337

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-24 07:00:00	AAPL	Stock	4.47	4.5107	4.47	4.5	82936.0
2009-04-24 08:00:00	AAPL	Stock	4.5	4.5068	4.4679	4.4857	853608.0
2009-04-24 09:00:00	AAPL	Stock	4.4857	4.49	4.4189	4.435	78852284.0
2009-04-24 10:00:00	AAPL	Stock	4.4364	4.4607	4.4214	4.4343	76796496.0
2009-04-24 11:00:00	AAPL	Stock	4.4339	4.4557	4.425	4.4496	44313080.0
2009-04-24 12:00:00	AAPL	Stock	4.4496	4.4536	4.4289	4.4496	46726036.0
2009-04-24 13:00:00	AAPL	Stock	4.4507	4.4636	4.4286	4.4314	43239224.0
2009-04-24 14:00:00	AAPL	Stock	4.4321	4.4532	4.4	4.4257	96090008.0
2009-04-24 15:00:00	AAPL	Stock	4.4264	4.4357	4.3918	4.4246	134534092.0
2009-04-24 16:00:00	AAPL	Stock	4.42	4.4303	4.4061	4.4204	13609764.0
2009-04-24 17:00:00	AAPL	Stock	4.4239	4.4239	4.4146	4.4179	41748.0
2009-04-24 18:00:00	AAPL	Stock	4.425	4.425	4.4164	4.4221	707616.0
2009-04-24 19:00:00	AAPL	Stock	4.4221	4.4221	4.4214	4.4214	50596.0
2009-04-24 04:00:00	MSFT	Stock	19.5	19.5	19.5	19.5	200.0
2009-04-24 05:00:00	MSFT	Stock	19.71	19.74	19.65	19.65	1900.0
2009-04-24 06:00:00	MSFT	Stock	19.74	19.74	19.7	19.7	2500.0
2009-04-24 07:00:00	MSFT	Stock	19.69	19.83	19.69	19.76	50511.0
2009-04-24 08:00:00	MSFT	Stock	19.76	19.99	19.67	19.74	693435.0
2009-04-24 09:00:00	MSFT	Stock	19.75	20.38	19.5	20.29	27869283.0
2009-04-24 10:00:00	MSFT	Stock	20.29	20.45	20.1	20.32	28949117.0
2009-04-24 11:00:00	MSFT	Stock	20.32	20.55	20.23	20.501	15723785.0
2009-04-24 12:00:00	MSFT	Stock	20.51	20.56	20.4	20.53	12181268.0
2009-04-24 13:00:00	MSFT	Stock	20.53	20.62	20.44	20.462	14120690.0
2009-04-24 14:00:00	MSFT	Stock	20.46	20.89	20.34	20.88	19697929.0
2009-04-24 15:00:00	MSFT	Stock	20.89	21.2	20.63	20.89	40412511.0
2009-04-24 16:00:00	MSFT	Stock	20.92	20.96	20.478	20.9	3013864.0
2009-04-24 17:00:00	MSFT	Stock	20.9	20.94	20.85	20.87	15859.0
2009-04-24 18:00:00	MSFT	Stock	20.87	20.91	20.85	20.86	730186.0
2009-04-24 19:00:00	MSFT	Stock	20.87	20.9	20.86	20.87	9802.0
2009-04-24 09:00:00	NVDA	Stock	0.2822	0.2845	0.2752	0.2776	66391800.0
2009-04-24 10:00:00	NVDA	Stock	0.2778	0.2848	0.2763	0.2838	112751800.0
2009-04-24 11:00:00	NVDA	Stock	0.2835	0.2852	0.2812	0.2845	113665920.0
2009-04-24 12:00:00	NVDA	Stock	0.2845	0.2848	0.282	0.2845	67801960.0
2009-04-24 13:00:00	NVDA	Stock	0.2845	0.2855	0.2825	0.2825	78203760.0
2009-04-24 14:00:00	NVDA	Stock	0.2825	0.2872	0.2795	0.2862	155965360.0
2009-04-24 15:00:00	NVDA	Stock	0.2865	0.2878	0.2838	0.2852	149206480.0
2009-04-24 16:00:00	NVDA	Stock	0.2855	0.2882	0.2826	0.2875	12298240.0
2009-04-24 17:00:00	NVDA	Stock	0.2875	0.2875	0.2875	0.2875	48200.0
2009-04-24 18:00:00	NVDA	Stock	0.2875	0.2875	0.2875	0.2875	13000.0
2009-04-24 19:00:00	NVDA	Stock	0.2875	0.2875	0.2875	0.2875	4000.0
2009-04-24 04:00:00	AMZN	Stock	4.1495	4.15	4.1495	4.15	6000.0
2009-04-24 05:00:00	AMZN	Stock	4.15	4.15	4.15	4.15	4000.0
2009-04-24 07:00:00	AMZN	Stock	4.149	4.1575	4.125	4.125	327300.0
2009-04-24 08:00:00	AMZN	Stock	4.125	4.1625	4.1225	4.137	2848080.0
2009-04-24 09:00:00	AMZN	Stock	4.13	4.138	4.0365	4.096	94720640.0
2009-04-24 10:00:00	AMZN	Stock	4.096	4.334	4.095	4.321	145548360.0
2009-04-24 11:00:00	AMZN	Stock	4.3225	4.3325	4.279	4.292	51618100.0
2009-04-24 12:00:00	AMZN	Stock	4.292	4.31	4.28	4.302	28663420.0
2009-04-24 13:00:00	AMZN	Stock	4.301	4.3165	4.1075	4.288	28854700.0
2009-04-24 14:00:00	AMZN	Stock	4.288	4.295	4.2265	4.288	56680180.0

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

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