PREVIEW / stock_30min / 2013-10-04

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-10-04.parquet
  size:    1.5 MB
  rows:    79,616
  symbols: 3,522

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-10-04 04:00:00	AAPL	Stock	17.2814	17.2814	17.2814	17.2814	7840.0
2013-10-04 04:30:00	AAPL	Stock	17.3214	17.3214	17.3214	17.3214	30660.0
2013-10-04 05:00:00	AAPL	Stock	17.3375	17.3375	17.3375	17.3375	2800.0
2013-10-04 05:30:00	AAPL	Stock	17.3282	17.3536	17.3282	17.3536	47460.0
2013-10-04 06:00:00	AAPL	Stock	17.3457	17.3507	17.3457	17.3457	12600.0
2013-10-04 06:30:00	AAPL	Stock	17.3496	17.3557	17.3464	17.3557	33712.0
2013-10-04 07:00:00	AAPL	Stock	17.35	17.3618	17.3193	17.3193	89908.0
2013-10-04 07:30:00	AAPL	Stock	17.3125	17.3125	17.2857	17.3036	145908.0
2013-10-04 08:00:00	AAPL	Stock	17.3036	17.37	17.25	17.3004	1396220.0
2013-10-04 08:30:00	AAPL	Stock	17.3007	17.3021	17.25	17.2946	367332.0
2013-10-04 09:00:00	AAPL	Stock	17.2921	17.2932	17.2554	17.2643	679224.0
2013-10-04 09:30:00	AAPL	Stock	17.2807	17.3071	17.1075	17.1304	53020800.0
2013-10-04 10:00:00	AAPL	Stock	17.1307	17.1971	17.0929	17.1715	32306596.0
2013-10-04 10:30:00	AAPL	Stock	17.1759	17.2361	17.1536	17.1596	22429792.0
2013-10-04 11:00:00	AAPL	Stock	17.16	17.1742	17.1286	17.1421	13081600.0
2013-10-04 11:30:00	AAPL	Stock	17.1389	17.1696	17.1389	17.1657	6866860.0
2013-10-04 12:00:00	AAPL	Stock	17.1621	17.1739	17.1429	17.1725	8280916.0
2013-10-04 12:30:00	AAPL	Stock	17.1704	17.2061	17.1652	17.1807	11862508.0
2013-10-04 13:00:00	AAPL	Stock	17.1839	17.2	17.1689	17.1893	6909028.0
2013-10-04 13:30:00	AAPL	Stock	17.1896	17.1996	17.1611	17.1729	8943144.0
2013-10-04 14:00:00	AAPL	Stock	17.1754	17.1893	17.1661	17.1702	7762048.0
2013-10-04 14:30:00	AAPL	Stock	17.1711	17.2429	17.1661	17.2179	18916100.0
2013-10-04 15:00:00	AAPL	Stock	17.2193	17.2857	17.2114	17.2296	21132384.0
2013-10-04 15:30:00	AAPL	Stock	17.2311	17.2768	17.2118	17.2502	31420144.0
2013-10-04 16:00:00	AAPL	Stock	17.2511	17.2654	17.1952	17.2568	7364364.0
2013-10-04 16:30:00	AAPL	Stock	17.2568	17.2588	17.2232	17.2393	327768.0
2013-10-04 17:00:00	AAPL	Stock	17.2393	17.2393	17.2154	17.2329	110348.0
2013-10-04 17:30:00	AAPL	Stock	17.2389	17.2511	17.2339	17.2339	135436.0
2013-10-04 18:00:00	AAPL	Stock	17.2357	17.2389	17.2357	17.2389	8400.0
2013-10-04 18:30:00	AAPL	Stock	17.2336	17.25	17.2321	17.25	54236.0
2013-10-04 19:00:00	AAPL	Stock	17.2454	17.2511	17.2446	17.2446	30296.0
2013-10-04 19:30:00	AAPL	Stock	17.25	17.255	17.2482	17.2529	83272.0
2013-10-04 04:30:00	MSFT	Stock	33.83	33.83	33.83	33.83	100.0
2013-10-04 06:30:00	MSFT	Stock	33.83	33.83	33.79	33.79	200.0
2013-10-04 07:30:00	MSFT	Stock	33.87	33.87	33.85	33.86	1890.0
2013-10-04 08:00:00	MSFT	Stock	33.83	33.87	33.8	33.86	204683.0
2013-10-04 08:30:00	MSFT	Stock	33.86	33.86	33.84	33.85	4700.0
2013-10-04 09:00:00	MSFT	Stock	33.85	33.85	33.7	33.7	10864.0
2013-10-04 09:30:00	MSFT	Stock	33.7	33.84	33.67	33.775	4037645.0
2013-10-04 10:00:00	MSFT	Stock	33.78	33.79	33.7	33.71	2185265.0
2013-10-04 10:30:00	MSFT	Stock	33.72	33.85	33.68	33.69	2801498.0
2013-10-04 11:00:00	MSFT	Stock	33.69	33.74	33.62	33.74	1891421.0
2013-10-04 11:30:00	MSFT	Stock	33.73	33.84	33.73	33.84	1305673.0
2013-10-04 12:00:00	MSFT	Stock	33.835	33.98	33.79	33.96	2059782.0
2013-10-04 12:30:00	MSFT	Stock	33.955	33.98	33.89	33.891	2255350.0
2013-10-04 13:00:00	MSFT	Stock	33.89	33.92	33.84	33.888	1228331.0
2013-10-04 13:30:00	MSFT	Stock	33.88	33.92	33.79	33.86	1314464.0
2013-10-04 14:00:00	MSFT	Stock	33.86	33.93	33.86	33.905	1336293.0
2013-10-04 14:30:00	MSFT	Stock	33.9	33.99	33.86	33.97	1729531.0
2013-10-04 15:00:00	MSFT	Stock	33.965	33.98	33.84	33.893	2329634.0

> showing 50 of 79,616 rows — these rows as CSV

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