PREVIEW / stock_30min / 2019-01-22

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-01-22.parquet
  size:    1.7 MB
  rows:    84,668
  symbols: 2,690

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-01-22 04:00:00	AAPL	Stock	39.05	39.05	38.875	38.9	21148.0
2019-01-22 04:30:00	AAPL	Stock	38.885	38.95	38.885	38.95	5200.0
2019-01-22 05:00:00	AAPL	Stock	38.9175	38.9175	38.85	38.89	8704.0
2019-01-22 05:30:00	AAPL	Stock	38.8725	38.8725	38.8275	38.8475	8500.0
2019-01-22 06:00:00	AAPL	Stock	38.8475	38.85	38.7875	38.8025	12496.0
2019-01-22 06:30:00	AAPL	Stock	38.8025	38.8575	38.8025	38.8575	3764.0
2019-01-22 07:00:00	AAPL	Stock	38.8375	38.9475	38.8375	38.925	32092.0
2019-01-22 07:30:00	AAPL	Stock	38.925	38.9425	38.875	38.875	59632.0
2019-01-22 08:00:00	AAPL	Stock	38.8775	38.9925	38.8375	38.965	198560.0
2019-01-22 08:30:00	AAPL	Stock	38.965	39.205	38.9525	38.97	469940.0
2019-01-22 09:00:00	AAPL	Stock	38.98	39.205	38.9625	39.135	399308.0
2019-01-22 09:30:00	AAPL	Stock	39.1025	39.1825	38.8075	38.8525	11769648.0
2019-01-22 10:00:00	AAPL	Stock	38.8538	38.8875	38.695	38.7925	7410172.0
2019-01-22 10:30:00	AAPL	Stock	38.796	38.8725	38.7525	38.7975	5179804.0
2019-01-22 11:00:00	AAPL	Stock	38.7925	38.92	38.7375	38.7975	4576268.0
2019-01-22 11:30:00	AAPL	Stock	38.7975	38.8495	38.6125	38.645	5763188.0
2019-01-22 12:00:00	AAPL	Stock	38.645	38.7925	38.6075	38.7238	4678332.0
2019-01-22 12:30:00	AAPL	Stock	38.7225	38.8325	38.675	38.6882	3584508.0
2019-01-22 13:00:00	AAPL	Stock	38.6875	38.6875	38.485	38.5728	6070808.0
2019-01-22 13:30:00	AAPL	Stock	38.5725	38.68	38.5425	38.5808	3981360.0
2019-01-22 14:00:00	AAPL	Stock	38.5775	38.6025	38.395	38.418	5579380.0
2019-01-22 14:30:00	AAPL	Stock	38.4175	38.51	38.2188	38.2985	7906528.0
2019-01-22 15:00:00	AAPL	Stock	38.2975	38.37	38.17	38.3442	6572848.0
2019-01-22 15:30:00	AAPL	Stock	38.345	38.505	38.155	38.4225	16333312.0
2019-01-22 16:00:00	AAPL	Stock	38.4225	38.4225	38.2875	38.3875	15010608.0
2019-01-22 16:30:00	AAPL	Stock	38.39	38.4025	38.3	38.3	59768.0
2019-01-22 17:00:00	AAPL	Stock	38.3225	38.36	38.3225	38.36	11912.0
2019-01-22 17:30:00	AAPL	Stock	38.3575	38.36	38.345	38.36	9764.0
2019-01-22 18:00:00	AAPL	Stock	38.3325	38.3325	38.2875	38.2875	13668.0
2019-01-22 18:30:00	AAPL	Stock	38.2675	38.3275	38.265	38.325	18204.0
2019-01-22 19:00:00	AAPL	Stock	38.325	38.3375	38.325	38.3375	8008.0
2019-01-22 19:30:00	AAPL	Stock	38.3325	38.375	38.3275	38.3725	23704.0
2019-01-22 04:00:00	MSFT	Stock	107.48	107.48	106.86	106.86	2077.0
2019-01-22 04:30:00	MSFT	Stock	106.9	107.0	106.9	107.0	1200.0
2019-01-22 05:00:00	MSFT	Stock	107.0	107.0	106.75	106.76	825.0
2019-01-22 05:30:00	MSFT	Stock	106.85	106.85	106.61	106.78	2379.0
2019-01-22 06:00:00	MSFT	Stock	106.65	106.65	106.61	106.61	200.0
2019-01-22 07:00:00	MSFT	Stock	106.82	106.85	106.7	106.85	1839.0
2019-01-22 07:30:00	MSFT	Stock	106.92	107.15	106.91	106.92	5550.0
2019-01-22 08:00:00	MSFT	Stock	106.9	107.07	106.63	106.63	14360.0
2019-01-22 08:30:00	MSFT	Stock	106.64	106.9	106.63	106.79	16984.0
2019-01-22 09:00:00	MSFT	Stock	106.81	107.04	106.7	106.98	11273.0
2019-01-22 09:30:00	MSFT	Stock	106.91	107.1	106.44	106.95	2758666.0
2019-01-22 10:00:00	MSFT	Stock	106.945	107.03	106.55	106.78	2038410.0
2019-01-22 10:30:00	MSFT	Stock	106.77	107.05	106.58	106.78	1465695.0
2019-01-22 11:00:00	MSFT	Stock	106.76	106.79	106.53	106.58	953003.0
2019-01-22 11:30:00	MSFT	Stock	106.57	106.69	106.11	106.15	1163580.0
2019-01-22 12:00:00	MSFT	Stock	106.13	106.37	105.89	106.025	1614427.0
2019-01-22 12:30:00	MSFT	Stock	106.02	106.24	105.99	106.065	839801.0
2019-01-22 13:00:00	MSFT	Stock	106.07	106.075	105.47	105.79	1773424.0

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

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