PREVIEW / stock_1hour / 2005-06-01

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-06-01.parquet
  size:    563 KB
  rows:    26,788
  symbols: 1,979

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-06-01 08:00:00	AAPL	Stock	1.4129	1.4221	1.4129	1.4214	151620.0
2005-06-01 09:00:00	AAPL	Stock	1.4196	1.4386	1.4093	1.4371	54290740.0
2005-06-01 10:00:00	AAPL	Stock	1.4371	1.4557	1.4368	1.4464	118912276.0
2005-06-01 11:00:00	AAPL	Stock	1.4468	1.4532	1.4454	1.45	54485536.0
2005-06-01 12:00:00	AAPL	Stock	1.4496	1.4532	1.4475	1.4525	30553824.0
2005-06-01 13:00:00	AAPL	Stock	1.4525	1.4532	1.4439	1.4457	37850428.0
2005-06-01 14:00:00	AAPL	Stock	1.4457	1.4468	1.4275	1.4314	74479636.0
2005-06-01 15:00:00	AAPL	Stock	1.4314	1.4421	1.4296	1.4389	64425284.0
2005-06-01 16:00:00	AAPL	Stock	1.4382	1.4382	1.4357	1.4361	813120.0
2005-06-01 17:00:00	AAPL	Stock	1.4371	1.443	1.4371	1.4393	1279040.0
2005-06-01 18:00:00	AAPL	Stock	1.4393	1.4426	1.4393	1.4426	252840.0
2005-06-01 07:00:00	MSFT	Stock	25.81	25.85	25.81	25.85	2800.0
2005-06-01 08:00:00	MSFT	Stock	25.84	25.84	25.79	25.79	19905.0
2005-06-01 09:00:00	MSFT	Stock	25.8	25.8	25.61	25.62	5217198.0
2005-06-01 10:00:00	MSFT	Stock	25.622	25.9	25.62	25.82	10931477.0
2005-06-01 11:00:00	MSFT	Stock	25.82	26.0	25.81	25.912	7951102.0
2005-06-01 12:00:00	MSFT	Stock	25.91	25.92	25.81	25.84	4098841.0
2005-06-01 13:00:00	MSFT	Stock	25.848	25.91	25.82	25.85	3571149.0
2005-06-01 14:00:00	MSFT	Stock	25.86	25.87	25.72	25.83	9074774.0
2005-06-01 15:00:00	MSFT	Stock	25.83	25.86	25.78	25.81	10098936.0
2005-06-01 16:00:00	MSFT	Stock	25.82	25.87	25.8	25.84	490705.0
2005-06-01 17:00:00	MSFT	Stock	25.83	25.84	25.81	25.81	322197.0
2005-06-01 18:00:00	MSFT	Stock	25.84	25.84	25.81	25.84	62560.0
2005-06-01 08:00:00	NVDA	Stock	0.2262	0.2262	0.2262	0.2262	132000.0
2005-06-01 09:00:00	NVDA	Stock	0.2262	0.2262	0.2217	0.2232	103953720.0
2005-06-01 10:00:00	NVDA	Stock	0.2232	0.2287	0.2232	0.2279	228502920.0
2005-06-01 11:00:00	NVDA	Stock	0.228	0.2312	0.228	0.2308	145979640.0
2005-06-01 12:00:00	NVDA	Stock	0.2308	0.2313	0.2306	0.2308	62265360.0
2005-06-01 13:00:00	NVDA	Stock	0.2307	0.2319	0.2305	0.2317	57697440.0
2005-06-01 14:00:00	NVDA	Stock	0.2318	0.2321	0.2267	0.2271	81098160.0
2005-06-01 15:00:00	NVDA	Stock	0.2271	0.2287	0.2263	0.2277	96225480.0
2005-06-01 16:00:00	NVDA	Stock	0.2276	0.2282	0.2267	0.2275	650520.0
2005-06-01 17:00:00	NVDA	Stock	0.2275	0.228	0.2273	0.228	3528000.0
2005-06-01 18:00:00	NVDA	Stock	0.2279	0.2279	0.2274	0.2274	210000.0
2005-06-01 08:00:00	AMZN	Stock	1.7755	1.7755	1.7755	1.7755	13000.0
2005-06-01 09:00:00	AMZN	Stock	1.7725	1.81	1.772	1.8085	18822220.0
2005-06-01 10:00:00	AMZN	Stock	1.808	1.828	1.808	1.822	34217620.0
2005-06-01 11:00:00	AMZN	Stock	1.8225	1.8365	1.8185	1.835	33292080.0
2005-06-01 12:00:00	AMZN	Stock	1.835	1.847	1.831	1.847	22080620.0
2005-06-01 13:00:00	AMZN	Stock	1.847	1.8495	1.839	1.8445	18011620.0
2005-06-01 14:00:00	AMZN	Stock	1.8445	1.8475	1.8275	1.83	30063780.0
2005-06-01 15:00:00	AMZN	Stock	1.83	1.8375	1.818	1.83	43491800.0
2005-06-01 16:00:00	AMZN	Stock	1.8265	1.828	1.806	1.826	558820.0
2005-06-01 17:00:00	AMZN	Stock	1.826	1.832	1.8125	1.8195	238960.0
2005-06-01 18:00:00	AMZN	Stock	1.825	1.832	1.8095	1.815	385600.0
2005-06-01 09:00:00	CL	Stock	24.995	25.075	24.93	24.935	251600.0
2005-06-01 10:00:00	CL	Stock	24.94	25.21	24.935	25.2	527400.0
2005-06-01 11:00:00	CL	Stock	25.2	25.35	25.175	25.28	477200.0
2005-06-01 12:00:00	CL	Stock	25.28	25.285	25.22	25.28	215000.0
2005-06-01 13:00:00	CL	Stock	25.28	25.3	25.215	25.265	275800.0

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

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