PREVIEW / stock_1hour / 2009-05-04

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-05-04.parquet
  size:    871 KB
  rows:    42,496
  symbols: 3,363

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
2009-05-04 06:00:00	AAPL	Stock	4.5696	4.585	4.5696	4.585	11200.0
2009-05-04 07:00:00	AAPL	Stock	4.5518	4.5518	4.5518	4.5518	2800.0
2009-05-04 08:00:00	AAPL	Stock	4.5707	4.595	4.5679	4.5711	791448.0
2009-05-04 09:00:00	AAPL	Stock	4.5711	4.6038	4.56	4.5768	78351924.0
2009-05-04 10:00:00	AAPL	Stock	4.5782	4.6414	4.575	4.6268	94915072.0
2009-05-04 11:00:00	AAPL	Stock	4.6268	4.6425	4.6264	4.6393	47620748.0
2009-05-04 12:00:00	AAPL	Stock	4.6393	4.6732	4.6332	4.67	76589856.0
2009-05-04 13:00:00	AAPL	Stock	4.67	4.7143	4.67	4.6986	92252328.0
2009-05-04 14:00:00	AAPL	Stock	4.6986	4.71	4.6832	4.6975	72037280.0
2009-05-04 15:00:00	AAPL	Stock	4.6982	4.7232	4.6786	4.7211	113120896.0
2009-05-04 16:00:00	AAPL	Stock	4.715	4.7214	4.6393	4.7196	26234516.0
2009-05-04 17:00:00	AAPL	Stock	4.7168	4.7207	4.7146	4.7179	543032.0
2009-05-04 18:00:00	AAPL	Stock	4.7168	4.7196	4.7168	4.7179	1718920.0
2009-05-04 19:00:00	AAPL	Stock	4.7193	4.7232	4.7186	4.7232	138292.0
2009-05-04 07:00:00	MSFT	Stock	20.46	20.46	20.35	20.35	400.0
2009-05-04 08:00:00	MSFT	Stock	20.35	20.44	20.25	20.35	43621.0
2009-05-04 09:00:00	MSFT	Stock	20.35	20.42	19.98	20.02	8249784.0
2009-05-04 10:00:00	MSFT	Stock	20.02	20.34	19.99	20.112	9724794.0
2009-05-04 11:00:00	MSFT	Stock	20.12	20.28	20.11	20.16	4809590.0
2009-05-04 12:00:00	MSFT	Stock	20.16	20.22	20.05	20.15	5302592.0
2009-05-04 13:00:00	MSFT	Stock	20.15	20.2	20.09	20.19	4126252.0
2009-05-04 14:00:00	MSFT	Stock	20.19	20.23	20.08	20.11	6729977.0
2009-05-04 15:00:00	MSFT	Stock	20.108	20.24	20.06	20.24	11218404.0
2009-05-04 16:00:00	MSFT	Stock	20.25	20.26	20.104	20.24	2751085.0
2009-05-04 17:00:00	MSFT	Stock	20.23	20.25	20.21	20.21	24129.0
2009-05-04 18:00:00	MSFT	Stock	20.21	20.25	20.21	20.24	12492.0
2009-05-04 19:00:00	MSFT	Stock	20.24	20.26	20.2	20.26	15420.0
2009-05-04 08:00:00	NVDA	Stock	0.2925	0.2955	0.2925	0.2955	104000.0
2009-05-04 09:00:00	NVDA	Stock	0.2955	0.3048	0.2928	0.3042	141582760.0
2009-05-04 10:00:00	NVDA	Stock	0.3042	0.309	0.3039	0.309	180369840.0
2009-05-04 11:00:00	NVDA	Stock	0.3086	0.3098	0.3062	0.3073	140184840.0
2009-05-04 12:00:00	NVDA	Stock	0.3075	0.3083	0.3052	0.306	58642040.0
2009-05-04 13:00:00	NVDA	Stock	0.3062	0.3084	0.306	0.3065	64906960.0
2009-05-04 14:00:00	NVDA	Stock	0.3062	0.3073	0.304	0.305	90858080.0
2009-05-04 15:00:00	NVDA	Stock	0.3052	0.3078	0.3035	0.3078	225253440.0
2009-05-04 16:00:00	NVDA	Stock	0.307	0.3078	0.3053	0.307	17747760.0
2009-05-04 17:00:00	NVDA	Stock	0.3075	0.3075	0.3062	0.3062	87640.0
2009-05-04 18:00:00	NVDA	Stock	0.3062	0.3062	0.306	0.3062	17760.0
2009-05-04 19:00:00	NVDA	Stock	0.3065	0.3073	0.3062	0.3062	72000.0
2009-05-04 08:00:00	AMZN	Stock	3.98	3.99	3.975	3.975	63000.0
2009-05-04 09:00:00	AMZN	Stock	3.99	4.023	3.9425	3.98	19095840.0
2009-05-04 10:00:00	AMZN	Stock	3.9805	4.0675	3.9805	4.02	31318700.0
2009-05-04 11:00:00	AMZN	Stock	4.0205	4.065	4.0096	4.0255	14021660.0
2009-05-04 12:00:00	AMZN	Stock	4.0255	4.0415	4.0065	4.0125	13186800.0
2009-05-04 13:00:00	AMZN	Stock	4.013	4.023	3.9845	4.003	16452060.0
2009-05-04 14:00:00	AMZN	Stock	4.0035	4.0592	3.966	3.97	15291040.0
2009-05-04 15:00:00	AMZN	Stock	3.971	3.994	3.951	3.9935	25804900.0
2009-05-04 16:00:00	AMZN	Stock	3.994	4.004	3.948	4.0	3660780.0
2009-05-04 17:00:00	AMZN	Stock	4.009	4.025	3.994	4.0225	204180.0
2009-05-04 18:00:00	AMZN	Stock	4.0225	4.0225	4.006	4.006	166640.0

> showing 50 of 42,496 rows — these rows as CSV

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