PREVIEW / stock_30min / 2012-12-14

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-12-14.parquet
  size:    1.4 MB
  rows:    74,395
  symbols: 3,485

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
2012-12-14 04:00:00	AAPL	Stock	18.875	18.8921	18.875	18.8921	22400.0
2012-12-14 04:30:00	AAPL	Stock	18.8911	18.8911	18.8911	18.8911	2800.0
2012-12-14 05:00:00	AAPL	Stock	18.875	18.8871	18.8661	18.8661	55384.0
2012-12-14 05:30:00	AAPL	Stock	18.8571	18.8571	18.8221	18.8221	30100.0
2012-12-14 06:00:00	AAPL	Stock	18.8214	18.8354	18.7857	18.7943	38780.0
2012-12-14 06:30:00	AAPL	Stock	18.7929	18.7971	18.7679	18.7739	70952.0
2012-12-14 07:00:00	AAPL	Stock	18.7739	18.7864	18.6357	18.6375	976360.0
2012-12-14 07:30:00	AAPL	Stock	18.6393	18.6568	18.4814	18.4868	3161424.0
2012-12-14 08:00:00	AAPL	Stock	18.4904	18.6564	18.4868	18.5711	7434364.0
2012-12-14 08:30:00	AAPL	Stock	18.5711	18.5714	18.425	18.4282	7996856.0
2012-12-14 09:00:00	AAPL	Stock	18.4282	18.4721	18.3171	18.3839	19562228.0
2012-12-14 09:30:00	AAPL	Stock	18.3839	18.5047	18.1607	18.3277	234063424.0
2012-12-14 10:00:00	AAPL	Stock	18.3257	18.3989	18.2857	18.3636	73133088.0
2012-12-14 10:30:00	AAPL	Stock	18.3636	18.3704	18.235	18.2443	69916392.0
2012-12-14 11:00:00	AAPL	Stock	18.2411	18.2679	18.1307	18.1817	94586436.0
2012-12-14 11:30:00	AAPL	Stock	18.185	18.2696	18.1536	18.2287	60479356.0
2012-12-14 12:00:00	AAPL	Stock	18.2321	18.3111	18.2207	18.2956	42567000.0
2012-12-14 12:30:00	AAPL	Stock	18.2982	18.3089	18.2286	18.2379	25006520.0
2012-12-14 13:00:00	AAPL	Stock	18.2361	18.2561	18.1746	18.2157	31294872.0
2012-12-14 13:30:00	AAPL	Stock	18.2182	18.2282	18.175	18.2232	29493716.0
2012-12-14 14:00:00	AAPL	Stock	18.2269	18.2439	18.1821	18.1854	28895664.0
2012-12-14 14:30:00	AAPL	Stock	18.1854	18.2118	18.0718	18.0893	51481612.0
2012-12-14 15:00:00	AAPL	Stock	18.0893	18.1329	18.0564	18.0725	66455900.0
2012-12-14 15:30:00	AAPL	Stock	18.0722	18.2243	18.0607	18.1786	118621748.0
2012-12-14 16:00:00	AAPL	Stock	18.2143	18.2877	18.1307	18.1821	19312412.0
2012-12-14 16:30:00	AAPL	Stock	18.1761	18.1786	18.0761	18.1429	1117844.0
2012-12-14 17:00:00	AAPL	Stock	18.1457	18.2068	18.1196	18.125	3657472.0
2012-12-14 17:30:00	AAPL	Stock	18.1289	18.1357	18.1196	18.12	427868.0
2012-12-14 18:00:00	AAPL	Stock	18.1243	18.1357	18.1107	18.1357	254660.0
2012-12-14 18:30:00	AAPL	Stock	18.1257	18.1264	18.1157	18.1171	51660.0
2012-12-14 19:00:00	AAPL	Stock	18.1171	18.1286	18.1111	18.125	105756.0
2012-12-14 19:30:00	AAPL	Stock	18.125	18.1279	18.1161	18.125	410368.0
2012-12-14 04:30:00	MSFT	Stock	27.22	27.26	27.22	27.26	1830.0
2012-12-14 06:30:00	MSFT	Stock	27.18	27.18	27.18	27.18	100.0
2012-12-14 07:00:00	MSFT	Stock	27.19	27.19	27.17	27.17	1151.0
2012-12-14 07:30:00	MSFT	Stock	27.2	27.2	27.14	27.18	16100.0
2012-12-14 08:00:00	MSFT	Stock	27.12	27.2	27.05	27.1	15826.0
2012-12-14 08:30:00	MSFT	Stock	27.07	27.08	26.93	26.95	21270.0
2012-12-14 09:00:00	MSFT	Stock	27.0	27.15	26.93	27.14	67358.0
2012-12-14 09:30:00	MSFT	Stock	27.14	27.14	26.82	26.93	4255303.0
2012-12-14 10:00:00	MSFT	Stock	26.93	26.99	26.89	26.935	3734859.0
2012-12-14 10:30:00	MSFT	Stock	26.94	26.995	26.88	26.97	2506753.0
2012-12-14 11:00:00	MSFT	Stock	26.96	26.99	26.83	26.843	2915633.0
2012-12-14 11:30:00	MSFT	Stock	26.85	26.91	26.83	26.85	2906868.0
2012-12-14 12:00:00	MSFT	Stock	26.856	26.945	26.85	26.91	2104349.0
2012-12-14 12:30:00	MSFT	Stock	26.905	26.93	26.88	26.89	1467713.0
2012-12-14 13:00:00	MSFT	Stock	26.9	26.91	26.85	26.874	1148391.0
2012-12-14 13:30:00	MSFT	Stock	26.87	26.89	26.85	26.86	1814054.0
2012-12-14 14:00:00	MSFT	Stock	26.865	26.88	26.85	26.852	1909829.0
2012-12-14 14:30:00	MSFT	Stock	26.855	26.87	26.72	26.73	3005586.0

> showing 50 of 74,395 rows — these rows as CSV

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