PREVIEW / stock_1hour / 2005-10-28

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-10-28.parquet
  size:    571 KB
  rows:    26,940
  symbols: 2,097

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-10-28 08:00:00	AAPL	Stock	1.9821	1.9929	1.9821	1.9857	825104.0
2005-10-28 09:00:00	AAPL	Stock	1.9875	2.0154	1.9864	2.0036	74132604.0
2005-10-28 10:00:00	AAPL	Stock	2.0036	2.0064	1.9368	1.9518	181869968.0
2005-10-28 11:00:00	AAPL	Stock	1.9521	1.9907	1.9518	1.9882	116436068.0
2005-10-28 12:00:00	AAPL	Stock	1.9886	1.9914	1.9571	1.9589	73510416.0
2005-10-28 13:00:00	AAPL	Stock	1.9589	1.9654	1.9421	1.9468	71522500.0
2005-10-28 14:00:00	AAPL	Stock	1.9471	1.9571	1.9425	1.9504	93303364.0
2005-10-28 15:00:00	AAPL	Stock	1.9504	1.9554	1.9346	1.9421	142828028.0
2005-10-28 16:00:00	AAPL	Stock	1.9436	1.95	1.9404	1.9496	1327256.0
2005-10-28 17:00:00	AAPL	Stock	1.9482	1.9482	1.9429	1.9464	202524.0
2005-10-28 18:00:00	AAPL	Stock	1.9479	1.9543	1.9479	1.9482	76300.0
2005-10-28 04:00:00	MSFT	Stock	25.5	25.5	25.5	25.5	160.0
2005-10-28 06:00:00	MSFT	Stock	25.5	25.5	24.7	24.71	35100.0
2005-10-28 07:00:00	MSFT	Stock	24.7	24.78	24.7	24.75	25600.0
2005-10-28 08:00:00	MSFT	Stock	24.77	25.09	24.7	24.96	1938343.0
2005-10-28 09:00:00	MSFT	Stock	24.96	25.491	24.96	25.38	21807291.0
2005-10-28 10:00:00	MSFT	Stock	25.38	25.49	25.3	25.36	20046405.0
2005-10-28 11:00:00	MSFT	Stock	25.36	25.47	25.35	25.432	12820508.0
2005-10-28 12:00:00	MSFT	Stock	25.44	25.46	25.33	25.38	6244870.0
2005-10-28 13:00:00	MSFT	Stock	25.37	25.5	25.35	25.41	8721832.0
2005-10-28 14:00:00	MSFT	Stock	25.418	25.53	25.39	25.52	12112458.0
2005-10-28 15:00:00	MSFT	Stock	25.53	25.6	25.44	25.53	17475173.0
2005-10-28 16:00:00	MSFT	Stock	25.53	25.56	25.4	25.5	777755.0
2005-10-28 17:00:00	MSFT	Stock	25.49	25.51	25.47	25.5	16850.0
2005-10-28 18:00:00	MSFT	Stock	25.5	25.56	25.47	25.51	1798834.0
2005-10-28 08:00:00	NVDA	Stock	0.2621	0.2621	0.2621	0.2621	72000.0
2005-10-28 09:00:00	NVDA	Stock	0.2621	0.2638	0.2596	0.2597	50463120.0
2005-10-28 10:00:00	NVDA	Stock	0.2597	0.2606	0.2562	0.2582	83717760.0
2005-10-28 11:00:00	NVDA	Stock	0.2583	0.2625	0.258	0.2624	39498600.0
2005-10-28 12:00:00	NVDA	Stock	0.2625	0.2665	0.2622	0.2644	52175400.0
2005-10-28 13:00:00	NVDA	Stock	0.2645	0.2688	0.2645	0.2671	65729040.0
2005-10-28 14:00:00	NVDA	Stock	0.2673	0.2693	0.2673	0.2692	58850280.0
2005-10-28 15:00:00	NVDA	Stock	0.2692	0.2707	0.2687	0.2704	101603040.0
2005-10-28 16:00:00	NVDA	Stock	0.2704	0.2711	0.2694	0.2711	2313840.0
2005-10-28 17:00:00	NVDA	Stock	0.27	0.2701	0.27	0.2701	228000.0
2005-10-28 08:00:00	AMZN	Stock	1.9545	1.966	1.954	1.966	41160.0
2005-10-28 09:00:00	AMZN	Stock	1.9655	1.99	1.956	1.9655	15525420.0
2005-10-28 10:00:00	AMZN	Stock	1.964	1.967	1.943	1.9515	18499160.0
2005-10-28 11:00:00	AMZN	Stock	1.9515	1.96	1.945	1.9575	13521720.0
2005-10-28 12:00:00	AMZN	Stock	1.9575	1.9615	1.9365	1.9365	11002520.0
2005-10-28 13:00:00	AMZN	Stock	1.9365	1.95	1.936	1.95	16743860.0
2005-10-28 14:00:00	AMZN	Stock	1.95	1.9535	1.939	1.945	13412860.0
2005-10-28 15:00:00	AMZN	Stock	1.945	1.9515	1.9385	1.947	22522340.0
2005-10-28 16:00:00	AMZN	Stock	1.9475	1.9505	1.9435	1.9505	891700.0
2005-10-28 17:00:00	AMZN	Stock	1.9505	1.9505	1.95	1.95	6000.0
2005-10-28 18:00:00	AMZN	Stock	1.95	1.95	1.95	1.95	6160.0
2005-10-28 09:00:00	CL	Stock	26.14	26.245	26.115	26.17	368800.0
2005-10-28 10:00:00	CL	Stock	26.185	26.245	26.1465	26.175	534200.0
2005-10-28 11:00:00	CL	Stock	26.175	26.28	26.175	26.23	429200.0
2005-10-28 12:00:00	CL	Stock	26.23	26.23	26.155	26.19	288400.0

> showing 50 of 26,940 rows — these rows as CSV

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