PREVIEW / stock_1hour / 2005-06-16

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-06-16.parquet
  size:    561 KB
  rows:    26,765
  symbols: 1,990

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-06-16 08:00:00	AAPL	Stock	1.3218	1.3296	1.3189	1.3189	360080.0
2005-06-16 09:00:00	AAPL	Stock	1.3171	1.3479	1.315	1.3404	122920140.0
2005-06-16 10:00:00	AAPL	Stock	1.3404	1.36	1.3389	1.3529	142457112.0
2005-06-16 11:00:00	AAPL	Stock	1.3529	1.3564	1.3475	1.3545	55417740.0
2005-06-16 12:00:00	AAPL	Stock	1.3543	1.355	1.3421	1.3475	53948468.0
2005-06-16 13:00:00	AAPL	Stock	1.3472	1.3493	1.3436	1.3457	28550704.0
2005-06-16 14:00:00	AAPL	Stock	1.3457	1.3511	1.3429	1.3482	31424316.0
2005-06-16 15:00:00	AAPL	Stock	1.3482	1.36	1.3471	1.3561	95163880.0
2005-06-16 16:00:00	AAPL	Stock	1.3561	1.3607	1.3543	1.3589	2656640.0
2005-06-16 17:00:00	AAPL	Stock	1.3593	1.3614	1.3495	1.3554	5377764.0
2005-06-16 18:00:00	AAPL	Stock	1.3543	1.3593	1.3543	1.3593	112000.0
2005-06-16 08:00:00	MSFT	Stock	25.27	25.29	25.26	25.26	10030.0
2005-06-16 09:00:00	MSFT	Stock	25.26	25.28	25.12	25.13	6214909.0
2005-06-16 10:00:00	MSFT	Stock	25.13	25.17	25.04	25.1	13731293.0
2005-06-16 11:00:00	MSFT	Stock	25.11	25.14	25.08	25.13	6729089.0
2005-06-16 12:00:00	MSFT	Stock	25.12	25.15	25.05	25.06	8128192.0
2005-06-16 13:00:00	MSFT	Stock	25.06	25.1	25.02	25.05	6258254.0
2005-06-16 14:00:00	MSFT	Stock	25.05	25.06	24.95	25.02	13798696.0
2005-06-16 15:00:00	MSFT	Stock	25.02	25.115	24.99	25.04	9797682.0
2005-06-16 16:00:00	MSFT	Stock	25.04	25.07	25.01	25.01	295320.0
2005-06-16 17:00:00	MSFT	Stock	25.05	25.067	25.03	25.04	1159460.0
2005-06-16 18:00:00	MSFT	Stock	25.03	25.03	25.02	25.02	3800.0
2005-06-16 08:00:00	NVDA	Stock	0.2242	0.2242	0.2237	0.2237	333600.0
2005-06-16 09:00:00	NVDA	Stock	0.2244	0.226	0.2162	0.2225	94733880.0
2005-06-16 10:00:00	NVDA	Stock	0.2225	0.2262	0.2202	0.225	140893320.0
2005-06-16 11:00:00	NVDA	Stock	0.2249	0.2257	0.2241	0.2257	42445680.0
2005-06-16 12:00:00	NVDA	Stock	0.2256	0.2257	0.2234	0.2251	45981480.0
2005-06-16 13:00:00	NVDA	Stock	0.2252	0.2257	0.2242	0.2251	36713760.0
2005-06-16 14:00:00	NVDA	Stock	0.225	0.2253	0.2239	0.2244	39873480.0
2005-06-16 15:00:00	NVDA	Stock	0.2245	0.2256	0.2241	0.2246	71265360.0
2005-06-16 16:00:00	NVDA	Stock	0.2247	0.2253	0.2247	0.225	2987400.0
2005-06-16 17:00:00	NVDA	Stock	0.225	0.2254	0.2243	0.2254	7410840.0
2005-06-16 18:00:00	NVDA	Stock	0.225	0.2255	0.225	0.2255	144000.0
2005-06-16 08:00:00	AMZN	Stock	1.763	1.763	1.7625	1.7625	4000.0
2005-06-16 09:00:00	AMZN	Stock	1.762	1.7695	1.758	1.7655	8124040.0
2005-06-16 10:00:00	AMZN	Stock	1.7655	1.77	1.764	1.7685	10213860.0
2005-06-16 11:00:00	AMZN	Stock	1.769	1.7845	1.7685	1.782	10070140.0
2005-06-16 12:00:00	AMZN	Stock	1.782	1.7835	1.766	1.7666	6863780.0
2005-06-16 13:00:00	AMZN	Stock	1.7665	1.7775	1.763	1.7755	10572860.0
2005-06-16 14:00:00	AMZN	Stock	1.7755	1.7825	1.768	1.7715	13371680.0
2005-06-16 15:00:00	AMZN	Stock	1.771	1.7905	1.771	1.7795	22056340.0
2005-06-16 16:00:00	AMZN	Stock	1.782	1.783	1.7795	1.781	307420.0
2005-06-16 17:00:00	AMZN	Stock	1.779	1.7805	1.7744	1.7805	3228700.0
2005-06-16 09:00:00	CL	Stock	24.725	24.725	24.655	24.725	299400.0
2005-06-16 10:00:00	CL	Stock	24.72	24.755	24.68	24.7	441200.0
2005-06-16 11:00:00	CL	Stock	24.7	24.705	24.6	24.645	537600.0
2005-06-16 12:00:00	CL	Stock	24.64	24.64	24.575	24.58	516600.0
2005-06-16 13:00:00	CL	Stock	24.58	24.6	24.535	24.555	323200.0
2005-06-16 14:00:00	CL	Stock	24.545	24.555	24.5	24.545	535600.0
2005-06-16 15:00:00	CL	Stock	24.545	24.545	24.44	24.45	1361800.0

> showing 50 of 26,765 rows — these rows as CSV

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