PREVIEW / stock_1hour / 2012-08-10

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-08-10.parquet
  size:    915 KB
  rows:    43,766
  symbols: 3,493

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
2012-08-10 06:00:00	AAPL	Stock	22.1321	22.1321	22.1321	22.1321	9380.0
2012-08-10 07:00:00	AAPL	Stock	22.1218	22.125	22.06	22.0893	221088.0
2012-08-10 08:00:00	AAPL	Stock	22.0907	22.1689	22.0582	22.1357	1384432.0
2012-08-10 09:00:00	AAPL	Stock	22.1364	22.1639	22.0921	22.1418	30806664.0
2012-08-10 10:00:00	AAPL	Stock	22.1429	22.2057	22.1393	22.1625	32512760.0
2012-08-10 11:00:00	AAPL	Stock	22.1657	22.1711	22.1286	22.1504	16857652.0
2012-08-10 12:00:00	AAPL	Stock	22.1504	22.1546	22.1271	22.1471	14871388.0
2012-08-10 13:00:00	AAPL	Stock	22.1511	22.1547	22.1286	22.1418	13275612.0
2012-08-10 14:00:00	AAPL	Stock	22.1425	22.2046	22.1386	22.1802	21269164.0
2012-08-10 15:00:00	AAPL	Stock	22.1802	22.2046	22.1711	22.2014	39435452.0
2012-08-10 16:00:00	AAPL	Stock	22.2014	22.2314	22.1458	22.2182	16568944.0
2012-08-10 17:00:00	AAPL	Stock	22.2196	22.2261	22.2179	22.2232	67480.0
2012-08-10 18:00:00	AAPL	Stock	22.2221	22.2221	22.2164	22.2207	21392.0
2012-08-10 19:00:00	AAPL	Stock	22.2207	22.2232	22.2189	22.2232	115276.0
2012-08-10 07:00:00	MSFT	Stock	30.4	30.4	30.4	30.4	100.0
2012-08-10 08:00:00	MSFT	Stock	30.43	30.44	30.41	30.44	2200.0
2012-08-10 09:00:00	MSFT	Stock	30.44	30.62	30.25	30.33	3627067.0
2012-08-10 10:00:00	MSFT	Stock	30.325	30.43	30.3	30.381	4328062.0
2012-08-10 11:00:00	MSFT	Stock	30.39	30.4	30.27	30.355	4169104.0
2012-08-10 12:00:00	MSFT	Stock	30.35	30.36	30.3	30.3	1731581.0
2012-08-10 13:00:00	MSFT	Stock	30.305	30.36	30.28	30.355	2021603.0
2012-08-10 14:00:00	MSFT	Stock	30.36	30.36	30.28	30.295	2118344.0
2012-08-10 15:00:00	MSFT	Stock	30.29	30.411	30.265	30.41	7814544.0
2012-08-10 16:00:00	MSFT	Stock	30.4	30.45	30.334	30.334	1717350.0
2012-08-10 17:00:00	MSFT	Stock	30.42	30.42	30.42	30.42	100.0
2012-08-10 18:00:00	MSFT	Stock	30.41	30.41	30.41	30.41	300.0
2012-08-10 19:00:00	MSFT	Stock	30.42	30.42	30.42	30.42	2874.0
2012-08-10 07:00:00	NVDA	Stock	0.382	0.386	0.382	0.384	1041000.0
2012-08-10 08:00:00	NVDA	Stock	0.384	0.3855	0.382	0.3822	10258960.0
2012-08-10 09:00:00	NVDA	Stock	0.382	0.3835	0.3645	0.3705	354217960.0
2012-08-10 10:00:00	NVDA	Stock	0.3705	0.3793	0.3655	0.3703	318814200.0
2012-08-10 11:00:00	NVDA	Stock	0.3705	0.3723	0.3635	0.364	188454720.0
2012-08-10 12:00:00	NVDA	Stock	0.364	0.3658	0.3608	0.3625	107402200.0
2012-08-10 13:00:00	NVDA	Stock	0.3625	0.3672	0.3614	0.3658	87638320.0
2012-08-10 14:00:00	NVDA	Stock	0.3655	0.3662	0.3645	0.3658	47005720.0
2012-08-10 15:00:00	NVDA	Stock	0.3658	0.3668	0.3642	0.3655	149135040.0
2012-08-10 16:00:00	NVDA	Stock	0.3655	0.3682	0.3645	0.3658	1124280.0
2012-08-10 17:00:00	NVDA	Stock	0.366	0.3662	0.365	0.3658	268880.0
2012-08-10 18:00:00	NVDA	Stock	0.365	0.365	0.365	0.365	28000.0
2012-08-10 19:00:00	NVDA	Stock	0.3652	0.3655	0.365	0.3655	100000.0
2012-08-10 08:00:00	AMZN	Stock	11.6945	11.6945	11.6605	11.6605	11000.0
2012-08-10 09:00:00	AMZN	Stock	11.661	11.7425	11.64	11.665	5153280.0
2012-08-10 10:00:00	AMZN	Stock	11.6665	11.7005	11.6545	11.672	5383520.0
2012-08-10 11:00:00	AMZN	Stock	11.6745	11.6785	11.65	11.655	3639460.0
2012-08-10 12:00:00	AMZN	Stock	11.655	11.657	11.5945	11.596	4540900.0
2012-08-10 13:00:00	AMZN	Stock	11.5955	11.6125	11.5715	11.604	4676680.0
2012-08-10 14:00:00	AMZN	Stock	11.604	11.611	11.5865	11.589	3082160.0
2012-08-10 15:00:00	AMZN	Stock	11.589	11.647	11.5845	11.6365	9026960.0
2012-08-10 16:00:00	AMZN	Stock	11.6365	11.64	11.5966	11.5966	1423440.0
2012-08-10 17:00:00	AMZN	Stock	11.64	11.64	11.64	11.64	2000.0

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

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