PREVIEW / stock_30min / 2019-02-21

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-02-21.parquet
  size:    1.7 MB
  rows:    82,830
  symbols: 2,653

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-02-21 04:00:00	AAPL	Stock	43.0	43.0075	42.9625	42.9875	3200.0
2019-02-21 04:30:00	AAPL	Stock	42.9275	42.9275	42.91	42.91	3640.0
2019-02-21 05:30:00	AAPL	Stock	42.9825	42.9825	42.9825	42.9825	1600.0
2019-02-21 06:00:00	AAPL	Stock	43.1	43.1	43.0825	43.0825	3188.0
2019-02-21 07:00:00	AAPL	Stock	43.08	43.08	42.9375	42.975	51644.0
2019-02-21 07:30:00	AAPL	Stock	42.9925	42.995	42.93	42.94	39928.0
2019-02-21 08:00:00	AAPL	Stock	42.94	43.0925	42.9325	43.025	106224.0
2019-02-21 08:30:00	AAPL	Stock	43.0075	43.025	42.9525	43.0175	85876.0
2019-02-21 09:00:00	AAPL	Stock	43.0175	43.0175	42.9325	42.95	43676.0
2019-02-21 09:30:00	AAPL	Stock	42.95	43.0925	42.705	42.8175	11810088.0
2019-02-21 10:00:00	AAPL	Stock	42.815	42.85	42.705	42.755	6330584.0
2019-02-21 10:30:00	AAPL	Stock	42.7525	42.835	42.7175	42.7272	4933328.0
2019-02-21 11:00:00	AAPL	Stock	42.7225	42.8225	42.62	42.71	5059776.0
2019-02-21 11:30:00	AAPL	Stock	42.7125	42.8593	42.695	42.8325	3411008.0
2019-02-21 12:00:00	AAPL	Stock	42.835	42.9175	42.825	42.885	2639396.0
2019-02-21 12:30:00	AAPL	Stock	42.885	42.925	42.835	42.91	2104112.0
2019-02-21 13:00:00	AAPL	Stock	42.9075	42.9175	42.8325	42.8495	2131588.0
2019-02-21 13:30:00	AAPL	Stock	42.85	42.8675	42.82	42.8538	1656684.0
2019-02-21 14:00:00	AAPL	Stock	42.855	42.86	42.665	42.7017	2870976.0
2019-02-21 14:30:00	AAPL	Stock	42.7025	42.7425	42.5875	42.6	3484760.0
2019-02-21 15:00:00	AAPL	Stock	42.6012	42.7175	42.575	42.675	3126124.0
2019-02-21 15:30:00	AAPL	Stock	42.6775	42.785	42.5825	42.785	6236692.0
2019-02-21 16:00:00	AAPL	Stock	42.765	42.765	42.7375	42.765	4707704.0
2019-02-21 16:30:00	AAPL	Stock	42.7625	42.7625	42.75	42.75	9660.0
2019-02-21 17:00:00	AAPL	Stock	42.75	42.76	42.7275	42.7275	20304.0
2019-02-21 17:30:00	AAPL	Stock	42.725	42.755	42.715	42.725	5808.0
2019-02-21 18:00:00	AAPL	Stock	42.7125	42.7125	42.6925	42.6925	8500.0
2019-02-21 18:30:00	AAPL	Stock	42.705	42.7225	42.705	42.7225	1980.0
2019-02-21 19:00:00	AAPL	Stock	42.7375	42.7375	42.735	42.735	2196.0
2019-02-21 19:30:00	AAPL	Stock	42.7475	42.7475	42.7275	42.7475	7412.0
2019-02-21 04:00:00	MSFT	Stock	107.35	107.35	107.25	107.25	1070.0
2019-02-21 04:30:00	MSFT	Stock	107.25	107.25	107.25	107.25	409.0
2019-02-21 05:30:00	MSFT	Stock	107.27	107.5	107.27	107.5	804.0
2019-02-21 06:30:00	MSFT	Stock	107.35	107.35	107.31	107.31	1004.0
2019-02-21 07:00:00	MSFT	Stock	107.31	107.31	107.14	107.25	6388.0
2019-02-21 07:30:00	MSFT	Stock	107.2	107.2	107.15	107.15	1360.0
2019-02-21 08:00:00	MSFT	Stock	107.15	107.25	107.15	107.24	607.0
2019-02-21 08:30:00	MSFT	Stock	107.03	107.2	107.0	107.05	120007.0
2019-02-21 09:00:00	MSFT	Stock	107.05	107.11	106.9	106.9	11637.0
2019-02-21 09:30:00	MSFT	Stock	106.97	107.55	106.87	107.19	2647234.0
2019-02-21 10:00:00	MSFT	Stock	107.19	107.63	107.04	107.52	1680055.0
2019-02-21 10:30:00	MSFT	Stock	107.53	108.57	107.525	108.48	2575829.0
2019-02-21 11:00:00	MSFT	Stock	108.484	109.15	108.435	108.89	2971131.0
2019-02-21 11:30:00	MSFT	Stock	108.885	109.32	108.79	109.14	2073172.0
2019-02-21 12:00:00	MSFT	Stock	109.14	109.284	108.99	109.26	1128228.0
2019-02-21 12:30:00	MSFT	Stock	109.27	109.46	109.24	109.447	1400330.0
2019-02-21 13:00:00	MSFT	Stock	109.45	109.48	109.24	109.33	1011586.0
2019-02-21 13:30:00	MSFT	Stock	109.34	109.41	109.27	109.34	1004251.0
2019-02-21 14:00:00	MSFT	Stock	109.33	109.36	108.91	108.99	1205409.0
2019-02-21 14:30:00	MSFT	Stock	108.995	109.03	108.65	108.852	1340282.0

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

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