PREVIEW / stock_1hour / 2009-05-12

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-05-12.parquet
  size:    851 KB
  rows:    41,609
  symbols: 3,343

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-12 05:00:00	AAPL	Stock	4.6425	4.6425	4.6425	4.6425	14000.0
2009-05-12 07:00:00	AAPL	Stock	4.6429	4.6429	4.6429	4.6429	42000.0
2009-05-12 08:00:00	AAPL	Stock	4.6339	4.655	4.6289	4.6511	340536.0
2009-05-12 09:00:00	AAPL	Stock	4.6457	4.6493	4.5246	4.5464	90439412.0
2009-05-12 10:00:00	AAPL	Stock	4.5464	4.5771	4.4932	4.5073	110624864.0
2009-05-12 11:00:00	AAPL	Stock	4.5071	4.5214	4.4661	4.4679	72375604.0
2009-05-12 12:00:00	AAPL	Stock	4.4679	4.4696	4.4018	4.4221	79466548.0
2009-05-12 13:00:00	AAPL	Stock	4.4225	4.4689	4.4221	4.4557	48404804.0
2009-05-12 14:00:00	AAPL	Stock	4.4554	4.4836	4.4411	4.4671	64591548.0
2009-05-12 15:00:00	AAPL	Stock	4.4671	4.5839	4.4375	4.445	123492208.0
2009-05-12 16:00:00	AAPL	Stock	4.4446	4.4931	4.4393	4.4643	11871104.0
2009-05-12 17:00:00	AAPL	Stock	4.4639	4.4732	4.4568	4.4568	639212.0
2009-05-12 18:00:00	AAPL	Stock	4.46	4.4636	4.4436	4.4625	1990688.0
2009-05-12 19:00:00	AAPL	Stock	4.4614	4.4636	4.4586	4.4625	213584.0
2009-05-12 08:00:00	MSFT	Stock	19.38	19.57	19.38	19.55	25900.0
2009-05-12 09:00:00	MSFT	Stock	19.53	19.7	19.45	19.59	7438330.0
2009-05-12 10:00:00	MSFT	Stock	19.59	19.82	19.57	19.72	11147620.0
2009-05-12 11:00:00	MSFT	Stock	19.71	19.79	19.68	19.74	6438971.0
2009-05-12 12:00:00	MSFT	Stock	19.74	19.77	19.66	19.76	7181842.0
2009-05-12 13:00:00	MSFT	Stock	19.76	19.83	19.73	19.79	5621624.0
2009-05-12 14:00:00	MSFT	Stock	19.79	19.87	19.75	19.86	11922571.0
2009-05-12 15:00:00	MSFT	Stock	19.86	20.06	19.85	19.89	18840443.0
2009-05-12 16:00:00	MSFT	Stock	19.9	20.05	19.7	20.0	2549901.0
2009-05-12 17:00:00	MSFT	Stock	20.02	20.05	20.01	20.05	82004.0
2009-05-12 18:00:00	MSFT	Stock	20.05	20.05	19.89	20.02	48451.0
2009-05-12 19:00:00	MSFT	Stock	20.03	20.04	20.0	20.03	8187.0
2009-05-12 08:00:00	NVDA	Stock	0.2378	0.2412	0.2378	0.241	192000.0
2009-05-12 09:00:00	NVDA	Stock	0.241	0.241	0.2252	0.2278	146358000.0
2009-05-12 10:00:00	NVDA	Stock	0.2278	0.2283	0.224	0.2258	226368840.0
2009-05-12 11:00:00	NVDA	Stock	0.226	0.2265	0.223	0.2232	171549120.0
2009-05-12 12:00:00	NVDA	Stock	0.2232	0.225	0.2208	0.221	139305120.0
2009-05-12 13:00:00	NVDA	Stock	0.221	0.2225	0.22	0.221	132084840.0
2009-05-12 14:00:00	NVDA	Stock	0.221	0.2243	0.2208	0.223	115626880.0
2009-05-12 15:00:00	NVDA	Stock	0.223	0.2252	0.2223	0.2245	238856400.0
2009-05-12 16:00:00	NVDA	Stock	0.2243	0.2288	0.2243	0.2265	8270280.0
2009-05-12 17:00:00	NVDA	Stock	0.2272	0.2288	0.227	0.2278	2553760.0
2009-05-12 18:00:00	NVDA	Stock	0.2272	0.23	0.2268	0.2295	1372560.0
2009-05-12 19:00:00	NVDA	Stock	0.2288	0.2288	0.227	0.2275	840600.0
2009-05-12 06:00:00	AMZN	Stock	3.95	3.95	3.95	3.95	4000.0
2009-05-12 08:00:00	AMZN	Stock	3.95	3.95	3.945	3.945	45600.0
2009-05-12 09:00:00	AMZN	Stock	3.945	3.9485	3.845	3.888	19373740.0
2009-05-12 10:00:00	AMZN	Stock	3.888	3.897	3.8545	3.8865	13584540.0
2009-05-12 11:00:00	AMZN	Stock	3.887	3.907	3.8455	3.8545	13405880.0
2009-05-12 12:00:00	AMZN	Stock	3.8545	3.863	3.8265	3.841	11597100.0
2009-05-12 13:00:00	AMZN	Stock	3.841	3.8655	3.8375	3.855	11687200.0
2009-05-12 14:00:00	AMZN	Stock	3.8565	3.8978	3.8485	3.886	13281400.0
2009-05-12 15:00:00	AMZN	Stock	3.887	3.9175	3.8825	3.896	25369540.0
2009-05-12 16:00:00	AMZN	Stock	3.896	3.9135	3.8728	3.8965	2127520.0
2009-05-12 17:00:00	AMZN	Stock	3.9025	3.905	3.9025	3.9025	14000.0
2009-05-12 18:00:00	AMZN	Stock	3.9025	3.9025	3.898	3.898	39000.0

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

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