PREVIEW / stock_30min / 2018-08-24

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-08-24.parquet
  size:    1.6 MB
  rows:    82,373
  symbols: 2,786

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-24 04:00:00	AAPL	Stock	54.075	54.1125	54.075	54.095	3948.0
2018-08-24 04:30:00	AAPL	Stock	54.05	54.0525	54.025	54.0525	3844.0
2018-08-24 05:30:00	AAPL	Stock	54.0875	54.09	54.0875	54.09	4000.0
2018-08-24 06:00:00	AAPL	Stock	54.0925	54.0925	54.06	54.0925	11488.0
2018-08-24 06:30:00	AAPL	Stock	54.1125	54.1125	54.1125	54.1125	1200.0
2018-08-24 07:00:00	AAPL	Stock	54.1	54.1	54.0625	54.0825	56620.0
2018-08-24 07:30:00	AAPL	Stock	54.08	54.105	54.0625	54.105	13868.0
2018-08-24 08:00:00	AAPL	Stock	54.0875	54.1125	54.055	54.095	154708.0
2018-08-24 08:30:00	AAPL	Stock	54.075	54.1625	54.075	54.125	83228.0
2018-08-24 09:00:00	AAPL	Stock	54.1125	54.15	54.0775	54.0875	59172.0
2018-08-24 09:30:00	AAPL	Stock	54.15	54.225	53.95	53.9725	8826564.0
2018-08-24 10:00:00	AAPL	Stock	53.975	54.08	53.7775	53.9698	8925432.0
2018-08-24 10:30:00	AAPL	Stock	53.9725	54.07	53.93	53.9575	5947180.0
2018-08-24 11:00:00	AAPL	Stock	53.9562	54.005	53.855	53.975	4430384.0
2018-08-24 11:30:00	AAPL	Stock	53.975	54.0825	53.975	54.0175	3146352.0
2018-08-24 12:00:00	AAPL	Stock	54.02	54.0475	53.9752	54.0175	1920004.0
2018-08-24 12:30:00	AAPL	Stock	54.0175	54.0375	53.99	54.011	1999708.0
2018-08-24 13:00:00	AAPL	Stock	54.01	54.04	53.945	54.02	2293312.0
2018-08-24 13:30:00	AAPL	Stock	54.02	54.0482	53.98	54.0325	2669612.0
2018-08-24 14:00:00	AAPL	Stock	54.0325	54.125	54.015	54.12	3008728.0
2018-08-24 14:30:00	AAPL	Stock	54.1188	54.1225	54.0238	54.0275	1841036.0
2018-08-24 15:00:00	AAPL	Stock	54.03	54.0825	54.0025	54.05	2437056.0
2018-08-24 15:30:00	AAPL	Stock	54.05	54.135	53.985	54.035	6586876.0
2018-08-24 16:00:00	AAPL	Stock	54.04	54.075	54.02	54.0625	7557044.0
2018-08-24 16:30:00	AAPL	Stock	54.04	54.065	54.0325	54.0325	28916.0
2018-08-24 17:00:00	AAPL	Stock	54.04	54.06	54.025	54.06	3856.0
2018-08-24 17:30:00	AAPL	Stock	54.03	54.04	54.03	54.04	1200.0
2018-08-24 18:00:00	AAPL	Stock	54.055	54.055	54.055	54.055	556.0
2018-08-24 18:30:00	AAPL	Stock	54.0525	54.0525	54.0525	54.0525	400.0
2018-08-24 19:00:00	AAPL	Stock	54.0425	54.0425	54.0425	54.0425	1400.0
2018-08-24 19:30:00	AAPL	Stock	54.055	54.0875	54.04	54.075	19228.0
2018-08-24 06:00:00	MSFT	Stock	107.78	107.78	107.7	107.78	1323.0
2018-08-24 06:30:00	MSFT	Stock	107.82	107.82	107.6	107.6	1631.0
2018-08-24 07:00:00	MSFT	Stock	107.5	107.6	107.35	107.35	2934.0
2018-08-24 07:30:00	MSFT	Stock	107.45	107.6	107.44	107.44	3299.0
2018-08-24 08:00:00	MSFT	Stock	107.36	107.6	107.36	107.55	10866.0
2018-08-24 08:30:00	MSFT	Stock	107.56	107.753	107.5	107.61	4416.0
2018-08-24 09:00:00	MSFT	Stock	107.61	107.67	107.5	107.6	8785.0
2018-08-24 09:30:00	MSFT	Stock	107.67	108.25	107.56	108.129	1821779.0
2018-08-24 10:00:00	MSFT	Stock	108.12	108.51	107.97	108.05	1221182.0
2018-08-24 10:30:00	MSFT	Stock	108.05	108.56	108.01	108.39	1810201.0
2018-08-24 11:00:00	MSFT	Stock	108.385	108.49	108.22	108.36	797312.0
2018-08-24 11:30:00	MSFT	Stock	108.36	108.53	108.24	108.35	687338.0
2018-08-24 12:00:00	MSFT	Stock	108.35	108.4	108.265	108.345	374737.0
2018-08-24 12:30:00	MSFT	Stock	108.345	108.345	108.14	108.2	553436.0
2018-08-24 13:00:00	MSFT	Stock	108.2	108.24	108.02	108.11	439511.0
2018-08-24 13:30:00	MSFT	Stock	108.11	108.22	107.9	108.2	653478.0
2018-08-24 14:00:00	MSFT	Stock	108.19	108.25	108.05	108.16	504226.0
2018-08-24 14:30:00	MSFT	Stock	108.155	108.205	108.09	108.1	463407.0
2018-08-24 15:00:00	MSFT	Stock	108.1	108.17	108.01	108.04	532081.0

> showing 50 of 82,373 rows — these rows as CSV

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