PREVIEW / stock_30min / 2017-02-10

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-02-10.parquet
  size:    1.6 MB
  rows:    81,821
  symbols: 3,108

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-02-10 04:00:00	AAPL	Stock	33.12	33.1875	33.12	33.125	5072.0
2017-02-10 04:30:00	AAPL	Stock	33.1125	33.1125	32.9625	33.025	20720.0
2017-02-10 05:00:00	AAPL	Stock	33.015	33.0375	33.0075	33.0375	6920.0
2017-02-10 05:30:00	AAPL	Stock	33.0375	33.0375	32.9625	33.0375	34472.0
2017-02-10 06:00:00	AAPL	Stock	33.0325	33.0475	32.9825	33.0	42596.0
2017-02-10 06:30:00	AAPL	Stock	33.0	33.025	33.0	33.025	5900.0
2017-02-10 07:00:00	AAPL	Stock	33.0375	33.0725	33.0375	33.0575	20600.0
2017-02-10 07:30:00	AAPL	Stock	33.07	33.075	33.0625	33.065	14012.0
2017-02-10 08:00:00	AAPL	Stock	33.0875	33.1175	33.0	33.07	168876.0
2017-02-10 08:30:00	AAPL	Stock	33.0625	33.1	33.0625	33.1	67684.0
2017-02-10 09:00:00	AAPL	Stock	33.1	33.125	33.0725	33.105	196524.0
2017-02-10 09:30:00	AAPL	Stock	33.115	33.235	33.085	33.1875	13648344.0
2017-02-10 10:00:00	AAPL	Stock	33.19	33.195	33.045	33.0685	7321680.0
2017-02-10 10:30:00	AAPL	Stock	33.0688	33.15	33.0475	33.0575	5519740.0
2017-02-10 11:00:00	AAPL	Stock	33.0588	33.1025	33.0325	33.053	4041708.0
2017-02-10 11:30:00	AAPL	Stock	33.0535	33.1175	33.025	33.09	4062176.0
2017-02-10 12:00:00	AAPL	Stock	33.0925	33.0925	33.0475	33.055	3359548.0
2017-02-10 12:30:00	AAPL	Stock	33.055	33.1125	33.0425	33.1078	4277152.0
2017-02-10 13:00:00	AAPL	Stock	33.1075	33.14	33.0882	33.0925	3285116.0
2017-02-10 13:30:00	AAPL	Stock	33.0925	33.1375	33.0915	33.115	2255560.0
2017-02-10 14:00:00	AAPL	Stock	33.115	33.125	33.075	33.099	2702860.0
2017-02-10 14:30:00	AAPL	Stock	33.0975	33.1072	33.0375	33.0575	3015908.0
2017-02-10 15:00:00	AAPL	Stock	33.0575	33.08	33.0235	33.0425	3117112.0
2017-02-10 15:30:00	AAPL	Stock	33.0438	33.065	33.015	33.03	7190196.0
2017-02-10 16:00:00	AAPL	Stock	33.0125	33.0425	33.0125	33.035	6395652.0
2017-02-10 16:30:00	AAPL	Stock	33.03	33.03	33.0075	33.0125	1079840.0
2017-02-10 17:00:00	AAPL	Stock	33.02	33.02	33.005	33.005	20504.0
2017-02-10 17:30:00	AAPL	Stock	33.015	33.015	33.0125	33.015	6044.0
2017-02-10 18:00:00	AAPL	Stock	33.0075	33.0075	33.0025	33.005	27864.0
2017-02-10 18:30:00	AAPL	Stock	33.0025	33.015	33.0	33.015	5300.0
2017-02-10 19:00:00	AAPL	Stock	33.015	33.015	33.005	33.005	2000.0
2017-02-10 19:30:00	AAPL	Stock	33.005	33.0125	33.005	33.0125	13484.0
2017-02-10 07:30:00	MSFT	Stock	64.21	64.21	64.21	64.21	123.0
2017-02-10 08:00:00	MSFT	Stock	64.23	64.23	64.1	64.23	2062.0
2017-02-10 08:30:00	MSFT	Stock	64.2	64.25	64.16	64.25	4425.0
2017-02-10 09:00:00	MSFT	Stock	64.23	64.27	64.16	64.21	17848.0
2017-02-10 09:30:00	MSFT	Stock	64.25	64.3	64.05	64.08	2351477.0
2017-02-10 10:00:00	MSFT	Stock	64.08	64.3	64.06	64.29	1455231.0
2017-02-10 10:30:00	MSFT	Stock	64.29	64.3	64.17	64.22	1147871.0
2017-02-10 11:00:00	MSFT	Stock	64.226	64.24	64.13	64.16	915779.0
2017-02-10 11:30:00	MSFT	Stock	64.155	64.21	64.11	64.14	779219.0
2017-02-10 12:00:00	MSFT	Stock	64.135	64.2	64.09	64.185	656461.0
2017-02-10 12:30:00	MSFT	Stock	64.18	64.235	64.164	64.215	557515.0
2017-02-10 13:00:00	MSFT	Stock	64.22	64.23	64.14	64.165	606937.0
2017-02-10 13:30:00	MSFT	Stock	64.164	64.19	64.11	64.11	527029.0
2017-02-10 14:00:00	MSFT	Stock	64.11	64.12	64.051	64.075	772226.0
2017-02-10 14:30:00	MSFT	Stock	64.075	64.11	64.03	64.035	934052.0
2017-02-10 15:00:00	MSFT	Stock	64.04	64.145	64.03	64.1	890228.0
2017-02-10 15:30:00	MSFT	Stock	64.095	64.11	63.975	64.0	2975142.0
2017-02-10 16:00:00	MSFT	Stock	64.0	64.031	63.95	63.95	1822756.0

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

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