PREVIEW / stock_1hour / 2010-03-22

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-03-22.parquet
  size:    921 KB
  rows:    43,753
  symbols: 3,490

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-22 04:00:00	AAPL	Stock	7.9	7.9	7.8961	7.8961	12600.0
2010-03-22 05:00:00	AAPL	Stock	7.8982	7.9064	7.8982	7.9064	26600.0
2010-03-22 06:00:00	AAPL	Stock	7.8982	7.9107	7.8982	7.9107	15540.0
2010-03-22 07:00:00	AAPL	Stock	7.8982	7.9089	7.8775	7.8832	163912.0
2010-03-22 08:00:00	AAPL	Stock	7.8775	7.8946	7.8643	7.8864	2302412.0
2010-03-22 09:00:00	AAPL	Stock	7.8857	8.0	7.8571	7.9814	88278204.0
2010-03-22 10:00:00	AAPL	Stock	7.9814	8.0643	7.9614	8.0129	90157900.0
2010-03-22 11:00:00	AAPL	Stock	8.0125	8.0354	8.0057	8.0243	50059716.0
2010-03-22 12:00:00	AAPL	Stock	8.0243	8.0493	8.0118	8.0482	44300116.0
2010-03-22 13:00:00	AAPL	Stock	8.0479	8.0607	8.0418	8.0425	34195868.0
2010-03-22 14:00:00	AAPL	Stock	8.0432	8.0696	8.0339	8.0561	46084416.0
2010-03-22 15:00:00	AAPL	Stock	8.0559	8.0714	8.0189	8.0314	71597400.0
2010-03-22 16:00:00	AAPL	Stock	8.0286	8.057	7.9393	8.0254	24076920.0
2010-03-22 17:00:00	AAPL	Stock	8.025	8.0304	8.0236	8.0286	93268.0
2010-03-22 18:00:00	AAPL	Stock	8.0286	8.0493	8.0261	8.0482	666512.0
2010-03-22 19:00:00	AAPL	Stock	8.0439	8.0482	8.0371	8.0429	148092.0
2010-03-22 20:00:00	AAPL	Stock	8.0014	8.0257	8.0014	8.0257	221648.0
2010-03-22 06:00:00	MSFT	Stock	29.31	29.31	29.3	29.3	241.0
2010-03-22 07:00:00	MSFT	Stock	29.3	29.35	29.3	29.35	300.0
2010-03-22 08:00:00	MSFT	Stock	29.36	29.52	29.35	29.42	31956.0
2010-03-22 09:00:00	MSFT	Stock	29.41	29.58	29.35	29.48	4001525.0
2010-03-22 10:00:00	MSFT	Stock	29.48	29.63	29.4	29.56	5715515.0
2010-03-22 11:00:00	MSFT	Stock	29.558	29.64	29.54	29.59	3556655.0
2010-03-22 12:00:00	MSFT	Stock	29.59	29.6	29.52	29.57	2666673.0
2010-03-22 13:00:00	MSFT	Stock	29.58	29.67	29.57	29.57	4049341.0
2010-03-22 14:00:00	MSFT	Stock	29.57	29.7	29.55	29.643	3172538.0
2010-03-22 15:00:00	MSFT	Stock	29.643	29.68	29.51	29.61	6870122.0
2010-03-22 16:00:00	MSFT	Stock	29.59	29.648	29.53	29.614	5226182.0
2010-03-22 17:00:00	MSFT	Stock	29.59	29.6	29.59	29.6	1100.0
2010-03-22 18:00:00	MSFT	Stock	29.6	29.61	29.59	29.61	3832.0
2010-03-22 19:00:00	MSFT	Stock	29.6	29.63	29.59	29.59	6373.0
2010-03-22 20:00:00	MSFT	Stock	29.54	29.61	29.54	29.61	9145.0
2010-03-22 08:00:00	NVDA	Stock	0.4312	0.4312	0.426	0.4268	212640.0
2010-03-22 09:00:00	NVDA	Stock	0.4268	0.437	0.4253	0.436	62041880.0
2010-03-22 10:00:00	NVDA	Stock	0.436	0.438	0.4318	0.4375	84257760.0
2010-03-22 11:00:00	NVDA	Stock	0.4374	0.44	0.4345	0.4378	47473200.0
2010-03-22 12:00:00	NVDA	Stock	0.4377	0.4382	0.4355	0.4375	32183280.0
2010-03-22 13:00:00	NVDA	Stock	0.4378	0.4398	0.4375	0.438	36785240.0
2010-03-22 14:00:00	NVDA	Stock	0.4382	0.4398	0.4372	0.4385	40375120.0
2010-03-22 15:00:00	NVDA	Stock	0.4387	0.4398	0.4376	0.4382	118749040.0
2010-03-22 16:00:00	NVDA	Stock	0.4382	0.4396	0.4366	0.439	1316240.0
2010-03-22 17:00:00	NVDA	Stock	0.438	0.438	0.438	0.438	28000.0
2010-03-22 19:00:00	NVDA	Stock	0.4398	0.4398	0.4385	0.4398	84000.0
2010-03-22 07:00:00	AMZN	Stock	6.45	6.458	6.45	6.458	15600.0
2010-03-22 08:00:00	AMZN	Stock	6.454	6.4875	6.441	6.475	380620.0
2010-03-22 09:00:00	AMZN	Stock	6.4755	6.524	6.4515	6.4715	20833000.0
2010-03-22 10:00:00	AMZN	Stock	6.472	6.509	6.432	6.48	25467800.0
2010-03-22 11:00:00	AMZN	Stock	6.4815	6.505	6.4665	6.5014	10299980.0
2010-03-22 12:00:00	AMZN	Stock	6.501	6.501	6.478	6.49	7728800.0
2010-03-22 13:00:00	AMZN	Stock	6.491	6.499	6.4855	6.495	9786400.0

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

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