PREVIEW / stock_30min / 2015-12-01

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-12-01.parquet
  size:    1.6 MB
  rows:    83,031
  symbols: 3,431

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-12-01 04:00:00	AAPL	Stock	29.72	29.735	29.6925	29.6925	4940.0
2015-12-01 04:30:00	AAPL	Stock	29.6725	29.6725	29.65	29.6625	17920.0
2015-12-01 05:00:00	AAPL	Stock	29.6625	29.6625	29.6375	29.65	10480.0
2015-12-01 05:30:00	AAPL	Stock	29.6375	29.68	29.625	29.68	17256.0
2015-12-01 06:00:00	AAPL	Stock	29.6775	29.725	29.6775	29.7175	12160.0
2015-12-01 06:30:00	AAPL	Stock	29.695	29.7475	29.69	29.725	45476.0
2015-12-01 07:00:00	AAPL	Stock	29.72	29.745	29.6925	29.6925	45620.0
2015-12-01 07:30:00	AAPL	Stock	29.6925	29.735	29.69	29.735	47868.0
2015-12-01 08:00:00	AAPL	Stock	29.72	29.75	29.655	29.6575	260876.0
2015-12-01 08:30:00	AAPL	Stock	29.6675	29.6675	29.65	29.6575	90312.0
2015-12-01 09:00:00	AAPL	Stock	29.6575	29.7125	29.575	29.68	265124.0
2015-12-01 09:30:00	AAPL	Stock	29.6875	29.7025	29.5375	29.6625	15287160.0
2015-12-01 10:00:00	AAPL	Stock	29.6625	29.685	29.455	29.54	14462580.0
2015-12-01 10:30:00	AAPL	Stock	29.54	29.618	29.485	29.57	7932152.0
2015-12-01 11:00:00	AAPL	Stock	29.5725	29.62	29.555	29.555	4658564.0
2015-12-01 11:30:00	AAPL	Stock	29.555	29.58	29.4925	29.5175	5514608.0
2015-12-01 12:00:00	AAPL	Stock	29.5175	29.583	29.4625	29.545	7821884.0
2015-12-01 12:30:00	AAPL	Stock	29.545	29.56	29.44	29.4588	8001156.0
2015-12-01 13:00:00	AAPL	Stock	29.4575	29.46	29.3325	29.3422	8037736.0
2015-12-01 13:30:00	AAPL	Stock	29.3425	29.3925	29.2825	29.34	8554332.0
2015-12-01 14:00:00	AAPL	Stock	29.34	29.375	29.2825	29.2838	6096804.0
2015-12-01 14:30:00	AAPL	Stock	29.2825	29.3112	29.215	29.286	9562004.0
2015-12-01 15:00:00	AAPL	Stock	29.285	29.325	29.25	29.2688	7451276.0
2015-12-01 15:30:00	AAPL	Stock	29.2662	29.345	29.2662	29.3225	16486880.0
2015-12-01 16:00:00	AAPL	Stock	29.3308	29.5872	29.3	29.325	10360328.0
2015-12-01 16:30:00	AAPL	Stock	29.3225	29.33	29.315	29.325	43504.0
2015-12-01 17:00:00	AAPL	Stock	29.325	29.325	29.3125	29.3225	21540.0
2015-12-01 17:30:00	AAPL	Stock	29.32	29.3225	29.31	29.3175	23456.0
2015-12-01 18:00:00	AAPL	Stock	29.325	29.325	29.3125	29.3125	15428.0
2015-12-01 18:30:00	AAPL	Stock	29.31	29.3225	29.3075	29.3075	8284.0
2015-12-01 19:00:00	AAPL	Stock	29.32	29.32	29.31	29.3125	5000.0
2015-12-01 19:30:00	AAPL	Stock	29.315	29.3175	29.295	29.2975	104548.0
2015-12-01 05:30:00	MSFT	Stock	54.49	54.55	54.49	54.55	2400.0
2015-12-01 06:00:00	MSFT	Stock	54.6	54.61	54.6	54.6	2900.0
2015-12-01 07:00:00	MSFT	Stock	54.57	54.57	54.56	54.56	200.0
2015-12-01 07:30:00	MSFT	Stock	54.56	54.56	54.47	54.55	1342.0
2015-12-01 08:00:00	MSFT	Stock	54.6	54.66	54.57	54.62	16342.0
2015-12-01 08:30:00	MSFT	Stock	54.62	54.65	54.58	54.6	15090.0
2015-12-01 09:00:00	MSFT	Stock	54.65	54.65	54.37	54.41	35940.0
2015-12-01 09:30:00	MSFT	Stock	54.37	54.65	54.3	54.58	4246660.0
2015-12-01 10:00:00	MSFT	Stock	54.58	54.75	54.35	54.69	2893077.0
2015-12-01 10:30:00	MSFT	Stock	54.69	55.14	54.6	55.035	4060573.0
2015-12-01 11:00:00	MSFT	Stock	55.04	55.1	54.815	54.84	3404374.0
2015-12-01 11:30:00	MSFT	Stock	54.83	54.88	54.72	54.825	1889635.0
2015-12-01 12:00:00	MSFT	Stock	54.83	54.9	54.71	54.74	1679179.0
2015-12-01 12:30:00	MSFT	Stock	54.74	54.898	54.705	54.81	1174914.0
2015-12-01 13:00:00	MSFT	Stock	54.81	54.819	54.64	54.73	1594882.0
2015-12-01 13:30:00	MSFT	Stock	54.73	54.805	54.71	54.77	1555414.0
2015-12-01 14:00:00	MSFT	Stock	54.77	54.916	54.75	54.86	1753821.0
2015-12-01 14:30:00	MSFT	Stock	54.87	54.989	54.84	54.94	1636560.0

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

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