PREVIEW / stock_30min / 2019-03-14

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-03-14.parquet
  size:    1.7 MB
  rows:    83,986
  symbols: 2,645

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-03-14 04:30:00	AAPL	Stock	45.7275	45.7325	45.7275	45.7325	800.0
2019-03-14 05:00:00	AAPL	Stock	45.725	45.8025	45.695	45.7875	19620.0
2019-03-14 05:30:00	AAPL	Stock	45.7525	45.82	45.7525	45.8	8000.0
2019-03-14 06:00:00	AAPL	Stock	45.825	45.825	45.6375	45.6375	136292.0
2019-03-14 06:30:00	AAPL	Stock	45.6725	45.865	45.6725	45.78	107568.0
2019-03-14 07:00:00	AAPL	Stock	45.78	45.86	45.7675	45.86	140812.0
2019-03-14 07:30:00	AAPL	Stock	45.8475	45.9625	45.8275	45.9375	162376.0
2019-03-14 08:00:00	AAPL	Stock	45.8022	45.9875	45.5425	45.93	331256.0
2019-03-14 08:30:00	AAPL	Stock	45.9425	46.0	45.89	45.975	253828.0
2019-03-14 09:00:00	AAPL	Stock	45.9525	46.045	45.95	45.9825	629444.0
2019-03-14 09:30:00	AAPL	Stock	45.975	45.9975	45.675	45.8875	15335520.0
2019-03-14 10:00:00	AAPL	Stock	45.8925	45.8925	45.64	45.79	6966684.0
2019-03-14 10:30:00	AAPL	Stock	45.79	45.875	45.6975	45.7562	5464372.0
2019-03-14 11:00:00	AAPL	Stock	45.7575	45.845	45.7025	45.7925	4149864.0
2019-03-14 11:30:00	AAPL	Stock	45.7925	45.9325	45.7775	45.8675	4699184.0
2019-03-14 12:00:00	AAPL	Stock	45.8675	46.025	45.8575	45.9562	6242772.0
2019-03-14 12:30:00	AAPL	Stock	45.955	45.98	45.9225	45.965	2809892.0
2019-03-14 13:00:00	AAPL	Stock	45.965	45.97	45.855	45.9358	3215332.0
2019-03-14 13:30:00	AAPL	Stock	45.9375	45.965	45.895	45.9075	2474124.0
2019-03-14 14:00:00	AAPL	Stock	45.9062	45.9925	45.9038	45.9875	2641308.0
2019-03-14 14:30:00	AAPL	Stock	45.9888	45.9925	45.925	45.9375	3230488.0
2019-03-14 15:00:00	AAPL	Stock	45.9375	45.97	45.86	45.89	3519004.0
2019-03-14 15:30:00	AAPL	Stock	45.8912	46.0025	45.8775	45.9325	9354116.0
2019-03-14 16:00:00	AAPL	Stock	45.9325	45.995	45.8775	45.9	12906620.0
2019-03-14 16:30:00	AAPL	Stock	45.925	45.95	45.89	45.925	93328.0
2019-03-14 17:00:00	AAPL	Stock	45.925	45.9375	45.895	45.9375	67984.0
2019-03-14 17:30:00	AAPL	Stock	45.9375	45.9375	45.9025	45.92	13688.0
2019-03-14 18:00:00	AAPL	Stock	45.92	45.9925	45.905	45.9875	27592.0
2019-03-14 18:30:00	AAPL	Stock	45.9725	45.995	45.9425	45.9925	21360.0
2019-03-14 19:00:00	AAPL	Stock	45.9925	46.025	45.965	45.9975	36652.0
2019-03-14 19:30:00	AAPL	Stock	45.9975	46.05	45.98	46.0125	77964.0
2019-03-14 04:00:00	MSFT	Stock	114.76	114.76	114.76	114.76	500.0
2019-03-14 04:30:00	MSFT	Stock	115.0	115.0	115.0	115.0	700.0
2019-03-14 05:00:00	MSFT	Stock	115.0	115.0	115.0	115.0	197.0
2019-03-14 05:30:00	MSFT	Stock	115.0	115.0	115.0	115.0	2701.0
2019-03-14 06:00:00	MSFT	Stock	114.87	114.88	114.69	114.75	6583.0
2019-03-14 06:30:00	MSFT	Stock	114.7	114.7	114.5	114.5	2000.0
2019-03-14 07:00:00	MSFT	Stock	114.57	114.84	114.57	114.79	12515.0
2019-03-14 07:30:00	MSFT	Stock	114.72	114.83	114.65	114.75	9230.0
2019-03-14 08:00:00	MSFT	Stock	114.65	114.9	114.65	114.77	16163.0
2019-03-14 08:30:00	MSFT	Stock	114.79	114.82	114.7	114.75	21476.0
2019-03-14 09:00:00	MSFT	Stock	114.76	114.8	114.35	114.53	20409.0
2019-03-14 09:30:00	MSFT	Stock	114.54	114.95	114.33	114.74	2105315.0
2019-03-14 10:00:00	MSFT	Stock	114.74	114.84	114.35	114.77	1170263.0
2019-03-14 10:30:00	MSFT	Stock	114.77	114.93	114.62	114.745	955670.0
2019-03-14 11:00:00	MSFT	Stock	114.74	114.99	114.63	114.865	903084.0
2019-03-14 11:30:00	MSFT	Stock	114.864	115.08	114.86	115.047	1587383.0
2019-03-14 12:00:00	MSFT	Stock	115.05	115.2	114.845	114.85	921677.0
2019-03-14 12:30:00	MSFT	Stock	114.85	115.025	114.79	114.935	663663.0
2019-03-14 13:00:00	MSFT	Stock	114.93	114.96	114.81	114.9	564296.0

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

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