PREVIEW / stock_1hour / 2005-05-27

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-05-27.parquet
  size:    530 KB
  rows:    25,249
  symbols: 1,973

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-05-27 08:00:00	AAPL	Stock	1.4571	1.4621	1.455	1.4589	891744.0
2005-05-27 09:00:00	AAPL	Stock	1.4604	1.4604	1.4304	1.435	77403480.0
2005-05-27 10:00:00	AAPL	Stock	1.435	1.4425	1.4289	1.4396	83019272.0
2005-05-27 11:00:00	AAPL	Stock	1.4396	1.4436	1.4382	1.4393	28594916.0
2005-05-27 12:00:00	AAPL	Stock	1.4393	1.4429	1.4389	1.4414	22158472.0
2005-05-27 13:00:00	AAPL	Stock	1.4411	1.4464	1.4404	1.445	20955480.0
2005-05-27 14:00:00	AAPL	Stock	1.445	1.4475	1.4436	1.4454	21869288.0
2005-05-27 15:00:00	AAPL	Stock	1.4454	1.4568	1.4429	1.4471	54349904.0
2005-05-27 16:00:00	AAPL	Stock	1.4471	1.45	1.4446	1.4479	1796816.0
2005-05-27 17:00:00	AAPL	Stock	1.4471	1.4486	1.4471	1.4486	86800.0
2005-05-27 18:00:00	AAPL	Stock	1.4493	1.4514	1.4493	1.4493	65688.0
2005-05-27 07:00:00	MSFT	Stock	25.83	25.83	25.83	25.83	650.0
2005-05-27 08:00:00	MSFT	Stock	25.9	25.9	25.86	25.86	57936.0
2005-05-27 09:00:00	MSFT	Stock	25.87	26.0	25.79	25.97	7328865.0
2005-05-27 10:00:00	MSFT	Stock	25.96	26.07	25.95	26.03	16411914.0
2005-05-27 11:00:00	MSFT	Stock	26.03	26.06	25.99	26.03	7180091.0
2005-05-27 12:00:00	MSFT	Stock	26.03	26.08	26.01	26.02	3013532.0
2005-05-27 13:00:00	MSFT	Stock	26.02	26.05	25.95	25.98	5570646.0
2005-05-27 14:00:00	MSFT	Stock	25.98	26.03	25.9	25.99	5012486.0
2005-05-27 15:00:00	MSFT	Stock	25.999	26.09	25.98	26.08	9538641.0
2005-05-27 16:00:00	MSFT	Stock	26.08	26.09	26.05	26.08	175773.0
2005-05-27 17:00:00	MSFT	Stock	26.08	26.08	26.06	26.08	1188.0
2005-05-27 18:00:00	MSFT	Stock	26.08	26.08	26.08	26.08	715.0
2005-05-27 08:00:00	NVDA	Stock	0.2302	0.2314	0.2293	0.2314	654000.0
2005-05-27 09:00:00	NVDA	Stock	0.2297	0.2315	0.229	0.23	43107600.0
2005-05-27 10:00:00	NVDA	Stock	0.23	0.2302	0.2271	0.2285	63243600.0
2005-05-27 11:00:00	NVDA	Stock	0.2286	0.2289	0.2269	0.2272	39249960.0
2005-05-27 12:00:00	NVDA	Stock	0.2272	0.2273	0.227	0.2273	28358880.0
2005-05-27 13:00:00	NVDA	Stock	0.2273	0.2292	0.2273	0.229	38895480.0
2005-05-27 14:00:00	NVDA	Stock	0.2288	0.2295	0.2282	0.2294	47701320.0
2005-05-27 15:00:00	NVDA	Stock	0.2293	0.2314	0.2287	0.2292	54226800.0
2005-05-27 16:00:00	NVDA	Stock	0.2293	0.23	0.2293	0.2293	1329120.0
2005-05-27 08:00:00	AMZN	Stock	1.77	1.77	1.7425	1.754	648840.0
2005-05-27 09:00:00	AMZN	Stock	1.754	1.766	1.754	1.765	11381880.0
2005-05-27 10:00:00	AMZN	Stock	1.765	1.7675	1.7595	1.765	12027640.0
2005-05-27 11:00:00	AMZN	Stock	1.7655	1.7665	1.7645	1.7655	4304740.0
2005-05-27 12:00:00	AMZN	Stock	1.7655	1.7665	1.765	1.766	3417620.0
2005-05-27 13:00:00	AMZN	Stock	1.7664	1.7775	1.7655	1.773	8435200.0
2005-05-27 14:00:00	AMZN	Stock	1.773	1.7735	1.769	1.7715	6477500.0
2005-05-27 15:00:00	AMZN	Stock	1.772	1.776	1.771	1.775	18310260.0
2005-05-27 16:00:00	AMZN	Stock	1.775	1.776	1.7745	1.775	302040.0
2005-05-27 17:00:00	AMZN	Stock	1.774	1.774	1.774	1.774	2000.0
2005-05-27 18:00:00	AMZN	Stock	1.773	1.774	1.773	1.774	16000.0
2005-05-27 09:00:00	CL	Stock	25.11	25.235	25.11	25.23	284600.0
2005-05-27 10:00:00	CL	Stock	25.23	25.23	25.035	25.11	363000.0
2005-05-27 11:00:00	CL	Stock	25.115	25.165	25.07	25.085	225800.0
2005-05-27 12:00:00	CL	Stock	25.085	25.125	25.075	25.075	217600.0
2005-05-27 13:00:00	CL	Stock	25.075	25.11	25.04	25.05	411800.0
2005-05-27 14:00:00	CL	Stock	25.05	25.06	25.025	25.05	392200.0
2005-05-27 15:00:00	CL	Stock	25.05	25.054	25.01	25.03	479400.0

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

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