PREVIEW / stock_30min / 2014-11-24

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-11-24.parquet
  size:    1.6 MB
  rows:    84,780
  symbols: 3,570

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-24 04:00:00	AAPL	Stock	29.15	29.2175	29.15	29.2075	11712.0
2014-11-24 04:30:00	AAPL	Stock	29.2175	29.22	29.1875	29.1875	20252.0
2014-11-24 05:00:00	AAPL	Stock	29.1875	29.1875	29.1625	29.1625	3600.0
2014-11-24 05:30:00	AAPL	Stock	29.175	29.175	29.15	29.175	19700.0
2014-11-24 06:00:00	AAPL	Stock	29.1875	29.195	29.165	29.175	14704.0
2014-11-24 06:30:00	AAPL	Stock	29.185	29.1875	29.165	29.175	35312.0
2014-11-24 07:00:00	AAPL	Stock	29.175	29.2075	29.1625	29.1975	105744.0
2014-11-24 07:30:00	AAPL	Stock	29.1975	29.2025	29.1775	29.185	77424.0
2014-11-24 08:00:00	AAPL	Stock	29.19	29.2175	29.1775	29.2125	248000.0
2014-11-24 08:30:00	AAPL	Stock	29.2125	29.265	29.2075	29.215	382184.0
2014-11-24 09:00:00	AAPL	Stock	29.22	29.23	29.2	29.2175	296096.0
2014-11-24 09:30:00	AAPL	Stock	29.2125	29.33	29.155	29.295	24107316.0
2014-11-24 10:00:00	AAPL	Stock	29.295	29.3675	29.29	29.365	14348272.0
2014-11-24 10:30:00	AAPL	Stock	29.3675	29.435	29.355	29.3725	15949308.0
2014-11-24 11:00:00	AAPL	Stock	29.3725	29.4625	29.37	29.425	11946368.0
2014-11-24 11:30:00	AAPL	Stock	29.425	29.4375	29.3625	29.41	8621844.0
2014-11-24 12:00:00	AAPL	Stock	29.4148	29.4875	29.4025	29.485	7775316.0
2014-11-24 12:30:00	AAPL	Stock	29.4842	29.565	29.465	29.5375	13824968.0
2014-11-24 13:00:00	AAPL	Stock	29.5375	29.5562	29.5025	29.55	6054144.0
2014-11-24 13:30:00	AAPL	Stock	29.5498	29.575	29.5475	29.5675	6481744.0
2014-11-24 14:00:00	AAPL	Stock	29.57	29.59	29.5325	29.5765	7865760.0
2014-11-24 14:30:00	AAPL	Stock	29.575	29.6125	29.55	29.605	8098444.0
2014-11-24 15:00:00	AAPL	Stock	29.6062	29.61	29.5675	29.605	8583708.0
2014-11-24 15:30:00	AAPL	Stock	29.6075	29.6925	29.605	29.6562	18242860.0
2014-11-24 16:00:00	AAPL	Stock	29.6562	29.675	29.0815	29.6302	20282476.0
2014-11-24 16:30:00	AAPL	Stock	29.6302	29.6562	29.5945	29.6325	216292.0
2014-11-24 17:00:00	AAPL	Stock	29.63	29.6598	29.482	29.645	302492.0
2014-11-24 17:30:00	AAPL	Stock	29.6475	29.665	29.6425	29.6575	85284.0
2014-11-24 18:00:00	AAPL	Stock	29.6625	29.6825	29.655	29.6825	76336.0
2014-11-24 18:30:00	AAPL	Stock	29.6825	29.695	29.655	29.695	1169760.0
2014-11-24 19:00:00	AAPL	Stock	29.695	29.7	29.685	29.6975	58536.0
2014-11-24 19:30:00	AAPL	Stock	29.6925	29.6975	29.685	29.6925	72196.0
2014-11-24 05:00:00	MSFT	Stock	48.03	48.03	48.0	48.0	600.0
2014-11-24 05:30:00	MSFT	Stock	48.0	48.1	48.0	48.1	1900.0
2014-11-24 06:00:00	MSFT	Stock	48.1	48.1	48.05	48.05	600.0
2014-11-24 06:30:00	MSFT	Stock	48.01	48.01	48.01	48.01	850.0
2014-11-24 07:30:00	MSFT	Stock	48.03	48.03	48.03	48.03	150.0
2014-11-24 08:00:00	MSFT	Stock	48.03	48.03	48.0	48.01	2900.0
2014-11-24 08:30:00	MSFT	Stock	48.01	48.07	48.0	48.0	5359.0
2014-11-24 09:00:00	MSFT	Stock	48.07	48.07	47.96	48.04	24670.0
2014-11-24 09:30:00	MSFT	Stock	47.98	48.0	47.39	47.5	6101415.0
2014-11-24 10:00:00	MSFT	Stock	47.51	47.71	47.48	47.7	2696670.0
2014-11-24 10:30:00	MSFT	Stock	47.695	47.76	47.67	47.7	2927609.0
2014-11-24 11:00:00	MSFT	Stock	47.695	47.81	47.67	47.8	1609093.0
2014-11-24 11:30:00	MSFT	Stock	47.795	47.83	47.74	47.78	1363718.0
2014-11-24 12:00:00	MSFT	Stock	47.775	47.85	47.77	47.833	1227966.0
2014-11-24 12:30:00	MSFT	Stock	47.83	47.85	47.7	47.76	1544440.0
2014-11-24 13:00:00	MSFT	Stock	47.75	47.85	47.73	47.823	1362567.0
2014-11-24 13:30:00	MSFT	Stock	47.82	47.83	47.75	47.77	1030709.0
2014-11-24 14:00:00	MSFT	Stock	47.77	47.83	47.74	47.82	1436447.0

> showing 50 of 84,780 rows — these rows as CSV

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