PREVIEW / stock_1hour / 2005-11-09

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-11-09.parquet
  size:    566 KB
  rows:    26,671
  symbols: 2,100

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-11-09 07:00:00	AAPL	Stock	2.145	2.1496	2.145	2.1496	30800.0
2005-11-09 08:00:00	AAPL	Stock	2.1429	2.1496	2.1393	2.1461	1586256.0
2005-11-09 09:00:00	AAPL	Stock	2.1432	2.1861	2.1429	2.1668	107841692.0
2005-11-09 10:00:00	AAPL	Stock	2.1664	2.1857	2.1561	2.1696	114540944.0
2005-11-09 11:00:00	AAPL	Stock	2.17	2.1736	2.1607	2.1643	54139120.0
2005-11-09 12:00:00	AAPL	Stock	2.1646	2.18	2.1518	2.1764	73959536.0
2005-11-09 13:00:00	AAPL	Stock	2.1764	2.1786	2.1604	2.1679	43785560.0
2005-11-09 14:00:00	AAPL	Stock	2.1679	2.1714	2.1554	2.1579	41893208.0
2005-11-09 15:00:00	AAPL	Stock	2.1582	2.1689	2.1443	2.1489	86896628.0
2005-11-09 16:00:00	AAPL	Stock	2.1482	2.1704	2.1454	2.1536	2131976.0
2005-11-09 17:00:00	AAPL	Stock	2.1521	2.1521	2.1411	2.1464	639548.0
2005-11-09 18:00:00	AAPL	Stock	2.145	2.1514	2.1432	2.1482	118552.0
2005-11-09 08:00:00	MSFT	Stock	27.06	27.06	26.98	26.99	29812.0
2005-11-09 09:00:00	MSFT	Stock	26.99	27.03	26.94	27.0	7730002.0
2005-11-09 10:00:00	MSFT	Stock	27.0	27.15	26.96	27.022	10308212.0
2005-11-09 11:00:00	MSFT	Stock	27.022	27.06	26.99	27.04	6446795.0
2005-11-09 12:00:00	MSFT	Stock	27.04	27.14	27.0	27.07	7745962.0
2005-11-09 13:00:00	MSFT	Stock	27.07	27.12	27.0	27.07	6130974.0
2005-11-09 14:00:00	MSFT	Stock	27.08	27.09	27.02	27.07	5816391.0
2005-11-09 15:00:00	MSFT	Stock	27.08	27.11	26.96	26.96	12004563.0
2005-11-09 16:00:00	MSFT	Stock	26.95	27.02	26.8	27.0	624030.0
2005-11-09 17:00:00	MSFT	Stock	27.0	27.0	26.91	26.94	16795.0
2005-11-09 08:00:00	NVDA	Stock	0.2782	0.2783	0.2782	0.2783	480000.0
2005-11-09 09:00:00	NVDA	Stock	0.2775	0.2827	0.2747	0.2811	84440160.0
2005-11-09 10:00:00	NVDA	Stock	0.2811	0.2842	0.2804	0.2815	98219400.0
2005-11-09 11:00:00	NVDA	Stock	0.2813	0.2835	0.2806	0.2827	75920520.0
2005-11-09 12:00:00	NVDA	Stock	0.2827	0.2899	0.2827	0.2897	101590080.0
2005-11-09 13:00:00	NVDA	Stock	0.2897	0.2917	0.2878	0.2893	66208200.0
2005-11-09 14:00:00	NVDA	Stock	0.2892	0.2902	0.2875	0.2892	59743920.0
2005-11-09 15:00:00	NVDA	Stock	0.2891	0.2904	0.2878	0.2903	163485480.0
2005-11-09 16:00:00	NVDA	Stock	0.2897	0.2908	0.2737	0.283	61741080.0
2005-11-09 17:00:00	NVDA	Stock	0.2833	0.2979	0.2758	0.2958	63122760.0
2005-11-09 18:00:00	NVDA	Stock	0.2958	0.3041	0.2943	0.3025	15211080.0
2005-11-09 09:00:00	AMZN	Stock	2.096	2.1	2.075	2.078	7315480.0
2005-11-09 10:00:00	AMZN	Stock	2.078	2.0875	2.0705	2.081	12292380.0
2005-11-09 11:00:00	AMZN	Stock	2.081	2.081	2.064	2.068	6265920.0
2005-11-09 12:00:00	AMZN	Stock	2.0675	2.078	2.064	2.0715	7371280.0
2005-11-09 13:00:00	AMZN	Stock	2.0715	2.08	2.068	2.0795	5426940.0
2005-11-09 14:00:00	AMZN	Stock	2.079	2.089	2.073	2.0825	7338560.0
2005-11-09 15:00:00	AMZN	Stock	2.08	2.0955	2.0675	2.07	16819840.0
2005-11-09 16:00:00	AMZN	Stock	2.0695	2.07	2.0675	2.069	432080.0
2005-11-09 17:00:00	AMZN	Stock	2.0695	2.0695	2.0695	2.0695	20000.0
2005-11-09 18:00:00	AMZN	Stock	2.0725	2.0745	2.0655	2.0745	24900.0
2005-11-09 08:00:00	CL	Stock	26.33	26.33	26.33	26.33	1400.0
2005-11-09 09:00:00	CL	Stock	26.41	26.585	26.35	26.555	397200.0
2005-11-09 10:00:00	CL	Stock	26.55	26.64	26.47	26.595	872200.0
2005-11-09 11:00:00	CL	Stock	26.595	26.6	26.495	26.545	519800.0
2005-11-09 12:00:00	CL	Stock	26.55	26.64	26.48	26.575	532800.0
2005-11-09 13:00:00	CL	Stock	26.565	26.585	26.49	26.53	311600.0
2005-11-09 14:00:00	CL	Stock	26.53	26.59	26.48	26.52	491000.0

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

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