PREVIEW / stock_30min / 2018-07-17

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-07-17.parquet
  size:    1.7 MB
  rows:    82,696
  symbols: 2,822

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
2018-07-17 04:00:00	AAPL	Stock	47.475	47.475	47.475	47.475	400.0
2018-07-17 04:30:00	AAPL	Stock	47.5	47.5	47.5	47.5	416.0
2018-07-17 06:00:00	AAPL	Stock	47.5	47.5	47.45	47.45	24280.0
2018-07-17 06:30:00	AAPL	Stock	47.45	47.45	47.4	47.4	21228.0
2018-07-17 07:00:00	AAPL	Stock	47.425	47.45	47.425	47.45	39908.0
2018-07-17 07:30:00	AAPL	Stock	47.475	47.595	47.4625	47.5875	54656.0
2018-07-17 08:00:00	AAPL	Stock	47.595	47.595	47.425	47.525	121088.0
2018-07-17 08:30:00	AAPL	Stock	47.525	47.5275	47.4675	47.4775	38104.0
2018-07-17 09:00:00	AAPL	Stock	47.4625	47.7275	47.4025	47.435	179620.0
2018-07-17 09:30:00	AAPL	Stock	47.4375	47.56	47.3	47.4675	7865296.0
2018-07-17 10:00:00	AAPL	Stock	47.4725	47.625	47.4058	47.615	3921924.0
2018-07-17 10:30:00	AAPL	Stock	47.6175	47.695	47.5475	47.68	2756288.0
2018-07-17 11:00:00	AAPL	Stock	47.6775	47.75	47.635	47.6485	2999144.0
2018-07-17 11:30:00	AAPL	Stock	47.6488	47.76	47.6025	47.695	2997184.0
2018-07-17 12:00:00	AAPL	Stock	47.6962	47.8725	47.6525	47.8575	3245812.0
2018-07-17 12:30:00	AAPL	Stock	47.8593	47.8675	47.7625	47.7625	3818348.0
2018-07-17 13:00:00	AAPL	Stock	47.7625	47.87	47.7625	47.828	2064576.0
2018-07-17 13:30:00	AAPL	Stock	47.83	47.8775	47.825	47.85	1627336.0
2018-07-17 14:00:00	AAPL	Stock	47.85	47.8775	47.82	47.86	1487796.0
2018-07-17 14:30:00	AAPL	Stock	47.855	47.8725	47.7725	47.805	1749844.0
2018-07-17 15:00:00	AAPL	Stock	47.8025	47.9675	47.7925	47.946	3245348.0
2018-07-17 15:30:00	AAPL	Stock	47.9475	47.9575	47.83	47.8675	6675148.0
2018-07-17 16:00:00	AAPL	Stock	47.8675	47.8925	47.8625	47.8625	9412500.0
2018-07-17 16:30:00	AAPL	Stock	47.8625	47.8875	47.8625	47.8875	26140.0
2018-07-17 17:00:00	AAPL	Stock	47.8875	47.8875	47.8725	47.875	11432.0
2018-07-17 17:30:00	AAPL	Stock	47.875	47.8875	47.8675	47.8675	6748.0
2018-07-17 18:00:00	AAPL	Stock	47.8925	47.9225	47.87	47.9225	12932.0
2018-07-17 18:30:00	AAPL	Stock	47.91	47.9375	47.91	47.925	11424.0
2018-07-17 19:00:00	AAPL	Stock	47.9075	47.9075	47.9075	47.9075	1772.0
2018-07-17 19:30:00	AAPL	Stock	47.9075	47.9325	47.9	47.9325	6048.0
2018-07-17 04:30:00	MSFT	Stock	104.72	104.72	104.5	104.5	598.0
2018-07-17 05:00:00	MSFT	Stock	104.55	104.78	104.55	104.78	1000.0
2018-07-17 05:30:00	MSFT	Stock	104.69	104.69	104.69	104.69	338.0
2018-07-17 06:00:00	MSFT	Stock	104.54	104.54	104.5	104.5	1500.0
2018-07-17 06:30:00	MSFT	Stock	104.48	104.48	104.48	104.48	100.0
2018-07-17 07:00:00	MSFT	Stock	104.5	104.58	104.5	104.58	2230.0
2018-07-17 07:30:00	MSFT	Stock	104.6	104.77	104.58	104.68	2240.0
2018-07-17 08:00:00	MSFT	Stock	104.5	105.15	104.5	104.76	20975.0
2018-07-17 08:30:00	MSFT	Stock	104.78	105.3	104.75	105.15	31644.0
2018-07-17 09:00:00	MSFT	Stock	105.15	105.26	104.6	104.6	54587.0
2018-07-17 09:30:00	MSFT	Stock	104.61	104.91	104.32	104.88	3135419.0
2018-07-17 10:00:00	MSFT	Stock	104.89	105.21	104.885	104.99	1707346.0
2018-07-17 10:30:00	MSFT	Stock	105.0	105.18	104.96	105.085	1358965.0
2018-07-17 11:00:00	MSFT	Stock	105.09	105.22	105.01	105.09	1346356.0
2018-07-17 11:30:00	MSFT	Stock	105.09	105.41	105.05	105.41	1135272.0
2018-07-17 12:00:00	MSFT	Stock	105.405	105.91	105.205	105.907	1169517.0
2018-07-17 12:30:00	MSFT	Stock	105.91	105.957	105.745	105.94	1174847.0
2018-07-17 13:00:00	MSFT	Stock	105.946	106.21	105.9	106.075	917800.0
2018-07-17 13:30:00	MSFT	Stock	106.08	106.32	106.07	106.202	877928.0
2018-07-17 14:00:00	MSFT	Stock	106.205	106.29	106.01	106.23	1022243.0

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

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