PREVIEW / stock_30min / 2017-09-28

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-09-28.parquet
  size:    1.6 MB
  rows:    84,960
  symbols: 2,948

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-09-28 04:00:00	AAPL	Stock	38.5575	38.5725	38.5525	38.5525	3080.0
2017-09-28 05:00:00	AAPL	Stock	38.5875	38.5875	38.5875	38.5875	400.0
2017-09-28 06:00:00	AAPL	Stock	38.575	38.61	38.575	38.61	4928.0
2017-09-28 06:30:00	AAPL	Stock	38.6	38.6125	38.595	38.595	6400.0
2017-09-28 07:00:00	AAPL	Stock	38.5775	38.5925	38.5575	38.5575	21452.0
2017-09-28 07:30:00	AAPL	Stock	38.56	38.56	38.465	38.465	25052.0
2017-09-28 08:00:00	AAPL	Stock	38.5862	38.595	38.4375	38.4625	112780.0
2017-09-28 08:30:00	AAPL	Stock	38.4375	38.5	38.4375	38.49	112904.0
2017-09-28 09:00:00	AAPL	Stock	38.475	38.5125	38.425	38.455	181316.0
2017-09-28 09:30:00	AAPL	Stock	38.4575	38.57	38.3225	38.34	13981936.0
2017-09-28 10:00:00	AAPL	Stock	38.3375	38.3625	38.175	38.33	11157692.0
2017-09-28 10:30:00	AAPL	Stock	38.326	38.33	38.205	38.2225	7048652.0
2017-09-28 11:00:00	AAPL	Stock	38.2225	38.27	38.1825	38.2275	5490604.0
2017-09-28 11:30:00	AAPL	Stock	38.23	38.295	38.185	38.2315	4369496.0
2017-09-28 12:00:00	AAPL	Stock	38.235	38.29	38.21	38.2625	3195112.0
2017-09-28 12:30:00	AAPL	Stock	38.2625	38.31	38.25	38.2925	3357040.0
2017-09-28 13:00:00	AAPL	Stock	38.2925	38.335	38.2625	38.3198	2439296.0
2017-09-28 13:30:00	AAPL	Stock	38.319	38.3875	38.305	38.375	3052220.0
2017-09-28 14:00:00	AAPL	Stock	38.375	38.3815	38.2625	38.274	2926528.0
2017-09-28 14:30:00	AAPL	Stock	38.2775	38.305	38.23	38.2775	3495972.0
2017-09-28 15:00:00	AAPL	Stock	38.2762	38.285	38.2225	38.235	3641808.0
2017-09-28 15:30:00	AAPL	Stock	38.235	38.325	38.225	38.315	8740264.0
2017-09-28 16:00:00	AAPL	Stock	38.32	38.3275	38.25	38.325	6227884.0
2017-09-28 16:30:00	AAPL	Stock	38.3325	38.3475	38.325	38.3475	28236.0
2017-09-28 17:00:00	AAPL	Stock	38.3325	38.36	38.3325	38.36	13708.0
2017-09-28 17:30:00	AAPL	Stock	38.3575	38.3625	38.34	38.35	8372.0
2017-09-28 18:00:00	AAPL	Stock	38.3375	38.3475	38.32	38.32	16032.0
2017-09-28 18:30:00	AAPL	Stock	38.3225	38.3425	38.32	38.3375	13732.0
2017-09-28 19:00:00	AAPL	Stock	38.3375	38.3375	38.33	38.33	3200.0
2017-09-28 19:30:00	AAPL	Stock	38.32	38.32	38.3125	38.3175	21608.0
2017-09-28 06:00:00	MSFT	Stock	73.9	73.9	73.9	73.9	500.0
2017-09-28 08:00:00	MSFT	Stock	73.9	73.9	73.78	73.78	2335.0
2017-09-28 08:30:00	MSFT	Stock	73.77	73.77	73.7	73.7	1825.0
2017-09-28 09:00:00	MSFT	Stock	73.61	73.7	73.49	73.49	41949.0
2017-09-28 09:30:00	MSFT	Stock	73.49	73.72	73.31	73.628	1625333.0
2017-09-28 10:00:00	MSFT	Stock	73.63	73.8	73.53	73.78	736667.0
2017-09-28 10:30:00	MSFT	Stock	73.78	73.97	73.71	73.72	673369.0
2017-09-28 11:00:00	MSFT	Stock	73.72	73.785	73.63	73.77	513122.0
2017-09-28 11:30:00	MSFT	Stock	73.78	73.79	73.635	73.69	466674.0
2017-09-28 12:00:00	MSFT	Stock	73.69	73.816	73.645	73.723	311035.0
2017-09-28 12:30:00	MSFT	Stock	73.72	73.78	73.585	73.755	386551.0
2017-09-28 13:00:00	MSFT	Stock	73.751	73.82	73.65	73.79	341686.0
2017-09-28 13:30:00	MSFT	Stock	73.785	73.91	73.77	73.857	380487.0
2017-09-28 14:00:00	MSFT	Stock	73.86	73.89	73.71	73.72	429806.0
2017-09-28 14:30:00	MSFT	Stock	73.72	73.805	73.673	73.77	447423.0
2017-09-28 15:00:00	MSFT	Stock	73.76	73.84	73.708	73.73	449276.0
2017-09-28 15:30:00	MSFT	Stock	73.725	73.9	73.68	73.86	1610509.0
2017-09-28 16:00:00	MSFT	Stock	73.87	73.98	73.794	73.98	1695150.0
2017-09-28 16:30:00	MSFT	Stock	73.87	73.87	73.87	73.87	275.0
2017-09-28 17:00:00	MSFT	Stock	73.87	73.87	73.87	73.87	100.0

> showing 50 of 84,960 rows — these rows as CSV

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