PREVIEW / stock_1hour / 2005-11-28

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-11-28.parquet
  size:    574 KB
  rows:    27,402
  symbols: 2,134

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-28 07:00:00	AAPL	Stock	2.5007	2.5286	2.5004	2.5143	592200.0
2005-11-28 08:00:00	AAPL	Stock	2.5179	2.535	2.5114	2.5296	13654256.0
2005-11-28 09:00:00	AAPL	Stock	2.5296	2.5382	2.5036	2.5093	271116188.0
2005-11-28 10:00:00	AAPL	Stock	2.5093	2.5264	2.4875	2.4889	210061432.0
2005-11-28 11:00:00	AAPL	Stock	2.4886	2.5089	2.4668	2.4879	188099576.0
2005-11-28 12:00:00	AAPL	Stock	2.4875	2.5057	2.4804	2.4821	88360356.0
2005-11-28 13:00:00	AAPL	Stock	2.4821	2.4989	2.4768	2.4925	82331788.0
2005-11-28 14:00:00	AAPL	Stock	2.4929	2.4961	2.4829	2.4857	59009356.0
2005-11-28 15:00:00	AAPL	Stock	2.485	2.4946	2.4754	2.4898	90856416.0
2005-11-28 16:00:00	AAPL	Stock	2.4889	2.4925	2.4858	2.4893	3930024.0
2005-11-28 17:00:00	AAPL	Stock	2.4893	2.4929	2.4857	2.4896	460236.0
2005-11-28 18:00:00	AAPL	Stock	2.4918	2.4918	2.4875	2.4889	386456.0
2005-11-28 07:00:00	MSFT	Stock	27.84	27.84	27.84	27.84	300.0
2005-11-28 08:00:00	MSFT	Stock	27.81	27.9	27.8	27.87	87908.0
2005-11-28 09:00:00	MSFT	Stock	27.87	27.89	27.53	27.54	7804418.0
2005-11-28 10:00:00	MSFT	Stock	27.54	27.77	27.53	27.702	12631743.0
2005-11-28 11:00:00	MSFT	Stock	27.7	27.79	27.699	27.73	6275989.0
2005-11-28 12:00:00	MSFT	Stock	27.73	27.78	27.65	27.68	6770519.0
2005-11-28 13:00:00	MSFT	Stock	27.68	27.721	27.65	27.7	5967648.0
2005-11-28 14:00:00	MSFT	Stock	27.7	27.78	27.7	27.76	5408655.0
2005-11-28 15:00:00	MSFT	Stock	27.75	27.78	27.69	27.77	10761483.0
2005-11-28 16:00:00	MSFT	Stock	27.77	27.79	27.738	27.75	249436.0
2005-11-28 17:00:00	MSFT	Stock	27.75	27.78	27.716	27.77	15100.0
2005-11-28 18:00:00	MSFT	Stock	27.77	27.79	27.76	27.76	3610.0
2005-11-28 08:00:00	NVDA	Stock	0.3167	0.3181	0.3167	0.3181	99720.0
2005-11-28 09:00:00	NVDA	Stock	0.3181	0.3208	0.317	0.3184	50314680.0
2005-11-28 10:00:00	NVDA	Stock	0.3184	0.3186	0.3167	0.3167	60987600.0
2005-11-28 11:00:00	NVDA	Stock	0.3167	0.3171	0.3137	0.3138	57525840.0
2005-11-28 12:00:00	NVDA	Stock	0.3137	0.3138	0.31	0.31	52220400.0
2005-11-28 13:00:00	NVDA	Stock	0.3102	0.3123	0.3102	0.3119	30937080.0
2005-11-28 14:00:00	NVDA	Stock	0.3118	0.3139	0.3113	0.3136	46367160.0
2005-11-28 15:00:00	NVDA	Stock	0.3136	0.3161	0.3134	0.3157	108540720.0
2005-11-28 16:00:00	NVDA	Stock	0.3156	0.3161	0.315	0.3161	6299520.0
2005-11-28 17:00:00	NVDA	Stock	0.3154	0.3154	0.3154	0.3154	13800.0
2005-11-28 18:00:00	NVDA	Stock	0.3155	0.3155	0.3155	0.3155	36000.0
2005-11-28 08:00:00	AMZN	Stock	2.407	2.4135	2.403	2.4135	314360.0
2005-11-28 09:00:00	AMZN	Stock	2.409	2.433	2.381	2.392	39276660.0
2005-11-28 10:00:00	AMZN	Stock	2.392	2.4095	2.3825	2.4075	34115640.0
2005-11-28 11:00:00	AMZN	Stock	2.408	2.431	2.407	2.425	37653460.0
2005-11-28 12:00:00	AMZN	Stock	2.4255	2.456	2.4155	2.419	35431200.0
2005-11-28 13:00:00	AMZN	Stock	2.419	2.4345	2.415	2.4295	15189880.0
2005-11-28 14:00:00	AMZN	Stock	2.43	2.4405	2.419	2.4205	20454520.0
2005-11-28 15:00:00	AMZN	Stock	2.4205	2.4275	2.416	2.418	27605980.0
2005-11-28 16:00:00	AMZN	Stock	2.4195	2.434	2.4175	2.4225	1642880.0
2005-11-28 17:00:00	AMZN	Stock	2.4225	2.4225	2.4225	2.4225	8000.0
2005-11-28 18:00:00	AMZN	Stock	2.426	2.426	2.426	2.426	2000.0
2005-11-28 09:00:00	CL	Stock	27.06	27.085	26.95	26.995	256000.0
2005-11-28 10:00:00	CL	Stock	26.99	27.21	26.96	27.15	491400.0
2005-11-28 11:00:00	CL	Stock	27.15	27.27	27.13	27.13	410000.0
2005-11-28 12:00:00	CL	Stock	27.12	27.27	27.115	27.165	483800.0

> showing 50 of 27,402 rows — these rows as CSV

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