PREVIEW / stock_30min / 2019-10-07

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-10-07.parquet
  size:    1.7 MB
  rows:    82,236
  symbols: 2,532

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-10-07 04:00:00	AAPL	Stock	56.62	56.62	56.4375	56.4375	13440.0
2019-10-07 04:30:00	AAPL	Stock	56.45	56.4625	56.4375	56.455	19632.0
2019-10-07 05:00:00	AAPL	Stock	56.4725	56.4725	56.425	56.425	2400.0
2019-10-07 05:30:00	AAPL	Stock	56.45	56.5	56.45	56.5	12204.0
2019-10-07 06:00:00	AAPL	Stock	56.525	56.5875	56.4625	56.5875	12920.0
2019-10-07 06:30:00	AAPL	Stock	56.6	56.75	56.6	56.75	45888.0
2019-10-07 07:00:00	AAPL	Stock	56.75	56.785	56.6275	56.6725	70432.0
2019-10-07 07:30:00	AAPL	Stock	56.6725	56.71	56.6325	56.66	59272.0
2019-10-07 08:00:00	AAPL	Stock	56.7625	56.78	56.6125	56.6725	143632.0
2019-10-07 08:30:00	AAPL	Stock	56.6725	56.6725	56.59	56.5925	72912.0
2019-10-07 09:00:00	AAPL	Stock	56.62	56.6625	56.558	56.5675	155524.0
2019-10-07 09:30:00	AAPL	Stock	56.5675	56.98	56.46	56.7625	13977328.0
2019-10-07 10:00:00	AAPL	Stock	56.77	57.0925	56.7325	57.0	9296912.0
2019-10-07 10:30:00	AAPL	Stock	56.9982	57.204	56.9125	57.19	7698120.0
2019-10-07 11:00:00	AAPL	Stock	57.19	57.25	57.1425	57.215	6401800.0
2019-10-07 11:30:00	AAPL	Stock	57.21	57.355	57.1928	57.3525	6997164.0
2019-10-07 12:00:00	AAPL	Stock	57.354	57.355	57.2	57.2428	4888236.0
2019-10-07 12:30:00	AAPL	Stock	57.2425	57.3675	57.2075	57.3488	4127924.0
2019-10-07 13:00:00	AAPL	Stock	57.3475	57.3925	57.1555	57.1825	5662820.0
2019-10-07 13:30:00	AAPL	Stock	57.18	57.4825	57.16	57.4702	7919608.0
2019-10-07 14:00:00	AAPL	Stock	57.4725	57.479	57.1	57.1695	7632180.0
2019-10-07 14:30:00	AAPL	Stock	57.17	57.17	56.6475	56.8565	9418576.0
2019-10-07 15:00:00	AAPL	Stock	56.86	56.9975	56.8	56.9575	5143540.0
2019-10-07 15:30:00	AAPL	Stock	56.96	56.9755	56.6525	56.765	8056188.0
2019-10-07 16:00:00	AAPL	Stock	56.765	56.82	56.745	56.8	6667504.0
2019-10-07 16:30:00	AAPL	Stock	56.775	56.805	56.765	56.8	36156.0
2019-10-07 17:00:00	AAPL	Stock	56.805	56.8125	56.8	56.8	19632.0
2019-10-07 17:30:00	AAPL	Stock	56.8025	56.8125	56.775	56.7875	15912.0
2019-10-07 18:00:00	AAPL	Stock	56.7875	56.8	56.6875	56.8	31820.0
2019-10-07 18:30:00	AAPL	Stock	56.8	56.815	56.7875	56.7875	9816.0
2019-10-07 19:00:00	AAPL	Stock	56.815	56.85	56.815	56.85	14012.0
2019-10-07 19:30:00	AAPL	Stock	56.855	56.875	56.8125	56.86	28316.0
2019-10-07 04:00:00	MSFT	Stock	137.88	137.88	137.59	137.59	1684.0
2019-10-07 05:30:00	MSFT	Stock	137.5	137.5	137.5	137.5	407.0
2019-10-07 06:30:00	MSFT	Stock	137.86	138.01	137.86	138.01	500.0
2019-10-07 07:00:00	MSFT	Stock	138.08	138.08	137.89	137.99	3459.0
2019-10-07 07:30:00	MSFT	Stock	138.0	138.0	137.9	137.95	3241.0
2019-10-07 08:00:00	MSFT	Stock	137.99	138.07	137.8	137.98	9098.0
2019-10-07 08:30:00	MSFT	Stock	137.81	137.98	137.81	137.85	7012.0
2019-10-07 09:00:00	MSFT	Stock	137.97	137.97	137.25	137.25	21047.0
2019-10-07 09:30:00	MSFT	Stock	137.22	137.8	137.03	137.2	1434278.0
2019-10-07 10:00:00	MSFT	Stock	137.21	137.51	137.05	137.352	817643.0
2019-10-07 10:30:00	MSFT	Stock	137.37	137.61	137.24	137.525	656087.0
2019-10-07 11:00:00	MSFT	Stock	137.53	137.928	137.51	137.66	743896.0
2019-10-07 11:30:00	MSFT	Stock	137.65	138.03	137.625	138.017	681231.0
2019-10-07 12:00:00	MSFT	Stock	138.01	138.024	137.6	137.605	575150.0
2019-10-07 12:30:00	MSFT	Stock	137.6	137.805	137.47	137.56	459968.0
2019-10-07 13:00:00	MSFT	Stock	137.56	137.745	137.31	137.55	487225.0
2019-10-07 13:30:00	MSFT	Stock	137.54	138.18	137.52	137.94	1028746.0
2019-10-07 14:00:00	MSFT	Stock	137.94	137.985	137.42	137.645	605375.0

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

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