PREVIEW / stock_1hour / 2006-08-15

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-08-15.parquet
  size:    606 KB
  rows:    29,313
  symbols: 2,326

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-08-15 07:00:00	AAPL	Stock	2.2857	2.2857	2.2857	2.2857	2800.0
2006-08-15 08:00:00	AAPL	Stock	2.2857	2.3243	2.285	2.3186	6301792.0
2006-08-15 09:00:00	AAPL	Stock	2.3189	2.3368	2.3143	2.3271	154811720.0
2006-08-15 10:00:00	AAPL	Stock	2.3271	2.3571	2.3232	2.3493	190079204.0
2006-08-15 11:00:00	AAPL	Stock	2.3493	2.3571	2.3446	2.3514	104674024.0
2006-08-15 12:00:00	AAPL	Stock	2.3514	2.3643	2.3511	2.3611	79661512.0
2006-08-15 13:00:00	AAPL	Stock	2.3607	2.3696	2.3543	2.36	91895132.0
2006-08-15 14:00:00	AAPL	Stock	2.36	2.3725	2.3514	2.3679	105889644.0
2006-08-15 15:00:00	AAPL	Stock	2.3675	2.375	2.3621	2.3739	112230272.0
2006-08-15 16:00:00	AAPL	Stock	2.3739	2.375	2.3499	2.3736	4881296.0
2006-08-15 17:00:00	AAPL	Stock	2.3739	2.375	2.3732	2.375	392000.0
2006-08-15 18:00:00	AAPL	Stock	2.375	2.375	2.3714	2.3746	202496.0
2006-08-15 08:00:00	MSFT	Stock	24.53	24.57	24.39	24.52	1474787.0
2006-08-15 09:00:00	MSFT	Stock	24.55	24.57	24.44	24.5	4815990.0
2006-08-15 10:00:00	MSFT	Stock	24.5	24.57	24.46	24.56	6537487.0
2006-08-15 11:00:00	MSFT	Stock	24.56	24.6	24.5	24.55	5637048.0
2006-08-15 12:00:00	MSFT	Stock	24.55	24.59	24.53	24.54	3402685.0
2006-08-15 13:00:00	MSFT	Stock	24.54	24.59	24.51	24.573	3544939.0
2006-08-15 14:00:00	MSFT	Stock	24.58	24.6	24.55	24.59	4394675.0
2006-08-15 15:00:00	MSFT	Stock	24.59	24.65	24.53	24.61	17029661.0
2006-08-15 16:00:00	MSFT	Stock	24.61	24.64	24.59	24.63	976059.0
2006-08-15 17:00:00	MSFT	Stock	24.59	24.6	24.59	24.6	2009.0
2006-08-15 18:00:00	MSFT	Stock	24.62	24.62	24.59	24.59	874.0
2006-08-15 08:00:00	NVDA	Stock	0.3887	0.3952	0.3887	0.3948	481200.0
2006-08-15 09:00:00	NVDA	Stock	0.3952	0.3997	0.3938	0.398	75461580.0
2006-08-15 10:00:00	NVDA	Stock	0.398	0.4093	0.3957	0.4068	153951300.0
2006-08-15 11:00:00	NVDA	Stock	0.4068	0.411	0.4068	0.4088	99513900.0
2006-08-15 12:00:00	NVDA	Stock	0.409	0.412	0.4088	0.4117	61331820.0
2006-08-15 13:00:00	NVDA	Stock	0.4118	0.4177	0.4115	0.4143	123787440.0
2006-08-15 14:00:00	NVDA	Stock	0.4142	0.4213	0.4107	0.4207	169993620.0
2006-08-15 15:00:00	NVDA	Stock	0.4207	0.4275	0.4193	0.4253	202876260.0
2006-08-15 16:00:00	NVDA	Stock	0.4247	0.4267	0.4235	0.4263	2625360.0
2006-08-15 17:00:00	NVDA	Stock	0.4263	0.427	0.4263	0.427	91200.0
2006-08-15 18:00:00	NVDA	Stock	0.4267	0.4273	0.4267	0.4273	36000.0
2006-08-15 08:00:00	AMZN	Stock	1.331	1.347	1.331	1.347	16000.0
2006-08-15 09:00:00	AMZN	Stock	1.3465	1.355	1.3315	1.3345	11067700.0
2006-08-15 10:00:00	AMZN	Stock	1.335	1.349	1.331	1.3455	23409440.0
2006-08-15 11:00:00	AMZN	Stock	1.3455	1.3525	1.343	1.3445	13182300.0
2006-08-15 12:00:00	AMZN	Stock	1.3445	1.351	1.3395	1.3505	11326520.0
2006-08-15 13:00:00	AMZN	Stock	1.3505	1.3585	1.347	1.3575	14457780.0
2006-08-15 14:00:00	AMZN	Stock	1.3575	1.38	1.355	1.3785	29707740.0
2006-08-15 15:00:00	AMZN	Stock	1.3785	1.393	1.37	1.3885	54659160.0
2006-08-15 16:00:00	AMZN	Stock	1.385	1.389	1.3845	1.3875	230820.0
2006-08-15 17:00:00	AMZN	Stock	1.3875	1.3875	1.385	1.385	12500.0
2006-08-15 09:00:00	CL	Stock	30.15	30.225	30.0	30.105	419400.0
2006-08-15 10:00:00	CL	Stock	30.115	30.15	30.0	30.0	381200.0
2006-08-15 11:00:00	CL	Stock	30.005	30.095	29.955	29.99	428600.0
2006-08-15 12:00:00	CL	Stock	29.98	30.075	29.98	30.055	317000.0
2006-08-15 13:00:00	CL	Stock	30.055	30.125	30.045	30.105	304600.0
2006-08-15 14:00:00	CL	Stock	30.105	30.19	30.085	30.145	358000.0

> showing 50 of 29,313 rows — these rows as CSV

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