PREVIEW / stock_1hour / 2008-04-25

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-04-25.parquet
  size:    838 KB
  rows:    40,735
  symbols: 3,271

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
2008-04-25 07:00:00	AAPL	Stock	6.0018	6.1607	5.9875	6.0979	1289988.0
2008-04-25 08:00:00	AAPL	Stock	6.0964	6.1318	6.0421	6.1168	9364348.0
2008-04-25 09:00:00	AAPL	Stock	6.1168	6.1182	5.9436	5.9664	192517948.0
2008-04-25 10:00:00	AAPL	Stock	5.9661	6.0732	5.9457	6.0625	215006008.0
2008-04-25 11:00:00	AAPL	Stock	6.0625	6.0661	6.0179	6.0436	117881652.0
2008-04-25 12:00:00	AAPL	Stock	6.0429	6.0554	6.0	6.0289	79072728.0
2008-04-25 13:00:00	AAPL	Stock	6.0289	6.035	5.9682	6.0329	99174096.0
2008-04-25 14:00:00	AAPL	Stock	6.0325	6.0704	6.025	6.0518	100478364.0
2008-04-25 15:00:00	AAPL	Stock	6.0525	6.0875	6.0461	6.0629	131468932.0
2008-04-25 16:00:00	AAPL	Stock	6.0625	6.0714	6.0385	6.0682	20409788.0
2008-04-25 17:00:00	AAPL	Stock	6.0679	6.0691	6.0618	6.0664	11685968.0
2008-04-25 18:00:00	AAPL	Stock	6.0654	6.0675	6.0632	6.0643	392252.0
2008-04-25 19:00:00	AAPL	Stock	6.0643	6.0696	6.0643	6.0679	275660.0
2008-04-25 06:00:00	MSFT	Stock	30.4	30.4	30.4	30.4	500.0
2008-04-25 07:00:00	MSFT	Stock	30.5	30.5	30.19	30.3	40950.0
2008-04-25 08:00:00	MSFT	Stock	30.39	30.53	30.3	30.4	1162883.0
2008-04-25 09:00:00	MSFT	Stock	30.38	30.39	29.85	29.92	39438446.0
2008-04-25 10:00:00	MSFT	Stock	29.93	30.02	29.77	29.908	27781859.0
2008-04-25 11:00:00	MSFT	Stock	29.91	30.0	29.6	29.81	18115743.0
2008-04-25 12:00:00	MSFT	Stock	29.8	29.85	29.74	29.77	7304612.0
2008-04-25 13:00:00	MSFT	Stock	29.77	29.842	29.72	29.79	9613478.0
2008-04-25 14:00:00	MSFT	Stock	29.78	29.81	29.7	29.754	9345074.0
2008-04-25 15:00:00	MSFT	Stock	29.75	29.88	29.68	29.81	25370095.0
2008-04-25 16:00:00	MSFT	Stock	29.82	29.883	29.769	29.85	2698226.0
2008-04-25 17:00:00	MSFT	Stock	29.83	29.91	29.769	29.9	184525.0
2008-04-25 18:00:00	MSFT	Stock	29.91	29.92	29.88	29.9	36397.0
2008-04-25 19:00:00	MSFT	Stock	29.88	29.91	29.86	29.87	18632.0
2008-04-25 08:00:00	NVDA	Stock	0.5025	0.5025	0.4988	0.5	474000.0
2008-04-25 09:00:00	NVDA	Stock	0.5	0.505	0.4932	0.495	65792240.0
2008-04-25 10:00:00	NVDA	Stock	0.4948	0.4958	0.49	0.4928	88129120.0
2008-04-25 11:00:00	NVDA	Stock	0.4928	0.4938	0.4878	0.4928	67183960.0
2008-04-25 12:00:00	NVDA	Stock	0.493	0.4942	0.4902	0.4918	54451520.0
2008-04-25 13:00:00	NVDA	Stock	0.4915	0.4935	0.4885	0.4928	43241080.0
2008-04-25 14:00:00	NVDA	Stock	0.4928	0.498	0.4928	0.4963	71389400.0
2008-04-25 15:00:00	NVDA	Stock	0.4963	0.5043	0.4958	0.5032	109837320.0
2008-04-25 16:00:00	NVDA	Stock	0.5032	0.505	0.495	0.5038	16180440.0
2008-04-25 17:00:00	NVDA	Stock	0.5016	0.505	0.4954	0.5038	30154000.0
2008-04-25 18:00:00	NVDA	Stock	0.5038	0.5038	0.5038	0.5038	4000.0
2008-04-25 19:00:00	NVDA	Stock	0.5038	0.5038	0.5038	0.5038	48000.0
2008-04-25 08:00:00	AMZN	Stock	3.9145	3.915	3.895	3.895	82000.0
2008-04-25 09:00:00	AMZN	Stock	3.895	3.925	3.863	3.8925	20255080.0
2008-04-25 10:00:00	AMZN	Stock	3.8925	3.9585	3.8705	3.945	40105300.0
2008-04-25 11:00:00	AMZN	Stock	3.945	3.95	3.904	3.932	19338880.0
2008-04-25 12:00:00	AMZN	Stock	3.9305	3.932	3.904	3.911	13783480.0
2008-04-25 13:00:00	AMZN	Stock	3.9095	3.9555	3.904	3.9515	16568920.0
2008-04-25 14:00:00	AMZN	Stock	3.951	4.0	3.9495	3.991	22936560.0
2008-04-25 15:00:00	AMZN	Stock	3.991	4.066	3.9865	4.0455	49609320.0
2008-04-25 16:00:00	AMZN	Stock	4.0455	4.0525	3.9558	4.0525	3031220.0
2008-04-25 17:00:00	AMZN	Stock	4.044	4.05	4.0295	4.05	1059300.0
2008-04-25 18:00:00	AMZN	Stock	4.045	4.0455	4.045	4.0455	19600.0

> showing 50 of 40,735 rows — these rows as CSV

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