PREVIEW / stock_1hour / 2010-05-03

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-05-03.parquet
  size:    954 KB
  rows:    45,317
  symbols: 3,505

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-05-03 04:00:00	AAPL	Stock	9.3704	9.3704	9.3704	9.3704	2800.0
2010-05-03 06:00:00	AAPL	Stock	9.3429	9.3679	9.3318	9.3679	86800.0
2010-05-03 07:00:00	AAPL	Stock	9.3814	9.4179	9.3814	9.4161	537880.0
2010-05-03 08:00:00	AAPL	Stock	9.4161	9.4536	9.3246	9.4496	3902080.0
2010-05-03 09:00:00	AAPL	Stock	9.4486	9.4571	9.3886	9.4339	81767952.0
2010-05-03 10:00:00	AAPL	Stock	9.4339	9.5318	9.425	9.5041	90888980.0
2010-05-03 11:00:00	AAPL	Stock	9.5021	9.5271	9.4739	9.5154	44183216.0
2010-05-03 12:00:00	AAPL	Stock	9.5161	9.5571	9.5025	9.5568	53302704.0
2010-05-03 13:00:00	AAPL	Stock	9.5571	9.5671	9.5411	9.5593	29155252.0
2010-05-03 14:00:00	AAPL	Stock	9.5593	9.5611	9.4893	9.5479	55359584.0
2010-05-03 15:00:00	AAPL	Stock	9.5482	9.55	9.4964	9.5129	75201420.0
2010-05-03 16:00:00	AAPL	Stock	9.5143	9.5309	9.3257	9.4911	12057472.0
2010-05-03 17:00:00	AAPL	Stock	9.4982	9.5	9.4861	9.4964	508200.0
2010-05-03 18:00:00	AAPL	Stock	9.4964	9.5125	9.4843	9.4861	461216.0
2010-05-03 19:00:00	AAPL	Stock	9.4929	9.5	9.4829	9.4911	348740.0
2010-05-03 07:00:00	MSFT	Stock	30.7	30.91	30.68	30.9	21634.0
2010-05-03 08:00:00	MSFT	Stock	30.76	30.76	30.535	30.67	23493.0
2010-05-03 09:00:00	MSFT	Stock	30.69	30.75	30.54	30.69	5114980.0
2010-05-03 10:00:00	MSFT	Stock	30.7	30.75	30.62	30.69	4319892.0
2010-05-03 11:00:00	MSFT	Stock	30.69	30.83	30.68	30.8	5295694.0
2010-05-03 12:00:00	MSFT	Stock	30.8	30.99	30.785	30.98	5463694.0
2010-05-03 13:00:00	MSFT	Stock	30.98	30.99	30.719	30.97	3798707.0
2010-05-03 14:00:00	MSFT	Stock	30.97	31.061	30.92	30.94	4426918.0
2010-05-03 15:00:00	MSFT	Stock	30.94	30.98	30.85	30.86	10178338.0
2010-05-03 16:00:00	MSFT	Stock	30.86	30.938	30.54	30.84	4688598.0
2010-05-03 17:00:00	MSFT	Stock	30.86	30.86	30.82	30.82	6617.0
2010-05-03 18:00:00	MSFT	Stock	30.87	30.87	30.87	30.87	500.0
2010-05-03 19:00:00	MSFT	Stock	30.82	30.82	30.82	30.82	118.0
2010-05-03 08:00:00	NVDA	Stock	0.393	0.402	0.393	0.3973	522640.0
2010-05-03 09:00:00	NVDA	Stock	0.3962	0.397	0.389	0.3908	102704680.0
2010-05-03 10:00:00	NVDA	Stock	0.3908	0.391	0.3828	0.3836	240597920.0
2010-05-03 11:00:00	NVDA	Stock	0.384	0.3893	0.3825	0.389	138994840.0
2010-05-03 12:00:00	NVDA	Stock	0.389	0.3935	0.388	0.3933	113344280.0
2010-05-03 13:00:00	NVDA	Stock	0.3934	0.394	0.3905	0.392	84832560.0
2010-05-03 14:00:00	NVDA	Stock	0.392	0.392	0.3888	0.3898	123282720.0
2010-05-03 15:00:00	NVDA	Stock	0.3896	0.3902	0.3873	0.3885	254016000.0
2010-05-03 16:00:00	NVDA	Stock	0.3885	0.39	0.3873	0.3873	19936960.0
2010-05-03 17:00:00	NVDA	Stock	0.3885	0.389	0.3875	0.389	105200.0
2010-05-03 18:00:00	NVDA	Stock	0.3893	0.3893	0.389	0.389	28000.0
2010-05-03 19:00:00	NVDA	Stock	0.3885	0.3885	0.3875	0.3875	88000.0
2010-05-03 08:00:00	AMZN	Stock	6.919	6.919	6.9005	6.915	369600.0
2010-05-03 09:00:00	AMZN	Stock	6.915	6.915	6.8055	6.8445	16390580.0
2010-05-03 10:00:00	AMZN	Stock	6.8475	6.8985	6.825	6.8452	20424580.0
2010-05-03 11:00:00	AMZN	Stock	6.8445	6.909	6.828	6.898	13085060.0
2010-05-03 12:00:00	AMZN	Stock	6.9015	6.972	6.898	6.9685	15297020.0
2010-05-03 13:00:00	AMZN	Stock	6.9705	6.9705	6.922	6.9355	9041380.0
2010-05-03 14:00:00	AMZN	Stock	6.939	6.94	6.9045	6.9122	11649100.0
2010-05-03 15:00:00	AMZN	Stock	6.912	6.9164	6.8505	6.874	23512940.0
2010-05-03 16:00:00	AMZN	Stock	6.872	6.89	6.853	6.855	1486460.0
2010-05-03 17:00:00	AMZN	Stock	6.8745	6.8805	6.87	6.87	34340.0

> showing 50 of 45,317 rows — these rows as CSV

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