PREVIEW / stock_1hour / 2009-11-12

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-11-12.parquet
  size:    889 KB
  rows:    42,453
  symbols: 3,401

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-11-12 05:00:00	AAPL	Stock	7.2379	7.2571	7.2379	7.2571	9688.0
2009-11-12 07:00:00	AAPL	Stock	7.25	7.25	7.2232	7.2239	75768.0
2009-11-12 08:00:00	AAPL	Stock	7.2182	7.2529	7.2182	7.2436	658420.0
2009-11-12 09:00:00	AAPL	Stock	7.2425	7.3168	7.2425	7.3079	56388724.0
2009-11-12 10:00:00	AAPL	Stock	7.3089	7.3146	7.2643	7.2836	61300652.0
2009-11-12 11:00:00	AAPL	Stock	7.2836	7.3132	7.25	7.2629	56733908.0
2009-11-12 12:00:00	AAPL	Stock	7.2629	7.2836	7.2518	7.2725	22506624.0
2009-11-12 13:00:00	AAPL	Stock	7.2718	7.2768	7.2464	7.265	28101164.0
2009-11-12 14:00:00	AAPL	Stock	7.2643	7.2768	7.2332	7.2368	30603608.0
2009-11-12 15:00:00	AAPL	Stock	7.2368	7.2425	7.1939	7.2143	84443996.0
2009-11-12 16:00:00	AAPL	Stock	7.2143	7.3137	7.2043	7.2179	10667972.0
2009-11-12 17:00:00	AAPL	Stock	7.2161	7.2161	7.2039	7.2039	178948.0
2009-11-12 18:00:00	AAPL	Stock	7.2089	7.2589	7.2043	7.2139	5608960.0
2009-11-12 19:00:00	AAPL	Stock	7.2171	7.2186	7.2139	7.2139	113204.0
2009-11-12 07:00:00	MSFT	Stock	29.0	29.0	29.0	29.0	200.0
2009-11-12 08:00:00	MSFT	Stock	29.1	29.12	29.0	29.08	5556.0
2009-11-12 09:00:00	MSFT	Stock	29.05	29.49	29.0	29.47	7545980.0
2009-11-12 10:00:00	MSFT	Stock	29.46	29.49	29.31	29.33	8162206.0
2009-11-12 11:00:00	MSFT	Stock	29.32	29.45	29.3	29.387	6225929.0
2009-11-12 12:00:00	MSFT	Stock	29.39	29.4	29.33	29.35	4335973.0
2009-11-12 13:00:00	MSFT	Stock	29.36	29.4	29.32	29.37	5126683.0
2009-11-12 14:00:00	MSFT	Stock	29.37	29.39	29.34	29.39	3706363.0
2009-11-12 15:00:00	MSFT	Stock	29.39	29.42	29.34	29.37	15826212.0
2009-11-12 16:00:00	MSFT	Stock	29.37	29.514	29.33	29.48	2580080.0
2009-11-12 17:00:00	MSFT	Stock	29.47	29.5	29.42	29.45	34857.0
2009-11-12 18:00:00	MSFT	Stock	29.39	29.44	29.39	29.44	12525.0
2009-11-12 19:00:00	MSFT	Stock	29.49	29.5	29.43	29.43	7394.0
2009-11-12 08:00:00	NVDA	Stock	0.3402	0.3402	0.3353	0.3353	31600.0
2009-11-12 09:00:00	NVDA	Stock	0.338	0.3462	0.3378	0.345	93435760.0
2009-11-12 10:00:00	NVDA	Stock	0.345	0.3455	0.3395	0.3405	122254760.0
2009-11-12 11:00:00	NVDA	Stock	0.3405	0.3414	0.3373	0.3385	66083760.0
2009-11-12 12:00:00	NVDA	Stock	0.3385	0.34	0.3375	0.338	50135440.0
2009-11-12 13:00:00	NVDA	Stock	0.338	0.3382	0.3355	0.3366	39361560.0
2009-11-12 14:00:00	NVDA	Stock	0.3365	0.3385	0.3362	0.3369	38824920.0
2009-11-12 15:00:00	NVDA	Stock	0.3368	0.3378	0.336	0.3365	80460680.0
2009-11-12 16:00:00	NVDA	Stock	0.3365	0.3396	0.3355	0.3358	12362400.0
2009-11-12 17:00:00	NVDA	Stock	0.339	0.339	0.3362	0.3362	44000.0
2009-11-12 08:00:00	AMZN	Stock	6.463	6.4955	6.463	6.4785	51820.0
2009-11-12 09:00:00	AMZN	Stock	6.4785	6.5915	6.4785	6.584	24644400.0
2009-11-12 10:00:00	AMZN	Stock	6.5845	6.6075	6.53	6.593	32286420.0
2009-11-12 11:00:00	AMZN	Stock	6.5905	6.5915	6.524	6.5339	23557000.0
2009-11-12 12:00:00	AMZN	Stock	6.5325	6.5725	6.5315	6.5545	11028840.0
2009-11-12 13:00:00	AMZN	Stock	6.5555	6.561	6.531	6.553	12640560.0
2009-11-12 14:00:00	AMZN	Stock	6.5535	6.5605	6.532	6.535	11269260.0
2009-11-12 15:00:00	AMZN	Stock	6.535	6.5495	6.505	6.525	24644660.0
2009-11-12 16:00:00	AMZN	Stock	6.533	6.553	6.5245	6.536	2838220.0
2009-11-12 17:00:00	AMZN	Stock	6.536	6.536	6.5185	6.5225	150500.0
2009-11-12 18:00:00	AMZN	Stock	6.5315	6.535	6.525	6.5345	66060.0
2009-11-12 19:00:00	AMZN	Stock	6.5375	6.5375	6.5375	6.5375	2000.0
2009-11-12 08:00:00	TLT	Stock	93.32	93.36	93.1	93.1	7700.0

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

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