PREVIEW / stock_1hour / 2005-10-03

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-10-03.parquet
  size:    570 KB
  rows:    27,042
  symbols: 2,094

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
2005-10-03 07:00:00	AAPL	Stock	1.9089	1.9214	1.9089	1.9214	56000.0
2005-10-03 08:00:00	AAPL	Stock	1.9268	1.9339	1.9146	1.9286	1918924.0
2005-10-03 09:00:00	AAPL	Stock	1.9304	1.94	1.9261	1.9336	93888424.0
2005-10-03 10:00:00	AAPL	Stock	1.9339	1.9368	1.9171	1.9279	100461564.0
2005-10-03 11:00:00	AAPL	Stock	1.9279	1.9343	1.9257	1.9282	56845320.0
2005-10-03 12:00:00	AAPL	Stock	1.9282	1.9318	1.9214	1.9271	33583424.0
2005-10-03 13:00:00	AAPL	Stock	1.9271	1.9371	1.9268	1.935	46445028.0
2005-10-03 14:00:00	AAPL	Stock	1.935	1.9425	1.9271	1.935	57879164.0
2005-10-03 15:00:00	AAPL	Stock	1.9357	1.9479	1.9321	1.9439	95377380.0
2005-10-03 16:00:00	AAPL	Stock	1.9443	1.9443	1.9326	1.9429	1709484.0
2005-10-03 17:00:00	AAPL	Stock	1.9421	1.9443	1.9374	1.9439	338716.0
2005-10-03 18:00:00	AAPL	Stock	1.9429	1.9518	1.9429	1.9482	951160.0
2005-10-03 08:00:00	MSFT	Stock	25.73	25.78	25.73	25.77	57734.0
2005-10-03 09:00:00	MSFT	Stock	25.77	25.78	25.58	25.63	5284671.0
2005-10-03 10:00:00	MSFT	Stock	25.63	25.66	25.54	25.56	8729331.0
2005-10-03 11:00:00	MSFT	Stock	25.57	25.63	25.52	25.53	4821265.0
2005-10-03 12:00:00	MSFT	Stock	25.54	25.6	25.46	25.57	6568709.0
2005-10-03 13:00:00	MSFT	Stock	25.58	25.61	25.48	25.53	5317022.0
2005-10-03 14:00:00	MSFT	Stock	25.53	25.59	25.479	25.53	6749049.0
2005-10-03 15:00:00	MSFT	Stock	25.54	25.57	25.44	25.499	12527392.0
2005-10-03 16:00:00	MSFT	Stock	25.5	25.55	25.41	25.46	1421306.0
2005-10-03 17:00:00	MSFT	Stock	25.5	25.52	25.41	25.43	80733.0
2005-10-03 18:00:00	MSFT	Stock	25.43	25.44	25.41	25.44	11987.0
2005-10-03 08:00:00	NVDA	Stock	0.2857	0.2907	0.2857	0.2888	1774560.0
2005-10-03 09:00:00	NVDA	Stock	0.2891	0.2907	0.2857	0.2906	72393360.0
2005-10-03 10:00:00	NVDA	Stock	0.2906	0.2955	0.2904	0.2942	136784640.0
2005-10-03 11:00:00	NVDA	Stock	0.2942	0.2956	0.2937	0.2953	80962800.0
2005-10-03 12:00:00	NVDA	Stock	0.2952	0.2954	0.2929	0.2939	59882520.0
2005-10-03 13:00:00	NVDA	Stock	0.2939	0.295	0.2933	0.294	56790240.0
2005-10-03 14:00:00	NVDA	Stock	0.2938	0.2947	0.2923	0.2936	43729920.0
2005-10-03 15:00:00	NVDA	Stock	0.2936	0.2946	0.2932	0.2935	82182360.0
2005-10-03 16:00:00	NVDA	Stock	0.2935	0.2941	0.2928	0.2941	3228960.0
2005-10-03 17:00:00	NVDA	Stock	0.2935	0.2935	0.2928	0.2928	1272000.0
2005-10-03 18:00:00	NVDA	Stock	0.2934	0.2934	0.2931	0.2931	629400.0
2005-10-03 08:00:00	AMZN	Stock	2.265	2.265	2.2645	2.2645	239840.0
2005-10-03 09:00:00	AMZN	Stock	2.255	2.291	2.255	2.2895	12190060.0
2005-10-03 10:00:00	AMZN	Stock	2.288	2.296	2.259	2.2645	16043340.0
2005-10-03 11:00:00	AMZN	Stock	2.2645	2.2915	2.2645	2.2855	9506040.0
2005-10-03 12:00:00	AMZN	Stock	2.2855	2.29	2.2835	2.2865	5893160.0
2005-10-03 13:00:00	AMZN	Stock	2.2866	2.306	2.286	2.3045	13567580.0
2005-10-03 14:00:00	AMZN	Stock	2.3045	2.3165	2.2895	2.312	15894920.0
2005-10-03 15:00:00	AMZN	Stock	2.312	2.3295	2.2935	2.2995	36130180.0
2005-10-03 16:00:00	AMZN	Stock	2.3035	2.3035	2.2995	2.2995	138160.0
2005-10-03 17:00:00	AMZN	Stock	2.299	2.299	2.299	2.299	10000.0
2005-10-03 09:00:00	CL	Stock	26.395	26.57	26.395	26.525	612400.0
2005-10-03 10:00:00	CL	Stock	26.535	26.56	26.21	26.21	574000.0
2005-10-03 11:00:00	CL	Stock	26.21	26.515	26.21	26.495	438600.0
2005-10-03 12:00:00	CL	Stock	26.5	26.51	26.44	26.44	266000.0
2005-10-03 13:00:00	CL	Stock	26.435	26.45	26.365	26.415	424600.0
2005-10-03 14:00:00	CL	Stock	26.4105	26.51	26.41	26.475	599600.0

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

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