PREVIEW / stock_1hour / 2014-03-26

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-03-26.parquet
  size:    1.0 MB
  rows:    48,684
  symbols: 3,526

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
2014-03-26 05:00:00	AAPL	Stock	19.5257	19.5257	19.4857	19.4857	28000.0
2014-03-26 06:00:00	AAPL	Stock	19.5296	19.5314	19.5179	19.5218	54152.0
2014-03-26 07:00:00	AAPL	Stock	19.5357	19.5357	19.4829	19.5286	201600.0
2014-03-26 08:00:00	AAPL	Stock	19.5314	19.5479	19.4989	19.5404	1707468.0
2014-03-26 09:00:00	AAPL	Stock	19.5411	19.605	19.5186	19.6046	38558660.0
2014-03-26 10:00:00	AAPL	Stock	19.6046	19.6071	19.5268	19.5295	34767068.0
2014-03-26 11:00:00	AAPL	Stock	19.5311	19.5925	19.5218	19.5554	23606156.0
2014-03-26 12:00:00	AAPL	Stock	19.5575	19.5589	19.4704	19.5311	21267092.0
2014-03-26 13:00:00	AAPL	Stock	19.5311	19.5332	19.3048	19.3736	31929296.0
2014-03-26 14:00:00	AAPL	Stock	19.3707	19.4182	19.245	19.395	34739012.0
2014-03-26 15:00:00	AAPL	Stock	19.3982	19.4089	19.2774	19.2779	35742896.0
2014-03-26 16:00:00	AAPL	Stock	19.2779	19.538	19.2482	19.2614	14329252.0
2014-03-26 17:00:00	AAPL	Stock	19.2625	19.2779	19.2507	19.26	801864.0
2014-03-26 18:00:00	AAPL	Stock	19.2607	19.2779	19.2521	19.2521	1312360.0
2014-03-26 19:00:00	AAPL	Stock	19.2521	19.2643	19.2357	19.2425	301644.0
2014-03-26 08:00:00	MSFT	Stock	40.64	40.64	40.5	40.52	14143.0
2014-03-26 09:00:00	MSFT	Stock	40.52	40.705	40.26	40.325	4586780.0
2014-03-26 10:00:00	MSFT	Stock	40.325	40.33	39.67	39.69	6451068.0
2014-03-26 11:00:00	MSFT	Stock	39.685	39.97	39.6	39.85	3812625.0
2014-03-26 12:00:00	MSFT	Stock	39.85	39.92	39.72	39.9	3636484.0
2014-03-26 13:00:00	MSFT	Stock	39.9	40.01	39.8	39.93	5113315.0
2014-03-26 14:00:00	MSFT	Stock	39.93	40.035	39.86	40.0	4797068.0
2014-03-26 15:00:00	MSFT	Stock	39.99	40.015	39.79	39.79	7888378.0
2014-03-26 16:00:00	MSFT	Stock	39.79	39.912	39.72	39.79	2642372.0
2014-03-26 17:00:00	MSFT	Stock	39.79	39.79	39.78	39.79	131110.0
2014-03-26 18:00:00	MSFT	Stock	39.8	39.83	39.8	39.83	600.0
2014-03-26 19:00:00	MSFT	Stock	39.77	39.85	39.75	39.75	4489.0
2014-03-26 09:00:00	NVDA	Stock	0.4648	0.4742	0.4645	0.466	105513000.0
2014-03-26 10:00:00	NVDA	Stock	0.4658	0.469	0.4555	0.4555	86710520.0
2014-03-26 11:00:00	NVDA	Stock	0.4552	0.459	0.4528	0.4542	50539280.0
2014-03-26 12:00:00	NVDA	Stock	0.4543	0.4598	0.4539	0.4581	44220520.0
2014-03-26 13:00:00	NVDA	Stock	0.4582	0.4585	0.4468	0.4492	77720760.0
2014-03-26 14:00:00	NVDA	Stock	0.4492	0.4568	0.449	0.4562	79083880.0
2014-03-26 15:00:00	NVDA	Stock	0.4561	0.4562	0.4505	0.4508	89227120.0
2014-03-26 16:00:00	NVDA	Stock	0.4508	0.4547	0.4506	0.4508	3844200.0
2014-03-26 17:00:00	NVDA	Stock	0.4508	0.4508	0.4508	0.4508	359600.0
2014-03-26 19:00:00	NVDA	Stock	0.449	0.449	0.449	0.449	20000.0
2014-03-26 04:00:00	AMZN	Stock	17.7455	17.753	17.7455	17.753	6000.0
2014-03-26 07:00:00	AMZN	Stock	17.813	17.827	17.803	17.81	16360.0
2014-03-26 08:00:00	AMZN	Stock	17.81	17.875	17.7355	17.8665	111220.0
2014-03-26 09:00:00	AMZN	Stock	17.875	17.8875	17.583	17.6375	9251800.0
2014-03-26 10:00:00	AMZN	Stock	17.6375	17.666	17.5025	17.545	10879280.0
2014-03-26 11:00:00	AMZN	Stock	17.546	17.69	17.538	17.594	6455420.0
2014-03-26 12:00:00	AMZN	Stock	17.59	17.6329	17.5265	17.5558	4853180.0
2014-03-26 13:00:00	AMZN	Stock	17.554	17.563	17.37	17.414	9213060.0
2014-03-26 14:00:00	AMZN	Stock	17.4228	17.4228	17.2701	17.3225	12193480.0
2014-03-26 15:00:00	AMZN	Stock	17.33	17.3625	17.17	17.1705	17999780.0
2014-03-26 16:00:00	AMZN	Stock	17.1705	17.7355	17.16	17.7355	4533460.0
2014-03-26 17:00:00	AMZN	Stock	17.19	17.19	17.1705	17.1705	136080.0
2014-03-26 18:00:00	AMZN	Stock	17.1875	17.1875	17.1705	17.175	100680.0

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

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