PREVIEW / stock_30min / 2016-03-23

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-03-23.parquet
  size:    1.6 MB
  rows:    81,785
  symbols: 3,340

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-03-23 04:00:00	AAPL	Stock	26.675	26.7425	26.675	26.7425	12240.0
2016-03-23 04:30:00	AAPL	Stock	26.7425	26.7425	26.7425	26.7425	960.0
2016-03-23 05:00:00	AAPL	Stock	26.7325	26.735	26.7325	26.735	1272.0
2016-03-23 05:30:00	AAPL	Stock	26.715	26.715	26.7	26.715	9772.0
2016-03-23 06:00:00	AAPL	Stock	26.695	26.695	26.695	26.695	400.0
2016-03-23 07:00:00	AAPL	Stock	26.6875	26.74	26.68	26.7375	18952.0
2016-03-23 08:00:00	AAPL	Stock	26.7125	26.74	26.625	26.6975	77540.0
2016-03-23 08:30:00	AAPL	Stock	26.675	26.71	26.675	26.695	85924.0
2016-03-23 09:00:00	AAPL	Stock	26.685	26.705	26.615	26.6175	379852.0
2016-03-23 09:30:00	AAPL	Stock	26.6175	26.7	26.555	26.57	13490380.0
2016-03-23 10:00:00	AAPL	Stock	26.57	26.635	26.5425	26.6075	8365692.0
2016-03-23 10:30:00	AAPL	Stock	26.605	26.6425	26.565	26.6052	7440268.0
2016-03-23 11:00:00	AAPL	Stock	26.6062	26.6975	26.575	26.6862	8044844.0
2016-03-23 11:30:00	AAPL	Stock	26.6862	26.7275	26.6595	26.7	6776176.0
2016-03-23 12:00:00	AAPL	Stock	26.7025	26.755	26.6775	26.75	5354800.0
2016-03-23 12:30:00	AAPL	Stock	26.75	26.7675	26.685	26.7	4172560.0
2016-03-23 13:00:00	AAPL	Stock	26.6975	26.74	26.685	26.74	3252168.0
2016-03-23 13:30:00	AAPL	Stock	26.7395	26.7525	26.7	26.7175	3886436.0
2016-03-23 14:00:00	AAPL	Stock	26.7198	26.725	26.59	26.5975	5637376.0
2016-03-23 14:30:00	AAPL	Stock	26.598	26.645	26.5275	26.5612	6544188.0
2016-03-23 15:00:00	AAPL	Stock	26.5605	26.5825	26.475	26.5255	6494088.0
2016-03-23 15:30:00	AAPL	Stock	26.525	26.555	26.485	26.535	8952756.0
2016-03-23 16:00:00	AAPL	Stock	26.5325	26.5575	26.53	26.5325	5705344.0
2016-03-23 16:30:00	AAPL	Stock	26.54	26.54	26.535	26.5375	31700.0
2016-03-23 17:00:00	AAPL	Stock	26.5375	26.545	26.5325	26.5325	19344.0
2016-03-23 17:30:00	AAPL	Stock	26.53	26.5375	26.53	26.53	4620.0
2016-03-23 18:00:00	AAPL	Stock	26.5175	26.5175	26.5125	26.515	9176.0
2016-03-23 18:30:00	AAPL	Stock	26.535	26.535	26.5125	26.515	5020.0
2016-03-23 19:00:00	AAPL	Stock	26.515	26.535	26.515	26.515	16436.0
2016-03-23 19:30:00	AAPL	Stock	26.5175	26.53	26.5175	26.53	22600.0
2016-03-23 07:00:00	MSFT	Stock	54.15	54.17	54.15	54.17	5154.0
2016-03-23 07:30:00	MSFT	Stock	54.35	54.36	54.27	54.27	1000.0
2016-03-23 08:00:00	MSFT	Stock	54.13	54.27	54.13	54.2	3881.0
2016-03-23 08:30:00	MSFT	Stock	54.2	54.2	54.2	54.2	3100.0
2016-03-23 09:00:00	MSFT	Stock	54.14	54.19	53.98	54.19	12841.0
2016-03-23 09:30:00	MSFT	Stock	54.16	54.22	53.83	54.08	2482595.0
2016-03-23 10:00:00	MSFT	Stock	54.08	54.24	53.97	54.08	1654222.0
2016-03-23 10:30:00	MSFT	Stock	54.08	54.165	53.83	53.89	1488004.0
2016-03-23 11:00:00	MSFT	Stock	53.89	54.05	53.82	53.94	1180878.0
2016-03-23 11:30:00	MSFT	Stock	53.95	53.97	53.74	53.805	1150701.0
2016-03-23 12:00:00	MSFT	Stock	53.808	54.0	53.78	54.0	756030.0
2016-03-23 12:30:00	MSFT	Stock	54.01	54.085	53.91	54.0	616767.0
2016-03-23 13:00:00	MSFT	Stock	54.0	54.09	53.94	53.95	521456.0
2016-03-23 13:30:00	MSFT	Stock	53.96	54.0	53.89	53.95	593266.0
2016-03-23 14:00:00	MSFT	Stock	53.955	54.035	53.9	53.925	695451.0
2016-03-23 14:30:00	MSFT	Stock	53.93	54.01	53.74	53.8	1006266.0
2016-03-23 15:00:00	MSFT	Stock	53.81	53.92	53.75	53.84	1217157.0
2016-03-23 15:30:00	MSFT	Stock	53.84	54.03	53.835	53.98	3105131.0
2016-03-23 16:00:00	MSFT	Stock	53.97	54.02	53.95	54.02	1987895.0
2016-03-23 16:30:00	MSFT	Stock	53.94	53.95	53.92	53.92	2600.0

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

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