PREVIEW / stock_30min / 2011-11-21

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-11-21.parquet
  size:    1.4 MB
  rows:    75,149
  symbols: 3,513

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-11-21 04:00:00	AAPL	Stock	13.1821	13.1975	13.1821	13.1975	14000.0
2011-11-21 04:30:00	AAPL	Stock	13.1893	13.1893	13.1332	13.1429	102200.0
2011-11-21 05:00:00	AAPL	Stock	13.1518	13.1518	13.1518	13.1518	8400.0
2011-11-21 05:30:00	AAPL	Stock	13.1836	13.2136	13.1786	13.2136	65240.0
2011-11-21 06:00:00	AAPL	Stock	13.2046	13.2046	13.2046	13.2046	2800.0
2011-11-21 06:30:00	AAPL	Stock	13.2104	13.2104	13.2104	13.2104	5600.0
2011-11-21 07:00:00	AAPL	Stock	13.2143	13.2232	13.1964	13.2232	387044.0
2011-11-21 07:30:00	AAPL	Stock	13.2218	13.2339	13.2179	13.2214	80360.0
2011-11-21 08:00:00	AAPL	Stock	13.225	13.2836	13.2143	13.2379	1777748.0
2011-11-21 08:30:00	AAPL	Stock	13.2368	13.2854	13.2329	13.2414	1598968.0
2011-11-21 09:00:00	AAPL	Stock	13.2429	13.2464	13.2154	13.2286	1463728.0
2011-11-21 09:30:00	AAPL	Stock	13.2286	13.2743	13.1107	13.1529	71092224.0
2011-11-21 10:00:00	AAPL	Stock	13.1571	13.1675	13.115	13.1368	42573580.0
2011-11-21 10:30:00	AAPL	Stock	13.1382	13.1461	13.075	13.0811	37478476.0
2011-11-21 11:00:00	AAPL	Stock	13.0764	13.1621	13.075	13.1232	35177688.0
2011-11-21 11:30:00	AAPL	Stock	13.1221	13.148	13.0736	13.1235	23916928.0
2011-11-21 12:00:00	AAPL	Stock	13.1236	13.1464	13.0725	13.0757	22521632.0
2011-11-21 12:30:00	AAPL	Stock	13.0757	13.1246	13.0682	13.0968	20911184.0
2011-11-21 13:00:00	AAPL	Stock	13.0964	13.1514	13.0954	13.1164	19672520.0
2011-11-21 13:30:00	AAPL	Stock	13.1179	13.1368	13.0821	13.0911	16664508.0
2011-11-21 14:00:00	AAPL	Stock	13.0946	13.1661	13.0839	13.1479	25974564.0
2011-11-21 14:30:00	AAPL	Stock	13.1457	13.1918	13.1425	13.1554	25987136.0
2011-11-21 15:00:00	AAPL	Stock	13.1557	13.2429	13.1325	13.2327	31254804.0
2011-11-21 15:30:00	AAPL	Stock	13.2327	13.2586	13.1789	13.1789	47271896.0
2011-11-21 16:00:00	AAPL	Stock	13.185	13.19	13.1181	13.1775	12517092.0
2011-11-21 16:30:00	AAPL	Stock	13.1654	13.2266	13.1579	13.1607	3579996.0
2011-11-21 17:00:00	AAPL	Stock	13.1607	13.1789	13.1429	13.1786	440748.0
2011-11-21 17:30:00	AAPL	Stock	13.18	13.2043	13.18	13.1964	342776.0
2011-11-21 18:00:00	AAPL	Stock	13.1946	13.1946	13.1707	13.1829	178584.0
2011-11-21 18:30:00	AAPL	Stock	13.1839	13.2	13.1786	13.1789	61964.0
2011-11-21 19:00:00	AAPL	Stock	13.1925	13.2029	13.1839	13.2029	19600.0
2011-11-21 19:30:00	AAPL	Stock	13.1861	13.2139	13.1861	13.2125	206276.0
2011-11-21 04:00:00	MSFT	Stock	25.1	25.1	25.05	25.05	500.0
2011-11-21 06:00:00	MSFT	Stock	25.17	25.17	25.12	25.12	300.0
2011-11-21 06:30:00	MSFT	Stock	25.05	25.05	25.05	25.05	400.0
2011-11-21 07:00:00	MSFT	Stock	25.04	25.04	24.95	24.95	1450.0
2011-11-21 07:30:00	MSFT	Stock	25.07	25.07	25.04	25.06	825.0
2011-11-21 08:00:00	MSFT	Stock	25.07	25.3	25.0	25.02	23165.0
2011-11-21 08:30:00	MSFT	Stock	25.03	25.1	25.02	25.09	26120.0
2011-11-21 09:00:00	MSFT	Stock	25.09	25.24	25.08	25.24	40947.0
2011-11-21 09:30:00	MSFT	Stock	25.24	25.25	25.09	25.115	4537824.0
2011-11-21 10:00:00	MSFT	Stock	25.12	25.13	25.0	25.06	5911055.0
2011-11-21 10:30:00	MSFT	Stock	25.055	25.15	24.96	24.97	5022589.0
2011-11-21 11:00:00	MSFT	Stock	24.97	25.059	24.95	25.005	3917425.0
2011-11-21 11:30:00	MSFT	Stock	25.0	25.04	24.9	24.956	3217862.0
2011-11-21 12:00:00	MSFT	Stock	24.95	25.0	24.92	24.95	2592233.0
2011-11-21 12:30:00	MSFT	Stock	24.95	25.03	24.935	24.995	3608678.0
2011-11-21 13:00:00	MSFT	Stock	25.0	25.06	24.99	25.03	3192991.0
2011-11-21 13:30:00	MSFT	Stock	25.03	25.046	24.98	24.99	2249184.0
2011-11-21 14:00:00	MSFT	Stock	24.99	25.1	24.97	25.04	3867769.0

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

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