PREVIEW / stock_30min / 2018-10-22

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-10-22.parquet
  size:    1.7 MB
  rows:    83,631
  symbols: 2,747

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
2018-10-22 04:00:00	AAPL	Stock	54.75	55.025	54.75	55.025	2120.0
2018-10-22 04:30:00	AAPL	Stock	55.0675	55.07	55.005	55.005	4748.0
2018-10-22 05:00:00	AAPL	Stock	55.0525	55.055	55.0525	55.055	14728.0
2018-10-22 05:30:00	AAPL	Stock	55.025	55.025	55.02	55.02	3992.0
2018-10-22 06:00:00	AAPL	Stock	55.0875	55.1025	55.0	55.1025	29984.0
2018-10-22 06:30:00	AAPL	Stock	55.18	55.18	55.18	55.18	400.0
2018-10-22 07:00:00	AAPL	Stock	55.18	55.2875	55.1625	55.2	96304.0
2018-10-22 07:30:00	AAPL	Stock	55.2225	55.365	55.1925	55.25	111228.0
2018-10-22 08:00:00	AAPL	Stock	55.235	55.3625	55.1725	55.2275	358608.0
2018-10-22 08:30:00	AAPL	Stock	55.2275	55.2275	55.1	55.1	153176.0
2018-10-22 09:00:00	AAPL	Stock	55.1	55.125	54.8875	54.9625	456680.0
2018-10-22 09:30:00	AAPL	Stock	54.9625	55.3075	54.7275	54.9628	12992128.0
2018-10-22 10:00:00	AAPL	Stock	54.955	55.2525	54.9275	55.06	8180548.0
2018-10-22 10:30:00	AAPL	Stock	55.0578	55.83	55.0025	55.6605	10744380.0
2018-10-22 11:00:00	AAPL	Stock	55.6625	55.84	55.5775	55.6725	7015368.0
2018-10-22 11:30:00	AAPL	Stock	55.675	55.7275	55.39	55.48	5589148.0
2018-10-22 12:00:00	AAPL	Stock	55.48	55.605	55.1975	55.34	5640584.0
2018-10-22 12:30:00	AAPL	Stock	55.34	55.5575	55.3118	55.3825	4805408.0
2018-10-22 13:00:00	AAPL	Stock	55.38	55.4925	55.225	55.265	4111440.0
2018-10-22 13:30:00	AAPL	Stock	55.265	55.45	55.144	55.1475	4074444.0
2018-10-22 14:00:00	AAPL	Stock	55.145	55.3325	55.085	55.095	4019864.0
2018-10-22 14:30:00	AAPL	Stock	55.1	55.355	55.065	55.3	3909760.0
2018-10-22 15:00:00	AAPL	Stock	55.2975	55.5175	55.2175	55.4125	5168476.0
2018-10-22 15:30:00	AAPL	Stock	55.4075	55.57	55.145	55.1475	9023940.0
2018-10-22 16:00:00	AAPL	Stock	55.1475	55.22	55.1175	55.1625	11575128.0
2018-10-22 16:30:00	AAPL	Stock	55.13	55.1625	55.125	55.1275	29948.0
2018-10-22 17:00:00	AAPL	Stock	55.125	55.1625	55.125	55.15	31052.0
2018-10-22 17:30:00	AAPL	Stock	55.15	55.16	55.1425	55.16	12952.0
2018-10-22 18:00:00	AAPL	Stock	55.15	55.1625	55.13	55.135	20056.0
2018-10-22 18:30:00	AAPL	Stock	55.15	55.175	55.15	55.175	4400.0
2018-10-22 19:00:00	AAPL	Stock	55.175	55.1825	55.13	55.15	8096.0
2018-10-22 19:30:00	AAPL	Stock	55.135	55.135	55.04	55.05	37524.0
2018-10-22 04:00:00	MSFT	Stock	109.1	109.61	109.1	109.61	799.0
2018-10-22 04:30:00	MSFT	Stock	109.5	109.5	108.95	108.95	1700.0
2018-10-22 05:00:00	MSFT	Stock	109.31	109.31	108.97	108.97	569.0
2018-10-22 05:30:00	MSFT	Stock	109.09	109.09	108.74	108.74	2037.0
2018-10-22 06:00:00	MSFT	Stock	109.08	109.09	109.08	109.09	2656.0
2018-10-22 06:30:00	MSFT	Stock	109.1	109.15	109.0	109.15	2900.0
2018-10-22 07:00:00	MSFT	Stock	109.03	109.39	109.03	109.32	13583.0
2018-10-22 07:30:00	MSFT	Stock	109.3	109.55	109.28	109.5	3118.0
2018-10-22 08:00:00	MSFT	Stock	109.55	109.75	109.1	109.7	23111.0
2018-10-22 08:30:00	MSFT	Stock	109.63	109.66	109.34	109.4	13530.0
2018-10-22 09:00:00	MSFT	Stock	109.34	109.59	109.15	109.4	18773.0
2018-10-22 09:30:00	MSFT	Stock	109.32	109.648	108.44	108.62	3211272.0
2018-10-22 10:00:00	MSFT	Stock	108.62	109.08	108.24	108.99	2144729.0
2018-10-22 10:30:00	MSFT	Stock	108.97	110.54	108.84	110.27	2212888.0
2018-10-22 11:00:00	MSFT	Stock	110.27	110.48	109.92	109.99	1870871.0
2018-10-22 11:30:00	MSFT	Stock	109.99	110.07	109.41	109.66	1330206.0
2018-10-22 12:00:00	MSFT	Stock	109.67	109.84	108.92	109.28	1453360.0
2018-10-22 12:30:00	MSFT	Stock	109.28	110.01	109.27	109.85	994355.0

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

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