PREVIEW / stock_30min / 2020-01-22

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-01-22.parquet
  size:    1.8 MB
  rows:    86,335
  symbols: 2,454

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
2020-01-22 04:00:00	AAPL	Stock	79.5175	79.625	79.5175	79.5575	10700.0
2020-01-22 04:30:00	AAPL	Stock	79.6	79.625	79.6	79.625	14552.0
2020-01-22 05:00:00	AAPL	Stock	79.6875	79.6875	79.625	79.6875	4412.0
2020-01-22 05:30:00	AAPL	Stock	79.67	79.67	79.6275	79.67	5452.0
2020-01-22 06:00:00	AAPL	Stock	79.67	79.775	79.6675	79.75	41308.0
2020-01-22 06:30:00	AAPL	Stock	79.745	79.7925	79.745	79.7925	20908.0
2020-01-22 07:00:00	AAPL	Stock	79.76	79.85	79.75	79.8125	277792.0
2020-01-22 07:30:00	AAPL	Stock	79.8125	79.8575	79.75	79.775	95480.0
2020-01-22 08:00:00	AAPL	Stock	79.7625	79.85	79.34	79.725	338168.0
2020-01-22 08:30:00	AAPL	Stock	79.695	79.73	79.65	79.655	142280.0
2020-01-22 09:00:00	AAPL	Stock	79.655	79.72	79.62	79.6625	165068.0
2020-01-22 09:30:00	AAPL	Stock	79.6475	79.735	79.3275	79.515	12266472.0
2020-01-22 10:00:00	AAPL	Stock	79.5225	79.722	79.38	79.68	7853580.0
2020-01-22 10:30:00	AAPL	Stock	79.6825	79.725	79.455	79.471	5089096.0
2020-01-22 11:00:00	AAPL	Stock	79.4725	79.5575	79.365	79.5205	5284580.0
2020-01-22 11:30:00	AAPL	Stock	79.52	79.6712	79.515	79.63	3598616.0
2020-01-22 12:00:00	AAPL	Stock	79.63	79.6875	79.525	79.6322	3421312.0
2020-01-22 12:30:00	AAPL	Stock	79.6375	79.9375	79.615	79.9075	6860160.0
2020-01-22 13:00:00	AAPL	Stock	79.91	79.9125	79.8025	79.8475	3102600.0
2020-01-22 13:30:00	AAPL	Stock	79.845	79.9725	79.7625	79.768	3807544.0
2020-01-22 14:00:00	AAPL	Stock	79.7725	79.93	79.765	79.8325	2719532.0
2020-01-22 14:30:00	AAPL	Stock	79.828	79.9975	79.75	79.97	4292032.0
2020-01-22 15:00:00	AAPL	Stock	79.975	79.975	79.4125	79.5838	8899288.0
2020-01-22 15:30:00	AAPL	Stock	79.5825	79.745	79.3925	79.425	9534636.0
2020-01-22 16:00:00	AAPL	Stock	79.425	79.455	79.4025	79.42	9748248.0
2020-01-22 16:30:00	AAPL	Stock	79.425	79.4325	79.3	79.35	108816.0
2020-01-22 17:00:00	AAPL	Stock	79.3475	79.4125	79.3475	79.355	22576.0
2020-01-22 17:30:00	AAPL	Stock	79.3575	79.39	79.35	79.37	9956.0
2020-01-22 18:00:00	AAPL	Stock	79.375	79.405	79.365	79.365	34424.0
2020-01-22 18:30:00	AAPL	Stock	79.3775	79.38	79.2875	79.375	104460.0
2020-01-22 19:00:00	AAPL	Stock	79.355	79.45	79.3375	79.3375	65636.0
2020-01-22 19:30:00	AAPL	Stock	79.35	79.4325	79.35	79.375	53560.0
2020-01-22 04:00:00	MSFT	Stock	167.45	167.6	167.4	167.4	4473.0
2020-01-22 04:30:00	MSFT	Stock	167.4	167.4	167.4	167.4	487.0
2020-01-22 05:00:00	MSFT	Stock	167.56	167.56	167.45	167.55	900.0
2020-01-22 05:30:00	MSFT	Stock	167.51	167.51	167.49	167.49	2090.0
2020-01-22 06:00:00	MSFT	Stock	167.54	167.54	167.42	167.49	617.0
2020-01-22 06:30:00	MSFT	Stock	167.49	167.7	167.49	167.7	5788.0
2020-01-22 07:00:00	MSFT	Stock	167.56	167.6	167.4	167.52	30763.0
2020-01-22 07:30:00	MSFT	Stock	167.56	167.6	167.43	167.49	14379.0
2020-01-22 08:00:00	MSFT	Stock	167.481	167.6	166.91	167.38	29746.0
2020-01-22 08:30:00	MSFT	Stock	167.46	167.46	167.26	167.431	9866.0
2020-01-22 09:00:00	MSFT	Stock	167.35	167.44	167.23	167.26	18953.0
2020-01-22 09:30:00	MSFT	Stock	167.26	167.49	166.87	167.39	2325731.0
2020-01-22 10:00:00	MSFT	Stock	167.4	167.41	167.0	167.115	1499146.0
2020-01-22 10:30:00	MSFT	Stock	167.11	167.17	166.865	166.87	1247316.0
2020-01-22 11:00:00	MSFT	Stock	166.87	166.93	166.34	166.39	1301519.0
2020-01-22 11:30:00	MSFT	Stock	166.39	166.617	166.09	166.251	853945.0
2020-01-22 12:00:00	MSFT	Stock	166.26	166.5	165.9	165.935	1281106.0
2020-01-22 12:30:00	MSFT	Stock	165.935	166.61	165.92	166.565	829083.0

> showing 50 of 86,335 rows — these rows as CSV

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