PREVIEW / stock_1hour / 2005-03-15

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-03-15.parquet
  size:    542 KB
  rows:    25,273
  symbols: 1,948

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-15 08:00:00	AAPL	Stock	1.4464	1.4482	1.4339	1.4436	1241016.0
2005-03-15 09:00:00	AAPL	Stock	1.4432	1.4554	1.4375	1.4489	77563696.0
2005-03-15 10:00:00	AAPL	Stock	1.4493	1.45	1.4382	1.445	74598104.0
2005-03-15 11:00:00	AAPL	Stock	1.4454	1.4529	1.4425	1.4471	47470192.0
2005-03-15 12:00:00	AAPL	Stock	1.4468	1.4629	1.4436	1.4614	74248188.0
2005-03-15 13:00:00	AAPL	Stock	1.4614	1.4661	1.4536	1.4629	73093468.0
2005-03-15 14:00:00	AAPL	Stock	1.4636	1.465	1.4536	1.4607	58784544.0
2005-03-15 15:00:00	AAPL	Stock	1.4607	1.4693	1.4561	1.4636	91462392.0
2005-03-15 16:00:00	AAPL	Stock	1.4632	1.4661	1.4561	1.4643	2550352.0
2005-03-15 17:00:00	AAPL	Stock	1.4661	1.4661	1.4629	1.4643	3771740.0
2005-03-15 18:00:00	AAPL	Stock	1.465	1.4657	1.4643	1.4657	35000.0
2005-03-15 08:00:00	MSFT	Stock	25.08	25.11	25.0	25.09	19087.0
2005-03-15 09:00:00	MSFT	Stock	25.09	25.24	25.07	25.111	7181416.0
2005-03-15 10:00:00	MSFT	Stock	25.11	25.16	25.079	25.13	7042122.0
2005-03-15 11:00:00	MSFT	Stock	25.13	25.18	25.07	25.1	6856007.0
2005-03-15 12:00:00	MSFT	Stock	25.1	25.14	25.06	25.11	7243293.0
2005-03-15 13:00:00	MSFT	Stock	25.1	25.12	25.01	25.02	6854397.0
2005-03-15 14:00:00	MSFT	Stock	25.02	25.11	24.94	24.991	9748559.0
2005-03-15 15:00:00	MSFT	Stock	24.99	25.0	24.89	24.92	13154309.0
2005-03-15 16:00:00	MSFT	Stock	24.91	24.93	24.91	24.92	6088963.0
2005-03-15 17:00:00	MSFT	Stock	24.93	24.93	24.91	24.92	205480.0
2005-03-15 18:00:00	MSFT	Stock	24.92	24.92	24.91	24.92	8100.0
2005-03-15 08:00:00	NVDA	Stock	0.2159	0.2162	0.2159	0.2162	48000.0
2005-03-15 09:00:00	NVDA	Stock	0.2162	0.2187	0.2142	0.2148	95777040.0
2005-03-15 10:00:00	NVDA	Stock	0.2148	0.215	0.2115	0.213	67834200.0
2005-03-15 11:00:00	NVDA	Stock	0.2129	0.2139	0.2126	0.2132	35743680.0
2005-03-15 12:00:00	NVDA	Stock	0.2131	0.214	0.2125	0.2129	26980440.0
2005-03-15 13:00:00	NVDA	Stock	0.213	0.2137	0.2124	0.2134	33684360.0
2005-03-15 14:00:00	NVDA	Stock	0.2134	0.2137	0.2117	0.2122	30363720.0
2005-03-15 15:00:00	NVDA	Stock	0.2123	0.2129	0.2111	0.2117	72283680.0
2005-03-15 16:00:00	NVDA	Stock	0.2112	0.2138	0.2108	0.2112	1255320.0
2005-03-15 17:00:00	NVDA	Stock	0.2112	0.2112	0.2108	0.2108	492000.0
2005-03-15 08:00:00	AMZN	Stock	1.7225	1.725	1.718	1.7225	110000.0
2005-03-15 09:00:00	AMZN	Stock	1.721	1.7425	1.72	1.729	14491600.0
2005-03-15 10:00:00	AMZN	Stock	1.7294	1.7295	1.7085	1.7125	16375340.0
2005-03-15 11:00:00	AMZN	Stock	1.7125	1.7165	1.696	1.701	25626280.0
2005-03-15 12:00:00	AMZN	Stock	1.701	1.711	1.695	1.711	13416200.0
2005-03-15 13:00:00	AMZN	Stock	1.711	1.7135	1.7045	1.71	6806940.0
2005-03-15 14:00:00	AMZN	Stock	1.71	1.7185	1.7055	1.711	8735260.0
2005-03-15 15:00:00	AMZN	Stock	1.7105	1.7125	1.701	1.707	12738620.0
2005-03-15 16:00:00	AMZN	Stock	1.7075	1.709	1.7035	1.709	671080.0
2005-03-15 17:00:00	AMZN	Stock	1.709	1.709	1.709	1.709	56000.0
2005-03-15 09:00:00	CL	Stock	26.415	26.57	26.4	26.545	345200.0
2005-03-15 10:00:00	CL	Stock	26.545	26.565	26.5	26.52	401600.0
2005-03-15 11:00:00	CL	Stock	26.52	26.52	26.34	26.365	406800.0
2005-03-15 12:00:00	CL	Stock	26.355	26.41	26.31	26.375	291600.0
2005-03-15 13:00:00	CL	Stock	26.38	26.4	26.35	26.39	312400.0
2005-03-15 14:00:00	CL	Stock	26.385	26.43	26.3	26.335	354800.0
2005-03-15 15:00:00	CL	Stock	26.335	26.339	26.275	26.305	684400.0
2005-03-15 17:00:00	CL	Stock	26.3	26.3	26.3	26.3	800.0

> showing 50 of 25,273 rows — these rows as CSV

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