PREVIEW / stock_30min / 2011-04-20

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-04-20.parquet
  size:    1.5 MB
  rows:    79,561
  symbols: 3,546

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-04-20 04:00:00	AAPL	Stock	12.1393	12.225	12.1393	12.225	28840.0
2011-04-20 04:30:00	AAPL	Stock	12.225	12.2346	12.2143	12.2346	49000.0
2011-04-20 05:00:00	AAPL	Stock	12.2464	12.2571	12.2346	12.2504	64120.0
2011-04-20 05:30:00	AAPL	Stock	12.2679	12.2679	12.2596	12.2639	22400.0
2011-04-20 06:00:00	AAPL	Stock	12.2529	12.2929	12.2529	12.2857	97020.0
2011-04-20 06:30:00	AAPL	Stock	12.2857	12.3114	12.2857	12.2857	159404.0
2011-04-20 07:00:00	AAPL	Stock	12.2857	12.2857	12.2446	12.2607	681576.0
2011-04-20 07:30:00	AAPL	Stock	12.2571	12.2643	12.2261	12.2357	519932.0
2011-04-20 08:00:00	AAPL	Stock	12.2364	12.2536	12.2061	12.2393	1960084.0
2011-04-20 08:30:00	AAPL	Stock	12.2393	12.2721	12.2375	12.2518	2551612.0
2011-04-20 09:00:00	AAPL	Stock	12.2525	12.2714	12.2375	12.2714	2741564.0
2011-04-20 09:30:00	AAPL	Stock	12.2725	12.2825	12.1964	12.2625	93187164.0
2011-04-20 10:00:00	AAPL	Stock	12.2625	12.3482	12.26	12.3161	79877364.0
2011-04-20 10:30:00	AAPL	Stock	12.3164	12.3336	12.3029	12.3129	35567812.0
2011-04-20 11:00:00	AAPL	Stock	12.3118	12.3186	12.2654	12.2844	30856000.0
2011-04-20 11:30:00	AAPL	Stock	12.2832	12.3	12.28	12.2904	20169548.0
2011-04-20 12:00:00	AAPL	Stock	12.2904	12.3018	12.2843	12.2979	16995664.0
2011-04-20 12:30:00	AAPL	Stock	12.2979	12.3107	12.2914	12.2993	20312656.0
2011-04-20 13:00:00	AAPL	Stock	12.2989	12.3143	12.2964	12.3125	23717736.0
2011-04-20 13:30:00	AAPL	Stock	12.3125	12.3214	12.3068	12.315	17169460.0
2011-04-20 14:00:00	AAPL	Stock	12.3143	12.3193	12.2946	12.3132	20025040.0
2011-04-20 14:30:00	AAPL	Stock	12.3132	12.3179	12.2857	12.2864	24373440.0
2011-04-20 15:00:00	AAPL	Stock	12.2864	12.2884	12.2107	12.2636	63194712.0
2011-04-20 15:30:00	AAPL	Stock	12.2646	12.2661	12.2268	12.2271	71190448.0
2011-04-20 16:00:00	AAPL	Stock	12.2318	12.3064	12.2143	12.2854	17483228.0
2011-04-20 16:30:00	AAPL	Stock	12.2854	12.6211	12.23	12.5321	85169616.0
2011-04-20 17:00:00	AAPL	Stock	12.5318	12.6786	12.2293	12.6532	27104896.0
2011-04-20 17:30:00	AAPL	Stock	12.6536	12.7668	12.2293	12.7257	19361384.0
2011-04-20 18:00:00	AAPL	Stock	12.7254	12.7429	12.2289	12.6871	4009012.0
2011-04-20 18:30:00	AAPL	Stock	12.6879	12.6946	12.6332	12.6418	3182284.0
2011-04-20 19:00:00	AAPL	Stock	12.6425	12.6468	12.6132	12.6161	1964424.0
2011-04-20 19:30:00	AAPL	Stock	12.6168	12.6604	12.6071	12.6079	2506392.0
2011-04-20 04:30:00	MSFT	Stock	25.5	25.5	25.5	25.5	400.0
2011-04-20 05:00:00	MSFT	Stock	25.45	25.5	25.45	25.5	2100.0
2011-04-20 05:30:00	MSFT	Stock	25.54	25.54	25.52	25.52	500.0
2011-04-20 06:00:00	MSFT	Stock	25.53	25.53	25.53	25.53	100.0
2011-04-20 06:30:00	MSFT	Stock	25.51	25.58	25.51	25.57	2500.0
2011-04-20 07:00:00	MSFT	Stock	25.58	25.75	25.58	25.62	18300.0
2011-04-20 07:30:00	MSFT	Stock	25.64	25.7	25.5	25.6	35477.0
2011-04-20 08:00:00	MSFT	Stock	25.6	25.6	25.52	25.6	85788.0
2011-04-20 08:30:00	MSFT	Stock	25.6	25.6	25.55	25.55	21150.0
2011-04-20 09:00:00	MSFT	Stock	25.56	25.7	25.55	25.55	228063.0
2011-04-20 09:30:00	MSFT	Stock	25.55	25.75	25.51	25.715	8742477.0
2011-04-20 10:00:00	MSFT	Stock	25.71	25.9	25.67	25.84	6170275.0
2011-04-20 10:30:00	MSFT	Stock	25.84	25.94	25.83	25.93	5320710.0
2011-04-20 11:00:00	MSFT	Stock	25.92	25.93	25.83	25.925	4157539.0
2011-04-20 11:30:00	MSFT	Stock	25.92	26.0	25.91	25.97	2855623.0
2011-04-20 12:00:00	MSFT	Stock	25.96	26.0	25.94	25.965	3459190.0
2011-04-20 12:30:00	MSFT	Stock	25.964	25.98	25.88	25.91	2186887.0
2011-04-20 13:00:00	MSFT	Stock	25.9	25.93	25.845	25.86	2443771.0

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

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