PREVIEW / stock_30min / 2019-06-14

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-06-14.parquet
  size:    1.7 MB
  rows:    82,376
  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-06-14 04:00:00	AAPL	Stock	48.1625	48.1625	47.9175	47.96	14468.0
2019-06-14 04:30:00	AAPL	Stock	47.8975	47.905	47.7925	47.7925	10504.0
2019-06-14 05:00:00	AAPL	Stock	47.7925	47.7925	47.6625	47.675	32556.0
2019-06-14 05:30:00	AAPL	Stock	47.7325	47.775	47.67	47.775	12976.0
2019-06-14 06:00:00	AAPL	Stock	47.7625	47.7625	47.585	47.585	18864.0
2019-06-14 06:30:00	AAPL	Stock	47.5825	47.72	47.53	47.6675	16708.0
2019-06-14 07:00:00	AAPL	Stock	47.72	48.06	47.72	47.95	298232.0
2019-06-14 07:30:00	AAPL	Stock	47.9375	48.1	47.8825	48.0775	81792.0
2019-06-14 08:00:00	AAPL	Stock	47.8125	48.0875	47.685	48.04	209836.0
2019-06-14 08:30:00	AAPL	Stock	48.04	48.075	47.875	47.915	181164.0
2019-06-14 09:00:00	AAPL	Stock	47.9148	47.9875	47.8275	47.83	238368.0
2019-06-14 09:30:00	AAPL	Stock	47.905	48.037	47.575	47.6612	12589728.0
2019-06-14 10:00:00	AAPL	Stock	47.66	47.97	47.62	47.9225	6177108.0
2019-06-14 10:30:00	AAPL	Stock	47.92	48.185	47.885	48.1325	5249148.0
2019-06-14 11:00:00	AAPL	Stock	48.1325	48.16	47.8388	48.055	5177128.0
2019-06-14 11:30:00	AAPL	Stock	48.0513	48.1675	48.01	48.0775	3032144.0
2019-06-14 12:00:00	AAPL	Stock	48.075	48.135	48.02	48.0875	1838332.0
2019-06-14 12:30:00	AAPL	Stock	48.088	48.155	48.0525	48.1175	1790000.0
2019-06-14 13:00:00	AAPL	Stock	48.115	48.215	48.095	48.1875	1587612.0
2019-06-14 13:30:00	AAPL	Stock	48.1825	48.235	48.1475	48.15	1668848.0
2019-06-14 14:00:00	AAPL	Stock	48.15	48.2725	48.1425	48.1975	2841592.0
2019-06-14 14:30:00	AAPL	Stock	48.1975	48.255	48.1875	48.2537	2313320.0
2019-06-14 15:00:00	AAPL	Stock	48.25	48.3965	48.2475	48.365	4303436.0
2019-06-14 15:30:00	AAPL	Stock	48.365	48.3775	48.17	48.185	6767116.0
2019-06-14 16:00:00	AAPL	Stock	48.185	48.235	48.1375	48.15	5458020.0
2019-06-14 16:30:00	AAPL	Stock	48.15	48.185	48.1325	48.15	19924.0
2019-06-14 17:00:00	AAPL	Stock	48.1575	48.1625	48.15	48.15	20668.0
2019-06-14 17:30:00	AAPL	Stock	48.145	48.185	48.145	48.185	146624.0
2019-06-14 18:00:00	AAPL	Stock	48.1575	48.1725	48.1575	48.1725	1196.0
2019-06-14 18:30:00	AAPL	Stock	48.1725	48.175	48.1725	48.175	3804.0
2019-06-14 19:00:00	AAPL	Stock	48.175	48.18	48.175	48.18	800.0
2019-06-14 19:30:00	AAPL	Stock	48.185	48.215	48.16	48.215	14568.0
2019-06-14 06:00:00	MSFT	Stock	131.8	131.8	131.73	131.73	2102.0
2019-06-14 07:00:00	MSFT	Stock	131.96	131.99	131.76	131.76	4875.0
2019-06-14 07:30:00	MSFT	Stock	131.95	132.2	131.85	132.1	3473.0
2019-06-14 08:00:00	MSFT	Stock	131.76	132.14	131.76	131.9	13761.0
2019-06-14 08:30:00	MSFT	Stock	131.91	132.1	131.91	132.1	3379.0
2019-06-14 09:00:00	MSFT	Stock	132.01	132.2	132.01	132.13	12821.0
2019-06-14 09:30:00	MSFT	Stock	132.26	132.28	131.64	132.08	1670630.0
2019-06-14 10:00:00	MSFT	Stock	132.07	132.38	131.94	132.27	1343233.0
2019-06-14 10:30:00	MSFT	Stock	132.27	132.91	132.12	132.6	1068857.0
2019-06-14 11:00:00	MSFT	Stock	132.61	132.65	132.08	132.565	956276.0
2019-06-14 11:30:00	MSFT	Stock	132.56	132.83	132.45	132.51	808502.0
2019-06-14 12:00:00	MSFT	Stock	132.508	132.7	132.43	132.6	453842.0
2019-06-14 12:30:00	MSFT	Stock	132.6	132.85	132.59	132.78	384575.0
2019-06-14 13:00:00	MSFT	Stock	132.783	132.9	132.67	132.795	434307.0
2019-06-14 13:30:00	MSFT	Stock	132.8	132.81	132.52	132.53	444056.0
2019-06-14 14:00:00	MSFT	Stock	132.535	133.79	132.5	132.89	1114768.0
2019-06-14 14:30:00	MSFT	Stock	132.88	132.97	132.797	132.925	649723.0
2019-06-14 15:00:00	MSFT	Stock	132.92	133.27	132.91	133.14	947478.0

> showing 50 of 82,376 rows — these rows as CSV

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