PREVIEW / stock_1hour / 2002-06-14

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-06-14.parquet
  size:    398 KB
  rows:    18,865
  symbols: 1,435

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
2002-06-14 08:00:00	AAPL	Stock	0.35	0.35	0.3448	0.3464	750400.0
2002-06-14 09:00:00	AAPL	Stock	0.3465	0.3489	0.3239	0.3241	48624800.0
2002-06-14 10:00:00	AAPL	Stock	0.3236	0.3502	0.3234	0.3484	78663200.0
2002-06-14 11:00:00	AAPL	Stock	0.3484	0.3486	0.34	0.3441	50870400.0
2002-06-14 12:00:00	AAPL	Stock	0.344	0.3525	0.343	0.35	48647200.0
2002-06-14 13:00:00	AAPL	Stock	0.35	0.351	0.3455	0.3493	22887200.0
2002-06-14 14:00:00	AAPL	Stock	0.3489	0.3636	0.3488	0.362	68846400.0
2002-06-14 15:00:00	AAPL	Stock	0.3618	0.3618	0.3571	0.3589	68633600.0
2002-06-14 16:00:00	AAPL	Stock	0.3589	0.3625	0.3473	0.3597	9956800.0
2002-06-14 08:00:00	MSFT	Stock	26.7	27.2068	26.5	26.6	668000.0
2002-06-14 09:00:00	MSFT	Stock	26.575	27.065	26.5	26.55	17294800.0
2002-06-14 10:00:00	MSFT	Stock	26.5525	27.3	26.5	27.225	27116600.0
2002-06-14 11:00:00	MSFT	Stock	27.225	27.575	27.088	27.51	16007600.0
2002-06-14 12:00:00	MSFT	Stock	27.51	27.585	27.35	27.4605	11784400.0
2002-06-14 13:00:00	MSFT	Stock	27.47	27.54	27.275	27.36	7967200.0
2002-06-14 14:00:00	MSFT	Stock	27.37	27.6795	27.28	27.55	12451400.0
2002-06-14 15:00:00	MSFT	Stock	27.54	27.765	27.425	27.635	12108000.0
2002-06-14 16:00:00	MSFT	Stock	27.63	27.75	27.2113	27.75	1769400.0
2002-06-14 17:00:00	MSFT	Stock	27.725	27.725	27.625	27.665	20600.0
2002-06-14 18:00:00	MSFT	Stock	27.7	27.7	27.69	27.7	2400.0
2002-06-14 08:00:00	NVDA	Stock	0.2275	0.2312	0.2229	0.2237	2412000.0
2002-06-14 09:00:00	NVDA	Stock	0.2242	0.2305	0.2145	0.2177	190152000.0
2002-06-14 10:00:00	NVDA	Stock	0.2177	0.227	0.2172	0.225	228156000.0
2002-06-14 11:00:00	NVDA	Stock	0.225	0.2337	0.2225	0.2305	194448000.0
2002-06-14 12:00:00	NVDA	Stock	0.2305	0.2329	0.2263	0.2302	125160000.0
2002-06-14 13:00:00	NVDA	Stock	0.2302	0.2317	0.2277	0.2315	61404000.0
2002-06-14 14:00:00	NVDA	Stock	0.2317	0.2366	0.2302	0.2342	137412000.0
2002-06-14 15:00:00	NVDA	Stock	0.2342	0.235	0.2312	0.2349	136644000.0
2002-06-14 16:00:00	NVDA	Stock	0.2349	0.2396	0.2346	0.239	14040000.0
2002-06-14 17:00:00	NVDA	Stock	0.2389	0.2391	0.238	0.238	4476000.0
2002-06-14 18:00:00	NVDA	Stock	0.2381	0.2398	0.2381	0.2398	300000.0
2002-06-14 08:00:00	AMZN	Stock	0.8595	0.869	0.8475	0.8565	230000.0
2002-06-14 09:00:00	AMZN	Stock	0.8565	0.863	0.815	0.815	28246000.0
2002-06-14 10:00:00	AMZN	Stock	0.815	0.848	0.813	0.84	41328000.0
2002-06-14 11:00:00	AMZN	Stock	0.8405	0.841	0.83	0.834	13596000.0
2002-06-14 12:00:00	AMZN	Stock	0.834	0.837	0.826	0.829	19288000.0
2002-06-14 13:00:00	AMZN	Stock	0.8295	0.83	0.8255	0.828	12078000.0
2002-06-14 14:00:00	AMZN	Stock	0.8285	0.8405	0.828	0.8365	16708000.0
2002-06-14 15:00:00	AMZN	Stock	0.837	0.843	0.832	0.843	18944000.0
2002-06-14 16:00:00	AMZN	Stock	0.8405	0.845	0.8325	0.845	2934000.0
2002-06-14 17:00:00	AMZN	Stock	0.84	0.845	0.84	0.845	30000.0
2002-06-14 18:00:00	AMZN	Stock	0.845	0.845	0.845	0.845	2000.0
2002-06-14 09:00:00	CL	Stock	26.075	26.225	26.025	26.025	390600.0
2002-06-14 10:00:00	CL	Stock	26.0	26.225	25.955	26.075	636800.0
2002-06-14 11:00:00	CL	Stock	26.075	26.15	25.875	25.96	614200.0
2002-06-14 12:00:00	CL	Stock	25.965	26.025	25.85	25.875	358200.0
2002-06-14 13:00:00	CL	Stock	25.88	26.165	25.88	26.16	491000.0
2002-06-14 14:00:00	CL	Stock	26.17	26.315	26.09	26.145	518600.0
2002-06-14 15:00:00	CL	Stock	26.125	26.325	26.05	26.295	593800.0
2002-06-14 16:00:00	CL	Stock	26.295	26.3	26.08	26.275	341000.0

> showing 50 of 18,865 rows — these rows as CSV

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