PREVIEW / stock_30min / 2019-05-16

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-05-16.parquet
  size:    1.7 MB
  rows:    84,343
  symbols: 2,597

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-16 04:00:00	AAPL	Stock	47.5	47.6175	47.5	47.5875	20352.0
2019-05-16 04:30:00	AAPL	Stock	47.6375	47.655	47.6375	47.655	5288.0
2019-05-16 05:00:00	AAPL	Stock	47.6525	47.6975	47.65	47.6975	3024.0
2019-05-16 05:30:00	AAPL	Stock	47.7475	47.7475	47.7475	47.7475	400.0
2019-05-16 06:00:00	AAPL	Stock	47.705	47.915	47.6975	47.895	21868.0
2019-05-16 06:30:00	AAPL	Stock	47.9125	47.9125	47.8375	47.875	15052.0
2019-05-16 07:00:00	AAPL	Stock	47.8775	47.9425	47.8375	47.9425	193788.0
2019-05-16 07:30:00	AAPL	Stock	47.93	47.96	47.765	47.875	115660.0
2019-05-16 08:00:00	AAPL	Stock	47.8625	47.96	47.625	47.6875	432912.0
2019-05-16 08:30:00	AAPL	Stock	47.6875	47.7425	47.48	47.5525	290940.0
2019-05-16 09:00:00	AAPL	Stock	47.52	47.52	47.3875	47.4975	359116.0
2019-05-16 09:30:00	AAPL	Stock	47.4775	47.5338	47.275	47.4	17279248.0
2019-05-16 10:00:00	AAPL	Stock	47.395	47.6175	47.21	47.6175	11094932.0
2019-05-16 10:30:00	AAPL	Stock	47.615	47.8875	47.555	47.81	9669268.0
2019-05-16 11:00:00	AAPL	Stock	47.81	47.8575	47.725	47.7575	4984632.0
2019-05-16 11:30:00	AAPL	Stock	47.7575	48.025	47.7375	47.9925	5112812.0
2019-05-16 12:00:00	AAPL	Stock	48.0025	48.0962	47.9325	48.055	4128344.0
2019-05-16 12:30:00	AAPL	Stock	48.0625	48.1172	47.8525	47.915	4794980.0
2019-05-16 13:00:00	AAPL	Stock	47.915	47.955	47.775	47.83	4310212.0
2019-05-16 13:30:00	AAPL	Stock	47.8325	47.8325	47.565	47.625	6296788.0
2019-05-16 14:00:00	AAPL	Stock	47.625	47.725	47.5575	47.7025	5106320.0
2019-05-16 14:30:00	AAPL	Stock	47.6975	47.745	47.59	47.6325	4523556.0
2019-05-16 15:00:00	AAPL	Stock	47.6275	47.6825	47.4475	47.4475	7228320.0
2019-05-16 15:30:00	AAPL	Stock	47.445	47.5375	47.2975	47.535	13453996.0
2019-05-16 16:00:00	AAPL	Stock	47.535	47.5425	47.4425	47.525	10979036.0
2019-05-16 16:30:00	AAPL	Stock	47.4625	47.5325	47.4325	47.5	79564.0
2019-05-16 17:00:00	AAPL	Stock	47.5	47.525	47.5	47.5125	13016.0
2019-05-16 17:30:00	AAPL	Stock	47.4775	47.515	47.4475	47.45	17756.0
2019-05-16 18:00:00	AAPL	Stock	47.4525	47.49	47.45	47.4525	8192.0
2019-05-16 18:30:00	AAPL	Stock	47.495	47.4975	47.455	47.455	9544.0
2019-05-16 19:00:00	AAPL	Stock	47.465	47.4875	47.4625	47.4625	16048.0
2019-05-16 19:30:00	AAPL	Stock	47.4625	47.515	47.4625	47.4875	41416.0
2019-05-16 04:00:00	MSFT	Stock	125.71	125.71	125.71	125.71	649.0
2019-05-16 05:00:00	MSFT	Stock	126.2	126.3	126.2	126.3	400.0
2019-05-16 05:30:00	MSFT	Stock	126.3	126.3	126.3	126.3	800.0
2019-05-16 06:00:00	MSFT	Stock	126.43	126.43	126.43	126.43	152.0
2019-05-16 06:30:00	MSFT	Stock	126.8	126.9	126.6	126.65	2511.0
2019-05-16 07:00:00	MSFT	Stock	126.57	126.83	126.54	126.83	3369.0
2019-05-16 07:30:00	MSFT	Stock	126.78	126.78	126.52	126.6	2200.0
2019-05-16 08:00:00	MSFT	Stock	126.6	126.87	126.35	126.5	15525.0
2019-05-16 08:30:00	MSFT	Stock	126.49	126.833	126.0	126.4	44084.0
2019-05-16 09:00:00	MSFT	Stock	126.42	126.75	126.26	126.75	28280.0
2019-05-16 09:30:00	MSFT	Stock	126.75	128.08	126.46	128.023	3055682.0
2019-05-16 10:00:00	MSFT	Stock	128.02	129.15	127.99	129.0	3158634.0
2019-05-16 10:30:00	MSFT	Stock	128.99	129.33	128.91	129.16	2047412.0
2019-05-16 11:00:00	MSFT	Stock	129.16	129.325	128.91	129.0	1439839.0
2019-05-16 11:30:00	MSFT	Stock	129.0	129.34	128.97	129.165	1022833.0
2019-05-16 12:00:00	MSFT	Stock	129.165	129.38	129.09	129.13	996992.0
2019-05-16 12:30:00	MSFT	Stock	129.14	129.235	128.83	128.95	1012002.0
2019-05-16 13:00:00	MSFT	Stock	128.96	129.13	128.78	129.02	903180.0

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

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