PREVIEW / stock_30min / 2018-08-28

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-08-28.parquet
  size:    1.7 MB
  rows:    83,194
  symbols: 2,802

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-08-28 04:00:00	AAPL	Stock	54.575	54.575	54.575	54.575	7388.0
2018-08-28 04:30:00	AAPL	Stock	54.6475	54.6625	54.6475	54.6625	20364.0
2018-08-28 05:00:00	AAPL	Stock	54.675	54.675	54.675	54.675	456.0
2018-08-28 05:30:00	AAPL	Stock	54.625	54.625	54.625	54.625	6560.0
2018-08-28 06:00:00	AAPL	Stock	54.6625	54.6625	54.6625	54.6625	2000.0
2018-08-28 06:30:00	AAPL	Stock	54.65	54.66	54.6125	54.625	4400.0
2018-08-28 07:00:00	AAPL	Stock	54.62	54.675	54.615	54.67	65548.0
2018-08-28 07:30:00	AAPL	Stock	54.65	54.71	54.6325	54.71	64820.0
2018-08-28 08:00:00	AAPL	Stock	54.6375	54.8175	54.6125	54.7575	311036.0
2018-08-28 08:30:00	AAPL	Stock	54.765	54.775	54.7025	54.72	243396.0
2018-08-28 09:00:00	AAPL	Stock	54.7375	54.7875	54.7175	54.755	207424.0
2018-08-28 09:30:00	AAPL	Stock	54.7525	54.9725	54.73	54.868	15140704.0
2018-08-28 10:00:00	AAPL	Stock	54.87	54.96	54.8325	54.8775	7513308.0
2018-08-28 10:30:00	AAPL	Stock	54.8775	54.945	54.8525	54.935	4572076.0
2018-08-28 11:00:00	AAPL	Stock	54.935	54.9375	54.8525	54.8675	4188508.0
2018-08-28 11:30:00	AAPL	Stock	54.87	54.9	54.77	54.805	4580192.0
2018-08-28 12:00:00	AAPL	Stock	54.8075	54.9225	54.7725	54.8925	3149264.0
2018-08-28 12:30:00	AAPL	Stock	54.895	54.955	54.8675	54.945	2788192.0
2018-08-28 13:00:00	AAPL	Stock	54.9475	55.0975	54.8825	55.0025	7472500.0
2018-08-28 13:30:00	AAPL	Stock	55.0075	55.135	54.9675	55.0675	4895176.0
2018-08-28 14:00:00	AAPL	Stock	55.0695	55.105	55.0375	55.0475	3020480.0
2018-08-28 14:30:00	AAPL	Stock	55.0475	55.0775	55.0065	55.0425	2674008.0
2018-08-28 15:00:00	AAPL	Stock	55.0425	55.0598	54.9325	54.9898	3958820.0
2018-08-28 15:30:00	AAPL	Stock	54.9875	55.0475	54.795	54.9275	9729752.0
2018-08-28 16:00:00	AAPL	Stock	54.925	54.975	54.925	54.9475	4881044.0
2018-08-28 16:30:00	AAPL	Stock	54.9375	54.9625	54.9375	54.9625	20436.0
2018-08-28 17:00:00	AAPL	Stock	54.9675	54.975	54.485	54.965	17184.0
2018-08-28 17:30:00	AAPL	Stock	54.9525	54.9525	54.95	54.95	1064.0
2018-08-28 18:00:00	AAPL	Stock	54.9525	54.975	54.94	54.955	12680.0
2018-08-28 18:30:00	AAPL	Stock	54.95	54.97	54.95	54.9575	4092.0
2018-08-28 19:00:00	AAPL	Stock	54.97	54.98	54.9575	54.98	13532.0
2018-08-28 19:30:00	AAPL	Stock	54.98	54.9875	54.9575	54.97	55768.0
2018-08-28 04:00:00	MSFT	Stock	109.65	109.65	109.65	109.65	3219.0
2018-08-28 04:30:00	MSFT	Stock	109.65	109.65	109.65	109.65	1459.0
2018-08-28 05:00:00	MSFT	Stock	109.65	109.65	109.65	109.65	8536.0
2018-08-28 05:30:00	MSFT	Stock	109.84	109.84	109.84	109.84	100.0
2018-08-28 06:00:00	MSFT	Stock	109.83	110.0	109.83	109.96	10372.0
2018-08-28 06:30:00	MSFT	Stock	109.9	109.94	109.9	109.9	4195.0
2018-08-28 07:00:00	MSFT	Stock	109.85	109.9	109.66	109.8	3201.0
2018-08-28 07:30:00	MSFT	Stock	109.78	109.89	109.71	109.88	4998.0
2018-08-28 08:00:00	MSFT	Stock	109.8	110.13	109.75	110.09	45777.0
2018-08-28 08:30:00	MSFT	Stock	110.07	110.07	109.9	109.92	2421.0
2018-08-28 09:00:00	MSFT	Stock	109.85	110.0	109.6	109.95	46304.0
2018-08-28 09:30:00	MSFT	Stock	109.94	110.45	109.84	110.392	2969905.0
2018-08-28 10:00:00	MSFT	Stock	110.4	110.5	109.97	109.98	1478790.0
2018-08-28 10:30:00	MSFT	Stock	109.99	110.07	109.8	110.066	1277220.0
2018-08-28 11:00:00	MSFT	Stock	110.07	110.22	109.97	110.08	903736.0
2018-08-28 11:30:00	MSFT	Stock	110.08	110.09	109.79	109.976	805773.0
2018-08-28 12:00:00	MSFT	Stock	109.975	110.18	109.89	110.14	670808.0
2018-08-28 12:30:00	MSFT	Stock	110.14	110.23	110.13	110.18	398416.0

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

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