PREVIEW / stock_30min / 2017-10-23

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-10-23.parquet
  size:    1.6 MB
  rows:    81,074
  symbols: 2,926

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-10-23 04:00:00	AAPL	Stock	39.0625	39.0625	39.0625	39.0625	2800.0
2017-10-23 04:30:00	AAPL	Stock	39.1	39.1625	39.1	39.1625	1124.0
2017-10-23 05:00:00	AAPL	Stock	39.1	39.1425	39.1	39.1	3524.0
2017-10-23 05:30:00	AAPL	Stock	39.15	39.15	39.115	39.115	2780.0
2017-10-23 06:00:00	AAPL	Stock	39.115	39.15	39.115	39.15	3200.0
2017-10-23 06:30:00	AAPL	Stock	39.15	39.2	39.15	39.15	18644.0
2017-10-23 07:00:00	AAPL	Stock	39.1375	39.1625	39.105	39.15	8652.0
2017-10-23 07:30:00	AAPL	Stock	39.1475	39.1475	39.1225	39.1225	14620.0
2017-10-23 08:00:00	AAPL	Stock	39.15	39.1725	39.1025	39.1725	56460.0
2017-10-23 08:30:00	AAPL	Stock	39.175	39.2225	39.175	39.2225	53648.0
2017-10-23 09:00:00	AAPL	Stock	39.23	39.275	39.0625	39.225	573792.0
2017-10-23 09:30:00	AAPL	Stock	39.2225	39.2625	39.075	39.2125	8289532.0
2017-10-23 10:00:00	AAPL	Stock	39.215	39.215	38.985	39.125	7502464.0
2017-10-23 10:30:00	AAPL	Stock	39.1275	39.14	38.9775	39.0288	3743032.0
2017-10-23 11:00:00	AAPL	Stock	39.03	39.1375	39.03	39.0875	2628000.0
2017-10-23 11:30:00	AAPL	Stock	39.0825	39.1125	39.03	39.0922	1991048.0
2017-10-23 12:00:00	AAPL	Stock	39.09	39.4	39.0888	39.4	7352008.0
2017-10-23 12:30:00	AAPL	Stock	39.4	39.4225	39.325	39.3725	4765044.0
2017-10-23 13:00:00	AAPL	Stock	39.3725	39.3925	39.3175	39.3225	1990668.0
2017-10-23 13:30:00	AAPL	Stock	39.3245	39.3425	39.2375	39.2512	3738540.0
2017-10-23 14:00:00	AAPL	Stock	39.25	39.29	39.1375	39.155	3554308.0
2017-10-23 14:30:00	AAPL	Stock	39.1538	39.1925	39.12	39.1788	3323336.0
2017-10-23 15:00:00	AAPL	Stock	39.1775	39.185	39.0475	39.075	4061240.0
2017-10-23 15:30:00	AAPL	Stock	39.075	39.1002	38.875	39.05	12788604.0
2017-10-23 16:00:00	AAPL	Stock	39.0425	39.095	38.985	39.0675	10248604.0
2017-10-23 16:30:00	AAPL	Stock	39.0625	39.0625	39.0	39.0175	65768.0
2017-10-23 17:00:00	AAPL	Stock	39.0375	39.0375	39.02	39.02	7992.0
2017-10-23 17:30:00	AAPL	Stock	39.02	39.025	39.0025	39.015	6780.0
2017-10-23 18:00:00	AAPL	Stock	39.0075	39.0375	39.0075	39.0375	27544.0
2017-10-23 18:30:00	AAPL	Stock	39.0375	39.04	39.025	39.0375	18060.0
2017-10-23 19:00:00	AAPL	Stock	39.03	39.035	39.0125	39.035	8428.0
2017-10-23 19:30:00	AAPL	Stock	39.02	39.0375	39.02	39.02	30644.0
2017-10-23 06:00:00	MSFT	Stock	78.93	78.93	78.85	78.85	1146.0
2017-10-23 06:30:00	MSFT	Stock	79.0	79.0	79.0	79.0	100.0
2017-10-23 07:00:00	MSFT	Stock	78.89	78.89	78.89	78.89	1447.0
2017-10-23 07:30:00	MSFT	Stock	78.89	78.94	78.89	78.9	3268.0
2017-10-23 08:00:00	MSFT	Stock	78.89	78.96	78.89	78.96	3990.0
2017-10-23 08:30:00	MSFT	Stock	78.96	78.96	78.94	78.96	7749.0
2017-10-23 09:00:00	MSFT	Stock	78.95	79.0	78.87	79.0	12237.0
2017-10-23 09:30:00	MSFT	Stock	78.99	79.13	78.85	79.037	1882637.0
2017-10-23 10:00:00	MSFT	Stock	79.03	79.1	78.9	78.97	1313482.0
2017-10-23 10:30:00	MSFT	Stock	78.98	79.0	78.88	78.95	1346843.0
2017-10-23 11:00:00	MSFT	Stock	78.95	79.08	78.95	79.045	1034249.0
2017-10-23 11:30:00	MSFT	Stock	79.04	79.19	79.0	79.12	696809.0
2017-10-23 12:00:00	MSFT	Stock	79.12	79.2	79.065	79.2	532362.0
2017-10-23 12:30:00	MSFT	Stock	79.195	79.21	79.1	79.14	508035.0
2017-10-23 13:00:00	MSFT	Stock	79.135	79.14	79.04	79.06	588864.0
2017-10-23 13:30:00	MSFT	Stock	79.055	79.17	78.94	79.16	908712.0
2017-10-23 14:00:00	MSFT	Stock	79.17	79.34	79.11	79.22	1052297.0
2017-10-23 14:30:00	MSFT	Stock	79.215	79.27	79.14	79.23	1123780.0

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

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