PREVIEW / stock_1hour / 2005-12-28

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-12-28.parquet
  size:    573 KB
  rows:    27,389
  symbols: 2,167

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-28 08:00:00	AAPL	Stock	2.6511	2.6711	2.6507	2.6639	1097740.0
2005-12-28 09:00:00	AAPL	Stock	2.6643	2.67	2.6489	2.66	54878376.0
2005-12-28 10:00:00	AAPL	Stock	2.6596	2.6661	2.6268	2.6396	86970968.0
2005-12-28 11:00:00	AAPL	Stock	2.6389	2.6675	2.6304	2.6329	45969728.0
2005-12-28 12:00:00	AAPL	Stock	2.6325	2.6582	2.6186	2.6282	39230940.0
2005-12-28 13:00:00	AAPL	Stock	2.6279	2.6336	2.6214	2.6275	34510700.0
2005-12-28 14:00:00	AAPL	Stock	2.6275	2.64	2.6239	2.6307	54505892.0
2005-12-28 15:00:00	AAPL	Stock	2.6304	2.6436	2.6275	2.6286	69909896.0
2005-12-28 16:00:00	AAPL	Stock	2.6289	2.6321	2.6261	2.6296	898968.0
2005-12-28 17:00:00	AAPL	Stock	2.6293	2.6395	2.6275	2.6395	1622572.0
2005-12-28 18:00:00	AAPL	Stock	2.6279	2.6286	2.6268	2.6268	622160.0
2005-12-28 08:00:00	MSFT	Stock	26.47	26.59	26.47	26.55	143305.0
2005-12-28 09:00:00	MSFT	Stock	26.55	26.662	26.49	26.54	4044787.0
2005-12-28 10:00:00	MSFT	Stock	26.54	26.59	26.41	26.44	5233274.0
2005-12-28 11:00:00	MSFT	Stock	26.45	26.5	26.42	26.44	4359247.0
2005-12-28 12:00:00	MSFT	Stock	26.44	26.5	26.4	26.44	3588633.0
2005-12-28 13:00:00	MSFT	Stock	26.45	26.47	26.42	26.45	3381278.0
2005-12-28 14:00:00	MSFT	Stock	26.44	26.49	26.43	26.442	3732072.0
2005-12-28 15:00:00	MSFT	Stock	26.441	26.47	26.35	26.37	6532503.0
2005-12-28 16:00:00	MSFT	Stock	26.38	26.42	26.35	26.42	1170028.0
2005-12-28 17:00:00	MSFT	Stock	26.38	26.38	26.35	26.35	1054.0
2005-12-28 18:00:00	MSFT	Stock	26.4	26.4	26.38	26.4	1797760.0
2005-12-28 09:00:00	NVDA	Stock	0.3167	0.3167	0.3127	0.3158	39511920.0
2005-12-28 10:00:00	NVDA	Stock	0.3158	0.3178	0.3142	0.3142	72495720.0
2005-12-28 11:00:00	NVDA	Stock	0.3141	0.3157	0.3137	0.3147	21716760.0
2005-12-28 12:00:00	NVDA	Stock	0.3148	0.3151	0.3144	0.3147	11012640.0
2005-12-28 13:00:00	NVDA	Stock	0.3147	0.3161	0.3146	0.3157	15533760.0
2005-12-28 14:00:00	NVDA	Stock	0.3157	0.3182	0.3153	0.3173	36869040.0
2005-12-28 15:00:00	NVDA	Stock	0.3172	0.3187	0.3167	0.3176	55217400.0
2005-12-28 16:00:00	NVDA	Stock	0.3174	0.3177	0.3173	0.3177	335880.0
2005-12-28 17:00:00	NVDA	Stock	0.3179	0.3179	0.3179	0.3179	12000.0
2005-12-28 08:00:00	AMZN	Stock	2.43	2.43	2.43	2.43	22000.0
2005-12-28 09:00:00	AMZN	Stock	2.424	2.4275	2.398	2.4065	12314060.0
2005-12-28 10:00:00	AMZN	Stock	2.407	2.418	2.4045	2.409	19947740.0
2005-12-28 11:00:00	AMZN	Stock	2.4095	2.4105	2.3995	2.3995	12653240.0
2005-12-28 12:00:00	AMZN	Stock	2.3995	2.4065	2.395	2.4024	7084480.0
2005-12-28 13:00:00	AMZN	Stock	2.402	2.415	2.4005	2.415	7127980.0
2005-12-28 14:00:00	AMZN	Stock	2.415	2.419	2.411	2.4115	7291120.0
2005-12-28 15:00:00	AMZN	Stock	2.4115	2.4175	2.4025	2.4035	16755040.0
2005-12-28 16:00:00	AMZN	Stock	2.4035	2.408	2.4025	2.405	5638540.0
2005-12-28 17:00:00	AMZN	Stock	2.406	2.407	2.406	2.407	24000.0
2005-12-28 18:00:00	AMZN	Stock	2.407	2.41	2.407	2.41	36000.0
2005-12-28 09:00:00	CL	Stock	27.445	27.59	27.395	27.5665	273400.0
2005-12-28 10:00:00	CL	Stock	27.565	27.57	27.46	27.47	355000.0
2005-12-28 11:00:00	CL	Stock	27.4715	27.5	27.405	27.485	455600.0
2005-12-28 12:00:00	CL	Stock	27.495	27.555	27.435	27.5	425800.0
2005-12-28 13:00:00	CL	Stock	27.5	27.575	27.47	27.57	366000.0
2005-12-28 14:00:00	CL	Stock	27.575	27.685	27.56	27.64	267000.0
2005-12-28 15:00:00	CL	Stock	27.645	27.725	27.605	27.63	452200.0
2005-12-28 16:00:00	CL	Stock	27.625	27.625	27.625	27.625	60000.0

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

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