PREVIEW / stock_30min / 2014-03-20

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-03-20.parquet
  size:    1.6 MB
  rows:    84,022
  symbols: 3,538

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
2014-03-20 06:00:00	AAPL	Stock	18.9114	18.9132	18.9032	18.9132	30800.0
2014-03-20 07:00:00	AAPL	Stock	18.9061	18.9061	18.9061	18.9061	2800.0
2014-03-20 07:30:00	AAPL	Stock	18.9107	18.965	18.9107	18.965	58800.0
2014-03-20 08:00:00	AAPL	Stock	18.88	18.9643	18.8789	18.9357	184800.0
2014-03-20 08:30:00	AAPL	Stock	18.9375	18.9571	18.925	18.9393	98812.0
2014-03-20 09:00:00	AAPL	Stock	18.9464	18.9571	18.9096	18.9229	768992.0
2014-03-20 09:30:00	AAPL	Stock	18.9246	19.0239	18.8446	18.9107	35438508.0
2014-03-20 10:00:00	AAPL	Stock	18.91	18.9711	18.8721	18.9304	16343712.0
2014-03-20 10:30:00	AAPL	Stock	18.9332	18.9475	18.875	18.8889	11585560.0
2014-03-20 11:00:00	AAPL	Stock	18.8882	18.9025	18.845	18.8761	11433660.0
2014-03-20 11:30:00	AAPL	Stock	18.8768	18.8807	18.8339	18.8711	10449460.0
2014-03-20 12:00:00	AAPL	Stock	18.8711	18.9182	18.8614	18.9159	6867280.0
2014-03-20 12:30:00	AAPL	Stock	18.9161	18.9568	18.9014	18.955	6881980.0
2014-03-20 13:00:00	AAPL	Stock	18.955	18.9736	18.9171	18.9204	7397712.0
2014-03-20 13:30:00	AAPL	Stock	18.9207	18.9389	18.8975	18.9129	4699800.0
2014-03-20 14:00:00	AAPL	Stock	18.9107	18.9379	18.8929	18.9371	5159840.0
2014-03-20 14:30:00	AAPL	Stock	18.9386	18.9582	18.8971	18.9036	5492844.0
2014-03-20 15:00:00	AAPL	Stock	18.9	18.9103	18.8679	18.8739	9074156.0
2014-03-20 15:30:00	AAPL	Stock	18.8754	18.9018	18.8482	18.8839	19662356.0
2014-03-20 16:00:00	AAPL	Stock	18.8821	18.9055	18.8796	18.8839	5331004.0
2014-03-20 16:30:00	AAPL	Stock	18.8844	18.8907	18.8786	18.8904	430696.0
2014-03-20 17:00:00	AAPL	Stock	18.8896	18.8929	18.875	18.8857	272104.0
2014-03-20 17:30:00	AAPL	Stock	18.8857	18.8857	18.8821	18.885	22428.0
2014-03-20 18:00:00	AAPL	Stock	18.885	18.885	18.8821	18.8821	89628.0
2014-03-20 18:30:00	AAPL	Stock	18.875	18.875	18.875	18.875	16660.0
2014-03-20 19:00:00	AAPL	Stock	18.8804	18.8804	18.8679	18.8757	19880.0
2014-03-20 19:30:00	AAPL	Stock	18.875	18.875	18.8607	18.8607	43344.0
2014-03-20 08:00:00	MSFT	Stock	39.15	39.15	39.15	39.15	100.0
2014-03-20 08:30:00	MSFT	Stock	39.08	39.169	39.08	39.169	620.0
2014-03-20 09:00:00	MSFT	Stock	39.11	39.29	39.11	39.26	40804.0
2014-03-20 09:30:00	MSFT	Stock	39.25	39.57	39.24	39.52	4402304.0
2014-03-20 10:00:00	MSFT	Stock	39.52	39.92	39.48	39.8	5456243.0
2014-03-20 10:30:00	MSFT	Stock	39.795	39.96	39.78	39.92	2963023.0
2014-03-20 11:00:00	MSFT	Stock	39.92	40.08	39.88	40.07	4204484.0
2014-03-20 11:30:00	MSFT	Stock	40.06	40.17	40.03	40.06	3080704.0
2014-03-20 12:00:00	MSFT	Stock	40.06	40.25	39.97	40.235	2409932.0
2014-03-20 12:30:00	MSFT	Stock	40.235	40.445	40.18	40.44	3805972.0
2014-03-20 13:00:00	MSFT	Stock	40.43	40.56	40.42	40.5	4515898.0
2014-03-20 13:30:00	MSFT	Stock	40.49	40.55	40.44	40.51	3740189.0
2014-03-20 14:00:00	MSFT	Stock	40.515	40.54	40.41	40.535	2357940.0
2014-03-20 14:30:00	MSFT	Stock	40.54	40.649	40.48	40.487	3565087.0
2014-03-20 15:00:00	MSFT	Stock	40.48	40.49	40.26	40.285	4464978.0
2014-03-20 15:30:00	MSFT	Stock	40.29	40.37	40.12	40.33	8208245.0
2014-03-20 16:00:00	MSFT	Stock	40.33	40.42	39.78	40.36	1955399.0
2014-03-20 16:30:00	MSFT	Stock	40.36	40.73	40.062	40.44	119515.0
2014-03-20 17:00:00	MSFT	Stock	40.44	40.44	39.27	40.42	1825192.0
2014-03-20 17:30:00	MSFT	Stock	40.381	40.4	40.33	40.36	5311.0
2014-03-20 18:00:00	MSFT	Stock	40.38	40.4	40.36	40.37	3465.0
2014-03-20 18:30:00	MSFT	Stock	40.37	40.39	40.37	40.39	4211.0
2014-03-20 19:00:00	MSFT	Stock	40.4	40.4	40.4	40.4	5378.0

> showing 50 of 84,022 rows — these rows as CSV

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