PREVIEW / stock_1hour / 2011-01-25

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-01-25.parquet
  size:    937 KB
  rows:    44,361
  symbols: 3,528

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
2011-01-25 05:00:00	AAPL	Stock	12.04	12.0446	12.04	12.0446	8400.0
2011-01-25 06:00:00	AAPL	Stock	12.0518	12.0568	12.0429	12.0568	8400.0
2011-01-25 07:00:00	AAPL	Stock	12.0625	12.0714	12.0232	12.0304	337176.0
2011-01-25 08:00:00	AAPL	Stock	12.0286	12.0479	11.9839	12.0014	1936144.0
2011-01-25 09:00:00	AAPL	Stock	12.0011	12.0821	11.9489	12.0818	101017924.0
2011-01-25 10:00:00	AAPL	Stock	12.0818	12.1564	12.0532	12.1507	106743028.0
2011-01-25 11:00:00	AAPL	Stock	12.1493	12.1604	12.0743	12.0989	77763140.0
2011-01-25 12:00:00	AAPL	Stock	12.0986	12.175	12.0986	12.1517	53094048.0
2011-01-25 13:00:00	AAPL	Stock	12.1507	12.1518	12.1121	12.1255	32849544.0
2011-01-25 14:00:00	AAPL	Stock	12.1254	12.1307	12.0679	12.1089	56381192.0
2011-01-25 15:00:00	AAPL	Stock	12.1086	12.1943	12.0982	12.1929	101681832.0
2011-01-25 16:00:00	AAPL	Stock	12.1911	12.2054	12.1019	12.1957	2240420.0
2011-01-25 17:00:00	AAPL	Stock	12.1946	12.2071	12.1946	12.2071	342552.0
2011-01-25 18:00:00	AAPL	Stock	12.2018	12.2082	12.1929	12.205	2374428.0
2011-01-25 19:00:00	AAPL	Stock	12.2036	12.2054	12.1929	12.2	302512.0
2011-01-25 07:00:00	MSFT	Stock	28.38	28.38	28.37	28.38	500.0
2011-01-25 08:00:00	MSFT	Stock	28.38	28.38	28.18	28.2	37902.0
2011-01-25 09:00:00	MSFT	Stock	28.24	28.36	28.12	28.32	4429269.0
2011-01-25 10:00:00	MSFT	Stock	28.31	28.4	28.21	28.35	7134628.0
2011-01-25 11:00:00	MSFT	Stock	28.34	28.36	28.18	28.291	5500312.0
2011-01-25 12:00:00	MSFT	Stock	28.29	28.422	28.29	28.4	4221030.0
2011-01-25 13:00:00	MSFT	Stock	28.395	28.42	28.28	28.35	3797992.0
2011-01-25 14:00:00	MSFT	Stock	28.36	28.36	28.19	28.29	4809487.0
2011-01-25 15:00:00	MSFT	Stock	28.29	28.45	28.28	28.45	7612291.0
2011-01-25 16:00:00	MSFT	Stock	28.45	28.45	28.312	28.39	1472944.0
2011-01-25 17:00:00	MSFT	Stock	28.37	28.38	28.36	28.38	300.0
2011-01-25 18:00:00	MSFT	Stock	28.41	28.55	28.41	28.48	28157.0
2011-01-25 19:00:00	MSFT	Stock	28.48	28.53	28.41	28.41	1100.0
2011-01-25 07:00:00	NVDA	Stock	0.6188	0.6188	0.6153	0.6153	235960.0
2011-01-25 08:00:00	NVDA	Stock	0.6185	0.6185	0.6088	0.615	2960400.0
2011-01-25 09:00:00	NVDA	Stock	0.6135	0.622	0.6028	0.6063	228698040.0
2011-01-25 10:00:00	NVDA	Stock	0.6065	0.6085	0.6018	0.606	217940800.0
2011-01-25 11:00:00	NVDA	Stock	0.606	0.6062	0.598	0.6005	157078200.0
2011-01-25 12:00:00	NVDA	Stock	0.6005	0.605	0.6003	0.6026	84861400.0
2011-01-25 13:00:00	NVDA	Stock	0.6025	0.6048	0.601	0.6018	57008040.0
2011-01-25 14:00:00	NVDA	Stock	0.6015	0.6015	0.5955	0.5965	131054760.0
2011-01-25 15:00:00	NVDA	Stock	0.5965	0.5998	0.5952	0.599	182706040.0
2011-01-25 16:00:00	NVDA	Stock	0.5992	0.6038	0.5955	0.5992	17312440.0
2011-01-25 17:00:00	NVDA	Stock	0.6023	0.6023	0.5995	0.6	429400.0
2011-01-25 18:00:00	NVDA	Stock	0.6	0.6008	0.6	0.6008	134800.0
2011-01-25 19:00:00	NVDA	Stock	0.6015	0.605	0.6005	0.6045	831640.0
2011-01-25 07:00:00	AMZN	Stock	8.826	8.826	8.825	8.825	24000.0
2011-01-25 08:00:00	AMZN	Stock	8.8	8.8	8.76	8.775	71140.0
2011-01-25 09:00:00	AMZN	Stock	8.777	8.834	8.7275	8.8115	14625540.0
2011-01-25 10:00:00	AMZN	Stock	8.8115	8.8375	8.731	8.8215	20500900.0
2011-01-25 11:00:00	AMZN	Stock	8.8185	8.8235	8.715	8.7332	11344100.0
2011-01-25 12:00:00	AMZN	Stock	8.7325	8.806	8.732	8.7975	7245600.0
2011-01-25 13:00:00	AMZN	Stock	8.7975	8.7975	8.7505	8.7655	4486940.0
2011-01-25 14:00:00	AMZN	Stock	8.7635	8.766	8.714	8.742	11044780.0
2011-01-25 15:00:00	AMZN	Stock	8.7405	8.835	8.7385	8.8345	19306080.0

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

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