PREVIEW / stock_30min / 2018-07-27

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-07-27.parquet
  size:    1.7 MB
  rows:    81,524
  symbols: 2,774

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-07-27 04:00:00	AAPL	Stock	48.65	48.73	48.65	48.7125	5696.0
2018-07-27 04:30:00	AAPL	Stock	48.65	48.7725	48.65	48.75	4084.0
2018-07-27 05:00:00	AAPL	Stock	48.7425	48.75	48.7425	48.75	6800.0
2018-07-27 05:30:00	AAPL	Stock	48.69	48.7	48.69	48.7	1148.0
2018-07-27 06:30:00	AAPL	Stock	48.7125	48.7125	48.7125	48.7125	400.0
2018-07-27 07:00:00	AAPL	Stock	48.6975	48.755	48.6625	48.6775	53540.0
2018-07-27 07:30:00	AAPL	Stock	48.6775	48.75	48.6775	48.6875	89904.0
2018-07-27 08:00:00	AAPL	Stock	48.745	48.77	48.67	48.7325	254648.0
2018-07-27 08:30:00	AAPL	Stock	48.745	48.7875	48.6775	48.7875	126520.0
2018-07-27 09:00:00	AAPL	Stock	48.7875	48.7875	48.6625	48.7325	100724.0
2018-07-27 09:30:00	AAPL	Stock	48.735	48.7975	48.595	48.6175	8354584.0
2018-07-27 10:00:00	AAPL	Stock	48.6125	48.6555	48.39	48.58	6298180.0
2018-07-27 10:30:00	AAPL	Stock	48.575	48.615	48.28	48.3975	4850768.0
2018-07-27 11:00:00	AAPL	Stock	48.3975	48.47	48.3475	48.455	3325844.0
2018-07-27 11:30:00	AAPL	Stock	48.4575	48.5097	48.3475	48.3825	2862608.0
2018-07-27 12:00:00	AAPL	Stock	48.38	48.395	48.135	48.205	4275496.0
2018-07-27 12:30:00	AAPL	Stock	48.2002	48.2175	47.925	47.95	6341260.0
2018-07-27 13:00:00	AAPL	Stock	47.9487	48.0125	47.7975	47.9675	5486320.0
2018-07-27 13:30:00	AAPL	Stock	47.965	47.984	47.8628	47.965	3769864.0
2018-07-27 14:00:00	AAPL	Stock	47.9575	48.0075	47.7725	47.8175	3963564.0
2018-07-27 14:30:00	AAPL	Stock	47.815	47.8325	47.54	47.5488	7235960.0
2018-07-27 15:00:00	AAPL	Stock	47.5475	47.6875	47.53	47.535	5184240.0
2018-07-27 15:30:00	AAPL	Stock	47.535	47.8	47.525	47.745	12169048.0
2018-07-27 16:00:00	AAPL	Stock	47.745	47.75	47.6625	47.675	6447040.0
2018-07-27 16:30:00	AAPL	Stock	47.68	47.745	47.6775	47.705	75700.0
2018-07-27 17:00:00	AAPL	Stock	47.7075	47.7375	47.6875	47.71	23452.0
2018-07-27 17:30:00	AAPL	Stock	47.715	47.7475	47.7	47.745	54828.0
2018-07-27 18:00:00	AAPL	Stock	47.745	47.7875	47.745	47.7625	33032.0
2018-07-27 18:30:00	AAPL	Stock	47.77	47.7738	47.745	47.745	52240.0
2018-07-27 19:00:00	AAPL	Stock	47.75	47.75	47.745	47.75	20128.0
2018-07-27 19:30:00	AAPL	Stock	47.75	47.785	47.745	47.745	14220.0
2018-07-27 04:30:00	MSFT	Stock	110.39	110.39	110.2	110.2	600.0
2018-07-27 05:00:00	MSFT	Stock	110.3	110.39	110.3	110.39	1300.0
2018-07-27 05:30:00	MSFT	Stock	110.39	110.39	110.29	110.29	1300.0
2018-07-27 06:00:00	MSFT	Stock	110.4	110.4	110.4	110.4	100.0
2018-07-27 07:00:00	MSFT	Stock	110.1	110.21	110.01	110.06	8154.0
2018-07-27 07:30:00	MSFT	Stock	110.05	110.16	109.9	110.04	11621.0
2018-07-27 08:00:00	MSFT	Stock	110.19	110.19	109.81	109.95	16305.0
2018-07-27 08:30:00	MSFT	Stock	109.95	110.25	109.82	110.25	22350.0
2018-07-27 09:00:00	MSFT	Stock	110.24	110.44	110.04	110.19	51419.0
2018-07-27 09:30:00	MSFT	Stock	110.18	110.18	109.18	109.19	3091178.0
2018-07-27 10:00:00	MSFT	Stock	109.19	109.355	108.925	109.17	1829373.0
2018-07-27 10:30:00	MSFT	Stock	109.16	109.325	108.93	109.16	1979023.0
2018-07-27 11:00:00	MSFT	Stock	109.15	109.25	108.685	108.76	1830341.0
2018-07-27 11:30:00	MSFT	Stock	108.77	108.88	108.11	108.145	1689851.0
2018-07-27 12:00:00	MSFT	Stock	108.145	108.145	107.64	107.685	2703409.0
2018-07-27 12:30:00	MSFT	Stock	107.69	107.71	106.57	106.59	4175445.0
2018-07-27 13:00:00	MSFT	Stock	106.57	106.67	106.14	106.66	3028678.0
2018-07-27 13:30:00	MSFT	Stock	106.658	108.0	106.62	107.91	2739197.0
2018-07-27 14:00:00	MSFT	Stock	107.918	107.95	107.44	107.63	1893409.0

> showing 50 of 81,524 rows — these rows as CSV

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