PREVIEW / stock_30min / 2014-11-19

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-11-19.parquet
  size:    1.6 MB
  rows:    83,158
  symbols: 3,565

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
2014-11-19 04:00:00	AAPL	Stock	28.8475	28.8475	28.8475	28.8475	400.0
2014-11-19 04:30:00	AAPL	Stock	28.8725	28.8825	28.8675	28.8675	8000.0
2014-11-19 05:00:00	AAPL	Stock	28.865	28.865	28.85	28.8625	21600.0
2014-11-19 05:30:00	AAPL	Stock	28.8625	28.8625	28.85	28.86	7200.0
2014-11-19 06:00:00	AAPL	Stock	28.86	28.87	28.845	28.8675	36756.0
2014-11-19 06:30:00	AAPL	Stock	28.8675	28.885	28.85	28.8525	28040.0
2014-11-19 07:00:00	AAPL	Stock	28.8625	28.875	28.86	28.86	69764.0
2014-11-19 07:30:00	AAPL	Stock	28.86	28.8725	28.8475	28.8575	49416.0
2014-11-19 08:00:00	AAPL	Stock	28.85	28.8825	28.835	28.855	187068.0
2014-11-19 08:30:00	AAPL	Stock	28.86	28.86	28.8075	28.8375	210980.0
2014-11-19 09:00:00	AAPL	Stock	28.8375	28.8875	28.835	28.86	228420.0
2014-11-19 09:30:00	AAPL	Stock	28.86	28.935	28.665	28.7318	27470424.0
2014-11-19 10:00:00	AAPL	Stock	28.73	28.7475	28.525	28.6125	18905112.0
2014-11-19 10:30:00	AAPL	Stock	28.6125	28.6925	28.5462	28.5475	11365992.0
2014-11-19 11:00:00	AAPL	Stock	28.5475	28.585	28.45	28.5675	14647680.0
2014-11-19 11:30:00	AAPL	Stock	28.57	28.6	28.555	28.575	6149468.0
2014-11-19 12:00:00	AAPL	Stock	28.5738	28.71	28.567	28.6675	7237128.0
2014-11-19 12:30:00	AAPL	Stock	28.665	28.7025	28.6425	28.7	4212436.0
2014-11-19 13:00:00	AAPL	Stock	28.7	28.76	28.7	28.735	6478416.0
2014-11-19 13:30:00	AAPL	Stock	28.735	28.7638	28.6575	28.6928	6910476.0
2014-11-19 14:00:00	AAPL	Stock	28.69	28.785	28.6525	28.6868	8544924.0
2014-11-19 14:30:00	AAPL	Stock	28.6875	28.73	28.66	28.7012	6028336.0
2014-11-19 15:00:00	AAPL	Stock	28.7025	28.75	28.6625	28.72	7054184.0
2014-11-19 15:30:00	AAPL	Stock	28.72	28.7275	28.66	28.665	12303864.0
2014-11-19 16:00:00	AAPL	Stock	28.6675	28.705	28.5692	28.6675	8094008.0
2014-11-19 16:30:00	AAPL	Stock	28.7025	28.7062	28.6675	28.6925	98836.0
2014-11-19 17:00:00	AAPL	Stock	28.69	28.6975	28.6675	28.675	195944.0
2014-11-19 17:30:00	AAPL	Stock	28.685	28.6925	28.6675	28.6675	34920.0
2014-11-19 18:00:00	AAPL	Stock	28.6825	28.6925	28.68	28.68	13268.0
2014-11-19 18:30:00	AAPL	Stock	28.6775	28.6825	28.67	28.6775	15352.0
2014-11-19 19:00:00	AAPL	Stock	28.68	28.6875	28.675	28.675	64888.0
2014-11-19 19:30:00	AAPL	Stock	28.675	28.685	28.6675	28.6825	78292.0
2014-11-19 06:00:00	MSFT	Stock	48.71	48.71	48.71	48.71	100.0
2014-11-19 06:30:00	MSFT	Stock	48.76	48.76	48.76	48.76	200.0
2014-11-19 07:00:00	MSFT	Stock	48.75	48.75	48.75	48.75	400.0
2014-11-19 07:30:00	MSFT	Stock	48.75	48.8	48.75	48.75	7810.0
2014-11-19 08:00:00	MSFT	Stock	48.75	48.75	48.7	48.73	1900.0
2014-11-19 08:30:00	MSFT	Stock	48.69	48.75	48.67	48.67	3718.0
2014-11-19 09:00:00	MSFT	Stock	48.73	48.73	48.63	48.7	12723.0
2014-11-19 09:30:00	MSFT	Stock	48.66	48.755	48.08	48.11	3632687.0
2014-11-19 10:00:00	MSFT	Stock	48.11	48.16	48.01	48.044	2816366.0
2014-11-19 10:30:00	MSFT	Stock	48.045	48.15	47.93	48.0	1444370.0
2014-11-19 11:00:00	MSFT	Stock	47.995	48.21	47.98	48.16	1113885.0
2014-11-19 11:30:00	MSFT	Stock	48.165	48.23	48.14	48.22	1023213.0
2014-11-19 12:00:00	MSFT	Stock	48.215	48.26	48.205	48.23	647587.0
2014-11-19 12:30:00	MSFT	Stock	48.23	48.28	48.15	48.239	886069.0
2014-11-19 13:00:00	MSFT	Stock	48.235	48.3	48.14	48.14	1150779.0
2014-11-19 13:30:00	MSFT	Stock	48.14	48.19	48.09	48.11	913851.0
2014-11-19 14:00:00	MSFT	Stock	48.105	48.27	48.0	48.043	1677493.0
2014-11-19 14:30:00	MSFT	Stock	48.04	48.14	48.01	48.12	1091214.0

> showing 50 of 83,158 rows — these rows as CSV

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