PREVIEW / stock_1hour / 2007-04-18

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-04-18.parquet
  size:    680 KB
  rows:    31,977
  symbols: 2,579

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-04-18 07:00:00	AAPL	Stock	3.2143	3.2186	3.1971	3.2018	240100.0
2007-04-18 08:00:00	AAPL	Stock	3.2018	3.2168	3.2018	3.2064	1106952.0
2007-04-18 09:00:00	AAPL	Stock	3.2071	3.2214	3.2	3.2168	57020852.0
2007-04-18 10:00:00	AAPL	Stock	3.2168	3.2396	3.2146	3.2311	108391052.0
2007-04-18 11:00:00	AAPL	Stock	3.2314	3.2446	3.2296	3.23	75281696.0
2007-04-18 12:00:00	AAPL	Stock	3.2296	3.2339	3.2225	3.2293	51721964.0
2007-04-18 13:00:00	AAPL	Stock	3.2293	3.2397	3.2286	3.2329	40296508.0
2007-04-18 14:00:00	AAPL	Stock	3.2329	3.2364	3.2268	3.2296	40603248.0
2007-04-18 15:00:00	AAPL	Stock	3.2304	3.2414	3.2221	3.2271	80889872.0
2007-04-18 16:00:00	AAPL	Stock	3.2264	3.2354	3.2257	3.2271	1676220.0
2007-04-18 17:00:00	AAPL	Stock	3.2293	3.2336	3.2293	3.2321	135464.0
2007-04-18 18:00:00	AAPL	Stock	3.2321	3.2329	3.2286	3.23	112000.0
2007-04-18 19:00:00	AAPL	Stock	3.23	3.2386	3.23	3.2339	293468.0
2007-04-18 07:00:00	MSFT	Stock	28.8	29.04	28.74	28.77	5000.0
2007-04-18 08:00:00	MSFT	Stock	28.88	28.88	28.68	28.68	6397.0
2007-04-18 09:00:00	MSFT	Stock	28.74	28.74	28.37	28.44	5657089.0
2007-04-18 10:00:00	MSFT	Stock	28.45	28.61	28.36	28.54	7954463.0
2007-04-18 11:00:00	MSFT	Stock	28.542	28.64	28.41	28.432	4514261.0
2007-04-18 12:00:00	MSFT	Stock	28.43	28.52	28.41	28.5	2994328.0
2007-04-18 13:00:00	MSFT	Stock	28.492	28.52	28.46	28.49	3196909.0
2007-04-18 14:00:00	MSFT	Stock	28.49	28.57	28.45	28.45	5779312.0
2007-04-18 15:00:00	MSFT	Stock	28.45	28.67	28.44	28.57	8809747.0
2007-04-18 16:00:00	MSFT	Stock	28.59	28.79	28.575	28.63	1085755.0
2007-04-18 17:00:00	MSFT	Stock	28.72	28.81	28.6	28.81	141150.0
2007-04-18 18:00:00	MSFT	Stock	28.65	28.73	28.61	28.73	758.0
2007-04-18 08:00:00	NVDA	Stock	0.5122	0.5122	0.5122	0.5122	60000.0
2007-04-18 09:00:00	NVDA	Stock	0.511	0.516	0.5083	0.5137	58839420.0
2007-04-18 10:00:00	NVDA	Stock	0.5138	0.5175	0.51	0.5155	146752260.0
2007-04-18 11:00:00	NVDA	Stock	0.5153	0.5222	0.5148	0.522	99400200.0
2007-04-18 12:00:00	NVDA	Stock	0.5218	0.5227	0.5178	0.5193	83627940.0
2007-04-18 13:00:00	NVDA	Stock	0.5193	0.5213	0.5175	0.52	65215860.0
2007-04-18 14:00:00	NVDA	Stock	0.5202	0.5215	0.5187	0.5197	81350940.0
2007-04-18 15:00:00	NVDA	Stock	0.5197	0.5223	0.5182	0.5183	123283740.0
2007-04-18 16:00:00	NVDA	Stock	0.5183	0.5192	0.5182	0.5187	5689140.0
2007-04-18 17:00:00	NVDA	Stock	0.5187	0.5187	0.5187	0.5187	18000.0
2007-04-18 18:00:00	NVDA	Stock	0.5188	0.5188	0.5178	0.5178	75000.0
2007-04-18 08:00:00	AMZN	Stock	2.2385	2.2395	2.2325	2.2325	251680.0
2007-04-18 09:00:00	AMZN	Stock	2.2335	2.2575	2.233	2.248	18913240.0
2007-04-18 10:00:00	AMZN	Stock	2.2475	2.248	2.2315	2.241	18997120.0
2007-04-18 11:00:00	AMZN	Stock	2.241	2.243	2.2345	2.2375	10939660.0
2007-04-18 12:00:00	AMZN	Stock	2.238	2.2425	2.234	2.2405	8339060.0
2007-04-18 13:00:00	AMZN	Stock	2.24	2.2455	2.2335	2.2416	10121200.0
2007-04-18 14:00:00	AMZN	Stock	2.2415	2.25	2.241	2.2495	9581720.0
2007-04-18 15:00:00	AMZN	Stock	2.249	2.257	2.2475	2.2495	19211080.0
2007-04-18 16:00:00	AMZN	Stock	2.2475	2.2715	2.245	2.251	585780.0
2007-04-18 17:00:00	AMZN	Stock	2.2545	2.2555	2.245	2.245	123080.0
2007-04-18 18:00:00	AMZN	Stock	2.2425	2.253	2.2425	2.253	39000.0
2007-04-18 09:00:00	CL	Stock	33.5	33.76	33.25	33.295	183800.0
2007-04-18 10:00:00	CL	Stock	33.3	33.355	33.225	33.295	303478.0
2007-04-18 11:00:00	CL	Stock	33.305	33.335	33.285	33.285	637818.0

> showing 50 of 31,977 rows — these rows as CSV

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