PREVIEW / stock_30min / 2018-08-21

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-08-21.parquet
  size:    1.7 MB
  rows:    83,940
  symbols: 2,797

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-21 04:00:00	AAPL	Stock	54.025	54.025	54.025	54.025	600.0
2018-08-21 04:30:00	AAPL	Stock	54.0	54.0	54.0	54.0	5896.0
2018-08-21 05:30:00	AAPL	Stock	54.1025	54.1925	54.1025	54.1725	61976.0
2018-08-21 06:00:00	AAPL	Stock	54.22	54.25	54.175	54.2275	34928.0
2018-08-21 06:30:00	AAPL	Stock	54.2125	54.2125	54.1875	54.1875	9744.0
2018-08-21 07:00:00	AAPL	Stock	54.155	54.21	54.09	54.125	94060.0
2018-08-21 07:30:00	AAPL	Stock	54.1275	54.14	54.1025	54.1125	59196.0
2018-08-21 08:00:00	AAPL	Stock	54.1985	54.205	54.0525	54.135	145400.0
2018-08-21 08:30:00	AAPL	Stock	54.135	54.15	54.0975	54.1	122064.0
2018-08-21 09:00:00	AAPL	Stock	54.1	54.2425	54.0975	54.1675	285320.0
2018-08-21 09:30:00	AAPL	Stock	54.2	54.2075	53.8465	53.88	13410380.0
2018-08-21 10:00:00	AAPL	Stock	53.8825	53.925	53.5062	53.7205	14209700.0
2018-08-21 10:30:00	AAPL	Stock	53.722	53.84	53.645	53.6775	5776336.0
2018-08-21 11:00:00	AAPL	Stock	53.6775	53.9525	53.64	53.9	5720992.0
2018-08-21 11:30:00	AAPL	Stock	53.9	54.1425	53.885	54.11	6150412.0
2018-08-21 12:00:00	AAPL	Stock	54.1085	54.2075	54.0312	54.135	4632964.0
2018-08-21 12:30:00	AAPL	Stock	54.135	54.25	54.095	54.2075	3385692.0
2018-08-21 13:00:00	AAPL	Stock	54.21	54.2975	54.1785	54.2288	4748012.0
2018-08-21 13:30:00	AAPL	Stock	54.2275	54.2375	54.1125	54.1275	2547736.0
2018-08-21 14:00:00	AAPL	Stock	54.1275	54.1375	54.0525	54.0985	3029380.0
2018-08-21 14:30:00	AAPL	Stock	54.0975	54.0975	53.815	53.8882	5029840.0
2018-08-21 15:00:00	AAPL	Stock	53.89	53.9275	53.7725	53.785	4720564.0
2018-08-21 15:30:00	AAPL	Stock	53.7875	53.8575	53.5225	53.765	8717392.0
2018-08-21 16:00:00	AAPL	Stock	53.76	53.8	53.73	53.7375	6802576.0
2018-08-21 16:30:00	AAPL	Stock	53.7475	53.7665	53.57	53.57	278436.0
2018-08-21 17:00:00	AAPL	Stock	53.575	53.6075	53.5125	53.525	96368.0
2018-08-21 17:30:00	AAPL	Stock	53.5175	53.575	53.505	53.575	79800.0
2018-08-21 18:00:00	AAPL	Stock	53.55	53.5875	53.5275	53.5375	45800.0
2018-08-21 18:30:00	AAPL	Stock	53.5125	53.525	53.5	53.505	58280.0
2018-08-21 19:00:00	AAPL	Stock	53.5025	53.5025	53.4375	53.4975	66756.0
2018-08-21 19:30:00	AAPL	Stock	53.4525	53.4975	53.44	53.4425	37104.0
2018-08-21 07:00:00	MSFT	Stock	107.03	107.18	106.92	107.06	18787.0
2018-08-21 07:30:00	MSFT	Stock	107.05	107.07	107.0	107.0	3151.0
2018-08-21 08:00:00	MSFT	Stock	107.12	107.18	106.91	107.1	5454.0
2018-08-21 08:30:00	MSFT	Stock	107.11	107.11	107.06	107.06	2696.0
2018-08-21 09:00:00	MSFT	Stock	107.1	107.1	106.94	106.94	11598.0
2018-08-21 09:30:00	MSFT	Stock	106.92	107.32	106.81	107.26	2191557.0
2018-08-21 10:00:00	MSFT	Stock	107.25	107.35	107.02	107.04	1327046.0
2018-08-21 10:30:00	MSFT	Stock	107.04	107.13	106.9	107.0	1053232.0
2018-08-21 11:00:00	MSFT	Stock	107.0	107.01	106.61	106.715	894075.0
2018-08-21 11:30:00	MSFT	Stock	106.715	107.02	106.71	107.01	848422.0
2018-08-21 12:00:00	MSFT	Stock	107.015	107.14	106.885	106.945	610833.0
2018-08-21 12:30:00	MSFT	Stock	106.95	106.99	106.85	106.854	769128.0
2018-08-21 13:00:00	MSFT	Stock	106.855	106.86	106.55	106.565	1069876.0
2018-08-21 13:30:00	MSFT	Stock	106.57	106.65	106.52	106.555	900272.0
2018-08-21 14:00:00	MSFT	Stock	106.55	106.56	106.4	106.415	1046893.0
2018-08-21 14:30:00	MSFT	Stock	106.42	106.42	106.0	106.14	1284435.0
2018-08-21 15:00:00	MSFT	Stock	106.14	106.25	106.05	106.185	1104991.0
2018-08-21 15:30:00	MSFT	Stock	106.195	106.24	105.85	105.98	3213433.0
2018-08-21 16:00:00	MSFT	Stock	105.98	106.14	105.86	105.95	3494093.0

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

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