PREVIEW / stock_30min / 2013-10-24

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-10-24.parquet
  size:    1.6 MB
  rows:    82,096
  symbols: 3,534

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-24 04:00:00	AAPL	Stock	18.7857	18.8179	18.7857	18.8179	18200.0
2013-10-24 05:00:00	AAPL	Stock	18.8036	18.8036	18.8036	18.8036	14000.0
2013-10-24 05:30:00	AAPL	Stock	18.8232	18.8532	18.8125	18.8125	20356.0
2013-10-24 06:00:00	AAPL	Stock	18.8393	18.8393	18.8175	18.8393	51380.0
2013-10-24 06:30:00	AAPL	Stock	18.8357	18.8557	18.8357	18.8557	63224.0
2013-10-24 07:00:00	AAPL	Stock	18.8721	18.8829	18.8271	18.8271	322504.0
2013-10-24 07:30:00	AAPL	Stock	18.8293	18.8321	18.7839	18.7839	272832.0
2013-10-24 08:00:00	AAPL	Stock	18.7686	18.8571	18.7321	18.7857	837816.0
2013-10-24 08:30:00	AAPL	Stock	18.7871	18.8036	18.7411	18.7643	1305136.0
2013-10-24 09:00:00	AAPL	Stock	18.75	18.8282	18.7218	18.7496	2865044.0
2013-10-24 09:30:00	AAPL	Stock	18.75	18.7857	18.6589	18.7089	42782208.0
2013-10-24 10:00:00	AAPL	Stock	18.7157	18.7679	18.7	18.7289	26981752.0
2013-10-24 10:30:00	AAPL	Stock	18.7268	18.8354	18.7196	18.8086	25195184.0
2013-10-24 11:00:00	AAPL	Stock	18.8077	18.9086	18.8011	18.8754	30618196.0
2013-10-24 11:30:00	AAPL	Stock	18.8814	18.9811	18.8764	18.9679	38701376.0
2013-10-24 12:00:00	AAPL	Stock	18.967	18.9893	18.9236	18.9589	27768860.0
2013-10-24 12:30:00	AAPL	Stock	18.96	18.9675	18.8786	18.9443	27657924.0
2013-10-24 13:00:00	AAPL	Stock	18.9446	18.9657	18.9304	18.952	11693808.0
2013-10-24 13:30:00	AAPL	Stock	18.952	18.9707	18.9211	18.9395	11258408.0
2013-10-24 14:00:00	AAPL	Stock	18.9417	18.9954	18.9358	18.9896	17265752.0
2013-10-24 14:30:00	AAPL	Stock	18.9889	19.0157	18.9761	19.0118	20042148.0
2013-10-24 15:00:00	AAPL	Stock	19.0111	19.0157	18.9936	19.0114	15586508.0
2013-10-24 15:30:00	AAPL	Stock	19.0118	19.0168	18.9479	18.9955	32358788.0
2013-10-24 16:00:00	AAPL	Stock	18.9979	19.0514	18.7993	19.0357	8372756.0
2013-10-24 16:30:00	AAPL	Stock	19.0375	19.0982	18.7225	19.0875	5465096.0
2013-10-24 17:00:00	AAPL	Stock	19.0946	19.095	18.9968	19.0729	32569096.0
2013-10-24 17:30:00	AAPL	Stock	19.0696	19.0718	19.0643	19.0718	103040.0
2013-10-24 18:00:00	AAPL	Stock	19.0679	19.075	18.9979	18.9979	80220.0
2013-10-24 18:30:00	AAPL	Stock	19.0661	19.0714	19.0629	19.0696	54628.0
2013-10-24 19:00:00	AAPL	Stock	19.0643	19.0718	19.0546	19.0586	239624.0
2013-10-24 19:30:00	AAPL	Stock	19.0536	19.0682	19.0536	19.0679	182364.0
2013-10-24 07:30:00	MSFT	Stock	33.89	33.89	33.89	33.89	200.0
2013-10-24 08:00:00	MSFT	Stock	34.0	34.02	33.82	33.89	18000.0
2013-10-24 08:30:00	MSFT	Stock	33.89	33.89	33.75	33.75	60627.0
2013-10-24 09:00:00	MSFT	Stock	33.71	33.79	33.7	33.79	23400.0
2013-10-24 09:30:00	MSFT	Stock	33.79	33.87	33.57	33.72	6058666.0
2013-10-24 10:00:00	MSFT	Stock	33.713	34.035	33.71	33.955	4289449.0
2013-10-24 10:30:00	MSFT	Stock	33.955	34.1	33.93	34.015	2908622.0
2013-10-24 11:00:00	MSFT	Stock	34.02	34.08	33.95	34.045	2220380.0
2013-10-24 11:30:00	MSFT	Stock	34.05	34.08	33.94	33.955	2018217.0
2013-10-24 12:00:00	MSFT	Stock	33.95	34.03	33.91	34.004	1525956.0
2013-10-24 12:30:00	MSFT	Stock	34.001	34.08	33.98	34.05	2620362.0
2013-10-24 13:00:00	MSFT	Stock	34.055	34.08	34.0	34.055	1576598.0
2013-10-24 13:30:00	MSFT	Stock	34.058	34.06	33.99	34.009	2882346.0
2013-10-24 14:00:00	MSFT	Stock	34.0	34.01	33.92	33.968	1869466.0
2013-10-24 14:30:00	MSFT	Stock	33.97	33.978	33.92	33.937	1938656.0
2013-10-24 15:00:00	MSFT	Stock	33.94	33.94	33.78	33.8	3553482.0
2013-10-24 15:30:00	MSFT	Stock	33.805	33.85	33.72	33.72	8666641.0
2013-10-24 16:00:00	MSFT	Stock	33.73	36.21	33.716	35.7	7595637.0
2013-10-24 16:30:00	MSFT	Stock	35.7	35.89	33.73	35.65	687870.0

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

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