PREVIEW / stock_30min / 2013-10-17

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-10-17.parquet
  size:    1.6 MB
  rows:    82,222
  symbols: 3,522

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-10-17 04:30:00	AAPL	Stock	17.8939	17.8939	17.8939	17.8939	2800.0
2013-10-17 05:00:00	AAPL	Stock	17.8718	17.8718	17.8661	17.8661	22400.0
2013-10-17 05:30:00	AAPL	Stock	17.8643	17.8643	17.8607	17.8607	16800.0
2013-10-17 06:00:00	AAPL	Stock	17.8571	17.8843	17.8571	17.8843	15400.0
2013-10-17 06:30:00	AAPL	Stock	17.8961	17.9018	17.8961	17.9018	14000.0
2013-10-17 07:00:00	AAPL	Stock	17.8936	17.9439	17.8893	17.9268	208768.0
2013-10-17 07:30:00	AAPL	Stock	17.9286	17.935	17.9018	17.9054	241976.0
2013-10-17 08:00:00	AAPL	Stock	17.91	17.9464	17.81	17.875	1428420.0
2013-10-17 08:30:00	AAPL	Stock	17.8643	17.8868	17.8432	17.8679	465360.0
2013-10-17 09:00:00	AAPL	Stock	17.8568	17.8661	17.8214	17.8536	1191988.0
2013-10-17 09:30:00	AAPL	Stock	17.8536	17.9789	17.8457	17.9439	50166536.0
2013-10-17 10:00:00	AAPL	Stock	17.9493	18.0054	17.9189	17.9939	25713408.0
2013-10-17 10:30:00	AAPL	Stock	17.9886	18.0193	17.9611	17.9721	20212696.0
2013-10-17 11:00:00	AAPL	Stock	17.9725	17.9964	17.9718	17.99	11721108.0
2013-10-17 11:30:00	AAPL	Stock	17.9875	18.0171	17.9786	18.0058	15323840.0
2013-10-17 12:00:00	AAPL	Stock	18.0075	18.0161	17.9907	17.9971	9915584.0
2013-10-17 12:30:00	AAPL	Stock	17.9964	18.0268	17.9946	18.0254	9296140.0
2013-10-17 13:00:00	AAPL	Stock	18.0248	18.0279	17.965	17.975	13737528.0
2013-10-17 13:30:00	AAPL	Stock	17.9754	17.9918	17.9714	17.9771	5632480.0
2013-10-17 14:00:00	AAPL	Stock	17.9754	17.9964	17.9646	17.9936	7360640.0
2013-10-17 14:30:00	AAPL	Stock	17.9943	18.005	17.9739	17.9939	7919632.0
2013-10-17 15:00:00	AAPL	Stock	17.9927	18.0114	17.9857	18.0018	10906476.0
2013-10-17 15:30:00	AAPL	Stock	18.0025	18.0257	17.9996	18.0236	28271628.0
2013-10-17 16:00:00	AAPL	Stock	18.0236	18.0571	17.9793	18.0446	17788428.0
2013-10-17 16:30:00	AAPL	Stock	18.0482	18.0632	18.0236	18.0518	919436.0
2013-10-17 17:00:00	AAPL	Stock	18.0518	18.0893	18.05	18.0732	543788.0
2013-10-17 17:30:00	AAPL	Stock	18.0721	18.0786	18.0646	18.0707	162792.0
2013-10-17 18:00:00	AAPL	Stock	18.0764	18.0821	18.075	18.0821	134512.0
2013-10-17 18:30:00	AAPL	Stock	18.0821	18.0964	18.0821	18.0964	98420.0
2013-10-17 19:00:00	AAPL	Stock	18.0932	18.0982	18.0236	18.0964	204260.0
2013-10-17 19:30:00	AAPL	Stock	18.0961	18.1007	18.0893	18.0989	467460.0
2013-10-17 07:30:00	MSFT	Stock	34.6	34.6	34.6	34.6	100.0
2013-10-17 08:00:00	MSFT	Stock	34.62	34.62	34.5	34.5	7814.0
2013-10-17 08:30:00	MSFT	Stock	34.5	34.5	34.4	34.47	1050.0
2013-10-17 09:00:00	MSFT	Stock	34.44	34.5	34.4	34.5	7386.0
2013-10-17 09:30:00	MSFT	Stock	34.47	34.74	34.37	34.71	3558720.0
2013-10-17 10:00:00	MSFT	Stock	34.71	34.91	34.71	34.91	3012610.0
2013-10-17 10:30:00	MSFT	Stock	34.91	34.92	34.805	34.84	2571149.0
2013-10-17 11:00:00	MSFT	Stock	34.845	34.86	34.8	34.805	2053690.0
2013-10-17 11:30:00	MSFT	Stock	34.8	34.97	34.8	34.935	1553457.0
2013-10-17 12:00:00	MSFT	Stock	34.93	34.95	34.873	34.95	1453506.0
2013-10-17 12:30:00	MSFT	Stock	34.947	34.99	34.94	34.99	1024503.0
2013-10-17 13:00:00	MSFT	Stock	34.98	34.99	34.895	34.904	1335464.0
2013-10-17 13:30:00	MSFT	Stock	34.902	34.93	34.89	34.9	785764.0
2013-10-17 14:00:00	MSFT	Stock	34.91	34.92	34.8	34.875	1429422.0
2013-10-17 14:30:00	MSFT	Stock	34.873	34.95	34.84	34.92	1358850.0
2013-10-17 15:00:00	MSFT	Stock	34.917	34.97	34.91	34.94	1771305.0
2013-10-17 15:30:00	MSFT	Stock	34.94	34.96	34.88	34.92	6079407.0
2013-10-17 16:00:00	MSFT	Stock	34.93	35.01	34.853	34.937	2845859.0
2013-10-17 16:30:00	MSFT	Stock	34.93	34.94	34.9	34.93	155423.0

> showing 50 of 82,222 rows — these rows as CSV

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