PREVIEW / stock_30min / 2020-08-10

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-08-10.parquet
  size:    2.0 MB
  rows:    100,259
  symbols: 2,451

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-08-10 04:00:00	AAPL	Stock	111.625	111.625	111.35	111.35	14616.0
2020-08-10 04:30:00	AAPL	Stock	111.375	111.7	111.375	111.7	12036.0
2020-08-10 05:00:00	AAPL	Stock	111.7375	111.875	111.7375	111.875	10700.0
2020-08-10 05:30:00	AAPL	Stock	111.85	111.9625	111.6875	111.925	17992.0
2020-08-10 06:00:00	AAPL	Stock	111.8775	111.8775	111.75	111.7975	5372.0
2020-08-10 06:30:00	AAPL	Stock	111.8125	112.0	111.7825	111.9	28700.0
2020-08-10 07:00:00	AAPL	Stock	111.95	112.3575	111.85	112.305	361264.0
2020-08-10 07:30:00	AAPL	Stock	112.3102	112.4975	112.1875	112.485	220492.0
2020-08-10 08:00:00	AAPL	Stock	112.18	112.6575	111.9	112.6275	584944.0
2020-08-10 08:30:00	AAPL	Stock	112.625	113.1125	112.5875	112.965	1047280.0
2020-08-10 09:00:00	AAPL	Stock	112.95	112.9525	112.5375	112.5625	834316.0
2020-08-10 09:30:00	AAPL	Stock	112.565	113.775	111.965	112.427	33356180.0
2020-08-10 10:00:00	AAPL	Stock	112.4375	112.685	111.5725	111.919	14132308.0
2020-08-10 10:30:00	AAPL	Stock	111.9212	112.3635	110.305	110.33	15847836.0
2020-08-10 11:00:00	AAPL	Stock	110.329	111.675	110.0	111.4475	17121292.0
2020-08-10 11:30:00	AAPL	Stock	111.4462	112.275	111.23	112.0592	10515624.0
2020-08-10 12:00:00	AAPL	Stock	112.0725	112.545	111.9438	112.0125	10827584.0
2020-08-10 12:30:00	AAPL	Stock	112.0162	112.9675	111.81	112.685	10158952.0
2020-08-10 13:00:00	AAPL	Stock	112.6875	112.975	112.415	112.765	7574436.0
2020-08-10 13:30:00	AAPL	Stock	112.7675	112.825	112.29	112.4888	6202428.0
2020-08-10 14:00:00	AAPL	Stock	112.4888	112.82	112.405	112.7768	6359528.0
2020-08-10 14:30:00	AAPL	Stock	112.785	113.205	112.4475	113.1325	7784080.0
2020-08-10 15:00:00	AAPL	Stock	113.13	113.245	112.42	112.495	9987848.0
2020-08-10 15:30:00	AAPL	Stock	112.4908	112.84	112.395	112.735	11004512.0
2020-08-10 16:00:00	AAPL	Stock	112.735	112.8	112.324	112.6125	6118636.0
2020-08-10 16:30:00	AAPL	Stock	112.635	112.7275	112.595	112.7025	56956.0
2020-08-10 17:00:00	AAPL	Stock	112.7025	112.72	112.4625	112.475	122240.0
2020-08-10 17:30:00	AAPL	Stock	112.475	112.475	112.4	112.435	40528.0
2020-08-10 18:00:00	AAPL	Stock	112.415	112.4625	112.375	112.4375	41692.0
2020-08-10 18:30:00	AAPL	Stock	112.375	112.45	112.375	112.4125	49308.0
2020-08-10 19:00:00	AAPL	Stock	112.4225	112.4425	112.4	112.4125	42040.0
2020-08-10 19:30:00	AAPL	Stock	112.4025	112.4925	112.4	112.4775	86316.0
2020-08-10 04:00:00	MSFT	Stock	211.98	211.98	211.7	211.7	1534.0
2020-08-10 04:30:00	MSFT	Stock	211.7	211.85	211.51	211.6	1575.0
2020-08-10 05:00:00	MSFT	Stock	211.55	211.71	211.31	211.71	663.0
2020-08-10 05:30:00	MSFT	Stock	211.6	211.77	211.45	211.45	2175.0
2020-08-10 06:00:00	MSFT	Stock	211.5	211.75	211.45	211.5	2013.0
2020-08-10 06:30:00	MSFT	Stock	211.42	211.51	211.39	211.39	900.0
2020-08-10 07:00:00	MSFT	Stock	211.77	211.93	210.95	211.3	33840.0
2020-08-10 07:30:00	MSFT	Stock	211.31	211.35	211.0	211.19	18394.0
2020-08-10 08:00:00	MSFT	Stock	211.021	211.85	210.95	211.25	54207.0
2020-08-10 08:30:00	MSFT	Stock	211.25	211.34	211.03	211.24	40173.0
2020-08-10 09:00:00	MSFT	Stock	211.25	211.7	211.25	211.37	35849.0
2020-08-10 09:30:00	MSFT	Stock	211.67	211.88	208.62	208.89	4584117.0
2020-08-10 10:00:00	MSFT	Stock	208.91	209.07	208.26	208.66	1754195.0
2020-08-10 10:30:00	MSFT	Stock	208.67	208.7	206.78	206.79	2140945.0
2020-08-10 11:00:00	MSFT	Stock	206.78	208.11	206.35	208.075	2055792.0
2020-08-10 11:30:00	MSFT	Stock	208.08	208.15	206.46	207.0	2282333.0
2020-08-10 12:00:00	MSFT	Stock	207.03	207.407	206.75	206.9	1147997.0
2020-08-10 12:30:00	MSFT	Stock	206.895	208.2	206.859	207.782	1437123.0

> showing 50 of 100,259 rows — these rows as CSV

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