PREVIEW / stock_1hour / 2010-05-11

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-05-11.parquet
  size:    929 KB
  rows:    44,387
  symbols: 3,484

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-11 04:00:00	AAPL	Stock	9.0536	9.0536	8.9807	8.9807	27440.0
2010-05-11 05:00:00	AAPL	Stock	8.9493	8.9493	8.9293	8.9293	50120.0
2010-05-11 06:00:00	AAPL	Stock	8.9379	8.9793	8.9379	8.9793	26180.0
2010-05-11 07:00:00	AAPL	Stock	8.9443	8.9893	8.9321	8.9736	767508.0
2010-05-11 08:00:00	AAPL	Stock	8.9746	9.0071	8.9446	8.9554	4680816.0
2010-05-11 09:00:00	AAPL	Stock	8.9514	9.0493	8.94	9.0091	115711988.0
2010-05-11 10:00:00	AAPL	Stock	9.0089	9.0807	8.9746	9.0571	105011144.0
2010-05-11 11:00:00	AAPL	Stock	9.0583	9.2286	9.0568	9.2111	155972348.0
2010-05-11 12:00:00	AAPL	Stock	9.2104	9.2807	9.2039	9.2675	104924848.0
2010-05-11 13:00:00	AAPL	Stock	9.2675	9.2818	9.2421	9.2739	72858380.0
2010-05-11 14:00:00	AAPL	Stock	9.274	9.2818	9.1543	9.18	132339312.0
2010-05-11 15:00:00	AAPL	Stock	9.18	9.2107	9.1204	9.1632	133279328.0
2010-05-11 16:00:00	AAPL	Stock	9.1557	9.2132	9.135	9.135	10525620.0
2010-05-11 17:00:00	AAPL	Stock	9.1375	9.1554	9.0677	9.1521	1256500.0
2010-05-11 18:00:00	AAPL	Stock	9.1521	9.1614	9.0993	9.1093	1122632.0
2010-05-11 19:00:00	AAPL	Stock	9.1125	9.1229	9.1075	9.1164	523012.0
2010-05-11 04:00:00	MSFT	Stock	28.88	28.88	28.88	28.88	200.0
2010-05-11 06:00:00	MSFT	Stock	28.63	28.63	28.63	28.63	1000.0
2010-05-11 07:00:00	MSFT	Stock	28.6	28.8	28.6	28.79	8013.0
2010-05-11 08:00:00	MSFT	Stock	28.71	28.79	28.63	28.69	7337.0
2010-05-11 09:00:00	MSFT	Stock	28.69	28.97	28.57	28.93	6359794.0
2010-05-11 10:00:00	MSFT	Stock	28.93	29.65	28.75	29.005	8773194.0
2010-05-11 11:00:00	MSFT	Stock	29.01	29.21	28.95	29.104	12038647.0
2010-05-11 12:00:00	MSFT	Stock	29.11	29.41	29.08	29.364	5401071.0
2010-05-11 13:00:00	MSFT	Stock	29.366	29.45	29.23	29.27	6224715.0
2010-05-11 14:00:00	MSFT	Stock	29.272	29.35	29.02	29.098	7786937.0
2010-05-11 15:00:00	MSFT	Stock	29.1	29.11	28.87	28.87	13611386.0
2010-05-11 16:00:00	MSFT	Stock	28.87	29.15	28.82	28.85	2360156.0
2010-05-11 17:00:00	MSFT	Stock	29.025	29.194	28.77	28.77	84620.0
2010-05-11 18:00:00	MSFT	Stock	28.75	28.88	28.63	28.73	17115.0
2010-05-11 19:00:00	MSFT	Stock	28.73	28.73	28.7	28.73	7853.0
2010-05-11 07:00:00	NVDA	Stock	0.36	0.36	0.36	0.36	40000.0
2010-05-11 08:00:00	NVDA	Stock	0.36	0.36	0.3538	0.36	382640.0
2010-05-11 09:00:00	NVDA	Stock	0.3605	0.3635	0.3572	0.3602	104968720.0
2010-05-11 10:00:00	NVDA	Stock	0.3602	0.3638	0.3595	0.3608	117293160.0
2010-05-11 11:00:00	NVDA	Stock	0.3608	0.3648	0.3605	0.3648	124311160.0
2010-05-11 12:00:00	NVDA	Stock	0.3645	0.3672	0.3642	0.3655	108758800.0
2010-05-11 13:00:00	NVDA	Stock	0.3658	0.3668	0.364	0.3652	72853360.0
2010-05-11 14:00:00	NVDA	Stock	0.3652	0.3662	0.3605	0.361	85006760.0
2010-05-11 15:00:00	NVDA	Stock	0.361	0.3625	0.3582	0.3602	189032320.0
2010-05-11 16:00:00	NVDA	Stock	0.36	0.3626	0.3592	0.36	11588520.0
2010-05-11 17:00:00	NVDA	Stock	0.359	0.3602	0.359	0.3602	84320.0
2010-05-11 18:00:00	NVDA	Stock	0.3615	0.3615	0.359	0.359	153280.0
2010-05-11 19:00:00	NVDA	Stock	0.3595	0.3595	0.3588	0.3588	76360.0
2010-05-11 08:00:00	AMZN	Stock	6.52	6.52	6.4605	6.475	111600.0
2010-05-11 09:00:00	AMZN	Stock	6.473	6.5316	6.4295	6.452	14897300.0
2010-05-11 10:00:00	AMZN	Stock	6.4505	6.509	6.4235	6.4805	16670880.0
2010-05-11 11:00:00	AMZN	Stock	6.4845	6.5899	6.4793	6.5625	15989280.0
2010-05-11 12:00:00	AMZN	Stock	6.564	6.654	6.558	6.6305	17919320.0
2010-05-11 13:00:00	AMZN	Stock	6.63	6.644	6.573	6.573	14794220.0

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

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