PREVIEW / stock_1hour / 2005-12-29

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-12-29.parquet
  size:    586 KB
  rows:    27,972
  symbols: 2,176

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-12-29 07:00:00	AAPL	Stock	2.6275	2.6275	2.6275	2.6275	37968.0
2005-12-29 08:00:00	AAPL	Stock	2.625	2.6275	2.6189	2.6243	799820.0
2005-12-29 09:00:00	AAPL	Stock	2.6243	2.6368	2.5861	2.5975	85651720.0
2005-12-29 10:00:00	AAPL	Stock	2.5975	2.6029	2.5664	2.5814	105801864.0
2005-12-29 11:00:00	AAPL	Stock	2.5811	2.5929	2.5736	2.5825	55448736.0
2005-12-29 12:00:00	AAPL	Stock	2.5825	2.5829	2.5636	2.5753	56067984.0
2005-12-29 13:00:00	AAPL	Stock	2.575	2.5807	2.5664	2.5725	31920364.0
2005-12-29 14:00:00	AAPL	Stock	2.5721	2.5864	2.5693	2.5786	40692792.0
2005-12-29 15:00:00	AAPL	Stock	2.5786	2.5789	2.5507	2.5514	102647244.0
2005-12-29 16:00:00	AAPL	Stock	2.5518	2.5546	2.5486	2.5514	3354092.0
2005-12-29 17:00:00	AAPL	Stock	2.5514	2.5564	2.5514	2.555	163156.0
2005-12-29 18:00:00	AAPL	Stock	2.555	2.5557	2.55	2.5557	229824.0
2005-12-29 08:00:00	MSFT	Stock	26.39	26.4	26.35	26.4	17654.0
2005-12-29 09:00:00	MSFT	Stock	26.41	26.5	26.37	26.45	4369437.0
2005-12-29 10:00:00	MSFT	Stock	26.45	26.48	26.39	26.44	4545064.0
2005-12-29 11:00:00	MSFT	Stock	26.43	26.48	26.41	26.41	3348694.0
2005-12-29 12:00:00	MSFT	Stock	26.41	26.42	26.359	26.4	3553273.0
2005-12-29 13:00:00	MSFT	Stock	26.41	26.42	26.39	26.41	3203244.0
2005-12-29 14:00:00	MSFT	Stock	26.4	26.42	26.4	26.41	3443611.0
2005-12-29 15:00:00	MSFT	Stock	26.402	26.41	26.26	26.28	10140602.0
2005-12-29 16:00:00	MSFT	Stock	26.27	26.29	26.26	26.29	165574.0
2005-12-29 17:00:00	MSFT	Stock	26.28	26.28	26.27	26.27	8971.0
2005-12-29 18:00:00	MSFT	Stock	26.28	26.29	26.28	26.29	400.0
2005-12-29 09:00:00	NVDA	Stock	0.317	0.3185	0.3148	0.315	44520240.0
2005-12-29 10:00:00	NVDA	Stock	0.3147	0.3177	0.3125	0.3136	52699440.0
2005-12-29 11:00:00	NVDA	Stock	0.3134	0.3142	0.3108	0.3115	30297840.0
2005-12-29 12:00:00	NVDA	Stock	0.3112	0.3117	0.3098	0.3116	24244080.0
2005-12-29 13:00:00	NVDA	Stock	0.3116	0.3117	0.3104	0.3106	17511480.0
2005-12-29 14:00:00	NVDA	Stock	0.3106	0.3112	0.3102	0.3103	24652320.0
2005-12-29 15:00:00	NVDA	Stock	0.3104	0.3107	0.3092	0.3106	101361840.0
2005-12-29 16:00:00	NVDA	Stock	0.3106	0.3107	0.31	0.3106	2971320.0
2005-12-29 17:00:00	NVDA	Stock	0.3104	0.3106	0.3104	0.3106	120000.0
2005-12-29 08:00:00	AMZN	Stock	2.403	2.403	2.403	2.403	2000.0
2005-12-29 09:00:00	AMZN	Stock	2.395	2.422	2.395	2.417	9723840.0
2005-12-29 10:00:00	AMZN	Stock	2.416	2.4225	2.4045	2.4146	11011560.0
2005-12-29 11:00:00	AMZN	Stock	2.4145	2.4215	2.4125	2.414	3987200.0
2005-12-29 12:00:00	AMZN	Stock	2.414	2.4195	2.4135	2.4145	5859120.0
2005-12-29 13:00:00	AMZN	Stock	2.415	2.4205	2.414	2.419	4024100.0
2005-12-29 14:00:00	AMZN	Stock	2.4195	2.423	2.4185	2.4185	5544740.0
2005-12-29 15:00:00	AMZN	Stock	2.4186	2.4205	2.3985	2.3995	20641320.0
2005-12-29 16:00:00	AMZN	Stock	2.3995	2.4025	2.3995	2.3995	103180.0
2005-12-29 18:00:00	AMZN	Stock	2.4	2.4	2.4	2.4	2000.0
2005-12-29 09:00:00	CL	Stock	27.725	27.765	27.645	27.66	189400.0
2005-12-29 10:00:00	CL	Stock	27.665	27.72	27.615	27.621	226000.0
2005-12-29 11:00:00	CL	Stock	27.63	27.675	27.6	27.6	330400.0
2005-12-29 12:00:00	CL	Stock	27.605	27.615	27.575	27.61	167400.0
2005-12-29 13:00:00	CL	Stock	27.61	27.625	27.575	27.62	135600.0
2005-12-29 14:00:00	CL	Stock	27.62	27.66	27.61	27.625	211000.0
2005-12-29 15:00:00	CL	Stock	27.63	27.74	27.545	27.675	815400.0
2005-12-29 16:00:00	CL	Stock	27.65	27.65	27.635	27.65	51400.0

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

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