PREVIEW / stock_30min / 2014-01-23

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-01-23.parquet
  size:    1.6 MB
  rows:    83,433
  symbols: 3,549

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-01-23 04:00:00	AAPL	Stock	19.75	19.75	19.7171	19.7171	5600.0
2014-01-23 04:30:00	AAPL	Stock	19.7382	19.7382	19.7382	19.7382	3332.0
2014-01-23 05:30:00	AAPL	Stock	19.7439	19.7439	19.7439	19.7439	5600.0
2014-01-23 06:30:00	AAPL	Stock	19.7411	19.7411	19.7071	19.7143	30940.0
2014-01-23 07:00:00	AAPL	Stock	19.6964	19.7071	19.6493	19.6679	263984.0
2014-01-23 07:30:00	AAPL	Stock	19.6679	19.7021	19.6679	19.7021	141792.0
2014-01-23 08:00:00	AAPL	Stock	19.6607	19.7082	19.6607	19.6957	189028.0
2014-01-23 08:30:00	AAPL	Stock	19.6875	19.6882	19.6296	19.6418	769076.0
2014-01-23 09:00:00	AAPL	Stock	19.635	19.6636	19.6129	19.6346	640472.0
2014-01-23 09:30:00	AAPL	Stock	19.6414	19.7082	19.5754	19.6721	38808588.0
2014-01-23 10:00:00	AAPL	Stock	19.6741	19.7082	19.5125	19.5196	23970464.0
2014-01-23 10:30:00	AAPL	Stock	19.5154	19.5361	19.4764	19.4882	17574844.0
2014-01-23 11:00:00	AAPL	Stock	19.4911	19.5496	19.4574	19.5431	13985468.0
2014-01-23 11:30:00	AAPL	Stock	19.5436	19.5629	19.5096	19.5489	9460808.0
2014-01-23 12:00:00	AAPL	Stock	19.55	19.5704	19.519	19.5646	6270152.0
2014-01-23 12:30:00	AAPL	Stock	19.5554	19.6036	19.5339	19.5989	9151772.0
2014-01-23 13:00:00	AAPL	Stock	19.6012	19.6761	19.5975	19.6761	16531480.0
2014-01-23 13:30:00	AAPL	Stock	19.6761	19.7568	19.6664	19.7143	34075132.0
2014-01-23 14:00:00	AAPL	Stock	19.715	19.8311	19.6939	19.8054	33262460.0
2014-01-23 14:30:00	AAPL	Stock	19.8082	19.8268	19.7646	19.8196	24885812.0
2014-01-23 15:00:00	AAPL	Stock	19.8186	19.875	19.7657	19.8546	40070940.0
2014-01-23 15:30:00	AAPL	Stock	19.8554	19.8661	19.8057	19.8636	30013536.0
2014-01-23 16:00:00	AAPL	Stock	19.8636	19.8929	19.6966	19.8504	40690720.0
2014-01-23 16:30:00	AAPL	Stock	19.8643	19.875	19.5732	19.8686	441840.0
2014-01-23 17:00:00	AAPL	Stock	19.8643	19.8695	19.8454	19.8482	321356.0
2014-01-23 17:30:00	AAPL	Stock	19.8482	19.8482	19.8439	19.8439	19600.0
2014-01-23 18:00:00	AAPL	Stock	19.845	19.8636	19.845	19.8636	248220.0
2014-01-23 18:30:00	AAPL	Stock	19.8535	19.8571	19.85	19.8521	98420.0
2014-01-23 19:00:00	AAPL	Stock	19.8521	19.8571	19.8379	19.8554	48440.0
2014-01-23 19:30:00	AAPL	Stock	19.8536	19.8554	19.8482	19.8554	98560.0
2014-01-23 04:00:00	MSFT	Stock	36.07	36.23	36.07	36.23	1071.0
2014-01-23 05:00:00	MSFT	Stock	36.23	36.27	36.23	36.27	600.0
2014-01-23 05:30:00	MSFT	Stock	36.27	36.27	36.27	36.27	300.0
2014-01-23 06:30:00	MSFT	Stock	36.24	36.24	36.24	36.24	100.0
2014-01-23 07:30:00	MSFT	Stock	36.18	36.19	36.1	36.12	7331.0
2014-01-23 08:00:00	MSFT	Stock	36.19	36.3	36.12	36.25	23830.0
2014-01-23 08:30:00	MSFT	Stock	36.25	36.31	36.2	36.2	10408.0
2014-01-23 09:00:00	MSFT	Stock	36.22	36.29	36.0	36.03	45122.0
2014-01-23 09:30:00	MSFT	Stock	36.09	36.13	35.63	35.64	4712146.0
2014-01-23 10:00:00	MSFT	Stock	35.65	35.81	35.58	35.74	2698214.0
2014-01-23 10:30:00	MSFT	Stock	35.73	35.8	35.665	35.76	1974123.0
2014-01-23 11:00:00	MSFT	Stock	35.76	35.86	35.67	35.84	2567406.0
2014-01-23 11:30:00	MSFT	Stock	35.84	35.88	35.79	35.8	1109669.0
2014-01-23 12:00:00	MSFT	Stock	35.79	35.81	35.66	35.74	1616940.0
2014-01-23 12:30:00	MSFT	Stock	35.745	35.757	35.67	35.705	1504299.0
2014-01-23 13:00:00	MSFT	Stock	35.705	35.72	35.59	35.62	1770684.0
2014-01-23 13:30:00	MSFT	Stock	35.616	35.68	35.52	35.64	2056198.0
2014-01-23 14:00:00	MSFT	Stock	35.64	36.09	35.61	35.83	3472054.0
2014-01-23 14:30:00	MSFT	Stock	35.825	35.92	35.78	35.846	1973619.0
2014-01-23 15:00:00	MSFT	Stock	35.84	35.9	35.77	35.885	1758771.0

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

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