PREVIEW / stock_30min / 2017-10-30

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-10-30.parquet
  size:    1.6 MB
  rows:    81,759
  symbols: 2,927

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
2017-10-30 04:00:00	AAPL	Stock	40.875	40.875	40.8	40.8575	21352.0
2017-10-30 04:30:00	AAPL	Stock	40.8575	40.8625	40.85	40.855	9984.0
2017-10-30 05:00:00	AAPL	Stock	40.875	40.875	40.85	40.85	20256.0
2017-10-30 05:30:00	AAPL	Stock	40.825	40.825	40.8175	40.82	4468.0
2017-10-30 06:00:00	AAPL	Stock	40.825	40.845	40.785	40.805	27864.0
2017-10-30 06:30:00	AAPL	Stock	40.8	40.8975	40.8	40.875	32648.0
2017-10-30 07:00:00	AAPL	Stock	40.875	40.9475	40.8625	40.8875	179068.0
2017-10-30 07:30:00	AAPL	Stock	40.9	40.9425	40.89	40.8925	52704.0
2017-10-30 08:00:00	AAPL	Stock	40.9	40.95	40.845	40.9475	261656.0
2017-10-30 08:30:00	AAPL	Stock	40.9475	41.0875	40.9375	41.0825	726068.0
2017-10-30 09:00:00	AAPL	Stock	41.0825	41.0825	40.96	40.965	635056.0
2017-10-30 09:30:00	AAPL	Stock	40.9625	41.5875	40.93	41.5575	34820512.0
2017-10-30 10:00:00	AAPL	Stock	41.5575	41.875	41.523	41.8715	20821856.0
2017-10-30 10:30:00	AAPL	Stock	41.8713	42.0175	41.7125	41.7795	21943908.0
2017-10-30 11:00:00	AAPL	Stock	41.7775	41.7825	41.535	41.58	12201120.0
2017-10-30 11:30:00	AAPL	Stock	41.575	41.7675	41.55	41.7575	8726996.0
2017-10-30 12:00:00	AAPL	Stock	41.75	41.755	41.4575	41.5275	7418448.0
2017-10-30 12:30:00	AAPL	Stock	41.5275	41.675	41.52	41.6225	5277024.0
2017-10-30 13:00:00	AAPL	Stock	41.62	41.7235	41.6175	41.7012	4712576.0
2017-10-30 13:30:00	AAPL	Stock	41.7012	41.7225	41.5325	41.5575	4825588.0
2017-10-30 14:00:00	AAPL	Stock	41.5575	41.6875	41.5575	41.6475	4501156.0
2017-10-30 14:30:00	AAPL	Stock	41.647	41.665	41.595	41.6325	4282504.0
2017-10-30 15:00:00	AAPL	Stock	41.6338	41.6745	41.565	41.6425	5965228.0
2017-10-30 15:30:00	AAPL	Stock	41.64	41.7425	41.6178	41.68	12986884.0
2017-10-30 16:00:00	AAPL	Stock	41.68	41.7125	41.6422	41.695	5160112.0
2017-10-30 16:30:00	AAPL	Stock	41.695	41.7125	41.68	41.6975	388196.0
2017-10-30 17:00:00	AAPL	Stock	41.6875	41.71	41.6875	41.71	96732.0
2017-10-30 17:30:00	AAPL	Stock	41.7025	41.7025	41.6875	41.7	31500.0
2017-10-30 18:00:00	AAPL	Stock	41.7	41.7125	41.685	41.7	18968.0
2017-10-30 18:30:00	AAPL	Stock	41.7125	41.7275	41.705	41.725	31452.0
2017-10-30 19:00:00	AAPL	Stock	41.705	41.7275	41.705	41.705	16596.0
2017-10-30 19:30:00	AAPL	Stock	41.7175	41.745	41.7175	41.7425	36992.0
2017-10-30 04:00:00	MSFT	Stock	83.98	83.99	83.98	83.99	1100.0
2017-10-30 04:30:00	MSFT	Stock	84.07	84.07	83.85	83.85	200.0
2017-10-30 05:00:00	MSFT	Stock	83.89	83.89	83.74	83.74	300.0
2017-10-30 05:30:00	MSFT	Stock	83.87	83.87	83.81	83.87	826.0
2017-10-30 06:00:00	MSFT	Stock	83.71	83.8	83.67	83.67	3271.0
2017-10-30 06:30:00	MSFT	Stock	83.7	83.76	83.7	83.75	3413.0
2017-10-30 07:00:00	MSFT	Stock	83.75	83.75	83.67	83.67	5672.0
2017-10-30 07:30:00	MSFT	Stock	83.7	83.78	83.7	83.75	3259.0
2017-10-30 08:00:00	MSFT	Stock	83.75	83.92	83.63	83.92	19154.0
2017-10-30 08:30:00	MSFT	Stock	83.92	84.13	83.84	83.87	25546.0
2017-10-30 09:00:00	MSFT	Stock	83.97	84.09	83.7	83.72	35709.0
2017-10-30 09:30:00	MSFT	Stock	83.71	84.24	83.105	84.189	4098152.0
2017-10-30 10:00:00	MSFT	Stock	84.18	84.325	83.94	84.255	3075418.0
2017-10-30 10:30:00	MSFT	Stock	84.25	84.27	83.78	83.85	1772301.0
2017-10-30 11:00:00	MSFT	Stock	83.85	83.91	83.63	83.84	1280145.0
2017-10-30 11:30:00	MSFT	Stock	83.84	84.19	83.83	84.02	1966375.0
2017-10-30 12:00:00	MSFT	Stock	84.02	84.05	83.6	83.69	1855324.0
2017-10-30 12:30:00	MSFT	Stock	83.695	83.98	83.68	83.79	940459.0

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

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