PREVIEW / stock_30min / 2016-09-02

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-09-02.parquet
  size:    1.5 MB
  rows:    79,492
  symbols: 3,221

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-09-02 04:00:00	AAPL	Stock	26.7275	26.7275	26.7275	26.7275	400.0
2016-09-02 06:00:00	AAPL	Stock	26.745	26.77	26.7125	26.7125	34852.0
2016-09-02 07:00:00	AAPL	Stock	26.725	26.75	26.7125	26.75	22288.0
2016-09-02 07:30:00	AAPL	Stock	26.745	26.7625	26.745	26.75	97972.0
2016-09-02 08:00:00	AAPL	Stock	26.7625	26.8	26.7125	26.75	280560.0
2016-09-02 08:30:00	AAPL	Stock	26.7175	26.91	26.7175	26.895	829756.0
2016-09-02 09:00:00	AAPL	Stock	26.8975	26.945	26.865	26.935	278532.0
2016-09-02 09:30:00	AAPL	Stock	26.9325	27.0	26.825	26.91	18677896.0
2016-09-02 10:00:00	AAPL	Stock	26.91	26.955	26.8075	26.8675	7949060.0
2016-09-02 10:30:00	AAPL	Stock	26.87	26.9075	26.8362	26.8475	5818868.0
2016-09-02 11:00:00	AAPL	Stock	26.8448	26.87	26.7925	26.8	4115492.0
2016-09-02 11:30:00	AAPL	Stock	26.8025	26.8325	26.75	26.815	4887800.0
2016-09-02 12:00:00	AAPL	Stock	26.8175	26.8225	26.705	26.7425	5288368.0
2016-09-02 12:30:00	AAPL	Stock	26.7425	26.775	26.7425	26.7668	3462768.0
2016-09-02 13:00:00	AAPL	Stock	26.765	26.7725	26.725	26.759	3194732.0
2016-09-02 13:30:00	AAPL	Stock	26.7575	26.8378	26.7528	26.825	5229776.0
2016-09-02 14:00:00	AAPL	Stock	26.825	26.8525	26.8075	26.8368	4232656.0
2016-09-02 14:30:00	AAPL	Stock	26.835	26.89	26.8225	26.8875	4595324.0
2016-09-02 15:00:00	AAPL	Stock	26.8875	26.93	26.885	26.925	7609368.0
2016-09-02 15:30:00	AAPL	Stock	26.925	26.9425	26.9	26.9325	11510284.0
2016-09-02 16:00:00	AAPL	Stock	26.9338	26.9425	26.9075	26.9125	7045076.0
2016-09-02 16:30:00	AAPL	Stock	26.9125	26.9325	26.9	26.9125	96332.0
2016-09-02 17:00:00	AAPL	Stock	26.9125	26.9275	26.9125	26.9275	38300.0
2016-09-02 17:30:00	AAPL	Stock	26.9275	26.9325	26.915	26.9275	34128.0
2016-09-02 18:00:00	AAPL	Stock	26.925	26.9325	26.925	26.9325	16800.0
2016-09-02 18:30:00	AAPL	Stock	26.9325	26.935	26.9325	26.9325	18832.0
2016-09-02 19:00:00	AAPL	Stock	26.935	26.935	26.9275	26.935	5536.0
2016-09-02 19:30:00	AAPL	Stock	26.9275	26.9275	26.9275	26.9275	8736.0
2016-09-02 08:00:00	MSFT	Stock	57.6	57.6	57.6	57.6	100.0
2016-09-02 08:30:00	MSFT	Stock	57.57	57.65	57.57	57.62	11996.0
2016-09-02 09:00:00	MSFT	Stock	57.67	57.73	57.6	57.73	27619.0
2016-09-02 09:30:00	MSFT	Stock	57.67	58.19	57.65	58.17	3541307.0
2016-09-02 10:00:00	MSFT	Stock	58.18	58.18	58.0	58.06	1518863.0
2016-09-02 10:30:00	MSFT	Stock	58.06	58.08	57.96	57.98	932435.0
2016-09-02 11:00:00	MSFT	Stock	57.99	58.01	57.82	57.82	879955.0
2016-09-02 11:30:00	MSFT	Stock	57.825	57.86	57.79	57.79	714059.0
2016-09-02 12:00:00	MSFT	Stock	57.799	57.83	57.59	57.6	979349.0
2016-09-02 12:30:00	MSFT	Stock	57.61	57.66	57.59	57.615	763958.0
2016-09-02 13:00:00	MSFT	Stock	57.61	57.62	57.52	57.54	820759.0
2016-09-02 13:30:00	MSFT	Stock	57.545	57.55	57.42	57.475	833235.0
2016-09-02 14:00:00	MSFT	Stock	57.475	57.705	57.47	57.665	916564.0
2016-09-02 14:30:00	MSFT	Stock	57.66	57.68	57.62	57.66	678516.0
2016-09-02 15:00:00	MSFT	Stock	57.655	57.75	57.63	57.72	971115.0
2016-09-02 15:30:00	MSFT	Stock	57.715	57.78	57.655	57.67	2100906.0
2016-09-02 16:00:00	MSFT	Stock	57.67	57.67	57.67	57.67	2178324.0
2016-09-02 17:30:00	MSFT	Stock	57.7	57.7	57.7	57.7	2000.0
2016-09-02 18:00:00	MSFT	Stock	57.6	57.6	57.6	57.6	100.0
2016-09-02 19:00:00	MSFT	Stock	57.6	57.6	57.6	57.6	400.0
2016-09-02 19:30:00	MSFT	Stock	57.61	57.61	57.61	57.61	750.0
2016-09-02 05:00:00	NVDA	Stock	1.5775	1.5775	1.5775	1.5775	4000.0

> showing 50 of 79,492 rows — these rows as CSV

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