PREVIEW / stock_30min / 2016-04-20

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-04-20.parquet
  size:    1.6 MB
  rows:    81,525
  symbols: 3,314

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-04-20 04:00:00	AAPL	Stock	26.71	26.71	26.625	26.625	7040.0
2016-04-20 05:00:00	AAPL	Stock	26.6625	26.6625	26.6625	26.6625	400.0
2016-04-20 07:00:00	AAPL	Stock	26.69	26.7025	26.65	26.7025	29060.0
2016-04-20 07:30:00	AAPL	Stock	26.71	26.72	26.71	26.72	27572.0
2016-04-20 08:00:00	AAPL	Stock	26.7175	26.725	26.675	26.7225	181340.0
2016-04-20 08:30:00	AAPL	Stock	26.7225	26.7225	26.6775	26.695	101040.0
2016-04-20 09:00:00	AAPL	Stock	26.69	26.6925	26.66	26.6675	111256.0
2016-04-20 09:30:00	AAPL	Stock	26.66	26.81	26.515	26.7962	19033940.0
2016-04-20 10:00:00	AAPL	Stock	26.7975	26.91	26.765	26.7725	13730356.0
2016-04-20 10:30:00	AAPL	Stock	26.7725	26.8875	26.7725	26.8675	6722532.0
2016-04-20 11:00:00	AAPL	Stock	26.8675	26.9465	26.84	26.9338	6957944.0
2016-04-20 11:30:00	AAPL	Stock	26.935	26.9925	26.9152	26.9225	6551576.0
2016-04-20 12:00:00	AAPL	Stock	26.9225	26.9625	26.9178	26.9525	3794908.0
2016-04-20 12:30:00	AAPL	Stock	26.9512	27.0225	26.9275	26.94	6623992.0
2016-04-20 13:00:00	AAPL	Stock	26.9398	26.95	26.8925	26.9338	4061828.0
2016-04-20 13:30:00	AAPL	Stock	26.9325	26.95	26.9125	26.9225	3385580.0
2016-04-20 14:00:00	AAPL	Stock	26.925	26.9375	26.9	26.9062	4652176.0
2016-04-20 14:30:00	AAPL	Stock	26.9112	26.94	26.9	26.91	3416372.0
2016-04-20 15:00:00	AAPL	Stock	26.9125	26.935	26.885	26.896	6889968.0
2016-04-20 15:30:00	AAPL	Stock	26.895	26.9025	26.7775	26.7825	11200888.0
2016-04-20 16:00:00	AAPL	Stock	26.7825	26.9658	26.75	26.7725	7480908.0
2016-04-20 16:30:00	AAPL	Stock	26.7575	26.7825	26.7575	26.7825	135792.0
2016-04-20 17:00:00	AAPL	Stock	26.77	26.825	26.75	26.7625	315644.0
2016-04-20 17:30:00	AAPL	Stock	26.76	26.7875	26.755	26.775	36800.0
2016-04-20 18:00:00	AAPL	Stock	26.765	26.775	26.765	26.775	4200.0
2016-04-20 18:30:00	AAPL	Stock	26.76	26.76	26.7575	26.76	7400.0
2016-04-20 19:00:00	AAPL	Stock	26.7625	26.775	26.7625	26.775	2860.0
2016-04-20 19:30:00	AAPL	Stock	26.775	26.7875	26.7625	26.7625	11864.0
2016-04-20 04:00:00	MSFT	Stock	56.25	56.25	56.02	56.02	22000.0
2016-04-20 04:30:00	MSFT	Stock	56.1	56.45	56.1	56.15	20600.0
2016-04-20 05:30:00	MSFT	Stock	56.05	56.05	56.03	56.03	2041.0
2016-04-20 06:00:00	MSFT	Stock	56.04	56.04	56.0	56.0	6859.0
2016-04-20 06:30:00	MSFT	Stock	55.91	56.09	55.91	56.09	6195.0
2016-04-20 07:00:00	MSFT	Stock	56.1	56.1	56.09	56.09	400.0
2016-04-20 07:30:00	MSFT	Stock	56.05	56.05	56.05	56.05	920.0
2016-04-20 08:00:00	MSFT	Stock	56.1	56.25	56.03	56.24	28516.0
2016-04-20 08:30:00	MSFT	Stock	56.21	56.25	56.17	56.19	7200.0
2016-04-20 09:00:00	MSFT	Stock	56.19	56.27	56.08	56.26	36514.0
2016-04-20 09:30:00	MSFT	Stock	56.29	56.5	56.05	56.255	3182356.0
2016-04-20 10:00:00	MSFT	Stock	56.255	56.26	56.0	56.025	2453856.0
2016-04-20 10:30:00	MSFT	Stock	56.03	56.065	55.935	56.03	2002424.0
2016-04-20 11:00:00	MSFT	Stock	56.035	56.17	55.96	56.149	2248369.0
2016-04-20 11:30:00	MSFT	Stock	56.145	56.17	56.054	56.1	1294578.0
2016-04-20 12:00:00	MSFT	Stock	56.1	56.12	56.0	56.095	972866.0
2016-04-20 12:30:00	MSFT	Stock	56.095	56.16	56.05	56.09	979491.0
2016-04-20 13:00:00	MSFT	Stock	56.086	56.12	56.0	56.06	1829226.0
2016-04-20 13:30:00	MSFT	Stock	56.065	56.12	55.98	56.0	1449003.0
2016-04-20 14:00:00	MSFT	Stock	56.0	56.11	55.97	56.015	2021997.0
2016-04-20 14:30:00	MSFT	Stock	56.02	56.05	55.87	55.93	2460805.0
2016-04-20 15:00:00	MSFT	Stock	55.93	56.03	55.78	55.78	2606909.0

> showing 50 of 81,525 rows — these rows as CSV

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