PREVIEW / stock_1hour / 2010-01-12

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-01-12.parquet
  size:    910 KB
  rows:    43,435
  symbols: 3,447

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-12 04:00:00	AAPL	Stock	7.4768	7.4768	7.4557	7.4557	14000.0
2010-01-12 06:00:00	AAPL	Stock	7.4632	7.4632	7.4632	7.4632	2800.0
2010-01-12 07:00:00	AAPL	Stock	7.4325	7.46	7.4286	7.4582	45108.0
2010-01-12 08:00:00	AAPL	Stock	7.4589	7.4643	7.4375	7.4404	1758064.0
2010-01-12 09:00:00	AAPL	Stock	7.4379	7.4851	7.4079	7.4264	96375412.0
2010-01-12 10:00:00	AAPL	Stock	7.4264	7.4864	7.4196	7.4725	89533780.0
2010-01-12 11:00:00	AAPL	Stock	7.4725	7.4918	7.455	7.4671	54545904.0
2010-01-12 12:00:00	AAPL	Stock	7.4661	7.4693	7.4107	7.425	68349792.0
2010-01-12 13:00:00	AAPL	Stock	7.425	7.4389	7.4054	7.4318	51460220.0
2010-01-12 14:00:00	AAPL	Stock	7.4314	7.4321	7.3871	7.4068	61409656.0
2010-01-12 15:00:00	AAPL	Stock	7.4071	7.4196	7.3721	7.4189	98413728.0
2010-01-12 16:00:00	AAPL	Stock	7.4189	7.5039	7.4027	7.4229	9786280.0
2010-01-12 17:00:00	AAPL	Stock	7.4229	7.425	7.4186	7.4186	150724.0
2010-01-12 18:00:00	AAPL	Stock	7.4204	7.4218	7.3964	7.3971	854028.0
2010-01-12 19:00:00	AAPL	Stock	7.4	7.4186	7.3946	7.4175	335300.0
2010-01-12 06:00:00	MSFT	Stock	30.02	30.02	29.99	29.99	2300.0
2010-01-12 07:00:00	MSFT	Stock	29.98	30.06	29.97	30.05	1732.0
2010-01-12 08:00:00	MSFT	Stock	30.06	30.1	30.0	30.07	25242.0
2010-01-12 09:00:00	MSFT	Stock	30.07	30.22	29.93	30.15	8295972.0
2010-01-12 10:00:00	MSFT	Stock	30.16	30.4	30.12	30.36	8035585.0
2010-01-12 11:00:00	MSFT	Stock	30.365	30.395	30.15	30.17	5392321.0
2010-01-12 12:00:00	MSFT	Stock	30.17	30.18	30.0	30.01	7142514.0
2010-01-12 13:00:00	MSFT	Stock	30.005	30.09	29.91	30.03	8372823.0
2010-01-12 14:00:00	MSFT	Stock	30.04	30.11	30.0	30.085	6201120.0
2010-01-12 15:00:00	MSFT	Stock	30.09	30.13	30.01	30.1	15530523.0
2010-01-12 16:00:00	MSFT	Stock	30.07	30.27	30.007	30.11	5436843.0
2010-01-12 17:00:00	MSFT	Stock	30.09	30.09	30.07	30.07	6386.0
2010-01-12 18:00:00	MSFT	Stock	30.09	30.11	30.08	30.11	1360.0
2010-01-12 19:00:00	MSFT	Stock	30.14	30.14	30.11	30.11	1120.0
2010-01-12 08:00:00	NVDA	Stock	0.4555	0.4555	0.4525	0.4538	102760.0
2010-01-12 09:00:00	NVDA	Stock	0.4538	0.454	0.442	0.4455	93168800.0
2010-01-12 10:00:00	NVDA	Stock	0.4455	0.4458	0.4415	0.444	85605080.0
2010-01-12 11:00:00	NVDA	Stock	0.444	0.445	0.439	0.4397	55163600.0
2010-01-12 12:00:00	NVDA	Stock	0.4398	0.4398	0.4325	0.4338	83913440.0
2010-01-12 13:00:00	NVDA	Stock	0.4338	0.4378	0.4322	0.4372	57434480.0
2010-01-12 14:00:00	NVDA	Stock	0.4375	0.442	0.4372	0.4414	96569320.0
2010-01-12 15:00:00	NVDA	Stock	0.4412	0.4418	0.4398	0.4418	127398760.0
2010-01-12 16:00:00	NVDA	Stock	0.4418	0.4506	0.435	0.4408	19130720.0
2010-01-12 17:00:00	NVDA	Stock	0.4418	0.4418	0.4408	0.4418	237800.0
2010-01-12 18:00:00	NVDA	Stock	0.4405	0.4405	0.4385	0.4392	32000.0
2010-01-12 19:00:00	NVDA	Stock	0.4405	0.4405	0.438	0.438	30000.0
2010-01-12 08:00:00	AMZN	Stock	6.4645	6.4645	6.424	6.43	214920.0
2010-01-12 09:00:00	AMZN	Stock	6.43	6.491	6.371	6.4105	31567460.0
2010-01-12 10:00:00	AMZN	Stock	6.4105	6.4325	6.388	6.405	31637520.0
2010-01-12 11:00:00	AMZN	Stock	6.4058	6.4405	6.385	6.4385	18218440.0
2010-01-12 12:00:00	AMZN	Stock	6.4365	6.4425	6.38	6.38	19793160.0
2010-01-12 13:00:00	AMZN	Stock	6.3802	6.4035	6.35	6.3985	21772660.0
2010-01-12 14:00:00	AMZN	Stock	6.3985	6.4025	6.3525	6.386	16734180.0
2010-01-12 15:00:00	AMZN	Stock	6.3865	6.3865	6.3275	6.377	37263880.0
2010-01-12 16:00:00	AMZN	Stock	6.366	6.3904	6.353	6.37	2488500.0

> showing 50 of 43,435 rows — these rows as CSV

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