PREVIEW / stock_30min / 2019-04-22

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-04-22.parquet
  size:    1.7 MB
  rows:    83,539
  symbols: 2,630

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-22 04:30:00	AAPL	Stock	50.9	50.9	50.9	50.9	400.0
2019-04-22 05:30:00	AAPL	Stock	50.825	50.825	50.8125	50.8125	800.0
2019-04-22 07:00:00	AAPL	Stock	50.8675	50.875	50.8225	50.8225	23288.0
2019-04-22 07:30:00	AAPL	Stock	50.8125	50.83	50.7825	50.8	17832.0
2019-04-22 08:00:00	AAPL	Stock	50.875	50.875	50.715	50.75	135820.0
2019-04-22 08:30:00	AAPL	Stock	50.75	50.75	50.6875	50.6875	101772.0
2019-04-22 09:00:00	AAPL	Stock	50.7	50.74	50.675	50.6825	139548.0
2019-04-22 09:30:00	AAPL	Stock	50.665	51.0975	50.585	50.909	12411332.0
2019-04-22 10:00:00	AAPL	Stock	50.9075	51.04	50.815	51.025	4700496.0
2019-04-22 10:30:00	AAPL	Stock	51.025	51.16	50.9675	51.1562	3569644.0
2019-04-22 11:00:00	AAPL	Stock	51.1575	51.23	51.1125	51.2175	3861952.0
2019-04-22 11:30:00	AAPL	Stock	51.22	51.235	51.13	51.15	2457272.0
2019-04-22 12:00:00	AAPL	Stock	51.15	51.1825	51.125	51.1738	1812072.0
2019-04-22 12:30:00	AAPL	Stock	51.1738	51.1775	51.1025	51.1275	1795832.0
2019-04-22 13:00:00	AAPL	Stock	51.1287	51.164	51.0575	51.0825	2207404.0
2019-04-22 13:30:00	AAPL	Stock	51.0818	51.155	51.045	51.116	2704356.0
2019-04-22 14:00:00	AAPL	Stock	51.1175	51.165	51.0778	51.0875	2178432.0
2019-04-22 14:30:00	AAPL	Stock	51.087	51.0875	51.015	51.07	2629776.0
2019-04-22 15:00:00	AAPL	Stock	51.0675	51.1138	51.0175	51.0775	2620264.0
2019-04-22 15:30:00	AAPL	Stock	51.0775	51.175	51.075	51.16	4932180.0
2019-04-22 16:00:00	AAPL	Stock	51.1325	51.1575	51.1	51.125	15317152.0
2019-04-22 16:30:00	AAPL	Stock	51.1575	51.215	51.1375	51.145	18624.0
2019-04-22 17:00:00	AAPL	Stock	51.1375	51.1475	51.1	51.1	44548.0
2019-04-22 17:30:00	AAPL	Stock	51.1125	51.125	51.1	51.1	2920.0
2019-04-22 18:00:00	AAPL	Stock	51.1	51.115	51.09	51.115	6576.0
2019-04-22 18:30:00	AAPL	Stock	51.125	51.15	51.125	51.1325	7148.0
2019-04-22 19:00:00	AAPL	Stock	51.135	51.135	51.1	51.1325	13852.0
2019-04-22 19:30:00	AAPL	Stock	51.1325	51.15	51.1325	51.1325	8384.0
2019-04-22 04:30:00	MSFT	Stock	123.14	123.14	123.14	123.14	100.0
2019-04-22 07:00:00	MSFT	Stock	123.49	123.49	123.04	123.07	7427.0
2019-04-22 07:30:00	MSFT	Stock	123.06	123.25	123.06	123.15	7973.0
2019-04-22 08:00:00	MSFT	Stock	123.4	123.45	122.9	123.05	19146.0
2019-04-22 08:30:00	MSFT	Stock	122.99	123.09	122.88	122.92	8371.0
2019-04-22 09:00:00	MSFT	Stock	122.95	123.14	122.63	122.63	29442.0
2019-04-22 09:30:00	MSFT	Stock	122.62	123.41	122.57	123.285	2024206.0
2019-04-22 10:00:00	MSFT	Stock	123.28	123.85	123.28	123.813	1170714.0
2019-04-22 10:30:00	MSFT	Stock	123.82	123.87	123.38	123.7	1055957.0
2019-04-22 11:00:00	MSFT	Stock	123.7	123.99	123.6	123.975	825528.0
2019-04-22 11:30:00	MSFT	Stock	123.98	124.0	123.76	123.795	837784.0
2019-04-22 12:00:00	MSFT	Stock	123.79	123.82	123.6	123.646	653320.0
2019-04-22 12:30:00	MSFT	Stock	123.645	123.76	123.565	123.576	471908.0
2019-04-22 13:00:00	MSFT	Stock	123.58	123.62	123.364	123.37	566618.0
2019-04-22 13:30:00	MSFT	Stock	123.37	123.67	123.365	123.604	674674.0
2019-04-22 14:00:00	MSFT	Stock	123.61	123.7	123.5	123.65	520206.0
2019-04-22 14:30:00	MSFT	Stock	123.65	123.67	123.54	123.597	469985.0
2019-04-22 15:00:00	MSFT	Stock	123.6	123.61	123.46	123.54	628524.0
2019-04-22 15:30:00	MSFT	Stock	123.54	123.77	123.5	123.76	1741603.0
2019-04-22 16:00:00	MSFT	Stock	123.76	123.77	123.66	123.75	1094839.0
2019-04-22 16:30:00	MSFT	Stock	123.71	123.8	123.71	123.8	25134.0
2019-04-22 17:00:00	MSFT	Stock	123.78	123.85	123.78	123.85	4114.0

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

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