PREVIEW / stock_1hour / 2009-12-31

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-12-31.parquet
  size:    886 KB
  rows:    42,342
  symbols: 3,467

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-12-31 08:00:00	AAPL	Stock	7.5714	7.6111	7.5714	7.6043	3534664.0
2009-12-31 09:00:00	AAPL	Stock	7.6039	7.6268	7.5607	7.5686	73967768.0
2009-12-31 10:00:00	AAPL	Stock	7.5686	7.5832	7.5464	7.57	56207984.0
2009-12-31 11:00:00	AAPL	Stock	7.5707	7.5757	7.5429	7.5629	49254688.0
2009-12-31 12:00:00	AAPL	Stock	7.5629	7.5729	7.5536	7.5554	23377256.0
2009-12-31 13:00:00	AAPL	Stock	7.5552	7.5579	7.5396	7.5486	29192660.0
2009-12-31 14:00:00	AAPL	Stock	7.5486	7.5536	7.5404	7.5493	22854132.0
2009-12-31 15:00:00	AAPL	Stock	7.5496	7.5518	7.52	7.53	71708168.0
2009-12-31 16:00:00	AAPL	Stock	7.5304	7.5714	7.5214	7.525	13068888.0
2009-12-31 17:00:00	AAPL	Stock	7.5282	7.5321	7.5246	7.5282	163044.0
2009-12-31 18:00:00	AAPL	Stock	7.5279	7.5346	7.5236	7.5257	380688.0
2009-12-31 19:00:00	AAPL	Stock	7.5268	7.5268	7.5096	7.51	273672.0
2009-12-31 08:00:00	MSFT	Stock	30.9	31.04	30.9	31.04	3479.0
2009-12-31 09:00:00	MSFT	Stock	31.03	31.04	30.87	30.91	2464387.0
2009-12-31 10:00:00	MSFT	Stock	30.912	30.92	30.84	30.858	3129837.0
2009-12-31 11:00:00	MSFT	Stock	30.859	30.86	30.72	30.79	3447468.0
2009-12-31 12:00:00	MSFT	Stock	30.78	30.83	30.75	30.77	2218694.0
2009-12-31 13:00:00	MSFT	Stock	30.76	30.83	30.71	30.79	1902511.0
2009-12-31 14:00:00	MSFT	Stock	30.8	30.8	30.75	30.784	2292392.0
2009-12-31 15:00:00	MSFT	Stock	30.79	30.8	30.48	30.49	10349719.0
2009-12-31 16:00:00	MSFT	Stock	30.48	30.835	30.45	30.57	3563734.0
2009-12-31 17:00:00	MSFT	Stock	30.55	30.59	30.55	30.58	4828.0
2009-12-31 18:00:00	MSFT	Stock	30.58	30.58	30.48	30.5	13756.0
2009-12-31 19:00:00	MSFT	Stock	30.48	30.59	30.48	30.59	6742.0
2009-12-31 08:00:00	NVDA	Stock	0.47	0.4725	0.4695	0.47	216600.0
2009-12-31 09:00:00	NVDA	Stock	0.471	0.4738	0.4678	0.4713	62838320.0
2009-12-31 10:00:00	NVDA	Stock	0.4713	0.4723	0.4688	0.472	104518320.0
2009-12-31 11:00:00	NVDA	Stock	0.472	0.4723	0.467	0.47	87956480.0
2009-12-31 12:00:00	NVDA	Stock	0.4702	0.4713	0.4695	0.4705	35751560.0
2009-12-31 13:00:00	NVDA	Stock	0.4705	0.4715	0.4678	0.468	227851640.0
2009-12-31 14:00:00	NVDA	Stock	0.4683	0.4718	0.4681	0.471	57830640.0
2009-12-31 15:00:00	NVDA	Stock	0.4708	0.4723	0.4665	0.467	95628760.0
2009-12-31 16:00:00	NVDA	Stock	0.4675	0.4714	0.4669	0.4678	9842360.0
2009-12-31 17:00:00	NVDA	Stock	0.4673	0.4673	0.4673	0.4673	20000.0
2009-12-31 18:00:00	NVDA	Stock	0.468	0.468	0.467	0.468	73720.0
2009-12-31 07:00:00	AMZN	Stock	6.934	6.934	6.845	6.845	16000.0
2009-12-31 08:00:00	AMZN	Stock	6.834	6.881	6.834	6.856	157100.0
2009-12-31 09:00:00	AMZN	Stock	6.856	6.8785	6.815	6.8315	9655840.0
2009-12-31 10:00:00	AMZN	Stock	6.832	6.839	6.8	6.808	10248040.0
2009-12-31 11:00:00	AMZN	Stock	6.8083	6.812	6.78	6.8055	13478700.0
2009-12-31 12:00:00	AMZN	Stock	6.8055	6.81	6.7825	6.7876	7035260.0
2009-12-31 13:00:00	AMZN	Stock	6.788	6.789	6.7635	6.773	9395120.0
2009-12-31 14:00:00	AMZN	Stock	6.7735	6.7766	6.758	6.7665	7887840.0
2009-12-31 15:00:00	AMZN	Stock	6.7685	6.7785	6.726	6.726	26563280.0
2009-12-31 16:00:00	AMZN	Stock	6.7285	6.7835	6.725	6.7325	928180.0
2009-12-31 17:00:00	AMZN	Stock	6.7325	6.7325	6.729	6.73	28000.0
2009-12-31 18:00:00	AMZN	Stock	6.7285	6.7285	6.725	6.725	34500.0
2009-12-31 08:00:00	TLT	Stock	90.05	90.05	89.11	89.45	72160.0
2009-12-31 09:00:00	TLT	Stock	89.45	89.89	89.34	89.58	433931.0
2009-12-31 10:00:00	TLT	Stock	89.58	89.6	89.05	89.52	974775.0

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

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