PREVIEW / stock_1hour / 2005-11-07

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-11-07.parquet
  size:    570 KB
  rows:    27,032
  symbols: 2,108

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-07 06:00:00	AAPL	Stock	2.1982	2.1982	2.1982	2.1982	14000.0
2005-11-07 07:00:00	AAPL	Stock	2.1982	2.2075	2.1875	2.1875	493668.0
2005-11-07 08:00:00	AAPL	Stock	2.1893	2.1968	2.1564	2.1689	8128316.0
2005-11-07 09:00:00	AAPL	Stock	2.1686	2.2025	2.1604	2.1746	146002360.0
2005-11-07 10:00:00	AAPL	Stock	2.175	2.1857	2.1604	2.1804	115347204.0
2005-11-07 11:00:00	AAPL	Stock	2.1804	2.1818	2.1543	2.1561	82710908.0
2005-11-07 12:00:00	AAPL	Stock	2.1561	2.1725	2.1521	2.1593	72679992.0
2005-11-07 13:00:00	AAPL	Stock	2.1593	2.1631	2.1479	2.1564	58853844.0
2005-11-07 14:00:00	AAPL	Stock	2.1564	2.1664	2.15	2.1582	59073952.0
2005-11-07 15:00:00	AAPL	Stock	2.1586	2.1614	2.1507	2.1525	84330204.0
2005-11-07 16:00:00	AAPL	Stock	2.1525	2.1554	2.1461	2.1521	1513904.0
2005-11-07 17:00:00	AAPL	Stock	2.1521	2.1543	2.1486	2.1486	1402884.0
2005-11-07 18:00:00	AAPL	Stock	2.1486	2.1507	2.1464	2.1464	609868.0
2005-11-07 08:00:00	MSFT	Stock	26.66	26.77	26.66	26.72	38389.0
2005-11-07 09:00:00	MSFT	Stock	26.72	26.85	26.65	26.81	6513956.0
2005-11-07 10:00:00	MSFT	Stock	26.81	26.84	26.7	26.76	7287829.0
2005-11-07 11:00:00	MSFT	Stock	26.76	26.82	26.7	26.78	8051825.0
2005-11-07 12:00:00	MSFT	Stock	26.77	26.83	26.758	26.81	4852920.0
2005-11-07 13:00:00	MSFT	Stock	26.82	26.9	26.795	26.89	7662716.0
2005-11-07 14:00:00	MSFT	Stock	26.89	27.001	26.88	26.98	13275311.0
2005-11-07 15:00:00	MSFT	Stock	26.99	27.081	26.92	27.01	26444466.0
2005-11-07 16:00:00	MSFT	Stock	27.0	27.05	26.915	27.02	821671.0
2005-11-07 17:00:00	MSFT	Stock	27.02	27.02	26.897	27.02	189866.0
2005-11-07 18:00:00	MSFT	Stock	27.02	27.02	26.98	26.98	3948.0
2005-11-07 08:00:00	NVDA	Stock	0.2849	0.2849	0.2849	0.2849	18000.0
2005-11-07 09:00:00	NVDA	Stock	0.2842	0.2863	0.2837	0.2846	36255000.0
2005-11-07 10:00:00	NVDA	Stock	0.2846	0.2852	0.2814	0.285	78475800.0
2005-11-07 11:00:00	NVDA	Stock	0.285	0.285	0.2823	0.2837	49832400.0
2005-11-07 12:00:00	NVDA	Stock	0.2836	0.2847	0.2833	0.2846	23488680.0
2005-11-07 13:00:00	NVDA	Stock	0.2847	0.2852	0.2839	0.2844	37742280.0
2005-11-07 14:00:00	NVDA	Stock	0.2843	0.285	0.2835	0.2843	39015960.0
2005-11-07 15:00:00	NVDA	Stock	0.2843	0.2843	0.2822	0.2827	79490640.0
2005-11-07 16:00:00	NVDA	Stock	0.2834	0.2853	0.283	0.2836	2452680.0
2005-11-07 17:00:00	NVDA	Stock	0.2833	0.2833	0.2833	0.2833	96000.0
2005-11-07 08:00:00	AMZN	Stock	2.055	2.055	2.0385	2.0385	8000.0
2005-11-07 09:00:00	AMZN	Stock	2.046	2.06	2.0455	2.0495	7682900.0
2005-11-07 10:00:00	AMZN	Stock	2.0495	2.06	2.0275	2.0495	14087300.0
2005-11-07 11:00:00	AMZN	Stock	2.0495	2.059	2.0435	2.0495	6321840.0
2005-11-07 12:00:00	AMZN	Stock	2.0495	2.0655	2.0455	2.0635	6864260.0
2005-11-07 13:00:00	AMZN	Stock	2.064	2.0645	2.0515	2.0525	4345120.0
2005-11-07 14:00:00	AMZN	Stock	2.0525	2.0735	2.048	2.07	9909920.0
2005-11-07 15:00:00	AMZN	Stock	2.07	2.0705	2.0585	2.0685	14794960.0
2005-11-07 16:00:00	AMZN	Stock	2.0685	2.0695	2.0615	2.0615	122120.0
2005-11-07 17:00:00	AMZN	Stock	2.0615	2.07	2.0615	2.07	866520.0
2005-11-07 09:00:00	CL	Stock	25.925	25.98	25.595	25.73	646200.0
2005-11-07 10:00:00	CL	Stock	25.715	25.845	25.715	25.785	594800.0
2005-11-07 11:00:00	CL	Stock	25.785	25.855	25.77	25.825	552400.0
2005-11-07 12:00:00	CL	Stock	25.825	25.89	25.815	25.865	363600.0
2005-11-07 13:00:00	CL	Stock	25.855	25.87	25.8	25.81	975200.0
2005-11-07 14:00:00	CL	Stock	25.815	25.95	25.76	25.95	760800.0

> showing 50 of 27,032 rows — these rows as CSV

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