PREVIEW / stock_30min / 2013-01-30

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-01-30.parquet
  size:    1.4 MB
  rows:    76,629
  symbols: 3,474

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-01-30 04:00:00	AAPL	Stock	16.4332	16.4507	16.4164	16.4279	44800.0
2013-01-30 04:30:00	AAPL	Stock	16.4286	16.4539	16.4286	16.4539	54600.0
2013-01-30 05:00:00	AAPL	Stock	16.4461	16.4461	16.4214	16.4214	37800.0
2013-01-30 05:30:00	AAPL	Stock	16.435	16.435	16.4075	16.4121	49000.0
2013-01-30 06:00:00	AAPL	Stock	16.4154	16.4154	16.3886	16.3929	32200.0
2013-01-30 06:30:00	AAPL	Stock	16.3857	16.3857	16.3214	16.3232	84140.0
2013-01-30 07:00:00	AAPL	Stock	16.3232	16.3357	16.3014	16.3125	264404.0
2013-01-30 07:30:00	AAPL	Stock	16.3107	16.3164	16.2875	16.3036	194796.0
2013-01-30 08:00:00	AAPL	Stock	16.3025	16.3571	16.2589	16.2757	1532552.0
2013-01-30 08:30:00	AAPL	Stock	16.2693	16.2696	16.1807	16.2218	2276456.0
2013-01-30 09:00:00	AAPL	Stock	16.2218	16.3386	16.2011	16.3214	3820824.0
2013-01-30 09:30:00	AAPL	Stock	16.3239	16.4893	16.2504	16.4564	80616788.0
2013-01-30 10:00:00	AAPL	Stock	16.4561	16.5214	16.3857	16.4242	52529988.0
2013-01-30 10:30:00	AAPL	Stock	16.4204	16.4868	16.3507	16.4575	38061184.0
2013-01-30 11:00:00	AAPL	Stock	16.4579	16.4959	16.4304	16.4389	20884556.0
2013-01-30 11:30:00	AAPL	Stock	16.435	16.4921	16.4339	16.45	15406188.0
2013-01-30 12:00:00	AAPL	Stock	16.4496	16.4593	16.3929	16.41	15995532.0
2013-01-30 12:30:00	AAPL	Stock	16.41	16.4168	16.3546	16.4135	18979044.0
2013-01-30 13:00:00	AAPL	Stock	16.4125	16.4275	16.3818	16.4139	11059104.0
2013-01-30 13:30:00	AAPL	Stock	16.4107	16.4149	16.375	16.4104	9361408.0
2013-01-30 14:00:00	AAPL	Stock	16.4079	16.425	16.3618	16.4046	21363384.0
2013-01-30 14:30:00	AAPL	Stock	16.4068	16.4239	16.3679	16.4	20420372.0
2013-01-30 15:00:00	AAPL	Stock	16.3982	16.4064	16.2789	16.2936	34423396.0
2013-01-30 15:30:00	AAPL	Stock	16.2953	16.3196	16.2321	16.3182	49825552.0
2013-01-30 16:00:00	AAPL	Stock	16.3154	16.3922	16.2857	16.3036	6204940.0
2013-01-30 16:30:00	AAPL	Stock	16.3036	16.4482	16.2892	16.3036	366408.0
2013-01-30 17:00:00	AAPL	Stock	16.3036	16.3036	16.2821	16.2857	389004.0
2013-01-30 17:30:00	AAPL	Stock	16.2854	16.3	16.2786	16.3	190428.0
2013-01-30 18:00:00	AAPL	Stock	16.3018	16.3107	16.2957	16.3089	81788.0
2013-01-30 18:30:00	AAPL	Stock	16.3096	16.3104	16.3	16.3093	69300.0
2013-01-30 19:00:00	AAPL	Stock	16.3121	16.3121	16.3036	16.3079	70000.0
2013-01-30 19:30:00	AAPL	Stock	16.3089	16.3107	16.3039	16.3071	155596.0
2013-01-30 06:30:00	MSFT	Stock	28.06	28.06	28.06	28.06	500.0
2013-01-30 07:00:00	MSFT	Stock	28.03	28.03	28.03	28.03	1000.0
2013-01-30 07:30:00	MSFT	Stock	28.06	28.06	28.03	28.05	1700.0
2013-01-30 08:00:00	MSFT	Stock	28.06	28.06	28.0	28.03	17350.0
2013-01-30 08:30:00	MSFT	Stock	28.03	28.04	27.97	27.99	30751.0
2013-01-30 09:00:00	MSFT	Stock	27.98	28.05	27.98	28.0	27386.0
2013-01-30 09:30:00	MSFT	Stock	28.01	28.19	27.98	28.155	6159113.0
2013-01-30 10:00:00	MSFT	Stock	28.15	28.152	27.96	27.97	3411135.0
2013-01-30 10:30:00	MSFT	Stock	27.975	28.01	27.86	27.99	3706517.0
2013-01-30 11:00:00	MSFT	Stock	27.995	28.035	27.98	27.99	1792455.0
2013-01-30 11:30:00	MSFT	Stock	27.995	28.05	27.98	27.98	1955695.0
2013-01-30 12:00:00	MSFT	Stock	27.98	28.02	27.94	27.955	1566803.0
2013-01-30 12:30:00	MSFT	Stock	27.955	28.05	27.955	28.05	1755086.0
2013-01-30 13:00:00	MSFT	Stock	28.045	28.06	27.96	28.002	1732958.0
2013-01-30 13:30:00	MSFT	Stock	28.005	28.01	27.95	27.98	1009044.0
2013-01-30 14:00:00	MSFT	Stock	27.975	28.04	27.92	27.98	2267135.0
2013-01-30 14:30:00	MSFT	Stock	27.975	28.0	27.92	27.952	1974155.0
2013-01-30 15:00:00	MSFT	Stock	27.96	27.98	27.86	27.875	3191332.0

> showing 50 of 76,629 rows — these rows as CSV

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