PREVIEW / stock_30min / 2012-08-27

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-08-27.parquet
  size:    1.4 MB
  rows:    72,102
  symbols: 3,456

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-08-27 04:00:00	AAPL	Stock	24.1425	24.2496	24.1425	24.2061	249060.0
2012-08-27 04:30:00	AAPL	Stock	24.2486	24.2496	24.2171	24.2461	60200.0
2012-08-27 05:00:00	AAPL	Stock	24.2457	24.2575	24.2457	24.2482	144732.0
2012-08-27 05:30:00	AAPL	Stock	24.2464	24.2554	24.2464	24.2554	46312.0
2012-08-27 06:00:00	AAPL	Stock	24.2554	24.2554	24.2429	24.2446	123984.0
2012-08-27 06:30:00	AAPL	Stock	24.2411	24.2411	24.165	24.2054	452032.0
2012-08-27 07:00:00	AAPL	Stock	24.2143	24.3357	24.1896	24.3061	1843324.0
2012-08-27 07:30:00	AAPL	Stock	24.3089	24.39	24.2286	24.2964	2673132.0
2012-08-27 08:00:00	AAPL	Stock	24.3125	24.3964	24.25	24.3625	5979064.0
2012-08-27 08:30:00	AAPL	Stock	24.3579	24.3721	24.25	24.2564	4268012.0
2012-08-27 09:00:00	AAPL	Stock	24.2536	24.2936	24.2321	24.2857	6693008.0
2012-08-27 09:30:00	AAPL	Stock	24.2796	24.3168	24.0714	24.0821	116343192.0
2012-08-27 10:00:00	AAPL	Stock	24.0839	24.2143	24.055	24.2011	57559936.0
2012-08-27 10:30:00	AAPL	Stock	24.2011	24.2243	24.1268	24.1783	34573420.0
2012-08-27 11:00:00	AAPL	Stock	24.1771	24.2143	24.14	24.2061	23440172.0
2012-08-27 11:30:00	AAPL	Stock	24.2061	24.2179	24.1625	24.1846	17813992.0
2012-08-27 12:00:00	AAPL	Stock	24.1836	24.1964	24.1357	24.1461	17179820.0
2012-08-27 12:30:00	AAPL	Stock	24.1436	24.1889	24.1386	24.1721	12143180.0
2012-08-27 13:00:00	AAPL	Stock	24.1679	24.1993	24.1607	24.1896	10572492.0
2012-08-27 13:30:00	AAPL	Stock	24.1914	24.2143	24.1679	24.1825	13011264.0
2012-08-27 14:00:00	AAPL	Stock	24.1829	24.1925	24.1393	24.1729	12608036.0
2012-08-27 14:30:00	AAPL	Stock	24.1686	24.1943	24.1646	24.1741	10895640.0
2012-08-27 15:00:00	AAPL	Stock	24.1732	24.1779	24.1096	24.1196	20247472.0
2012-08-27 15:30:00	AAPL	Stock	24.1214	24.1418	24.0761	24.1239	42907368.0
2012-08-27 16:00:00	AAPL	Stock	24.1361	24.1778	24.1071	24.1239	1950312.0
2012-08-27 16:30:00	AAPL	Stock	24.1289	24.1339	24.1143	24.1339	386512.0
2012-08-27 17:00:00	AAPL	Stock	24.1318	24.1375	24.1239	24.1268	1071168.0
2012-08-27 17:30:00	AAPL	Stock	24.1339	24.1357	24.125	24.1286	119560.0
2012-08-27 18:00:00	AAPL	Stock	24.1271	24.1314	24.1214	24.125	110460.0
2012-08-27 18:30:00	AAPL	Stock	24.1257	24.1321	24.125	24.1261	44100.0
2012-08-27 19:00:00	AAPL	Stock	24.1268	24.1314	24.1261	24.1314	70168.0
2012-08-27 19:30:00	AAPL	Stock	24.1304	24.1429	24.1304	24.1429	223580.0
2012-08-27 04:00:00	MSFT	Stock	30.8	30.8	30.8	30.8	300.0
2012-08-27 07:00:00	MSFT	Stock	30.85	30.95	30.8	30.87	17475.0
2012-08-27 07:30:00	MSFT	Stock	30.87	30.88	30.8	30.87	18890.0
2012-08-27 08:00:00	MSFT	Stock	30.87	31.0	30.85	30.86	82702.0
2012-08-27 08:30:00	MSFT	Stock	30.86	30.95	30.82	30.89	135804.0
2012-08-27 09:00:00	MSFT	Stock	30.9	30.96	30.85	30.96	139065.0
2012-08-27 09:30:00	MSFT	Stock	30.94	30.96	30.67	30.76	6247214.0
2012-08-27 10:00:00	MSFT	Stock	30.76	30.8	30.72	30.76	3324171.0
2012-08-27 10:30:00	MSFT	Stock	30.76	30.81	30.73	30.8	2247171.0
2012-08-27 11:00:00	MSFT	Stock	30.79	30.84	30.785	30.82	2012042.0
2012-08-27 11:30:00	MSFT	Stock	30.81	30.82	30.76	30.795	1472331.0
2012-08-27 12:00:00	MSFT	Stock	30.78	30.85	30.78	30.787	2124939.0
2012-08-27 12:30:00	MSFT	Stock	30.78	30.8	30.76	30.777	1324861.0
2012-08-27 13:00:00	MSFT	Stock	30.77	30.81	30.76	30.795	1006573.0
2012-08-27 13:30:00	MSFT	Stock	30.79	30.8	30.73	30.74	1405913.0
2012-08-27 14:00:00	MSFT	Stock	30.75	30.78	30.72	30.76	1748553.0
2012-08-27 14:30:00	MSFT	Stock	30.76	30.8	30.75	30.764	1390698.0
2012-08-27 15:00:00	MSFT	Stock	30.765	30.79	30.66	30.7	2072205.0

> showing 50 of 72,102 rows — these rows as CSV

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