PREVIEW / stock_30min / 2019-10-04

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-10-04.parquet
  size:    1.7 MB
  rows:    82,147
  symbols: 2,519

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-04 04:00:00	AAPL	Stock	55.675	56.015	55.675	56.0025	80288.0
2019-10-04 04:30:00	AAPL	Stock	56.0	56.1175	55.9725	56.0625	35408.0
2019-10-04 05:00:00	AAPL	Stock	56.0075	56.1	56.0	56.0025	48884.0
2019-10-04 05:30:00	AAPL	Stock	56.0	56.1	55.75	55.88	79892.0
2019-10-04 06:00:00	AAPL	Stock	55.8875	56.025	55.875	55.875	38536.0
2019-10-04 06:30:00	AAPL	Stock	55.9375	55.99	55.875	55.9375	23144.0
2019-10-04 07:00:00	AAPL	Stock	55.88	56.0375	55.805	56.0	424588.0
2019-10-04 07:30:00	AAPL	Stock	55.99	56.1075	55.97	56.085	289528.0
2019-10-04 08:00:00	AAPL	Stock	56.08	56.1025	55.85	56.0775	708480.0
2019-10-04 08:30:00	AAPL	Stock	56.09	56.5375	56.0775	56.5	1427208.0
2019-10-04 09:00:00	AAPL	Stock	56.485	56.59	56.375	56.405	770980.0
2019-10-04 09:30:00	AAPL	Stock	56.4275	56.4725	55.9725	56.2075	21150236.0
2019-10-04 10:00:00	AAPL	Stock	56.225	56.35	56.0625	56.13	9693008.0
2019-10-04 10:30:00	AAPL	Stock	56.13	56.3275	56.105	56.285	5845708.0
2019-10-04 11:00:00	AAPL	Stock	56.285	56.485	56.23	56.4375	8230488.0
2019-10-04 11:30:00	AAPL	Stock	56.435	56.5475	56.3925	56.51	7678736.0
2019-10-04 12:00:00	AAPL	Stock	56.5075	56.53	56.425	56.4325	4599756.0
2019-10-04 12:30:00	AAPL	Stock	56.43	56.5125	56.365	56.4875	3707700.0
2019-10-04 13:00:00	AAPL	Stock	56.4875	56.575	56.4375	56.55	4314544.0
2019-10-04 13:30:00	AAPL	Stock	56.552	56.615	56.5125	56.5788	3571672.0
2019-10-04 14:00:00	AAPL	Stock	56.58	56.7925	56.5625	56.7075	7678540.0
2019-10-04 14:30:00	AAPL	Stock	56.705	56.8725	56.6925	56.7242	6635016.0
2019-10-04 15:00:00	AAPL	Stock	56.7275	56.735	56.535	56.545	7286136.0
2019-10-04 15:30:00	AAPL	Stock	56.545	56.7875	56.53	56.7525	14566308.0
2019-10-04 16:00:00	AAPL	Stock	56.7525	56.79	56.6675	56.7575	8529804.0
2019-10-04 16:30:00	AAPL	Stock	56.7825	56.865	56.7525	56.7625	321848.0
2019-10-04 17:00:00	AAPL	Stock	56.77	56.8	56.7525	56.7525	43972.0
2019-10-04 17:30:00	AAPL	Stock	56.755	56.775	56.7525	56.77	30736.0
2019-10-04 18:00:00	AAPL	Stock	56.7625	56.7725	56.7525	56.7525	22372.0
2019-10-04 18:30:00	AAPL	Stock	56.7525	56.7725	56.7525	56.7625	9876.0
2019-10-04 19:00:00	AAPL	Stock	56.765	56.7725	56.68	56.7025	77776.0
2019-10-04 19:30:00	AAPL	Stock	56.725	56.77	56.715	56.7375	18336.0
2019-10-04 04:00:00	MSFT	Stock	136.43	136.43	136.43	136.43	478.0
2019-10-04 04:30:00	MSFT	Stock	136.28	136.28	135.63	135.63	1678.0
2019-10-04 05:00:00	MSFT	Stock	135.93	135.93	135.9	135.9	200.0
2019-10-04 05:30:00	MSFT	Stock	135.99	135.99	135.41	135.75	3051.0
2019-10-04 06:30:00	MSFT	Stock	135.75	135.75	135.72	135.72	307.0
2019-10-04 07:00:00	MSFT	Stock	135.84	135.9	135.8	135.87	1854.0
2019-10-04 07:30:00	MSFT	Stock	135.9	135.95	135.78	135.82	6944.0
2019-10-04 08:00:00	MSFT	Stock	135.76	135.9	135.6	135.6	11165.0
2019-10-04 08:30:00	MSFT	Stock	135.87	136.855	135.54	136.57	51358.0
2019-10-04 09:00:00	MSFT	Stock	136.61	136.77	136.464	136.76	14514.0
2019-10-04 09:30:00	MSFT	Stock	136.76	137.75	136.42	137.67	2527114.0
2019-10-04 10:00:00	MSFT	Stock	137.68	137.89	137.255	137.34	1201788.0
2019-10-04 10:30:00	MSFT	Stock	137.339	137.4	136.88	137.045	1108522.0
2019-10-04 11:00:00	MSFT	Stock	137.05	137.33	136.72	137.03	1284019.0
2019-10-04 11:30:00	MSFT	Stock	137.0	137.87	137.0	137.67	1160399.0
2019-10-04 12:00:00	MSFT	Stock	137.66	137.77	137.41	137.46	1002250.0
2019-10-04 12:30:00	MSFT	Stock	137.475	137.58	137.2	137.491	936367.0
2019-10-04 13:00:00	MSFT	Stock	137.5	137.62	137.23	137.59	480961.0

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

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