PREVIEW / stock_1hour / 2005-03-30

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-03-30.parquet
  size:    564 KB
  rows:    26,919
  symbols: 1,961

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-03-30 08:00:00	AAPL	Stock	1.4964	1.5	1.4964	1.4982	889448.0
2005-03-30 09:00:00	AAPL	Stock	1.4982	1.5061	1.4936	1.4986	40983824.0
2005-03-30 10:00:00	AAPL	Stock	1.4987	1.5225	1.4986	1.5182	87777228.0
2005-03-30 11:00:00	AAPL	Stock	1.5179	1.5254	1.5118	1.525	48818112.0
2005-03-30 12:00:00	AAPL	Stock	1.525	1.5279	1.5186	1.5225	37104704.0
2005-03-30 13:00:00	AAPL	Stock	1.5225	1.5239	1.5143	1.5186	39965968.0
2005-03-30 14:00:00	AAPL	Stock	1.5182	1.5214	1.51	1.515	45491124.0
2005-03-30 15:00:00	AAPL	Stock	1.5146	1.5286	1.5132	1.5254	81528916.0
2005-03-30 16:00:00	AAPL	Stock	1.5261	1.5286	1.5189	1.5268	3322732.0
2005-03-30 17:00:00	AAPL	Stock	1.524	1.5321	1.524	1.5321	541576.0
2005-03-30 18:00:00	AAPL	Stock	1.5286	1.5329	1.5286	1.5286	278068.0
2005-03-30 08:00:00	MSFT	Stock	23.98	24.03	23.98	23.99	34808.0
2005-03-30 09:00:00	MSFT	Stock	23.99	24.12	23.97	24.08	8305879.0
2005-03-30 10:00:00	MSFT	Stock	24.07	24.19	24.05	24.12	11954282.0
2005-03-30 11:00:00	MSFT	Stock	24.12	24.17	24.08	24.15	6044312.0
2005-03-30 12:00:00	MSFT	Stock	24.16	24.17	24.08	24.08	5163038.0
2005-03-30 13:00:00	MSFT	Stock	24.09	24.12	24.02	24.07	5686206.0
2005-03-30 14:00:00	MSFT	Stock	24.07	24.14	24.02	24.04	7522901.0
2005-03-30 15:00:00	MSFT	Stock	24.04	24.16	24.02	24.15	12517720.0
2005-03-30 16:00:00	MSFT	Stock	24.14	24.17	24.13	24.16	825984.0
2005-03-30 17:00:00	MSFT	Stock	24.16	24.18	24.12	24.14	211484.0
2005-03-30 18:00:00	MSFT	Stock	24.14	24.17	24.14	24.17	44612.0
2005-03-30 09:00:00	NVDA	Stock	0.2042	0.2054	0.1956	0.1967	149856480.0
2005-03-30 10:00:00	NVDA	Stock	0.1964	0.2013	0.196	0.2002	184456920.0
2005-03-30 11:00:00	NVDA	Stock	0.2002	0.2012	0.1987	0.1993	93223920.0
2005-03-30 12:00:00	NVDA	Stock	0.1999	0.2	0.199	0.199	69161760.0
2005-03-30 13:00:00	NVDA	Stock	0.199	0.1992	0.1982	0.1991	70552080.0
2005-03-30 14:00:00	NVDA	Stock	0.1992	0.2008	0.1984	0.2006	104633760.0
2005-03-30 15:00:00	NVDA	Stock	0.2007	0.2026	0.2004	0.2025	150975000.0
2005-03-30 16:00:00	NVDA	Stock	0.2024	0.2025	0.2022	0.2023	11119440.0
2005-03-30 17:00:00	NVDA	Stock	0.2025	0.2025	0.202	0.2025	3715680.0
2005-03-30 08:00:00	AMZN	Stock	1.675	1.6795	1.675	1.6795	17800.0
2005-03-30 09:00:00	AMZN	Stock	1.6765	1.703	1.673	1.6965	14324920.0
2005-03-30 10:00:00	AMZN	Stock	1.6965	1.7155	1.693	1.709	23516620.0
2005-03-30 11:00:00	AMZN	Stock	1.7095	1.7185	1.7025	1.7175	12609580.0
2005-03-30 12:00:00	AMZN	Stock	1.7185	1.725	1.715	1.722	10891760.0
2005-03-30 13:00:00	AMZN	Stock	1.722	1.726	1.714	1.716	15056600.0
2005-03-30 14:00:00	AMZN	Stock	1.716	1.722	1.7085	1.7155	10483760.0
2005-03-30 15:00:00	AMZN	Stock	1.714	1.7185	1.7115	1.7185	16855680.0
2005-03-30 16:00:00	AMZN	Stock	1.716	1.7195	1.713	1.716	1847900.0
2005-03-30 17:00:00	AMZN	Stock	1.716	1.7161	1.7125	1.7125	80840.0
2005-03-30 18:00:00	AMZN	Stock	1.716	1.716	1.716	1.716	399100.0
2005-03-30 09:00:00	CL	Stock	25.675	25.83	25.67	25.815	157200.0
2005-03-30 10:00:00	CL	Stock	25.81	25.945	25.765	25.943	246400.0
2005-03-30 11:00:00	CL	Stock	25.935	25.99	25.9	25.985	292800.0
2005-03-30 12:00:00	CL	Stock	25.99	25.995	25.93	25.945	227800.0
2005-03-30 13:00:00	CL	Stock	25.945	25.985	25.9	25.94	273400.0
2005-03-30 14:00:00	CL	Stock	25.95	25.985	25.88	25.94	414600.0
2005-03-30 15:00:00	CL	Stock	25.93	26.23	25.925	26.14	1084800.0
2005-03-30 16:00:00	CL	Stock	26.14	26.1415	25.945	26.14	172400.0

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

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