PREVIEW / stock_1hour / 2010-08-12

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-08-12.parquet
  size:    913 KB
  rows:    44,690
  symbols: 3,466

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-08-12 05:00:00	AAPL	Stock	8.8161	8.8357	8.8161	8.8211	70000.0
2010-08-12 06:00:00	AAPL	Stock	8.8375	8.8879	8.8143	8.8732	84700.0
2010-08-12 07:00:00	AAPL	Stock	8.8732	8.8929	8.8571	8.8643	182812.0
2010-08-12 08:00:00	AAPL	Stock	8.8661	8.9	8.8164	8.8286	5986344.0
2010-08-12 09:00:00	AAPL	Stock	8.8304	8.9278	8.79	8.9125	112619612.0
2010-08-12 10:00:00	AAPL	Stock	8.9127	9.0343	8.9079	9.0143	139186404.0
2010-08-12 11:00:00	AAPL	Stock	9.0144	9.0393	8.9871	9.0014	63577472.0
2010-08-12 12:00:00	AAPL	Stock	9.0025	9.0207	8.9864	9.0168	36015056.0
2010-08-12 13:00:00	AAPL	Stock	9.0175	9.0286	8.9482	8.9618	43965152.0
2010-08-12 14:00:00	AAPL	Stock	8.9614	8.9929	8.9446	8.9793	43626072.0
2010-08-12 15:00:00	AAPL	Stock	8.9793	9.015	8.9661	8.9925	72350404.0
2010-08-12 16:00:00	AAPL	Stock	8.9907	9.0096	8.8048	8.9946	8850856.0
2010-08-12 17:00:00	AAPL	Stock	8.9311	9.0089	8.9311	9.0086	152600.0
2010-08-12 18:00:00	AAPL	Stock	9.0054	9.0118	8.9925	9.0118	140112.0
2010-08-12 19:00:00	AAPL	Stock	9.0107	9.0232	9.0107	9.0225	467824.0
2010-08-12 07:00:00	MSFT	Stock	24.68	24.68	24.68	24.68	200.0
2010-08-12 08:00:00	MSFT	Stock	24.66	24.66	24.5	24.53	24069.0
2010-08-12 09:00:00	MSFT	Stock	24.51	24.86	24.36	24.61	8689064.0
2010-08-12 10:00:00	MSFT	Stock	24.61	24.62	24.4	24.505	11032161.0
2010-08-12 11:00:00	MSFT	Stock	24.493	24.56	24.431	24.5	7833738.0
2010-08-12 12:00:00	MSFT	Stock	24.5	24.58	24.45	24.56	4674327.0
2010-08-12 13:00:00	MSFT	Stock	24.56	24.57	24.39	24.456	10458729.0
2010-08-12 14:00:00	MSFT	Stock	24.458	24.51	24.44	24.482	9288771.0
2010-08-12 15:00:00	MSFT	Stock	24.48	24.56	24.47	24.51	13924535.0
2010-08-12 16:00:00	MSFT	Stock	24.49	24.55	24.46	24.52	2227338.0
2010-08-12 17:00:00	MSFT	Stock	24.58	24.58	24.5	24.55	35232.0
2010-08-12 18:00:00	MSFT	Stock	24.57	24.58	24.49	24.53	15984.0
2010-08-12 19:00:00	MSFT	Stock	24.53	24.57	24.52	24.52	6851.0
2010-08-12 07:00:00	NVDA	Stock	0.2243	0.2243	0.2243	0.2243	40000.0
2010-08-12 08:00:00	NVDA	Stock	0.219	0.2238	0.2175	0.2175	397520.0
2010-08-12 09:00:00	NVDA	Stock	0.2175	0.2223	0.2163	0.2219	98735920.0
2010-08-12 10:00:00	NVDA	Stock	0.222	0.2255	0.2203	0.2252	156583160.0
2010-08-12 11:00:00	NVDA	Stock	0.225	0.2275	0.2223	0.2275	158697720.0
2010-08-12 12:00:00	NVDA	Stock	0.2275	0.2275	0.2258	0.2265	61051360.0
2010-08-12 13:00:00	NVDA	Stock	0.2265	0.229	0.2258	0.2285	198741200.0
2010-08-12 14:00:00	NVDA	Stock	0.2286	0.2288	0.224	0.225	158411480.0
2010-08-12 15:00:00	NVDA	Stock	0.2251	0.2272	0.2232	0.224	296187360.0
2010-08-12 16:00:00	NVDA	Stock	0.2243	0.2415	0.2	0.2378	141222240.0
2010-08-12 17:00:00	NVDA	Stock	0.2378	0.2388	0.232	0.2325	27819560.0
2010-08-12 18:00:00	NVDA	Stock	0.2322	0.2332	0.224	0.226	23492840.0
2010-08-12 19:00:00	NVDA	Stock	0.226	0.2263	0.2243	0.225	4976200.0
2010-08-12 20:00:00	NVDA	Stock	0.2225	0.2225	0.2225	0.2225	2740000.0
2010-08-12 07:00:00	AMZN	Stock	6.241	6.241	6.241	6.241	2000.0
2010-08-12 08:00:00	AMZN	Stock	6.2485	6.2485	6.1875	6.2055	254820.0
2010-08-12 09:00:00	AMZN	Stock	6.206	6.311	6.1775	6.2915	14872080.0
2010-08-12 10:00:00	AMZN	Stock	6.291	6.343	6.2777	6.299	16889320.0
2010-08-12 11:00:00	AMZN	Stock	6.299	6.3235	6.29	6.2905	8286920.0
2010-08-12 12:00:00	AMZN	Stock	6.2923	6.318	6.2755	6.3095	5596920.0
2010-08-12 13:00:00	AMZN	Stock	6.3105	6.32	6.2525	6.264	8101700.0
2010-08-12 14:00:00	AMZN	Stock	6.264	6.2938	6.248	6.2885	7967300.0

> showing 50 of 44,690 rows — these rows as CSV

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