PREVIEW / stock_30min / 2019-12-04

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-12-04.parquet
  size:    1.8 MB
  rows:    86,618
  symbols: 2,503

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-04 04:00:00	AAPL	Stock	64.855	65.35	64.855	65.25	11492.0
2019-12-04 04:30:00	AAPL	Stock	65.2875	65.3475	65.1125	65.3475	48668.0
2019-12-04 05:00:00	AAPL	Stock	65.3375	65.35	65.2825	65.3225	11388.0
2019-12-04 05:30:00	AAPL	Stock	65.3375	65.3375	65.25	65.28	8312.0
2019-12-04 06:00:00	AAPL	Stock	65.285	65.3375	65.2525	65.3375	18692.0
2019-12-04 06:30:00	AAPL	Stock	65.335	65.35	65.3025	65.35	13004.0
2019-12-04 07:00:00	AAPL	Stock	65.3525	65.545	65.35	65.4975	159916.0
2019-12-04 07:30:00	AAPL	Stock	65.4975	65.5	65.3	65.4125	147564.0
2019-12-04 08:00:00	AAPL	Stock	65.3875	65.5458	65.24	65.3375	369632.0
2019-12-04 08:30:00	AAPL	Stock	65.3125	65.3875	65.18	65.3875	215552.0
2019-12-04 09:00:00	AAPL	Stock	65.375	65.4725	65.2525	65.275	227668.0
2019-12-04 09:30:00	AAPL	Stock	65.2675	65.47	65.17	65.37	9638540.0
2019-12-04 10:00:00	AAPL	Stock	65.37	65.44	65.28	65.3325	4397620.0
2019-12-04 10:30:00	AAPL	Stock	65.3325	65.5375	65.3125	65.5375	3737392.0
2019-12-04 11:00:00	AAPL	Stock	65.537	65.73	65.515	65.6975	5174464.0
2019-12-04 11:30:00	AAPL	Stock	65.6975	65.8275	65.6725	65.7148	4034840.0
2019-12-04 12:00:00	AAPL	Stock	65.7175	65.73	65.5325	65.6225	3291640.0
2019-12-04 12:30:00	AAPL	Stock	65.6225	65.74	65.6075	65.705	2464612.0
2019-12-04 13:00:00	AAPL	Stock	65.705	65.7083	65.5625	65.5803	1647260.0
2019-12-04 13:30:00	AAPL	Stock	65.5825	65.5975	65.52	65.573	1474860.0
2019-12-04 14:00:00	AAPL	Stock	65.575	65.665	65.5485	65.6585	2518904.0
2019-12-04 14:30:00	AAPL	Stock	65.6582	65.745	65.65	65.7125	2201936.0
2019-12-04 15:00:00	AAPL	Stock	65.71	65.7175	65.5625	65.5725	2556516.0
2019-12-04 15:30:00	AAPL	Stock	65.575	65.6	65.435	65.435	5180824.0
2019-12-04 16:00:00	AAPL	Stock	65.435	65.445	64.8625	65.35	6132692.0
2019-12-04 16:30:00	AAPL	Stock	65.3675	65.435	65.345	65.38	50016.0
2019-12-04 17:00:00	AAPL	Stock	65.3675	65.385	65.3675	65.385	7620.0
2019-12-04 17:30:00	AAPL	Stock	65.38	65.435	65.3025	65.3675	77376.0
2019-12-04 18:00:00	AAPL	Stock	65.365	65.3925	65.35	65.385	17240.0
2019-12-04 18:30:00	AAPL	Stock	65.375	65.375	65.335	65.3525	6328.0
2019-12-04 19:00:00	AAPL	Stock	65.3325	65.35	65.325	65.35	20680.0
2019-12-04 19:30:00	AAPL	Stock	65.35	65.375	65.3175	65.375	6684.0
2019-12-04 04:00:00	MSFT	Stock	149.85	150.19	149.85	150.19	1900.0
2019-12-04 04:30:00	MSFT	Stock	150.2	150.2	150.09	150.09	500.0
2019-12-04 05:00:00	MSFT	Stock	150.24	150.36	150.04	150.36	6408.0
2019-12-04 05:30:00	MSFT	Stock	150.36	150.45	150.31	150.38	2000.0
2019-12-04 06:30:00	MSFT	Stock	150.36	150.5	150.36	150.49	1100.0
2019-12-04 07:00:00	MSFT	Stock	150.45	150.45	150.2	150.3	21538.0
2019-12-04 07:30:00	MSFT	Stock	150.28	150.28	150.0	150.1	6166.0
2019-12-04 08:00:00	MSFT	Stock	150.388	150.388	149.6	150.0	28406.0
2019-12-04 08:30:00	MSFT	Stock	150.08	150.185	149.85	150.185	7977.0
2019-12-04 09:00:00	MSFT	Stock	150.08	150.4	149.99	150.06	23544.0
2019-12-04 09:30:00	MSFT	Stock	150.06	150.18	149.2	149.73	2397040.0
2019-12-04 10:00:00	MSFT	Stock	149.7	149.809	149.354	149.45	1279756.0
2019-12-04 10:30:00	MSFT	Stock	149.45	149.79	149.25	149.76	1082527.0
2019-12-04 11:00:00	MSFT	Stock	149.765	149.8	149.5	149.72	1211044.0
2019-12-04 11:30:00	MSFT	Stock	149.71	149.98	149.71	149.75	633923.0
2019-12-04 12:00:00	MSFT	Stock	149.76	149.79	149.311	149.34	813434.0
2019-12-04 12:30:00	MSFT	Stock	149.35	149.58	149.31	149.53	517768.0
2019-12-04 13:00:00	MSFT	Stock	149.53	149.64	149.36	149.6	672080.0

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

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