PREVIEW / stock_30min / 2015-02-26

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-02-26.parquet
  size:    1.6 MB
  rows:    82,875
  symbols: 3,501

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
2015-02-26 04:00:00	AAPL	Stock	32.15	32.1925	32.15	32.1875	56912.0
2015-02-26 04:30:00	AAPL	Stock	32.1875	32.2425	32.1875	32.2425	12400.0
2015-02-26 05:00:00	AAPL	Stock	32.225	32.25	32.2125	32.245	7788.0
2015-02-26 05:30:00	AAPL	Stock	32.26	32.3075	32.26	32.305	7180.0
2015-02-26 06:00:00	AAPL	Stock	32.3025	32.3375	32.275	32.3375	91220.0
2015-02-26 06:30:00	AAPL	Stock	32.3175	32.345	32.3125	32.3125	42632.0
2015-02-26 07:00:00	AAPL	Stock	32.3175	32.3425	32.3075	32.325	82744.0
2015-02-26 07:30:00	AAPL	Stock	32.3275	32.3375	32.305	32.3075	141760.0
2015-02-26 08:00:00	AAPL	Stock	32.3175	32.3725	32.175	32.36	686440.0
2015-02-26 08:30:00	AAPL	Stock	32.3625	32.3725	32.24	32.24	732908.0
2015-02-26 09:00:00	AAPL	Stock	32.25	32.28	32.1375	32.21	554612.0
2015-02-26 09:30:00	AAPL	Stock	32.2075	32.2512	31.665	31.7075	61290248.0
2015-02-26 10:00:00	AAPL	Stock	31.71	31.885	31.6525	31.8775	32568496.0
2015-02-26 10:30:00	AAPL	Stock	31.8762	31.9575	31.8125	31.9225	18739636.0
2015-02-26 11:00:00	AAPL	Stock	31.9208	32.08	31.9185	32.0375	17721144.0
2015-02-26 11:30:00	AAPL	Stock	32.0375	32.35	32.035	32.3315	22752104.0
2015-02-26 12:00:00	AAPL	Stock	32.33	32.435	32.2125	32.415	25081740.0
2015-02-26 12:30:00	AAPL	Stock	32.4135	32.5175	32.4125	32.475	24195920.0
2015-02-26 13:00:00	AAPL	Stock	32.475	32.6725	32.4702	32.5872	25052204.0
2015-02-26 13:30:00	AAPL	Stock	32.5875	32.7175	32.565	32.5825	19415568.0
2015-02-26 14:00:00	AAPL	Stock	32.585	32.615	32.3	32.335	24620340.0
2015-02-26 14:30:00	AAPL	Stock	32.3375	32.4425	32.225	32.41	16728504.0
2015-02-26 15:00:00	AAPL	Stock	32.41	32.5575	32.2975	32.55	16129688.0
2015-02-26 15:30:00	AAPL	Stock	32.5498	32.6125	32.5125	32.6025	21325128.0
2015-02-26 16:00:00	AAPL	Stock	32.6038	32.6125	31.7618	32.605	6297180.0
2015-02-26 16:30:00	AAPL	Stock	32.605	32.605	32.2895	32.5975	1464120.0
2015-02-26 17:00:00	AAPL	Stock	32.6	32.6	32.5925	32.5975	103912.0
2015-02-26 17:30:00	AAPL	Stock	32.5975	32.6	32.5925	32.5952	75240.0
2015-02-26 18:00:00	AAPL	Stock	32.5975	32.605	32.5875	32.5878	140528.0
2015-02-26 18:30:00	AAPL	Stock	32.5875	32.6125	32.5875	32.6125	49952.0
2015-02-26 19:00:00	AAPL	Stock	32.6075	32.6075	32.5825	32.5825	51100.0
2015-02-26 19:30:00	AAPL	Stock	32.58	32.5825	32.5525	32.5575	116988.0
2015-02-26 06:00:00	MSFT	Stock	43.9	43.9	43.9	43.9	200.0
2015-02-26 07:00:00	MSFT	Stock	44.03	44.03	43.9	43.9	4729.0
2015-02-26 07:30:00	MSFT	Stock	44.02	44.02	43.97	43.97	200.0
2015-02-26 08:00:00	MSFT	Stock	43.99	43.99	43.99	43.99	5719.0
2015-02-26 08:30:00	MSFT	Stock	44.0	44.0	43.92	43.96	5586.0
2015-02-26 09:00:00	MSFT	Stock	44.01	44.01	43.91	43.95	5150.0
2015-02-26 09:30:00	MSFT	Stock	43.99	44.23	43.95	44.159	4137765.0
2015-02-26 10:00:00	MSFT	Stock	44.16	44.18	44.02	44.08	2279320.0
2015-02-26 10:30:00	MSFT	Stock	44.085	44.16	44.05	44.1	1361983.0
2015-02-26 11:00:00	MSFT	Stock	44.1	44.18	44.08	44.095	1360952.0
2015-02-26 11:30:00	MSFT	Stock	44.094	44.14	44.04	44.04	1234175.0
2015-02-26 12:00:00	MSFT	Stock	44.04	44.08	43.94	43.96	1222473.0
2015-02-26 12:30:00	MSFT	Stock	43.963	44.08	43.945	44.03	1151339.0
2015-02-26 13:00:00	MSFT	Stock	44.03	44.06	43.95	44.01	857756.0
2015-02-26 13:30:00	MSFT	Stock	44.0	44.02	43.92	43.95	1451898.0
2015-02-26 14:00:00	MSFT	Stock	43.96	43.99	43.92	43.97	1286820.0
2015-02-26 14:30:00	MSFT	Stock	43.971	43.98	43.92	43.96	1109892.0
2015-02-26 15:00:00	MSFT	Stock	43.95	44.04	43.89	44.02	2364407.0

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

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