PREVIEW / stock_30min / 2019-07-02

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-07-02.parquet
  size:    1.7 MB
  rows:    83,684
  symbols: 2,610

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-07-02 04:00:00	AAPL	Stock	50.3075	50.3075	50.3075	50.3075	2356.0
2019-07-02 04:30:00	AAPL	Stock	50.2725	50.3	50.205	50.205	3208.0
2019-07-02 05:00:00	AAPL	Stock	50.25	50.25	50.25	50.25	3632.0
2019-07-02 05:30:00	AAPL	Stock	50.25	50.25	50.2175	50.2175	10384.0
2019-07-02 06:00:00	AAPL	Stock	50.19	50.19	50.125	50.125	2200.0
2019-07-02 06:30:00	AAPL	Stock	50.1825	50.2	50.1825	50.2	2000.0
2019-07-02 07:00:00	AAPL	Stock	50.245	50.3	50.2025	50.2025	54680.0
2019-07-02 07:30:00	AAPL	Stock	50.2025	50.25	50.2025	50.25	16344.0
2019-07-02 08:00:00	AAPL	Stock	50.25	50.31	50.2	50.2675	51432.0
2019-07-02 08:30:00	AAPL	Stock	50.2875	50.2975	50.25	50.275	33116.0
2019-07-02 09:00:00	AAPL	Stock	50.275	50.3525	50.275	50.325	97456.0
2019-07-02 09:30:00	AAPL	Stock	50.3675	50.665	50.34	50.6125	9976020.0
2019-07-02 10:00:00	AAPL	Stock	50.6175	50.735	50.53	50.7088	6053180.0
2019-07-02 10:30:00	AAPL	Stock	50.7092	50.783	50.635	50.7125	4462460.0
2019-07-02 11:00:00	AAPL	Stock	50.7088	50.74	50.64	50.6475	2356716.0
2019-07-02 11:30:00	AAPL	Stock	50.6488	50.6512	50.4825	50.5775	4003524.0
2019-07-02 12:00:00	AAPL	Stock	50.5785	50.65	50.4925	50.5065	3965580.0
2019-07-02 12:30:00	AAPL	Stock	50.5075	50.5375	50.4225	50.505	3054644.0
2019-07-02 13:00:00	AAPL	Stock	50.505	50.55	50.4425	50.475	2802328.0
2019-07-02 13:30:00	AAPL	Stock	50.4725	50.5395	50.4525	50.5125	2314904.0
2019-07-02 14:00:00	AAPL	Stock	50.5125	50.5625	50.4815	50.515	2733532.0
2019-07-02 14:30:00	AAPL	Stock	50.52	50.5625	50.5075	50.5475	2475088.0
2019-07-02 15:00:00	AAPL	Stock	50.5475	50.65	50.545	50.6175	3950496.0
2019-07-02 15:30:00	AAPL	Stock	50.6175	50.695	50.5625	50.6775	6508384.0
2019-07-02 16:00:00	AAPL	Stock	50.6825	50.9925	50.63	50.7275	2969452.0
2019-07-02 16:30:00	AAPL	Stock	50.7325	50.7425	50.6825	50.6825	34868.0
2019-07-02 17:00:00	AAPL	Stock	50.725	50.73	50.71	50.7225	43628.0
2019-07-02 17:30:00	AAPL	Stock	50.7225	50.7425	50.6825	50.7425	38828.0
2019-07-02 18:00:00	AAPL	Stock	50.7425	50.7425	50.7125	50.725	16492.0
2019-07-02 18:30:00	AAPL	Stock	50.7225	50.725	50.7125	50.725	5988.0
2019-07-02 19:00:00	AAPL	Stock	50.7175	50.725	50.7	50.705	20428.0
2019-07-02 19:30:00	AAPL	Stock	50.7175	50.7375	50.6825	50.7375	25968.0
2019-07-02 04:00:00	MSFT	Stock	135.75	135.75	135.45	135.45	1056.0
2019-07-02 04:30:00	MSFT	Stock	135.27	135.42	135.27	135.34	680.0
2019-07-02 05:00:00	MSFT	Stock	135.43	135.43	135.43	135.43	408.0
2019-07-02 07:00:00	MSFT	Stock	135.58	135.59	135.46	135.55	1186.0
2019-07-02 07:30:00	MSFT	Stock	135.5	135.61	135.5	135.61	765.0
2019-07-02 08:00:00	MSFT	Stock	135.5	135.85	135.41	135.78	6119.0
2019-07-02 08:30:00	MSFT	Stock	135.68	135.74	135.54	135.6	3631.0
2019-07-02 09:00:00	MSFT	Stock	135.68	136.02	135.6	136.02	5063.0
2019-07-02 09:30:00	MSFT	Stock	136.03	136.12	135.34	135.75	1616639.0
2019-07-02 10:00:00	MSFT	Stock	135.75	135.95	135.65	135.92	893560.0
2019-07-02 10:30:00	MSFT	Stock	135.915	136.16	135.88	136.06	928645.0
2019-07-02 11:00:00	MSFT	Stock	136.07	136.13	135.965	136.07	629212.0
2019-07-02 11:30:00	MSFT	Stock	136.07	136.14	135.8	135.96	797895.0
2019-07-02 12:00:00	MSFT	Stock	135.94	136.07	135.77	135.83	569683.0
2019-07-02 12:30:00	MSFT	Stock	135.84	135.955	135.62	135.9	587988.0
2019-07-02 13:00:00	MSFT	Stock	135.905	136.1	135.8	136.09	454164.0
2019-07-02 13:30:00	MSFT	Stock	136.095	136.17	135.97	136.095	448764.0
2019-07-02 14:00:00	MSFT	Stock	136.093	136.17	136.01	136.06	441410.0

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

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