PREVIEW / stock_30min / 2011-09-26

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-09-26.parquet
  size:    1.4 MB
  rows:    75,538
  symbols: 3,528

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
2011-09-26 04:00:00	AAPL	Stock	14.4321	14.4582	14.3811	14.4464	58800.0
2011-09-26 04:30:00	AAPL	Stock	14.4321	14.4964	14.4321	14.4964	68600.0
2011-09-26 05:00:00	AAPL	Stock	14.5	14.5321	14.4964	14.5179	79660.0
2011-09-26 05:30:00	AAPL	Stock	14.5357	14.5357	14.5	14.5054	78484.0
2011-09-26 06:00:00	AAPL	Stock	14.4782	14.4821	14.4636	14.4636	78400.0
2011-09-26 06:30:00	AAPL	Stock	14.4764	14.4868	14.4286	14.4464	183960.0
2011-09-26 07:00:00	AAPL	Stock	14.4464	14.4857	14.2396	14.3357	2421076.0
2011-09-26 07:30:00	AAPL	Stock	14.3393	14.3446	14.1071	14.2679	2921520.0
2011-09-26 08:00:00	AAPL	Stock	14.2836	14.4393	14.2646	14.3214	5902064.0
2011-09-26 08:30:00	AAPL	Stock	14.3075	14.4107	14.3075	14.4068	8589000.0
2011-09-26 09:00:00	AAPL	Stock	14.4036	14.4193	14.2725	14.2857	5524820.0
2011-09-26 09:30:00	AAPL	Stock	14.2857	14.3279	14.0714	14.0857	136600352.0
2011-09-26 10:00:00	AAPL	Stock	14.0887	14.1071	13.975	14.0742	97121248.0
2011-09-26 10:30:00	AAPL	Stock	14.0771	14.242	14.0007	14.2164	80759364.0
2011-09-26 11:00:00	AAPL	Stock	14.2232	14.2979	14.1786	14.2579	64363264.0
2011-09-26 11:30:00	AAPL	Stock	14.2579	14.3521	14.1971	14.3018	50129408.0
2011-09-26 12:00:00	AAPL	Stock	14.3032	14.3211	14.2321	14.2339	29754424.0
2011-09-26 12:30:00	AAPL	Stock	14.2343	14.2679	14.1429	14.1714	34930224.0
2011-09-26 13:00:00	AAPL	Stock	14.1711	14.1814	14.1071	14.1568	29391068.0
2011-09-26 13:30:00	AAPL	Stock	14.1554	14.1814	14.0796	14.1293	27191556.0
2011-09-26 14:00:00	AAPL	Stock	14.1321	14.2411	14.1164	14.1618	37200296.0
2011-09-26 14:30:00	AAPL	Stock	14.1575	14.2587	14.1536	14.2454	31154732.0
2011-09-26 15:00:00	AAPL	Stock	14.2532	14.2957	14.2343	14.275	37428244.0
2011-09-26 15:30:00	AAPL	Stock	14.2729	14.4279	14.2536	14.4	72507120.0
2011-09-26 16:00:00	AAPL	Stock	14.3943	14.4059	14.181	14.3975	40269432.0
2011-09-26 16:30:00	AAPL	Stock	14.3939	14.4004	14.2716	14.3875	970620.0
2011-09-26 17:00:00	AAPL	Stock	14.3946	14.3946	14.3839	14.3893	214788.0
2011-09-26 17:30:00	AAPL	Stock	14.3882	14.3918	14.3821	14.3864	121072.0
2011-09-26 18:00:00	AAPL	Stock	14.3864	14.3989	14.3821	14.3821	85904.0
2011-09-26 18:30:00	AAPL	Stock	14.3782	14.3893	14.3779	14.3857	57232.0
2011-09-26 19:00:00	AAPL	Stock	14.3857	14.3889	14.3764	14.3821	109116.0
2011-09-26 19:30:00	AAPL	Stock	14.3821	14.3821	14.3643	14.3714	307300.0
2011-09-26 05:00:00	MSFT	Stock	25.17	25.17	25.17	25.17	100.0
2011-09-26 06:30:00	MSFT	Stock	25.25	25.25	25.25	25.25	200.0
2011-09-26 07:00:00	MSFT	Stock	25.38	25.47	25.25	25.31	27819.0
2011-09-26 07:30:00	MSFT	Stock	25.4	25.45	25.36	25.4	10540.0
2011-09-26 08:00:00	MSFT	Stock	25.4	25.44	25.06	25.37	19498.0
2011-09-26 08:30:00	MSFT	Stock	25.4	25.4	25.31	25.31	4899.0
2011-09-26 09:00:00	MSFT	Stock	25.35	25.36	25.2	25.2	25723.0
2011-09-26 09:30:00	MSFT	Stock	25.2	25.37	24.96	25.0	4941681.0
2011-09-26 10:00:00	MSFT	Stock	25.0	25.025	24.73	24.89	4966857.0
2011-09-26 10:30:00	MSFT	Stock	24.89	25.09	24.8	25.052	4348787.0
2011-09-26 11:00:00	MSFT	Stock	25.05	25.25	25.01	25.23	2975573.0
2011-09-26 11:30:00	MSFT	Stock	25.23	25.35	25.125	25.26	3195797.0
2011-09-26 12:00:00	MSFT	Stock	25.26	25.28	25.142	25.18	2131818.0
2011-09-26 12:30:00	MSFT	Stock	25.18	25.21	24.95	25.01	2201314.0
2011-09-26 13:00:00	MSFT	Stock	25.01	25.01	24.88	24.98	2524307.0
2011-09-26 13:30:00	MSFT	Stock	24.98	25.036	24.88	24.978	2260088.0
2011-09-26 14:00:00	MSFT	Stock	24.976	25.13	24.95	25.09	2245774.0
2011-09-26 14:30:00	MSFT	Stock	25.095	25.24	25.06	25.135	2798335.0

> showing 50 of 75,538 rows — these rows as CSV

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