PREVIEW / stock_1hour / 2009-04-27

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-04-27.parquet
  size:    828 KB
  rows:    40,810
  symbols: 3,329

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-04-27 04:00:00	AAPL	Stock	4.4107	4.4107	4.3961	4.3961	10080.0
2009-04-27 06:00:00	AAPL	Stock	4.3921	4.3921	4.365	4.365	30800.0
2009-04-27 07:00:00	AAPL	Stock	4.37	4.3857	4.37	4.3857	20132.0
2009-04-27 08:00:00	AAPL	Stock	4.3779	4.4214	4.375	4.3943	557676.0
2009-04-27 09:00:00	AAPL	Stock	4.3929	4.4321	4.3739	4.3982	69267156.0
2009-04-27 10:00:00	AAPL	Stock	4.3989	4.4643	4.3857	4.4604	85778476.0
2009-04-27 11:00:00	AAPL	Stock	4.4614	4.4643	4.4325	4.4475	47863480.0
2009-04-27 12:00:00	AAPL	Stock	4.4475	4.4546	4.4364	4.4435	34711488.0
2009-04-27 13:00:00	AAPL	Stock	4.4439	4.4507	4.43	4.4407	37964220.0
2009-04-27 14:00:00	AAPL	Stock	4.4397	4.4518	4.43	4.4454	44686264.0
2009-04-27 15:00:00	AAPL	Stock	4.4454	4.4643	4.4375	4.4546	99469944.0
2009-04-27 16:00:00	AAPL	Stock	4.4579	4.4589	4.4363	4.4461	16192204.0
2009-04-27 17:00:00	AAPL	Stock	4.4501	4.4568	4.4461	4.4493	58996.0
2009-04-27 18:00:00	AAPL	Stock	4.4479	4.4546	4.4468	4.4468	261408.0
2009-04-27 19:00:00	AAPL	Stock	4.4486	4.4496	4.4461	4.4471	44912.0
2009-04-27 20:00:00	AAPL	Stock	4.4468	4.4468	4.4468	4.4468	20580.0
2009-04-27 06:00:00	MSFT	Stock	20.25	20.3	20.2	20.2	5200.0
2009-04-27 07:00:00	MSFT	Stock	20.27	20.55	20.26	20.51	20674.0
2009-04-27 08:00:00	MSFT	Stock	20.47	20.75	20.47	20.66	83782.0
2009-04-27 09:00:00	MSFT	Stock	20.69	20.84	20.44	20.53	9902923.0
2009-04-27 10:00:00	MSFT	Stock	20.52	20.79	20.45	20.79	10692754.0
2009-04-27 11:00:00	MSFT	Stock	20.789	20.82	20.6	20.62	5303995.0
2009-04-27 12:00:00	MSFT	Stock	20.62	20.71	20.5	20.561	4561051.0
2009-04-27 13:00:00	MSFT	Stock	20.56	20.59	20.28	20.35	7277965.0
2009-04-27 14:00:00	MSFT	Stock	20.35	20.54	20.3	20.41	7175755.0
2009-04-27 15:00:00	MSFT	Stock	20.41	20.5	20.31	20.37	12152967.0
2009-04-27 16:00:00	MSFT	Stock	20.37	20.655	20.35	20.41	6124684.0
2009-04-27 17:00:00	MSFT	Stock	20.38	20.42	20.3	20.42	1722.0
2009-04-27 18:00:00	MSFT	Stock	20.4	20.42	20.4	20.42	179088.0
2009-04-27 19:00:00	MSFT	Stock	20.44	20.44	20.4	20.4	2062.0
2009-04-27 20:00:00	MSFT	Stock	20.63	20.63	20.63	20.63	7917.0
2009-04-27 08:00:00	NVDA	Stock	0.2825	0.2842	0.2812	0.2812	221800.0
2009-04-27 09:00:00	NVDA	Stock	0.2812	0.2895	0.28	0.2875	80444000.0
2009-04-27 10:00:00	NVDA	Stock	0.2878	0.29	0.2832	0.2888	103827520.0
2009-04-27 11:00:00	NVDA	Stock	0.2885	0.2892	0.2822	0.2838	88103360.0
2009-04-27 12:00:00	NVDA	Stock	0.2835	0.2855	0.2788	0.2795	82899440.0
2009-04-27 13:00:00	NVDA	Stock	0.2795	0.2798	0.2743	0.2755	114432480.0
2009-04-27 14:00:00	NVDA	Stock	0.2755	0.2768	0.2738	0.2768	80860200.0
2009-04-27 15:00:00	NVDA	Stock	0.2765	0.2775	0.2749	0.2752	217120440.0
2009-04-27 16:00:00	NVDA	Stock	0.275	0.28	0.2748	0.2763	6596680.0
2009-04-27 17:00:00	NVDA	Stock	0.2765	0.2765	0.2765	0.2765	60000.0
2009-04-27 18:00:00	NVDA	Stock	0.2765	0.2765	0.2765	0.2765	8000.0
2009-04-27 19:00:00	NVDA	Stock	0.2752	0.2752	0.275	0.275	72000.0
2009-04-27 06:00:00	AMZN	Stock	4.1535	4.1535	4.1535	4.1535	2000.0
2009-04-27 07:00:00	AMZN	Stock	4.228	4.228	4.228	4.228	4000.0
2009-04-27 08:00:00	AMZN	Stock	4.1995	4.2125	4.185	4.1925	171300.0
2009-04-27 09:00:00	AMZN	Stock	4.1925	4.249	4.18	4.1925	38502360.0
2009-04-27 10:00:00	AMZN	Stock	4.194	4.2175	4.1405	4.2025	37190320.0
2009-04-27 11:00:00	AMZN	Stock	4.203	4.2125	4.1695	4.2025	21844160.0
2009-04-27 12:00:00	AMZN	Stock	4.2035	4.2125	4.1455	4.15	19412140.0

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

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