PREVIEW / stock_30min / 2019-05-06

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-05-06.parquet
  size:    1.7 MB
  rows:    86,476
  symbols: 2,620

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
2019-05-06 04:00:00	AAPL	Stock	51.425	51.425	51.185	51.1875	104456.0
2019-05-06 04:30:00	AAPL	Stock	51.235	51.2375	50.955	50.9825	79612.0
2019-05-06 05:00:00	AAPL	Stock	50.955	51.0725	50.95	51.0275	58308.0
2019-05-06 05:30:00	AAPL	Stock	51.0375	51.325	51.0375	51.2775	56784.0
2019-05-06 06:00:00	AAPL	Stock	51.25	51.2875	51.15	51.2525	78112.0
2019-05-06 06:30:00	AAPL	Stock	51.25	51.3675	51.21	51.3625	132244.0
2019-05-06 07:00:00	AAPL	Stock	51.325	51.41	51.2	51.37	590200.0
2019-05-06 07:30:00	AAPL	Stock	51.37	51.5425	51.3125	51.425	365180.0
2019-05-06 08:00:00	AAPL	Stock	51.375	51.573	51.2025	51.5075	699632.0
2019-05-06 08:30:00	AAPL	Stock	51.5075	51.525	51.4125	51.425	493212.0
2019-05-06 09:00:00	AAPL	Stock	51.435	51.45	51.0325	51.065	1024656.0
2019-05-06 09:30:00	AAPL	Stock	51.0725	52.02	50.875	51.9578	30112952.0
2019-05-06 10:00:00	AAPL	Stock	51.9525	52.1775	51.825	51.8962	11027752.0
2019-05-06 10:30:00	AAPL	Stock	51.895	51.9775	51.735	51.88	9131704.0
2019-05-06 11:00:00	AAPL	Stock	51.885	52.0625	51.7	52.053	7550136.0
2019-05-06 11:30:00	AAPL	Stock	52.056	52.0875	51.9	51.925	5169464.0
2019-05-06 12:00:00	AAPL	Stock	51.9275	51.9738	51.7112	51.7325	4936580.0
2019-05-06 12:30:00	AAPL	Stock	51.7325	51.81	51.65	51.695	5153832.0
2019-05-06 13:00:00	AAPL	Stock	51.695	51.8575	51.6325	51.8538	3775740.0
2019-05-06 13:30:00	AAPL	Stock	51.86	51.945	51.83	51.9075	2519096.0
2019-05-06 14:00:00	AAPL	Stock	51.905	51.9875	51.8425	51.9675	3793956.0
2019-05-06 14:30:00	AAPL	Stock	51.965	52.195	51.9622	52.18	5898200.0
2019-05-06 15:00:00	AAPL	Stock	52.18	52.21	52.0425	52.1352	5232536.0
2019-05-06 15:30:00	AAPL	Stock	52.14	52.1875	52.08	52.15	7257024.0
2019-05-06 16:00:00	AAPL	Stock	52.12	52.145	52.07	52.12	9232300.0
2019-05-06 16:30:00	AAPL	Stock	52.12	52.145	51.72	51.72	97972.0
2019-05-06 17:00:00	AAPL	Stock	51.7475	51.942	51.5875	51.68	302796.0
2019-05-06 17:30:00	AAPL	Stock	51.675	51.76	51.6725	51.6875	73332.0
2019-05-06 18:00:00	AAPL	Stock	51.675	51.825	51.665	51.725	70012.0
2019-05-06 18:30:00	AAPL	Stock	51.7725	51.78	51.735	51.775	53544.0
2019-05-06 19:00:00	AAPL	Stock	51.7775	51.92	51.77	51.8675	87376.0
2019-05-06 19:30:00	AAPL	Stock	51.8525	51.8875	51.8125	51.8375	46052.0
2019-05-06 04:00:00	MSFT	Stock	126.7	126.7	126.01	126.5	18880.0
2019-05-06 04:30:00	MSFT	Stock	126.52	126.53	125.63	126.12	10417.0
2019-05-06 05:00:00	MSFT	Stock	126.05	126.05	125.71	125.85	7053.0
2019-05-06 05:30:00	MSFT	Stock	125.85	126.32	125.8	126.3	3107.0
2019-05-06 06:00:00	MSFT	Stock	126.36	126.48	126.24	126.48	1322.0
2019-05-06 06:30:00	MSFT	Stock	126.45	126.59	126.35	126.5	8114.0
2019-05-06 07:00:00	MSFT	Stock	126.56	126.79	126.48	126.79	22510.0
2019-05-06 07:30:00	MSFT	Stock	126.74	126.97	126.71	126.71	13642.0
2019-05-06 08:00:00	MSFT	Stock	126.76	127.05	126.45	127.05	61643.0
2019-05-06 08:30:00	MSFT	Stock	127.0	127.1	126.71	126.95	27048.0
2019-05-06 09:00:00	MSFT	Stock	126.91	126.91	126.26	126.37	37389.0
2019-05-06 09:30:00	MSFT	Stock	126.42	127.69	126.11	127.43	3211135.0
2019-05-06 10:00:00	MSFT	Stock	127.42	127.68	126.95	127.62	1906551.0
2019-05-06 10:30:00	MSFT	Stock	127.625	128.07	127.5	127.99	1279399.0
2019-05-06 11:00:00	MSFT	Stock	127.987	128.1	127.8	127.93	1036769.0
2019-05-06 11:30:00	MSFT	Stock	127.95	128.0	127.67	127.71	1067930.0
2019-05-06 12:00:00	MSFT	Stock	127.71	127.797	127.38	127.415	850325.0
2019-05-06 12:30:00	MSFT	Stock	127.415	127.75	127.37	127.45	776232.0

> showing 50 of 86,476 rows — these rows as CSV

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