PREVIEW / stock_1hour / 2009-05-01

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-05-01.parquet
  size:    821 KB
  rows:    40,230
  symbols: 3,319

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-01 05:00:00	AAPL	Stock	4.4964	4.4964	4.4964	4.4964	5600.0
2009-05-01 07:00:00	AAPL	Stock	4.5071	4.5071	4.5071	4.5071	2800.0
2009-05-01 08:00:00	AAPL	Stock	4.5079	4.5193	4.4961	4.4964	837284.0
2009-05-01 09:00:00	AAPL	Stock	4.4968	4.5357	4.4886	4.5307	55341916.0
2009-05-01 10:00:00	AAPL	Stock	4.5307	4.5382	4.4936	4.5257	61276040.0
2009-05-01 11:00:00	AAPL	Stock	4.525	4.5518	4.5196	4.5279	53590572.0
2009-05-01 12:00:00	AAPL	Stock	4.5289	4.5589	4.52	4.5557	43498448.0
2009-05-01 13:00:00	AAPL	Stock	4.5557	4.5679	4.5446	4.5664	35127708.0
2009-05-01 14:00:00	AAPL	Stock	4.5671	4.5696	4.5396	4.5411	49450408.0
2009-05-01 15:00:00	AAPL	Stock	4.5414	4.5536	4.5132	4.5429	78305444.0
2009-05-01 16:00:00	AAPL	Stock	4.5432	4.5632	4.4939	4.5464	8899212.0
2009-05-01 17:00:00	AAPL	Stock	4.5482	4.55	4.5464	4.5464	58800.0
2009-05-01 18:00:00	AAPL	Stock	4.5464	4.5479	4.545	4.5464	74396.0
2009-05-01 19:00:00	AAPL	Stock	4.5446	4.5518	4.5446	4.5518	18760.0
2009-05-01 20:00:00	AAPL	Stock	4.5279	4.5279	4.5279	4.5279	33600.0
2009-05-01 05:00:00	MSFT	Stock	21.1	21.1	21.1	21.1	200.0
2009-05-01 08:00:00	MSFT	Stock	20.35	20.59	20.35	20.4	26200.0
2009-05-01 09:00:00	MSFT	Stock	20.26	20.42	19.87	19.99	5919192.0
2009-05-01 10:00:00	MSFT	Stock	19.99	20.055	19.87	19.94	8957962.0
2009-05-01 11:00:00	MSFT	Stock	19.94	20.01	19.92	19.97	5884582.0
2009-05-01 12:00:00	MSFT	Stock	19.965	20.0	19.91	19.96	4354633.0
2009-05-01 13:00:00	MSFT	Stock	19.97	20.0	19.92	19.96	6631326.0
2009-05-01 14:00:00	MSFT	Stock	19.95	20.05	19.93	20.001	9108734.0
2009-05-01 15:00:00	MSFT	Stock	20.0	20.23	19.862	20.22	15863551.0
2009-05-01 16:00:00	MSFT	Stock	20.22	20.25	19.991	20.18	4207324.0
2009-05-01 17:00:00	MSFT	Stock	20.18	20.19	20.18	20.18	4971.0
2009-05-01 18:00:00	MSFT	Stock	20.18	20.19	20.16	20.19	1381.0
2009-05-01 19:00:00	MSFT	Stock	20.18	20.18	20.12	20.12	4144.0
2009-05-01 20:00:00	MSFT	Stock	19.97	19.97	19.97	19.97	74000.0
2009-05-01 09:00:00	NVDA	Stock	0.2862	0.292	0.286	0.2885	79363720.0
2009-05-01 10:00:00	NVDA	Stock	0.2888	0.295	0.2875	0.2935	193710360.0
2009-05-01 11:00:00	NVDA	Stock	0.2932	0.2968	0.2932	0.2942	129660480.0
2009-05-01 12:00:00	NVDA	Stock	0.2944	0.297	0.2934	0.295	91274880.0
2009-05-01 13:00:00	NVDA	Stock	0.295	0.2985	0.2942	0.2965	57574400.0
2009-05-01 14:00:00	NVDA	Stock	0.2968	0.297	0.2925	0.2925	62502560.0
2009-05-01 15:00:00	NVDA	Stock	0.2925	0.295	0.2888	0.2918	209424800.0
2009-05-01 16:00:00	NVDA	Stock	0.2918	0.295	0.2918	0.2918	16415280.0
2009-05-01 17:00:00	NVDA	Stock	0.2945	0.2945	0.2945	0.2945	24000.0
2009-05-01 18:00:00	NVDA	Stock	0.2942	0.2945	0.2942	0.2945	100000.0
2009-05-01 19:00:00	NVDA	Stock	0.2925	0.295	0.2925	0.2945	100000.0
2009-05-01 07:00:00	AMZN	Stock	4.075	4.075	4.075	4.075	4000.0
2009-05-01 08:00:00	AMZN	Stock	4.027	4.0705	4.027	4.06	10000.0
2009-05-01 09:00:00	AMZN	Stock	4.026	4.0405	3.931	3.943	19151340.0
2009-05-01 10:00:00	AMZN	Stock	3.9445	3.965	3.8925	3.9255	22813160.0
2009-05-01 11:00:00	AMZN	Stock	3.9265	3.954	3.9185	3.938	12929880.0
2009-05-01 12:00:00	AMZN	Stock	3.938	3.9825	3.9355	3.9615	11651940.0
2009-05-01 13:00:00	AMZN	Stock	3.962	3.9925	3.946	3.9615	12497480.0
2009-05-01 14:00:00	AMZN	Stock	3.962	3.9655	3.931	3.933	10246880.0
2009-05-01 15:00:00	AMZN	Stock	3.933	3.95	3.912	3.9475	26427760.0
2009-05-01 16:00:00	AMZN	Stock	3.9475	3.966	3.9405	3.948	2695180.0

> showing 50 of 40,230 rows — these rows as CSV

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