PREVIEW / stock_1hour / 2010-03-10

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-03-10.parquet
  size:    911 KB
  rows:    43,307
  symbols: 3,452

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
2010-03-10 06:00:00	AAPL	Stock	8.0007	8.0007	8.0007	8.0007	12824.0
2010-03-10 07:00:00	AAPL	Stock	8.0	8.0036	7.9932	8.0	202580.0
2010-03-10 08:00:00	AAPL	Stock	7.9946	8.0164	7.9946	8.0071	3039736.0
2010-03-10 09:00:00	AAPL	Stock	8.0073	8.0318	7.9714	7.9957	82357744.0
2010-03-10 10:00:00	AAPL	Stock	7.9957	8.0302	7.9893	8.0186	89185292.0
2010-03-10 11:00:00	AAPL	Stock	8.0193	8.0343	8.0093	8.0221	62620572.0
2010-03-10 12:00:00	AAPL	Stock	8.0221	8.0314	7.9968	8.0257	58880052.0
2010-03-10 13:00:00	AAPL	Stock	8.0261	8.0407	7.9982	8.0093	59757152.0
2010-03-10 14:00:00	AAPL	Stock	8.01	8.0529	8.0054	8.035	78729980.0
2010-03-10 15:00:00	AAPL	Stock	8.035	8.0446	8.0061	8.03	77637112.0
2010-03-10 16:00:00	AAPL	Stock	8.0307	8.0393	7.965	8.0393	5316080.0
2010-03-10 17:00:00	AAPL	Stock	8.0343	8.0368	8.0307	8.035	142212.0
2010-03-10 18:00:00	AAPL	Stock	8.035	8.035	8.0304	8.0307	95844.0
2010-03-10 19:00:00	AAPL	Stock	8.0321	8.035	8.0196	8.0196	352548.0
2010-03-10 08:00:00	MSFT	Stock	28.92	28.93	28.85	28.9	24467.0
2010-03-10 09:00:00	MSFT	Stock	28.93	28.93	28.8	28.85	3544634.0
2010-03-10 10:00:00	MSFT	Stock	28.85	29.11	28.85	29.01	8742900.0
2010-03-10 11:00:00	MSFT	Stock	29.01	29.08	28.91	28.98	5318841.0
2010-03-10 12:00:00	MSFT	Stock	28.981	29.0	28.87	28.95	5545859.0
2010-03-10 13:00:00	MSFT	Stock	28.95	29.04	28.92	28.955	3541058.0
2010-03-10 14:00:00	MSFT	Stock	28.96	29.04	28.93	28.98	4649363.0
2010-03-10 15:00:00	MSFT	Stock	28.97	29.05	28.91	28.97	9806714.0
2010-03-10 16:00:00	MSFT	Stock	28.97	28.98	28.933	28.97	3144752.0
2010-03-10 17:00:00	MSFT	Stock	29.039	29.039	28.99	28.99	1900.0
2010-03-10 18:00:00	MSFT	Stock	28.96	28.99	28.96	28.99	1826.0
2010-03-10 19:00:00	MSFT	Stock	28.98	28.98	28.95	28.96	5425.0
2010-03-10 09:00:00	NVDA	Stock	0.4375	0.444	0.4375	0.4412	64533200.0
2010-03-10 10:00:00	NVDA	Stock	0.4412	0.4445	0.441	0.441	63003360.0
2010-03-10 11:00:00	NVDA	Stock	0.4412	0.443	0.4395	0.4408	52743480.0
2010-03-10 12:00:00	NVDA	Stock	0.4408	0.441	0.4372	0.4388	54029760.0
2010-03-10 13:00:00	NVDA	Stock	0.4388	0.44	0.4376	0.4382	35399080.0
2010-03-10 14:00:00	NVDA	Stock	0.4382	0.442	0.4378	0.4395	61524720.0
2010-03-10 15:00:00	NVDA	Stock	0.4398	0.4408	0.4372	0.4395	76984800.0
2010-03-10 16:00:00	NVDA	Stock	0.4395	0.4403	0.4385	0.4398	9514760.0
2010-03-10 17:00:00	NVDA	Stock	0.44	0.4415	0.44	0.4415	96000.0
2010-03-10 19:00:00	NVDA	Stock	0.4398	0.4398	0.4398	0.4398	52000.0
2010-03-10 08:00:00	AMZN	Stock	6.45	6.459	6.4375	6.4375	67500.0
2010-03-10 09:00:00	AMZN	Stock	6.4495	6.508	6.424	6.479	14505700.0
2010-03-10 10:00:00	AMZN	Stock	6.48	6.5425	6.47	6.5272	22793720.0
2010-03-10 11:00:00	AMZN	Stock	6.526	6.5425	6.506	6.5249	15481740.0
2010-03-10 12:00:00	AMZN	Stock	6.524	6.5385	6.5105	6.532	12696220.0
2010-03-10 13:00:00	AMZN	Stock	6.5315	6.5425	6.506	6.5115	7985940.0
2010-03-10 14:00:00	AMZN	Stock	6.5105	6.55	6.506	6.5335	11684240.0
2010-03-10 15:00:00	AMZN	Stock	6.5325	6.5585	6.5165	6.5255	25400980.0
2010-03-10 16:00:00	AMZN	Stock	6.5255	6.5356	6.5186	6.5315	314380.0
2010-03-10 17:00:00	AMZN	Stock	6.53	6.53	6.53	6.53	15580.0
2010-03-10 18:00:00	AMZN	Stock	6.5245	6.537	6.5245	6.535	50600.0
2010-03-10 19:00:00	AMZN	Stock	6.535	6.537	6.5305	6.537	17000.0
2010-03-10 07:00:00	TLT	Stock	89.65	89.65	89.65	89.65	100.0
2010-03-10 08:00:00	TLT	Stock	89.49	89.63	89.49	89.63	700.0

> showing 50 of 43,307 rows — these rows as CSV

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