PREVIEW / stock_1hour / 2009-08-26

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-08-26.parquet
  size:    861 KB
  rows:    41,611
  symbols: 3,367

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
2009-08-26 04:00:00	AAPL	Stock	6.0696	6.0696	6.0696	6.0696	2800.0
2009-08-26 06:00:00	AAPL	Stock	6.0536	6.0536	6.0536	6.0536	2800.0
2009-08-26 07:00:00	AAPL	Stock	6.0375	6.0529	6.0346	6.0504	117460.0
2009-08-26 08:00:00	AAPL	Stock	6.0375	6.0514	6.0375	6.0482	428092.0
2009-08-26 09:00:00	AAPL	Stock	6.0482	6.0554	6.0232	6.0354	32501952.0
2009-08-26 10:00:00	AAPL	Stock	6.0343	6.05	6.0143	6.0211	55583976.0
2009-08-26 11:00:00	AAPL	Stock	6.0204	6.0239	5.9643	5.9668	54579084.0
2009-08-26 12:00:00	AAPL	Stock	5.9668	5.9814	5.9589	5.9696	27264412.0
2009-08-26 13:00:00	AAPL	Stock	5.9696	5.9946	5.9557	5.9939	29364244.0
2009-08-26 14:00:00	AAPL	Stock	5.9943	6.0036	5.9825	5.9857	33802356.0
2009-08-26 15:00:00	AAPL	Stock	5.9854	5.9904	5.9704	5.9789	50731436.0
2009-08-26 16:00:00	AAPL	Stock	5.9793	6.0375	5.9771	5.9896	13793528.0
2009-08-26 17:00:00	AAPL	Stock	5.9824	5.9893	5.9793	5.9804	107324.0
2009-08-26 18:00:00	AAPL	Stock	5.9821	5.9821	5.9725	5.9725	260624.0
2009-08-26 19:00:00	AAPL	Stock	5.9782	5.9789	5.9607	5.9607	437836.0
2009-08-26 08:00:00	MSFT	Stock	24.55	24.65	24.55	24.6	1004400.0
2009-08-26 09:00:00	MSFT	Stock	24.6	24.64	24.47	24.58	5341212.0
2009-08-26 10:00:00	MSFT	Stock	24.58	24.75	24.55	24.56	7147805.0
2009-08-26 11:00:00	MSFT	Stock	24.57	24.58	24.47	24.5	5520832.0
2009-08-26 12:00:00	MSFT	Stock	24.5	24.642	24.48	24.52	2677751.0
2009-08-26 13:00:00	MSFT	Stock	24.51	24.58	24.48	24.58	3388219.0
2009-08-26 14:00:00	MSFT	Stock	24.58	24.59	24.42	24.44	3753256.0
2009-08-26 15:00:00	MSFT	Stock	24.44	24.55	24.42	24.54	8028652.0
2009-08-26 16:00:00	MSFT	Stock	24.55	24.55	24.4	24.53	3715445.0
2009-08-26 17:00:00	MSFT	Stock	24.53	24.53	24.49	24.5	3356.0
2009-08-26 18:00:00	MSFT	Stock	24.47	24.55	24.45	24.48	14014.0
2009-08-26 19:00:00	MSFT	Stock	24.45	24.5	24.45	24.46	1990.0
2009-08-26 08:00:00	NVDA	Stock	0.3418	0.342	0.3418	0.342	40000.0
2009-08-26 09:00:00	NVDA	Stock	0.3433	0.3448	0.3395	0.3435	49230480.0
2009-08-26 10:00:00	NVDA	Stock	0.3435	0.3458	0.3415	0.343	119035680.0
2009-08-26 11:00:00	NVDA	Stock	0.3433	0.344	0.3402	0.3418	68772080.0
2009-08-26 12:00:00	NVDA	Stock	0.342	0.3428	0.3405	0.3415	26035160.0
2009-08-26 13:00:00	NVDA	Stock	0.3418	0.3435	0.3408	0.3435	17227360.0
2009-08-26 14:00:00	NVDA	Stock	0.3433	0.3455	0.3425	0.3442	43373760.0
2009-08-26 15:00:00	NVDA	Stock	0.3442	0.3462	0.3438	0.3455	94374560.0
2009-08-26 16:00:00	NVDA	Stock	0.3455	0.3455	0.3432	0.3455	14222600.0
2009-08-26 19:00:00	NVDA	Stock	0.3448	0.345	0.3448	0.345	16000.0
2009-08-26 08:00:00	AMZN	Stock	4.2125	4.2125	4.2025	4.2025	14560.0
2009-08-26 09:00:00	AMZN	Stock	4.2	4.215	4.169	4.1815	10324800.0
2009-08-26 10:00:00	AMZN	Stock	4.1802	4.238	4.1802	4.2105	15354840.0
2009-08-26 11:00:00	AMZN	Stock	4.2105	4.213	4.169	4.1815	9012260.0
2009-08-26 12:00:00	AMZN	Stock	4.182	4.1945	4.169	4.1915	7387840.0
2009-08-26 13:00:00	AMZN	Stock	4.1915	4.2115	4.1705	4.2115	7151780.0
2009-08-26 14:00:00	AMZN	Stock	4.212	4.2125	4.187	4.19	7501920.0
2009-08-26 15:00:00	AMZN	Stock	4.19	4.2055	4.182	4.1995	11481160.0
2009-08-26 16:00:00	AMZN	Stock	4.197	4.2015	4.1904	4.2	3614660.0
2009-08-26 18:00:00	AMZN	Stock	4.2	4.2	4.2	4.2	3700.0
2009-08-26 08:00:00	TLT	Stock	95.65	96.07	95.65	96.07	4800.0
2009-08-26 09:00:00	TLT	Stock	96.01	96.38	95.99	96.25	384840.0
2009-08-26 10:00:00	TLT	Stock	96.25	96.38	95.91	96.05	527640.0

> showing 50 of 41,611 rows — these rows as CSV

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