PREVIEW / stock_30min / 2013-01-17

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-01-17.parquet
  size:    1.4 MB
  rows:    75,409
  symbols: 3,473

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-01-17 04:00:00	AAPL	Stock	18.0643	18.2143	18.0643	18.1786	94164.0
2013-01-17 04:30:00	AAPL	Stock	18.1893	18.2143	18.1786	18.2036	64120.0
2013-01-17 05:00:00	AAPL	Stock	18.1964	18.2054	18.1839	18.1911	135744.0
2013-01-17 05:30:00	AAPL	Stock	18.1911	18.1911	18.1432	18.1614	96488.0
2013-01-17 06:00:00	AAPL	Stock	18.1696	18.1943	18.1607	18.1671	47600.0
2013-01-17 06:30:00	AAPL	Stock	18.1671	18.1964	18.1643	18.1964	78400.0
2013-01-17 07:00:00	AAPL	Stock	18.1786	18.2464	18.1782	18.1786	340732.0
2013-01-17 07:30:00	AAPL	Stock	18.1786	18.2143	18.1679	18.2107	544768.0
2013-01-17 08:00:00	AAPL	Stock	18.2036	18.2496	18.0907	18.1571	3485720.0
2013-01-17 08:30:00	AAPL	Stock	18.1604	18.2411	18.1511	18.2121	3332980.0
2013-01-17 09:00:00	AAPL	Stock	18.2098	18.2364	18.1696	18.2143	4560136.0
2013-01-17 09:30:00	AAPL	Stock	18.2254	18.2411	17.9502	18.0275	96468736.0
2013-01-17 10:00:00	AAPL	Stock	18.0275	18.125	17.9821	18.0518	46783184.0
2013-01-17 10:30:00	AAPL	Stock	18.0502	18.065	17.9771	17.9921	30465596.0
2013-01-17 11:00:00	AAPL	Stock	17.9964	18.0489	17.9761	18.0429	20037388.0
2013-01-17 11:30:00	AAPL	Stock	18.0429	18.0536	17.9414	17.9414	23107672.0
2013-01-17 12:00:00	AAPL	Stock	17.9414	18.0086	17.9411	17.9754	21358036.0
2013-01-17 12:30:00	AAPL	Stock	17.9732	17.9943	17.9296	17.9789	20515936.0
2013-01-17 13:00:00	AAPL	Stock	17.975	18.0532	17.9671	18.0264	21632772.0
2013-01-17 13:30:00	AAPL	Stock	18.0304	18.0786	18.0036	18.075	19542768.0
2013-01-17 14:00:00	AAPL	Stock	18.075	18.125	18.0496	18.0568	30639140.0
2013-01-17 14:30:00	AAPL	Stock	18.0604	18.0914	18.0168	18.0329	18504136.0
2013-01-17 15:00:00	AAPL	Stock	18.0336	18.0489	17.9575	17.9675	22870176.0
2013-01-17 15:30:00	AAPL	Stock	17.9704	17.9929	17.9359	17.9536	37850120.0
2013-01-17 16:00:00	AAPL	Stock	17.9534	18.0318	17.9036	17.9036	13284908.0
2013-01-17 16:30:00	AAPL	Stock	17.9096	17.967	17.8593	17.8754	1135260.0
2013-01-17 17:00:00	AAPL	Stock	17.8804	17.9529	17.8679	17.8679	363496.0
2013-01-17 17:30:00	AAPL	Stock	17.8611	17.8911	17.8532	17.8911	798420.0
2013-01-17 18:00:00	AAPL	Stock	17.8929	17.8929	17.8843	17.8904	190988.0
2013-01-17 18:30:00	AAPL	Stock	17.8861	17.8904	17.875	17.8857	70700.0
2013-01-17 19:00:00	AAPL	Stock	18.04	18.04	17.8754	17.8857	174160.0
2013-01-17 19:30:00	AAPL	Stock	17.8875	17.9286	17.8857	17.9286	686336.0
2013-01-17 07:00:00	MSFT	Stock	27.18	27.18	27.17	27.17	10600.0
2013-01-17 07:30:00	MSFT	Stock	27.16	27.16	27.16	27.16	1000.0
2013-01-17 08:00:00	MSFT	Stock	27.01	27.13	26.99	27.12	13815.0
2013-01-17 08:30:00	MSFT	Stock	27.12	27.14	27.11	27.13	14764.0
2013-01-17 09:00:00	MSFT	Stock	27.12	27.21	27.1	27.19	50602.0
2013-01-17 09:30:00	MSFT	Stock	27.19	27.22	27.06	27.195	5147418.0
2013-01-17 10:00:00	MSFT	Stock	27.19	27.28	27.15	27.275	4442257.0
2013-01-17 10:30:00	MSFT	Stock	27.275	27.31	27.22	27.25	3923955.0
2013-01-17 11:00:00	MSFT	Stock	27.255	27.33	27.22	27.33	2586454.0
2013-01-17 11:30:00	MSFT	Stock	27.33	27.37	27.31	27.32	2967287.0
2013-01-17 12:00:00	MSFT	Stock	27.32	27.38	27.32	27.378	2148925.0
2013-01-17 12:30:00	MSFT	Stock	27.38	27.4	27.35	27.38	2719481.0
2013-01-17 13:00:00	MSFT	Stock	27.38	27.4	27.35	27.38	2032603.0
2013-01-17 13:30:00	MSFT	Stock	27.373	27.47	27.36	27.47	2895744.0
2013-01-17 14:00:00	MSFT	Stock	27.47	27.47	27.42	27.43	1891829.0
2013-01-17 14:30:00	MSFT	Stock	27.43	27.445	27.342	27.37	2688399.0
2013-01-17 15:00:00	MSFT	Stock	27.38	27.38	27.27	27.35	3147090.0
2013-01-17 15:30:00	MSFT	Stock	27.35	27.36	27.23	27.23	7741026.0

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

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