PREVIEW / stock_30min / 2013-05-13

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-05-13.parquet
  size:    1.5 MB
  rows:    76,905
  symbols: 3,503

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-13 04:00:00	AAPL	Stock	16.1607	16.1607	16.1607	16.1607	2800.0
2013-05-13 05:30:00	AAPL	Stock	16.0964	16.0964	16.0964	16.0964	2800.0
2013-05-13 06:00:00	AAPL	Stock	16.0739	16.0743	16.0739	16.0739	15400.0
2013-05-13 06:30:00	AAPL	Stock	16.0643	16.0643	16.0643	16.0643	2800.0
2013-05-13 07:00:00	AAPL	Stock	16.0732	16.0861	16.0732	16.0861	45136.0
2013-05-13 07:30:00	AAPL	Stock	16.0911	16.125	16.0911	16.125	148568.0
2013-05-13 08:00:00	AAPL	Stock	16.1421	16.145	16.0661	16.1321	822192.0
2013-05-13 08:30:00	AAPL	Stock	16.14	16.2464	16.1339	16.2179	1909152.0
2013-05-13 09:00:00	AAPL	Stock	16.2211	16.2454	16.1275	16.1275	2151828.0
2013-05-13 09:30:00	AAPL	Stock	16.1254	16.35	16.125	16.2357	72593472.0
2013-05-13 10:00:00	AAPL	Stock	16.235	16.2696	16.1904	16.2352	26166000.0
2013-05-13 10:30:00	AAPL	Stock	16.2361	16.2836	16.2332	16.2491	14560364.0
2013-05-13 11:00:00	AAPL	Stock	16.2489	16.2557	16.179	16.205	16020060.0
2013-05-13 11:30:00	AAPL	Stock	16.205	16.2532	16.1961	16.2525	14952980.0
2013-05-13 12:00:00	AAPL	Stock	16.2529	16.3207	16.2371	16.3061	19191284.0
2013-05-13 12:30:00	AAPL	Stock	16.3061	16.3536	16.3014	16.3237	20378036.0
2013-05-13 13:00:00	AAPL	Stock	16.3202	16.3411	16.2925	16.3146	11979632.0
2013-05-13 13:30:00	AAPL	Stock	16.3146	16.3161	16.2739	16.2942	10075352.0
2013-05-13 14:00:00	AAPL	Stock	16.2932	16.3381	16.2857	16.3036	11480728.0
2013-05-13 14:30:00	AAPL	Stock	16.3036	16.3168	16.2904	16.3004	9717820.0
2013-05-13 15:00:00	AAPL	Stock	16.3041	16.3041	16.2256	16.2411	16534420.0
2013-05-13 15:30:00	AAPL	Stock	16.24	16.2743	16.2254	16.2407	27870780.0
2013-05-13 16:00:00	AAPL	Stock	16.2407	16.2666	16.2346	16.25	21960260.0
2013-05-13 16:30:00	AAPL	Stock	16.25	16.25	16.2407	16.25	1266636.0
2013-05-13 17:00:00	AAPL	Stock	16.2407	16.25	16.2407	16.2407	236600.0
2013-05-13 17:30:00	AAPL	Stock	16.2446	16.25	16.2432	16.25	19152.0
2013-05-13 18:00:00	AAPL	Stock	16.2411	16.2461	16.2411	16.2411	63140.0
2013-05-13 18:30:00	AAPL	Stock	16.2429	16.25	16.2429	16.25	13496.0
2013-05-13 19:00:00	AAPL	Stock	16.25	16.255	16.25	16.255	26656.0
2013-05-13 19:30:00	AAPL	Stock	16.2536	16.2593	16.25	16.2589	122136.0
2013-05-13 07:00:00	MSFT	Stock	32.69	32.69	32.69	32.69	1000.0
2013-05-13 07:30:00	MSFT	Stock	32.65	32.65	32.65	32.65	1600.0
2013-05-13 08:00:00	MSFT	Stock	32.61	32.65	32.61	32.65	8376.0
2013-05-13 08:30:00	MSFT	Stock	32.66	32.71	32.64	32.68	3300.0
2013-05-13 09:00:00	MSFT	Stock	32.68	32.69	32.6	32.61	30090.0
2013-05-13 09:30:00	MSFT	Stock	32.56	32.9	32.55	32.8	4197254.0
2013-05-13 10:00:00	MSFT	Stock	32.79	32.9	32.71	32.8	3468000.0
2013-05-13 10:30:00	MSFT	Stock	32.79	32.86	32.75	32.758	2183075.0
2013-05-13 11:00:00	MSFT	Stock	32.75	32.78	32.68	32.75	2017253.0
2013-05-13 11:30:00	MSFT	Stock	32.745	32.81	32.69	32.76	1498746.0
2013-05-13 12:00:00	MSFT	Stock	32.77	32.78	32.73	32.763	941227.0
2013-05-13 12:30:00	MSFT	Stock	32.77	32.81	32.74	32.75	928646.0
2013-05-13 13:00:00	MSFT	Stock	32.75	32.77	32.74	32.75	1326130.0
2013-05-13 13:30:00	MSFT	Stock	32.74	32.77	32.71	32.758	1509940.0
2013-05-13 14:00:00	MSFT	Stock	32.75	32.82	32.74	32.8	1075199.0
2013-05-13 14:30:00	MSFT	Stock	32.804	32.97	32.795	32.935	3000346.0
2013-05-13 15:00:00	MSFT	Stock	32.935	32.97	32.87	32.904	2656310.0
2013-05-13 15:30:00	MSFT	Stock	32.905	33.07	32.9	33.06	7402348.0
2013-05-13 16:00:00	MSFT	Stock	33.03	33.06	32.803	32.83	2117502.0
2013-05-13 16:30:00	MSFT	Stock	33.05	33.07	33.03	33.03	383639.0

> showing 50 of 76,905 rows — these rows as CSV

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