PREVIEW / stock_30min / 2016-11-15

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-11-15.parquet
  size:    1.6 MB
  rows:    84,389
  symbols: 3,197

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-11-15 04:30:00	AAPL	Stock	26.4675	26.4675	26.4675	26.4675	1680.0
2016-11-15 06:00:00	AAPL	Stock	26.475	26.475	26.4375	26.45	3712.0
2016-11-15 06:30:00	AAPL	Stock	26.4725	26.4825	26.4575	26.4625	33060.0
2016-11-15 07:00:00	AAPL	Stock	26.47	26.5	26.4	26.5	18756.0
2016-11-15 07:30:00	AAPL	Stock	26.4875	26.495	26.4025	26.4375	30624.0
2016-11-15 08:00:00	AAPL	Stock	26.45	26.6	26.4025	26.6	188164.0
2016-11-15 08:30:00	AAPL	Stock	26.58	26.675	26.5375	26.665	240080.0
2016-11-15 09:00:00	AAPL	Stock	26.6675	26.6725	26.6	26.635	409532.0
2016-11-15 09:30:00	AAPL	Stock	26.6425	26.825	26.5398	26.7425	21487156.0
2016-11-15 10:00:00	AAPL	Stock	26.7412	26.92	26.7325	26.7825	15738664.0
2016-11-15 10:30:00	AAPL	Stock	26.7825	26.79	26.6825	26.78	10480584.0
2016-11-15 11:00:00	AAPL	Stock	26.78	26.83	26.7125	26.76	6831796.0
2016-11-15 11:30:00	AAPL	Stock	26.76	26.78	26.68	26.68	6209440.0
2016-11-15 12:00:00	AAPL	Stock	26.68	26.7012	26.6475	26.6562	4428304.0
2016-11-15 12:30:00	AAPL	Stock	26.6562	26.685	26.5875	26.6112	4856056.0
2016-11-15 13:00:00	AAPL	Stock	26.6125	26.695	26.59	26.6538	3662768.0
2016-11-15 13:30:00	AAPL	Stock	26.6525	26.745	26.65	26.7362	4115612.0
2016-11-15 14:00:00	AAPL	Stock	26.7375	26.8075	26.7275	26.7625	4441464.0
2016-11-15 14:30:00	AAPL	Stock	26.765	26.8638	26.7575	26.8615	5879368.0
2016-11-15 15:00:00	AAPL	Stock	26.8625	26.9025	26.82	26.835	8020500.0
2016-11-15 15:30:00	AAPL	Stock	26.835	26.8725	26.7775	26.7775	13342572.0
2016-11-15 16:00:00	AAPL	Stock	26.7775	26.79	26.6782	26.7725	7892568.0
2016-11-15 16:30:00	AAPL	Stock	26.7775	26.78	26.7625	26.7775	11580.0
2016-11-15 17:00:00	AAPL	Stock	26.7775	26.7775	26.7625	26.7725	37784.0
2016-11-15 17:30:00	AAPL	Stock	26.7725	26.7725	26.7725	26.7725	400.0
2016-11-15 18:00:00	AAPL	Stock	26.775	26.775	26.7575	26.775	6704.0
2016-11-15 18:30:00	AAPL	Stock	26.7725	26.7775	26.76	26.7775	56572.0
2016-11-15 19:00:00	AAPL	Stock	26.7625	26.785	26.7625	26.785	21400.0
2016-11-15 19:30:00	AAPL	Stock	26.7775	26.7875	26.775	26.7775	24472.0
2016-11-15 05:30:00	MSFT	Stock	57.75	57.75	57.75	57.75	500.0
2016-11-15 06:30:00	MSFT	Stock	57.77	57.77	57.77	57.77	400.0
2016-11-15 07:00:00	MSFT	Stock	57.75	57.75	57.75	57.75	170.0
2016-11-15 07:30:00	MSFT	Stock	57.8	57.91	57.75	57.82	19997.0
2016-11-15 08:00:00	MSFT	Stock	57.85	58.12	57.83	58.05	12890.0
2016-11-15 08:30:00	MSFT	Stock	58.1	58.35	58.09	58.33	63258.0
2016-11-15 09:00:00	MSFT	Stock	58.34	58.39	58.28	58.31	16256.0
2016-11-15 09:30:00	MSFT	Stock	58.32	59.1	58.315	59.08	4585939.0
2016-11-15 10:00:00	MSFT	Stock	59.085	59.49	59.02	59.16	3560700.0
2016-11-15 10:30:00	MSFT	Stock	59.165	59.26	58.95	59.1	2466925.0
2016-11-15 11:00:00	MSFT	Stock	59.105	59.26	58.99	59.13	1922817.0
2016-11-15 11:30:00	MSFT	Stock	59.14	59.17	58.96	59.03	1158894.0
2016-11-15 12:00:00	MSFT	Stock	59.03	59.07	58.87	58.91	1057525.0
2016-11-15 12:30:00	MSFT	Stock	58.905	58.93	58.61	58.665	1276361.0
2016-11-15 13:00:00	MSFT	Stock	58.67	58.83	58.66	58.77	1424481.0
2016-11-15 13:30:00	MSFT	Stock	58.77	58.85	58.715	58.847	1789110.0
2016-11-15 14:00:00	MSFT	Stock	58.84	58.98	58.793	58.92	1334487.0
2016-11-15 14:30:00	MSFT	Stock	58.93	59.12	58.91	59.08	1395248.0
2016-11-15 15:00:00	MSFT	Stock	59.08	59.16	58.93	59.02	1853615.0
2016-11-15 15:30:00	MSFT	Stock	59.028	59.14	58.87	58.87	5035942.0
2016-11-15 16:00:00	MSFT	Stock	58.9	58.97	58.87	58.93	3729016.0

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

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