PREVIEW / stock_30min / 2020-02-14

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-02-14.parquet
  size:    1.8 MB
  rows:    84,990
  symbols: 2,409

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
2020-02-14 04:00:00	AAPL	Stock	81.3575	81.4875	81.3575	81.4875	9816.0
2020-02-14 04:30:00	AAPL	Stock	81.4875	81.5625	81.47	81.5325	12600.0
2020-02-14 05:00:00	AAPL	Stock	81.55	81.55	81.5225	81.5375	8204.0
2020-02-14 05:30:00	AAPL	Stock	81.5925	81.625	81.59	81.625	1988.0
2020-02-14 06:00:00	AAPL	Stock	81.5025	81.5025	81.4675	81.4675	864.0
2020-02-14 06:30:00	AAPL	Stock	81.5	81.5025	81.475	81.5	4764.0
2020-02-14 07:00:00	AAPL	Stock	81.52	81.6	81.485	81.575	82076.0
2020-02-14 07:30:00	AAPL	Stock	81.55	81.5625	81.54	81.5475	18788.0
2020-02-14 08:00:00	AAPL	Stock	81.55	81.6	81.45	81.475	192468.0
2020-02-14 08:30:00	AAPL	Stock	81.475	81.475	81.2375	81.32	266064.0
2020-02-14 09:00:00	AAPL	Stock	81.3	81.35	81.085	81.14	191412.0
2020-02-14 09:30:00	AAPL	Stock	81.1775	81.495	80.8775	80.9875	9360280.0
2020-02-14 10:00:00	AAPL	Stock	80.9825	81.24	80.7125	81.232	7595836.0
2020-02-14 10:30:00	AAPL	Stock	81.235	81.485	81.1575	81.4325	5820444.0
2020-02-14 11:00:00	AAPL	Stock	81.435	81.47	81.24	81.275	3567972.0
2020-02-14 11:30:00	AAPL	Stock	81.27	81.3075	81.13	81.2482	3443568.0
2020-02-14 12:00:00	AAPL	Stock	81.2425	81.2825	81.045	81.13	2670088.0
2020-02-14 12:30:00	AAPL	Stock	81.1292	81.175	81.0028	81.05	2078976.0
2020-02-14 13:00:00	AAPL	Stock	81.05	81.2725	80.99	81.06	4101096.0
2020-02-14 13:30:00	AAPL	Stock	81.0575	81.2075	80.9875	81.0212	2264944.0
2020-02-14 14:00:00	AAPL	Stock	81.0202	81.1175	80.835	81.0325	3477548.0
2020-02-14 14:30:00	AAPL	Stock	81.03	81.1555	80.9625	81.1175	2912908.0
2020-02-14 15:00:00	AAPL	Stock	81.115	81.1325	80.915	80.9375	3030880.0
2020-02-14 15:30:00	AAPL	Stock	80.93	81.25	80.9032	81.235	7580680.0
2020-02-14 16:00:00	AAPL	Stock	81.235	81.25	81.1875	81.225	8963792.0
2020-02-14 16:30:00	AAPL	Stock	81.2075	81.2725	81.1875	81.255	97724.0
2020-02-14 17:00:00	AAPL	Stock	81.2525	81.253	81.215	81.2475	35604.0
2020-02-14 17:30:00	AAPL	Stock	81.2475	81.25	81.215	81.2275	15572.0
2020-02-14 18:00:00	AAPL	Stock	81.25	81.25	81.225	81.225	31852.0
2020-02-14 18:30:00	AAPL	Stock	81.23	81.2625	81.23	81.26	15008.0
2020-02-14 19:00:00	AAPL	Stock	81.23	81.25	81.225	81.25	19268.0
2020-02-14 19:30:00	AAPL	Stock	81.2425	81.2625	81.2375	81.2625	14172.0
2020-02-14 04:00:00	MSFT	Stock	184.26	184.26	184.26	184.26	100.0
2020-02-14 05:00:00	MSFT	Stock	184.22	184.35	184.22	184.35	3697.0
2020-02-14 05:30:00	MSFT	Stock	184.43	184.43	184.42	184.42	739.0
2020-02-14 06:00:00	MSFT	Stock	184.4	184.42	184.26	184.42	561.0
2020-02-14 06:30:00	MSFT	Stock	184.31	184.43	184.31	184.38	2796.0
2020-02-14 07:00:00	MSFT	Stock	184.27	184.38	184.15	184.2	12021.0
2020-02-14 07:30:00	MSFT	Stock	184.24	184.36	184.12	184.36	7074.0
2020-02-14 08:00:00	MSFT	Stock	184.2	184.38	184.1	184.26	29927.0
2020-02-14 08:30:00	MSFT	Stock	184.22	184.22	183.56	183.78	43541.0
2020-02-14 09:00:00	MSFT	Stock	183.73	183.85	183.2	183.25	37808.0
2020-02-14 09:30:00	MSFT	Stock	183.19	183.93	182.65	182.96	3214364.0
2020-02-14 10:00:00	MSFT	Stock	182.97	184.2	182.865	184.07	1642575.0
2020-02-14 10:30:00	MSFT	Stock	184.09	185.24	183.96	185.1	1846304.0
2020-02-14 11:00:00	MSFT	Stock	185.12	185.12	184.5	184.78	913814.0
2020-02-14 11:30:00	MSFT	Stock	184.77	184.92	184.41	184.426	698677.0
2020-02-14 12:00:00	MSFT	Stock	184.42	184.63	184.05	184.055	934961.0
2020-02-14 12:30:00	MSFT	Stock	184.06	184.35	183.9	184.123	866827.0
2020-02-14 13:00:00	MSFT	Stock	184.121	184.47	184.05	184.22	769425.0

> showing 50 of 84,990 rows — these rows as CSV

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