PREVIEW / stock_1hour / 2010-02-08

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-02-08.parquet
  size:    887 KB
  rows:    42,810
  symbols: 3,408

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-08 05:00:00	AAPL	Stock	6.9789	6.9789	6.9789	6.9789	5040.0
2010-02-08 07:00:00	AAPL	Stock	6.9782	6.9882	6.9311	6.9882	163016.0
2010-02-08 08:00:00	AAPL	Stock	6.9754	6.9993	6.9575	6.9714	1593088.0
2010-02-08 09:00:00	AAPL	Stock	6.9711	7.0429	6.9629	7.0111	87850840.0
2010-02-08 10:00:00	AAPL	Stock	7.0139	7.0493	7.0	7.0332	80251640.0
2010-02-08 11:00:00	AAPL	Stock	7.0325	7.0671	7.0257	7.035	56471660.0
2010-02-08 12:00:00	AAPL	Stock	7.0374	7.0461	7.0193	7.0314	32405296.0
2010-02-08 13:00:00	AAPL	Stock	7.0321	7.0371	6.975	6.9968	53487476.0
2010-02-08 14:00:00	AAPL	Stock	6.9961	7.0179	6.9861	6.9986	35556248.0
2010-02-08 15:00:00	AAPL	Stock	6.9986	7.0043	6.9286	6.9289	86762116.0
2010-02-08 16:00:00	AAPL	Stock	6.93	7.0127	6.9254	6.935	29139796.0
2010-02-08 17:00:00	AAPL	Stock	7.0314	7.0314	6.9161	6.9189	855960.0
2010-02-08 18:00:00	AAPL	Stock	6.9232	6.9329	6.92	6.9232	311948.0
2010-02-08 19:00:00	AAPL	Stock	6.925	6.9279	6.8936	6.8964	1176084.0
2010-02-08 07:00:00	MSFT	Stock	27.82	27.95	27.78	27.95	7500.0
2010-02-08 08:00:00	MSFT	Stock	27.95	28.03	27.95	27.98	17593.0
2010-02-08 09:00:00	MSFT	Stock	27.98	28.02	27.57	27.85	6919961.0
2010-02-08 10:00:00	MSFT	Stock	27.85	28.0	27.8	27.86	7480333.0
2010-02-08 11:00:00	MSFT	Stock	27.851	28.08	27.851	28.038	6729624.0
2010-02-08 12:00:00	MSFT	Stock	28.04	28.07	27.92	27.94	4747439.0
2010-02-08 13:00:00	MSFT	Stock	27.94	27.95	27.75	27.84	5482742.0
2010-02-08 14:00:00	MSFT	Stock	27.835	27.92	27.82	27.87	4344323.0
2010-02-08 15:00:00	MSFT	Stock	27.865	27.89	27.66	27.72	11873739.0
2010-02-08 16:00:00	MSFT	Stock	27.72	27.96	27.57	27.78	3728074.0
2010-02-08 17:00:00	MSFT	Stock	28.02	28.02	27.6	27.61	394185.0
2010-02-08 18:00:00	MSFT	Stock	27.65	27.73	27.65	27.73	4904.0
2010-02-08 19:00:00	MSFT	Stock	27.73	27.75	27.72	27.75	2203.0
2010-02-08 08:00:00	NVDA	Stock	0.4005	0.4055	0.4003	0.4055	104000.0
2010-02-08 09:00:00	NVDA	Stock	0.4058	0.4065	0.3968	0.402	63241080.0
2010-02-08 10:00:00	NVDA	Stock	0.4022	0.4105	0.4018	0.41	82485800.0
2010-02-08 11:00:00	NVDA	Stock	0.41	0.4145	0.41	0.4111	63653520.0
2010-02-08 12:00:00	NVDA	Stock	0.4114	0.4142	0.41	0.414	49331240.0
2010-02-08 13:00:00	NVDA	Stock	0.414	0.4142	0.4078	0.409	39034600.0
2010-02-08 14:00:00	NVDA	Stock	0.4093	0.4112	0.4072	0.4078	38101040.0
2010-02-08 15:00:00	NVDA	Stock	0.408	0.4082	0.4043	0.4048	96659880.0
2010-02-08 16:00:00	NVDA	Stock	0.4048	0.4077	0.4035	0.4076	11265840.0
2010-02-08 17:00:00	NVDA	Stock	0.413	0.413	0.4048	0.4075	228000.0
2010-02-08 18:00:00	NVDA	Stock	0.4048	0.4048	0.4048	0.4048	516400.0
2010-02-08 19:00:00	NVDA	Stock	0.4043	0.4043	0.4043	0.4043	8000.0
2010-02-08 07:00:00	AMZN	Stock	5.92	5.937	5.9	5.935	58920.0
2010-02-08 08:00:00	AMZN	Stock	5.93	5.95	5.8695	5.9495	522100.0
2010-02-08 09:00:00	AMZN	Stock	5.9475	6.05	5.94	5.99	42166660.0
2010-02-08 10:00:00	AMZN	Stock	5.9925	6.0085	5.9175	5.961	38548980.0
2010-02-08 11:00:00	AMZN	Stock	5.9616	5.986	5.9205	5.949	26095680.0
2010-02-08 12:00:00	AMZN	Stock	5.95	5.9665	5.9345	5.942	11039380.0
2010-02-08 13:00:00	AMZN	Stock	5.943	5.95	5.8785	5.9016	20063740.0
2010-02-08 14:00:00	AMZN	Stock	5.9005	5.9225	5.8585	5.863	18436460.0
2010-02-08 15:00:00	AMZN	Stock	5.8645	5.8695	5.828	5.839	32543480.0
2010-02-08 16:00:00	AMZN	Stock	5.8415	5.9356	5.832	5.846	908120.0
2010-02-08 17:00:00	AMZN	Stock	5.8425	5.8425	5.828	5.835	307120.0

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

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