PREVIEW / stock_30min / 2013-05-14

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-05-14.parquet
  size:    1.5 MB
  rows:    78,937
  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-05-14 05:00:00	AAPL	Stock	16.1929	16.1929	16.1929	16.1929	3920.0
2013-05-14 05:30:00	AAPL	Stock	16.1871	16.1871	16.1871	16.1871	7364.0
2013-05-14 06:00:00	AAPL	Stock	16.1804	16.1804	16.1804	16.1804	2800.0
2013-05-14 07:00:00	AAPL	Stock	16.1982	16.2143	16.1982	16.2143	17192.0
2013-05-14 07:30:00	AAPL	Stock	16.2018	16.2675	16.1646	16.2675	188300.0
2013-05-14 08:00:00	AAPL	Stock	16.2589	16.2904	16.1786	16.2232	816592.0
2013-05-14 08:30:00	AAPL	Stock	16.2161	16.2218	16.1864	16.2032	770000.0
2013-05-14 09:00:00	AAPL	Stock	16.2018	16.2161	16.1879	16.2104	440888.0
2013-05-14 09:30:00	AAPL	Stock	16.2089	16.2571	16.13	16.1414	52688636.0
2013-05-14 10:00:00	AAPL	Stock	16.1436	16.205	16.1204	16.1868	32487028.0
2013-05-14 10:30:00	AAPL	Stock	16.1868	16.1989	16.1607	16.1869	19017684.0
2013-05-14 11:00:00	AAPL	Stock	16.1856	16.1964	16.1286	16.1657	20153756.0
2013-05-14 11:30:00	AAPL	Stock	16.1668	16.1896	16.1468	16.1732	21077252.0
2013-05-14 12:00:00	AAPL	Stock	16.1736	16.2	16.1571	16.1668	10321920.0
2013-05-14 12:30:00	AAPL	Stock	16.1643	16.1832	16.1314	16.1418	9148944.0
2013-05-14 13:00:00	AAPL	Stock	16.1421	16.1551	16.1143	16.1255	10819592.0
2013-05-14 13:30:00	AAPL	Stock	16.1232	16.1346	15.8293	15.9246	63912884.0
2013-05-14 14:00:00	AAPL	Stock	15.9246	15.9804	15.7911	15.8171	68392352.0
2013-05-14 14:30:00	AAPL	Stock	15.8168	15.9089	15.8146	15.8364	38470712.0
2013-05-14 15:00:00	AAPL	Stock	15.8354	15.9057	15.8036	15.8459	33889240.0
2013-05-14 15:30:00	AAPL	Stock	15.8468	15.8714	15.8221	15.8457	39689356.0
2013-05-14 16:00:00	AAPL	Stock	15.8532	16.2359	15.8393	15.8443	13010872.0
2013-05-14 16:30:00	AAPL	Stock	15.8443	15.8525	15.8426	15.8471	1434664.0
2013-05-14 17:00:00	AAPL	Stock	15.8496	15.8518	15.8304	15.8304	360808.0
2013-05-14 17:30:00	AAPL	Stock	15.8332	15.8393	15.8207	15.8207	89712.0
2013-05-14 18:00:00	AAPL	Stock	15.8214	15.8214	15.8071	15.8175	182336.0
2013-05-14 18:30:00	AAPL	Stock	15.8175	15.8304	15.8125	15.8261	140616.0
2013-05-14 19:00:00	AAPL	Stock	15.83	15.83	15.8214	15.8214	56168.0
2013-05-14 19:30:00	AAPL	Stock	15.8168	15.8171	15.8107	15.8146	148120.0
2013-05-14 06:00:00	MSFT	Stock	32.83	32.83	32.83	32.83	500.0
2013-05-14 06:30:00	MSFT	Stock	32.82	32.82	32.82	32.82	100.0
2013-05-14 07:00:00	MSFT	Stock	32.8	32.8	32.8	32.8	1000.0
2013-05-14 07:30:00	MSFT	Stock	32.8	32.84	32.8	32.83	5300.0
2013-05-14 08:00:00	MSFT	Stock	32.83	32.9	32.8	32.87	22515.0
2013-05-14 08:30:00	MSFT	Stock	32.86	32.9	32.82	32.9	16200.0
2013-05-14 09:00:00	MSFT	Stock	32.9	32.94	32.84	32.86	28996.0
2013-05-14 09:30:00	MSFT	Stock	32.86	33.34	32.8	33.13	6065693.0
2013-05-14 10:00:00	MSFT	Stock	33.13	33.14	33.005	33.065	4422170.0
2013-05-14 10:30:00	MSFT	Stock	33.07	33.15	33.04	33.08	3661262.0
2013-05-14 11:00:00	MSFT	Stock	33.09	33.22	33.08	33.16	3340386.0
2013-05-14 11:30:00	MSFT	Stock	33.155	33.16	33.07	33.15	1831150.0
2013-05-14 12:00:00	MSFT	Stock	33.145	33.357	33.14	33.26	2724428.0
2013-05-14 12:30:00	MSFT	Stock	33.25	33.28	33.18	33.18	1966854.0
2013-05-14 13:00:00	MSFT	Stock	33.18	33.28	33.15	33.24	2133444.0
2013-05-14 13:30:00	MSFT	Stock	33.235	33.34	33.19	33.225	2430504.0
2013-05-14 14:00:00	MSFT	Stock	33.224	33.27	33.19	33.26	1601778.0
2013-05-14 14:30:00	MSFT	Stock	33.27	33.3	33.17	33.195	1861504.0
2013-05-14 15:00:00	MSFT	Stock	33.195	33.27	33.18	33.245	1859460.0
2013-05-14 15:30:00	MSFT	Stock	33.25	33.53	33.245	33.52	10798612.0
2013-05-14 16:00:00	MSFT	Stock	33.53	33.91	32.934	33.52	10988441.0

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

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