PREVIEW / stock_30min / 2019-11-21

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-11-21.parquet
  size:    1.7 MB
  rows:    83,908
  symbols: 2,488

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-11-21 04:00:00	AAPL	Stock	65.8375	65.8375	65.825	65.825	1200.0
2019-11-21 04:30:00	AAPL	Stock	66.005	66.005	65.9125	65.9125	3908.0
2019-11-21 05:00:00	AAPL	Stock	66.075	66.075	66.075	66.075	400.0
2019-11-21 05:30:00	AAPL	Stock	66.09	66.1275	65.9625	66.0725	21416.0
2019-11-21 06:00:00	AAPL	Stock	66.05	66.07	66.05	66.07	2800.0
2019-11-21 06:30:00	AAPL	Stock	66.07	66.1375	66.07	66.125	4844.0
2019-11-21 07:00:00	AAPL	Stock	66.1	66.25	66.075	66.075	59068.0
2019-11-21 07:30:00	AAPL	Stock	66.0725	66.11	66.035	66.11	48492.0
2019-11-21 08:00:00	AAPL	Stock	66.204	66.375	66.025	66.325	266272.0
2019-11-21 08:30:00	AAPL	Stock	66.305	66.305	66.1375	66.1425	96984.0
2019-11-21 09:00:00	AAPL	Stock	66.14	66.1625	65.7975	65.875	2584092.0
2019-11-21 09:30:00	AAPL	Stock	65.995	65.9975	65.713	65.8712	9509752.0
2019-11-21 10:00:00	AAPL	Stock	65.8725	66.0012	65.6375	65.665	6173812.0
2019-11-21 10:30:00	AAPL	Stock	65.6625	65.7425	65.55	65.6118	4491468.0
2019-11-21 11:00:00	AAPL	Stock	65.615	65.7	65.515	65.5525	3551048.0
2019-11-21 11:30:00	AAPL	Stock	65.5475	65.575	65.2975	65.3175	4954668.0
2019-11-21 12:00:00	AAPL	Stock	65.315	65.58	65.295	65.5375	3687384.0
2019-11-21 12:30:00	AAPL	Stock	65.5375	65.6125	65.4825	65.5475	2194400.0
2019-11-21 13:00:00	AAPL	Stock	65.5475	65.62	65.5225	65.5725	1860608.0
2019-11-21 13:30:00	AAPL	Stock	65.575	65.5825	65.46	65.48	2393736.0
2019-11-21 14:00:00	AAPL	Stock	65.4838	65.65	65.375	65.5945	2946272.0
2019-11-21 14:30:00	AAPL	Stock	65.5925	65.6175	65.525	65.59	2094904.0
2019-11-21 15:00:00	AAPL	Stock	65.5875	65.6378	65.5425	65.5912	2451788.0
2019-11-21 15:30:00	AAPL	Stock	65.59	65.6075	65.3175	65.5025	9484248.0
2019-11-21 16:00:00	AAPL	Stock	65.5025	65.6	65.4625	65.5125	15786968.0
2019-11-21 16:30:00	AAPL	Stock	65.52	65.5225	65.5025	65.5225	36544.0
2019-11-21 17:00:00	AAPL	Stock	65.525	65.5325	65.5025	65.515	10444.0
2019-11-21 17:30:00	AAPL	Stock	65.525	65.525	65.5025	65.5225	13984.0
2019-11-21 18:00:00	AAPL	Stock	65.525	65.5625	65.525	65.5525	20292.0
2019-11-21 18:30:00	AAPL	Stock	65.5525	65.5625	65.5125	65.5625	10140.0
2019-11-21 19:00:00	AAPL	Stock	65.5125	65.545	65.5025	65.515	31948.0
2019-11-21 19:30:00	AAPL	Stock	65.505	65.61	65.505	65.565	23784.0
2019-11-21 04:30:00	MSFT	Stock	149.3	149.34	149.3	149.34	1150.0
2019-11-21 05:00:00	MSFT	Stock	149.35	149.78	149.35	149.78	1014.0
2019-11-21 06:00:00	MSFT	Stock	149.41	149.41	149.41	149.41	100.0
2019-11-21 07:00:00	MSFT	Stock	149.5	149.5	149.32	149.32	3268.0
2019-11-21 07:30:00	MSFT	Stock	149.4	149.4	149.4	149.4	600.0
2019-11-21 08:00:00	MSFT	Stock	149.49	149.78	149.28	149.6	21848.0
2019-11-21 08:30:00	MSFT	Stock	149.57	149.64	149.55	149.6	3998.0
2019-11-21 09:00:00	MSFT	Stock	149.55	149.65	149.5	149.54	25616.0
2019-11-21 09:30:00	MSFT	Stock	149.46	149.77	149.1	149.17	1647722.0
2019-11-21 10:00:00	MSFT	Stock	149.16	149.33	148.82	148.92	1123244.0
2019-11-21 10:30:00	MSFT	Stock	148.91	148.99	148.501	148.965	919358.0
2019-11-21 11:00:00	MSFT	Stock	148.97	149.385	148.93	149.27	791240.0
2019-11-21 11:30:00	MSFT	Stock	149.273	149.33	148.98	149.03	535040.0
2019-11-21 12:00:00	MSFT	Stock	149.04	149.312	148.99	149.27	449296.0
2019-11-21 12:30:00	MSFT	Stock	149.28	149.57	149.25	149.564	501225.0
2019-11-21 13:00:00	MSFT	Stock	149.57	149.66	149.51	149.545	376814.0
2019-11-21 13:30:00	MSFT	Stock	149.545	149.57	149.25	149.31	407905.0
2019-11-21 14:00:00	MSFT	Stock	149.314	149.65	149.245	149.59	529026.0

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

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