PREVIEW / stock_30min / 2013-06-26

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-06-26.parquet
  size:    1.5 MB
  rows:    79,223
  symbols: 3,526

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-06-26 04:30:00	AAPL	Stock	14.4139	14.4361	14.4107	14.4107	20440.0
2013-06-26 05:30:00	AAPL	Stock	14.4286	14.4286	14.4286	14.4286	5600.0
2013-06-26 06:00:00	AAPL	Stock	14.4361	14.4554	14.4361	14.4511	72688.0
2013-06-26 06:30:00	AAPL	Stock	14.4464	14.4464	14.4464	14.4464	2800.0
2013-06-26 07:00:00	AAPL	Stock	14.4464	14.4464	14.4107	14.4286	107940.0
2013-06-26 07:30:00	AAPL	Stock	14.4286	14.4407	14.4214	14.4286	143108.0
2013-06-26 08:00:00	AAPL	Stock	14.4264	14.4429	14.3857	14.4071	407204.0
2013-06-26 08:30:00	AAPL	Stock	14.3893	14.4104	14.3661	14.3893	216692.0
2013-06-26 09:00:00	AAPL	Stock	14.3825	14.4314	14.3821	14.4143	432152.0
2013-06-26 09:30:00	AAPL	Stock	14.4179	14.4568	14.2779	14.295	56358848.0
2013-06-26 10:00:00	AAPL	Stock	14.2943	14.3482	14.22	14.2621	42941556.0
2013-06-26 10:30:00	AAPL	Stock	14.2621	14.335	14.2475	14.2554	24109260.0
2013-06-26 11:00:00	AAPL	Stock	14.255	14.2921	14.2368	14.2415	18446092.0
2013-06-26 11:30:00	AAPL	Stock	14.2368	14.2644	14.165	14.165	22634052.0
2013-06-26 12:00:00	AAPL	Stock	14.165	14.1939	14.1532	14.1843	25769884.0
2013-06-26 12:30:00	AAPL	Stock	14.1848	14.2086	14.1468	14.1518	14022960.0
2013-06-26 13:00:00	AAPL	Stock	14.1536	14.2136	14.1393	14.2046	18592308.0
2013-06-26 13:30:00	AAPL	Stock	14.2046	14.2089	14.1789	14.1857	9743608.0
2013-06-26 14:00:00	AAPL	Stock	14.1863	14.1925	14.1639	14.1886	10908380.0
2013-06-26 14:30:00	AAPL	Stock	14.1882	14.1907	14.1307	14.1354	16699368.0
2013-06-26 15:00:00	AAPL	Stock	14.1354	14.2232	14.135	14.2143	20556368.0
2013-06-26 15:30:00	AAPL	Stock	14.2139	14.2493	14.19	14.2143	35473004.0
2013-06-26 16:00:00	AAPL	Stock	14.2168	14.3741	14.1843	14.1857	46863740.0
2013-06-26 16:30:00	AAPL	Stock	14.1889	14.2281	14.1811	14.2	367108.0
2013-06-26 17:00:00	AAPL	Stock	14.2	14.2	14.1832	14.1875	95900.0
2013-06-26 17:30:00	AAPL	Stock	14.1857	14.1893	14.1857	14.1893	49980.0
2013-06-26 18:00:00	AAPL	Stock	14.1964	14.1964	14.1893	14.1893	29960.0
2013-06-26 18:30:00	AAPL	Stock	14.1929	14.1954	14.1875	14.1879	35504.0
2013-06-26 19:00:00	AAPL	Stock	14.1875	14.1964	14.1804	14.1875	114268.0
2013-06-26 19:30:00	AAPL	Stock	14.1821	14.1964	14.1789	14.1821	66584.0
2013-06-26 06:30:00	MSFT	Stock	33.9	34.11	33.9	34.1	10594.0
2013-06-26 07:00:00	MSFT	Stock	34.03	34.08	33.89	33.89	52009.0
2013-06-26 07:30:00	MSFT	Stock	33.94	33.94	33.81	33.93	17713.0
2013-06-26 08:00:00	MSFT	Stock	34.03	34.03	33.91	34.0	14500.0
2013-06-26 08:30:00	MSFT	Stock	33.93	34.0	33.92	33.93	16602.0
2013-06-26 09:00:00	MSFT	Stock	33.98	34.14	33.93	34.11	36248.0
2013-06-26 09:30:00	MSFT	Stock	34.13	34.385	33.888	34.069	7142942.0
2013-06-26 10:00:00	MSFT	Stock	34.07	34.275	34.05	34.27	4610147.0
2013-06-26 10:30:00	MSFT	Stock	34.27	34.31	34.16	34.26	2815970.0
2013-06-26 11:00:00	MSFT	Stock	34.26	34.36	34.17	34.19	3049994.0
2013-06-26 11:30:00	MSFT	Stock	34.19	34.3	34.15	34.205	1603714.0
2013-06-26 12:00:00	MSFT	Stock	34.2	34.4	34.2	34.4	2044894.0
2013-06-26 12:30:00	MSFT	Stock	34.39	34.4	34.3	34.3	2217481.0
2013-06-26 13:00:00	MSFT	Stock	34.305	34.35	34.24	34.34	1308094.0
2013-06-26 13:30:00	MSFT	Stock	34.34	34.36	34.28	34.35	2000639.0
2013-06-26 14:00:00	MSFT	Stock	34.35	34.4	34.28	34.37	1679602.0
2013-06-26 14:30:00	MSFT	Stock	34.375	34.38	34.32	34.345	1487669.0
2013-06-26 15:00:00	MSFT	Stock	34.35	34.48	34.33	34.38	2764338.0
2013-06-26 15:30:00	MSFT	Stock	34.39	34.42	34.34	34.36	5370596.0
2013-06-26 16:00:00	MSFT	Stock	34.35	34.455	34.202	34.35	10179065.0

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

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