PREVIEW / stock_30min / 2019-04-24

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-04-24.parquet
  size:    1.7 MB
  rows:    84,650
  symbols: 2,613

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-24 04:00:00	AAPL	Stock	51.905	52.04	51.8825	52.0075	34848.0
2019-04-24 04:30:00	AAPL	Stock	51.9625	51.9625	51.9625	51.9625	5600.0
2019-04-24 06:00:00	AAPL	Stock	51.9975	52.025	51.9975	52.025	3388.0
2019-04-24 06:30:00	AAPL	Stock	52.025	52.025	51.9975	51.9975	2492.0
2019-04-24 07:00:00	AAPL	Stock	52.0075	52.03	51.9125	51.9625	80796.0
2019-04-24 07:30:00	AAPL	Stock	51.945	52.0075	51.9375	51.9725	75296.0
2019-04-24 08:00:00	AAPL	Stock	52.0275	52.036	51.9225	51.9625	163116.0
2019-04-24 08:30:00	AAPL	Stock	51.95	51.9575	51.8875	51.9225	79492.0
2019-04-24 09:00:00	AAPL	Stock	51.9375	51.995	51.81	51.8375	234428.0
2019-04-24 09:30:00	AAPL	Stock	51.835	52.1	51.805	51.86	14668536.0
2019-04-24 10:00:00	AAPL	Stock	51.8575	52.0525	51.7625	52.0155	5651664.0
2019-04-24 10:30:00	AAPL	Stock	52.0175	52.045	51.9175	52.0425	3523416.0
2019-04-24 11:00:00	AAPL	Stock	52.045	52.12	51.9725	51.99	3601588.0
2019-04-24 11:30:00	AAPL	Stock	51.9925	52.075	51.8775	51.9475	3372704.0
2019-04-24 12:00:00	AAPL	Stock	51.945	51.9612	51.885	51.9225	2016624.0
2019-04-24 12:30:00	AAPL	Stock	51.92	51.925	51.82	51.8225	2459324.0
2019-04-24 13:00:00	AAPL	Stock	51.82	51.9225	51.79	51.92	2268296.0
2019-04-24 13:30:00	AAPL	Stock	51.92	51.945	51.845	51.875	2157952.0
2019-04-24 14:00:00	AAPL	Stock	51.875	51.9425	51.8575	51.9085	1750588.0
2019-04-24 14:30:00	AAPL	Stock	51.9075	51.995	51.9025	51.9532	1983740.0
2019-04-24 15:00:00	AAPL	Stock	51.9538	51.975	51.78	51.8275	3208212.0
2019-04-24 15:30:00	AAPL	Stock	51.8275	51.985	51.7725	51.795	6308736.0
2019-04-24 16:00:00	AAPL	Stock	51.79	52.0	51.7625	51.975	7661192.0
2019-04-24 16:30:00	AAPL	Stock	51.975	52.0	51.79	51.975	240952.0
2019-04-24 17:00:00	AAPL	Stock	51.975	52.1125	51.79	52.1	287176.0
2019-04-24 17:30:00	AAPL	Stock	52.04	52.1	51.79	52.0025	192152.0
2019-04-24 18:00:00	AAPL	Stock	52.0025	52.0125	51.975	51.975	74880.0
2019-04-24 18:30:00	AAPL	Stock	51.975	52.0	51.975	51.975	71944.0
2019-04-24 19:00:00	AAPL	Stock	51.975	52.0	51.975	52.0	12436.0
2019-04-24 19:30:00	AAPL	Stock	51.9875	52.0	51.98	52.0	30276.0
2019-04-24 04:00:00	MSFT	Stock	125.6	125.6	125.58	125.6	1090.0
2019-04-24 04:30:00	MSFT	Stock	125.6	125.6	125.6	125.6	100.0
2019-04-24 05:00:00	MSFT	Stock	125.64	125.68	125.64	125.68	1733.0
2019-04-24 05:30:00	MSFT	Stock	125.7	125.8	125.7	125.8	1801.0
2019-04-24 06:00:00	MSFT	Stock	125.72	125.89	125.72	125.78	2349.0
2019-04-24 06:30:00	MSFT	Stock	125.86	125.9	125.85	125.85	3133.0
2019-04-24 07:00:00	MSFT	Stock	125.81	125.9	125.74	125.77	22475.0
2019-04-24 07:30:00	MSFT	Stock	125.8	125.96	125.75	125.9	11180.0
2019-04-24 08:00:00	MSFT	Stock	125.9	126.1	125.732	125.95	50026.0
2019-04-24 08:30:00	MSFT	Stock	125.98	126.0	125.87	125.93	20296.0
2019-04-24 09:00:00	MSFT	Stock	125.91	125.94	125.72	125.82	31749.0
2019-04-24 09:30:00	MSFT	Stock	125.79	125.85	124.52	124.85	3913098.0
2019-04-24 10:00:00	MSFT	Stock	124.845	125.29	124.7	125.207	1739906.0
2019-04-24 10:30:00	MSFT	Stock	125.22	125.42	124.9	125.17	1617616.0
2019-04-24 11:00:00	MSFT	Stock	125.18	125.25	124.93	124.95	1450375.0
2019-04-24 11:30:00	MSFT	Stock	124.95	125.14	124.875	124.94	929583.0
2019-04-24 12:00:00	MSFT	Stock	124.943	125.11	124.86	125.08	820055.0
2019-04-24 12:30:00	MSFT	Stock	125.08	125.19	124.973	125.036	910707.0
2019-04-24 13:00:00	MSFT	Stock	125.04	125.16	124.99	125.143	606021.0
2019-04-24 13:30:00	MSFT	Stock	125.15	125.17	125.04	125.07	582993.0

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

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