PREVIEW / stock_1hour / 2005-06-06

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-06-06.parquet
  size:    536 KB
  rows:    25,457
  symbols: 1,981

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-06 07:00:00	AAPL	Stock	1.3689	1.4	1.3689	1.3921	409220.0
2005-06-06 08:00:00	AAPL	Stock	1.3921	1.3946	1.3743	1.375	6361040.0
2005-06-06 09:00:00	AAPL	Stock	1.375	1.3821	1.3582	1.3721	123205572.0
2005-06-06 10:00:00	AAPL	Stock	1.3725	1.3729	1.3525	1.3532	121108484.0
2005-06-06 11:00:00	AAPL	Stock	1.3532	1.3557	1.3414	1.3468	99779596.0
2005-06-06 12:00:00	AAPL	Stock	1.3471	1.3536	1.3446	1.3475	60731384.0
2005-06-06 13:00:00	AAPL	Stock	1.3475	1.3764	1.3471	1.3696	150724672.0
2005-06-06 14:00:00	AAPL	Stock	1.3696	1.3732	1.3543	1.3554	105750232.0
2005-06-06 15:00:00	AAPL	Stock	1.3557	1.3596	1.3482	1.3532	134168412.0
2005-06-06 16:00:00	AAPL	Stock	1.3543	1.3543	1.3486	1.3543	2811424.0
2005-06-06 17:00:00	AAPL	Stock	1.3493	1.3514	1.3489	1.3514	179200.0
2005-06-06 18:00:00	AAPL	Stock	1.3507	1.3511	1.3496	1.3496	58100.0
2005-06-06 07:00:00	MSFT	Stock	25.4	25.4	25.4	25.4	200.0
2005-06-06 08:00:00	MSFT	Stock	25.44	25.44	25.42	25.43	4467.0
2005-06-06 09:00:00	MSFT	Stock	25.44	25.5	25.36	25.45	6562542.0
2005-06-06 10:00:00	MSFT	Stock	25.45	25.45	25.36	25.39	7127404.0
2005-06-06 11:00:00	MSFT	Stock	25.39	25.41	25.32	25.33	5363574.0
2005-06-06 12:00:00	MSFT	Stock	25.33	25.38	25.31	25.33	3478569.0
2005-06-06 13:00:00	MSFT	Stock	25.33	25.38	25.32	25.348	4836283.0
2005-06-06 14:00:00	MSFT	Stock	25.35	25.39	25.34	25.38	4262191.0
2005-06-06 15:00:00	MSFT	Stock	25.38	25.41	25.35	25.37	8426938.0
2005-06-06 16:00:00	MSFT	Stock	25.37	25.37	25.32	25.37	140918.0
2005-06-06 17:00:00	MSFT	Stock	25.35	25.36	25.34	25.34	1730.0
2005-06-06 18:00:00	MSFT	Stock	25.34	25.36	25.34	25.34	3380.0
2005-06-06 08:00:00	NVDA	Stock	0.2329	0.2358	0.2279	0.2321	8868000.0
2005-06-06 09:00:00	NVDA	Stock	0.2324	0.2351	0.2314	0.2341	98104920.0
2005-06-06 10:00:00	NVDA	Stock	0.2342	0.2362	0.2328	0.2329	97278360.0
2005-06-06 11:00:00	NVDA	Stock	0.2328	0.233	0.2317	0.232	106154880.0
2005-06-06 12:00:00	NVDA	Stock	0.232	0.2327	0.232	0.2327	43213800.0
2005-06-06 13:00:00	NVDA	Stock	0.2325	0.2337	0.2321	0.2332	52213200.0
2005-06-06 14:00:00	NVDA	Stock	0.233	0.2339	0.2324	0.2329	42062280.0
2005-06-06 15:00:00	NVDA	Stock	0.233	0.2342	0.2322	0.2337	59013360.0
2005-06-06 16:00:00	NVDA	Stock	0.2336	0.2336	0.2329	0.2336	829800.0
2005-06-06 17:00:00	NVDA	Stock	0.2332	0.2332	0.2332	0.2332	108000.0
2005-06-06 08:00:00	AMZN	Stock	1.78	1.78	1.7785	1.7785	9660.0
2005-06-06 09:00:00	AMZN	Stock	1.781	1.79	1.7735	1.7855	8230340.0
2005-06-06 10:00:00	AMZN	Stock	1.785	1.795	1.7835	1.7895	12436580.0
2005-06-06 11:00:00	AMZN	Stock	1.789	1.7945	1.7875	1.7875	9207800.0
2005-06-06 12:00:00	AMZN	Stock	1.7885	1.799	1.7885	1.798	7955940.0
2005-06-06 13:00:00	AMZN	Stock	1.798	1.801	1.794	1.7975	10592120.0
2005-06-06 14:00:00	AMZN	Stock	1.797	1.7995	1.7895	1.7895	9382100.0
2005-06-06 15:00:00	AMZN	Stock	1.79	1.7915	1.782	1.7875	18118700.0
2005-06-06 16:00:00	AMZN	Stock	1.7855	1.7885	1.783	1.7885	323460.0
2005-06-06 17:00:00	AMZN	Stock	1.7825	1.7885	1.7825	1.7885	19600.0
2005-06-06 18:00:00	AMZN	Stock	1.779	1.779	1.779	1.779	2000.0
2005-06-06 09:00:00	CL	Stock	24.46	24.53	24.39	24.4	353400.0
2005-06-06 10:00:00	CL	Stock	24.405	24.405	24.325	24.35	508600.0
2005-06-06 11:00:00	CL	Stock	24.35	24.465	24.275	24.465	543400.0
2005-06-06 12:00:00	CL	Stock	24.465	24.5	24.4	24.4	331200.0
2005-06-06 13:00:00	CL	Stock	24.4	24.41	24.375	24.395	345000.0

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

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