PREVIEW / stock_30min / 2013-07-12

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-07-12.parquet
  size:    1.5 MB
  rows:    77,777
  symbols: 3,512

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-12 04:30:00	AAPL	Stock	15.2407	15.2407	15.2407	15.2407	2800.0
2013-07-12 05:00:00	AAPL	Stock	15.2368	15.2368	15.2368	15.2368	2800.0
2013-07-12 06:00:00	AAPL	Stock	15.2371	15.2436	15.2371	15.2436	8400.0
2013-07-12 07:00:00	AAPL	Stock	15.2575	15.2693	15.25	15.2514	37968.0
2013-07-12 07:30:00	AAPL	Stock	15.2671	15.2707	15.2368	15.25	140000.0
2013-07-12 08:00:00	AAPL	Stock	15.2336	15.2714	15.2325	15.2579	326508.0
2013-07-12 08:30:00	AAPL	Stock	15.2596	15.2732	15.2414	15.2732	357112.0
2013-07-12 09:00:00	AAPL	Stock	15.2707	15.2804	15.2529	15.2761	374724.0
2013-07-12 09:30:00	AAPL	Stock	15.2732	15.3357	15.2429	15.2893	51415084.0
2013-07-12 10:00:00	AAPL	Stock	15.2893	15.3496	15.2821	15.3382	23013564.0
2013-07-12 10:30:00	AAPL	Stock	15.3362	15.3382	15.2536	15.2768	21926464.0
2013-07-12 11:00:00	AAPL	Stock	15.27	15.2914	15.2036	15.2107	12741008.0
2013-07-12 11:30:00	AAPL	Stock	15.2129	15.2329	15.1654	15.2075	24006640.0
2013-07-12 12:00:00	AAPL	Stock	15.2079	15.225	15.1696	15.1721	9072840.0
2013-07-12 12:30:00	AAPL	Stock	15.1718	15.1768	15.1218	15.1632	18560556.0
2013-07-12 13:00:00	AAPL	Stock	15.1607	15.1957	15.1571	15.1729	9775892.0
2013-07-12 13:30:00	AAPL	Stock	15.1736	15.1843	15.1432	15.1746	7505148.0
2013-07-12 14:00:00	AAPL	Stock	15.1725	15.1778	15.1371	15.1457	8871296.0
2013-07-12 14:30:00	AAPL	Stock	15.1469	15.1857	15.1379	15.1757	9579416.0
2013-07-12 15:00:00	AAPL	Stock	15.1761	15.1893	15.1646	15.1818	8611848.0
2013-07-12 15:30:00	AAPL	Stock	15.1796	15.2368	15.1686	15.2321	43557724.0
2013-07-12 16:00:00	AAPL	Stock	15.2325	15.235	15.2004	15.2111	16910432.0
2013-07-12 16:30:00	AAPL	Stock	15.2111	15.2783	15.1799	15.2325	644280.0
2013-07-12 17:00:00	AAPL	Stock	15.2243	15.225	15.2036	15.2143	113904.0
2013-07-12 17:30:00	AAPL	Stock	15.2179	15.2214	15.2132	15.2154	69524.0
2013-07-12 18:00:00	AAPL	Stock	15.2164	15.2196	15.2164	15.2196	30800.0
2013-07-12 18:30:00	AAPL	Stock	15.2232	15.2268	15.2196	15.2214	49476.0
2013-07-12 19:00:00	AAPL	Stock	15.2214	15.2321	15.2214	15.2321	25200.0
2013-07-12 19:30:00	AAPL	Stock	15.2321	15.2321	15.2321	15.2321	5600.0
2013-07-12 04:30:00	MSFT	Stock	35.59	35.59	35.59	35.59	3100.0
2013-07-12 07:00:00	MSFT	Stock	35.6	35.6	35.55	35.55	700.0
2013-07-12 07:30:00	MSFT	Stock	35.59	35.6	35.59	35.6	2300.0
2013-07-12 08:00:00	MSFT	Stock	35.6	35.8	35.52	35.6	9059.0
2013-07-12 08:30:00	MSFT	Stock	35.66	35.66	35.52	35.53	16051.0
2013-07-12 09:00:00	MSFT	Stock	35.51	35.58	35.51	35.58	6895.0
2013-07-12 09:30:00	MSFT	Stock	35.58	35.73	35.4	35.503	4481118.0
2013-07-12 10:00:00	MSFT	Stock	35.505	35.52	35.31	35.415	2966105.0
2013-07-12 10:30:00	MSFT	Stock	35.42	35.45	35.34	35.4	1818424.0
2013-07-12 11:00:00	MSFT	Stock	35.4	35.41	35.28	35.29	1630221.0
2013-07-12 11:30:00	MSFT	Stock	35.295	35.36	35.29	35.305	1217229.0
2013-07-12 12:00:00	MSFT	Stock	35.305	35.41	35.3	35.4	969680.0
2013-07-12 12:30:00	MSFT	Stock	35.4	35.41	35.32	35.33	1396036.0
2013-07-12 13:00:00	MSFT	Stock	35.335	35.38	35.28	35.373	1274018.0
2013-07-12 13:30:00	MSFT	Stock	35.38	35.44	35.36	35.41	1261193.0
2013-07-12 14:00:00	MSFT	Stock	35.405	35.45	35.38	35.45	1339922.0
2013-07-12 14:30:00	MSFT	Stock	35.45	35.54	35.442	35.49	1221782.0
2013-07-12 15:00:00	MSFT	Stock	35.49	35.54	35.43	35.525	1625305.0
2013-07-12 15:30:00	MSFT	Stock	35.53	35.73	35.52	35.71	8080444.0
2013-07-12 16:00:00	MSFT	Stock	35.72	35.73	35.516	35.73	5679369.0
2013-07-12 16:30:00	MSFT	Stock	35.66	35.68	35.53	35.67	151021.0

> showing 50 of 77,777 rows — these rows as CSV

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