PREVIEW / stock_1hour / 2010-12-20

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-12-20.parquet
  size:    976 KB
  rows:    47,107
  symbols: 3,556

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-12-20 04:00:00	AAPL	Stock	11.4686	11.5	11.4643	11.4643	28000.0
2010-12-20 06:00:00	AAPL	Stock	11.4746	11.475	11.4654	11.4654	36400.0
2010-12-20 07:00:00	AAPL	Stock	11.4768	11.4904	11.4657	11.4757	263480.0
2010-12-20 08:00:00	AAPL	Stock	11.4786	11.4857	11.4661	11.4714	1260000.0
2010-12-20 09:00:00	AAPL	Stock	11.4714	11.4857	11.4329	11.4475	42904456.0
2010-12-20 10:00:00	AAPL	Stock	11.4475	11.4857	11.3654	11.3757	68469324.0
2010-12-20 11:00:00	AAPL	Stock	11.375	11.4521	11.3696	11.4489	39331320.0
2010-12-20 12:00:00	AAPL	Stock	11.4489	11.4725	11.4196	11.4721	31880940.0
2010-12-20 13:00:00	AAPL	Stock	11.4712	11.5054	11.4712	11.4921	48799520.0
2010-12-20 14:00:00	AAPL	Stock	11.4921	11.5446	11.4893	11.5214	50136940.0
2010-12-20 15:00:00	AAPL	Stock	11.5218	11.5364	11.4911	11.5071	62409872.0
2010-12-20 16:00:00	AAPL	Stock	11.5071	11.5161	11.4312	11.4946	33493628.0
2010-12-20 17:00:00	AAPL	Stock	11.4954	11.5057	11.4954	11.5057	273504.0
2010-12-20 18:00:00	AAPL	Stock	11.5043	11.5089	11.4875	11.4882	914676.0
2010-12-20 19:00:00	AAPL	Stock	11.4882	11.4932	11.4796	11.4929	604016.0
2010-12-20 07:00:00	MSFT	Stock	27.95	27.95	27.95	27.95	2000.0
2010-12-20 08:00:00	MSFT	Stock	27.91	28.0	27.91	27.99	39050.0
2010-12-20 09:00:00	MSFT	Stock	27.96	27.99	27.83	27.904	4762674.0
2010-12-20 10:00:00	MSFT	Stock	27.9	27.91	27.76	27.79	5485953.0
2010-12-20 11:00:00	MSFT	Stock	27.78	27.86	27.68	27.85	4728513.0
2010-12-20 12:00:00	MSFT	Stock	27.85	27.88	27.78	27.855	4215033.0
2010-12-20 13:00:00	MSFT	Stock	27.86	27.895	27.84	27.885	3298345.0
2010-12-20 14:00:00	MSFT	Stock	27.885	27.99	27.88	27.92	5938319.0
2010-12-20 15:00:00	MSFT	Stock	27.92	27.93	27.81	27.81	9416865.0
2010-12-20 16:00:00	MSFT	Stock	27.81	27.92	27.79	27.871	13669294.0
2010-12-20 17:00:00	MSFT	Stock	27.79	27.88	27.79	27.88	1750.0
2010-12-20 18:00:00	MSFT	Stock	27.81	27.88	27.81	27.88	145721.0
2010-12-20 19:00:00	MSFT	Stock	27.88	28.041	27.88	27.89	2170.0
2010-12-20 07:00:00	NVDA	Stock	0.3625	0.3625	0.3625	0.3625	46360.0
2010-12-20 08:00:00	NVDA	Stock	0.363	0.3632	0.363	0.363	18000.0
2010-12-20 09:00:00	NVDA	Stock	0.365	0.365	0.3578	0.3588	50303920.0
2010-12-20 10:00:00	NVDA	Stock	0.359	0.3595	0.3575	0.358	55002840.0
2010-12-20 11:00:00	NVDA	Stock	0.358	0.3618	0.3578	0.3602	47332040.0
2010-12-20 12:00:00	NVDA	Stock	0.3603	0.361	0.359	0.3605	36076800.0
2010-12-20 13:00:00	NVDA	Stock	0.3605	0.361	0.3591	0.3595	32048640.0
2010-12-20 14:00:00	NVDA	Stock	0.3592	0.3612	0.359	0.3591	42359680.0
2010-12-20 15:00:00	NVDA	Stock	0.3591	0.3595	0.3578	0.358	69909880.0
2010-12-20 16:00:00	NVDA	Stock	0.3578	0.3596	0.3577	0.3588	9807280.0
2010-12-20 17:00:00	NVDA	Stock	0.3588	0.3588	0.3578	0.3588	266560.0
2010-12-20 18:00:00	NVDA	Stock	0.3578	0.3578	0.3578	0.3578	218720.0
2010-12-20 19:00:00	NVDA	Stock	0.358	0.3595	0.358	0.3595	50000.0
2010-12-20 04:00:00	AMZN	Stock	8.874	8.874	8.874	8.874	18000.0
2010-12-20 05:00:00	AMZN	Stock	8.8835	8.95	8.865	8.915	26000.0
2010-12-20 06:00:00	AMZN	Stock	8.95	8.985	8.9025	8.945	40000.0
2010-12-20 07:00:00	AMZN	Stock	8.9745	8.9745	8.96	8.96	4000.0
2010-12-20 08:00:00	AMZN	Stock	8.96	8.97	8.95	8.955	246380.0
2010-12-20 09:00:00	AMZN	Stock	8.955	9.063	8.902	9.0395	26910240.0
2010-12-20 10:00:00	AMZN	Stock	9.0385	9.0535	8.923	8.95	20959980.0
2010-12-20 11:00:00	AMZN	Stock	8.9485	8.9938	8.9275	8.9915	9181780.0
2010-12-20 12:00:00	AMZN	Stock	8.993	9.0945	8.9845	9.0805	17603820.0

> showing 50 of 47,107 rows — these rows as CSV

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