PREVIEW / stock_30min / 2013-02-15

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-02-15.parquet
  size:    1.5 MB
  rows:    77,526
  symbols: 3,461

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-02-15 06:00:00	AAPL	Stock	16.7268	16.7268	16.7268	16.7268	2800.0
2013-02-15 06:30:00	AAPL	Stock	16.6825	16.6825	16.6786	16.6786	14000.0
2013-02-15 07:00:00	AAPL	Stock	16.6821	16.6964	16.6786	16.6914	23660.0
2013-02-15 07:30:00	AAPL	Stock	16.6929	16.6936	16.6875	16.6875	35000.0
2013-02-15 08:00:00	AAPL	Stock	16.7104	16.75	16.6836	16.7304	636356.0
2013-02-15 08:30:00	AAPL	Stock	16.7371	16.745	16.7161	16.7207	675080.0
2013-02-15 09:00:00	AAPL	Stock	16.7279	16.7664	16.7154	16.75	1071868.0
2013-02-15 09:30:00	AAPL	Stock	16.7561	16.7571	16.6536	16.7346	67586148.0
2013-02-15 10:00:00	AAPL	Stock	16.7293	16.7914	16.6964	16.7139	34536208.0
2013-02-15 10:30:00	AAPL	Stock	16.7136	16.7239	16.6718	16.6929	16855552.0
2013-02-15 11:00:00	AAPL	Stock	16.6957	16.6982	16.6486	16.6834	14313488.0
2013-02-15 11:30:00	AAPL	Stock	16.6779	16.6779	16.6336	16.6521	14841820.0
2013-02-15 12:00:00	AAPL	Stock	16.6554	16.6554	16.55	16.59	32690812.0
2013-02-15 12:30:00	AAPL	Stock	16.5893	16.6014	16.575	16.59	8936116.0
2013-02-15 13:00:00	AAPL	Stock	16.5946	16.6268	16.5571	16.5839	15120980.0
2013-02-15 13:30:00	AAPL	Stock	16.5821	16.6089	16.5768	16.5975	9376724.0
2013-02-15 14:00:00	AAPL	Stock	16.5957	16.6086	16.4643	16.4732	33282536.0
2013-02-15 14:30:00	AAPL	Stock	16.4696	16.5104	16.455	16.4871	28042924.0
2013-02-15 15:00:00	AAPL	Stock	16.4868	16.5032	16.4286	16.4404	35557340.0
2013-02-15 15:30:00	AAPL	Stock	16.4429	16.4607	16.4257	16.4375	50286096.0
2013-02-15 16:00:00	AAPL	Stock	16.4356	16.5919	16.4271	16.4342	16052960.0
2013-02-15 16:30:00	AAPL	Stock	16.4293	16.4388	16.4286	16.4286	855148.0
2013-02-15 17:00:00	AAPL	Stock	16.4279	16.4286	16.425	16.425	200060.0
2013-02-15 17:30:00	AAPL	Stock	16.4268	16.43	16.4204	16.4289	161392.0
2013-02-15 18:00:00	AAPL	Stock	16.4282	16.4282	16.4036	16.4282	89152.0
2013-02-15 18:30:00	AAPL	Stock	16.42	16.42	16.42	16.42	2800.0
2013-02-15 19:00:00	AAPL	Stock	16.4154	16.4286	16.4154	16.425	65128.0
2013-02-15 19:30:00	AAPL	Stock	16.4254	16.4254	16.4143	16.4232	69104.0
2013-02-15 04:30:00	MSFT	Stock	28.09	28.09	28.09	28.09	226.0
2013-02-15 07:00:00	MSFT	Stock	28.05	28.05	28.05	28.05	200.0
2013-02-15 08:00:00	MSFT	Stock	28.0	28.05	28.0	28.05	11500.0
2013-02-15 08:30:00	MSFT	Stock	28.04	28.04	28.01	28.01	1500.0
2013-02-15 09:00:00	MSFT	Stock	28.01	28.09	27.85	28.04	50701.0
2013-02-15 09:30:00	MSFT	Stock	28.04	28.16	28.025	28.12	12758903.0
2013-02-15 10:00:00	MSFT	Stock	28.12	28.15	27.98	28.01	3182293.0
2013-02-15 10:30:00	MSFT	Stock	28.01	28.03	27.975	28.0	2120238.0
2013-02-15 11:00:00	MSFT	Stock	28.01	28.015	27.97	28.0	1798625.0
2013-02-15 11:30:00	MSFT	Stock	27.995	28.025	27.95	27.99	2669371.0
2013-02-15 12:00:00	MSFT	Stock	27.988	28.015	27.96	28.005	1933453.0
2013-02-15 12:30:00	MSFT	Stock	28.01	28.02	27.98	28.0	1037782.0
2013-02-15 13:00:00	MSFT	Stock	28.0	28.01	27.96	27.96	1673887.0
2013-02-15 13:30:00	MSFT	Stock	27.962	28.0	27.96	27.998	901175.0
2013-02-15 14:00:00	MSFT	Stock	27.992	28.01	27.92	27.94	4666904.0
2013-02-15 14:30:00	MSFT	Stock	27.94	27.955	27.875	27.88	3079438.0
2013-02-15 15:00:00	MSFT	Stock	27.88	28.01	27.88	27.985	3014982.0
2013-02-15 15:30:00	MSFT	Stock	27.99	28.02	27.955	28.02	6957249.0
2013-02-15 16:00:00	MSFT	Stock	28.01	28.02	27.98	28.014	2862184.0
2013-02-15 16:30:00	MSFT	Stock	27.99	28.02	27.98	28.02	84940.0
2013-02-15 17:00:00	MSFT	Stock	28.0	28.02	27.99	28.02	61955.0
2013-02-15 17:30:00	MSFT	Stock	27.99	27.99	27.99	27.99	320.0

> showing 50 of 77,526 rows — these rows as CSV

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