PREVIEW / stock_30min / 2013-07-15

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-07-15.parquet
  size:    1.5 MB
  rows:    79,224
  symbols: 3,513

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-07-15 04:00:00	AAPL	Stock	15.2586	15.2586	15.2586	15.2586	5600.0
2013-07-15 06:00:00	AAPL	Stock	15.2329	15.2329	15.2329	15.2329	2800.0
2013-07-15 07:00:00	AAPL	Stock	15.2321	15.2325	15.2321	15.2325	6468.0
2013-07-15 07:30:00	AAPL	Stock	15.2232	15.2232	15.1989	15.1989	17080.0
2013-07-15 08:00:00	AAPL	Stock	15.1807	15.2321	15.1696	15.1982	687260.0
2013-07-15 08:30:00	AAPL	Stock	15.1982	15.215	15.1929	15.2146	387380.0
2013-07-15 09:00:00	AAPL	Stock	15.2143	15.2143	15.1714	15.1943	481628.0
2013-07-15 09:30:00	AAPL	Stock	15.1796	15.3143	15.1714	15.2914	37371236.0
2013-07-15 10:00:00	AAPL	Stock	15.2929	15.4089	15.2629	15.3882	36371636.0
2013-07-15 10:30:00	AAPL	Stock	15.3869	15.4093	15.3139	15.3368	22395856.0
2013-07-15 11:00:00	AAPL	Stock	15.3382	15.3814	15.3143	15.373	12752292.0
2013-07-15 11:30:00	AAPL	Stock	15.3736	15.3821	15.3264	15.3443	6442856.0
2013-07-15 12:00:00	AAPL	Stock	15.3482	15.3714	15.2989	15.3314	8880508.0
2013-07-15 12:30:00	AAPL	Stock	15.3336	15.3343	15.2993	15.3286	4942336.0
2013-07-15 13:00:00	AAPL	Stock	15.3271	15.3386	15.3107	15.3107	5431468.0
2013-07-15 13:30:00	AAPL	Stock	15.3107	15.3532	15.305	15.3454	7153496.0
2013-07-15 14:00:00	AAPL	Stock	15.3475	15.3679	15.31	15.3279	8765568.0
2013-07-15 14:30:00	AAPL	Stock	15.3282	15.3518	15.3125	15.3507	9347688.0
2013-07-15 15:00:00	AAPL	Stock	15.3475	15.3564	15.2943	15.3068	10241252.0
2013-07-15 15:30:00	AAPL	Stock	15.3054	15.3127	15.2573	15.2657	23829148.0
2013-07-15 16:00:00	AAPL	Stock	15.2668	15.3222	15.2611	15.2679	31946908.0
2013-07-15 16:30:00	AAPL	Stock	15.2657	15.3039	15.2625	15.2643	399084.0
2013-07-15 17:00:00	AAPL	Stock	15.2643	15.2679	15.2625	15.2679	70532.0
2013-07-15 17:30:00	AAPL	Stock	15.2671	15.2671	15.2643	15.2643	16240.0
2013-07-15 18:00:00	AAPL	Stock	15.2643	15.2679	15.2643	15.2679	5600.0
2013-07-15 18:30:00	AAPL	Stock	15.2679	15.2679	15.2632	15.2664	21140.0
2013-07-15 19:00:00	AAPL	Stock	15.2625	15.2643	15.2625	15.2625	31416.0
2013-07-15 19:30:00	AAPL	Stock	15.2607	15.2639	15.25	15.25	202132.0
2013-07-15 04:00:00	MSFT	Stock	35.67	35.67	35.67	35.67	5000.0
2013-07-15 05:00:00	MSFT	Stock	35.68	35.68	35.68	35.68	3000.0
2013-07-15 06:30:00	MSFT	Stock	35.69	35.69	35.68	35.68	440.0
2013-07-15 07:00:00	MSFT	Stock	35.7	35.7	35.61	35.61	3631.0
2013-07-15 08:00:00	MSFT	Stock	35.65	35.67	35.62	35.62	2306.0
2013-07-15 08:30:00	MSFT	Stock	35.67	35.67	35.62	35.66	1200.0
2013-07-15 09:00:00	MSFT	Stock	35.66	35.66	35.62	35.65	20502.0
2013-07-15 09:30:00	MSFT	Stock	35.65	35.81	35.58	35.77	3584125.0
2013-07-15 10:00:00	MSFT	Stock	35.77	35.98	35.73	35.969	2596274.0
2013-07-15 10:30:00	MSFT	Stock	35.96	36.0	35.9	35.97	2061812.0
2013-07-15 11:00:00	MSFT	Stock	35.97	35.98	35.88	35.95	1546079.0
2013-07-15 11:30:00	MSFT	Stock	35.95	35.99	35.86	35.99	2143487.0
2013-07-15 12:00:00	MSFT	Stock	35.99	36.135	35.96	36.13	2578780.0
2013-07-15 12:30:00	MSFT	Stock	36.13	36.15	36.07	36.089	1685593.0
2013-07-15 13:00:00	MSFT	Stock	36.085	36.09	36.03	36.07	1411372.0
2013-07-15 13:30:00	MSFT	Stock	36.065	36.12	36.05	36.055	1663903.0
2013-07-15 14:00:00	MSFT	Stock	36.06	36.09	36.03	36.08	1415495.0
2013-07-15 14:30:00	MSFT	Stock	36.08	36.09	36.02	36.055	1526920.0
2013-07-15 15:00:00	MSFT	Stock	36.055	36.14	36.05	36.067	1553012.0
2013-07-15 15:30:00	MSFT	Stock	36.06	36.22	36.06	36.19	6795418.0
2013-07-15 16:00:00	MSFT	Stock	36.19	36.21	35.837	36.138	3096492.0
2013-07-15 16:30:00	MSFT	Stock	36.17	36.19	36.058	36.17	120316.0

> showing 50 of 79,224 rows — these rows as CSV

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