PREVIEW / stock_1hour / 2010-02-02

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-02-02.parquet
  size:    897 KB
  rows:    42,889
  symbols: 3,439

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
2010-02-02 05:00:00	AAPL	Stock	6.9629	6.9682	6.9629	6.9682	11200.0
2010-02-02 06:00:00	AAPL	Stock	6.9907	6.9914	6.9907	6.9911	11424.0
2010-02-02 07:00:00	AAPL	Stock	6.9911	6.9996	6.9771	6.9818	186536.0
2010-02-02 08:00:00	AAPL	Stock	6.9786	6.9993	6.9589	6.9761	3389568.0
2010-02-02 09:00:00	AAPL	Stock	6.9739	7.0054	6.9404	6.9546	95856628.0
2010-02-02 10:00:00	AAPL	Stock	6.9568	6.9786	6.9064	6.9254	137402300.0
2010-02-02 11:00:00	AAPL	Stock	6.9254	6.9736	6.9146	6.9618	77020720.0
2010-02-02 12:00:00	AAPL	Stock	6.9611	6.9779	6.9521	6.9779	47729752.0
2010-02-02 13:00:00	AAPL	Stock	6.9771	7.0	6.9557	6.9803	62736912.0
2010-02-02 14:00:00	AAPL	Stock	6.9811	6.9921	6.9614	6.9767	53537848.0
2010-02-02 15:00:00	AAPL	Stock	6.9768	7.0114	6.9661	6.9936	97080116.0
2010-02-02 16:00:00	AAPL	Stock	6.9939	6.9964	6.9643	6.9911	28322196.0
2010-02-02 17:00:00	AAPL	Stock	6.9546	6.9945	6.9546	6.9889	185472.0
2010-02-02 18:00:00	AAPL	Stock	6.9879	6.995	6.9879	6.9939	210308.0
2010-02-02 19:00:00	AAPL	Stock	6.9929	6.9929	6.9875	6.9875	179004.0
2010-02-02 04:00:00	MSFT	Stock	28.3	28.3	28.3	28.3	100.0
2010-02-02 05:00:00	MSFT	Stock	28.36	28.36	28.36	28.36	100.0
2010-02-02 07:00:00	MSFT	Stock	28.4	28.45	28.37	28.45	3600.0
2010-02-02 08:00:00	MSFT	Stock	28.43	28.46	28.36	28.37	33183.0
2010-02-02 09:00:00	MSFT	Stock	28.36	28.42	28.16	28.2	6646525.0
2010-02-02 10:00:00	MSFT	Stock	28.21	28.5	28.14	28.4	11575419.0
2010-02-02 11:00:00	MSFT	Stock	28.4	28.46	28.32	28.415	5655934.0
2010-02-02 12:00:00	MSFT	Stock	28.42	28.49	28.37	28.405	5545817.0
2010-02-02 13:00:00	MSFT	Stock	28.41	28.44	28.27	28.42	5379346.0
2010-02-02 14:00:00	MSFT	Stock	28.42	28.44	28.35	28.4	4608213.0
2010-02-02 15:00:00	MSFT	Stock	28.41	28.5	28.38	28.48	10214773.0
2010-02-02 16:00:00	MSFT	Stock	28.48	28.49	28.37	28.386	3056277.0
2010-02-02 17:00:00	MSFT	Stock	28.41	28.42	28.38	28.4	2090.0
2010-02-02 18:00:00	MSFT	Stock	28.4	28.46	28.38	28.4	18583.0
2010-02-02 19:00:00	MSFT	Stock	28.39	28.42	28.36	28.39	8771.0
2010-02-02 20:00:00	MSFT	Stock	28.41	28.41	28.41	28.41	251800.0
2010-02-02 08:00:00	NVDA	Stock	0.4175	0.4178	0.4168	0.4168	45000.0
2010-02-02 09:00:00	NVDA	Stock	0.4165	0.4178	0.4115	0.4138	102893440.0
2010-02-02 10:00:00	NVDA	Stock	0.4138	0.4173	0.4115	0.4165	202828760.0
2010-02-02 11:00:00	NVDA	Stock	0.4162	0.4215	0.4145	0.4202	142653440.0
2010-02-02 12:00:00	NVDA	Stock	0.4202	0.4238	0.418	0.4195	107423280.0
2010-02-02 13:00:00	NVDA	Stock	0.4195	0.4205	0.4165	0.4182	93180200.0
2010-02-02 14:00:00	NVDA	Stock	0.4182	0.4208	0.4165	0.4198	61271960.0
2010-02-02 15:00:00	NVDA	Stock	0.4198	0.4218	0.4182	0.4185	106698720.0
2010-02-02 16:00:00	NVDA	Stock	0.4185	0.4211	0.4172	0.4185	14565320.0
2010-02-02 17:00:00	NVDA	Stock	0.4142	0.4174	0.4142	0.4174	2352000.0
2010-02-02 18:00:00	NVDA	Stock	0.4185	0.4185	0.4185	0.4185	969480.0
2010-02-02 07:00:00	AMZN	Stock	5.9665	5.9665	5.938	5.95	18000.0
2010-02-02 08:00:00	AMZN	Stock	5.96	5.9935	5.9025	5.945	1517260.0
2010-02-02 09:00:00	AMZN	Stock	5.943	5.9675	5.77	5.795	85698600.0
2010-02-02 10:00:00	AMZN	Stock	5.794	5.816	5.72	5.76	115222540.0
2010-02-02 11:00:00	AMZN	Stock	5.7594	5.8435	5.7355	5.8345	61455240.0
2010-02-02 12:00:00	AMZN	Stock	5.8345	5.862	5.8165	5.85	34520360.0
2010-02-02 13:00:00	AMZN	Stock	5.8495	5.8735	5.8055	5.845	39133720.0
2010-02-02 14:00:00	AMZN	Stock	5.8445	5.922	5.8145	5.914	50165280.0

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

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