PREVIEW / stock_30min / 2015-03-25

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-03-25.parquet
  size:    1.6 MB
  rows:    83,374
  symbols: 3,490

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-03-25 04:00:00	AAPL	Stock	31.75	31.785	31.75	31.785	3600.0
2015-03-25 05:00:00	AAPL	Stock	31.7425	31.7425	31.7425	31.7425	400.0
2015-03-25 05:30:00	AAPL	Stock	31.7375	31.75	31.7375	31.75	2400.0
2015-03-25 06:00:00	AAPL	Stock	31.765	31.7725	31.75	31.75	1200.0
2015-03-25 06:30:00	AAPL	Stock	31.7425	31.7425	31.7425	31.7425	400.0
2015-03-25 07:00:00	AAPL	Stock	31.7075	31.72	31.6825	31.715	17200.0
2015-03-25 07:30:00	AAPL	Stock	31.7	31.7	31.25	31.45	279880.0
2015-03-25 08:00:00	AAPL	Stock	31.4525	31.76	31.375	31.5975	699636.0
2015-03-25 08:30:00	AAPL	Stock	31.5975	31.65	31.575	31.6425	217384.0
2015-03-25 09:00:00	AAPL	Stock	31.6425	31.6975	31.6125	31.6375	450856.0
2015-03-25 09:30:00	AAPL	Stock	31.6725	31.705	31.3825	31.4375	25223548.0
2015-03-25 10:00:00	AAPL	Stock	31.4375	31.5225	31.325	31.4875	16121776.0
2015-03-25 10:30:00	AAPL	Stock	31.485	31.5	31.3578	31.4962	10115672.0
2015-03-25 11:00:00	AAPL	Stock	31.4962	31.55	31.3675	31.3975	8833772.0
2015-03-25 11:30:00	AAPL	Stock	31.395	31.395	31.2	31.2775	20854932.0
2015-03-25 12:00:00	AAPL	Stock	31.2775	31.2925	31.1575	31.1575	10963136.0
2015-03-25 12:30:00	AAPL	Stock	31.16	31.235	31.105	31.2275	12646464.0
2015-03-25 13:00:00	AAPL	Stock	31.2275	31.2575	31.1075	31.14	8780600.0
2015-03-25 13:30:00	AAPL	Stock	31.14	31.2338	31.115	31.185	7848192.0
2015-03-25 14:00:00	AAPL	Stock	31.1825	31.2125	31.09	31.134	7326696.0
2015-03-25 14:30:00	AAPL	Stock	31.134	31.14	31.055	31.06	9566932.0
2015-03-25 15:00:00	AAPL	Stock	31.06	31.0875	30.855	30.89	15865588.0
2015-03-25 15:30:00	AAPL	Stock	30.8925	30.9525	30.8475	30.8475	25213336.0
2015-03-25 16:00:00	AAPL	Stock	30.845	31.6712	30.845	30.8975	9153280.0
2015-03-25 16:30:00	AAPL	Stock	30.8975	31.2415	30.845	30.98	1458192.0
2015-03-25 17:00:00	AAPL	Stock	30.9825	31.0125	30.845	30.9875	166808.0
2015-03-25 17:30:00	AAPL	Stock	30.9825	30.9875	30.845	30.9798	151512.0
2015-03-25 18:00:00	AAPL	Stock	30.98	30.985	30.9275	30.9375	191796.0
2015-03-25 18:30:00	AAPL	Stock	30.94	30.94	30.875	30.9075	75736.0
2015-03-25 19:00:00	AAPL	Stock	30.9075	30.93	30.9075	30.9175	38264.0
2015-03-25 19:30:00	AAPL	Stock	30.915	30.925	30.91	30.9125	92164.0
2015-03-25 05:00:00	MSFT	Stock	42.9	42.9	42.9	42.9	100.0
2015-03-25 06:00:00	MSFT	Stock	43.0	43.0	43.0	43.0	100.0
2015-03-25 07:00:00	MSFT	Stock	42.96	42.96	42.96	42.96	170.0
2015-03-25 07:30:00	MSFT	Stock	42.92	42.95	42.92	42.92	555.0
2015-03-25 08:00:00	MSFT	Stock	42.8	42.83	42.76	42.83	7120.0
2015-03-25 09:00:00	MSFT	Stock	42.88	42.93	42.86	42.9	16579.0
2015-03-25 09:30:00	MSFT	Stock	42.9	42.925	42.3	42.37	5073012.0
2015-03-25 10:00:00	MSFT	Stock	42.37	42.37	42.26	42.31	2378957.0
2015-03-25 10:30:00	MSFT	Stock	42.3	42.315	42.0	42.08	3315439.0
2015-03-25 11:00:00	MSFT	Stock	42.075	42.16	41.95	42.0	3075704.0
2015-03-25 11:30:00	MSFT	Stock	42.0	42.0	41.585	41.71	4145752.0
2015-03-25 12:00:00	MSFT	Stock	41.71	41.82	41.65	41.74	2991037.0
2015-03-25 12:30:00	MSFT	Stock	41.735	41.89	41.71	41.855	2921626.0
2015-03-25 13:00:00	MSFT	Stock	41.86	41.88	41.64	41.73	1654037.0
2015-03-25 13:30:00	MSFT	Stock	41.74	41.88	41.65	41.722	1775095.0
2015-03-25 14:00:00	MSFT	Stock	41.72	41.74	41.64	41.69	1715020.0
2015-03-25 14:30:00	MSFT	Stock	41.7	41.71	41.54	41.55	2344107.0
2015-03-25 15:00:00	MSFT	Stock	41.555	41.65	41.52	41.52	2123562.0
2015-03-25 15:30:00	MSFT	Stock	41.53	41.56	41.44	41.46	5315671.0

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

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