PREVIEW / stock_30min / 2019-03-25

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-03-25.parquet
  size:    1.7 MB
  rows:    84,133
  symbols: 2,641

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-03-25 04:00:00	AAPL	Stock	47.5925	47.5925	47.5	47.5	19076.0
2019-03-25 04:30:00	AAPL	Stock	47.45	47.625	47.415	47.415	19140.0
2019-03-25 05:00:00	AAPL	Stock	47.535	47.675	47.535	47.5625	11560.0
2019-03-25 05:30:00	AAPL	Stock	47.615	47.6625	47.5525	47.5525	18324.0
2019-03-25 06:00:00	AAPL	Stock	47.55	47.5875	47.5125	47.5525	52920.0
2019-03-25 06:30:00	AAPL	Stock	47.5625	47.5875	47.5575	47.5575	76548.0
2019-03-25 07:00:00	AAPL	Stock	47.5925	47.625	47.54	47.55	137072.0
2019-03-25 07:30:00	AAPL	Stock	47.575	47.6125	47.535	47.5975	122608.0
2019-03-25 08:00:00	AAPL	Stock	47.6	48.035	47.5375	48.035	659632.0
2019-03-25 08:30:00	AAPL	Stock	48.0	48.25	47.9625	48.12	675296.0
2019-03-25 09:00:00	AAPL	Stock	48.12	48.14	47.855	47.905	598600.0
2019-03-25 09:30:00	AAPL	Stock	47.91	47.995	46.8125	46.9375	29815460.0
2019-03-25 10:00:00	AAPL	Stock	46.9382	47.185	46.8642	47.1775	14683008.0
2019-03-25 10:30:00	AAPL	Stock	47.175	47.625	47.14	47.5175	10677360.0
2019-03-25 11:00:00	AAPL	Stock	47.515	47.625	47.29	47.5922	7916804.0
2019-03-25 11:30:00	AAPL	Stock	47.59	47.653	47.5025	47.54	5916876.0
2019-03-25 12:00:00	AAPL	Stock	47.54	47.74	47.5075	47.64	5426108.0
2019-03-25 12:30:00	AAPL	Stock	47.6425	47.665	47.35	47.445	6719912.0
2019-03-25 13:00:00	AAPL	Stock	47.4517	47.48	47.0475	47.1548	9682304.0
2019-03-25 13:30:00	AAPL	Stock	47.1508	47.295	46.96	47.0625	10124284.0
2019-03-25 14:00:00	AAPL	Stock	47.0628	47.1075	46.7975	46.9225	9093348.0
2019-03-25 14:30:00	AAPL	Stock	46.9225	47.1	46.81	46.8688	11026408.0
2019-03-25 15:00:00	AAPL	Stock	46.8675	46.98	46.65	46.9758	11997964.0
2019-03-25 15:30:00	AAPL	Stock	46.975	47.2075	46.9125	47.1925	14345752.0
2019-03-25 16:00:00	AAPL	Stock	47.185	47.32	47.1325	47.2025	6422444.0
2019-03-25 16:30:00	AAPL	Stock	47.245	47.295	47.1875	47.295	168812.0
2019-03-25 17:00:00	AAPL	Stock	47.29	47.2975	47.185	47.2	113868.0
2019-03-25 17:30:00	AAPL	Stock	47.2	47.2375	47.1875	47.225	40092.0
2019-03-25 18:00:00	AAPL	Stock	47.225	47.3275	47.225	47.2525	88576.0
2019-03-25 18:30:00	AAPL	Stock	47.285	47.2875	47.2525	47.285	35892.0
2019-03-25 19:00:00	AAPL	Stock	47.275	47.2825	47.2375	47.2375	18952.0
2019-03-25 19:30:00	AAPL	Stock	47.225	47.29	47.085	47.29	135308.0
2019-03-25 04:00:00	MSFT	Stock	115.75	116.25	115.75	116.11	4067.0
2019-03-25 04:30:00	MSFT	Stock	116.24	116.54	116.1	116.1	5895.0
2019-03-25 05:00:00	MSFT	Stock	116.7	116.7	116.5	116.69	3028.0
2019-03-25 05:30:00	MSFT	Stock	116.65	116.72	116.55	116.55	3926.0
2019-03-25 06:00:00	MSFT	Stock	116.55	116.85	116.5	116.75	7940.0
2019-03-25 06:30:00	MSFT	Stock	116.84	116.9	116.71	116.71	3530.0
2019-03-25 07:00:00	MSFT	Stock	116.86	116.86	116.49	116.5	11983.0
2019-03-25 07:30:00	MSFT	Stock	116.5	116.77	116.5	116.59	8533.0
2019-03-25 08:00:00	MSFT	Stock	116.55	116.89	116.45	116.8	13298.0
2019-03-25 08:30:00	MSFT	Stock	116.8	117.0	116.7	117.0	17377.0
2019-03-25 09:00:00	MSFT	Stock	116.92	116.92	116.42	116.44	21847.0
2019-03-25 09:30:00	MSFT	Stock	116.56	117.857	116.322	117.16	3837706.0
2019-03-25 10:00:00	MSFT	Stock	117.16	117.338	116.73	117.04	1848906.0
2019-03-25 10:30:00	MSFT	Stock	117.03	117.64	116.78	117.54	1758307.0
2019-03-25 11:00:00	MSFT	Stock	117.53	117.935	117.34	117.9	1434212.0
2019-03-25 11:30:00	MSFT	Stock	117.9	118.01	117.38	117.39	1447649.0
2019-03-25 12:00:00	MSFT	Stock	117.4	117.81	117.24	117.675	819190.0
2019-03-25 12:30:00	MSFT	Stock	117.67	117.7	117.23	117.38	870642.0

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

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