PREVIEW / stock_1hour / 2004-01-16

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-01-16.parquet
  size:    508 KB
  rows:    23,055
  symbols: 1,713

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
2004-01-16 08:00:00	AAPL	Stock	0.4107	0.412	0.408	0.4107	880712.0
2004-01-16 09:00:00	AAPL	Stock	0.4107	0.4113	0.4061	0.4091	77975856.0
2004-01-16 10:00:00	AAPL	Stock	0.4089	0.4102	0.4057	0.4057	82687192.0
2004-01-16 11:00:00	AAPL	Stock	0.4057	0.4086	0.4054	0.4081	30295160.0
2004-01-16 12:00:00	AAPL	Stock	0.408	0.4088	0.407	0.4086	20330912.0
2004-01-16 13:00:00	AAPL	Stock	0.4088	0.41	0.4057	0.4082	33180000.0
2004-01-16 14:00:00	AAPL	Stock	0.4084	0.4086	0.4043	0.4046	35065800.0
2004-01-16 15:00:00	AAPL	Stock	0.4046	0.4064	0.4041	0.4043	67035864.0
2004-01-16 16:00:00	AAPL	Stock	0.4043	0.4071	0.4038	0.4054	9941624.0
2004-01-16 17:00:00	AAPL	Stock	0.4054	0.4054	0.404	0.4046	609280.0
2004-01-16 18:00:00	AAPL	Stock	0.4043	0.4043	0.4038	0.4038	16800.0
2004-01-16 08:00:00	MSFT	Stock	27.59	27.7	27.59	27.64	63843.0
2004-01-16 09:00:00	MSFT	Stock	27.64	27.74	27.6	27.62	8287790.0
2004-01-16 10:00:00	MSFT	Stock	27.61	27.72	27.57	27.64	9329006.0
2004-01-16 11:00:00	MSFT	Stock	27.64	27.72	27.63	27.71	7601788.0
2004-01-16 12:00:00	MSFT	Stock	27.71	27.75	27.68	27.74	5046180.0
2004-01-16 13:00:00	MSFT	Stock	27.74	27.82	27.74	27.81	8482785.0
2004-01-16 14:00:00	MSFT	Stock	27.81	27.82	27.66	27.72	7020701.0
2004-01-16 15:00:00	MSFT	Stock	27.73	27.84	27.71	27.82	8678185.0
2004-01-16 16:00:00	MSFT	Stock	27.82	27.88	27.73	27.83	1179630.0
2004-01-16 17:00:00	MSFT	Stock	27.8655	27.8655	27.78	27.84	64646.0
2004-01-16 18:00:00	MSFT	Stock	27.84	27.85	27.66	27.66	13270.0
2004-01-16 08:00:00	NVDA	Stock	0.2083	0.2083	0.2033	0.2054	780000.0
2004-01-16 09:00:00	NVDA	Stock	0.205	0.2056	0.2028	0.2032	55870440.0
2004-01-16 10:00:00	NVDA	Stock	0.203	0.2048	0.2026	0.2038	57223680.0
2004-01-16 11:00:00	NVDA	Stock	0.2038	0.2049	0.2037	0.2044	48240360.0
2004-01-16 12:00:00	NVDA	Stock	0.2045	0.2058	0.2044	0.2058	51760440.0
2004-01-16 13:00:00	NVDA	Stock	0.2059	0.2072	0.2057	0.2059	55758360.0
2004-01-16 14:00:00	NVDA	Stock	0.206	0.2067	0.2041	0.2047	59097600.0
2004-01-16 15:00:00	NVDA	Stock	0.2047	0.2061	0.2042	0.2047	93909120.0
2004-01-16 16:00:00	NVDA	Stock	0.2057	0.2057	0.2037	0.2042	11920560.0
2004-01-16 17:00:00	NVDA	Stock	0.2054	0.2054	0.2043	0.2049	450720.0
2004-01-16 18:00:00	NVDA	Stock	0.2042	0.2045	0.2042	0.2045	216000.0
2004-01-16 08:00:00	AMZN	Stock	2.8255	2.8255	2.786	2.8135	68000.0
2004-01-16 09:00:00	AMZN	Stock	2.8175	2.8205	2.7665	2.7755	27953860.0
2004-01-16 10:00:00	AMZN	Stock	2.7755	2.79	2.77	2.785	26541960.0
2004-01-16 11:00:00	AMZN	Stock	2.785	2.7875	2.77	2.776	19047500.0
2004-01-16 12:00:00	AMZN	Stock	2.7775	2.78	2.7735	2.777	12085840.0
2004-01-16 13:00:00	AMZN	Stock	2.777	2.7785	2.7635	2.7725	12080640.0
2004-01-16 14:00:00	AMZN	Stock	2.7725	2.7845	2.7715	2.7805	14359800.0
2004-01-16 15:00:00	AMZN	Stock	2.78	2.813	2.7775	2.786	46317140.0
2004-01-16 16:00:00	AMZN	Stock	2.786	2.787	2.7725	2.777	20557040.0
2004-01-16 17:00:00	AMZN	Stock	2.7853	2.786	2.7724	2.7755	634580.0
2004-01-16 18:00:00	AMZN	Stock	2.777	2.777	2.777	2.777	2000.0
2004-01-16 09:00:00	CL	Stock	25.725	25.75	25.61	25.62	972600.0
2004-01-16 10:00:00	CL	Stock	25.615	25.745	25.59	25.65	759600.0
2004-01-16 11:00:00	CL	Stock	25.65	25.675	25.535	25.61	588200.0
2004-01-16 12:00:00	CL	Stock	25.615	25.635	25.6	25.635	276400.0
2004-01-16 13:00:00	CL	Stock	25.63	25.635	25.575	25.58	389600.0
2004-01-16 14:00:00	CL	Stock	25.58	25.615	25.515	25.54	314000.0

> showing 50 of 23,055 rows — these rows as CSV

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