PREVIEW / stock_30min / 2016-02-16

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-02-16.parquet
  size:    1.6 MB
  rows:    82,943
  symbols: 3,359

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-02-16 04:00:00	AAPL	Stock	23.46	24.0525	23.46	23.95	29428.0
2016-02-16 04:30:00	AAPL	Stock	23.915	23.915	23.885	23.885	2400.0
2016-02-16 05:00:00	AAPL	Stock	23.8775	23.8775	23.8375	23.8375	5800.0
2016-02-16 05:30:00	AAPL	Stock	23.8375	23.8375	23.8375	23.8375	400.0
2016-02-16 06:00:00	AAPL	Stock	23.8375	23.8375	23.825	23.825	7688.0
2016-02-16 06:30:00	AAPL	Stock	23.7875	23.85	23.7875	23.85	18136.0
2016-02-16 07:00:00	AAPL	Stock	23.8575	23.8625	23.8325	23.8375	33008.0
2016-02-16 07:30:00	AAPL	Stock	23.85	23.9025	23.85	23.87	89352.0
2016-02-16 08:00:00	AAPL	Stock	23.8625	23.9025	23.45	23.75	289436.0
2016-02-16 08:30:00	AAPL	Stock	23.75	23.795	23.725	23.7875	194316.0
2016-02-16 09:00:00	AAPL	Stock	23.785	23.8125	23.7275	23.7475	245296.0
2016-02-16 09:30:00	AAPL	Stock	23.74	23.8675	23.6525	23.795	23697112.0
2016-02-16 10:00:00	AAPL	Stock	23.7925	23.8188	23.71	23.7618	12945268.0
2016-02-16 10:30:00	AAPL	Stock	23.765	23.8625	23.7275	23.8175	11214796.0
2016-02-16 11:00:00	AAPL	Stock	23.8175	23.9075	23.745	23.8762	11045396.0
2016-02-16 11:30:00	AAPL	Stock	23.8775	23.9375	23.835	23.9362	8196888.0
2016-02-16 12:00:00	AAPL	Stock	23.9375	24.0355	23.9297	23.995	12742064.0
2016-02-16 12:30:00	AAPL	Stock	23.9962	24.0225	23.9325	24.01	8430688.0
2016-02-16 13:00:00	AAPL	Stock	24.0095	24.0875	23.9862	24.0462	8990328.0
2016-02-16 13:30:00	AAPL	Stock	24.044	24.1	24.0178	24.0725	8998532.0
2016-02-16 14:00:00	AAPL	Stock	24.0712	24.16	24.0675	24.1575	9139104.0
2016-02-16 14:30:00	AAPL	Stock	24.1572	24.2125	24.1175	24.1225	13688944.0
2016-02-16 15:00:00	AAPL	Stock	24.1225	24.195	24.0775	24.17	14287644.0
2016-02-16 15:30:00	AAPL	Stock	24.172	24.1775	24.0275	24.155	21932112.0
2016-02-16 16:00:00	AAPL	Stock	24.155	24.16	24.12	24.135	11087876.0
2016-02-16 16:30:00	AAPL	Stock	24.14	24.1425	23.9575	24.035	451680.0
2016-02-16 17:00:00	AAPL	Stock	24.0525	24.16	23.975	24.0075	539108.0
2016-02-16 17:30:00	AAPL	Stock	24.0075	24.0425	24.0	24.0125	104984.0
2016-02-16 18:00:00	AAPL	Stock	24.02	24.02	23.975	24.0	46972.0
2016-02-16 18:30:00	AAPL	Stock	24.0	24.0125	23.9875	24.0125	32680.0
2016-02-16 19:00:00	AAPL	Stock	24.015	24.035	24.015	24.0325	4652.0
2016-02-16 19:30:00	AAPL	Stock	24.0375	24.1	24.0375	24.0875	81688.0
2016-02-16 04:00:00	MSFT	Stock	50.75	50.9	50.75	50.9	500.0
2016-02-16 04:30:00	MSFT	Stock	50.9	50.92	50.9	50.92	1000.0
2016-02-16 05:00:00	MSFT	Stock	51.08	51.08	51.08	51.08	100.0
2016-02-16 05:30:00	MSFT	Stock	51.0	51.0	51.0	51.0	100.0
2016-02-16 06:00:00	MSFT	Stock	50.7	50.7	50.56	50.56	1305.0
2016-02-16 06:30:00	MSFT	Stock	50.9	50.94	50.9	50.94	1100.0
2016-02-16 07:00:00	MSFT	Stock	51.0	51.0	51.0	51.0	100.0
2016-02-16 07:30:00	MSFT	Stock	50.98	50.98	50.82	50.82	3750.0
2016-02-16 08:00:00	MSFT	Stock	51.02	51.02	50.75	50.85	19166.0
2016-02-16 08:30:00	MSFT	Stock	50.8	50.8	50.7	50.74	2441.0
2016-02-16 09:00:00	MSFT	Stock	50.76	50.9	50.76	50.89	6690.0
2016-02-16 09:30:00	MSFT	Stock	50.9	51.0	50.57	50.725	3133211.0
2016-02-16 10:00:00	MSFT	Stock	50.725	50.8	50.53	50.63	1590088.0
2016-02-16 10:30:00	MSFT	Stock	50.64	50.8	50.38	50.41	1357528.0
2016-02-16 11:00:00	MSFT	Stock	50.41	50.45	50.13	50.295	2451195.0
2016-02-16 11:30:00	MSFT	Stock	50.303	50.717	50.25	50.69	1397029.0
2016-02-16 12:00:00	MSFT	Stock	50.7	50.805	50.63	50.76	1134409.0
2016-02-16 12:30:00	MSFT	Stock	50.753	50.9	50.65	50.835	1002559.0

> showing 50 of 82,943 rows — these rows as CSV

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