PREVIEW / stock_30min / 2011-02-02

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-02-02.parquet
  size:    1.4 MB
  rows:    76,143
  symbols: 3,514

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-02-02 04:30:00	AAPL	Stock	12.3225	12.3496	12.3225	12.3496	8400.0
2011-02-02 05:00:00	AAPL	Stock	12.3393	12.3393	12.3286	12.3286	8400.0
2011-02-02 06:00:00	AAPL	Stock	12.3429	12.3429	12.3429	12.3429	14000.0
2011-02-02 06:30:00	AAPL	Stock	12.3429	12.3429	12.3286	12.3286	19600.0
2011-02-02 07:00:00	AAPL	Stock	12.3314	12.3539	12.3225	12.3464	163912.0
2011-02-02 07:30:00	AAPL	Stock	12.3307	12.3321	12.3214	12.3321	39200.0
2011-02-02 08:00:00	AAPL	Stock	12.3279	12.3279	12.2946	12.3136	791560.0
2011-02-02 08:30:00	AAPL	Stock	12.3039	12.3107	12.2893	12.2961	349440.0
2011-02-02 09:00:00	AAPL	Stock	12.2961	12.3014	12.2643	12.3014	1295028.0
2011-02-02 09:30:00	AAPL	Stock	12.3014	12.3304	12.28	12.3057	47598348.0
2011-02-02 10:00:00	AAPL	Stock	12.3057	12.3179	12.2696	12.3118	34935068.0
2011-02-02 10:30:00	AAPL	Stock	12.312	12.3179	12.2886	12.295	18385556.0
2011-02-02 11:00:00	AAPL	Stock	12.2957	12.2986	12.2725	12.2918	18307800.0
2011-02-02 11:30:00	AAPL	Stock	12.2929	12.3104	12.2832	12.3104	14145712.0
2011-02-02 12:00:00	AAPL	Stock	12.3104	12.3125	12.2911	12.2936	10531836.0
2011-02-02 12:30:00	AAPL	Stock	12.2946	12.3107	12.2939	12.3021	9294236.0
2011-02-02 13:00:00	AAPL	Stock	12.3032	12.3064	12.2925	12.2957	9712640.0
2011-02-02 13:30:00	AAPL	Stock	12.295	12.305	12.2807	12.2857	11310600.0
2011-02-02 14:00:00	AAPL	Stock	12.2879	12.3079	12.2839	12.3068	8230068.0
2011-02-02 14:30:00	AAPL	Stock	12.3061	12.3211	12.2932	12.3134	12768000.0
2011-02-02 15:00:00	AAPL	Stock	12.3129	12.3207	12.2761	12.2764	19161240.0
2011-02-02 15:30:00	AAPL	Stock	12.2771	12.2975	12.2707	12.2971	31699584.0
2011-02-02 16:00:00	AAPL	Stock	12.2971	12.3225	12.2786	12.2857	5062428.0
2011-02-02 16:30:00	AAPL	Stock	12.2857	12.2959	12.2769	12.29	178584.0
2011-02-02 17:00:00	AAPL	Stock	12.2879	12.29	12.2857	12.29	65688.0
2011-02-02 17:30:00	AAPL	Stock	12.2886	12.2886	12.2879	12.2879	24612.0
2011-02-02 18:00:00	AAPL	Stock	12.2893	12.2971	12.2875	12.2875	48860.0
2011-02-02 18:30:00	AAPL	Stock	12.2875	12.2907	12.2875	12.2882	44380.0
2011-02-02 19:00:00	AAPL	Stock	12.2875	12.2893	12.2821	12.2854	98728.0
2011-02-02 19:30:00	AAPL	Stock	12.2832	12.2886	12.2821	12.285	111748.0
2011-02-02 04:00:00	MSFT	Stock	28.13	28.13	28.13	28.13	100.0
2011-02-02 05:30:00	MSFT	Stock	28.15	28.15	28.15	28.15	100.0
2011-02-02 07:30:00	MSFT	Stock	27.99	28.03	27.98	27.98	4000.0
2011-02-02 08:00:00	MSFT	Stock	27.97	28.05	27.87	27.95	18404.0
2011-02-02 08:30:00	MSFT	Stock	27.95	27.95	27.85	27.91	9271.0
2011-02-02 09:00:00	MSFT	Stock	27.88	27.93	27.87	27.93	7667.0
2011-02-02 09:30:00	MSFT	Stock	27.92	28.05	27.91	28.02	4853170.0
2011-02-02 10:00:00	MSFT	Stock	28.02	28.11	27.91	28.041	4984062.0
2011-02-02 10:30:00	MSFT	Stock	28.049	28.1	28.01	28.03	3126622.0
2011-02-02 11:00:00	MSFT	Stock	28.03	28.04	27.88	27.99	3142912.0
2011-02-02 11:30:00	MSFT	Stock	27.985	28.08	27.96	28.078	3273477.0
2011-02-02 12:00:00	MSFT	Stock	28.08	28.08	27.98	27.99	2209009.0
2011-02-02 12:30:00	MSFT	Stock	27.99	28.01	27.96	27.99	2290033.0
2011-02-02 13:00:00	MSFT	Stock	27.992	28.01	27.94	27.97	2535382.0
2011-02-02 13:30:00	MSFT	Stock	27.97	28.01	27.97	28.0	2394198.0
2011-02-02 14:00:00	MSFT	Stock	28.005	28.04	27.99	28.03	2063637.0
2011-02-02 14:30:00	MSFT	Stock	28.04	28.06	27.98	28.05	2536969.0
2011-02-02 15:00:00	MSFT	Stock	28.04	28.05	27.93	27.941	2556617.0
2011-02-02 15:30:00	MSFT	Stock	27.95	27.99	27.89	27.94	7139227.0
2011-02-02 16:00:00	MSFT	Stock	27.94	28.01	27.91	27.91	1345466.0

> showing 50 of 76,143 rows — these rows as CSV

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