PREVIEW / stock_1hour / 2005-11-23

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-11-23.parquet
  size:    562 KB
  rows:    26,554
  symbols: 2,119

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-11-23 08:00:00	AAPL	Stock	2.39	2.3946	2.3764	2.3896	2200968.0
2005-11-23 09:00:00	AAPL	Stock	2.3886	2.4089	2.3811	2.4018	86729440.0
2005-11-23 10:00:00	AAPL	Stock	2.4018	2.4279	2.3979	2.4196	123598748.0
2005-11-23 11:00:00	AAPL	Stock	2.4193	2.4232	2.4079	2.4139	60507944.0
2005-11-23 12:00:00	AAPL	Stock	2.4136	2.4229	2.411	2.42	39877180.0
2005-11-23 13:00:00	AAPL	Stock	2.42	2.4214	2.4168	2.4179	23182292.0
2005-11-23 14:00:00	AAPL	Stock	2.4179	2.4189	2.3936	2.3961	61716060.0
2005-11-23 15:00:00	AAPL	Stock	2.3964	2.3982	2.3839	2.3968	81036592.0
2005-11-23 16:00:00	AAPL	Stock	2.3954	2.4018	2.3946	2.4018	1637020.0
2005-11-23 17:00:00	AAPL	Stock	2.4018	2.4064	2.3968	2.4018	1722084.0
2005-11-23 18:00:00	AAPL	Stock	2.4036	2.4039	2.4004	2.4036	39900.0
2005-11-23 08:00:00	MSFT	Stock	27.85	28.0	27.85	27.92	30655.0
2005-11-23 09:00:00	MSFT	Stock	27.91	27.94	27.74	27.88	12902348.0
2005-11-23 10:00:00	MSFT	Stock	27.88	28.01	27.84	27.98	7890235.0
2005-11-23 11:00:00	MSFT	Stock	27.98	28.09	27.9	27.98	9188352.0
2005-11-23 12:00:00	MSFT	Stock	27.97	28.0	27.88	27.95	11667137.0
2005-11-23 13:00:00	MSFT	Stock	27.95	27.99	27.9	27.98	7206219.0
2005-11-23 14:00:00	MSFT	Stock	27.98	28.04	27.93	27.96	8132681.0
2005-11-23 15:00:00	MSFT	Stock	27.96	27.96	27.85	27.92	12132497.0
2005-11-23 16:00:00	MSFT	Stock	27.92	27.96	27.89	27.92	286914.0
2005-11-23 17:00:00	MSFT	Stock	27.93	27.95	27.92	27.92	180950.0
2005-11-23 18:00:00	MSFT	Stock	27.91	28.0	27.88	27.88	7349.0
2005-11-23 08:00:00	NVDA	Stock	0.3157	0.3157	0.3157	0.3157	132000.0
2005-11-23 09:00:00	NVDA	Stock	0.3153	0.3183	0.3138	0.317	54559440.0
2005-11-23 10:00:00	NVDA	Stock	0.3171	0.3182	0.3148	0.3156	63396720.0
2005-11-23 11:00:00	NVDA	Stock	0.3155	0.3156	0.3125	0.3151	62773200.0
2005-11-23 12:00:00	NVDA	Stock	0.3151	0.3187	0.3147	0.3177	48044760.0
2005-11-23 13:00:00	NVDA	Stock	0.3178	0.318	0.3167	0.3177	30339480.0
2005-11-23 14:00:00	NVDA	Stock	0.3177	0.3179	0.3162	0.3167	39889320.0
2005-11-23 15:00:00	NVDA	Stock	0.3167	0.3167	0.3128	0.3142	104701800.0
2005-11-23 16:00:00	NVDA	Stock	0.3142	0.3167	0.3142	0.3167	600000.0
2005-11-23 17:00:00	NVDA	Stock	0.3149	0.3149	0.3149	0.3149	12000.0
2005-11-23 08:00:00	AMZN	Stock	2.441	2.441	2.433	2.434	378000.0
2005-11-23 09:00:00	AMZN	Stock	2.435	2.448	2.43	2.4414	23407180.0
2005-11-23 10:00:00	AMZN	Stock	2.4415	2.442	2.4175	2.42	30030220.0
2005-11-23 11:00:00	AMZN	Stock	2.42	2.4298	2.4115	2.421	19705800.0
2005-11-23 12:00:00	AMZN	Stock	2.4215	2.4275	2.42	2.4245	14242700.0
2005-11-23 13:00:00	AMZN	Stock	2.4245	2.4325	2.4165	2.4205	8699260.0
2005-11-23 14:00:00	AMZN	Stock	2.4206	2.4238	2.412	2.423	14247960.0
2005-11-23 15:00:00	AMZN	Stock	2.423	2.4235	2.4045	2.412	34724900.0
2005-11-23 16:00:00	AMZN	Stock	2.41	2.415	2.362	2.41	443080.0
2005-11-23 17:00:00	AMZN	Stock	2.41	2.412	2.41	2.412	2299000.0
2005-11-23 09:00:00	CL	Stock	26.995	26.995	26.855	26.95	312600.0
2005-11-23 10:00:00	CL	Stock	26.95	26.97	26.825	26.865	321200.0
2005-11-23 11:00:00	CL	Stock	26.865	26.97	26.84	26.95	187200.0
2005-11-23 12:00:00	CL	Stock	26.945	26.95	26.825	26.88	278400.0
2005-11-23 13:00:00	CL	Stock	26.88	26.97	26.88	26.95	123000.0
2005-11-23 14:00:00	CL	Stock	26.95	27.05	26.95	27.015	217000.0
2005-11-23 15:00:00	CL	Stock	27.015	27.015	26.95	26.995	419000.0

> showing 49 of 26,554 rows — these rows as CSV

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