PREVIEW / stock_30min / 2019-05-02

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-05-02.parquet
  size:    1.7 MB
  rows:    82,721
  symbols: 2,617

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-02 04:00:00	AAPL	Stock	52.6625	52.6625	52.525	52.525	45732.0
2019-05-02 04:30:00	AAPL	Stock	52.5325	52.585	52.515	52.585	53440.0
2019-05-02 05:00:00	AAPL	Stock	52.58	52.7175	52.575	52.6875	38412.0
2019-05-02 05:30:00	AAPL	Stock	52.7075	52.7425	52.6875	52.7425	31236.0
2019-05-02 06:00:00	AAPL	Stock	52.74	52.75	52.6525	52.6525	15720.0
2019-05-02 06:30:00	AAPL	Stock	52.7	52.73	52.6975	52.725	30440.0
2019-05-02 07:00:00	AAPL	Stock	52.6775	52.7325	52.5825	52.675	77292.0
2019-05-02 07:30:00	AAPL	Stock	52.6725	52.735	52.625	52.655	110856.0
2019-05-02 08:00:00	AAPL	Stock	52.6275	52.735	52.625	52.6625	336396.0
2019-05-02 08:30:00	AAPL	Stock	52.675	52.73	52.575	52.61	223480.0
2019-05-02 09:00:00	AAPL	Stock	52.6125	52.625	52.415	52.4575	512824.0
2019-05-02 09:30:00	AAPL	Stock	52.4875	53.1375	52.375	53.115	21723956.0
2019-05-02 10:00:00	AAPL	Stock	53.1132	53.1625	52.815	52.85	11532688.0
2019-05-02 10:30:00	AAPL	Stock	52.85	53.0225	52.74	52.7775	7131268.0
2019-05-02 11:00:00	AAPL	Stock	52.78	52.88	52.4425	52.4525	8359236.0
2019-05-02 11:30:00	AAPL	Stock	52.4525	52.6225	52.0325	52.1575	11097988.0
2019-05-02 12:00:00	AAPL	Stock	52.1625	52.345	52.1125	52.2875	5744104.0
2019-05-02 12:30:00	AAPL	Stock	52.29	52.4225	52.15	52.18	4601356.0
2019-05-02 13:00:00	AAPL	Stock	52.1775	52.49	52.1025	52.4038	4637308.0
2019-05-02 13:30:00	AAPL	Stock	52.4075	52.5725	52.3725	52.4025	4589500.0
2019-05-02 14:00:00	AAPL	Stock	52.41	52.555	52.37	52.4	3523724.0
2019-05-02 14:30:00	AAPL	Stock	52.4025	52.44	52.2425	52.35	3870800.0
2019-05-02 15:00:00	AAPL	Stock	52.345	52.475	52.2575	52.43	4052560.0
2019-05-02 15:30:00	AAPL	Stock	52.425	52.425	52.1675	52.2925	9347604.0
2019-05-02 16:00:00	AAPL	Stock	52.2875	52.33	52.24	52.25	4238760.0
2019-05-02 16:30:00	AAPL	Stock	52.2575	52.2975	52.2525	52.2875	23620.0
2019-05-02 17:00:00	AAPL	Stock	52.2975	52.3125	52.2875	52.2875	44588.0
2019-05-02 17:30:00	AAPL	Stock	52.2875	52.295	52.2875	52.29	17776.0
2019-05-02 18:00:00	AAPL	Stock	52.3	52.3125	52.3	52.3125	3296.0
2019-05-02 18:30:00	AAPL	Stock	52.3125	52.3125	52.29	52.29	16376.0
2019-05-02 19:00:00	AAPL	Stock	52.3	52.3125	52.285	52.2875	24168.0
2019-05-02 19:30:00	AAPL	Stock	52.3	52.325	52.25	52.275	45504.0
2019-05-02 04:00:00	MSFT	Stock	128.14	128.14	128.09	128.09	663.0
2019-05-02 04:30:00	MSFT	Stock	128.25	128.25	128.22	128.22	2835.0
2019-05-02 05:00:00	MSFT	Stock	128.23	128.58	128.23	128.57	2778.0
2019-05-02 05:30:00	MSFT	Stock	128.47	128.51	128.33	128.47	4761.0
2019-05-02 06:00:00	MSFT	Stock	128.45	128.45	128.34	128.34	3000.0
2019-05-02 07:00:00	MSFT	Stock	128.35	128.35	128.0	128.07	7738.0
2019-05-02 07:30:00	MSFT	Stock	128.06	128.26	128.06	128.1	3042.0
2019-05-02 08:00:00	MSFT	Stock	128.25	128.39	128.0	128.1	11743.0
2019-05-02 08:30:00	MSFT	Stock	128.2	128.2	127.88	127.98	7364.0
2019-05-02 09:00:00	MSFT	Stock	128.0	128.1	127.8	127.97	17665.0
2019-05-02 09:30:00	MSFT	Stock	127.98	128.0	127.01	127.05	2769927.0
2019-05-02 10:00:00	MSFT	Stock	127.06	127.98	127.044	127.47	1663759.0
2019-05-02 10:30:00	MSFT	Stock	127.475	127.74	127.275	127.285	1018458.0
2019-05-02 11:00:00	MSFT	Stock	127.29	127.45	126.59	126.68	1630771.0
2019-05-02 11:30:00	MSFT	Stock	126.69	127.04	125.56	125.77	2349873.0
2019-05-02 12:00:00	MSFT	Stock	125.779	126.34	125.74	126.27	1720355.0
2019-05-02 12:30:00	MSFT	Stock	126.28	126.46	125.66	125.77	1232222.0
2019-05-02 13:00:00	MSFT	Stock	125.77	126.35	125.52	126.28	1545433.0

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

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