PREVIEW / stock_30min / 2013-08-15

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-08-15.parquet
  size:    1.6 MB
  rows:    82,108
  symbols: 3,551

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-08-15 04:00:00	AAPL	Stock	17.7414	17.8925	17.7414	17.8925	46956.0
2013-08-15 04:30:00	AAPL	Stock	17.875	17.875	17.8461	17.8461	47040.0
2013-08-15 05:00:00	AAPL	Stock	17.8571	17.8782	17.8471	17.8571	49000.0
2013-08-15 05:30:00	AAPL	Stock	17.8571	17.8818	17.8571	17.875	43960.0
2013-08-15 06:00:00	AAPL	Stock	17.875	17.8854	17.8461	17.8568	117404.0
2013-08-15 06:30:00	AAPL	Stock	17.8525	17.8625	17.8286	17.8286	45500.0
2013-08-15 07:00:00	AAPL	Stock	17.8214	17.855	17.7982	17.8025	429100.0
2013-08-15 07:30:00	AAPL	Stock	17.7939	17.8214	17.7536	17.7657	731024.0
2013-08-15 08:00:00	AAPL	Stock	17.7554	17.8557	17.6661	17.6754	2656584.0
2013-08-15 08:30:00	AAPL	Stock	17.6686	17.6732	17.5932	17.6286	3844008.0
2013-08-15 09:00:00	AAPL	Stock	17.6343	17.7521	17.6296	17.7496	3931844.0
2013-08-15 09:30:00	AAPL	Stock	17.7496	17.85	17.6339	17.7329	96522384.0
2013-08-15 10:00:00	AAPL	Stock	17.7264	17.7618	17.6379	17.7429	50888516.0
2013-08-15 10:30:00	AAPL	Stock	17.7429	17.7507	17.6857	17.7152	24956680.0
2013-08-15 11:00:00	AAPL	Stock	17.7089	17.8532	17.6936	17.8325	35310828.0
2013-08-15 11:30:00	AAPL	Stock	17.8357	17.9214	17.8314	17.8754	39212656.0
2013-08-15 12:00:00	AAPL	Stock	17.8719	17.9157	17.8493	17.9005	18731888.0
2013-08-15 12:30:00	AAPL	Stock	17.9004	17.9428	17.8786	17.9111	19650176.0
2013-08-15 13:00:00	AAPL	Stock	17.9071	17.9179	17.77	17.8637	29428224.0
2013-08-15 13:30:00	AAPL	Stock	17.8643	17.8657	17.79	17.8182	15002988.0
2013-08-15 14:00:00	AAPL	Stock	17.8175	17.8796	17.7704	17.8439	21136976.0
2013-08-15 14:30:00	AAPL	Stock	17.8439	17.8839	17.8411	17.8554	16199344.0
2013-08-15 15:00:00	AAPL	Stock	17.8571	17.8575	17.7372	17.7875	28910700.0
2013-08-15 15:30:00	AAPL	Stock	17.7871	17.8189	17.7575	17.782	27070652.0
2013-08-15 16:00:00	AAPL	Stock	17.7854	17.8933	17.7618	17.7618	42262108.0
2013-08-15 16:30:00	AAPL	Stock	17.7743	17.7893	17.7611	17.7711	348432.0
2013-08-15 17:00:00	AAPL	Stock	17.7893	17.7893	17.7696	17.7814	251356.0
2013-08-15 17:30:00	AAPL	Stock	17.7846	17.7893	17.7746	17.7818	219968.0
2013-08-15 18:00:00	AAPL	Stock	17.7821	17.7993	17.7786	17.7993	221872.0
2013-08-15 18:30:00	AAPL	Stock	17.8018	17.8018	17.7857	17.7857	124712.0
2013-08-15 19:00:00	AAPL	Stock	17.7918	17.7929	17.7871	17.7918	28028.0
2013-08-15 19:30:00	AAPL	Stock	17.7857	17.8054	17.7789	17.7911	151844.0
2013-08-15 05:00:00	MSFT	Stock	32.22	32.22	32.22	32.22	800.0
2013-08-15 05:30:00	MSFT	Stock	32.2	32.2	32.2	32.2	900.0
2013-08-15 06:30:00	MSFT	Stock	32.1	32.1	32.1	32.1	200.0
2013-08-15 07:30:00	MSFT	Stock	32.12	32.12	32.01	32.01	892.0
2013-08-15 08:00:00	MSFT	Stock	32.01	32.15	32.01	32.15	1102.0
2013-08-15 08:30:00	MSFT	Stock	32.1	32.1	32.01	32.02	71375.0
2013-08-15 09:00:00	MSFT	Stock	32.0	32.04	31.93	31.97	18169.0
2013-08-15 09:30:00	MSFT	Stock	31.97	32.18	31.75	31.818	4483884.0
2013-08-15 10:00:00	MSFT	Stock	31.81	31.885	31.66	31.825	4591341.0
2013-08-15 10:30:00	MSFT	Stock	31.825	31.83	31.69	31.775	3064616.0
2013-08-15 11:00:00	MSFT	Stock	31.78	32.0	31.77	31.91	2562631.0
2013-08-15 11:30:00	MSFT	Stock	31.92	31.94	31.81	31.83	1475121.0
2013-08-15 12:00:00	MSFT	Stock	31.84	31.97	31.835	31.926	1079207.0
2013-08-15 12:30:00	MSFT	Stock	31.93	31.96	31.822	31.84	1390412.0
2013-08-15 13:00:00	MSFT	Stock	31.84	31.85	30.84	31.786	1278823.0
2013-08-15 13:30:00	MSFT	Stock	31.78	31.87	31.73	31.765	1105220.0
2013-08-15 14:00:00	MSFT	Stock	31.76	31.78	31.65	31.67	1814621.0
2013-08-15 14:30:00	MSFT	Stock	31.675	31.83	31.67	31.79	1588775.0

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

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