PREVIEW / stock_30min / 2011-05-19

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-05-19.parquet
  size:    1.4 MB
  rows:    75,173
  symbols: 3,547

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-05-19 04:00:00	AAPL	Stock	12.1346	12.1346	12.1346	12.1346	2800.0
2011-05-19 04:30:00	AAPL	Stock	12.125	12.125	12.1125	12.1125	11900.0
2011-05-19 05:00:00	AAPL	Stock	12.1125	12.1518	12.1125	12.1518	16800.0
2011-05-19 06:00:00	AAPL	Stock	12.1914	12.1914	12.1907	12.1907	5600.0
2011-05-19 06:30:00	AAPL	Stock	12.1904	12.1907	12.1904	12.1907	18088.0
2011-05-19 07:00:00	AAPL	Stock	12.19	12.1921	12.175	12.1871	68880.0
2011-05-19 07:30:00	AAPL	Stock	12.1789	12.1868	12.1732	12.1818	109760.0
2011-05-19 08:00:00	AAPL	Stock	12.1786	12.1964	12.1607	12.1821	554344.0
2011-05-19 08:30:00	AAPL	Stock	12.1843	12.2096	12.1839	12.2054	1098636.0
2011-05-19 09:00:00	AAPL	Stock	12.2071	12.2204	12.1975	12.2146	1182552.0
2011-05-19 09:30:00	AAPL	Stock	12.2161	12.2291	12.1767	12.1807	49734300.0
2011-05-19 10:00:00	AAPL	Stock	12.1807	12.1957	12.1468	12.1743	27897912.0
2011-05-19 10:30:00	AAPL	Stock	12.1736	12.175	12.1254	12.1404	22374100.0
2011-05-19 11:00:00	AAPL	Stock	12.1404	12.1554	12.1264	12.1345	15564276.0
2011-05-19 11:30:00	AAPL	Stock	12.1344	12.1393	12.0954	12.0996	16228520.0
2011-05-19 12:00:00	AAPL	Stock	12.1007	12.1679	12.0989	12.1679	19924464.0
2011-05-19 12:30:00	AAPL	Stock	12.1686	12.1771	12.15	12.1671	12055484.0
2011-05-19 13:00:00	AAPL	Stock	12.1671	12.1911	12.1536	12.1757	11396840.0
2011-05-19 13:30:00	AAPL	Stock	12.1754	12.1854	12.1654	12.175	11247628.0
2011-05-19 14:00:00	AAPL	Stock	12.1761	12.1914	12.1582	12.1729	15836660.0
2011-05-19 14:30:00	AAPL	Stock	12.1732	12.1782	12.1461	12.1496	11797660.0
2011-05-19 15:00:00	AAPL	Stock	12.1504	12.1757	12.1482	12.1704	12638920.0
2011-05-19 15:30:00	AAPL	Stock	12.17	12.1736	12.1575	12.1625	21103460.0
2011-05-19 16:00:00	AAPL	Stock	12.1625	12.2243	12.1468	12.1475	3767260.0
2011-05-19 16:30:00	AAPL	Stock	12.1518	12.1696	12.1504	12.165	2868152.0
2011-05-19 17:00:00	AAPL	Stock	12.1661	12.1661	12.1643	12.1657	19824.0
2011-05-19 17:30:00	AAPL	Stock	12.1625	12.1625	12.1625	12.1625	14000.0
2011-05-19 18:00:00	AAPL	Stock	12.1625	12.1675	12.1618	12.1671	51408.0
2011-05-19 18:30:00	AAPL	Stock	12.1685	12.1685	12.1607	12.1607	446880.0
2011-05-19 19:00:00	AAPL	Stock	12.1596	12.1596	12.1557	12.1557	19600.0
2011-05-19 19:30:00	AAPL	Stock	12.1571	12.1596	12.1532	12.1596	40348.0
2011-05-19 05:00:00	MSFT	Stock	24.65	24.65	24.65	24.65	100.0
2011-05-19 05:30:00	MSFT	Stock	24.65	24.65	24.65	24.65	900.0
2011-05-19 06:00:00	MSFT	Stock	24.68	24.7	24.68	24.7	1400.0
2011-05-19 07:00:00	MSFT	Stock	24.68	24.68	24.68	24.68	100.0
2011-05-19 07:30:00	MSFT	Stock	24.67	24.67	24.67	24.67	500.0
2011-05-19 08:00:00	MSFT	Stock	24.68	24.7	24.68	24.69	13178.0
2011-05-19 08:30:00	MSFT	Stock	24.7	24.72	24.69	24.69	43338.0
2011-05-19 09:00:00	MSFT	Stock	24.7	24.87	24.69	24.85	132843.0
2011-05-19 09:30:00	MSFT	Stock	24.85	24.88	24.66	24.73	4740135.0
2011-05-19 10:00:00	MSFT	Stock	24.73	24.73	24.6	24.65	4491051.0
2011-05-19 10:30:00	MSFT	Stock	24.643	24.66	24.55	24.56	2617989.0
2011-05-19 11:00:00	MSFT	Stock	24.57	24.605	24.5	24.58	3542521.0
2011-05-19 11:30:00	MSFT	Stock	24.58	24.62	24.55	24.61	2055482.0
2011-05-19 12:00:00	MSFT	Stock	24.61	24.8	24.61	24.79	3145162.0
2011-05-19 12:30:00	MSFT	Stock	24.78	24.83	24.74	24.76	1829826.0
2011-05-19 13:00:00	MSFT	Stock	24.765	24.82	24.75	24.803	1423833.0
2011-05-19 13:30:00	MSFT	Stock	24.805	24.82	24.74	24.765	1975963.0
2011-05-19 14:00:00	MSFT	Stock	24.76	24.8	24.68	24.7	2220459.0
2011-05-19 14:30:00	MSFT	Stock	24.7	24.73	24.65	24.72	1949686.0

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

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