PREVIEW / stock_30min / 2011-12-22

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-12-22.parquet
  size:    1.4 MB
  rows:    75,814
  symbols: 3,536

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-12-22 04:00:00	AAPL	Stock	14.1429	14.2114	14.1429	14.2114	14000.0
2011-12-22 04:30:00	AAPL	Stock	14.1936	14.1936	14.1936	14.1936	2800.0
2011-12-22 05:30:00	AAPL	Stock	14.1429	14.1454	14.1429	14.1454	14000.0
2011-12-22 06:00:00	AAPL	Stock	14.1489	14.1493	14.1432	14.1493	11200.0
2011-12-22 06:30:00	AAPL	Stock	14.1536	14.1536	14.1536	14.1536	11200.0
2011-12-22 07:00:00	AAPL	Stock	14.1625	14.1875	14.1557	14.1786	36400.0
2011-12-22 07:30:00	AAPL	Stock	14.1836	14.1964	14.1836	14.1964	166516.0
2011-12-22 08:00:00	AAPL	Stock	14.1925	14.2179	14.1857	14.2139	757512.0
2011-12-22 08:30:00	AAPL	Stock	14.2143	14.2175	14.1786	14.1786	1079988.0
2011-12-22 09:00:00	AAPL	Stock	14.1839	14.1943	14.1786	14.1789	867916.0
2011-12-22 09:30:00	AAPL	Stock	14.1789	14.2454	14.1464	14.2196	41302604.0
2011-12-22 10:00:00	AAPL	Stock	14.2232	14.2393	14.2039	14.2303	19264728.0
2011-12-22 10:30:00	AAPL	Stock	14.2304	14.2357	14.1986	14.2139	13522740.0
2011-12-22 11:00:00	AAPL	Stock	14.2136	14.2318	14.2036	14.2104	11971652.0
2011-12-22 11:30:00	AAPL	Stock	14.2107	14.2179	14.2007	14.2107	8284332.0
2011-12-22 12:00:00	AAPL	Stock	14.2139	14.25	14.2093	14.2482	13528816.0
2011-12-22 12:30:00	AAPL	Stock	14.2482	14.2546	14.2268	14.2471	12324172.0
2011-12-22 13:00:00	AAPL	Stock	14.2475	14.2518	14.2332	14.2429	6248816.0
2011-12-22 13:30:00	AAPL	Stock	14.2431	14.2496	14.2361	14.2364	6552392.0
2011-12-22 14:00:00	AAPL	Stock	14.2386	14.2411	14.2154	14.2375	9797200.0
2011-12-22 14:30:00	AAPL	Stock	14.2371	14.2389	14.2186	14.226	8608880.0
2011-12-22 15:00:00	AAPL	Stock	14.2268	14.2368	14.2161	14.23	11113844.0
2011-12-22 15:30:00	AAPL	Stock	14.2304	14.2404	14.2214	14.2311	22937040.0
2011-12-22 16:00:00	AAPL	Stock	14.2304	14.2382	14.1587	14.2311	7434644.0
2011-12-22 16:30:00	AAPL	Stock	14.2321	14.2375	14.2207	14.2375	2086616.0
2011-12-22 17:00:00	AAPL	Stock	14.2097	14.2439	14.2097	14.2439	106708.0
2011-12-22 17:30:00	AAPL	Stock	14.2407	14.2454	14.2382	14.2454	173740.0
2011-12-22 18:00:00	AAPL	Stock	14.2414	14.2418	14.2343	14.2361	36456.0
2011-12-22 18:30:00	AAPL	Stock	14.2429	14.2461	14.2429	14.245	104272.0
2011-12-22 19:00:00	AAPL	Stock	14.2461	14.2471	14.2364	14.245	117432.0
2011-12-22 19:30:00	AAPL	Stock	14.2454	14.25	14.2432	14.2436	252588.0
2011-12-22 04:30:00	MSFT	Stock	25.78	25.78	25.78	25.78	150.0
2011-12-22 06:30:00	MSFT	Stock	25.8	25.8	25.8	25.8	995.0
2011-12-22 07:00:00	MSFT	Stock	25.8	25.8	25.8	25.8	4005.0
2011-12-22 08:00:00	MSFT	Stock	25.85	25.85	25.8	25.82	5350.0
2011-12-22 08:30:00	MSFT	Stock	25.82	25.82	25.76	25.77	16900.0
2011-12-22 09:00:00	MSFT	Stock	25.77	25.89	25.77	25.82	15144.0
2011-12-22 09:30:00	MSFT	Stock	25.82	25.86	25.6	25.67	5643858.0
2011-12-22 10:00:00	MSFT	Stock	25.669	25.72	25.54	25.66	3604818.0
2011-12-22 10:30:00	MSFT	Stock	25.655	25.66	25.55	25.62	2371104.0
2011-12-22 11:00:00	MSFT	Stock	25.62	25.71	25.619	25.705	2894752.0
2011-12-22 11:30:00	MSFT	Stock	25.709	25.75	25.68	25.69	2382020.0
2011-12-22 12:00:00	MSFT	Stock	25.7	25.76	25.69	25.75	1586678.0
2011-12-22 12:30:00	MSFT	Stock	25.75	25.8	25.74	25.755	1575397.0
2011-12-22 13:00:00	MSFT	Stock	25.755	25.761	25.7	25.73	2064774.0
2011-12-22 13:30:00	MSFT	Stock	25.735	25.8	25.715	25.76	1585489.0
2011-12-22 14:00:00	MSFT	Stock	25.76	25.8	25.73	25.795	1508732.0
2011-12-22 14:30:00	MSFT	Stock	25.8	25.81	25.78	25.785	1850498.0
2011-12-22 15:00:00	MSFT	Stock	25.79	25.8	25.73	25.771	1569174.0
2011-12-22 15:30:00	MSFT	Stock	25.775	25.82	25.77	25.81	4170431.0

> showing 50 of 75,814 rows — these rows as CSV

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