PREVIEW / stock_30min / 2019-05-01

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-05-01.parquet
  size:    1.7 MB
  rows:    83,773
  symbols: 2,624

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-05-01 04:00:00	AAPL	Stock	52.7	52.8	52.7	52.8	32180.0
2019-05-01 04:30:00	AAPL	Stock	52.82	52.85	52.8	52.8	5600.0
2019-05-01 05:00:00	AAPL	Stock	52.7825	52.9175	52.75	52.9175	35208.0
2019-05-01 05:30:00	AAPL	Stock	52.925	53.0	52.9	53.0	17212.0
2019-05-01 06:00:00	AAPL	Stock	53.0	53.0275	52.975	53.0	36708.0
2019-05-01 06:30:00	AAPL	Stock	53.025	53.1675	53.0075	53.1075	85408.0
2019-05-01 07:00:00	AAPL	Stock	53.1	53.1875	53.0	53.0975	482700.0
2019-05-01 07:30:00	AAPL	Stock	53.055	53.0675	52.8525	52.875	432328.0
2019-05-01 08:00:00	AAPL	Stock	53.0225	53.1875	52.7	52.82	1197044.0
2019-05-01 08:30:00	AAPL	Stock	52.8125	52.8322	52.62	52.65	976544.0
2019-05-01 09:00:00	AAPL	Stock	52.65	52.855	52.465	52.465	2709872.0
2019-05-01 09:30:00	AAPL	Stock	52.47	53.0125	52.3075	52.8075	45712064.0
2019-05-01 10:00:00	AAPL	Stock	52.8	53.2225	52.73	53.1625	21448288.0
2019-05-01 10:30:00	AAPL	Stock	53.16	53.345	53.1	53.265	13933308.0
2019-05-01 11:00:00	AAPL	Stock	53.2675	53.73	53.25	53.605	17313264.0
2019-05-01 11:30:00	AAPL	Stock	53.61	53.8275	53.555	53.7115	15187864.0
2019-05-01 12:00:00	AAPL	Stock	53.72	53.7675	53.42	53.5275	11688532.0
2019-05-01 12:30:00	AAPL	Stock	53.5275	53.59	53.315	53.48	8572880.0
2019-05-01 13:00:00	AAPL	Stock	53.49	53.67	53.45	53.5325	7230672.0
2019-05-01 13:30:00	AAPL	Stock	53.5325	53.575	53.4325	53.5625	4770308.0
2019-05-01 14:00:00	AAPL	Stock	53.5625	53.775	53.5225	53.7075	9846752.0
2019-05-01 14:30:00	AAPL	Stock	53.7075	53.73	53.3575	53.535	10370704.0
2019-05-01 15:00:00	AAPL	Stock	53.53	53.7	53.4175	53.436	10036520.0
2019-05-01 15:30:00	AAPL	Stock	53.435	53.435	52.6125	52.63	29373364.0
2019-05-01 16:00:00	AAPL	Stock	52.63	52.7	52.5675	52.67	11067872.0
2019-05-01 16:30:00	AAPL	Stock	52.6525	52.68	52.5625	52.6	542612.0
2019-05-01 17:00:00	AAPL	Stock	52.595	52.5975	52.515	52.525	166008.0
2019-05-01 17:30:00	AAPL	Stock	52.5175	52.63	52.47	52.47	154596.0
2019-05-01 18:00:00	AAPL	Stock	52.4975	52.5675	52.475	52.5375	138380.0
2019-05-01 18:30:00	AAPL	Stock	52.5375	52.625	52.5375	52.62	101324.0
2019-05-01 19:00:00	AAPL	Stock	52.6075	52.65	52.6075	52.63	83716.0
2019-05-01 19:30:00	AAPL	Stock	52.63	52.6825	52.63	52.6625	94280.0
2019-05-01 04:00:00	MSFT	Stock	131.23	131.23	131.23	131.23	100.0
2019-05-01 04:30:00	MSFT	Stock	131.0	131.0	131.0	131.0	100.0
2019-05-01 05:30:00	MSFT	Stock	131.0	131.0	131.0	131.0	100.0
2019-05-01 06:30:00	MSFT	Stock	130.99	130.99	130.86	130.86	350.0
2019-05-01 07:00:00	MSFT	Stock	130.86	130.95	130.65	130.75	13361.0
2019-05-01 07:30:00	MSFT	Stock	130.8	130.8	130.72	130.77	2228.0
2019-05-01 08:00:00	MSFT	Stock	130.989	130.99	130.7	130.85	8584.0
2019-05-01 08:30:00	MSFT	Stock	130.92	130.92	130.76	130.85	6714.0
2019-05-01 09:00:00	MSFT	Stock	130.76	130.83	130.51	130.54	18149.0
2019-05-01 09:30:00	MSFT	Stock	130.55	130.65	129.594	129.87	2941864.0
2019-05-01 10:00:00	MSFT	Stock	129.87	130.0	129.49	129.845	1527847.0
2019-05-01 10:30:00	MSFT	Stock	129.85	129.89	129.62	129.637	732975.0
2019-05-01 11:00:00	MSFT	Stock	129.636	129.81	129.582	129.795	987145.0
2019-05-01 11:30:00	MSFT	Stock	129.797	129.97	129.7	129.73	912170.0
2019-05-01 12:00:00	MSFT	Stock	129.73	129.8	129.53	129.639	813145.0
2019-05-01 12:30:00	MSFT	Stock	129.63	129.65	129.34	129.535	1032149.0
2019-05-01 13:00:00	MSFT	Stock	129.535	129.75	129.35	129.403	806307.0
2019-05-01 13:30:00	MSFT	Stock	129.41	129.45	129.25	129.417	651546.0

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

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