PREVIEW / stock_30min / 2014-10-20

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-10-20.parquet
  size:    1.6 MB
  rows:    84,178
  symbols: 3,563

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-10-20 04:00:00	AAPL	Stock	24.6875	24.7675	24.5325	24.5475	37424.0
2014-10-20 04:30:00	AAPL	Stock	24.5475	24.5875	24.5475	24.5875	10400.0
2014-10-20 05:00:00	AAPL	Stock	24.55	24.565	24.525	24.565	25140.0
2014-10-20 05:30:00	AAPL	Stock	24.58	24.58	24.575	24.575	2800.0
2014-10-20 06:00:00	AAPL	Stock	24.58	24.635	24.58	24.5875	57316.0
2014-10-20 06:30:00	AAPL	Stock	24.625	24.6625	24.5875	24.5875	92348.0
2014-10-20 07:00:00	AAPL	Stock	24.5775	24.595	24.515	24.575	190780.0
2014-10-20 07:30:00	AAPL	Stock	24.5725	24.7175	24.5575	24.575	539352.0
2014-10-20 08:00:00	AAPL	Stock	24.6055	24.7075	24.5025	24.62	1027664.0
2014-10-20 08:30:00	AAPL	Stock	24.62	24.6225	24.6	24.6	264748.0
2014-10-20 09:00:00	AAPL	Stock	24.605	24.605	24.515	24.5825	425972.0
2014-10-20 09:30:00	AAPL	Stock	24.5788	24.82	24.575	24.7322	37267532.0
2014-10-20 10:00:00	AAPL	Stock	24.735	24.8375	24.73	24.835	20379468.0
2014-10-20 10:30:00	AAPL	Stock	24.8375	24.895	24.7775	24.8725	19429080.0
2014-10-20 11:00:00	AAPL	Stock	24.8725	24.9175	24.79	24.905	16447880.0
2014-10-20 11:30:00	AAPL	Stock	24.9052	24.92	24.8125	24.83	12657968.0
2014-10-20 12:00:00	AAPL	Stock	24.8315	24.875	24.7925	24.795	9473084.0
2014-10-20 12:30:00	AAPL	Stock	24.795	24.845	24.765	24.8088	10617692.0
2014-10-20 13:00:00	AAPL	Stock	24.8075	24.8175	24.765	24.795	10236464.0
2014-10-20 13:30:00	AAPL	Stock	24.7925	24.86	24.78	24.8288	10759808.0
2014-10-20 14:00:00	AAPL	Stock	24.8312	24.8525	24.81	24.8288	12368544.0
2014-10-20 14:30:00	AAPL	Stock	24.8275	24.905	24.8225	24.8862	15636624.0
2014-10-20 15:00:00	AAPL	Stock	24.885	24.9225	24.8725	24.9185	18186528.0
2014-10-20 15:30:00	AAPL	Stock	24.9175	24.99	24.9125	24.9425	38370776.0
2014-10-20 16:00:00	AAPL	Stock	24.94	25.0725	24.5975	24.9875	9788872.0
2014-10-20 16:30:00	AAPL	Stock	24.9625	25.435	24.625	25.2125	29232716.0
2014-10-20 17:00:00	AAPL	Stock	25.2175	25.355	21.7038	25.2625	7658700.0
2014-10-20 17:30:00	AAPL	Stock	25.2675	25.4175	24.94	25.3125	3995740.0
2014-10-20 18:00:00	AAPL	Stock	25.3125	25.3425	24.94	25.3425	1223672.0
2014-10-20 18:30:00	AAPL	Stock	25.34	25.3475	24.94	25.3	653680.0
2014-10-20 19:00:00	AAPL	Stock	25.2925	25.325	25.28	25.32	450276.0
2014-10-20 19:30:00	AAPL	Stock	25.3225	25.325	25.3	25.3175	506440.0
2014-10-20 04:00:00	MSFT	Stock	43.7	43.7	43.7	43.7	300.0
2014-10-20 06:30:00	MSFT	Stock	43.68	43.76	43.68	43.76	800.0
2014-10-20 07:00:00	MSFT	Stock	43.51	43.51	43.2	43.2	1730.0
2014-10-20 07:30:00	MSFT	Stock	43.2	43.33	43.1	43.1	3370.0
2014-10-20 08:00:00	MSFT	Stock	43.3	43.4	43.2	43.3	11072.0
2014-10-20 08:30:00	MSFT	Stock	43.3	43.35	43.25	43.25	2803.0
2014-10-20 09:00:00	MSFT	Stock	43.3	43.3	43.0	43.07	174942.0
2014-10-20 09:30:00	MSFT	Stock	43.07	43.2	42.81	43.18	5813760.0
2014-10-20 10:00:00	MSFT	Stock	43.18	43.51	43.12	43.44	2723400.0
2014-10-20 10:30:00	MSFT	Stock	43.45	43.68	43.34	43.63	2204175.0
2014-10-20 11:00:00	MSFT	Stock	43.62	43.74	43.51	43.735	1596694.0
2014-10-20 11:30:00	MSFT	Stock	43.74	43.79	43.63	43.79	1266957.0
2014-10-20 12:00:00	MSFT	Stock	43.786	43.91	43.77	43.835	1617375.0
2014-10-20 12:30:00	MSFT	Stock	43.835	43.88	43.75	43.76	1356496.0
2014-10-20 13:00:00	MSFT	Stock	43.76	43.885	43.67	43.87	1231378.0
2014-10-20 13:30:00	MSFT	Stock	43.875	43.95	43.83	43.86	1426240.0
2014-10-20 14:00:00	MSFT	Stock	43.86	44.0	43.85	43.957	1471651.0
2014-10-20 14:30:00	MSFT	Stock	43.955	44.04	43.94	44.04	1204146.0

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

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