PREVIEW / stock_1hour / 2006-04-17

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-04-17.parquet
  size:    601 KB
  rows:    28,410
  symbols: 2,250

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
2006-04-17 08:00:00	AAPL	Stock	2.3739	2.38	2.3739	2.375	592844.0
2006-04-17 09:00:00	AAPL	Stock	2.375	2.3871	2.3589	2.3707	78692656.0
2006-04-17 10:00:00	AAPL	Stock	2.3704	2.3804	2.3571	2.3586	79823772.0
2006-04-17 11:00:00	AAPL	Stock	2.3585	2.3589	2.34	2.3489	106295000.0
2006-04-17 12:00:00	AAPL	Stock	2.3493	2.3507	2.3143	2.3221	132520528.0
2006-04-17 13:00:00	AAPL	Stock	2.3214	2.3246	2.2982	2.3064	101356892.0
2006-04-17 14:00:00	AAPL	Stock	2.3061	2.3236	2.3004	2.3121	87962252.0
2006-04-17 15:00:00	AAPL	Stock	2.3125	2.3236	2.3064	2.3146	104504624.0
2006-04-17 16:00:00	AAPL	Stock	2.3143	2.3168	2.3125	2.3136	2565612.0
2006-04-17 17:00:00	AAPL	Stock	2.3146	2.3146	2.3036	2.3118	615972.0
2006-04-17 18:00:00	AAPL	Stock	2.3107	2.3125	2.3107	2.3125	378924.0
2006-04-17 08:00:00	MSFT	Stock	27.1	27.1	27.07	27.09	6398.0
2006-04-17 09:00:00	MSFT	Stock	27.1	27.12	26.9	26.98	4221310.0
2006-04-17 10:00:00	MSFT	Stock	26.98	27.05	26.96	26.97	4110360.0
2006-04-17 11:00:00	MSFT	Stock	26.98	27.03	26.94	26.968	2677935.0
2006-04-17 12:00:00	MSFT	Stock	26.97	26.97	26.82	26.87	4673356.0
2006-04-17 13:00:00	MSFT	Stock	26.87	27.0	26.75	26.79	5168569.0
2006-04-17 14:00:00	MSFT	Stock	26.78	26.86	26.73	26.83	5593861.0
2006-04-17 15:00:00	MSFT	Stock	26.83	26.9	26.78	26.84	7551259.0
2006-04-17 16:00:00	MSFT	Stock	26.87	26.91	26.84	26.89	90237.0
2006-04-17 17:00:00	MSFT	Stock	26.88	26.9	26.88	26.9	785.0
2006-04-17 18:00:00	MSFT	Stock	26.87	26.87	26.87	26.87	100.0
2006-04-17 07:00:00	NVDA	Stock	0.4933	0.4933	0.4933	0.4933	6000.0
2006-04-17 08:00:00	NVDA	Stock	0.495	0.495	0.4913	0.4913	30000.0
2006-04-17 09:00:00	NVDA	Stock	0.4913	0.5015	0.4907	0.499	42532020.0
2006-04-17 10:00:00	NVDA	Stock	0.499	0.507	0.499	0.5018	62796840.0
2006-04-17 11:00:00	NVDA	Stock	0.5018	0.5025	0.4993	0.5017	50259360.0
2006-04-17 12:00:00	NVDA	Stock	0.5017	0.5018	0.4983	0.4995	54389640.0
2006-04-17 13:00:00	NVDA	Stock	0.4993	0.5	0.4913	0.4927	88431840.0
2006-04-17 14:00:00	NVDA	Stock	0.4928	0.495	0.4908	0.4922	59634000.0
2006-04-17 15:00:00	NVDA	Stock	0.4923	0.4948	0.4912	0.4947	69225000.0
2006-04-17 16:00:00	NVDA	Stock	0.4945	0.4948	0.4932	0.4947	509580.0
2006-04-17 08:00:00	AMZN	Stock	1.8315	1.8315	1.8315	1.8315	7000.0
2006-04-17 09:00:00	AMZN	Stock	1.825	1.831	1.7965	1.801	7798260.0
2006-04-17 10:00:00	AMZN	Stock	1.801	1.8145	1.7995	1.8025	9682900.0
2006-04-17 11:00:00	AMZN	Stock	1.8025	1.8035	1.7925	1.7985	7373320.0
2006-04-17 12:00:00	AMZN	Stock	1.799	1.799	1.7785	1.782	7491800.0
2006-04-17 13:00:00	AMZN	Stock	1.782	1.782	1.7525	1.758	15190300.0
2006-04-17 14:00:00	AMZN	Stock	1.758	1.7735	1.755	1.7715	15553200.0
2006-04-17 15:00:00	AMZN	Stock	1.771	1.7765	1.76	1.7625	20704680.0
2006-04-17 16:00:00	AMZN	Stock	1.762	1.7655	1.76	1.761	336840.0
2006-04-17 17:00:00	AMZN	Stock	1.7635	1.7635	1.7635	1.7635	2000.0
2006-04-17 09:00:00	CL	Stock	28.25	28.34	28.205	28.32	222400.0
2006-04-17 10:00:00	CL	Stock	28.32	28.33	28.23	28.28	270000.0
2006-04-17 11:00:00	CL	Stock	28.29	28.36	28.28	28.335	160200.0
2006-04-17 12:00:00	CL	Stock	28.33	28.335	28.2	28.245	226000.0
2006-04-17 13:00:00	CL	Stock	28.25	28.25	28.045	28.055	436200.0
2006-04-17 14:00:00	CL	Stock	28.06	28.085	28.0	28.035	359000.0
2006-04-17 15:00:00	CL	Stock	28.04	28.2	28.04	28.155	626400.0

> showing 49 of 28,410 rows — these rows as CSV

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