PREVIEW / stock_30min / 2020-03-24

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-03-24.parquet
  size:    1.9 MB
  rows:    96,442
  symbols: 2,450

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-03-24 04:00:00	AAPL	Stock	58.255	58.8375	58.0	58.075	120780.0
2020-03-24 04:30:00	AAPL	Stock	58.0625	58.5	57.925	58.3825	29620.0
2020-03-24 05:00:00	AAPL	Stock	58.495	58.6	58.475	58.475	32904.0
2020-03-24 05:30:00	AAPL	Stock	58.5	58.97	58.45	58.97	39016.0
2020-03-24 06:00:00	AAPL	Stock	59.0	59.4725	59.0	59.2225	75796.0
2020-03-24 06:30:00	AAPL	Stock	59.2175	59.5	59.0	59.125	84816.0
2020-03-24 07:00:00	AAPL	Stock	59.125	59.21	58.0	58.4375	566856.0
2020-03-24 07:30:00	AAPL	Stock	58.45	58.62	57.875	58.37	558068.0
2020-03-24 08:00:00	AAPL	Stock	59.045	59.045	57.8075	58.175	849828.0
2020-03-24 08:30:00	AAPL	Stock	58.2125	58.8875	57.975	58.7	725136.0
2020-03-24 09:00:00	AAPL	Stock	58.675	59.36	58.5375	59.1925	1006312.0
2020-03-24 09:30:00	AAPL	Stock	59.1925	59.4675	58.575	59.1315	31340864.0
2020-03-24 10:00:00	AAPL	Stock	59.125	60.86	58.9275	60.4345	26248688.0
2020-03-24 10:30:00	AAPL	Stock	60.435	60.6675	60.2	60.3	15299340.0
2020-03-24 11:00:00	AAPL	Stock	60.3	60.5648	59.7625	60.1725	13354708.0
2020-03-24 11:30:00	AAPL	Stock	60.1775	60.5875	59.95	60.5738	12277720.0
2020-03-24 12:00:00	AAPL	Stock	60.57	60.645	60.3075	60.645	9158684.0
2020-03-24 12:30:00	AAPL	Stock	60.6388	60.77	60.03	60.0575	12030204.0
2020-03-24 13:00:00	AAPL	Stock	60.0625	60.3575	59.7155	60.0285	10692588.0
2020-03-24 13:30:00	AAPL	Stock	60.0275	60.3075	59.535	59.635	9221272.0
2020-03-24 14:00:00	AAPL	Stock	59.64	59.9575	59.135	59.8685	10447832.0
2020-03-24 14:30:00	AAPL	Stock	59.8675	60.75	59.65	60.7225	13932032.0
2020-03-24 15:00:00	AAPL	Stock	60.72	61.125	60.525	60.9112	16807640.0
2020-03-24 15:30:00	AAPL	Stock	60.92	61.9225	60.78	61.72	31460648.0
2020-03-24 16:00:00	AAPL	Stock	61.5	61.81	60.1948	61.6375	25197852.0
2020-03-24 16:30:00	AAPL	Stock	61.6	62.0	61.55	61.8038	305080.0
2020-03-24 17:00:00	AAPL	Stock	61.815	61.8925	61.5025	61.6	150488.0
2020-03-24 17:30:00	AAPL	Stock	61.6225	61.9225	61.55	61.9225	348868.0
2020-03-24 18:00:00	AAPL	Stock	61.9225	62.125	61.625	62.125	223084.0
2020-03-24 18:30:00	AAPL	Stock	62.125	62.25	62.0125	62.125	180180.0
2020-03-24 19:00:00	AAPL	Stock	62.1125	62.175	61.65	61.67	141288.0
2020-03-24 19:30:00	AAPL	Stock	61.65	61.7	61.1875	61.5	351048.0
2020-03-24 04:00:00	MSFT	Stock	141.28	143.0	141.28	141.49	26928.0
2020-03-24 04:30:00	MSFT	Stock	141.31	141.98	141.0	141.66	8469.0
2020-03-24 05:00:00	MSFT	Stock	141.8	142.3	141.66	142.2	3769.0
2020-03-24 05:30:00	MSFT	Stock	142.25	143.0	142.0	143.0	18399.0
2020-03-24 06:00:00	MSFT	Stock	143.0	143.45	143.0	143.24	10326.0
2020-03-24 06:30:00	MSFT	Stock	143.06	143.3	142.28	142.92	6329.0
2020-03-24 07:00:00	MSFT	Stock	142.76	143.0	140.3	141.1	131296.0
2020-03-24 07:30:00	MSFT	Stock	141.29	141.75	140.75	141.05	47408.0
2020-03-24 08:00:00	MSFT	Stock	141.25	142.5	140.06	141.0	148753.0
2020-03-24 08:30:00	MSFT	Stock	140.93	142.7	140.5	142.56	183068.0
2020-03-24 09:00:00	MSFT	Stock	142.6	144.1	142.2	143.9	303200.0
2020-03-24 09:30:00	MSFT	Stock	143.9	144.86	141.47	142.07	7688797.0
2020-03-24 10:00:00	MSFT	Stock	142.04	145.35	141.27	144.425	5423074.0
2020-03-24 10:30:00	MSFT	Stock	144.43	145.28	143.12	143.865	3726589.0
2020-03-24 11:00:00	MSFT	Stock	143.87	144.79	143.0	144.202	3535495.0
2020-03-24 11:30:00	MSFT	Stock	144.23	146.0	143.85	145.934	4298584.0
2020-03-24 12:00:00	MSFT	Stock	145.936	147.96	145.61	147.94	3714379.0
2020-03-24 12:30:00	MSFT	Stock	147.93	149.6	146.098	146.136	4652758.0

> showing 50 of 96,442 rows — these rows as CSV

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