PREVIEW / stock_30min / 2011-02-24

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-02-24.parquet
  size:    1.5 MB
  rows:    77,888
  symbols: 3,530

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
2011-02-24 04:30:00	AAPL	Stock	12.2625	12.2625	12.2625	12.2625	2800.0
2011-02-24 05:00:00	AAPL	Stock	12.2436	12.25	12.2429	12.2429	11200.0
2011-02-24 06:00:00	AAPL	Stock	12.2107	12.2107	12.2107	12.2107	11200.0
2011-02-24 06:30:00	AAPL	Stock	12.2179	12.225	12.2125	12.2125	78400.0
2011-02-24 07:00:00	AAPL	Stock	12.2125	12.215	12.1789	12.2121	121800.0
2011-02-24 07:30:00	AAPL	Stock	12.1993	12.2061	12.1725	12.1786	86800.0
2011-02-24 08:00:00	AAPL	Stock	12.1911	12.2464	12.175	12.2321	1186584.0
2011-02-24 08:30:00	AAPL	Stock	12.2382	12.2843	12.2293	12.2739	1367324.0
2011-02-24 09:00:00	AAPL	Stock	12.2768	12.3332	12.2768	12.2857	2599716.0
2011-02-24 09:30:00	AAPL	Stock	12.2871	12.3268	12.2521	12.2839	66506272.0
2011-02-24 10:00:00	AAPL	Stock	12.2839	12.2943	12.2339	12.2782	39841312.0
2011-02-24 10:30:00	AAPL	Stock	12.2782	12.28	12.1861	12.1864	36247932.0
2011-02-24 11:00:00	AAPL	Stock	12.1864	12.2082	12.1275	12.1957	49246596.0
2011-02-24 11:30:00	AAPL	Stock	12.1957	12.2056	12.1304	12.175	31945928.0
2011-02-24 12:00:00	AAPL	Stock	12.175	12.1918	12.1293	12.14	19941208.0
2011-02-24 12:30:00	AAPL	Stock	12.14	12.1879	12.1393	12.1843	15983268.0
2011-02-24 13:00:00	AAPL	Stock	12.1839	12.1964	12.1529	12.1604	14096796.0
2011-02-24 13:30:00	AAPL	Stock	12.16	12.1679	12.0846	12.0964	34166636.0
2011-02-24 14:00:00	AAPL	Stock	12.095	12.1886	12.0936	12.1815	34376328.0
2011-02-24 14:30:00	AAPL	Stock	12.1789	12.2286	12.1647	12.2218	37022888.0
2011-02-24 15:00:00	AAPL	Stock	12.2207	12.2804	12.2021	12.2779	40552232.0
2011-02-24 15:30:00	AAPL	Stock	12.2771	12.2857	12.2346	12.2346	44175740.0
2011-02-24 16:00:00	AAPL	Stock	12.235	12.25	12.2086	12.2311	14764232.0
2011-02-24 16:30:00	AAPL	Stock	12.2282	12.2781	12.1808	12.2107	980952.0
2011-02-24 17:00:00	AAPL	Stock	12.2107	12.2364	12.2107	12.2264	795032.0
2011-02-24 17:30:00	AAPL	Stock	12.2236	12.2311	12.2179	12.2229	87976.0
2011-02-24 18:00:00	AAPL	Stock	12.2314	12.2493	12.225	12.2493	399392.0
2011-02-24 18:30:00	AAPL	Stock	12.2393	12.2464	12.2393	12.2464	36400.0
2011-02-24 19:00:00	AAPL	Stock	12.2482	12.2564	12.2482	12.2564	46592.0
2011-02-24 19:30:00	AAPL	Stock	12.2536	12.2554	12.2482	12.2554	107884.0
2011-02-24 04:30:00	MSFT	Stock	26.39	26.39	26.38	26.38	200.0
2011-02-24 06:30:00	MSFT	Stock	26.38	26.4	26.35	26.35	1100.0
2011-02-24 07:00:00	MSFT	Stock	26.44	26.45	26.44	26.44	2525.0
2011-02-24 07:30:00	MSFT	Stock	26.41	26.55	26.39	26.4	5000.0
2011-02-24 08:00:00	MSFT	Stock	26.44	26.49	26.4	26.49	10449.0
2011-02-24 08:30:00	MSFT	Stock	26.52	26.64	26.48	26.53	10955.0
2011-02-24 09:00:00	MSFT	Stock	26.54	26.72	26.54	26.68	69350.0
2011-02-24 09:30:00	MSFT	Stock	26.65	26.95	26.62	26.92	6898526.0
2011-02-24 10:00:00	MSFT	Stock	26.92	27.06	26.88	26.95	7532755.0
2011-02-24 10:30:00	MSFT	Stock	26.95	26.96	26.78	26.82	3952533.0
2011-02-24 11:00:00	MSFT	Stock	26.82	26.85	26.66	26.76	4086175.0
2011-02-24 11:30:00	MSFT	Stock	26.76	26.78	26.62	26.7	2587896.0
2011-02-24 12:00:00	MSFT	Stock	26.695	26.72	26.58	26.64	2437506.0
2011-02-24 12:30:00	MSFT	Stock	26.646	26.7	26.62	26.688	2133725.0
2011-02-24 13:00:00	MSFT	Stock	26.68	26.74	26.6	26.622	2377479.0
2011-02-24 13:30:00	MSFT	Stock	26.63	26.67	26.5	26.546	2914393.0
2011-02-24 14:00:00	MSFT	Stock	26.55	26.81	26.54	26.8	4379342.0
2011-02-24 14:30:00	MSFT	Stock	26.8	26.93	26.77	26.88	7045361.0
2011-02-24 15:00:00	MSFT	Stock	26.88	26.89	26.78	26.87	4313899.0
2011-02-24 15:30:00	MSFT	Stock	26.87	26.95	26.75	26.76	6607761.0

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

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