PREVIEW / stock_30min / 2015-01-02

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-01-02.parquet
  size:    1.6 MB
  rows:    81,874
  symbols: 3,489

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
2015-01-02 04:00:00	AAPL	Stock	27.75	27.75	27.7425	27.7425	1600.0
2015-01-02 04:30:00	AAPL	Stock	27.7575	27.775	27.7375	27.775	10024.0
2015-01-02 05:00:00	AAPL	Stock	27.7975	27.8	27.725	27.7525	11920.0
2015-01-02 05:30:00	AAPL	Stock	27.8125	27.8125	27.8125	27.8125	800.0
2015-01-02 06:00:00	AAPL	Stock	27.825	27.825	27.7975	27.8	41092.0
2015-01-02 06:30:00	AAPL	Stock	27.8	27.8	27.745	27.745	6200.0
2015-01-02 07:00:00	AAPL	Stock	27.7875	27.8	27.7775	27.7925	88004.0
2015-01-02 07:30:00	AAPL	Stock	27.8	27.8	27.7725	27.7775	31812.0
2015-01-02 08:00:00	AAPL	Stock	27.7725	27.8	27.7375	27.7825	223440.0
2015-01-02 08:30:00	AAPL	Stock	27.785	27.8412	27.595	27.835	318716.0
2015-01-02 09:00:00	AAPL	Stock	27.8375	27.875	27.835	27.8525	321876.0
2015-01-02 09:30:00	AAPL	Stock	27.8475	27.86	27.1625	27.375	39547536.0
2015-01-02 10:00:00	AAPL	Stock	27.3725	27.4275	27.1925	27.2762	22888568.0
2015-01-02 10:30:00	AAPL	Stock	27.2825	27.2875	26.8375	27.0712	27627420.0
2015-01-02 11:00:00	AAPL	Stock	27.0725	27.1102	26.9625	27.0922	14536912.0
2015-01-02 11:30:00	AAPL	Stock	27.09	27.1975	27.0525	27.194	10630192.0
2015-01-02 12:00:00	AAPL	Stock	27.1925	27.3075	27.1888	27.295	10900396.0
2015-01-02 12:30:00	AAPL	Stock	27.2975	27.3975	27.295	27.3388	9299300.0
2015-01-02 13:00:00	AAPL	Stock	27.3388	27.3675	27.23	27.245	7254848.0
2015-01-02 13:30:00	AAPL	Stock	27.2425	27.29	27.1875	27.2475	7399576.0
2015-01-02 14:00:00	AAPL	Stock	27.2488	27.34	27.225	27.3	6162124.0
2015-01-02 14:30:00	AAPL	Stock	27.2975	27.345	27.25	27.27	6125396.0
2015-01-02 15:00:00	AAPL	Stock	27.27	27.29	27.1725	27.2425	7984620.0
2015-01-02 15:30:00	AAPL	Stock	27.2425	27.381	27.23	27.325	17825100.0
2015-01-02 16:00:00	AAPL	Stock	27.3325	27.7998	27.1555	27.265	10987672.0
2015-01-02 16:30:00	AAPL	Stock	27.275	27.3325	27.265	27.275	124364.0
2015-01-02 17:00:00	AAPL	Stock	27.265	27.2925	27.2625	27.2925	18744.0
2015-01-02 17:30:00	AAPL	Stock	27.2925	27.3325	27.26	27.275	122172.0
2015-01-02 18:00:00	AAPL	Stock	27.275	27.28	27.2525	27.2625	28060.0
2015-01-02 18:30:00	AAPL	Stock	27.2875	27.2875	27.255	27.255	30748.0
2015-01-02 19:00:00	AAPL	Stock	27.2625	27.2875	27.2525	27.2675	15580.0
2015-01-02 19:30:00	AAPL	Stock	27.2875	27.295	27.2675	27.2825	13844.0
2015-01-02 04:00:00	MSFT	Stock	46.5	46.5	46.5	46.5	100.0
2015-01-02 07:00:00	MSFT	Stock	46.72	46.72	46.7	46.7	300.0
2015-01-02 08:00:00	MSFT	Stock	46.45	46.7	46.45	46.67	24700.0
2015-01-02 08:30:00	MSFT	Stock	46.67	46.69	46.45	46.62	18821.0
2015-01-02 09:00:00	MSFT	Stock	46.65	46.76	46.63	46.69	13169.0
2015-01-02 09:30:00	MSFT	Stock	46.66	47.42	46.63	47.272	4613757.0
2015-01-02 10:00:00	MSFT	Stock	47.28	47.3	47.05	47.09	1841176.0
2015-01-02 10:30:00	MSFT	Stock	47.1	47.1	46.92	46.955	2635264.0
2015-01-02 11:00:00	MSFT	Stock	46.96	46.97	46.58	46.66	1677733.0
2015-01-02 11:30:00	MSFT	Stock	46.66	46.74	46.6	46.715	1167990.0
2015-01-02 12:00:00	MSFT	Stock	46.72	46.84	46.7	46.8	971569.0
2015-01-02 12:30:00	MSFT	Stock	46.81	46.83	46.62	46.63	824264.0
2015-01-02 13:00:00	MSFT	Stock	46.62	46.71	46.62	46.685	1019135.0
2015-01-02 13:30:00	MSFT	Stock	46.68	46.71	46.54	46.65	1301842.0
2015-01-02 14:00:00	MSFT	Stock	46.65	46.8	46.545	46.71	1071440.0
2015-01-02 14:30:00	MSFT	Stock	46.71	46.78	46.69	46.716	1002092.0
2015-01-02 15:00:00	MSFT	Stock	46.72	46.733	46.59	46.61	1578791.0
2015-01-02 15:30:00	MSFT	Stock	46.6	46.9	46.585	46.75	4214214.0

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

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