PREVIEW / stock_30min / 2013-02-12

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-02-12.parquet
  size:    1.4 MB
  rows:    75,701
  symbols: 3,479

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-02-12 04:00:00	AAPL	Stock	17.1246	17.1246	17.1246	17.1246	2800.0
2013-02-12 05:30:00	AAPL	Stock	17.1071	17.15	17.1071	17.15	37212.0
2013-02-12 06:00:00	AAPL	Stock	17.1714	17.1714	17.1429	17.1464	22400.0
2013-02-12 06:30:00	AAPL	Stock	17.1689	17.1689	17.1071	17.1071	74228.0
2013-02-12 07:00:00	AAPL	Stock	17.0907	17.1143	17.0893	17.1064	65324.0
2013-02-12 07:30:00	AAPL	Stock	17.1071	17.1664	17.1071	17.1436	378476.0
2013-02-12 08:00:00	AAPL	Stock	17.1429	17.1607	17.0464	17.1011	925232.0
2013-02-12 08:30:00	AAPL	Stock	17.0996	17.1425	17.0732	17.1321	1100512.0
2013-02-12 09:00:00	AAPL	Stock	17.1325	17.1407	17.1043	17.1264	1586760.0
2013-02-12 09:30:00	AAPL	Stock	17.1254	17.2279	16.9843	16.9893	72246076.0
2013-02-12 10:00:00	AAPL	Stock	16.9894	17.1696	16.9832	17.106	61681732.0
2013-02-12 10:30:00	AAPL	Stock	17.1011	17.1196	16.9036	17.0071	66486280.0
2013-02-12 11:00:00	AAPL	Stock	17.005	17.0079	16.8014	16.8436	61647936.0
2013-02-12 11:30:00	AAPL	Stock	16.8404	16.8689	16.7093	16.8036	55385316.0
2013-02-12 12:00:00	AAPL	Stock	16.8043	16.8618	16.7609	16.8386	30077768.0
2013-02-12 12:30:00	AAPL	Stock	16.8378	16.9439	16.8343	16.9176	30265340.0
2013-02-12 13:00:00	AAPL	Stock	16.9196	16.9546	16.8704	16.9121	18949056.0
2013-02-12 13:30:00	AAPL	Stock	16.9096	16.9179	16.8149	16.8305	17344236.0
2013-02-12 14:00:00	AAPL	Stock	16.8304	16.86	16.7668	16.828	34487992.0
2013-02-12 14:30:00	AAPL	Stock	16.83	16.8571	16.7732	16.7732	21095088.0
2013-02-12 15:00:00	AAPL	Stock	16.7743	16.8021	16.7396	16.7532	30757748.0
2013-02-12 15:30:00	AAPL	Stock	16.7564	16.7607	16.7051	16.7086	55738900.0
2013-02-12 16:00:00	AAPL	Stock	16.7089	16.8981	16.6964	16.7032	11646992.0
2013-02-12 16:30:00	AAPL	Stock	16.7039	16.7541	16.7004	16.7089	431452.0
2013-02-12 17:00:00	AAPL	Stock	16.7089	16.7107	16.6929	16.7	810516.0
2013-02-12 17:30:00	AAPL	Stock	16.7004	16.7104	16.6964	16.7057	204708.0
2013-02-12 18:00:00	AAPL	Stock	16.7089	16.7089	16.6982	16.6982	85456.0
2013-02-12 18:30:00	AAPL	Stock	16.6982	16.7007	16.6736	16.6768	448952.0
2013-02-12 19:00:00	AAPL	Stock	16.6786	16.6793	16.6443	16.6443	473200.0
2013-02-12 19:30:00	AAPL	Stock	16.6479	16.6586	16.6393	16.6393	725788.0
2013-02-12 07:30:00	MSFT	Stock	27.87	27.87	27.87	27.87	100.0
2013-02-12 08:00:00	MSFT	Stock	27.76	27.9	27.75	27.83	13940.0
2013-02-12 08:30:00	MSFT	Stock	27.86	27.9	27.86	27.9	1500.0
2013-02-12 09:00:00	MSFT	Stock	27.88	27.9	27.85	27.85	8005.0
2013-02-12 09:30:00	MSFT	Stock	27.89	27.91	27.78	27.827	4035789.0
2013-02-12 10:00:00	MSFT	Stock	27.83	27.95	27.81	27.9	2895078.0
2013-02-12 10:30:00	MSFT	Stock	27.895	27.9	27.8	27.86	2833680.0
2013-02-12 11:00:00	MSFT	Stock	27.855	27.86	27.75	27.82	2576963.0
2013-02-12 11:30:00	MSFT	Stock	27.82	27.85	27.8	27.822	1669780.0
2013-02-12 12:00:00	MSFT	Stock	27.825	27.87	27.81	27.864	1490345.0
2013-02-12 12:30:00	MSFT	Stock	27.87	27.98	27.86	27.97	2235935.0
2013-02-12 13:00:00	MSFT	Stock	27.965	27.98	27.93	27.97	1520631.0
2013-02-12 13:30:00	MSFT	Stock	27.965	27.98	27.94	27.94	1183650.0
2013-02-12 14:00:00	MSFT	Stock	27.94	27.99	27.94	27.972	1351502.0
2013-02-12 14:30:00	MSFT	Stock	27.98	28.0	27.92	27.95	2876524.0
2013-02-12 15:00:00	MSFT	Stock	27.95	27.96	27.89	27.905	1772971.0
2013-02-12 15:30:00	MSFT	Stock	27.908	27.91	27.84	27.88	6530179.0
2013-02-12 16:00:00	MSFT	Stock	27.88	27.97	27.81	27.88	1849792.0
2013-02-12 16:30:00	MSFT	Stock	27.9	27.91	27.88	27.91	5086.0
2013-02-12 17:00:00	MSFT	Stock	27.94	27.94	27.88	27.91	92024.0

> showing 50 of 75,701 rows — these rows as CSV

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