PREVIEW / stock_30min / 2013-05-02

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-05-02.parquet
  size:    1.5 MB
  rows:    78,658
  symbols: 3,482

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-05-02 05:00:00	AAPL	Stock	15.7171	15.7171	15.7171	15.7171	2800.0
2013-05-02 06:00:00	AAPL	Stock	15.7411	15.7479	15.7411	15.7479	8400.0
2013-05-02 06:30:00	AAPL	Stock	15.7482	15.75	15.7407	15.75	32312.0
2013-05-02 07:00:00	AAPL	Stock	15.7675	15.7821	15.7554	15.7821	200424.0
2013-05-02 07:30:00	AAPL	Stock	15.7796	15.84	15.7711	15.825	715820.0
2013-05-02 08:00:00	AAPL	Stock	15.825	15.8346	15.7607	15.8036	1172724.0
2013-05-02 08:30:00	AAPL	Stock	15.8089	15.8393	15.7964	15.8086	1938720.0
2013-05-02 09:00:00	AAPL	Stock	15.8089	15.8107	15.7718	15.7779	1963724.0
2013-05-02 09:30:00	AAPL	Stock	15.7804	15.9748	15.7368	15.8846	82939388.0
2013-05-02 10:00:00	AAPL	Stock	15.8807	15.9885	15.875	15.9386	42388472.0
2013-05-02 10:30:00	AAPL	Stock	15.9371	15.9832	15.9197	15.9489	25508756.0
2013-05-02 11:00:00	AAPL	Stock	15.9496	15.9854	15.9164	15.9779	26859840.0
2013-05-02 11:30:00	AAPL	Stock	15.9757	16.01	15.9582	15.9832	33100060.0
2013-05-02 12:00:00	AAPL	Stock	15.9832	15.9907	15.9307	15.9485	16813076.0
2013-05-02 12:30:00	AAPL	Stock	15.9452	15.97	15.9407	15.9621	15268596.0
2013-05-02 13:00:00	AAPL	Stock	15.965	16.0061	15.9571	15.9866	22272012.0
2013-05-02 13:30:00	AAPL	Stock	15.9857	16.0161	15.975	15.995	18964428.0
2013-05-02 14:00:00	AAPL	Stock	15.9947	16.0	15.9746	15.995	11808972.0
2013-05-02 14:30:00	AAPL	Stock	15.9959	16.0211	15.975	15.9939	21496272.0
2013-05-02 15:00:00	AAPL	Stock	15.9939	15.9975	15.9586	15.9841	23479092.0
2013-05-02 15:30:00	AAPL	Stock	15.985	15.9875	15.9111	15.913	37737140.0
2013-05-02 16:00:00	AAPL	Stock	15.9129	16.0079	15.905	15.9168	6690208.0
2013-05-02 16:30:00	AAPL	Stock	15.9157	15.9193	15.9011	15.9193	405916.0
2013-05-02 17:00:00	AAPL	Stock	15.9221	15.969	15.9114	15.9275	390124.0
2013-05-02 17:30:00	AAPL	Stock	15.9264	15.9275	15.9114	15.9261	155596.0
2013-05-02 18:00:00	AAPL	Stock	15.9171	15.9204	15.9114	15.9129	35476.0
2013-05-02 18:30:00	AAPL	Stock	15.9143	15.9239	15.9143	15.915	76020.0
2013-05-02 19:00:00	AAPL	Stock	15.9143	15.9189	15.9143	15.9182	22400.0
2013-05-02 19:30:00	AAPL	Stock	15.9125	15.9254	15.9125	15.9254	94528.0
2013-05-02 07:00:00	MSFT	Stock	32.7	32.7	32.7	32.7	100.0
2013-05-02 07:30:00	MSFT	Stock	32.69	32.78	32.69	32.72	3911.0
2013-05-02 08:00:00	MSFT	Stock	32.73	32.78	32.73	32.76	6340.0
2013-05-02 08:30:00	MSFT	Stock	32.76	32.85	32.73	32.75	21527.0
2013-05-02 09:00:00	MSFT	Stock	32.75	32.79	32.55	32.64	125106.0
2013-05-02 09:30:00	MSFT	Stock	32.64	32.73	32.39	32.644	5582627.0
2013-05-02 10:00:00	MSFT	Stock	32.65	32.71	32.545	32.67	2663026.0
2013-05-02 10:30:00	MSFT	Stock	32.67	32.72	32.61	32.67	2586664.0
2013-05-02 11:00:00	MSFT	Stock	32.67	32.71	32.64	32.68	3014380.0
2013-05-02 11:30:00	MSFT	Stock	32.68	32.72	32.66	32.69	1779694.0
2013-05-02 12:00:00	MSFT	Stock	32.69	32.77	32.685	32.735	2525851.0
2013-05-02 12:30:00	MSFT	Stock	32.73	32.96	32.73	32.95	2736585.0
2013-05-02 13:00:00	MSFT	Stock	32.945	33.09	32.915	33.044	3123801.0
2013-05-02 13:30:00	MSFT	Stock	33.04	33.1	33.02	33.09	2675200.0
2013-05-02 14:00:00	MSFT	Stock	33.09	33.12	33.06	33.066	2699423.0
2013-05-02 14:30:00	MSFT	Stock	33.06	33.12	33.025	33.1	2465920.0
2013-05-02 15:00:00	MSFT	Stock	33.1	33.13	33.02	33.042	3196245.0
2013-05-02 15:30:00	MSFT	Stock	33.05	33.17	33.03	33.16	7433146.0
2013-05-02 16:00:00	MSFT	Stock	33.16	33.2	32.61	33.13	1653333.0
2013-05-02 16:30:00	MSFT	Stock	33.15	33.16	33.09	33.16	7893.0
2013-05-02 17:00:00	MSFT	Stock	33.15	33.16	33.15	33.15	3863.0

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

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