PREVIEW / stock_1hour / 2015-02-26

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-02-26.parquet
  size:    1.1 MB
  rows:    48,623
  symbols: 3,501

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
2015-02-26 04:00:00	AAPL	Stock	32.15	32.2425	32.15	32.2425	69312.0
2015-02-26 05:00:00	AAPL	Stock	32.225	32.3075	32.2125	32.305	14968.0
2015-02-26 06:00:00	AAPL	Stock	32.3025	32.345	32.275	32.3125	133852.0
2015-02-26 07:00:00	AAPL	Stock	32.3175	32.3425	32.305	32.3075	224504.0
2015-02-26 08:00:00	AAPL	Stock	32.3175	32.3725	32.175	32.24	1419348.0
2015-02-26 09:00:00	AAPL	Stock	32.25	32.28	31.665	31.7075	61844860.0
2015-02-26 10:00:00	AAPL	Stock	31.71	31.9575	31.6525	31.9225	51308132.0
2015-02-26 11:00:00	AAPL	Stock	31.9208	32.35	31.9185	32.3315	40473248.0
2015-02-26 12:00:00	AAPL	Stock	32.33	32.5175	32.2125	32.475	49277660.0
2015-02-26 13:00:00	AAPL	Stock	32.475	32.7175	32.4702	32.5825	44467772.0
2015-02-26 14:00:00	AAPL	Stock	32.585	32.615	32.225	32.41	41348844.0
2015-02-26 15:00:00	AAPL	Stock	32.41	32.6125	32.2975	32.6025	37454816.0
2015-02-26 16:00:00	AAPL	Stock	32.6038	32.6125	31.7618	32.5975	7761300.0
2015-02-26 17:00:00	AAPL	Stock	32.6	32.6	32.5925	32.5952	179152.0
2015-02-26 18:00:00	AAPL	Stock	32.5975	32.6125	32.5875	32.6125	190480.0
2015-02-26 19:00:00	AAPL	Stock	32.6075	32.6075	32.5525	32.5575	168088.0
2015-02-26 06:00:00	MSFT	Stock	43.9	43.9	43.9	43.9	200.0
2015-02-26 07:00:00	MSFT	Stock	44.03	44.03	43.9	43.97	4929.0
2015-02-26 08:00:00	MSFT	Stock	43.99	44.0	43.92	43.96	11305.0
2015-02-26 09:00:00	MSFT	Stock	44.01	44.23	43.91	44.159	4142915.0
2015-02-26 10:00:00	MSFT	Stock	44.16	44.18	44.02	44.1	3641303.0
2015-02-26 11:00:00	MSFT	Stock	44.1	44.18	44.04	44.04	2595127.0
2015-02-26 12:00:00	MSFT	Stock	44.04	44.08	43.94	44.03	2373812.0
2015-02-26 13:00:00	MSFT	Stock	44.03	44.06	43.92	43.95	2309654.0
2015-02-26 14:00:00	MSFT	Stock	43.96	43.99	43.92	43.96	2396712.0
2015-02-26 15:00:00	MSFT	Stock	43.95	44.07	43.89	44.05	4982694.0
2015-02-26 16:00:00	MSFT	Stock	44.05	44.075	43.99	44.0	3079484.0
2015-02-26 17:00:00	MSFT	Stock	44.0	44.0	44.0	44.0	3186.0
2015-02-26 18:00:00	MSFT	Stock	44.0	44.055	44.0	44.03	1214825.0
2015-02-26 19:00:00	MSFT	Stock	44.0	44.0	44.0	44.0	625.0
2015-02-26 07:00:00	NVDA	Stock	0.5545	0.5545	0.5538	0.5538	32000.0
2015-02-26 09:00:00	NVDA	Stock	0.5555	0.5566	0.5518	0.5548	22307880.0
2015-02-26 10:00:00	NVDA	Stock	0.5549	0.5581	0.5548	0.5572	19721440.0
2015-02-26 11:00:00	NVDA	Stock	0.5575	0.5578	0.5542	0.5542	15221640.0
2015-02-26 12:00:00	NVDA	Stock	0.5542	0.5542	0.5522	0.5528	9205520.0
2015-02-26 13:00:00	NVDA	Stock	0.5528	0.5534	0.5518	0.553	6157360.0
2015-02-26 14:00:00	NVDA	Stock	0.553	0.5534	0.5505	0.5532	18639320.0
2015-02-26 15:00:00	NVDA	Stock	0.5532	0.5552	0.552	0.555	43593160.0
2015-02-26 16:00:00	NVDA	Stock	0.555	0.555	0.5538	0.5542	9432160.0
2015-02-26 19:00:00	NVDA	Stock	0.5575	0.558	0.5575	0.558	28000.0
2015-02-26 07:00:00	AMZN	Stock	19.275	19.3	19.275	19.275	18000.0
2015-02-26 08:00:00	AMZN	Stock	19.3225	19.3225	19.175	19.25	93580.0
2015-02-26 09:00:00	AMZN	Stock	19.228	19.4415	19.1762	19.367	10464740.0
2015-02-26 10:00:00	AMZN	Stock	19.367	19.4685	19.258	19.3275	12355060.0
2015-02-26 11:00:00	AMZN	Stock	19.3238	19.4195	19.303	19.307	8876760.0
2015-02-26 12:00:00	AMZN	Stock	19.307	19.3084	19.217	19.2765	4014020.0
2015-02-26 13:00:00	AMZN	Stock	19.2741	19.2795	19.2045	19.2385	2687100.0
2015-02-26 14:00:00	AMZN	Stock	19.2435	19.2525	19.17	19.223	3277220.0
2015-02-26 15:00:00	AMZN	Stock	19.2215	19.2595	19.164	19.2395	6554820.0
2015-02-26 16:00:00	AMZN	Stock	19.24	19.3319	19.2332	19.2762	243120.0

> showing 50 of 48,623 rows — these rows as CSV

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