PREVIEW / stock_30min / 2017-08-03

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-08-03.parquet
  size:    1.6 MB
  rows:    80,595
  symbols: 2,988

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
2017-08-03 04:00:00	AAPL	Stock	39.2875	39.2875	39.265	39.265	1536.0
2017-08-03 04:30:00	AAPL	Stock	39.285	39.285	39.285	39.285	2000.0
2017-08-03 05:00:00	AAPL	Stock	39.285	39.37	39.285	39.37	2496.0
2017-08-03 05:30:00	AAPL	Stock	39.35	39.35	39.3375	39.35	8052.0
2017-08-03 06:00:00	AAPL	Stock	39.35	39.35	39.325	39.325	12340.0
2017-08-03 06:30:00	AAPL	Stock	39.325	39.325	39.29	39.325	20632.0
2017-08-03 07:00:00	AAPL	Stock	39.3	39.35	39.25	39.275	48288.0
2017-08-03 07:30:00	AAPL	Stock	39.275	39.28	39.2575	39.27	29892.0
2017-08-03 08:00:00	AAPL	Stock	39.2875	39.2875	39.19	39.2	155660.0
2017-08-03 08:30:00	AAPL	Stock	39.22	39.2275	39.2	39.2	135864.0
2017-08-03 09:00:00	AAPL	Stock	39.225	39.2725	39.15	39.26	225024.0
2017-08-03 09:30:00	AAPL	Stock	39.2625	39.3025	38.9625	39.0625	17489472.0
2017-08-03 10:00:00	AAPL	Stock	39.06	39.06	38.82	38.9712	11791928.0
2017-08-03 10:30:00	AAPL	Stock	38.9725	39.0658	38.925	39.0475	6642432.0
2017-08-03 11:00:00	AAPL	Stock	39.045	39.205	39.0225	39.0725	7922588.0
2017-08-03 11:30:00	AAPL	Stock	39.0725	39.1025	38.9658	38.9885	4362472.0
2017-08-03 12:00:00	AAPL	Stock	38.9875	39.03	38.915	39.0275	4290656.0
2017-08-03 12:30:00	AAPL	Stock	39.0245	39.0475	38.9468	38.9775	2782148.0
2017-08-03 13:00:00	AAPL	Stock	38.9775	38.98	38.8388	38.8575	4275176.0
2017-08-03 13:30:00	AAPL	Stock	38.8625	38.9675	38.8237	38.95	4380560.0
2017-08-03 14:00:00	AAPL	Stock	38.9545	39.0025	38.9125	38.94	3674120.0
2017-08-03 14:30:00	AAPL	Stock	38.9388	38.9388	38.855	38.88	3463788.0
2017-08-03 15:00:00	AAPL	Stock	38.879	38.985	38.8675	38.9625	4911324.0
2017-08-03 15:30:00	AAPL	Stock	38.9625	38.97	38.755	38.8775	12376692.0
2017-08-03 16:00:00	AAPL	Stock	38.84	38.9625	38.84	38.9	6485004.0
2017-08-03 16:30:00	AAPL	Stock	38.9025	38.91	38.9	38.91	11560.0
2017-08-03 17:00:00	AAPL	Stock	38.925	38.925	38.9075	38.9075	14340.0
2017-08-03 17:30:00	AAPL	Stock	38.9075	38.9225	38.8875	38.8925	31788.0
2017-08-03 18:00:00	AAPL	Stock	38.89	38.9125	38.89	38.91	24052.0
2017-08-03 18:30:00	AAPL	Stock	38.8925	38.905	38.89	38.89	10772.0
2017-08-03 19:00:00	AAPL	Stock	38.8925	38.905	38.89	38.89	14092.0
2017-08-03 19:30:00	AAPL	Stock	38.9	38.9	38.89	38.89	13788.0
2017-08-03 06:30:00	MSFT	Stock	72.2	72.25	72.2	72.25	780.0
2017-08-03 08:00:00	MSFT	Stock	72.0	72.28	72.0	72.28	1825.0
2017-08-03 08:30:00	MSFT	Stock	72.28	72.28	72.27	72.28	450.0
2017-08-03 09:00:00	MSFT	Stock	72.27	72.28	72.19	72.19	3191.0
2017-08-03 09:30:00	MSFT	Stock	72.19	72.37	71.93	71.99	1998937.0
2017-08-03 10:00:00	MSFT	Stock	71.98	72.145	71.845	72.14	1392475.0
2017-08-03 10:30:00	MSFT	Stock	72.13	72.16	71.993	72.07	885344.0
2017-08-03 11:00:00	MSFT	Stock	72.075	72.11	71.93	72.01	1234044.0
2017-08-03 11:30:00	MSFT	Stock	72.014	72.055	71.945	72.005	754382.0
2017-08-03 12:00:00	MSFT	Stock	72.005	72.39	72.0	72.39	1055272.0
2017-08-03 12:30:00	MSFT	Stock	72.39	72.44	72.26	72.275	790461.0
2017-08-03 13:00:00	MSFT	Stock	72.276	72.29	72.112	72.165	621981.0
2017-08-03 13:30:00	MSFT	Stock	72.165	72.34	72.105	72.295	648345.0
2017-08-03 14:00:00	MSFT	Stock	72.3	72.34	72.11	72.21	906934.0
2017-08-03 14:30:00	MSFT	Stock	72.2	72.22	72.09	72.12	680342.0
2017-08-03 15:00:00	MSFT	Stock	72.125	72.22	72.1	72.185	921713.0
2017-08-03 15:30:00	MSFT	Stock	72.18	72.21	71.94	72.14	2966253.0
2017-08-03 16:00:00	MSFT	Stock	72.15	72.3	72.13	72.3	2276635.0

> showing 50 of 80,595 rows — these rows as CSV

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