PREVIEW / stock_30min / 2015-05-19

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-05-19.parquet
  size:    1.6 MB
  rows:    82,980
  symbols: 3,518

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-05-19 04:00:00	AAPL	Stock	32.675	32.7225	32.6675	32.6675	68164.0
2015-05-19 04:30:00	AAPL	Stock	32.7075	32.7125	32.7075	32.7125	1732.0
2015-05-19 05:00:00	AAPL	Stock	32.71	32.72	32.7	32.72	11144.0
2015-05-19 05:30:00	AAPL	Stock	32.72	32.7225	32.6875	32.705	49580.0
2015-05-19 06:00:00	AAPL	Stock	32.7075	32.7225	32.6925	32.7025	40340.0
2015-05-19 06:30:00	AAPL	Stock	32.7075	32.725	32.695	32.705	69828.0
2015-05-19 07:00:00	AAPL	Stock	32.695	32.71	32.6725	32.71	230004.0
2015-05-19 07:30:00	AAPL	Stock	32.7075	32.715	32.675	32.7	92108.0
2015-05-19 08:00:00	AAPL	Stock	32.7	32.7162	32.64	32.6675	920504.0
2015-05-19 08:30:00	AAPL	Stock	32.6675	32.6725	32.5675	32.6	1001952.0
2015-05-19 09:00:00	AAPL	Stock	32.6	32.6725	32.5775	32.65	636016.0
2015-05-19 09:30:00	AAPL	Stock	32.6725	32.72	32.4875	32.6	28128460.0
2015-05-19 10:00:00	AAPL	Stock	32.6025	32.6225	32.455	32.5475	17474148.0
2015-05-19 10:30:00	AAPL	Stock	32.5485	32.63	32.5325	32.6	11869544.0
2015-05-19 11:00:00	AAPL	Stock	32.595	32.615	32.5525	32.5825	7501776.0
2015-05-19 11:30:00	AAPL	Stock	32.5875	32.6175	32.545	32.6	6967788.0
2015-05-19 12:00:00	AAPL	Stock	32.6002	32.61	32.54	32.5425	5620448.0
2015-05-19 12:30:00	AAPL	Stock	32.545	32.6075	32.5088	32.5828	8796368.0
2015-05-19 13:00:00	AAPL	Stock	32.5845	32.62	32.5475	32.615	4956580.0
2015-05-19 13:30:00	AAPL	Stock	32.6125	32.69	32.6075	32.675	9925104.0
2015-05-19 14:00:00	AAPL	Stock	32.6725	32.6922	32.6575	32.665	5537808.0
2015-05-19 14:30:00	AAPL	Stock	32.6675	32.6775	32.59	32.595	8198840.0
2015-05-19 15:00:00	AAPL	Stock	32.595	32.6225	32.4375	32.4482	12960308.0
2015-05-19 15:30:00	AAPL	Stock	32.45	32.56	32.41	32.5175	16957464.0
2015-05-19 16:00:00	AAPL	Stock	32.5175	32.5552	32.5	32.5	14884364.0
2015-05-19 16:30:00	AAPL	Stock	32.52	32.525	32.5025	32.5225	33624.0
2015-05-19 17:00:00	AAPL	Stock	32.53	32.53	32.5075	32.53	29308.0
2015-05-19 17:30:00	AAPL	Stock	32.5275	32.5275	32.51	32.525	58052.0
2015-05-19 18:00:00	AAPL	Stock	32.5125	32.5125	32.5075	32.5125	4816.0
2015-05-19 18:30:00	AAPL	Stock	32.515	32.52	32.5075	32.52	64632.0
2015-05-19 19:00:00	AAPL	Stock	32.5175	32.52	32.5075	32.5075	2764.0
2015-05-19 19:30:00	AAPL	Stock	32.5078	32.525	32.5075	32.525	43148.0
2015-05-19 04:00:00	MSFT	Stock	47.87	47.87	47.87	47.87	2900.0
2015-05-19 04:30:00	MSFT	Stock	47.85	47.85	47.85	47.85	600.0
2015-05-19 06:00:00	MSFT	Stock	47.84	47.85	47.84	47.85	400.0
2015-05-19 06:30:00	MSFT	Stock	47.85	47.85	47.85	47.85	600.0
2015-05-19 07:00:00	MSFT	Stock	47.81	47.82	47.81	47.82	400.0
2015-05-19 08:00:00	MSFT	Stock	47.83	47.88	47.8	47.87	5321.0
2015-05-19 08:30:00	MSFT	Stock	47.84	47.85	47.75	47.75	12827.0
2015-05-19 09:00:00	MSFT	Stock	47.8	47.81	47.58	47.58	30961.0
2015-05-19 09:30:00	MSFT	Stock	47.57	47.81	47.39	47.427	3642307.0
2015-05-19 10:00:00	MSFT	Stock	47.43	47.5	47.27	47.39	1645721.0
2015-05-19 10:30:00	MSFT	Stock	47.39	47.44	47.18	47.19	1902295.0
2015-05-19 11:00:00	MSFT	Stock	47.195	47.46	47.195	47.44	1816125.0
2015-05-19 11:30:00	MSFT	Stock	47.44	47.46	47.28	47.35	1804423.0
2015-05-19 12:00:00	MSFT	Stock	47.35	47.4	47.29	47.344	987418.0
2015-05-19 12:30:00	MSFT	Stock	47.345	47.49	47.29	47.48	905634.0
2015-05-19 13:00:00	MSFT	Stock	47.485	47.54	47.44	47.515	1106448.0
2015-05-19 13:30:00	MSFT	Stock	47.52	47.6	47.48	47.505	1013807.0
2015-05-19 14:00:00	MSFT	Stock	47.505	47.54	47.46	47.5	889568.0

> showing 50 of 82,980 rows — these rows as CSV

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