PREVIEW / stock_30min / 2015-11-23

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-11-23.parquet
  size:    1.6 MB
  rows:    82,287
  symbols: 3,412

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-11-23 04:00:00	AAPL	Stock	29.825	29.825	29.6275	29.75	15292.0
2015-11-23 04:30:00	AAPL	Stock	29.7925	29.7925	29.7925	29.7925	400.0
2015-11-23 05:00:00	AAPL	Stock	29.765	29.765	29.7625	29.7625	1200.0
2015-11-23 06:00:00	AAPL	Stock	29.77	29.77	29.7625	29.7625	1932.0
2015-11-23 06:30:00	AAPL	Stock	29.7425	29.7625	29.7425	29.7425	1976.0
2015-11-23 07:00:00	AAPL	Stock	29.7975	29.945	29.79	29.9275	31608.0
2015-11-23 07:30:00	AAPL	Stock	29.92	29.9375	29.88	29.9075	49056.0
2015-11-23 08:00:00	AAPL	Stock	29.905	29.95	29.775	29.92	141576.0
2015-11-23 08:30:00	AAPL	Stock	29.915	29.9225	29.8425	29.855	99608.0
2015-11-23 09:00:00	AAPL	Stock	29.8625	29.895	29.8175	29.8175	212668.0
2015-11-23 09:30:00	AAPL	Stock	29.815	29.9325	29.6875	29.8675	16792432.0
2015-11-23 10:00:00	AAPL	Stock	29.865	29.8675	29.7875	29.8225	7568328.0
2015-11-23 10:30:00	AAPL	Stock	29.8225	29.83	29.695	29.736	8661128.0
2015-11-23 11:00:00	AAPL	Stock	29.735	29.7355	29.555	29.5875	9194088.0
2015-11-23 11:30:00	AAPL	Stock	29.5895	29.625	29.5125	29.5575	8408804.0
2015-11-23 12:00:00	AAPL	Stock	29.5588	29.56	29.45	29.5325	7921548.0
2015-11-23 12:30:00	AAPL	Stock	29.5338	29.5938	29.4788	29.5775	5276208.0
2015-11-23 13:00:00	AAPL	Stock	29.5762	29.6075	29.4988	29.5225	5868004.0
2015-11-23 13:30:00	AAPL	Stock	29.5238	29.555	29.445	29.4452	5196968.0
2015-11-23 14:00:00	AAPL	Stock	29.445	29.475	29.4	29.4125	7247548.0
2015-11-23 14:30:00	AAPL	Stock	29.4125	29.4475	29.335	29.4225	7327392.0
2015-11-23 15:00:00	AAPL	Stock	29.4238	29.5125	29.4045	29.485	5366128.0
2015-11-23 15:30:00	AAPL	Stock	29.4865	29.5225	29.395	29.4375	10861960.0
2015-11-23 16:00:00	AAPL	Stock	29.4375	29.882	29.435	29.4625	15108924.0
2015-11-23 16:30:00	AAPL	Stock	29.4375	29.465	29.4375	29.45	281156.0
2015-11-23 17:00:00	AAPL	Stock	29.4575	29.4575	29.445	29.445	20672.0
2015-11-23 17:30:00	AAPL	Stock	29.4425	29.4575	29.4375	29.45	26828.0
2015-11-23 18:00:00	AAPL	Stock	29.4375	29.46	29.425	29.46	12900.0
2015-11-23 18:30:00	AAPL	Stock	29.455	29.455	29.43	29.43	7688.0
2015-11-23 19:00:00	AAPL	Stock	29.4275	29.4475	29.4075	29.415	47172.0
2015-11-23 19:30:00	AAPL	Stock	29.4325	29.4475	29.4175	29.42	36592.0
2015-11-23 04:30:00	MSFT	Stock	54.18	54.19	54.18	54.18	3400.0
2015-11-23 05:00:00	MSFT	Stock	54.18	54.18	54.18	54.18	2600.0
2015-11-23 05:30:00	MSFT	Stock	54.16	54.16	54.16	54.16	1240.0
2015-11-23 06:00:00	MSFT	Stock	54.16	54.16	54.16	54.16	1760.0
2015-11-23 07:00:00	MSFT	Stock	54.17	54.3	54.17	54.3	2900.0
2015-11-23 07:30:00	MSFT	Stock	54.37	54.37	54.31	54.31	1900.0
2015-11-23 08:00:00	MSFT	Stock	54.5	54.5	54.3	54.31	11109.0
2015-11-23 08:30:00	MSFT	Stock	54.3	54.33	54.25	54.25	7202.0
2015-11-23 09:00:00	MSFT	Stock	54.29	54.41	54.23	54.23	13161.0
2015-11-23 09:30:00	MSFT	Stock	54.25	54.46	54.05	54.09	2879546.0
2015-11-23 10:00:00	MSFT	Stock	54.09	54.46	54.07	54.29	1897324.0
2015-11-23 10:30:00	MSFT	Stock	54.29	54.39	54.245	54.3	1553806.0
2015-11-23 11:00:00	MSFT	Stock	54.29	54.31	54.1	54.174	1463833.0
2015-11-23 11:30:00	MSFT	Stock	54.175	54.21	54.08	54.12	1304394.0
2015-11-23 12:00:00	MSFT	Stock	54.12	54.2	54.05	54.085	1817864.0
2015-11-23 12:30:00	MSFT	Stock	54.09	54.17	54.0	54.116	1246929.0
2015-11-23 13:00:00	MSFT	Stock	54.12	54.23	54.11	54.146	1476438.0
2015-11-23 13:30:00	MSFT	Stock	54.141	54.21	54.075	54.1	1349731.0
2015-11-23 14:00:00	MSFT	Stock	54.1	54.12	53.78	53.84	2096446.0

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

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