PREVIEW / stock_30min / 2014-04-02

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-04-02.parquet
  size:    1.6 MB
  rows:    82,174
  symbols: 3,542

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-04-02 04:00:00	AAPL	Stock	19.3911	19.3929	19.3911	19.3929	8400.0
2014-04-02 04:30:00	AAPL	Stock	19.3961	19.3961	19.3961	19.3961	2800.0
2014-04-02 05:00:00	AAPL	Stock	19.3929	19.3929	19.3929	19.3929	5600.0
2014-04-02 05:30:00	AAPL	Stock	19.3757	19.3757	19.3757	19.3757	11760.0
2014-04-02 06:00:00	AAPL	Stock	19.3575	19.38	19.3575	19.38	5600.0
2014-04-02 06:30:00	AAPL	Stock	19.3804	19.3911	19.3804	19.3807	29400.0
2014-04-02 07:00:00	AAPL	Stock	19.3804	19.4018	19.3804	19.3932	62412.0
2014-04-02 07:30:00	AAPL	Stock	19.3857	19.3857	19.3571	19.3575	78400.0
2014-04-02 08:00:00	AAPL	Stock	19.3643	19.4021	19.3471	19.3804	534296.0
2014-04-02 08:30:00	AAPL	Stock	19.3789	19.3886	19.3639	19.3639	270536.0
2014-04-02 09:00:00	AAPL	Stock	19.3668	19.3925	19.3661	19.3739	768684.0
2014-04-02 09:30:00	AAPL	Stock	19.3707	19.3989	19.2961	19.3036	30113496.0
2014-04-02 10:00:00	AAPL	Stock	19.3036	19.3611	19.2968	19.3511	14014168.0
2014-04-02 10:30:00	AAPL	Stock	19.3507	19.3571	19.3111	19.32	9926252.0
2014-04-02 11:00:00	AAPL	Stock	19.32	19.347	19.3143	19.3214	7896672.0
2014-04-02 11:30:00	AAPL	Stock	19.3193	19.3729	19.318	19.3611	7162316.0
2014-04-02 12:00:00	AAPL	Stock	19.3614	19.3729	19.3229	19.3654	7936684.0
2014-04-02 12:30:00	AAPL	Stock	19.3679	19.38	19.3511	19.3779	7067200.0
2014-04-02 13:00:00	AAPL	Stock	19.3782	19.3789	19.3361	19.3539	4874884.0
2014-04-02 13:30:00	AAPL	Stock	19.3539	19.3554	19.295	19.3268	7254604.0
2014-04-02 14:00:00	AAPL	Stock	19.3275	19.3464	19.3161	19.3218	5445664.0
2014-04-02 14:30:00	AAPL	Stock	19.3214	19.3564	19.3086	19.3521	4817400.0
2014-04-02 15:00:00	AAPL	Stock	19.3525	19.3839	19.3521	19.3839	8126076.0
2014-04-02 15:30:00	AAPL	Stock	19.3839	19.41	19.3721	19.3789	20584396.0
2014-04-02 16:00:00	AAPL	Stock	19.3768	19.3814	19.3502	19.3768	7449540.0
2014-04-02 16:30:00	AAPL	Stock	19.3646	19.365	19.3372	19.3625	92876.0
2014-04-02 17:00:00	AAPL	Stock	19.3729	19.3768	19.3282	19.3586	231644.0
2014-04-02 17:30:00	AAPL	Stock	19.3696	19.3696	19.3696	19.3696	11200.0
2014-04-02 18:00:00	AAPL	Stock	19.3661	19.3893	19.3582	19.3586	211400.0
2014-04-02 18:30:00	AAPL	Stock	19.3611	19.3768	19.3393	19.3393	439768.0
2014-04-02 19:00:00	AAPL	Stock	19.3564	19.3582	19.3561	19.3571	85596.0
2014-04-02 19:30:00	AAPL	Stock	19.3582	19.3929	19.3568	19.3839	328916.0
2014-04-02 06:30:00	MSFT	Stock	41.44	41.58	41.4	41.58	1585.0
2014-04-02 07:00:00	MSFT	Stock	41.52	41.6	41.52	41.6	1645.0
2014-04-02 07:30:00	MSFT	Stock	41.59	41.62	41.55	41.62	12235.0
2014-04-02 08:00:00	MSFT	Stock	41.6	41.63	41.3	41.5	14805.0
2014-04-02 08:30:00	MSFT	Stock	41.51	41.58	41.5	41.53	5041.0
2014-04-02 09:00:00	MSFT	Stock	41.51	41.57	41.44	41.45	35266.0
2014-04-02 09:30:00	MSFT	Stock	41.44	41.66	41.325	41.35	4809368.0
2014-04-02 10:00:00	MSFT	Stock	41.34	41.39	41.17	41.38	2234560.0
2014-04-02 10:30:00	MSFT	Stock	41.385	41.39	41.24	41.33	1521703.0
2014-04-02 11:00:00	MSFT	Stock	41.337	41.37	41.2	41.29	1728979.0
2014-04-02 11:30:00	MSFT	Stock	41.29	41.3	41.21	41.28	904754.0
2014-04-02 12:00:00	MSFT	Stock	41.285	41.291	41.21	41.24	986176.0
2014-04-02 12:30:00	MSFT	Stock	41.246	41.29	41.21	41.25	774888.0
2014-04-02 13:00:00	MSFT	Stock	41.259	41.31	41.23	41.3	1164184.0
2014-04-02 13:30:00	MSFT	Stock	41.3	41.35	41.22	41.295	1526655.0
2014-04-02 14:00:00	MSFT	Stock	41.3	41.37	41.22	41.24	1341420.0
2014-04-02 14:30:00	MSFT	Stock	41.23	41.35	41.23	41.35	1233285.0
2014-04-02 15:00:00	MSFT	Stock	41.34	41.39	41.28	41.385	1715955.0

> showing 50 of 82,174 rows — these rows as CSV

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