PREVIEW / stock_30min / 2019-05-17

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-05-17.parquet
  size:    1.7 MB
  rows:    83,323
  symbols: 2,609

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-05-17 04:00:00	AAPL	Stock	47.375	47.375	47.195	47.195	94880.0
2019-05-17 04:30:00	AAPL	Stock	47.18	47.1925	47.0625	47.07	24404.0
2019-05-17 05:00:00	AAPL	Stock	47.095	47.125	47.0875	47.125	10764.0
2019-05-17 05:30:00	AAPL	Stock	47.145	47.265	47.145	47.235	7196.0
2019-05-17 06:00:00	AAPL	Stock	47.2025	47.2025	47.0275	47.045	11744.0
2019-05-17 06:30:00	AAPL	Stock	47.05	47.055	46.905	47.0025	15092.0
2019-05-17 07:00:00	AAPL	Stock	47.05	47.1125	46.875	46.875	159292.0
2019-05-17 07:30:00	AAPL	Stock	46.8625	46.905	46.8	46.86	143468.0
2019-05-17 08:00:00	AAPL	Stock	47.086	47.6375	46.625	46.6275	291856.0
2019-05-17 08:30:00	AAPL	Stock	46.625	46.8	46.595	46.725	279312.0
2019-05-17 09:00:00	AAPL	Stock	46.705	46.765	46.6275	46.765	294452.0
2019-05-17 09:30:00	AAPL	Stock	46.765	47.085	46.69	46.921	16546060.0
2019-05-17 10:00:00	AAPL	Stock	46.9175	47.3325	46.7025	47.3103	11287372.0
2019-05-17 10:30:00	AAPL	Stock	47.3125	47.5375	47.175	47.4825	7968992.0
2019-05-17 11:00:00	AAPL	Stock	47.48	47.725	47.44	47.4912	6921320.0
2019-05-17 11:30:00	AAPL	Stock	47.49	47.5075	47.1425	47.3138	5915172.0
2019-05-17 12:00:00	AAPL	Stock	47.3125	47.4025	47.145	47.3325	4676484.0
2019-05-17 12:30:00	AAPL	Stock	47.3325	47.555	47.2825	47.4875	4595428.0
2019-05-17 13:00:00	AAPL	Stock	47.4875	47.555	47.4125	47.4125	3195836.0
2019-05-17 13:30:00	AAPL	Stock	47.415	47.55	47.3375	47.4875	4579904.0
2019-05-17 14:00:00	AAPL	Stock	47.4875	47.5325	47.3925	47.4288	3750536.0
2019-05-17 14:30:00	AAPL	Stock	47.43	47.495	47.34	47.4843	3963208.0
2019-05-17 15:00:00	AAPL	Stock	47.4825	47.49	47.0	47.25	10633420.0
2019-05-17 15:30:00	AAPL	Stock	47.2482	47.3525	47.1375	47.245	12096552.0
2019-05-17 16:00:00	AAPL	Stock	47.2412	47.2625	46.9202	47.25	9875372.0
2019-05-17 16:30:00	AAPL	Stock	47.2275	47.2275	47.175	47.175	88032.0
2019-05-17 17:00:00	AAPL	Stock	47.1775	47.2375	47.175	47.2375	23812.0
2019-05-17 17:30:00	AAPL	Stock	47.215	47.215	47.1775	47.1875	3484.0
2019-05-17 18:00:00	AAPL	Stock	47.1775	47.1825	47.1775	47.1825	1244.0
2019-05-17 18:30:00	AAPL	Stock	47.22	47.22	47.175	47.175	4200.0
2019-05-17 19:00:00	AAPL	Stock	47.2225	47.2225	47.1775	47.19	10400.0
2019-05-17 19:30:00	AAPL	Stock	47.2	47.3375	47.19	47.25	17104.0
2019-05-17 04:00:00	MSFT	Stock	128.76	128.77	128.33	128.33	3077.0
2019-05-17 04:30:00	MSFT	Stock	128.13	128.37	128.03	128.13	2154.0
2019-05-17 05:00:00	MSFT	Stock	128.07	128.09	127.91	128.09	1010.0
2019-05-17 05:30:00	MSFT	Stock	128.26	128.62	128.26	128.54	2140.0
2019-05-17 06:00:00	MSFT	Stock	128.5	128.5	128.39	128.39	841.0
2019-05-17 06:30:00	MSFT	Stock	128.35	128.35	128.21	128.3	1247.0
2019-05-17 07:00:00	MSFT	Stock	128.27	128.27	128.1	128.25	5973.0
2019-05-17 07:30:00	MSFT	Stock	128.12	128.2	128.01	128.1	17305.0
2019-05-17 08:00:00	MSFT	Stock	128.15	129.25	127.75	127.91	28828.0
2019-05-17 08:30:00	MSFT	Stock	127.85	128.26	127.76	128.013	22652.0
2019-05-17 09:00:00	MSFT	Stock	128.05	128.28	127.88	128.25	26685.0
2019-05-17 09:30:00	MSFT	Stock	128.28	129.06	128.23	128.56	3278324.0
2019-05-17 10:00:00	MSFT	Stock	128.55	129.29	128.375	129.16	1632496.0
2019-05-17 10:30:00	MSFT	Stock	129.16	130.03	128.955	129.96	2199340.0
2019-05-17 11:00:00	MSFT	Stock	129.95	130.46	129.95	130.03	1879533.0
2019-05-17 11:30:00	MSFT	Stock	130.04	130.07	129.13	129.27	1381334.0
2019-05-17 12:00:00	MSFT	Stock	129.27	129.3	128.85	129.035	914833.0
2019-05-17 12:30:00	MSFT	Stock	129.041	129.28	128.824	129.11	831500.0

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

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