PREVIEW / stock_30min / 2013-10-18

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-10-18.parquet
  size:    1.6 MB
  rows:    82,065
  symbols: 3,540

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
2013-10-18 04:00:00	AAPL	Stock	18.0839	18.1429	18.0839	18.1393	75600.0
2013-10-18 04:30:00	AAPL	Stock	18.1429	18.1429	18.125	18.125	36008.0
2013-10-18 05:00:00	AAPL	Stock	18.1357	18.1393	18.125	18.125	103376.0
2013-10-18 05:30:00	AAPL	Stock	18.1125	18.1125	18.0768	18.0829	30800.0
2013-10-18 06:00:00	AAPL	Stock	18.1071	18.1143	18.1071	18.1071	53956.0
2013-10-18 06:30:00	AAPL	Stock	18.0982	18.1161	18.0982	18.1071	36288.0
2013-10-18 07:00:00	AAPL	Stock	18.1071	18.1607	18.1071	18.1321	341432.0
2013-10-18 07:30:00	AAPL	Stock	18.1321	18.1429	18.1161	18.1268	447272.0
2013-10-18 08:00:00	AAPL	Stock	18.1268	18.1814	18.0	18.1432	2629172.0
2013-10-18 08:30:00	AAPL	Stock	18.15	18.1761	18.1429	18.1536	850416.0
2013-10-18 09:00:00	AAPL	Stock	18.1536	18.1643	18.0593	18.075	2767912.0
2013-10-18 09:30:00	AAPL	Stock	18.075	18.1429	18.0611	18.135	60068036.0
2013-10-18 10:00:00	AAPL	Stock	18.135	18.1879	18.1143	18.1193	31839444.0
2013-10-18 10:30:00	AAPL	Stock	18.1196	18.1804	18.1168	18.1761	19379948.0
2013-10-18 11:00:00	AAPL	Stock	18.1771	18.1846	18.1607	18.1643	13227564.0
2013-10-18 11:30:00	AAPL	Stock	18.1643	18.1786	18.1432	18.1714	11487784.0
2013-10-18 12:00:00	AAPL	Stock	18.1711	18.1718	18.1425	18.1529	9065504.0
2013-10-18 12:30:00	AAPL	Stock	18.1529	18.17	18.1475	18.1571	12575864.0
2013-10-18 13:00:00	AAPL	Stock	18.1571	18.1607	18.1318	18.1334	10451644.0
2013-10-18 13:30:00	AAPL	Stock	18.1325	18.1625	18.1286	18.1535	8922340.0
2013-10-18 14:00:00	AAPL	Stock	18.1518	18.1589	18.1375	18.1507	9130100.0
2013-10-18 14:30:00	AAPL	Stock	18.1511	18.1636	18.1396	18.1614	12241852.0
2013-10-18 15:00:00	AAPL	Stock	18.1611	18.1661	18.1421	18.1536	15934520.0
2013-10-18 15:30:00	AAPL	Stock	18.1532	18.1782	18.1368	18.1725	38990728.0
2013-10-18 16:00:00	AAPL	Stock	18.1768	18.1857	17.9985	18.1696	12748456.0
2013-10-18 16:30:00	AAPL	Stock	18.1804	18.1804	18.1535	18.1779	1567944.0
2013-10-18 17:00:00	AAPL	Stock	18.1714	18.1779	18.1625	18.1768	144788.0
2013-10-18 17:30:00	AAPL	Stock	18.1607	18.1857	18.1607	18.1786	293664.0
2013-10-18 18:00:00	AAPL	Stock	18.1768	18.1821	18.1768	18.1796	939344.0
2013-10-18 18:30:00	AAPL	Stock	18.1821	18.1857	18.1786	18.1846	70364.0
2013-10-18 19:00:00	AAPL	Stock	18.1807	18.1839	18.1714	18.1839	186536.0
2013-10-18 19:30:00	AAPL	Stock	18.1857	18.1946	18.1857	18.1946	194516.0
2013-10-18 06:30:00	MSFT	Stock	34.94	34.94	34.94	34.94	150.0
2013-10-18 07:00:00	MSFT	Stock	35.06	35.06	35.05	35.05	519.0
2013-10-18 07:30:00	MSFT	Stock	35.06	35.06	34.8	34.92	1211.0
2013-10-18 08:00:00	MSFT	Stock	35.0	35.0	34.82	34.91	940.0
2013-10-18 08:30:00	MSFT	Stock	34.94	34.94	34.88	34.89	5100.0
2013-10-18 09:00:00	MSFT	Stock	34.89	34.91	34.73	34.74	98528.0
2013-10-18 09:30:00	MSFT	Stock	34.74	34.82	34.33	34.56	11641050.0
2013-10-18 10:00:00	MSFT	Stock	34.57	34.68	34.5	34.64	3658650.0
2013-10-18 10:30:00	MSFT	Stock	34.64	34.8	34.62	34.765	2059622.0
2013-10-18 11:00:00	MSFT	Stock	34.76	34.83	34.6	34.688	2500982.0
2013-10-18 11:30:00	MSFT	Stock	34.69	34.78	34.68	34.709	1593310.0
2013-10-18 12:00:00	MSFT	Stock	34.709	34.74	34.68	34.7	1139195.0
2013-10-18 12:30:00	MSFT	Stock	34.71	34.78	34.7	34.75	996805.0
2013-10-18 13:00:00	MSFT	Stock	34.749	34.9	34.745	34.885	1431270.0
2013-10-18 13:30:00	MSFT	Stock	34.885	34.96	34.85	34.955	955636.0
2013-10-18 14:00:00	MSFT	Stock	34.96	34.96	34.86	34.905	1376002.0
2013-10-18 14:30:00	MSFT	Stock	34.91	34.93	34.85	34.86	1417406.0
2013-10-18 15:00:00	MSFT	Stock	34.86	34.9	34.84	34.9	1551728.0

> showing 50 of 82,065 rows — these rows as CSV

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