PREVIEW / stock_30min / 2017-10-25

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-10-25.parquet
  size:    1.6 MB
  rows:    81,878
  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-25 04:30:00	AAPL	Stock	39.235	39.2475	39.23	39.23	7960.0
2017-10-25 05:00:00	AAPL	Stock	39.2475	39.31	39.2475	39.25	7912.0
2017-10-25 05:30:00	AAPL	Stock	39.25	39.25	39.2375	39.2375	968.0
2017-10-25 06:00:00	AAPL	Stock	39.3225	39.3225	39.3225	39.3225	1988.0
2017-10-25 06:30:00	AAPL	Stock	39.275	39.3	39.25	39.3	5200.0
2017-10-25 07:00:00	AAPL	Stock	39.2775	39.35	39.2775	39.3125	22616.0
2017-10-25 07:30:00	AAPL	Stock	39.3	39.315	39.3	39.3	8904.0
2017-10-25 08:00:00	AAPL	Stock	39.3	39.3175	39.275	39.31	53232.0
2017-10-25 08:30:00	AAPL	Stock	39.31	39.3175	39.3	39.3175	39396.0
2017-10-25 09:00:00	AAPL	Stock	39.3025	39.3175	39.2225	39.2225	158792.0
2017-10-25 09:30:00	AAPL	Stock	39.2275	39.3875	39.1125	39.2125	8917464.0
2017-10-25 10:00:00	AAPL	Stock	39.21	39.3	39.21	39.2625	5629064.0
2017-10-25 10:30:00	AAPL	Stock	39.265	39.28	39.1575	39.215	3924652.0
2017-10-25 11:00:00	AAPL	Stock	39.2175	39.2175	38.9125	39.0408	7753484.0
2017-10-25 11:30:00	AAPL	Stock	39.045	39.1125	38.985	39.0375	3394948.0
2017-10-25 12:00:00	AAPL	Stock	39.035	39.0825	38.84	38.8432	7287168.0
2017-10-25 12:30:00	AAPL	Stock	38.84	39.02	38.8175	39.0062	5302728.0
2017-10-25 13:00:00	AAPL	Stock	39.005	39.0425	38.96	39.0175	2400404.0
2017-10-25 13:30:00	AAPL	Stock	39.0152	39.1	39.0152	39.0725	3013108.0
2017-10-25 14:00:00	AAPL	Stock	39.0725	39.1175	39.0612	39.0675	3224280.0
2017-10-25 14:30:00	AAPL	Stock	39.0658	39.075	38.9825	39.0325	3401080.0
2017-10-25 15:00:00	AAPL	Stock	39.03	39.1375	39.0075	39.125	3774844.0
2017-10-25 15:30:00	AAPL	Stock	39.1225	39.1338	39.0218	39.1025	6143532.0
2017-10-25 16:00:00	AAPL	Stock	39.105	39.275	39.1	39.275	8912436.0
2017-10-25 16:30:00	AAPL	Stock	39.1275	39.1375	39.1025	39.1175	13324.0
2017-10-25 17:00:00	AAPL	Stock	39.1175	39.1375	39.115	39.115	98304.0
2017-10-25 17:30:00	AAPL	Stock	39.12	39.135	39.12	39.135	6960.0
2017-10-25 18:00:00	AAPL	Stock	39.125	39.1375	39.125	39.1375	54384.0
2017-10-25 18:30:00	AAPL	Stock	39.1275	39.1275	39.125	39.125	4040.0
2017-10-25 19:00:00	AAPL	Stock	39.13	39.13	39.125	39.125	18660.0
2017-10-25 19:30:00	AAPL	Stock	39.1125	39.1375	39.105	39.1375	17528.0
2017-10-25 04:30:00	MSFT	Stock	78.7	78.7	78.7	78.7	100.0
2017-10-25 05:00:00	MSFT	Stock	78.61	78.89	78.61	78.89	600.0
2017-10-25 07:00:00	MSFT	Stock	78.95	79.37	78.8	78.8	5534.0
2017-10-25 07:30:00	MSFT	Stock	78.8	78.8	78.8	78.8	900.0
2017-10-25 08:00:00	MSFT	Stock	78.8	78.84	78.71	78.84	3093.0
2017-10-25 08:30:00	MSFT	Stock	78.8	78.82	78.7	78.7	3769.0
2017-10-25 09:00:00	MSFT	Stock	78.8	78.8	78.54	78.55	13983.0
2017-10-25 09:30:00	MSFT	Stock	78.55	79.03	78.53	78.74	1891076.0
2017-10-25 10:00:00	MSFT	Stock	78.73	79.1	78.73	79.054	1235273.0
2017-10-25 10:30:00	MSFT	Stock	79.05	79.05	78.73	78.815	1148575.0
2017-10-25 11:00:00	MSFT	Stock	78.81	78.82	78.2	78.41	1701605.0
2017-10-25 11:30:00	MSFT	Stock	78.42	78.54	78.385	78.52	998156.0
2017-10-25 12:00:00	MSFT	Stock	78.52	78.61	78.084	78.084	1628331.0
2017-10-25 12:30:00	MSFT	Stock	78.086	78.35	78.01	78.34	1185432.0
2017-10-25 13:00:00	MSFT	Stock	78.34	78.525	78.28	78.369	919800.0
2017-10-25 13:30:00	MSFT	Stock	78.365	78.455	78.34	78.375	725249.0
2017-10-25 14:00:00	MSFT	Stock	78.37	78.576	78.36	78.53	721952.0
2017-10-25 14:30:00	MSFT	Stock	78.525	78.56	78.46	78.55	546668.0
2017-10-25 15:00:00	MSFT	Stock	78.54	78.77	78.476	78.74	924893.0

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

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