PREVIEW / stock_1hour / 2009-12-30

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-12-30.parquet
  size:    912 KB
  rows:    44,617
  symbols: 3,461

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-12-30 05:00:00	AAPL	Stock	7.4336	7.4336	7.4336	7.4336	8400.0
2009-12-30 06:00:00	AAPL	Stock	7.4289	7.4289	7.4125	7.4125	53200.0
2009-12-30 07:00:00	AAPL	Stock	7.4211	7.4571	7.4196	7.4468	225988.0
2009-12-30 08:00:00	AAPL	Stock	7.4468	7.4686	7.4439	7.4507	2157596.0
2009-12-30 09:00:00	AAPL	Stock	7.4536	7.5482	7.4396	7.5239	97910484.0
2009-12-30 10:00:00	AAPL	Stock	7.5229	7.5357	7.4707	7.4925	85380092.0
2009-12-30 11:00:00	AAPL	Stock	7.4931	7.5246	7.4768	7.5132	42781508.0
2009-12-30 12:00:00	AAPL	Stock	7.5132	7.5318	7.5071	7.5104	34731732.0
2009-12-30 13:00:00	AAPL	Stock	7.5107	7.5268	7.5082	7.5196	21492240.0
2009-12-30 14:00:00	AAPL	Stock	7.5196	7.5607	7.5179	7.5421	43172668.0
2009-12-30 15:00:00	AAPL	Stock	7.5421	7.5714	7.5357	7.5643	68319020.0
2009-12-30 16:00:00	AAPL	Stock	7.5671	7.5711	7.5195	7.5696	11326952.0
2009-12-30 17:00:00	AAPL	Stock	7.5002	7.5696	7.5002	7.5679	407484.0
2009-12-30 18:00:00	AAPL	Stock	7.5679	7.5711	7.5586	7.565	761152.0
2009-12-30 19:00:00	AAPL	Stock	7.5654	7.5714	7.565	7.5714	311052.0
2009-12-30 07:00:00	MSFT	Stock	31.34	31.39	31.34	31.36	10500.0
2009-12-30 08:00:00	MSFT	Stock	31.3	31.35	31.3	31.33	11448.0
2009-12-30 09:00:00	MSFT	Stock	31.34	31.35	31.1	31.195	5074481.0
2009-12-30 10:00:00	MSFT	Stock	31.2	31.26	31.0	31.02	6551086.0
2009-12-30 11:00:00	MSFT	Stock	31.02	31.2	30.93	30.96	5863387.0
2009-12-30 12:00:00	MSFT	Stock	30.96	31.03	30.94	30.97	3196488.0
2009-12-30 13:00:00	MSFT	Stock	30.97	31.0	30.82	30.94	3407289.0
2009-12-30 14:00:00	MSFT	Stock	30.94	30.95	30.85	30.898	4373732.0
2009-12-30 15:00:00	MSFT	Stock	30.895	31.0	30.8	30.94	9732260.0
2009-12-30 16:00:00	MSFT	Stock	30.95	31.007	30.816	30.94	2822983.0
2009-12-30 17:00:00	MSFT	Stock	30.96	30.96	30.96	30.96	30421.0
2009-12-30 18:00:00	MSFT	Stock	30.96	30.96	30.96	30.96	300.0
2009-12-30 19:00:00	MSFT	Stock	30.96	30.96	30.93	30.93	1150.0
2009-12-30 07:00:00	NVDA	Stock	0.4588	0.4588	0.4585	0.4588	82400.0
2009-12-30 08:00:00	NVDA	Stock	0.456	0.4588	0.455	0.4582	1347800.0
2009-12-30 09:00:00	NVDA	Stock	0.4582	0.4612	0.4515	0.4608	158124440.0
2009-12-30 10:00:00	NVDA	Stock	0.4608	0.465	0.4605	0.463	139023840.0
2009-12-30 11:00:00	NVDA	Stock	0.4631	0.4695	0.4622	0.4675	118848160.0
2009-12-30 12:00:00	NVDA	Stock	0.4675	0.4683	0.4635	0.4645	79785200.0
2009-12-30 13:00:00	NVDA	Stock	0.4645	0.466	0.4635	0.466	45366400.0
2009-12-30 14:00:00	NVDA	Stock	0.466	0.4675	0.465	0.467	63968200.0
2009-12-30 15:00:00	NVDA	Stock	0.4668	0.4675	0.4655	0.467	85240640.0
2009-12-30 16:00:00	NVDA	Stock	0.4665	0.4688	0.4623	0.4668	3447080.0
2009-12-30 17:00:00	NVDA	Stock	0.4505	0.4685	0.4505	0.4665	2977920.0
2009-12-30 18:00:00	NVDA	Stock	0.4685	0.4685	0.4685	0.4685	58000.0
2009-12-30 19:00:00	NVDA	Stock	0.4678	0.4678	0.4675	0.4675	35400.0
2009-12-30 07:00:00	AMZN	Stock	6.9125	6.9185	6.8885	6.9185	29160.0
2009-12-30 08:00:00	AMZN	Stock	6.913	6.9215	6.9005	6.9155	120340.0
2009-12-30 09:00:00	AMZN	Stock	6.9155	6.92	6.832	6.8625	25551620.0
2009-12-30 10:00:00	AMZN	Stock	6.8605	6.869	6.7885	6.796	31971860.0
2009-12-30 11:00:00	AMZN	Stock	6.796	6.811	6.764	6.8	26250540.0
2009-12-30 12:00:00	AMZN	Stock	6.799	6.8085	6.785	6.7905	12722660.0
2009-12-30 13:00:00	AMZN	Stock	6.79	6.8165	6.79	6.8053	9927400.0
2009-12-30 14:00:00	AMZN	Stock	6.8035	6.821	6.794	6.814	9914860.0
2009-12-30 15:00:00	AMZN	Stock	6.813	6.825	6.797	6.825	18918800.0

> showing 50 of 44,617 rows — these rows as CSV

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