PREVIEW / stock_30min / 2018-09-13

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-09-13.parquet
  size:    1.7 MB
  rows:    83,867
  symbols: 2,795

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
2018-09-13 04:00:00	AAPL	Stock	55.425	55.5	55.375	55.5	12532.0
2018-09-13 04:30:00	AAPL	Stock	55.5	55.5	55.4375	55.4975	15660.0
2018-09-13 05:00:00	AAPL	Stock	55.4625	55.5	55.3875	55.3875	25140.0
2018-09-13 05:30:00	AAPL	Stock	55.375	55.385	55.25	55.325	100912.0
2018-09-13 06:00:00	AAPL	Stock	55.375	55.4975	55.375	55.4975	31880.0
2018-09-13 06:30:00	AAPL	Stock	55.525	55.625	55.525	55.6175	30792.0
2018-09-13 07:00:00	AAPL	Stock	55.5975	55.7325	55.575	55.625	142572.0
2018-09-13 07:30:00	AAPL	Stock	55.605	55.735	55.59	55.6925	145248.0
2018-09-13 08:00:00	AAPL	Stock	55.707	55.73	55.5675	55.6575	407536.0
2018-09-13 08:30:00	AAPL	Stock	55.665	55.91	55.625	55.85	686764.0
2018-09-13 09:00:00	AAPL	Stock	55.8425	55.885	55.2675	55.885	1062396.0
2018-09-13 09:30:00	AAPL	Stock	55.88	56.3225	55.6425	55.97	21532360.0
2018-09-13 10:00:00	AAPL	Stock	55.97	56.425	55.95	56.3	16082196.0
2018-09-13 10:30:00	AAPL	Stock	56.2975	56.5475	56.2375	56.475	11598236.0
2018-09-13 11:00:00	AAPL	Stock	56.4775	56.8	56.4	56.685	12564684.0
2018-09-13 11:30:00	AAPL	Stock	56.6875	56.955	56.635	56.89	8459960.0
2018-09-13 12:00:00	AAPL	Stock	56.892	57.0875	56.8475	56.8825	9532352.0
2018-09-13 12:30:00	AAPL	Stock	56.885	56.97	56.7025	56.7525	5572188.0
2018-09-13 13:00:00	AAPL	Stock	56.7525	56.8362	56.5375	56.6225	6710772.0
2018-09-13 13:30:00	AAPL	Stock	56.625	56.655	56.4	56.5822	5979520.0
2018-09-13 14:00:00	AAPL	Stock	56.58	56.7275	56.3	56.5352	7098008.0
2018-09-13 14:30:00	AAPL	Stock	56.5355	56.6575	56.4182	56.445	4644108.0
2018-09-13 15:00:00	AAPL	Stock	56.4475	56.46	56.2625	56.3475	5929012.0
2018-09-13 15:30:00	AAPL	Stock	56.3465	56.61	56.3225	56.6	10646992.0
2018-09-13 16:00:00	AAPL	Stock	56.6575	56.6575	56.5975	56.6425	13186632.0
2018-09-13 16:30:00	AAPL	Stock	56.6425	56.735	56.6025	56.6725	243760.0
2018-09-13 17:00:00	AAPL	Stock	56.6525	56.69	56.625	56.655	16924.0
2018-09-13 17:30:00	AAPL	Stock	56.655	56.6875	56.625	56.665	42996.0
2018-09-13 18:00:00	AAPL	Stock	56.6375	56.8	56.6375	56.77	65724.0
2018-09-13 18:30:00	AAPL	Stock	56.755	56.775	56.7275	56.7525	77120.0
2018-09-13 19:00:00	AAPL	Stock	56.7725	56.7725	56.75	56.75	35600.0
2018-09-13 19:30:00	AAPL	Stock	56.75	56.77	56.7025	56.7375	48232.0
2018-09-13 04:00:00	MSFT	Stock	111.8	111.8	111.8	111.8	200.0
2018-09-13 05:00:00	MSFT	Stock	112.0	112.17	112.0	112.17	997.0
2018-09-13 05:30:00	MSFT	Stock	112.01	112.01	112.01	112.01	200.0
2018-09-13 06:00:00	MSFT	Stock	112.2	112.2	112.2	112.2	1300.0
2018-09-13 06:30:00	MSFT	Stock	112.2	112.2	112.2	112.2	4342.0
2018-09-13 07:00:00	MSFT	Stock	112.11	112.3	112.11	112.3	6309.0
2018-09-13 07:30:00	MSFT	Stock	112.29	112.3	112.0	112.01	7290.0
2018-09-13 08:00:00	MSFT	Stock	112.3	112.35	112.03	112.1	4361.0
2018-09-13 08:30:00	MSFT	Stock	112.17	112.29	112.05	112.18	16870.0
2018-09-13 09:00:00	MSFT	Stock	112.17	112.295	112.08	112.08	16316.0
2018-09-13 09:30:00	MSFT	Stock	112.12	113.725	112.12	113.03	4104759.0
2018-09-13 10:00:00	MSFT	Stock	113.04	113.5	112.92	113.16	2182052.0
2018-09-13 10:30:00	MSFT	Stock	113.16	113.235	112.49	112.905	1667401.0
2018-09-13 11:00:00	MSFT	Stock	112.91	113.2	112.72	112.82	1690181.0
2018-09-13 11:30:00	MSFT	Stock	112.815	113.03	112.65	112.915	1091801.0
2018-09-13 12:00:00	MSFT	Stock	112.915	113.06	112.79	112.795	830515.0
2018-09-13 12:30:00	MSFT	Stock	112.8	112.92	112.68	112.7	654805.0
2018-09-13 13:00:00	MSFT	Stock	112.705	112.92	112.61	112.9	640388.0

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

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