PREVIEW / stock_1hour / 2005-03-28

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-03-28.parquet
  size:    542 KB
  rows:    25,532
  symbols: 1,946

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-28 08:00:00	AAPL	Stock	1.5196	1.5321	1.5196	1.5321	1346828.0
2005-03-28 09:00:00	AAPL	Stock	1.5311	1.5343	1.5196	1.5243	39615800.0
2005-03-28 10:00:00	AAPL	Stock	1.5246	1.5332	1.5211	1.5289	55369860.0
2005-03-28 11:00:00	AAPL	Stock	1.5289	1.534	1.525	1.5279	38794700.0
2005-03-28 12:00:00	AAPL	Stock	1.5275	1.5286	1.5236	1.5275	19814564.0
2005-03-28 13:00:00	AAPL	Stock	1.5271	1.5336	1.5268	1.5286	26320028.0
2005-03-28 14:00:00	AAPL	Stock	1.5286	1.5307	1.5246	1.5279	29640016.0
2005-03-28 15:00:00	AAPL	Stock	1.5279	1.5296	1.5168	1.5196	50308972.0
2005-03-28 16:00:00	AAPL	Stock	1.5193	1.5286	1.5186	1.5214	2089612.0
2005-03-28 17:00:00	AAPL	Stock	1.5214	1.5232	1.5207	1.5232	103600.0
2005-03-28 18:00:00	AAPL	Stock	1.5218	1.525	1.5214	1.525	47600.0
2005-03-28 08:00:00	MSFT	Stock	24.46	24.46	24.35	24.39	51205.0
2005-03-28 09:00:00	MSFT	Stock	24.37	24.47	24.34	24.4	6165438.0
2005-03-28 10:00:00	MSFT	Stock	24.41	24.43	24.34	24.34	8659153.0
2005-03-28 11:00:00	MSFT	Stock	24.35	24.41	24.28	24.35	4959481.0
2005-03-28 12:00:00	MSFT	Stock	24.36	24.37	24.31	24.34	4002442.0
2005-03-28 13:00:00	MSFT	Stock	24.332	24.39	24.32	24.35	5303198.0
2005-03-28 14:00:00	MSFT	Stock	24.35	24.38	24.31	24.35	7640482.0
2005-03-28 15:00:00	MSFT	Stock	24.35	24.36	24.18	24.19	10705964.0
2005-03-28 16:00:00	MSFT	Stock	24.2	24.22	24.18	24.19	572262.0
2005-03-28 17:00:00	MSFT	Stock	24.19	24.23	24.19	24.23	5283.0
2005-03-28 18:00:00	MSFT	Stock	24.23	24.23	24.21	24.21	7200.0
2005-03-28 09:00:00	NVDA	Stock	0.2101	0.2125	0.2095	0.2108	118707000.0
2005-03-28 10:00:00	NVDA	Stock	0.2108	0.2108	0.2061	0.2064	108896400.0
2005-03-28 11:00:00	NVDA	Stock	0.2063	0.2096	0.2051	0.2059	75820560.0
2005-03-28 12:00:00	NVDA	Stock	0.2059	0.208	0.2055	0.2072	57951720.0
2005-03-28 13:00:00	NVDA	Stock	0.2072	0.2079	0.2071	0.2077	19546440.0
2005-03-28 14:00:00	NVDA	Stock	0.2079	0.2084	0.2065	0.2077	37037880.0
2005-03-28 15:00:00	NVDA	Stock	0.2076	0.208	0.2059	0.2068	81715080.0
2005-03-28 16:00:00	NVDA	Stock	0.2066	0.2072	0.2062	0.2071	533160.0
2005-03-28 08:00:00	AMZN	Stock	1.6475	1.65	1.6475	1.65	28000.0
2005-03-28 09:00:00	AMZN	Stock	1.6515	1.682	1.65	1.6765	11740300.0
2005-03-28 10:00:00	AMZN	Stock	1.6765	1.6825	1.6695	1.6785	13906360.0
2005-03-28 11:00:00	AMZN	Stock	1.678	1.6785	1.669	1.669	10589020.0
2005-03-28 12:00:00	AMZN	Stock	1.669	1.672	1.6625	1.6695	8180340.0
2005-03-28 13:00:00	AMZN	Stock	1.6695	1.6765	1.6685	1.674	8817540.0
2005-03-28 14:00:00	AMZN	Stock	1.6745	1.682	1.6685	1.6805	13442420.0
2005-03-28 15:00:00	AMZN	Stock	1.6805	1.6825	1.6675	1.6675	16267580.0
2005-03-28 16:00:00	AMZN	Stock	1.67	1.671	1.6675	1.6695	976240.0
2005-03-28 18:00:00	AMZN	Stock	1.6695	1.6695	1.6695	1.6695	27200.0
2005-03-28 09:00:00	CL	Stock	25.885	25.955	25.785	25.935	305800.0
2005-03-28 10:00:00	CL	Stock	25.935	25.95	25.865	25.905	233400.0
2005-03-28 11:00:00	CL	Stock	25.9	25.925	25.85	25.865	296800.0
2005-03-28 12:00:00	CL	Stock	25.87	25.905	25.795	25.845	196800.0
2005-03-28 13:00:00	CL	Stock	25.845	25.875	25.81	25.85	157600.0
2005-03-28 14:00:00	CL	Stock	25.845	26.0	25.84	26.0	447800.0
2005-03-28 15:00:00	CL	Stock	26.0	26.015	25.785	25.825	499000.0
2005-03-28 16:00:00	CL	Stock	25.82	25.825	25.715	25.81	2200.0

> showing 48 of 25,532 rows — these rows as CSV

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