PREVIEW / stock_1hour / 2007-08-15

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-08-15.parquet
  size:    766 KB
  rows:    37,908
  symbols: 3,122

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
2007-08-15 09:00:00	AAPL	Stock	4.3836	4.4593	4.3493	4.4357	151026260.0
2007-08-15 10:00:00	AAPL	Stock	4.435	4.4426	4.3882	4.3925	125389824.0
2007-08-15 11:00:00	AAPL	Stock	4.3925	4.4011	4.3371	4.3393	134461068.0
2007-08-15 12:00:00	AAPL	Stock	4.3393	4.3793	4.3346	4.3586	89456724.0
2007-08-15 13:00:00	AAPL	Stock	4.3579	4.4221	4.3475	4.3939	100692480.0
2007-08-15 14:00:00	AAPL	Stock	4.3946	4.4104	4.3461	4.3543	104802460.0
2007-08-15 15:00:00	AAPL	Stock	4.3539	4.3668	4.2732	4.2846	228399276.0
2007-08-15 16:00:00	AAPL	Stock	4.2846	4.2857	4.2821	4.2821	10877496.0
2007-08-15 09:00:00	MSFT	Stock	28.24	28.62	28.14	28.56	3810672.0
2007-08-15 10:00:00	MSFT	Stock	28.56	28.71	28.55	28.62	7163568.0
2007-08-15 11:00:00	MSFT	Stock	28.62	28.74	28.51	28.57	4515982.0
2007-08-15 12:00:00	MSFT	Stock	28.57	28.74	28.55	28.7	3017846.0
2007-08-15 13:00:00	MSFT	Stock	28.69	28.99	28.64	28.95	5131559.0
2007-08-15 14:00:00	MSFT	Stock	28.95	28.96	28.45	28.47	6867572.0
2007-08-15 15:00:00	MSFT	Stock	28.47	28.655	28.05	28.11	11489308.0
2007-08-15 16:00:00	MSFT	Stock	28.1	28.1	28.1	28.1	1822099.0
2007-08-15 08:00:00	NVDA	Stock	0.7492	0.7508	0.7468	0.75	764880.0
2007-08-15 09:00:00	NVDA	Stock	0.75	0.7567	0.7337	0.7437	103741140.0
2007-08-15 10:00:00	NVDA	Stock	0.7438	0.76	0.738	0.7465	124198320.0
2007-08-15 11:00:00	NVDA	Stock	0.747	0.7475	0.7377	0.7395	73873500.0
2007-08-15 12:00:00	NVDA	Stock	0.739	0.7425	0.7362	0.7378	55304880.0
2007-08-15 13:00:00	NVDA	Stock	0.7378	0.7442	0.7292	0.7412	85154580.0
2007-08-15 14:00:00	NVDA	Stock	0.7408	0.7448	0.7325	0.7337	84418920.0
2007-08-15 15:00:00	NVDA	Stock	0.7338	0.7378	0.7205	0.7215	133864680.0
2007-08-15 16:00:00	NVDA	Stock	0.7215	0.7267	0.7215	0.7217	11560320.0
2007-08-15 17:00:00	NVDA	Stock	0.7218	0.722	0.7218	0.722	165780.0
2007-08-15 18:00:00	NVDA	Stock	0.722	0.722	0.72	0.72	106800.0
2007-08-15 19:00:00	NVDA	Stock	0.7192	0.7192	0.7192	0.7192	210000.0
2007-08-15 06:00:00	AMZN	Stock	3.625	3.625	3.625	3.625	2000.0
2007-08-15 07:00:00	AMZN	Stock	3.6855	3.6855	3.665	3.665	6000.0
2007-08-15 08:00:00	AMZN	Stock	3.6535	3.662	3.65	3.655	115180.0
2007-08-15 09:00:00	AMZN	Stock	3.6545	3.7575	3.648	3.713	19203200.0
2007-08-15 10:00:00	AMZN	Stock	3.713	3.75	3.676	3.712	20775960.0
2007-08-15 11:00:00	AMZN	Stock	3.712	3.721	3.69	3.709	19740040.0
2007-08-15 12:00:00	AMZN	Stock	3.709	3.709	3.6795	3.6875	9745280.0
2007-08-15 13:00:00	AMZN	Stock	3.6875	3.725	3.6815	3.7065	10259640.0
2007-08-15 14:00:00	AMZN	Stock	3.7065	3.715	3.6785	3.694	12346380.0
2007-08-15 15:00:00	AMZN	Stock	3.694	3.705	3.613	3.619	31398920.0
2007-08-15 16:00:00	AMZN	Stock	3.6195	3.6465	3.619	3.6465	2475980.0
2007-08-15 17:00:00	AMZN	Stock	3.62	3.625	3.6195	3.625	13760.0
2007-08-15 18:00:00	AMZN	Stock	3.6225	3.6225	3.6225	3.6225	6000.0
2007-08-15 09:00:00	TLT	Stock	86.65	86.75	86.42	86.53	279100.0
2007-08-15 10:00:00	TLT	Stock	86.48	86.51	86.35	86.42	231100.0
2007-08-15 11:00:00	TLT	Stock	86.4	86.57	86.29	86.52	241100.0
2007-08-15 12:00:00	TLT	Stock	86.52	86.54	86.41	86.5	74100.0
2007-08-15 13:00:00	TLT	Stock	86.5	86.5	86.26	86.36	22800.0
2007-08-15 14:00:00	TLT	Stock	86.37	86.55	86.37	86.47	67900.0
2007-08-15 15:00:00	TLT	Stock	86.47	86.64	86.46	86.47	146400.0
2007-08-15 16:00:00	TLT	Stock	86.42	86.42	86.25	86.25	5800.0
2007-08-15 09:00:00	CL	Stock	32.725	33.0	32.655	32.97	370614.0

> showing 50 of 37,908 rows — these rows as CSV

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