PREVIEW / stock_1hour / 2005-03-14

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-03-14.parquet
  size:    549 KB
  rows:    25,902
  symbols: 1,952

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-14 08:00:00	AAPL	Stock	1.4518	1.4625	1.4471	1.4543	5117784.0
2005-03-14 09:00:00	AAPL	Stock	1.4554	1.4568	1.4257	1.4325	102295872.0
2005-03-14 10:00:00	AAPL	Stock	1.4321	1.4561	1.4114	1.4229	145431496.0
2005-03-14 11:00:00	AAPL	Stock	1.4225	1.4332	1.4179	1.43	83249432.0
2005-03-14 12:00:00	AAPL	Stock	1.4296	1.4361	1.4268	1.4279	42322756.0
2005-03-14 13:00:00	AAPL	Stock	1.4279	1.44	1.4246	1.4346	56365540.0
2005-03-14 14:00:00	AAPL	Stock	1.4346	1.44	1.4325	1.435	43760108.0
2005-03-14 15:00:00	AAPL	Stock	1.435	1.4468	1.4329	1.4407	98776076.0
2005-03-14 16:00:00	AAPL	Stock	1.4404	1.4418	1.4325	1.4404	3819704.0
2005-03-14 17:00:00	AAPL	Stock	1.4382	1.4408	1.4335	1.4379	627144.0
2005-03-14 18:00:00	AAPL	Stock	1.4393	1.4393	1.4375	1.4375	11200.0
2005-03-14 08:00:00	MSFT	Stock	25.1	25.13	25.09	25.12	35679.0
2005-03-14 09:00:00	MSFT	Stock	25.12	25.12	24.96	25.03	9375164.0
2005-03-14 10:00:00	MSFT	Stock	25.03	25.1	25.0	25.08	8985951.0
2005-03-14 11:00:00	MSFT	Stock	25.08	25.1	24.98	25.03	5395836.0
2005-03-14 12:00:00	MSFT	Stock	25.03	25.07	25.02	25.04	3674730.0
2005-03-14 13:00:00	MSFT	Stock	25.04	25.07	25.019	25.04	7085315.0
2005-03-14 14:00:00	MSFT	Stock	25.04	25.09	25.02	25.07	7717617.0
2005-03-14 15:00:00	MSFT	Stock	25.08	25.15	25.07	25.12	11276462.0
2005-03-14 16:00:00	MSFT	Stock	25.12	25.15	25.06	25.11	5812382.0
2005-03-14 17:00:00	MSFT	Stock	25.08	25.123	25.02	25.09	158222.0
2005-03-14 08:00:00	NVDA	Stock	0.2131	0.2146	0.2104	0.2141	2638080.0
2005-03-14 09:00:00	NVDA	Stock	0.2139	0.2155	0.2097	0.2126	135681000.0
2005-03-14 10:00:00	NVDA	Stock	0.2125	0.2148	0.2125	0.2142	77316720.0
2005-03-14 11:00:00	NVDA	Stock	0.2142	0.215	0.2133	0.2136	98503920.0
2005-03-14 12:00:00	NVDA	Stock	0.2135	0.2148	0.2135	0.214	30098400.0
2005-03-14 13:00:00	NVDA	Stock	0.214	0.2142	0.2131	0.2137	37772760.0
2005-03-14 14:00:00	NVDA	Stock	0.2137	0.2142	0.2134	0.2141	46275120.0
2005-03-14 15:00:00	NVDA	Stock	0.214	0.2165	0.2131	0.2156	129718080.0
2005-03-14 16:00:00	NVDA	Stock	0.2155	0.2162	0.2152	0.2162	4251360.0
2005-03-14 17:00:00	NVDA	Stock	0.2156	0.2156	0.2142	0.2153	212400.0
2005-03-14 18:00:00	NVDA	Stock	0.216	0.216	0.2157	0.2157	43200.0
2005-03-14 08:00:00	AMZN	Stock	1.725	1.725	1.725	1.725	19000.0
2005-03-14 09:00:00	AMZN	Stock	1.734	1.7375	1.7145	1.7175	8883180.0
2005-03-14 10:00:00	AMZN	Stock	1.7175	1.7215	1.7145	1.72	15317700.0
2005-03-14 11:00:00	AMZN	Stock	1.72	1.72	1.7	1.704	17288560.0
2005-03-14 12:00:00	AMZN	Stock	1.7045	1.715	1.704	1.708	10018160.0
2005-03-14 13:00:00	AMZN	Stock	1.708	1.709	1.7	1.705	15815500.0
2005-03-14 14:00:00	AMZN	Stock	1.7055	1.7135	1.705	1.708	11705800.0
2005-03-14 15:00:00	AMZN	Stock	1.7085	1.7305	1.708	1.7275	27134820.0
2005-03-14 16:00:00	AMZN	Stock	1.7295	1.731	1.725	1.725	151800.0
2005-03-14 17:00:00	AMZN	Stock	1.7298	1.7302	1.725	1.725	145240.0
2005-03-14 09:00:00	CL	Stock	26.17	26.28	26.085	26.105	469600.0
2005-03-14 10:00:00	CL	Stock	26.1	26.18	26.055	26.18	504400.0
2005-03-14 11:00:00	CL	Stock	26.185	26.205	26.1	26.16	279800.0
2005-03-14 12:00:00	CL	Stock	26.16	26.21	26.125	26.17	212600.0
2005-03-14 13:00:00	CL	Stock	26.165	26.225	26.1	26.12	347400.0
2005-03-14 14:00:00	CL	Stock	26.12	26.18	26.09	26.18	271200.0
2005-03-14 15:00:00	CL	Stock	26.18	26.275	26.165	26.275	656200.0
2005-03-14 16:00:00	CL	Stock	26.29	26.29	26.29	26.29	200.0

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

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