PREVIEW / stock_30min / 2013-07-31

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-07-31.parquet
  size:    1.5 MB
  rows:    79,630
  symbols: 3,515

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-07-31 04:00:00	AAPL	Stock	16.2096	16.2121	16.2096	16.2121	5600.0
2013-07-31 05:00:00	AAPL	Stock	16.2404	16.2518	16.2404	16.2518	23520.0
2013-07-31 06:00:00	AAPL	Stock	16.2571	16.2571	16.2571	16.2571	30800.0
2013-07-31 07:00:00	AAPL	Stock	16.25	16.3036	16.2286	16.2857	244552.0
2013-07-31 07:30:00	AAPL	Stock	16.2857	16.2857	16.2679	16.2764	70000.0
2013-07-31 08:00:00	AAPL	Stock	16.2754	16.2821	16.1071	16.2493	1134196.0
2013-07-31 08:30:00	AAPL	Stock	16.2432	16.2589	16.1979	16.2496	795676.0
2013-07-31 09:00:00	AAPL	Stock	16.2496	16.2546	16.2143	16.2514	656208.0
2013-07-31 09:30:00	AAPL	Stock	16.25	16.3336	16.2261	16.2941	39605860.0
2013-07-31 10:00:00	AAPL	Stock	16.2946	16.2986	16.1143	16.1379	46283692.0
2013-07-31 10:30:00	AAPL	Stock	16.14	16.1429	16.0511	16.1211	33005812.0
2013-07-31 11:00:00	AAPL	Stock	16.1225	16.1589	16.0954	16.1571	13823320.0
2013-07-31 11:30:00	AAPL	Stock	16.1586	16.1857	16.1018	16.1071	13116236.0
2013-07-31 12:00:00	AAPL	Stock	16.1075	16.1436	16.0897	16.1436	9058812.0
2013-07-31 12:30:00	AAPL	Stock	16.1439	16.1511	16.1096	16.1282	7504196.0
2013-07-31 13:00:00	AAPL	Stock	16.1271	16.1529	16.0964	16.1361	9130520.0
2013-07-31 13:30:00	AAPL	Stock	16.1389	16.1696	16.1336	16.1689	8419964.0
2013-07-31 14:00:00	AAPL	Stock	16.1643	16.2321	16.1214	16.2274	23825256.0
2013-07-31 14:30:00	AAPL	Stock	16.227	16.2833	16.2179	16.2711	18834172.0
2013-07-31 15:00:00	AAPL	Stock	16.2711	16.2721	16.1883	16.2232	17700396.0
2013-07-31 15:30:00	AAPL	Stock	16.225	16.2266	16.1161	16.1614	31046680.0
2013-07-31 16:00:00	AAPL	Stock	16.1607	16.1821	16.1586	16.1786	37433004.0
2013-07-31 16:30:00	AAPL	Stock	16.31	16.31	16.1231	16.1754	428372.0
2013-07-31 17:00:00	AAPL	Stock	16.1775	16.1786	16.1696	16.1696	101220.0
2013-07-31 17:30:00	AAPL	Stock	16.1721	16.175	16.1696	16.175	30548.0
2013-07-31 18:00:00	AAPL	Stock	16.17	16.1964	16.17	16.1943	147364.0
2013-07-31 18:30:00	AAPL	Stock	16.1925	16.1925	16.1925	16.1925	2800.0
2013-07-31 19:00:00	AAPL	Stock	16.1829	16.1936	16.1825	16.1936	39340.0
2013-07-31 19:30:00	AAPL	Stock	16.1893	16.1968	16.1804	16.1929	216580.0
2013-07-31 08:00:00	MSFT	Stock	31.81	31.81	31.8	31.8	600.0
2013-07-31 08:30:00	MSFT	Stock	31.81	31.89	31.81	31.87	2934.0
2013-07-31 09:00:00	MSFT	Stock	31.78	32.04	31.77	31.97	97781.0
2013-07-31 09:30:00	MSFT	Stock	31.96	32.0	31.79	31.83	3630308.0
2013-07-31 10:00:00	MSFT	Stock	31.82	32.05	31.8	32.035	4036123.0
2013-07-31 10:30:00	MSFT	Stock	32.04	32.04	31.98	31.99	3670779.0
2013-07-31 11:00:00	MSFT	Stock	31.99	32.02	31.92	31.93	2704272.0
2013-07-31 11:30:00	MSFT	Stock	31.92	32.03	31.92	32.011	1547503.0
2013-07-31 12:00:00	MSFT	Stock	32.01	32.03	31.99	32.0	2695367.0
2013-07-31 12:30:00	MSFT	Stock	31.99	32.01	31.91	31.918	2091913.0
2013-07-31 13:00:00	MSFT	Stock	31.91	31.97	31.91	31.929	1328763.0
2013-07-31 13:30:00	MSFT	Stock	31.92	31.96	31.9	31.92	1325848.0
2013-07-31 14:00:00	MSFT	Stock	31.91	31.96	31.75	31.887	3880640.0
2013-07-31 14:30:00	MSFT	Stock	31.89	31.96	31.87	31.94	3022489.0
2013-07-31 15:00:00	MSFT	Stock	31.94	31.95	31.85	31.88	1820171.0
2013-07-31 15:30:00	MSFT	Stock	31.88	31.92	31.71	31.83	6689918.0
2013-07-31 16:00:00	MSFT	Stock	31.84	31.97	31.776	31.84	4728249.0
2013-07-31 16:30:00	MSFT	Stock	31.9	31.985	31.83	31.83	21157.0
2013-07-31 18:00:00	MSFT	Stock	31.88	31.88	31.83	31.83	880.0
2013-07-31 19:00:00	MSFT	Stock	31.84	31.84	31.84	31.84	700.0
2013-07-31 19:30:00	MSFT	Stock	31.9	31.9	31.9	31.9	500.0

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

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