PREVIEW / stock_1hour / 2002-06-18

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-06-18.parquet
  size:    409 KB
  rows:    19,279
  symbols: 1,436

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-18 08:00:00	AAPL	Stock	0.3673	0.3673	0.3641	0.3652	515200.0
2002-06-18 09:00:00	AAPL	Stock	0.3627	0.367	0.3618	0.3659	53524800.0
2002-06-18 10:00:00	AAPL	Stock	0.3657	0.3677	0.3637	0.3643	48076000.0
2002-06-18 11:00:00	AAPL	Stock	0.3648	0.3652	0.3593	0.365	41227200.0
2002-06-18 12:00:00	AAPL	Stock	0.365	0.3668	0.3625	0.3625	25905600.0
2002-06-18 13:00:00	AAPL	Stock	0.3625	0.3638	0.3607	0.3613	23184000.0
2002-06-18 14:00:00	AAPL	Stock	0.3613	0.362	0.3595	0.3605	42599200.0
2002-06-18 15:00:00	AAPL	Stock	0.3607	0.3625	0.3568	0.36	64064000.0
2002-06-18 16:00:00	AAPL	Stock	0.3598	0.3739	0.308	0.3214	31813600.0
2002-06-18 17:00:00	AAPL	Stock	0.3232	0.3614	0.3089	0.3107	18967200.0
2002-06-18 18:00:00	AAPL	Stock	0.3107	0.3125	0.308	0.3089	9368800.0
2002-06-18 08:00:00	MSFT	Stock	27.7	27.9	27.55	27.785	156200.0
2002-06-18 09:00:00	MSFT	Stock	27.775	28.025	27.675	27.975	10247200.0
2002-06-18 10:00:00	MSFT	Stock	27.975	28.085	27.885	27.965	12718000.0
2002-06-18 11:00:00	MSFT	Stock	27.959	28.095	27.845	28.065	8768400.0
2002-06-18 12:00:00	MSFT	Stock	28.05	28.075	27.945	27.985	6118600.0
2002-06-18 13:00:00	MSFT	Stock	27.985	28.045	27.95	27.975	8401200.0
2002-06-18 14:00:00	MSFT	Stock	27.975	28.05	27.9	28.045	11532800.0
2002-06-18 15:00:00	MSFT	Stock	28.0435	28.145	27.88	28.0	12536600.0
2002-06-18 16:00:00	MSFT	Stock	28.0	28.525	27.94	28.125	4585000.0
2002-06-18 17:00:00	MSFT	Stock	28.125	28.18	27.755	27.775	605000.0
2002-06-18 18:00:00	MSFT	Stock	27.755	27.975	27.7	27.75	84400.0
2002-06-18 08:00:00	NVDA	Stock	0.2371	0.2398	0.2334	0.235	1680000.0
2002-06-18 09:00:00	NVDA	Stock	0.235	0.2367	0.2313	0.2342	153768000.0
2002-06-18 10:00:00	NVDA	Stock	0.234	0.2417	0.2312	0.2409	275772000.0
2002-06-18 11:00:00	NVDA	Stock	0.241	0.2415	0.236	0.2391	170808000.0
2002-06-18 12:00:00	NVDA	Stock	0.2392	0.2402	0.2367	0.2375	47016000.0
2002-06-18 13:00:00	NVDA	Stock	0.2379	0.2381	0.2343	0.2371	72972000.0
2002-06-18 14:00:00	NVDA	Stock	0.2371	0.2415	0.2354	0.2413	94968000.0
2002-06-18 15:00:00	NVDA	Stock	0.2414	0.2425	0.2357	0.2357	123204000.0
2002-06-18 16:00:00	NVDA	Stock	0.2357	0.2429	0.2295	0.23	28620000.0
2002-06-18 17:00:00	NVDA	Stock	0.23	0.2358	0.2283	0.2292	2508000.0
2002-06-18 18:00:00	NVDA	Stock	0.2293	0.2308	0.2287	0.2287	480000.0
2002-06-18 08:00:00	AMZN	Stock	0.93	0.93	0.8965	0.91	996000.0
2002-06-18 09:00:00	AMZN	Stock	0.908	0.9335	0.8999	0.9325	20632000.0
2002-06-18 10:00:00	AMZN	Stock	0.934	0.958	0.9275	0.9495	49062000.0
2002-06-18 11:00:00	AMZN	Stock	0.95	0.9525	0.943	0.9485	19396000.0
2002-06-18 12:00:00	AMZN	Stock	0.9485	0.9505	0.9395	0.9435	15264000.0
2002-06-18 13:00:00	AMZN	Stock	0.9445	0.945	0.934	0.936	19048000.0
2002-06-18 14:00:00	AMZN	Stock	0.936	0.941	0.934	0.9395	10374000.0
2002-06-18 15:00:00	AMZN	Stock	0.9395	0.9445	0.9375	0.939	16580000.0
2002-06-18 16:00:00	AMZN	Stock	0.9395	0.95	0.9125	0.944	2158000.0
2002-06-18 17:00:00	AMZN	Stock	0.945	0.945	0.933	0.933	290000.0
2002-06-18 18:00:00	AMZN	Stock	0.933	0.933	0.933	0.933	18000.0
2002-06-18 09:00:00	CL	Stock	26.85	26.865	26.65	26.75	283200.0
2002-06-18 10:00:00	CL	Stock	26.725	26.875	26.635	26.635	526400.0
2002-06-18 11:00:00	CL	Stock	26.635	26.7	26.56	26.635	392000.0
2002-06-18 12:00:00	CL	Stock	26.65	26.685	26.6	26.625	216600.0
2002-06-18 13:00:00	CL	Stock	26.62	26.65	26.525	26.55	349400.0
2002-06-18 14:00:00	CL	Stock	26.55	26.575	26.47	26.57	487600.0

> showing 50 of 19,279 rows — these rows as CSV

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