PREVIEW / stock_30min / 2013-04-16

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-04-16.parquet
  size:    1.5 MB
  rows:    78,294
  symbols: 3,477

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-04-16 04:00:00	AAPL	Stock	15.0357	15.0357	15.0357	15.0357	17304.0
2013-04-16 05:00:00	AAPL	Stock	15.0714	15.0714	15.0714	15.0714	2800.0
2013-04-16 05:30:00	AAPL	Stock	15.0714	15.0714	15.0714	15.0714	17360.0
2013-04-16 06:30:00	AAPL	Stock	15.0821	15.0925	15.0768	15.0786	56000.0
2013-04-16 07:00:00	AAPL	Stock	15.0786	15.1143	15.0786	15.1064	110068.0
2013-04-16 07:30:00	AAPL	Stock	15.09	15.1589	15.0714	15.1218	603288.0
2013-04-16 08:00:00	AAPL	Stock	15.1146	15.1468	15.0	15.1071	964712.0
2013-04-16 08:30:00	AAPL	Stock	15.1071	15.1382	15.0786	15.0893	1151164.0
2013-04-16 09:00:00	AAPL	Stock	15.0914	15.1025	15.0386	15.055	1196468.0
2013-04-16 09:30:00	AAPL	Stock	15.0557	15.1714	15.0204	15.0795	59789408.0
2013-04-16 10:00:00	AAPL	Stock	15.0769	15.0979	15.0279	15.0841	30134272.0
2013-04-16 10:30:00	AAPL	Stock	15.0875	15.1661	15.0675	15.1025	28079184.0
2013-04-16 11:00:00	AAPL	Stock	15.1004	15.1371	15.0754	15.1079	17527244.0
2013-04-16 11:30:00	AAPL	Stock	15.102	15.1893	15.1007	15.1664	20694744.0
2013-04-16 12:00:00	AAPL	Stock	15.1661	15.1796	15.1446	15.1618	14676396.0
2013-04-16 12:30:00	AAPL	Stock	15.162	15.1814	15.155	15.1636	10151820.0
2013-04-16 13:00:00	AAPL	Stock	15.1639	15.1736	15.1168	15.1511	10210340.0
2013-04-16 13:30:00	AAPL	Stock	15.1525	15.1725	15.1525	15.1621	6954052.0
2013-04-16 14:00:00	AAPL	Stock	15.1656	15.1964	15.1636	15.1794	14161028.0
2013-04-16 14:30:00	AAPL	Stock	15.179	15.1968	15.1632	15.1739	12945912.0
2013-04-16 15:00:00	AAPL	Stock	15.1775	15.2321	15.1664	15.2232	20221768.0
2013-04-16 15:30:00	AAPL	Stock	15.2221	15.2361	15.2018	15.2175	25165896.0
2013-04-16 16:00:00	AAPL	Stock	15.2229	15.2289	15.136	15.2125	24238424.0
2013-04-16 16:30:00	AAPL	Stock	15.2229	15.2264	15.0915	15.2246	618828.0
2013-04-16 17:00:00	AAPL	Stock	15.2229	15.2243	15.2214	15.2229	126560.0
2013-04-16 17:30:00	AAPL	Stock	15.2168	15.2168	15.2143	15.2168	75852.0
2013-04-16 18:00:00	AAPL	Stock	15.2175	15.2175	15.2079	15.2139	61880.0
2013-04-16 18:30:00	AAPL	Stock	15.2086	15.2086	15.1918	15.1964	131236.0
2013-04-16 19:00:00	AAPL	Stock	15.1893	15.1893	15.1571	15.1661	500612.0
2013-04-16 19:30:00	AAPL	Stock	15.1589	15.1875	15.1589	15.1786	189000.0
2013-04-16 06:30:00	MSFT	Stock	28.83	28.85	28.81	28.85	4700.0
2013-04-16 07:00:00	MSFT	Stock	28.86	29.03	28.86	28.97	13827.0
2013-04-16 07:30:00	MSFT	Stock	28.96	29.0	28.93	29.0	13399.0
2013-04-16 08:00:00	MSFT	Stock	29.0	29.04	28.75	29.01	87588.0
2013-04-16 08:30:00	MSFT	Stock	29.0	29.05	28.68	29.04	101355.0
2013-04-16 09:00:00	MSFT	Stock	29.0	29.03	28.84	28.91	271293.0
2013-04-16 09:30:00	MSFT	Stock	28.93	29.0	28.76	28.9	7130016.0
2013-04-16 10:00:00	MSFT	Stock	28.9	29.14	28.89	28.93	5346019.0
2013-04-16 10:30:00	MSFT	Stock	28.93	29.0	28.695	28.817	4397438.0
2013-04-16 11:00:00	MSFT	Stock	28.82	29.08	28.77	28.99	4524460.0
2013-04-16 11:30:00	MSFT	Stock	29.0	29.01	28.88	28.945	2755089.0
2013-04-16 12:00:00	MSFT	Stock	28.945	29.0	28.92	28.95	1769514.0
2013-04-16 12:30:00	MSFT	Stock	28.96	29.1	28.95	29.09	2524167.0
2013-04-16 13:00:00	MSFT	Stock	29.085	29.095	29.025	29.061	1631995.0
2013-04-16 13:30:00	MSFT	Stock	29.065	29.09	28.96	29.015	1620738.0
2013-04-16 14:00:00	MSFT	Stock	29.02	29.03	28.97	28.984	1740438.0
2013-04-16 14:30:00	MSFT	Stock	28.98	28.99	28.88	28.885	3291415.0
2013-04-16 15:00:00	MSFT	Stock	28.885	28.905	28.81	28.87	4133275.0
2013-04-16 15:30:00	MSFT	Stock	28.875	28.98	28.85	28.98	6300367.0
2013-04-16 16:00:00	MSFT	Stock	28.98	29.25	28.623	29.0	3711823.0

> showing 50 of 78,294 rows — these rows as CSV

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