PREVIEW / stock_30min / 2016-07-12

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-07-12.parquet
  size:    1.6 MB
  rows:    83,351
  symbols: 3,275

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-07-12 04:00:00	AAPL	Stock	24.235	24.395	24.235	24.395	4180.0
2016-07-12 04:30:00	AAPL	Stock	24.3875	24.39	24.3875	24.39	2460.0
2016-07-12 05:00:00	AAPL	Stock	24.3775	24.3775	24.3775	24.3775	612.0
2016-07-12 05:30:00	AAPL	Stock	24.3725	24.3775	24.3725	24.3775	1816.0
2016-07-12 06:00:00	AAPL	Stock	24.35	24.35	24.35	24.35	400.0
2016-07-12 07:00:00	AAPL	Stock	24.3525	24.375	24.3525	24.3625	28088.0
2016-07-12 07:30:00	AAPL	Stock	24.36	24.36	24.3375	24.3475	49740.0
2016-07-12 08:00:00	AAPL	Stock	24.35	24.375	24.3375	24.3475	200236.0
2016-07-12 08:30:00	AAPL	Stock	24.345	24.35	24.3425	24.3475	69748.0
2016-07-12 09:00:00	AAPL	Stock	24.35	24.365	24.295	24.295	309904.0
2016-07-12 09:30:00	AAPL	Stock	24.295	24.425	24.28	24.3925	16122088.0
2016-07-12 10:00:00	AAPL	Stock	24.3912	24.4075	24.3175	24.34	8551420.0
2016-07-12 10:30:00	AAPL	Stock	24.3425	24.3625	24.335	24.35	6094712.0
2016-07-12 11:00:00	AAPL	Stock	24.3475	24.3612	24.3162	24.3558	5233676.0
2016-07-12 11:30:00	AAPL	Stock	24.355	24.3725	24.34	24.3625	4153356.0
2016-07-12 12:00:00	AAPL	Stock	24.3635	24.3825	24.3575	24.3762	3720760.0
2016-07-12 12:30:00	AAPL	Stock	24.38	24.3825	24.35	24.3525	3612224.0
2016-07-12 13:00:00	AAPL	Stock	24.3525	24.3618	24.325	24.3375	3481636.0
2016-07-12 13:30:00	AAPL	Stock	24.3375	24.3562	24.3125	24.32	3944872.0
2016-07-12 14:00:00	AAPL	Stock	24.32	24.3725	24.31	24.3575	4647580.0
2016-07-12 14:30:00	AAPL	Stock	24.36	24.37	24.3375	24.3412	4365952.0
2016-07-12 15:00:00	AAPL	Stock	24.3435	24.3675	24.3025	24.3225	5710032.0
2016-07-12 15:30:00	AAPL	Stock	24.3225	24.355	24.305	24.355	11801812.0
2016-07-12 16:00:00	AAPL	Stock	24.3525	24.355	24.335	24.355	6381240.0
2016-07-12 16:30:00	AAPL	Stock	24.3575	24.3825	24.355	24.3575	749404.0
2016-07-12 17:00:00	AAPL	Stock	24.3725	24.3825	24.3575	24.3725	40280.0
2016-07-12 17:30:00	AAPL	Stock	24.355	24.3575	24.355	24.3575	7624.0
2016-07-12 18:00:00	AAPL	Stock	24.355	24.355	24.35	24.35	19724.0
2016-07-12 18:30:00	AAPL	Stock	24.35	24.355	24.35	24.3525	2296.0
2016-07-12 19:00:00	AAPL	Stock	24.355	24.355	24.3525	24.3525	7200.0
2016-07-12 19:30:00	AAPL	Stock	24.3525	24.3625	24.3525	24.3625	56760.0
2016-07-12 06:30:00	MSFT	Stock	52.97	52.98	52.97	52.98	7167.0
2016-07-12 07:00:00	MSFT	Stock	52.97	53.07	52.97	53.04	5369.0
2016-07-12 07:30:00	MSFT	Stock	53.04	53.04	53.0	53.0	2900.0
2016-07-12 08:00:00	MSFT	Stock	53.0	53.0	52.9	52.93	4000.0
2016-07-12 08:30:00	MSFT	Stock	53.0	53.05	52.93	53.04	13971.0
2016-07-12 09:00:00	MSFT	Stock	53.04	53.07	52.93	52.94	33553.0
2016-07-12 09:30:00	MSFT	Stock	52.94	53.0	52.785	52.87	2740170.0
2016-07-12 10:00:00	MSFT	Stock	52.875	53.18	52.85	53.15	3526161.0
2016-07-12 10:30:00	MSFT	Stock	53.15	53.205	53.11	53.137	1602147.0
2016-07-12 11:00:00	MSFT	Stock	53.14	53.21	53.12	53.185	1277244.0
2016-07-12 11:30:00	MSFT	Stock	53.185	53.37	53.17	53.335	1301289.0
2016-07-12 12:00:00	MSFT	Stock	53.339	53.4	53.31	53.354	1227836.0
2016-07-12 12:30:00	MSFT	Stock	53.36	53.37	53.235	53.28	999765.0
2016-07-12 13:00:00	MSFT	Stock	53.28	53.3	53.2	53.255	970902.0
2016-07-12 13:30:00	MSFT	Stock	53.26	53.38	53.2	53.22	1035474.0
2016-07-12 14:00:00	MSFT	Stock	53.22	53.345	53.22	53.3	1145841.0
2016-07-12 14:30:00	MSFT	Stock	53.295	53.39	53.23	53.295	1350752.0
2016-07-12 15:00:00	MSFT	Stock	53.3	53.36	53.175	53.19	1668104.0
2016-07-12 15:30:00	MSFT	Stock	53.194	53.24	53.135	53.21	4197202.0

> showing 50 of 83,351 rows — these rows as CSV

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