PREVIEW / stock_1hour / 2008-04-14

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-04-14.parquet
  size:    807 KB
  rows:    39,769
  symbols: 3,308

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-14 06:00:00	AAPL	Stock	5.2418	5.2721	5.2386	5.2386	38500.0
2008-04-14 07:00:00	AAPL	Stock	5.23	5.2475	5.2236	5.2321	175000.0
2008-04-14 08:00:00	AAPL	Stock	5.2289	5.2432	5.1989	5.2357	4017692.0
2008-04-14 09:00:00	AAPL	Stock	5.2361	5.2736	5.1621	5.1979	161244020.0
2008-04-14 10:00:00	AAPL	Stock	5.1989	5.3029	5.1893	5.2946	186863992.0
2008-04-14 11:00:00	AAPL	Stock	5.2954	5.3136	5.2621	5.2929	104726944.0
2008-04-14 12:00:00	AAPL	Stock	5.2932	5.3304	5.2875	5.3193	89889884.0
2008-04-14 13:00:00	AAPL	Stock	5.3193	5.3214	5.2664	5.2744	81083632.0
2008-04-14 14:00:00	AAPL	Stock	5.2729	5.3054	5.2614	5.2704	93327164.0
2008-04-14 15:00:00	AAPL	Stock	5.27	5.2896	5.2532	5.2786	103060888.0
2008-04-14 16:00:00	AAPL	Stock	5.2789	5.2814	5.2554	5.2786	14564228.0
2008-04-14 17:00:00	AAPL	Stock	5.2786	5.2804	5.2771	5.2771	228816.0
2008-04-14 18:00:00	AAPL	Stock	5.2786	5.2804	5.275	5.2754	93492.0
2008-04-14 19:00:00	AAPL	Stock	5.2782	5.2821	5.2754	5.2814	191604.0
2008-04-14 08:00:00	MSFT	Stock	28.35	28.38	28.25	28.3	11912.0
2008-04-14 09:00:00	MSFT	Stock	28.3	28.31	28.16	28.22	3763915.0
2008-04-14 10:00:00	MSFT	Stock	28.23	28.3	28.01	28.178	5178349.0
2008-04-14 11:00:00	MSFT	Stock	28.18	28.22	27.93	28.06	6262693.0
2008-04-14 12:00:00	MSFT	Stock	28.055	28.3	28.04	28.29	4441174.0
2008-04-14 13:00:00	MSFT	Stock	28.29	28.3	28.17	28.24	3918921.0
2008-04-14 14:00:00	MSFT	Stock	28.24	28.26	28.14	28.17	4606845.0
2008-04-14 15:00:00	MSFT	Stock	28.175	28.25	28.05	28.06	7274964.0
2008-04-14 16:00:00	MSFT	Stock	28.05	28.292	28.02	28.06	6463546.0
2008-04-14 17:00:00	MSFT	Stock	28.08	28.09	28.06	28.09	5750.0
2008-04-14 18:00:00	MSFT	Stock	28.09	28.09	28.06	28.06	53463.0
2008-04-14 19:00:00	MSFT	Stock	28.09	28.1	28.06	28.1	14737.0
2008-04-14 07:00:00	NVDA	Stock	0.4652	0.4652	0.4652	0.4652	4000.0
2008-04-14 08:00:00	NVDA	Stock	0.4612	0.4633	0.46	0.46	186040.0
2008-04-14 09:00:00	NVDA	Stock	0.4615	0.4625	0.4475	0.4538	126472440.0
2008-04-14 10:00:00	NVDA	Stock	0.4538	0.4558	0.4468	0.4492	136138640.0
2008-04-14 11:00:00	NVDA	Stock	0.4492	0.4508	0.4458	0.4488	100123960.0
2008-04-14 12:00:00	NVDA	Stock	0.4489	0.455	0.4482	0.453	55178880.0
2008-04-14 13:00:00	NVDA	Stock	0.453	0.4532	0.4492	0.45	44529880.0
2008-04-14 14:00:00	NVDA	Stock	0.4502	0.4502	0.4468	0.4468	72359080.0
2008-04-14 15:00:00	NVDA	Stock	0.4468	0.4488	0.445	0.4478	132254520.0
2008-04-14 16:00:00	NVDA	Stock	0.4475	0.4496	0.4465	0.447	109169960.0
2008-04-14 17:00:00	NVDA	Stock	0.447	0.447	0.4465	0.447	222800.0
2008-04-14 18:00:00	NVDA	Stock	0.447	0.4485	0.4465	0.4465	48000.0
2008-04-14 19:00:00	NVDA	Stock	0.448	0.448	0.4465	0.4465	64000.0
2008-04-14 08:00:00	AMZN	Stock	3.581	3.581	3.581	3.581	9000.0
2008-04-14 09:00:00	AMZN	Stock	3.5875	3.6625	3.5645	3.66	18020100.0
2008-04-14 10:00:00	AMZN	Stock	3.66	3.6985	3.64	3.69	19959020.0
2008-04-14 11:00:00	AMZN	Stock	3.691	3.7	3.6545	3.674	8744660.0
2008-04-14 12:00:00	AMZN	Stock	3.6735	3.6915	3.6505	3.674	6683540.0
2008-04-14 13:00:00	AMZN	Stock	3.674	3.6855	3.659	3.6655	6031860.0
2008-04-14 14:00:00	AMZN	Stock	3.6655	3.6705	3.64	3.645	8517880.0
2008-04-14 15:00:00	AMZN	Stock	3.6465	3.6555	3.6275	3.633	16025420.0
2008-04-14 16:00:00	AMZN	Stock	3.6305	3.6562	3.6001	3.6375	1060080.0
2008-04-14 17:00:00	AMZN	Stock	3.632	3.632	3.632	3.632	2000.0
2008-04-14 18:00:00	AMZN	Stock	3.6385	3.6385	3.6385	3.6385	2000.0

> showing 50 of 39,769 rows — these rows as CSV

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