PREVIEW / stock_30min / 2013-01-31

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-01-31.parquet
  size:    1.5 MB
  rows:    77,331
  symbols: 3,460

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-31 06:00:00	AAPL	Stock	16.2571	16.2571	16.2571	16.2571	5600.0
2013-01-31 06:30:00	AAPL	Stock	16.2679	16.2836	16.2679	16.2836	24640.0
2013-01-31 07:00:00	AAPL	Stock	16.2536	16.2543	16.2343	16.25	75320.0
2013-01-31 07:30:00	AAPL	Stock	16.2696	16.2857	16.2589	16.2857	131600.0
2013-01-31 08:00:00	AAPL	Stock	16.2857	16.3118	16.2343	16.2693	377888.0
2013-01-31 08:30:00	AAPL	Stock	16.2682	16.2779	16.2389	16.2618	351848.0
2013-01-31 09:00:00	AAPL	Stock	16.2557	16.3425	16.2557	16.3204	1289708.0
2013-01-31 09:30:00	AAPL	Stock	16.3207	16.4029	16.255	16.3529	55050408.0
2013-01-31 10:00:00	AAPL	Stock	16.3436	16.365	16.3057	16.3132	18966220.0
2013-01-31 10:30:00	AAPL	Stock	16.3118	16.3729	16.3068	16.3261	17073784.0
2013-01-31 11:00:00	AAPL	Stock	16.3268	16.3439	16.2732	16.2732	16761136.0
2013-01-31 11:30:00	AAPL	Stock	16.2746	16.2907	16.2493	16.2598	20897660.0
2013-01-31 12:00:00	AAPL	Stock	16.2607	16.3032	16.2536	16.2554	14788704.0
2013-01-31 12:30:00	AAPL	Stock	16.2568	16.3143	16.2511	16.2775	13544804.0
2013-01-31 13:00:00	AAPL	Stock	16.2757	16.2889	16.2536	16.2668	12041120.0
2013-01-31 13:30:00	AAPL	Stock	16.2668	16.3146	16.2661	16.2879	11453736.0
2013-01-31 14:00:00	AAPL	Stock	16.2874	16.3493	16.2768	16.3375	13852048.0
2013-01-31 14:30:00	AAPL	Stock	16.3381	16.3679	16.3312	16.3443	14814408.0
2013-01-31 15:00:00	AAPL	Stock	16.3436	16.3514	16.2725	16.2875	19354300.0
2013-01-31 15:30:00	AAPL	Stock	16.2871	16.3186	16.2507	16.2636	35268380.0
2013-01-31 16:00:00	AAPL	Stock	16.2614	16.3121	16.2589	16.2704	43828512.0
2013-01-31 16:30:00	AAPL	Stock	16.2746	16.2885	16.2609	16.2804	1592388.0
2013-01-31 17:00:00	AAPL	Stock	16.2839	16.2857	16.2611	16.2804	1117396.0
2013-01-31 17:30:00	AAPL	Stock	16.2804	16.2821	16.2611	16.2732	83132.0
2013-01-31 18:00:00	AAPL	Stock	16.2732	16.2889	16.2732	16.2825	303856.0
2013-01-31 18:30:00	AAPL	Stock	16.2839	16.2961	16.2796	16.2954	91308.0
2013-01-31 19:00:00	AAPL	Stock	16.2961	16.2961	16.2875	16.2893	52248.0
2013-01-31 19:30:00	AAPL	Stock	16.2946	16.3011	16.2929	16.3	126980.0
2013-01-31 08:00:00	MSFT	Stock	27.85	27.87	27.82	27.85	25300.0
2013-01-31 08:30:00	MSFT	Stock	27.84	27.84	27.84	27.84	3200.0
2013-01-31 09:00:00	MSFT	Stock	27.82	27.84	27.61	27.77	82554.0
2013-01-31 09:30:00	MSFT	Stock	27.79	27.97	27.6	27.82	4721669.0
2013-01-31 10:00:00	MSFT	Stock	27.82	27.82	27.7	27.71	3171544.0
2013-01-31 10:30:00	MSFT	Stock	27.71	27.79	27.55	27.59	3482382.0
2013-01-31 11:00:00	MSFT	Stock	27.6	27.61	27.51	27.56	3306722.0
2013-01-31 11:30:00	MSFT	Stock	27.56	27.6	27.52	27.55	2448441.0
2013-01-31 12:00:00	MSFT	Stock	27.55	27.565	27.5	27.515	1779610.0
2013-01-31 12:30:00	MSFT	Stock	27.516	27.57	27.5	27.566	3315519.0
2013-01-31 13:00:00	MSFT	Stock	27.57	27.62	27.53	27.53	2466610.0
2013-01-31 13:30:00	MSFT	Stock	27.535	27.55	27.52	27.525	1278912.0
2013-01-31 14:00:00	MSFT	Stock	27.52	27.54	27.48	27.48	2172510.0
2013-01-31 14:30:00	MSFT	Stock	27.48	27.55	27.45	27.514	4234141.0
2013-01-31 15:00:00	MSFT	Stock	27.51	27.52	27.43	27.458	3208265.0
2013-01-31 15:30:00	MSFT	Stock	27.45	27.49	27.4	27.47	9563346.0
2013-01-31 16:00:00	MSFT	Stock	27.47	27.652	27.43	27.43	4197227.0
2013-01-31 16:30:00	MSFT	Stock	27.44	27.85	27.44	27.47	390441.0
2013-01-31 17:00:00	MSFT	Stock	27.47	27.47	27.45	27.47	105909.0
2013-01-31 17:30:00	MSFT	Stock	27.47	27.48	27.47	27.48	3920.0
2013-01-31 18:00:00	MSFT	Stock	27.49	27.5	27.48	27.48	1518.0
2013-01-31 18:30:00	MSFT	Stock	27.49	27.5	27.48	27.5	1150.0

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

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