PREVIEW / stock_1hour / 2005-07-19

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-07-19.parquet
  size:    559 KB
  rows:    26,542
  symbols: 2,031

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-07-19 07:00:00	AAPL	Stock	1.5014	1.5032	1.4946	1.4946	50400.0
2005-07-19 08:00:00	AAPL	Stock	1.495	1.495	1.4857	1.4904	1129268.0
2005-07-19 09:00:00	AAPL	Stock	1.4904	1.4982	1.4668	1.4911	68121704.0
2005-07-19 10:00:00	AAPL	Stock	1.4914	1.5232	1.49	1.5161	156034648.0
2005-07-19 11:00:00	AAPL	Stock	1.5157	1.5196	1.5125	1.5164	53106508.0
2005-07-19 12:00:00	AAPL	Stock	1.5164	1.5296	1.5154	1.5275	58057160.0
2005-07-19 13:00:00	AAPL	Stock	1.5271	1.5336	1.5239	1.5246	64991584.0
2005-07-19 14:00:00	AAPL	Stock	1.5243	1.5371	1.5239	1.5357	85464372.0
2005-07-19 15:00:00	AAPL	Stock	1.5353	1.5439	1.5318	1.5432	172794244.0
2005-07-19 16:00:00	AAPL	Stock	1.5439	1.5443	1.5179	1.5268	5941236.0
2005-07-19 17:00:00	AAPL	Stock	1.5268	1.5439	1.5232	1.5243	1734040.0
2005-07-19 18:00:00	AAPL	Stock	1.5321	1.5321	1.5218	1.5218	497280.0
2005-07-19 08:00:00	MSFT	Stock	25.79	25.8	25.7	25.76	33996.0
2005-07-19 09:00:00	MSFT	Stock	25.76	25.97	25.71	25.962	13663608.0
2005-07-19 10:00:00	MSFT	Stock	25.96	26.05	25.89	25.98	19613911.0
2005-07-19 11:00:00	MSFT	Stock	25.99	26.2	25.88	26.1	20818347.0
2005-07-19 12:00:00	MSFT	Stock	26.1	26.12	26.0	26.03	9187290.0
2005-07-19 13:00:00	MSFT	Stock	26.03	26.06	26.0	26.03	5997202.0
2005-07-19 14:00:00	MSFT	Stock	26.04	26.19	25.99	26.18	13484899.0
2005-07-19 15:00:00	MSFT	Stock	26.18	26.25	26.044	26.18	27355429.0
2005-07-19 16:00:00	MSFT	Stock	26.17	26.18	25.45	25.9	1217311.0
2005-07-19 17:00:00	MSFT	Stock	25.9	26.22	25.85	25.88	115673.0
2005-07-19 18:00:00	MSFT	Stock	25.88	25.88	25.85	25.88	36551.0
2005-07-19 08:00:00	NVDA	Stock	0.2202	0.2202	0.2202	0.2202	12000.0
2005-07-19 09:00:00	NVDA	Stock	0.2192	0.222	0.2182	0.2198	107168280.0
2005-07-19 10:00:00	NVDA	Stock	0.2198	0.2212	0.2187	0.2203	138375360.0
2005-07-19 11:00:00	NVDA	Stock	0.2202	0.2206	0.2192	0.2202	47929920.0
2005-07-19 12:00:00	NVDA	Stock	0.2202	0.2211	0.2202	0.2208	28386600.0
2005-07-19 13:00:00	NVDA	Stock	0.221	0.2211	0.2199	0.2204	33516120.0
2005-07-19 14:00:00	NVDA	Stock	0.2204	0.2216	0.22	0.2212	69782880.0
2005-07-19 15:00:00	NVDA	Stock	0.2213	0.2217	0.2211	0.2216	67943880.0
2005-07-19 16:00:00	NVDA	Stock	0.2215	0.2218	0.2017	0.2181	3096000.0
2005-07-19 17:00:00	NVDA	Stock	0.2175	0.2189	0.2175	0.2183	684000.0
2005-07-19 09:00:00	AMZN	Stock	1.861	1.875	1.8345	1.874	10460120.0
2005-07-19 10:00:00	AMZN	Stock	1.8735	1.8865	1.867	1.8855	17270000.0
2005-07-19 11:00:00	AMZN	Stock	1.886	1.886	1.8805	1.883	11393600.0
2005-07-19 12:00:00	AMZN	Stock	1.883	1.8885	1.8825	1.8885	15479920.0
2005-07-19 13:00:00	AMZN	Stock	1.889	1.8915	1.8865	1.8865	13378500.0
2005-07-19 14:00:00	AMZN	Stock	1.887	1.897	1.8845	1.8945	11097260.0
2005-07-19 15:00:00	AMZN	Stock	1.8945	1.9085	1.894	1.9085	29039120.0
2005-07-19 16:00:00	AMZN	Stock	1.9085	1.9125	1.859	1.87	3281820.0
2005-07-19 17:00:00	AMZN	Stock	1.862	1.894	1.8605	1.894	352460.0
2005-07-19 18:00:00	AMZN	Stock	1.8675	1.8675	1.8675	1.8675	20000.0
2005-07-19 09:00:00	CL	Stock	25.85	25.895	25.72	25.725	314800.0
2005-07-19 10:00:00	CL	Stock	25.725	25.865	25.72	25.825	389400.0
2005-07-19 11:00:00	CL	Stock	25.825	25.825	25.74	25.78	191400.0
2005-07-19 12:00:00	CL	Stock	25.78	25.785	25.615	25.71	309800.0
2005-07-19 13:00:00	CL	Stock	25.705	25.72	25.63	25.655	264800.0
2005-07-19 14:00:00	CL	Stock	25.655	25.735	25.635	25.715	398800.0
2005-07-19 15:00:00	CL	Stock	25.705	25.76	25.685	25.71	590400.0

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

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