PREVIEW / stock_30min / 2013-07-24

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-07-24.parquet
  size:    1.5 MB
  rows:    78,275
  symbols: 3,502

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-07-24 04:00:00	AAPL	Stock	15.5	15.5357	15.5	15.5357	215824.0
2013-07-24 04:30:00	AAPL	Stock	15.5429	15.5632	15.5429	15.5632	5600.0
2013-07-24 05:00:00	AAPL	Stock	15.5107	15.5107	15.5	15.5086	27188.0
2013-07-24 05:30:00	AAPL	Stock	15.5357	15.5625	15.5357	15.5621	71400.0
2013-07-24 06:00:00	AAPL	Stock	15.5536	15.56	15.5536	15.5536	26124.0
2013-07-24 06:30:00	AAPL	Stock	15.5446	15.5836	15.5	15.5836	70616.0
2013-07-24 07:00:00	AAPL	Stock	15.575	15.6464	15.5714	15.6286	645204.0
2013-07-24 07:30:00	AAPL	Stock	15.6425	15.7232	15.6071	15.6964	1758820.0
2013-07-24 08:00:00	AAPL	Stock	15.6786	15.7089	15.5714	15.6536	3046288.0
2013-07-24 08:30:00	AAPL	Stock	15.6514	15.7039	15.6482	15.6846	3048360.0
2013-07-24 09:00:00	AAPL	Stock	15.6843	15.7143	15.6343	15.6786	3917676.0
2013-07-24 09:30:00	AAPL	Stock	15.6761	15.7321	15.545	15.6107	128477888.0
2013-07-24 10:00:00	AAPL	Stock	15.6114	15.7439	15.5771	15.7039	77522704.0
2013-07-24 10:30:00	AAPL	Stock	15.7025	15.8654	15.6864	15.8339	74213776.0
2013-07-24 11:00:00	AAPL	Stock	15.8296	15.8739	15.8111	15.8696	39432736.0
2013-07-24 11:30:00	AAPL	Stock	15.868	15.8732	15.8036	15.8107	26899292.0
2013-07-24 12:00:00	AAPL	Stock	15.8111	15.8329	15.7618	15.7707	28375200.0
2013-07-24 12:30:00	AAPL	Stock	15.7725	15.8314	15.7618	15.8279	19723228.0
2013-07-24 13:00:00	AAPL	Stock	15.83	15.8389	15.7786	15.8018	17518956.0
2013-07-24 13:30:00	AAPL	Stock	15.8032	15.8089	15.7446	15.7971	18700220.0
2013-07-24 14:00:00	AAPL	Stock	15.795	15.8632	15.79	15.8586	24350760.0
2013-07-24 14:30:00	AAPL	Stock	15.8586	15.8782	15.8161	15.8368	26230260.0
2013-07-24 15:00:00	AAPL	Stock	15.8375	15.8407	15.7786	15.7821	21297304.0
2013-07-24 15:30:00	AAPL	Stock	15.78	15.7989	15.725	15.7375	49882952.0
2013-07-24 16:00:00	AAPL	Stock	15.7361	15.8248	15.7325	15.7361	11874968.0
2013-07-24 16:30:00	AAPL	Stock	15.7682	15.7801	15.7325	15.7707	836780.0
2013-07-24 17:00:00	AAPL	Stock	15.7725	15.8218	15.75	15.7686	301924.0
2013-07-24 17:30:00	AAPL	Stock	15.7732	15.7732	15.7686	15.7714	43596.0
2013-07-24 18:00:00	AAPL	Stock	15.7768	15.7857	15.7625	15.7707	19460.0
2013-07-24 18:30:00	AAPL	Stock	15.7643	15.7643	15.7643	15.7643	9492.0
2013-07-24 19:00:00	AAPL	Stock	15.7661	15.7714	15.7661	15.7714	26628.0
2013-07-24 19:30:00	AAPL	Stock	15.7679	15.7757	15.7575	15.7714	84560.0
2013-07-24 06:30:00	MSFT	Stock	31.93	31.93	31.93	31.93	100.0
2013-07-24 07:00:00	MSFT	Stock	31.94	31.94	31.93	31.93	995.0
2013-07-24 07:30:00	MSFT	Stock	31.93	31.95	31.93	31.95	1197.0
2013-07-24 08:00:00	MSFT	Stock	31.91	31.98	31.91	31.98	9919.0
2013-07-24 08:30:00	MSFT	Stock	31.92	31.97	31.89	31.9	12288.0
2013-07-24 09:00:00	MSFT	Stock	31.94	32.07	31.91	32.07	72485.0
2013-07-24 09:30:00	MSFT	Stock	32.07	32.19	31.96	32.0	9291724.0
2013-07-24 10:00:00	MSFT	Stock	31.99	32.01	31.89	31.999	5464852.0
2013-07-24 10:30:00	MSFT	Stock	31.99	32.1	31.97	32.044	3086058.0
2013-07-24 11:00:00	MSFT	Stock	32.045	32.06	31.95	31.964	3873595.0
2013-07-24 11:30:00	MSFT	Stock	31.97	32.08	31.95	32.01	4105868.0
2013-07-24 12:00:00	MSFT	Stock	32.01	32.02	31.95	32.0	2355363.0
2013-07-24 12:30:00	MSFT	Stock	32.0	32.0	31.95	31.98	1695067.0
2013-07-24 13:00:00	MSFT	Stock	31.99	32.0	31.94	31.99	1627437.0
2013-07-24 13:30:00	MSFT	Stock	31.99	31.995	31.93	31.965	1529101.0
2013-07-24 14:00:00	MSFT	Stock	31.97	32.03	31.96	31.99	2427277.0
2013-07-24 14:30:00	MSFT	Stock	31.995	32.02	31.93	31.973	1985334.0
2013-07-24 15:00:00	MSFT	Stock	31.98	32.01	31.94	32.005	2038938.0

> showing 50 of 78,275 rows — these rows as CSV

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