PREVIEW / stock_30min / 2017-05-30

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-05-30.parquet
  size:    1.6 MB
  rows:    80,749
  symbols: 3,051

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-05-30 04:00:00	AAPL	Stock	38.4	38.4275	38.35	38.35	10756.0
2017-05-30 05:00:00	AAPL	Stock	38.3425	38.3425	38.31	38.31	2080.0
2017-05-30 06:00:00	AAPL	Stock	38.3325	38.3475	38.3225	38.325	20024.0
2017-05-30 06:30:00	AAPL	Stock	38.345	38.3475	38.3	38.3375	6500.0
2017-05-30 07:00:00	AAPL	Stock	38.3225	38.3225	38.29	38.3075	18360.0
2017-05-30 07:30:00	AAPL	Stock	38.3	38.3075	38.29	38.3	14016.0
2017-05-30 08:00:00	AAPL	Stock	38.305	38.345	38.2875	38.3225	121292.0
2017-05-30 08:30:00	AAPL	Stock	38.33	38.3375	38.305	38.32	78048.0
2017-05-30 09:00:00	AAPL	Stock	38.31	38.3625	38.3075	38.3575	53444.0
2017-05-30 09:30:00	AAPL	Stock	38.355	38.5175	38.3325	38.4625	10773928.0
2017-05-30 10:00:00	AAPL	Stock	38.4625	38.48	38.3325	38.3575	5725516.0
2017-05-30 10:30:00	AAPL	Stock	38.355	38.445	38.3525	38.425	4745296.0
2017-05-30 11:00:00	AAPL	Stock	38.4225	38.4725	38.4225	38.4412	3027196.0
2017-05-30 11:30:00	AAPL	Stock	38.44	38.48	38.4375	38.4725	2430964.0
2017-05-30 12:00:00	AAPL	Stock	38.4725	38.5888	38.47	38.5825	5001016.0
2017-05-30 12:30:00	AAPL	Stock	38.5842	38.6	38.55	38.5925	4417304.0
2017-05-30 13:00:00	AAPL	Stock	38.5925	38.6075	38.5125	38.5125	3607572.0
2017-05-30 13:30:00	AAPL	Stock	38.5125	38.5625	38.495	38.525	2974492.0
2017-05-30 14:00:00	AAPL	Stock	38.525	38.5372	38.495	38.5138	2570816.0
2017-05-30 14:30:00	AAPL	Stock	38.5125	38.5225	38.4662	38.4775	2853584.0
2017-05-30 15:00:00	AAPL	Stock	38.4785	38.51	38.4662	38.485	2827420.0
2017-05-30 15:30:00	AAPL	Stock	38.485	38.495	38.4062	38.4175	8478288.0
2017-05-30 16:00:00	AAPL	Stock	38.4175	38.511	38.261	38.405	8634788.0
2017-05-30 16:30:00	AAPL	Stock	38.405	38.4175	38.405	38.4075	144196.0
2017-05-30 17:00:00	AAPL	Stock	38.4125	38.4225	38.405	38.4225	7932.0
2017-05-30 17:30:00	AAPL	Stock	38.4075	38.415	38.4075	38.415	3976.0
2017-05-30 18:00:00	AAPL	Stock	38.415	38.415	38.415	38.415	400.0
2017-05-30 18:30:00	AAPL	Stock	38.415	38.42	38.415	38.42	9140.0
2017-05-30 19:00:00	AAPL	Stock	38.4125	38.4175	38.405	38.4175	4492.0
2017-05-30 19:30:00	AAPL	Stock	38.405	38.4125	38.4	38.4	11420.0
2017-05-30 06:00:00	MSFT	Stock	70.06	70.06	70.0	70.0	503.0
2017-05-30 06:30:00	MSFT	Stock	70.26	70.26	70.0	70.0	300.0
2017-05-30 07:00:00	MSFT	Stock	70.15	70.17	70.02	70.02	4100.0
2017-05-30 07:30:00	MSFT	Stock	69.9	69.95	69.89	69.95	2700.0
2017-05-30 08:00:00	MSFT	Stock	69.89	70.0	69.89	69.9	4242.0
2017-05-30 08:30:00	MSFT	Stock	69.9	69.94	69.89	69.94	3723.0
2017-05-30 09:00:00	MSFT	Stock	69.94	69.97	69.79	69.79	16494.0
2017-05-30 09:30:00	MSFT	Stock	69.79	70.09	69.77	70.0	2229708.0
2017-05-30 10:00:00	MSFT	Stock	70.01	70.2	69.93	69.99	1459666.0
2017-05-30 10:30:00	MSFT	Stock	69.99	70.11	69.965	69.97	974125.0
2017-05-30 11:00:00	MSFT	Stock	69.97	70.02	69.96	69.985	798288.0
2017-05-30 11:30:00	MSFT	Stock	69.985	70.18	69.975	70.15	817545.0
2017-05-30 12:00:00	MSFT	Stock	70.16	70.3	70.13	70.295	845873.0
2017-05-30 12:30:00	MSFT	Stock	70.295	70.32	70.1	70.18	584631.0
2017-05-30 13:00:00	MSFT	Stock	70.17	70.21	70.08	70.17	544141.0
2017-05-30 13:30:00	MSFT	Stock	70.175	70.23	70.14	70.173	623205.0
2017-05-30 14:00:00	MSFT	Stock	70.175	70.23	70.16	70.216	486835.0
2017-05-30 14:30:00	MSFT	Stock	70.216	70.24	70.15	70.21	442501.0
2017-05-30 15:00:00	MSFT	Stock	70.21	70.29	70.19	70.285	664896.0
2017-05-30 15:30:00	MSFT	Stock	70.285	70.41	70.27	70.41	3237829.0

> showing 50 of 80,749 rows — these rows as CSV

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