PREVIEW / stock_30min / 2013-04-08

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-04-08.parquet
  size:    1.4 MB
  rows:    76,434
  symbols: 3,492

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-08 04:00:00	AAPL	Stock	15.1779	15.2371	15.1779	15.2371	14504.0
2013-04-08 04:30:00	AAPL	Stock	15.2411	15.2411	15.2411	15.2411	5600.0
2013-04-08 05:00:00	AAPL	Stock	15.2411	15.2411	15.2321	15.2321	8400.0
2013-04-08 05:30:00	AAPL	Stock	15.2264	15.2468	15.2264	15.2468	39200.0
2013-04-08 06:00:00	AAPL	Stock	15.2321	15.2704	15.2321	15.2679	36540.0
2013-04-08 06:30:00	AAPL	Stock	15.2446	15.2607	15.2446	15.2596	14000.0
2013-04-08 07:00:00	AAPL	Stock	15.25	15.33	15.1821	15.3036	454664.0
2013-04-08 07:30:00	AAPL	Stock	15.2946	15.2946	15.2607	15.2611	159320.0
2013-04-08 08:00:00	AAPL	Stock	15.2525	15.3214	15.2182	15.2182	939092.0
2013-04-08 08:30:00	AAPL	Stock	15.2214	15.2307	15.1539	15.1768	1688540.0
2013-04-08 09:00:00	AAPL	Stock	15.1768	15.1893	15.1521	15.1714	1700244.0
2013-04-08 09:30:00	AAPL	Stock	15.1714	15.2679	15.1429	15.2066	49084840.0
2013-04-08 10:00:00	AAPL	Stock	15.2061	15.2095	15.125	15.1543	27415528.0
2013-04-08 10:30:00	AAPL	Stock	15.1539	15.1964	15.0986	15.1964	27951084.0
2013-04-08 11:00:00	AAPL	Stock	15.195	15.1954	15.1214	15.1243	17013808.0
2013-04-08 11:30:00	AAPL	Stock	15.1246	15.1423	15.09	15.1221	15242696.0
2013-04-08 12:00:00	AAPL	Stock	15.1222	15.1379	15.0889	15.0975	11813676.0
2013-04-08 12:30:00	AAPL	Stock	15.0996	15.1461	15.0982	15.125	12404756.0
2013-04-08 13:00:00	AAPL	Stock	15.125	15.1696	15.1089	15.1643	11036872.0
2013-04-08 13:30:00	AAPL	Stock	15.1632	15.2232	15.1621	15.2165	15125208.0
2013-04-08 14:00:00	AAPL	Stock	15.2168	15.2521	15.1982	15.2114	17865708.0
2013-04-08 14:30:00	AAPL	Stock	15.2097	15.2207	15.1714	15.1771	12720764.0
2013-04-08 15:00:00	AAPL	Stock	15.1782	15.1982	15.1654	15.1864	10947216.0
2013-04-08 15:30:00	AAPL	Stock	15.1882	15.2229	15.1789	15.2218	23770320.0
2013-04-08 16:00:00	AAPL	Stock	15.2218	15.2233	15.1479	15.2218	27171928.0
2013-04-08 16:30:00	AAPL	Stock	15.2104	15.2325	15.1895	15.2268	820960.0
2013-04-08 17:00:00	AAPL	Stock	15.2321	15.2321	15.22	15.2214	109816.0
2013-04-08 17:30:00	AAPL	Stock	15.2161	15.225	15.2161	15.2214	95200.0
2013-04-08 18:00:00	AAPL	Stock	15.225	15.225	15.215	15.2225	199528.0
2013-04-08 18:30:00	AAPL	Stock	15.2229	15.2229	15.2171	15.2207	23464.0
2013-04-08 19:00:00	AAPL	Stock	15.2196	15.225	15.2196	15.2232	77952.0
2013-04-08 19:30:00	AAPL	Stock	15.2243	15.2243	15.2196	15.2204	79436.0
2013-04-08 07:30:00	MSFT	Stock	28.79	28.79	28.79	28.79	100.0
2013-04-08 08:00:00	MSFT	Stock	28.77	28.8	28.6	28.75	4149.0
2013-04-08 08:30:00	MSFT	Stock	28.74	28.77	28.73	28.77	2600.0
2013-04-08 09:00:00	MSFT	Stock	28.75	28.77	28.63	28.64	67854.0
2013-04-08 09:30:00	MSFT	Stock	28.69	28.73	28.57	28.63	3284463.0
2013-04-08 10:00:00	MSFT	Stock	28.63	28.69	28.54	28.56	2445169.0
2013-04-08 10:30:00	MSFT	Stock	28.56	28.58	28.5	28.555	2076180.0
2013-04-08 11:00:00	MSFT	Stock	28.555	28.56	28.47	28.526	2216467.0
2013-04-08 11:30:00	MSFT	Stock	28.525	28.54	28.5	28.5	1762169.0
2013-04-08 12:00:00	MSFT	Stock	28.5	28.52	28.49	28.51	1567373.0
2013-04-08 12:30:00	MSFT	Stock	28.515	28.55	28.5	28.5	1122840.0
2013-04-08 13:00:00	MSFT	Stock	28.5	28.52	28.48	28.499	1380850.0
2013-04-08 13:30:00	MSFT	Stock	28.5	28.54	28.48	28.531	1534326.0
2013-04-08 14:00:00	MSFT	Stock	28.53	28.57	28.5	28.505	1644474.0
2013-04-08 14:30:00	MSFT	Stock	28.501	28.53	28.495	28.505	3127276.0
2013-04-08 15:00:00	MSFT	Stock	28.505	28.54	28.49	28.505	4045216.0
2013-04-08 15:30:00	MSFT	Stock	28.51	28.59	28.5	28.59	5593776.0
2013-04-08 16:00:00	MSFT	Stock	28.59	28.63	28.5	28.59	2185017.0

> showing 50 of 76,434 rows — these rows as CSV

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