PREVIEW / stock_30min / 2017-08-09

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-08-09.parquet
  size:    1.6 MB
  rows:    82,125
  symbols: 2,991

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-08-09 04:00:00	AAPL	Stock	39.845	39.845	39.7525	39.8	14228.0
2017-08-09 05:00:00	AAPL	Stock	39.8625	39.8625	39.8625	39.8625	624.0
2017-08-09 05:30:00	AAPL	Stock	39.8375	39.8375	39.7875	39.7875	4000.0
2017-08-09 06:00:00	AAPL	Stock	39.775	39.82	39.75	39.82	15436.0
2017-08-09 06:30:00	AAPL	Stock	39.7875	39.82	39.7875	39.8	12372.0
2017-08-09 07:00:00	AAPL	Stock	39.79	39.85	39.7875	39.8225	83060.0
2017-08-09 07:30:00	AAPL	Stock	39.825	39.8475	39.6875	39.7275	96260.0
2017-08-09 08:00:00	AAPL	Stock	39.825	39.85	39.6825	39.75	286512.0
2017-08-09 08:30:00	AAPL	Stock	39.75	39.8625	39.7225	39.8225	227924.0
2017-08-09 09:00:00	AAPL	Stock	39.8225	39.825	39.7625	39.7725	204480.0
2017-08-09 09:30:00	AAPL	Stock	39.815	40.142	39.7775	40.0925	17228292.0
2017-08-09 10:00:00	AAPL	Stock	40.0938	40.175	39.8225	40.0975	8424148.0
2017-08-09 10:30:00	AAPL	Stock	40.0975	40.2625	40.0875	40.16	7230124.0
2017-08-09 11:00:00	AAPL	Stock	40.16	40.1675	39.9825	40.0225	5687092.0
2017-08-09 11:30:00	AAPL	Stock	40.0225	40.185	39.975	40.1825	5952616.0
2017-08-09 12:00:00	AAPL	Stock	40.185	40.195	40.0825	40.1375	3905048.0
2017-08-09 12:30:00	AAPL	Stock	40.1375	40.16	40.0425	40.0792	4839524.0
2017-08-09 13:00:00	AAPL	Stock	40.08	40.2312	40.08	40.16	4779388.0
2017-08-09 13:30:00	AAPL	Stock	40.16	40.31	40.1525	40.3	5148328.0
2017-08-09 14:00:00	AAPL	Stock	40.3025	40.3175	40.16	40.1982	5008444.0
2017-08-09 14:30:00	AAPL	Stock	40.1975	40.2125	40.1025	40.1625	5114156.0
2017-08-09 15:00:00	AAPL	Stock	40.1625	40.23	40.1	40.18	5003872.0
2017-08-09 15:30:00	AAPL	Stock	40.18	40.3025	40.1625	40.275	10906572.0
2017-08-09 16:00:00	AAPL	Stock	40.2775	40.2925	40.265	40.2925	3271084.0
2017-08-09 16:30:00	AAPL	Stock	40.2825	40.3075	40.1115	40.29	247836.0
2017-08-09 17:00:00	AAPL	Stock	40.3	40.3	40.265	40.2875	164196.0
2017-08-09 17:30:00	AAPL	Stock	40.2875	40.2975	40.275	40.28	18360.0
2017-08-09 18:00:00	AAPL	Stock	40.285	40.3125	40.285	40.305	109680.0
2017-08-09 18:30:00	AAPL	Stock	40.3	40.3125	40.2925	40.3025	26996.0
2017-08-09 19:00:00	AAPL	Stock	40.3075	40.3175	40.2925	40.3175	60840.0
2017-08-09 19:30:00	AAPL	Stock	40.3175	40.3225	40.2925	40.3	51172.0
2017-08-09 06:00:00	MSFT	Stock	72.5	72.5	72.5	72.5	492.0
2017-08-09 06:30:00	MSFT	Stock	72.33	72.33	72.33	72.33	200.0
2017-08-09 07:30:00	MSFT	Stock	72.35	72.4	72.35	72.4	1000.0
2017-08-09 08:00:00	MSFT	Stock	72.5	72.5	72.17	72.2	16948.0
2017-08-09 08:30:00	MSFT	Stock	72.3	72.3	72.06	72.09	15812.0
2017-08-09 09:00:00	MSFT	Stock	72.15	72.26	72.01	72.24	19704.0
2017-08-09 09:30:00	MSFT	Stock	72.25	72.39	72.05	72.275	3322006.0
2017-08-09 10:00:00	MSFT	Stock	72.28	72.4	72.139	72.33	1597391.0
2017-08-09 10:30:00	MSFT	Stock	72.33	72.48	72.28	72.33	1203704.0
2017-08-09 11:00:00	MSFT	Stock	72.33	72.36	72.12	72.25	887543.0
2017-08-09 11:30:00	MSFT	Stock	72.25	72.505	72.21	72.455	1181378.0
2017-08-09 12:00:00	MSFT	Stock	72.46	72.5	72.35	72.495	695990.0
2017-08-09 12:30:00	MSFT	Stock	72.5	72.51	72.35	72.36	692138.0
2017-08-09 13:00:00	MSFT	Stock	72.36	72.46	72.3	72.32	670443.0
2017-08-09 13:30:00	MSFT	Stock	72.32	72.419	72.3	72.355	661011.0
2017-08-09 14:00:00	MSFT	Stock	72.355	72.365	72.22	72.31	858692.0
2017-08-09 14:30:00	MSFT	Stock	72.315	72.39	72.23	72.38	874540.0
2017-08-09 15:00:00	MSFT	Stock	72.38	72.41	72.3	72.315	1287941.0
2017-08-09 15:30:00	MSFT	Stock	72.32	72.51	72.26	72.45	2876358.0

> showing 50 of 82,125 rows — these rows as CSV

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