PREVIEW / stock_1hour / 2007-07-19

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-07-19.parquet
  size:    757 KB
  rows:    37,227
  symbols: 3,052

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-07-19 09:00:00	AAPL	Stock	5.0107	5.0179	4.9875	5.0068	113491868.0
2007-07-19 10:00:00	AAPL	Stock	5.0061	5.0243	4.9946	5.005	150198468.0
2007-07-19 11:00:00	AAPL	Stock	5.0054	5.0289	5.0032	5.0075	115403288.0
2007-07-19 12:00:00	AAPL	Stock	5.0071	5.0204	5.0018	5.0154	60144308.0
2007-07-19 13:00:00	AAPL	Stock	5.0157	5.0225	5.0061	5.0179	48440084.0
2007-07-19 14:00:00	AAPL	Stock	5.0179	5.0179	5.0039	5.0096	72587060.0
2007-07-19 15:00:00	AAPL	Stock	5.0093	5.0193	4.9946	4.9957	100324700.0
2007-07-19 16:00:00	AAPL	Stock	4.995	5.0	4.9946	5.0	19863256.0
2007-07-19 09:00:00	MSFT	Stock	31.05	31.1	30.96	31.05	5951834.0
2007-07-19 10:00:00	MSFT	Stock	31.05	31.11	30.93	31.11	12406000.0
2007-07-19 11:00:00	MSFT	Stock	31.105	31.45	31.09	31.4	18331256.0
2007-07-19 12:00:00	MSFT	Stock	31.41	31.49	31.31	31.47	12732575.0
2007-07-19 13:00:00	MSFT	Stock	31.47	31.57	31.4	31.49	13483228.0
2007-07-19 14:00:00	MSFT	Stock	31.49	31.56	31.4	31.54	11827656.0
2007-07-19 15:00:00	MSFT	Stock	31.54	31.84	31.5	31.51	30905412.0
2007-07-19 16:00:00	MSFT	Stock	31.51	31.55	31.51	31.51	1856372.0
2007-07-19 08:00:00	NVDA	Stock	0.7667	0.7742	0.7662	0.7708	102000.0
2007-07-19 09:00:00	NVDA	Stock	0.7708	0.7755	0.7667	0.7692	37471200.0
2007-07-19 10:00:00	NVDA	Stock	0.769	0.769	0.755	0.756	59105400.0
2007-07-19 11:00:00	NVDA	Stock	0.756	0.7607	0.7546	0.758	45317220.0
2007-07-19 12:00:00	NVDA	Stock	0.7582	0.7612	0.756	0.7603	36997620.0
2007-07-19 13:00:00	NVDA	Stock	0.7602	0.7628	0.758	0.7597	39314880.0
2007-07-19 14:00:00	NVDA	Stock	0.7597	0.7597	0.7557	0.757	37197240.0
2007-07-19 15:00:00	NVDA	Stock	0.757	0.7632	0.757	0.7597	74957160.0
2007-07-19 16:00:00	NVDA	Stock	0.76	0.76	0.7567	0.759	56791080.0
2007-07-19 17:00:00	NVDA	Stock	0.7552	0.7567	0.7525	0.7525	676020.0
2007-07-19 19:00:00	NVDA	Stock	0.7582	0.7582	0.7582	0.7582	18000.0
2007-07-19 07:00:00	AMZN	Stock	3.695	3.7095	3.695	3.7095	52000.0
2007-07-19 08:00:00	AMZN	Stock	3.705	3.7165	3.7	3.714	208060.0
2007-07-19 09:00:00	AMZN	Stock	3.713	3.7175	3.666	3.686	18407960.0
2007-07-19 10:00:00	AMZN	Stock	3.686	3.6995	3.666	3.667	13519880.0
2007-07-19 11:00:00	AMZN	Stock	3.666	3.6705	3.656	3.6645	12750160.0
2007-07-19 12:00:00	AMZN	Stock	3.6645	3.693	3.66	3.693	7846340.0
2007-07-19 13:00:00	AMZN	Stock	3.693	3.693	3.676	3.681	6530940.0
2007-07-19 14:00:00	AMZN	Stock	3.6815	3.7175	3.6625	3.6805	13303420.0
2007-07-19 15:00:00	AMZN	Stock	3.681	3.6855	3.6625	3.665	20786360.0
2007-07-19 16:00:00	AMZN	Stock	3.665	3.6732	3.6245	3.63	5022420.0
2007-07-19 17:00:00	AMZN	Stock	3.625	3.6325	3.625	3.6325	175960.0
2007-07-19 18:00:00	AMZN	Stock	3.6325	3.6325	3.63	3.6305	64440.0
2007-07-19 19:00:00	AMZN	Stock	3.6325	3.6405	3.6325	3.6405	15000.0
2007-07-19 09:00:00	TLT	Stock	84.9	84.94	84.8	84.93	152400.0
2007-07-19 10:00:00	TLT	Stock	84.94	85.16	84.93	85.15	296100.0
2007-07-19 11:00:00	TLT	Stock	85.13	85.2	85.04	85.07	118700.0
2007-07-19 12:00:00	TLT	Stock	85.07	85.21	85.02	85.19	148416.0
2007-07-19 13:00:00	TLT	Stock	85.18	85.24	85.06	85.06	157700.0
2007-07-19 14:00:00	TLT	Stock	85.08	85.26	85.06	85.23	29600.0
2007-07-19 15:00:00	TLT	Stock	85.22	85.23	85.04	85.19	136472.0
2007-07-19 09:00:00	CL	Stock	33.925	34.09	33.855	34.09	567200.0
2007-07-19 10:00:00	CL	Stock	34.085	34.245	34.08	34.19	1018796.0
2007-07-19 11:00:00	CL	Stock	34.195	34.3	34.155	34.155	608800.0

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

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