PREVIEW / stock_30min / 2016-03-02

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-03-02.parquet
  size:    1.6 MB
  rows:    81,230
  symbols: 3,349

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
2016-03-02 04:00:00	AAPL	Stock	25.2125	25.2375	25.2125	25.235	10336.0
2016-03-02 04:30:00	AAPL	Stock	25.2025	25.215	25.2025	25.215	6600.0
2016-03-02 05:00:00	AAPL	Stock	25.215	25.215	25.2	25.2	2400.0
2016-03-02 05:30:00	AAPL	Stock	25.175	25.175	25.155	25.155	1960.0
2016-03-02 06:00:00	AAPL	Stock	25.16	25.175	25.1325	25.1325	9276.0
2016-03-02 06:30:00	AAPL	Stock	25.1625	25.1625	25.1625	25.1625	6320.0
2016-03-02 07:00:00	AAPL	Stock	25.15	25.175	25.125	25.125	37292.0
2016-03-02 07:30:00	AAPL	Stock	25.15	25.2125	25.15	25.2125	44712.0
2016-03-02 08:00:00	AAPL	Stock	25.2	25.2125	25.13	25.1375	203344.0
2016-03-02 08:30:00	AAPL	Stock	25.1375	25.155	25.115	25.115	171016.0
2016-03-02 09:00:00	AAPL	Stock	25.115	25.1875	25.1	25.1275	139848.0
2016-03-02 09:30:00	AAPL	Stock	25.1275	25.2225	25.0165	25.045	18737800.0
2016-03-02 10:00:00	AAPL	Stock	25.045	25.0825	24.92	24.9912	14175296.0
2016-03-02 10:30:00	AAPL	Stock	24.99	25.09	24.935	25.0825	12148612.0
2016-03-02 11:00:00	AAPL	Stock	25.08	25.0925	24.99	25.01	7398328.0
2016-03-02 11:30:00	AAPL	Stock	25.01	25.03	24.9625	24.984	7539248.0
2016-03-02 12:00:00	AAPL	Stock	24.983	24.9975	24.91	24.9725	6701832.0
2016-03-02 12:30:00	AAPL	Stock	24.9725	25.055	24.965	25.0225	5521180.0
2016-03-02 13:00:00	AAPL	Stock	25.025	25.1875	24.9875	25.019	3839036.0
2016-03-02 13:30:00	AAPL	Stock	25.0175	25.0292	24.965	24.9825	3915756.0
2016-03-02 14:00:00	AAPL	Stock	24.9825	25.0272	24.9125	25.005	8525956.0
2016-03-02 14:30:00	AAPL	Stock	25.0072	25.105	25.005	25.09	5572148.0
2016-03-02 15:00:00	AAPL	Stock	25.09	25.125	25.0175	25.1075	6353092.0
2016-03-02 15:30:00	AAPL	Stock	25.1075	25.2125	25.061	25.1825	13343424.0
2016-03-02 16:00:00	AAPL	Stock	25.1875	25.215	24.9725	25.18	7797524.0
2016-03-02 16:30:00	AAPL	Stock	25.18	25.185	25.17	25.1725	77292.0
2016-03-02 17:00:00	AAPL	Stock	25.1875	25.1975	25.175	25.1975	39652.0
2016-03-02 17:30:00	AAPL	Stock	25.175	25.2125	25.175	25.21	28136.0
2016-03-02 18:00:00	AAPL	Stock	25.1875	25.195	25.1675	25.1675	25452.0
2016-03-02 18:30:00	AAPL	Stock	25.1875	25.1875	25.1675	25.185	38900.0
2016-03-02 19:00:00	AAPL	Stock	25.17	25.1875	25.165	25.175	27080.0
2016-03-02 19:30:00	AAPL	Stock	25.175	25.175	25.1675	25.175	30580.0
2016-03-02 07:30:00	MSFT	Stock	52.59	52.59	52.59	52.59	100.0
2016-03-02 08:00:00	MSFT	Stock	52.6	52.83	52.5	52.55	8440.0
2016-03-02 08:30:00	MSFT	Stock	52.42	52.42	52.42	52.42	427.0
2016-03-02 09:00:00	MSFT	Stock	52.42	52.46	52.42	52.46	4759.0
2016-03-02 09:30:00	MSFT	Stock	52.41	52.66	52.155	52.26	2517081.0
2016-03-02 10:00:00	MSFT	Stock	52.26	52.55	52.225	52.47	2008153.0
2016-03-02 10:30:00	MSFT	Stock	52.46	52.5	52.16	52.47	1798955.0
2016-03-02 11:00:00	MSFT	Stock	52.46	52.54	52.2	52.264	1771242.0
2016-03-02 11:30:00	MSFT	Stock	52.27	52.41	52.25	52.33	1434335.0
2016-03-02 12:00:00	MSFT	Stock	52.33	52.365	52.27	52.34	1241907.0
2016-03-02 12:30:00	MSFT	Stock	52.33	52.48	52.27	52.445	1173361.0
2016-03-02 13:00:00	MSFT	Stock	52.45	52.48	52.3	52.45	932353.0
2016-03-02 13:30:00	MSFT	Stock	52.45	52.626	52.4	52.41	970204.0
2016-03-02 14:00:00	MSFT	Stock	52.4	52.59	52.4	52.56	1093830.0
2016-03-02 14:30:00	MSFT	Stock	52.56	52.75	52.54	52.735	1232607.0
2016-03-02 15:00:00	MSFT	Stock	52.73	52.84	52.65	52.8	2332154.0
2016-03-02 15:30:00	MSFT	Stock	52.8	52.96	52.71	52.95	3921196.0
2016-03-02 16:00:00	MSFT	Stock	52.95	52.95	52.88	52.9	4371017.0

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

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