PREVIEW / stock_1hour / 2006-05-26

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-05-26.parquet
  size:    584 KB
  rows:    27,895
  symbols: 2,267

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
2006-05-26 07:00:00	AAPL	Stock	2.2982	2.3007	2.2982	2.3007	16800.0
2006-05-26 08:00:00	AAPL	Stock	2.2964	2.3107	2.2946	2.2986	1273972.0
2006-05-26 09:00:00	AAPL	Stock	2.3	2.3057	2.2764	2.2896	77800380.0
2006-05-26 10:00:00	AAPL	Stock	2.2893	2.2979	2.2714	2.2782	79640848.0
2006-05-26 11:00:00	AAPL	Stock	2.2779	2.2846	2.2746	2.2775	44076760.0
2006-05-26 12:00:00	AAPL	Stock	2.2775	2.2825	2.2607	2.265	53371920.0
2006-05-26 13:00:00	AAPL	Stock	2.2646	2.2696	2.255	2.2696	57320872.0
2006-05-26 14:00:00	AAPL	Stock	2.2696	2.2839	2.2657	2.2718	51162300.0
2006-05-26 15:00:00	AAPL	Stock	2.2717	2.275	2.2625	2.2693	60526256.0
2006-05-26 16:00:00	AAPL	Stock	2.2689	2.2743	2.2664	2.2707	1610980.0
2006-05-26 17:00:00	AAPL	Stock	2.2707	2.2743	2.2707	2.2714	72520.0
2006-05-26 18:00:00	AAPL	Stock	2.2721	2.2721	2.2696	2.2707	61404.0
2006-05-26 06:00:00	MSFT	Stock	23.7	23.72	23.7	23.72	5000.0
2006-05-26 07:00:00	MSFT	Stock	23.76	23.76	23.7	23.7	6200.0
2006-05-26 08:00:00	MSFT	Stock	23.75	23.8	23.67	23.78	28200.0
2006-05-26 09:00:00	MSFT	Stock	23.75	23.88	23.66	23.71	7300019.0
2006-05-26 10:00:00	MSFT	Stock	23.71	23.87	23.63	23.682	8149269.0
2006-05-26 11:00:00	MSFT	Stock	23.69	23.74	23.68	23.72	5907610.0
2006-05-26 12:00:00	MSFT	Stock	23.72	23.73	23.59	23.61	7270910.0
2006-05-26 13:00:00	MSFT	Stock	23.61	23.69	23.59	23.68	4142937.0
2006-05-26 14:00:00	MSFT	Stock	23.68	23.699	23.56	23.62	4650276.0
2006-05-26 15:00:00	MSFT	Stock	23.62	23.76	23.62	23.72	7154738.0
2006-05-26 16:00:00	MSFT	Stock	23.71	23.74	23.68	23.73	64272.0
2006-05-26 17:00:00	MSFT	Stock	23.74	23.74	23.69	23.69	7059.0
2006-05-26 18:00:00	MSFT	Stock	23.72	23.73	23.72	23.73	4374.0
2006-05-26 08:00:00	NVDA	Stock	0.3993	0.3993	0.3993	0.3993	36000.0
2006-05-26 09:00:00	NVDA	Stock	0.3993	0.4015	0.3953	0.3998	36666120.0
2006-05-26 10:00:00	NVDA	Stock	0.3998	0.4028	0.3988	0.3997	49296840.0
2006-05-26 11:00:00	NVDA	Stock	0.3997	0.4022	0.3995	0.4002	31205280.0
2006-05-26 12:00:00	NVDA	Stock	0.4	0.4003	0.3987	0.3988	25867260.0
2006-05-26 13:00:00	NVDA	Stock	0.3988	0.3993	0.3975	0.3987	26589420.0
2006-05-26 14:00:00	NVDA	Stock	0.3988	0.4002	0.3978	0.3988	22922520.0
2006-05-26 15:00:00	NVDA	Stock	0.3988	0.4003	0.3973	0.3993	56089380.0
2006-05-26 16:00:00	NVDA	Stock	0.3992	0.4008	0.3992	0.4008	14150700.0
2006-05-26 17:00:00	NVDA	Stock	0.3995	0.4	0.3995	0.4	57600.0
2006-05-26 09:00:00	AMZN	Stock	1.785	1.7925	1.773	1.786	8612840.0
2006-05-26 10:00:00	AMZN	Stock	1.786	1.796	1.7755	1.781	13594500.0
2006-05-26 11:00:00	AMZN	Stock	1.781	1.8165	1.777	1.813	17510720.0
2006-05-26 12:00:00	AMZN	Stock	1.8135	1.825	1.805	1.81	11706740.0
2006-05-26 13:00:00	AMZN	Stock	1.81	1.811	1.8055	1.807	6222080.0
2006-05-26 14:00:00	AMZN	Stock	1.8075	1.8075	1.7975	1.805	12526900.0
2006-05-26 15:00:00	AMZN	Stock	1.805	1.8075	1.7995	1.8035	17681180.0
2006-05-26 16:00:00	AMZN	Stock	1.804	1.8055	1.804	1.8055	12920.0
2006-05-26 17:00:00	AMZN	Stock	1.802	1.802	1.795	1.8	48940.0
2006-05-26 09:00:00	CL	Stock	30.05	30.15	30.0	30.145	315600.0
2006-05-26 10:00:00	CL	Stock	30.145	30.275	30.0	30.075	486600.0
2006-05-26 11:00:00	CL	Stock	30.08	30.27	30.02	30.27	704800.0
2006-05-26 12:00:00	CL	Stock	30.265	30.28	30.18	30.21	333600.0
2006-05-26 13:00:00	CL	Stock	30.215	30.27	30.205	30.265	355800.0
2006-05-26 14:00:00	CL	Stock	30.265	30.31	30.25	30.31	325200.0

> showing 50 of 27,895 rows — these rows as CSV

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