PREVIEW / stock_30min / 2010-03-24

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-03-24.parquet
  size:    1.4 MB
  rows:    75,225
  symbols: 3,457

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
2010-03-24 04:00:00	AAPL	Stock	8.1596	8.1596	8.1596	8.1596	22400.0
2010-03-24 04:30:00	AAPL	Stock	8.1396	8.1396	8.1346	8.1346	7644.0
2010-03-24 05:00:00	AAPL	Stock	8.1	8.1086	8.1	8.1086	36876.0
2010-03-24 05:30:00	AAPL	Stock	8.1107	8.1107	8.1107	8.1107	5600.0
2010-03-24 06:00:00	AAPL	Stock	8.1111	8.1179	8.1107	8.1107	48048.0
2010-03-24 06:30:00	AAPL	Stock	8.1107	8.1107	8.1079	8.1079	16352.0
2010-03-24 07:00:00	AAPL	Stock	8.125	8.1286	8.1114	8.125	179088.0
2010-03-24 07:30:00	AAPL	Stock	8.1232	8.1304	8.1232	8.1254	225596.0
2010-03-24 08:00:00	AAPL	Stock	8.1254	8.1432	8.1218	8.1289	1163904.0
2010-03-24 08:30:00	AAPL	Stock	8.1321	8.1354	8.1189	8.1286	780276.0
2010-03-24 09:00:00	AAPL	Stock	8.13	8.1364	8.1161	8.1314	1127364.0
2010-03-24 09:30:00	AAPL	Stock	8.13	8.1921	8.1254	8.1785	91062860.0
2010-03-24 10:00:00	AAPL	Stock	8.1775	8.2071	8.1571	8.2043	59326568.0
2010-03-24 10:30:00	AAPL	Stock	8.2043	8.2214	8.1936	8.2108	61458824.0
2010-03-24 11:00:00	AAPL	Stock	8.2107	8.2196	8.1682	8.1911	51033304.0
2010-03-24 11:30:00	AAPL	Stock	8.1907	8.2089	8.1797	8.2082	23479428.0
2010-03-24 12:00:00	AAPL	Stock	8.208	8.2129	8.1943	8.2054	16660616.0
2010-03-24 12:30:00	AAPL	Stock	8.205	8.2118	8.198	8.2029	17945340.0
2010-03-24 13:00:00	AAPL	Stock	8.2029	8.2093	8.1929	8.2014	21781648.0
2010-03-24 13:30:00	AAPL	Stock	8.2021	8.21	8.1857	8.2	19883472.0
2010-03-24 14:00:00	AAPL	Stock	8.1997	8.2125	8.1918	8.2029	20967604.0
2010-03-24 14:30:00	AAPL	Stock	8.2029	8.2161	8.1843	8.1868	31735340.0
2010-03-24 15:00:00	AAPL	Stock	8.1871	8.21	8.1829	8.2007	27336456.0
2010-03-24 15:30:00	AAPL	Stock	8.2017	8.2129	8.1911	8.1914	56982660.0
2010-03-24 16:00:00	AAPL	Stock	8.1918	8.2022	8.16	8.1918	6430256.0
2010-03-24 16:30:00	AAPL	Stock	8.1929	8.2035	8.1893	8.1971	356216.0
2010-03-24 17:00:00	AAPL	Stock	8.1964	8.1971	8.1929	8.1929	97188.0
2010-03-24 17:30:00	AAPL	Stock	8.1907	8.1968	8.1893	8.1968	33600.0
2010-03-24 18:00:00	AAPL	Stock	8.1911	8.1929	8.1911	8.1911	19908.0
2010-03-24 18:30:00	AAPL	Stock	8.1954	8.1964	8.1929	8.1946	155008.0
2010-03-24 19:00:00	AAPL	Stock	8.1911	8.1946	8.1911	8.1946	156296.0
2010-03-24 19:30:00	AAPL	Stock	8.1929	8.1993	8.1925	8.1925	176400.0
2010-03-24 06:30:00	MSFT	Stock	29.67	29.67	29.67	29.67	1000.0
2010-03-24 07:00:00	MSFT	Stock	29.69	29.74	29.69	29.71	4042.0
2010-03-24 08:00:00	MSFT	Stock	29.84	29.84	29.77	29.83	8482.0
2010-03-24 08:30:00	MSFT	Stock	29.8	29.83	29.79	29.79	6476.0
2010-03-24 09:00:00	MSFT	Stock	29.8	29.8	29.69	29.73	24115.0
2010-03-24 09:30:00	MSFT	Stock	29.74	29.8	29.6	29.72	4184057.0
2010-03-24 10:00:00	MSFT	Stock	29.72	29.85	29.68	29.76	3229504.0
2010-03-24 10:30:00	MSFT	Stock	29.76	29.825	29.71	29.75	2765902.0
2010-03-24 11:00:00	MSFT	Stock	29.755	29.79	29.62	29.67	2771618.0
2010-03-24 11:30:00	MSFT	Stock	29.662	29.79	29.643	29.78	1867795.0
2010-03-24 12:00:00	MSFT	Stock	29.79	29.8	29.71	29.738	1439995.0
2010-03-24 12:30:00	MSFT	Stock	29.735	29.79	29.72	29.77	1398307.0
2010-03-24 13:00:00	MSFT	Stock	29.76	29.77	29.64	29.692	2036464.0
2010-03-24 13:30:00	MSFT	Stock	29.7	29.756	29.63	29.72	1975348.0
2010-03-24 14:00:00	MSFT	Stock	29.72	29.73	29.66	29.675	1760252.0
2010-03-24 14:30:00	MSFT	Stock	29.675	29.71	29.64	29.668	1938185.0
2010-03-24 15:00:00	MSFT	Stock	29.67	29.73	29.65	29.695	1339861.0
2010-03-24 15:30:00	MSFT	Stock	29.69	29.75	29.63	29.66	4845747.0

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

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