PREVIEW / stock_30min / 2019-04-04

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-04-04.parquet
  size:    1.7 MB
  rows:    83,351
  symbols: 2,635

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-04-04 04:00:00	AAPL	Stock	48.91	48.9275	48.91	48.9125	14184.0
2019-04-04 04:30:00	AAPL	Stock	48.9175	48.9175	48.8725	48.8725	15608.0
2019-04-04 05:30:00	AAPL	Stock	48.87	48.9	48.87	48.9	6160.0
2019-04-04 06:00:00	AAPL	Stock	48.9	48.9475	48.875	48.9475	6792.0
2019-04-04 06:30:00	AAPL	Stock	48.885	48.885	48.885	48.885	400.0
2019-04-04 07:00:00	AAPL	Stock	48.895	48.9125	48.865	48.9075	20968.0
2019-04-04 07:30:00	AAPL	Stock	48.9025	48.9225	48.8125	48.8125	61676.0
2019-04-04 08:00:00	AAPL	Stock	48.8775	48.9228	48.75	48.765	152000.0
2019-04-04 08:30:00	AAPL	Stock	48.7625	48.775	48.705	48.7375	147144.0
2019-04-04 09:00:00	AAPL	Stock	48.725	48.775	48.6425	48.675	208336.0
2019-04-04 09:30:00	AAPL	Stock	48.6975	49.0475	48.6902	48.9862	9895084.0
2019-04-04 10:00:00	AAPL	Stock	48.9875	49.0425	48.8125	48.828	5372052.0
2019-04-04 10:30:00	AAPL	Stock	48.8275	49.0	48.7	48.96	6506508.0
2019-04-04 11:00:00	AAPL	Stock	48.96	49.04	48.8103	48.97	4404848.0
2019-04-04 11:30:00	AAPL	Stock	48.9725	49.0925	48.92	48.94	4628336.0
2019-04-04 12:00:00	AAPL	Stock	48.9375	48.9925	48.855	48.9325	2697720.0
2019-04-04 12:30:00	AAPL	Stock	48.9325	48.9425	48.805	48.8912	3411272.0
2019-04-04 13:00:00	AAPL	Stock	48.8925	48.9325	48.87	48.875	2130308.0
2019-04-04 13:30:00	AAPL	Stock	48.8775	48.8925	48.8375	48.875	2246788.0
2019-04-04 14:00:00	AAPL	Stock	48.875	48.9	48.839	48.8738	2594660.0
2019-04-04 14:30:00	AAPL	Stock	48.8725	49.0225	48.8725	48.9725	4080812.0
2019-04-04 15:00:00	AAPL	Stock	48.9725	48.994	48.9075	48.9175	3098608.0
2019-04-04 15:30:00	AAPL	Stock	48.9225	48.96	48.285	48.93	7213304.0
2019-04-04 16:00:00	AAPL	Stock	48.9225	48.9375	48.8858	48.9	6684000.0
2019-04-04 16:30:00	AAPL	Stock	48.9225	48.9375	48.9225	48.925	11404.0
2019-04-04 17:00:00	AAPL	Stock	48.92	48.9275	48.8125	48.89	37496.0
2019-04-04 17:30:00	AAPL	Stock	48.8925	48.91	48.88	48.895	28352.0
2019-04-04 18:00:00	AAPL	Stock	48.8975	48.8975	48.87	48.875	16420.0
2019-04-04 18:30:00	AAPL	Stock	48.89	48.89	48.8825	48.89	5508.0
2019-04-04 19:00:00	AAPL	Stock	48.875	48.875	48.8575	48.8575	7672.0
2019-04-04 19:30:00	AAPL	Stock	48.8625	48.895	48.8625	48.8875	19980.0
2019-04-04 04:00:00	MSFT	Stock	120.13	120.2	120.13	120.2	200.0
2019-04-04 06:00:00	MSFT	Stock	120.2	120.2	120.2	120.2	147.0
2019-04-04 06:30:00	MSFT	Stock	120.33	120.36	120.32	120.32	840.0
2019-04-04 07:00:00	MSFT	Stock	120.17	120.17	120.17	120.17	300.0
2019-04-04 07:30:00	MSFT	Stock	120.17	120.2	119.97	120.0	1841.0
2019-04-04 08:00:00	MSFT	Stock	120.15	120.3	119.92	120.12	2799.0
2019-04-04 08:30:00	MSFT	Stock	120.0	120.09	119.99	120.0	13613.0
2019-04-04 09:00:00	MSFT	Stock	119.901	120.11	119.87	120.11	2718.0
2019-04-04 09:30:00	MSFT	Stock	120.1	120.23	119.72	120.1	1844040.0
2019-04-04 10:00:00	MSFT	Stock	120.1	120.11	119.07	119.13	1630169.0
2019-04-04 10:30:00	MSFT	Stock	119.13	119.415	118.75	119.06	1581945.0
2019-04-04 11:00:00	MSFT	Stock	119.07	119.076	118.71	118.895	1199471.0
2019-04-04 11:30:00	MSFT	Stock	118.89	119.21	118.835	118.95	872155.0
2019-04-04 12:00:00	MSFT	Stock	118.96	119.19	118.79	118.87	848953.0
2019-04-04 12:30:00	MSFT	Stock	118.86	118.93	118.38	118.61	1350818.0
2019-04-04 13:00:00	MSFT	Stock	118.605	118.92	118.49	118.852	693118.0
2019-04-04 13:30:00	MSFT	Stock	118.855	118.955	118.71	118.78	543627.0
2019-04-04 14:00:00	MSFT	Stock	118.78	119.23	118.74	119.18	577736.0
2019-04-04 14:30:00	MSFT	Stock	119.16	119.545	119.125	119.53	723377.0

> showing 50 of 83,351 rows — these rows as CSV

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