PREVIEW / stock_30min / 2018-03-14

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-03-14.parquet
  size:    1.6 MB
  rows:    82,356
  symbols: 2,865

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-03-14 04:00:00	AAPL	Stock	45.0125	45.125	44.875	45.125	5892.0
2018-03-14 04:30:00	AAPL	Stock	45.2025	45.2175	45.0525	45.0525	4480.0
2018-03-14 05:00:00	AAPL	Stock	45.2225	45.225	45.2225	45.225	12400.0
2018-03-14 05:30:00	AAPL	Stock	45.225	45.225	45.225	45.225	400.0
2018-03-14 06:00:00	AAPL	Stock	45.21	45.21	45.21	45.21	400.0
2018-03-14 06:30:00	AAPL	Stock	45.225	45.225	45.1875	45.1875	8224.0
2018-03-14 07:00:00	AAPL	Stock	45.1525	45.27	45.1525	45.205	130608.0
2018-03-14 07:30:00	AAPL	Stock	45.2225	45.2475	45.2125	45.2475	43784.0
2018-03-14 08:00:00	AAPL	Stock	45.2325	45.2525	45.1125	45.155	283128.0
2018-03-14 08:30:00	AAPL	Stock	45.1675	45.2225	45.125	45.14	151220.0
2018-03-14 09:00:00	AAPL	Stock	45.1325	45.175	45.065	45.0875	359900.0
2018-03-14 09:30:00	AAPL	Stock	45.08	45.13	44.64	44.755	17488540.0
2018-03-14 10:00:00	AAPL	Stock	44.7575	44.95	44.5775	44.6475	11860452.0
2018-03-14 10:30:00	AAPL	Stock	44.6475	44.805	44.6125	44.755	6756148.0
2018-03-14 11:00:00	AAPL	Stock	44.7575	44.8175	44.61	44.6525	6315360.0
2018-03-14 11:30:00	AAPL	Stock	44.6512	44.685	44.4525	44.58	8610748.0
2018-03-14 12:00:00	AAPL	Stock	44.5825	44.6875	44.5075	44.6575	5780900.0
2018-03-14 12:30:00	AAPL	Stock	44.6575	44.7725	44.645	44.74	4765084.0
2018-03-14 13:00:00	AAPL	Stock	44.7388	44.7388	44.625	44.68	3539068.0
2018-03-14 13:30:00	AAPL	Stock	44.68	44.9075	44.68	44.8425	5046568.0
2018-03-14 14:00:00	AAPL	Stock	44.84	44.8875	44.765	44.8015	3739000.0
2018-03-14 14:30:00	AAPL	Stock	44.8025	44.8425	44.5465	44.6625	6359420.0
2018-03-14 15:00:00	AAPL	Stock	44.6625	44.675	44.54	44.5475	6729828.0
2018-03-14 15:30:00	AAPL	Stock	44.55	44.6625	44.4975	44.6213	11817124.0
2018-03-14 16:00:00	AAPL	Stock	44.61	44.6525	44.5125	44.5125	6776272.0
2018-03-14 16:30:00	AAPL	Stock	44.5975	44.61	44.5025	44.55	85928.0
2018-03-14 17:00:00	AAPL	Stock	44.5575	44.5725	44.525	44.5725	23456.0
2018-03-14 17:30:00	AAPL	Stock	44.5875	44.5875	44.5575	44.5775	17952.0
2018-03-14 18:00:00	AAPL	Stock	44.5625	44.6	44.5625	44.5825	7768.0
2018-03-14 18:30:00	AAPL	Stock	44.58	44.6225	44.58	44.6225	14432.0
2018-03-14 19:00:00	AAPL	Stock	44.6225	44.65	44.6125	44.65	18104.0
2018-03-14 19:30:00	AAPL	Stock	44.625	44.65	44.6	44.65	60600.0
2018-03-14 04:00:00	MSFT	Stock	94.6	94.97	94.6	94.94	1006.0
2018-03-14 05:00:00	MSFT	Stock	95.25	95.31	95.25	95.31	5752.0
2018-03-14 06:00:00	MSFT	Stock	95.31	95.31	95.31	95.31	200.0
2018-03-14 06:30:00	MSFT	Stock	95.2	95.2	95.1	95.1	4553.0
2018-03-14 07:00:00	MSFT	Stock	95.06	95.2	94.98	95.2	6658.0
2018-03-14 07:30:00	MSFT	Stock	95.07	95.07	95.05	95.05	1840.0
2018-03-14 08:00:00	MSFT	Stock	95.0	95.07	94.9	94.92	9945.0
2018-03-14 08:30:00	MSFT	Stock	94.9	95.1	94.85	94.96	20291.0
2018-03-14 09:00:00	MSFT	Stock	95.0	95.22	94.76	95.02	35520.0
2018-03-14 09:30:00	MSFT	Stock	95.12	95.41	94.59	94.77	3263784.0
2018-03-14 10:00:00	MSFT	Stock	94.78	95.18	94.4	94.65	1799120.0
2018-03-14 10:30:00	MSFT	Stock	94.66	94.94	94.595	94.665	1549824.0
2018-03-14 11:00:00	MSFT	Stock	94.67	94.711	94.13	94.36	1630971.0
2018-03-14 11:30:00	MSFT	Stock	94.35	94.46	93.82	93.94	2321831.0
2018-03-14 12:00:00	MSFT	Stock	93.95	94.29	93.75	94.26	1233498.0
2018-03-14 12:30:00	MSFT	Stock	94.26	94.58	94.23	94.345	955713.0
2018-03-14 13:00:00	MSFT	Stock	94.34	94.51	94.11	94.39	787093.0
2018-03-14 13:30:00	MSFT	Stock	94.4	94.975	94.39	94.65	1568961.0

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

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