PREVIEW / stock_30min / 2016-01-12

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-01-12.parquet
  size:    1.6 MB
  rows:    83,784
  symbols: 3,385

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
2016-01-12 04:00:00	AAPL	Stock	24.555	24.6725	24.555	24.6725	20116.0
2016-01-12 04:30:00	AAPL	Stock	24.725	24.725	24.685	24.685	14156.0
2016-01-12 05:00:00	AAPL	Stock	24.7425	24.7425	24.7	24.7125	9944.0
2016-01-12 05:30:00	AAPL	Stock	24.7125	24.805	24.7125	24.805	14060.0
2016-01-12 06:00:00	AAPL	Stock	24.825	25.1575	24.825	25.1375	504688.0
2016-01-12 06:30:00	AAPL	Stock	25.15	25.175	25.0475	25.065	205192.0
2016-01-12 07:00:00	AAPL	Stock	25.0525	25.1	25.0475	25.075	160684.0
2016-01-12 07:30:00	AAPL	Stock	25.075	25.1025	25.0375	25.075	330536.0
2016-01-12 08:00:00	AAPL	Stock	25.08	25.1375	25.05	25.07	987304.0
2016-01-12 08:30:00	AAPL	Stock	25.0575	25.1075	25.0475	25.1	354448.0
2016-01-12 09:00:00	AAPL	Stock	25.1	25.1375	25.05	25.1375	1056356.0
2016-01-12 09:30:00	AAPL	Stock	25.1375	25.1725	24.9575	25.095	35406952.0
2016-01-12 10:00:00	AAPL	Stock	25.095	25.155	24.9275	25.005	18131376.0
2016-01-12 10:30:00	AAPL	Stock	25.005	25.0445	24.8425	24.9315	12209452.0
2016-01-12 11:00:00	AAPL	Stock	24.925	24.9525	24.7775	24.8525	10477336.0
2016-01-12 11:30:00	AAPL	Stock	24.8525	24.925	24.785	24.9125	9964868.0
2016-01-12 12:00:00	AAPL	Stock	24.9125	24.9675	24.805	24.8385	8034392.0
2016-01-12 12:30:00	AAPL	Stock	24.835	24.875	24.7575	24.8075	8090200.0
2016-01-12 13:00:00	AAPL	Stock	24.8038	24.9225	24.8025	24.8222	7168668.0
2016-01-12 13:30:00	AAPL	Stock	24.8212	24.915	24.8	24.825	6292656.0
2016-01-12 14:00:00	AAPL	Stock	24.8275	24.8575	24.71	24.83	11751016.0
2016-01-12 14:30:00	AAPL	Stock	24.8275	24.93	24.82	24.9062	8952156.0
2016-01-12 15:00:00	AAPL	Stock	24.9052	24.9712	24.8	24.9225	10680540.0
2016-01-12 15:30:00	AAPL	Stock	24.9215	25.055	24.9	24.99	20100820.0
2016-01-12 16:00:00	AAPL	Stock	24.99	25.035	24.925	24.945	10479064.0
2016-01-12 16:30:00	AAPL	Stock	24.9475	24.9725	24.9125	24.925	94160.0
2016-01-12 17:00:00	AAPL	Stock	24.9475	24.9475	24.935	24.945	35648.0
2016-01-12 17:30:00	AAPL	Stock	24.945	24.955	24.91	24.925	65444.0
2016-01-12 18:00:00	AAPL	Stock	24.93	24.95	24.9225	24.95	26552.0
2016-01-12 18:30:00	AAPL	Stock	24.9525	24.99	24.94	24.975	37940.0
2016-01-12 19:00:00	AAPL	Stock	24.9875	25.02	24.9875	25.0	24288.0
2016-01-12 19:30:00	AAPL	Stock	25.0175	25.075	25.01	25.0725	99388.0
2016-01-12 04:00:00	MSFT	Stock	52.5	52.5	52.5	52.5	441.0
2016-01-12 05:00:00	MSFT	Stock	52.59	52.59	52.55	52.55	1400.0
2016-01-12 05:30:00	MSFT	Stock	52.54	52.57	52.54	52.57	760.0
2016-01-12 06:30:00	MSFT	Stock	52.56	52.56	52.45	52.55	10693.0
2016-01-12 07:30:00	MSFT	Stock	52.6	52.8	52.6	52.8	2960.0
2016-01-12 08:00:00	MSFT	Stock	52.7	52.95	52.7	52.85	52414.0
2016-01-12 08:30:00	MSFT	Stock	52.85	52.89	52.75	52.8	106053.0
2016-01-12 09:00:00	MSFT	Stock	52.78	52.9	52.71	52.81	99860.0
2016-01-12 09:30:00	MSFT	Stock	52.77	53.1	52.61	52.82	4173293.0
2016-01-12 10:00:00	MSFT	Stock	52.82	52.885	52.585	52.695	2573028.0
2016-01-12 10:30:00	MSFT	Stock	52.69	52.9	52.5	52.7	2160664.0
2016-01-12 11:00:00	MSFT	Stock	52.7	52.71	52.33	52.47	2021165.0
2016-01-12 11:30:00	MSFT	Stock	52.47	52.47	52.11	52.342	2117172.0
2016-01-12 12:00:00	MSFT	Stock	52.35	52.56	52.192	52.34	1406274.0
2016-01-12 12:30:00	MSFT	Stock	52.33	52.4	52.06	52.27	1555708.0
2016-01-12 13:00:00	MSFT	Stock	52.27	52.56	52.27	52.32	1407683.0
2016-01-12 13:30:00	MSFT	Stock	52.31	52.55	52.29	52.37	1318579.0
2016-01-12 14:00:00	MSFT	Stock	52.379	52.415	52.06	52.34	2142807.0

> showing 50 of 83,784 rows — these rows as CSV

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