PREVIEW / stock_1hour / 2013-09-19

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-09-19.parquet
  size:    1021 KB
  rows:    47,078
  symbols: 3,525

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
2013-09-19 04:00:00	AAPL	Stock	16.7543	16.7543	16.6625	16.6793	210588.0
2013-09-19 05:00:00	AAPL	Stock	16.6964	16.7286	16.6964	16.7286	50400.0
2013-09-19 06:00:00	AAPL	Stock	16.7286	16.7286	16.6804	16.7071	106120.0
2013-09-19 07:00:00	AAPL	Stock	16.7107	16.7621	16.7054	16.75	860188.0
2013-09-19 08:00:00	AAPL	Stock	16.75	16.8246	16.7143	16.8	4267340.0
2013-09-19 09:00:00	AAPL	Stock	16.7993	16.9071	16.7589	16.9	85705788.0
2013-09-19 10:00:00	AAPL	Stock	16.9	16.9596	16.8661	16.9071	75689880.0
2013-09-19 11:00:00	AAPL	Stock	16.9071	16.9157	16.8821	16.8914	31773616.0
2013-09-19 12:00:00	AAPL	Stock	16.8936	16.9939	16.8886	16.963	43345456.0
2013-09-19 13:00:00	AAPL	Stock	16.9629	16.9721	16.9071	16.9254	30451736.0
2013-09-19 14:00:00	AAPL	Stock	16.9246	16.9668	16.9196	16.9618	23982056.0
2013-09-19 15:00:00	AAPL	Stock	16.9604	16.9729	16.8407	16.8679	81856460.0
2013-09-19 16:00:00	AAPL	Stock	16.8741	16.9607	16.6169	16.8107	20336904.0
2013-09-19 17:00:00	AAPL	Stock	16.8204	16.8679	16.8036	16.8193	619780.0
2013-09-19 18:00:00	AAPL	Stock	16.8214	16.8243	16.8018	16.8204	130004.0
2013-09-19 19:00:00	AAPL	Stock	16.8179	16.8211	16.775	16.7857	738136.0
2013-09-19 06:00:00	MSFT	Stock	33.53	33.54	33.43	33.5	2400.0
2013-09-19 07:00:00	MSFT	Stock	33.5	33.5	33.4	33.4	3478.0
2013-09-19 08:00:00	MSFT	Stock	33.4	33.45	33.33	33.44	29151.0
2013-09-19 09:00:00	MSFT	Stock	33.43	33.68	33.42	33.64	6829411.0
2013-09-19 10:00:00	MSFT	Stock	33.65	33.65	33.41	33.5	5221225.0
2013-09-19 11:00:00	MSFT	Stock	33.5	33.53	33.415	33.5	3715422.0
2013-09-19 12:00:00	MSFT	Stock	33.5	33.54	33.47	33.49	2192644.0
2013-09-19 13:00:00	MSFT	Stock	33.49	33.53	33.33	33.33	3249723.0
2013-09-19 14:00:00	MSFT	Stock	33.33	33.53	33.32	33.53	3263536.0
2013-09-19 15:00:00	MSFT	Stock	33.53	33.68	33.49	33.63	9710975.0
2013-09-19 16:00:00	MSFT	Stock	33.63	33.8	33.44	33.66	7355894.0
2013-09-19 17:00:00	MSFT	Stock	33.65	33.67	33.63	33.63	36169.0
2013-09-19 18:00:00	MSFT	Stock	33.64	33.64	33.45	33.45	10461.0
2013-09-19 19:00:00	MSFT	Stock	33.62	33.63	33.62	33.63	300.0
2013-09-19 09:00:00	NVDA	Stock	0.4018	0.4025	0.3993	0.4013	23453400.0
2013-09-19 10:00:00	NVDA	Stock	0.4013	0.4016	0.3993	0.3998	55221480.0
2013-09-19 11:00:00	NVDA	Stock	0.4	0.4005	0.3985	0.399	32524000.0
2013-09-19 12:00:00	NVDA	Stock	0.3993	0.3993	0.3975	0.398	14951560.0
2013-09-19 13:00:00	NVDA	Stock	0.398	0.3985	0.3968	0.3975	16541160.0
2013-09-19 14:00:00	NVDA	Stock	0.3975	0.398	0.3965	0.398	29864640.0
2013-09-19 15:00:00	NVDA	Stock	0.398	0.3988	0.3973	0.3982	46735240.0
2013-09-19 16:00:00	NVDA	Stock	0.3982	0.3995	0.3978	0.3978	8171640.0
2013-09-19 05:00:00	AMZN	Stock	15.7	15.7	15.7	15.7	4000.0
2013-09-19 06:00:00	AMZN	Stock	15.7135	15.7135	15.69	15.69	6000.0
2013-09-19 07:00:00	AMZN	Stock	15.678	15.678	15.678	15.678	2000.0
2013-09-19 08:00:00	AMZN	Stock	15.667	15.7	15.605	15.6135	81340.0
2013-09-19 09:00:00	AMZN	Stock	15.605	15.727	15.6025	15.6298	10027160.0
2013-09-19 10:00:00	AMZN	Stock	15.6298	15.665	15.552	15.6235	8070400.0
2013-09-19 11:00:00	AMZN	Stock	15.61	15.655	15.566	15.59	4159240.0
2013-09-19 12:00:00	AMZN	Stock	15.5915	15.7	15.589	15.6615	4344080.0
2013-09-19 13:00:00	AMZN	Stock	15.6545	15.6825	15.572	15.573	3283140.0
2013-09-19 14:00:00	AMZN	Stock	15.579	15.6255	15.568	15.5935	3230560.0
2013-09-19 15:00:00	AMZN	Stock	15.595	15.6575	15.5944	15.611	7914140.0
2013-09-19 16:00:00	AMZN	Stock	15.603	15.6309	15.6025	15.6025	2119620.0

> showing 50 of 47,078 rows — these rows as CSV

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