PREVIEW / stock_30min / 2011-03-24

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-03-24.parquet
  size:    1.4 MB
  rows:    74,518
  symbols: 3,510

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-03-24 04:00:00	AAPL	Stock	12.1139	12.1139	12.1139	12.1139	2800.0
2011-03-24 05:00:00	AAPL	Stock	12.1475	12.1475	12.1475	12.1475	8400.0
2011-03-24 06:00:00	AAPL	Stock	12.1707	12.1821	12.1707	12.1821	5600.0
2011-03-24 07:00:00	AAPL	Stock	12.1768	12.2039	12.1768	12.1786	84196.0
2011-03-24 07:30:00	AAPL	Stock	12.1893	12.1907	12.1786	12.1886	135184.0
2011-03-24 08:00:00	AAPL	Stock	12.1879	12.2314	12.1786	12.1964	1445416.0
2011-03-24 08:30:00	AAPL	Stock	12.1971	12.205	12.1911	12.1968	1073128.0
2011-03-24 09:00:00	AAPL	Stock	12.1986	12.2136	12.1943	12.2111	899332.0
2011-03-24 09:30:00	AAPL	Stock	12.21	12.2132	12.1021	12.1436	57039920.0
2011-03-24 10:00:00	AAPL	Stock	12.1439	12.1843	12.1218	12.17	30861068.0
2011-03-24 10:30:00	AAPL	Stock	12.1682	12.2293	12.1682	12.2257	34463184.0
2011-03-24 11:00:00	AAPL	Stock	12.2236	12.2607	12.2171	12.2232	44339428.0
2011-03-24 11:30:00	AAPL	Stock	12.2232	12.2489	12.2232	12.24	18646124.0
2011-03-24 12:00:00	AAPL	Stock	12.2411	12.2679	12.2332	12.2621	17737384.0
2011-03-24 12:30:00	AAPL	Stock	12.2625	12.2646	12.2368	12.2557	17256484.0
2011-03-24 13:00:00	AAPL	Stock	12.2561	12.2846	12.2511	12.2807	17145184.0
2011-03-24 13:30:00	AAPL	Stock	12.2814	12.3	12.2439	12.2691	26439168.0
2011-03-24 14:00:00	AAPL	Stock	12.2693	12.2946	12.2687	12.2868	15946672.0
2011-03-24 14:30:00	AAPL	Stock	12.2869	12.3043	12.2832	12.2961	20782384.0
2011-03-24 15:00:00	AAPL	Stock	12.2936	12.3296	12.2872	12.3236	32645648.0
2011-03-24 15:30:00	AAPL	Stock	12.3243	12.3281	12.3086	12.3225	41948424.0
2011-03-24 16:00:00	AAPL	Stock	12.3246	12.3279	12.2321	12.3214	14313852.0
2011-03-24 16:30:00	AAPL	Stock	12.3214	12.3251	12.3125	12.3179	208880.0
2011-03-24 17:00:00	AAPL	Stock	12.3204	12.3518	12.3204	12.3504	541100.0
2011-03-24 17:30:00	AAPL	Stock	12.3536	12.3846	12.3536	12.3671	952504.0
2011-03-24 18:00:00	AAPL	Stock	12.3664	12.3929	12.3204	12.3893	695100.0
2011-03-24 18:30:00	AAPL	Stock	12.3821	12.3875	12.3746	12.3825	264460.0
2011-03-24 19:00:00	AAPL	Stock	12.3839	12.3871	12.375	12.3857	152320.0
2011-03-24 19:30:00	AAPL	Stock	12.3786	12.3893	12.3768	12.3839	114912.0
2011-03-24 05:00:00	MSFT	Stock	25.69	25.7	25.68	25.68	500.0
2011-03-24 05:30:00	MSFT	Stock	25.69	25.69	25.68	25.68	6100.0
2011-03-24 07:30:00	MSFT	Stock	25.64	25.67	25.55	25.67	5000.0
2011-03-24 08:00:00	MSFT	Stock	25.63	25.68	25.63	25.65	7620.0
2011-03-24 08:30:00	MSFT	Stock	25.66	25.68	25.65	25.67	6500.0
2011-03-24 09:00:00	MSFT	Stock	25.65	25.68	25.54	25.6	77889.0
2011-03-24 09:30:00	MSFT	Stock	25.61	25.66	25.5	25.61	4248865.0
2011-03-24 10:00:00	MSFT	Stock	25.61	25.68	25.6	25.648	2071664.0
2011-03-24 10:30:00	MSFT	Stock	25.645	25.825	25.64	25.81	2871894.0
2011-03-24 11:00:00	MSFT	Stock	25.815	25.86	25.74	25.825	3892645.0
2011-03-24 11:30:00	MSFT	Stock	25.83	25.84	25.75	25.82	1595602.0
2011-03-24 12:00:00	MSFT	Stock	25.82	25.86	25.78	25.795	1967622.0
2011-03-24 12:30:00	MSFT	Stock	25.8	25.85	25.77	25.795	2419477.0
2011-03-24 13:00:00	MSFT	Stock	25.8	25.81	25.71	25.74	1930267.0
2011-03-24 13:30:00	MSFT	Stock	25.74	25.79	25.73	25.774	2174921.0
2011-03-24 14:00:00	MSFT	Stock	25.775	25.83	25.76	25.81	1418529.0
2011-03-24 14:30:00	MSFT	Stock	25.815	25.83	25.76	25.802	2384899.0
2011-03-24 15:00:00	MSFT	Stock	25.805	25.87	25.76	25.86	2533255.0
2011-03-24 15:30:00	MSFT	Stock	25.85	25.86	25.79	25.81	5323370.0
2011-03-24 16:00:00	MSFT	Stock	25.815	25.84	25.58	25.75	1914050.0
2011-03-24 16:30:00	MSFT	Stock	25.76	25.853	25.73	25.79	18684.0

> showing 50 of 74,518 rows — these rows as CSV

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