PREVIEW / stock_30min / 2014-10-16

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-10-16.parquet
  size:    1.7 MB
  rows:    85,940
  symbols: 3,562

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-16 04:00:00	AAPL	Stock	24.2525	24.2525	24.1525	24.21	23504.0
2014-10-16 04:30:00	AAPL	Stock	24.1875	24.2	24.1875	24.2	3368.0
2014-10-16 05:00:00	AAPL	Stock	24.21	24.21	24.105	24.105	9080.0
2014-10-16 05:30:00	AAPL	Stock	24.105	24.105	23.875	23.9025	105964.0
2014-10-16 06:00:00	AAPL	Stock	24.0	24.0	23.4375	23.75	429984.0
2014-10-16 06:30:00	AAPL	Stock	23.825	23.8475	23.665	23.7125	208536.0
2014-10-16 07:00:00	AAPL	Stock	23.75	23.9625	23.725	23.95	552280.0
2014-10-16 07:30:00	AAPL	Stock	23.95	24.0225	23.8575	23.925	342360.0
2014-10-16 08:00:00	AAPL	Stock	23.92	24.04	23.7375	23.9025	892632.0
2014-10-16 08:30:00	AAPL	Stock	23.915	23.9575	23.825	23.945	1178676.0
2014-10-16 09:00:00	AAPL	Stock	23.945	24.1	23.8775	23.8825	790708.0
2014-10-16 09:30:00	AAPL	Stock	23.8825	24.1875	23.855	24.0837	36823960.0
2014-10-16 10:00:00	AAPL	Stock	24.0875	24.1	23.8525	23.94	30009748.0
2014-10-16 10:30:00	AAPL	Stock	23.94	24.2475	23.9	24.1412	22410236.0
2014-10-16 11:00:00	AAPL	Stock	24.1425	24.3325	24.0225	24.2812	20789548.0
2014-10-16 11:30:00	AAPL	Stock	24.2825	24.325	24.06	24.09	14752888.0
2014-10-16 12:00:00	AAPL	Stock	24.09	24.2375	24.0625	24.1575	12230340.0
2014-10-16 12:30:00	AAPL	Stock	24.1575	24.275	24.08	24.2502	11459724.0
2014-10-16 13:00:00	AAPL	Stock	24.25	24.43	24.2075	24.302	23922788.0
2014-10-16 13:30:00	AAPL	Stock	24.3	24.3625	24.185	24.22	16226948.0
2014-10-16 14:00:00	AAPL	Stock	24.22	24.2875	24.125	24.1618	15378380.0
2014-10-16 14:30:00	AAPL	Stock	24.1625	24.2125	23.97	23.975	14612616.0
2014-10-16 15:00:00	AAPL	Stock	23.975	24.125	23.95	24.099	16789148.0
2014-10-16 15:30:00	AAPL	Stock	24.0985	24.16	24.0225	24.065	23221884.0
2014-10-16 16:00:00	AAPL	Stock	24.065	24.385	23.915	23.9625	8667992.0
2014-10-16 16:30:00	AAPL	Stock	23.9625	24.1532	23.9625	24.1532	605148.0
2014-10-16 17:00:00	AAPL	Stock	24.05	24.065	21.3492	24.065	258216.0
2014-10-16 17:30:00	AAPL	Stock	24.01	24.065	23.9875	24.0075	116384.0
2014-10-16 18:00:00	AAPL	Stock	24.0225	24.0475	24.0225	24.0475	48476.0
2014-10-16 18:30:00	AAPL	Stock	24.0475	24.085	24.04	24.0625	105572.0
2014-10-16 19:00:00	AAPL	Stock	24.0625	24.0725	24.01	24.0425	25100.0
2014-10-16 19:30:00	AAPL	Stock	24.025	24.0925	24.025	24.0525	32540.0
2014-10-16 06:00:00	MSFT	Stock	42.41	42.41	42.41	42.41	200.0
2014-10-16 06:30:00	MSFT	Stock	42.42	42.45	42.4	42.45	5500.0
2014-10-16 07:00:00	MSFT	Stock	42.45	42.5	42.35	42.5	22000.0
2014-10-16 07:30:00	MSFT	Stock	42.55	42.55	42.47	42.51	13370.0
2014-10-16 08:00:00	MSFT	Stock	42.55	42.8	42.55	42.65	41583.0
2014-10-16 08:30:00	MSFT	Stock	42.71	42.71	42.55	42.62	227208.0
2014-10-16 09:00:00	MSFT	Stock	42.65	42.75	42.57	42.63	60574.0
2014-10-16 09:30:00	MSFT	Stock	42.53	43.08	42.4	42.9	5437387.0
2014-10-16 10:00:00	MSFT	Stock	42.896	42.93	42.37	42.74	4434625.0
2014-10-16 10:30:00	MSFT	Stock	42.74	42.8	42.5	42.63	3870200.0
2014-10-16 11:00:00	MSFT	Stock	42.63	42.665	42.45	42.6	3871590.0
2014-10-16 11:30:00	MSFT	Stock	42.62	42.72	42.42	42.48	3215525.0
2014-10-16 12:00:00	MSFT	Stock	42.48	42.525	42.31	42.41	2312493.0
2014-10-16 12:30:00	MSFT	Stock	42.4	42.53	42.22	42.52	2547689.0
2014-10-16 13:00:00	MSFT	Stock	42.52	42.79	42.52	42.707	3315716.0
2014-10-16 13:30:00	MSFT	Stock	42.7	42.807	42.58	42.65	2506257.0
2014-10-16 14:00:00	MSFT	Stock	42.65	42.79	42.62	42.79	1892834.0
2014-10-16 14:30:00	MSFT	Stock	42.79	42.86	42.62	42.714	2167913.0

> showing 50 of 85,940 rows — these rows as CSV

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