PREVIEW / stock_30min / 2019-12-13

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-12-13.parquet
  size:    1.8 MB
  rows:    86,121
  symbols: 2,500

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-12-13 04:00:00	AAPL	Stock	68.285	68.4575	68.2525	68.35	10748.0
2019-12-13 04:30:00	AAPL	Stock	68.3525	68.4	68.325	68.325	7652.0
2019-12-13 05:00:00	AAPL	Stock	68.33	68.3875	68.33	68.3875	13740.0
2019-12-13 05:30:00	AAPL	Stock	68.3825	68.4	68.365	68.3875	5088.0
2019-12-13 06:00:00	AAPL	Stock	68.385	68.385	68.275	68.28	25468.0
2019-12-13 06:30:00	AAPL	Stock	68.2875	68.2875	68.15	68.195	21708.0
2019-12-13 07:00:00	AAPL	Stock	68.2375	68.2975	68.1375	68.1625	110364.0
2019-12-13 07:30:00	AAPL	Stock	68.1625	68.25	67.675	67.875	204008.0
2019-12-13 08:00:00	AAPL	Stock	67.9475	68.2975	67.7475	68.1475	368864.0
2019-12-13 08:30:00	AAPL	Stock	68.1275	68.25	68.1125	68.1425	286844.0
2019-12-13 09:00:00	AAPL	Stock	68.14	68.185	67.7	67.8625	901744.0
2019-12-13 09:30:00	AAPL	Stock	67.865	68.3925	67.7325	68.2275	14142696.0
2019-12-13 10:00:00	AAPL	Stock	68.2325	68.7	68.1775	68.5825	18675980.0
2019-12-13 10:30:00	AAPL	Stock	68.58	68.59	68.08	68.175	10781856.0
2019-12-13 11:00:00	AAPL	Stock	68.175	68.3548	68.0075	68.03	6977148.0
2019-12-13 11:30:00	AAPL	Stock	68.0275	68.58	68.025	68.565	9603676.0
2019-12-13 12:00:00	AAPL	Stock	68.565	68.685	68.49	68.6825	6790744.0
2019-12-13 12:30:00	AAPL	Stock	68.6825	68.745	68.61	68.7382	4922832.0
2019-12-13 13:00:00	AAPL	Stock	68.7375	68.75	68.6025	68.6688	3901864.0
2019-12-13 13:30:00	AAPL	Stock	68.6665	68.7275	68.5775	68.68	3656640.0
2019-12-13 14:00:00	AAPL	Stock	68.675	68.69	68.58	68.585	2676196.0
2019-12-13 14:30:00	AAPL	Stock	68.5875	68.635	68.4325	68.6188	4651096.0
2019-12-13 15:00:00	AAPL	Stock	68.6175	68.735	68.5575	68.715	4914984.0
2019-12-13 15:30:00	AAPL	Stock	68.7125	68.825	68.6925	68.815	11679308.0
2019-12-13 16:00:00	AAPL	Stock	68.8175	68.8225	68.76	68.775	7782540.0
2019-12-13 16:30:00	AAPL	Stock	68.775	68.81	68.77	68.775	227400.0
2019-12-13 17:00:00	AAPL	Stock	68.765	68.775	68.75	68.76	45244.0
2019-12-13 17:30:00	AAPL	Stock	68.775	68.805	68.775	68.79	57016.0
2019-12-13 18:00:00	AAPL	Stock	68.7925	68.795	68.7875	68.7875	43176.0
2019-12-13 18:30:00	AAPL	Stock	68.7875	68.795	68.775	68.775	14816.0
2019-12-13 19:00:00	AAPL	Stock	68.7925	68.7925	68.775	68.7875	12840.0
2019-12-13 19:30:00	AAPL	Stock	68.7925	68.825	68.7875	68.825	54364.0
2019-12-13 04:00:00	MSFT	Stock	153.88	154.0	153.88	153.9	3265.0
2019-12-13 04:30:00	MSFT	Stock	153.95	153.95	153.8	153.9	924.0
2019-12-13 05:00:00	MSFT	Stock	153.9	154.0	153.9	154.0	775.0
2019-12-13 05:30:00	MSFT	Stock	154.04	154.12	154.04	154.07	2873.0
2019-12-13 06:00:00	MSFT	Stock	154.0	154.04	153.91	153.91	1427.0
2019-12-13 06:30:00	MSFT	Stock	153.93	153.93	153.9	153.9	700.0
2019-12-13 07:00:00	MSFT	Stock	153.88	153.88	153.64	153.7	14143.0
2019-12-13 07:30:00	MSFT	Stock	153.7	153.7	153.21	153.35	9914.0
2019-12-13 08:00:00	MSFT	Stock	153.884	153.9	153.21	153.48	23618.0
2019-12-13 08:30:00	MSFT	Stock	153.5	153.7	153.5	153.508	23301.0
2019-12-13 09:00:00	MSFT	Stock	153.617	153.7	152.5	153.3	85467.0
2019-12-13 09:30:00	MSFT	Stock	153.12	153.79	152.83	153.6	1941236.0
2019-12-13 10:00:00	MSFT	Stock	153.59	154.31	153.43	154.19	2878310.0
2019-12-13 10:30:00	MSFT	Stock	154.18	154.6	153.73	153.93	2331064.0
2019-12-13 11:00:00	MSFT	Stock	153.94	154.52	153.87	154.04	1340230.0
2019-12-13 11:30:00	MSFT	Stock	154.03	154.66	153.995	154.66	1073666.0
2019-12-13 12:00:00	MSFT	Stock	154.67	154.89	154.6	154.68	1005103.0
2019-12-13 12:30:00	MSFT	Stock	154.68	154.86	154.565	154.835	743575.0

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

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