PREVIEW / stock_1hour / 2010-01-08

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-01-08.parquet
  size:    896 KB
  rows:    42,893
  symbols: 3,424

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-01-08 06:00:00	AAPL	Stock	7.5536	7.5536	7.5393	7.5393	11200.0
2010-01-08 07:00:00	AAPL	Stock	7.5536	7.5543	7.5357	7.5357	100100.0
2010-01-08 08:00:00	AAPL	Stock	7.5421	7.5425	7.4732	7.4957	4386900.0
2010-01-08 09:00:00	AAPL	Stock	7.4964	7.5446	7.4664	7.4936	81190144.0
2010-01-08 10:00:00	AAPL	Stock	7.4939	7.54	7.4924	7.5304	89245744.0
2010-01-08 11:00:00	AAPL	Stock	7.5305	7.5639	7.5143	7.56	59013780.0
2010-01-08 12:00:00	AAPL	Stock	7.56	7.5614	7.5318	7.5382	39147388.0
2010-01-08 13:00:00	AAPL	Stock	7.5384	7.5443	7.525	7.5312	43878128.0
2010-01-08 14:00:00	AAPL	Stock	7.5307	7.5486	7.5279	7.5436	39032196.0
2010-01-08 15:00:00	AAPL	Stock	7.5436	7.5714	7.5296	7.5675	67161640.0
2010-01-08 16:00:00	AAPL	Stock	7.5711	7.5736	7.5104	7.5643	11402384.0
2010-01-08 17:00:00	AAPL	Stock	7.5564	7.5707	7.5564	7.5704	391748.0
2010-01-08 18:00:00	AAPL	Stock	7.5696	7.5707	7.5632	7.5632	507976.0
2010-01-08 19:00:00	AAPL	Stock	7.565	7.5689	7.565	7.5679	72940.0
2010-01-08 07:00:00	MSFT	Stock	30.39	30.46	30.39	30.4	1900.0
2010-01-08 08:00:00	MSFT	Stock	30.48	30.5	30.28	30.31	14005.0
2010-01-08 09:00:00	MSFT	Stock	30.32	30.55	30.24	30.54	7378642.0
2010-01-08 10:00:00	MSFT	Stock	30.54	30.68	30.45	30.575	7354612.0
2010-01-08 11:00:00	MSFT	Stock	30.575	30.66	30.51	30.65	5392516.0
2010-01-08 12:00:00	MSFT	Stock	30.65	30.79	30.45	30.76	6749360.0
2010-01-08 13:00:00	MSFT	Stock	30.76	30.83	30.73	30.77	4481480.0
2010-01-08 14:00:00	MSFT	Stock	30.77	30.88	30.75	30.85	4243887.0
2010-01-08 15:00:00	MSFT	Stock	30.85	30.86	30.61	30.63	9650494.0
2010-01-08 16:00:00	MSFT	Stock	30.66	30.736	30.48	30.736	4132551.0
2010-01-08 17:00:00	MSFT	Stock	30.62	30.73	30.62	30.72	45245.0
2010-01-08 18:00:00	MSFT	Stock	30.72	30.72	30.7	30.7	1919.0
2010-01-08 19:00:00	MSFT	Stock	30.7	30.72	30.7	30.7	2644.0
2010-01-08 08:00:00	NVDA	Stock	0.4625	0.4625	0.46	0.46	58400.0
2010-01-08 09:00:00	NVDA	Stock	0.4598	0.4662	0.4562	0.461	65262320.0
2010-01-08 10:00:00	NVDA	Stock	0.461	0.467	0.461	0.4643	104904920.0
2010-01-08 11:00:00	NVDA	Stock	0.4643	0.4648	0.4608	0.4612	76338640.0
2010-01-08 12:00:00	NVDA	Stock	0.4612	0.4625	0.4605	0.4612	44306240.0
2010-01-08 13:00:00	NVDA	Stock	0.4612	0.4645	0.4612	0.4628	58602520.0
2010-01-08 14:00:00	NVDA	Stock	0.4628	0.4635	0.461	0.4622	47875440.0
2010-01-08 15:00:00	NVDA	Stock	0.4622	0.4645	0.462	0.464	65673760.0
2010-01-08 16:00:00	NVDA	Stock	0.4638	0.4652	0.4628	0.4652	9452160.0
2010-01-08 17:00:00	NVDA	Stock	0.4652	0.4652	0.4652	0.4652	132000.0
2010-01-08 18:00:00	NVDA	Stock	0.4665	0.4665	0.4665	0.4665	4000.0
2010-01-08 19:00:00	NVDA	Stock	0.4662	0.4662	0.4662	0.4662	6000.0
2010-01-08 08:00:00	AMZN	Stock	6.495	6.495	6.4355	6.465	226260.0
2010-01-08 09:00:00	AMZN	Stock	6.4725	6.5585	6.4515	6.5153	31614560.0
2010-01-08 10:00:00	AMZN	Stock	6.5158	6.5305	6.4695	6.53	30065540.0
2010-01-08 11:00:00	AMZN	Stock	6.53	6.5958	6.519	6.585	33254800.0
2010-01-08 12:00:00	AMZN	Stock	6.5855	6.6045	6.5565	6.5809	16145160.0
2010-01-08 13:00:00	AMZN	Stock	6.5825	6.6425	6.572	6.627	23215900.0
2010-01-08 14:00:00	AMZN	Stock	6.6265	6.642	6.6045	6.6385	18245540.0
2010-01-08 15:00:00	AMZN	Stock	6.6385	6.684	6.6165	6.677	39020480.0
2010-01-08 16:00:00	AMZN	Stock	6.675	6.683	6.5774	6.675	738920.0
2010-01-08 17:00:00	AMZN	Stock	6.667	6.667	6.65	6.657	310060.0
2010-01-08 18:00:00	AMZN	Stock	6.6575	6.665	6.6575	6.6625	58640.0

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

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