PREVIEW / stock_30min / 2017-09-05

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-09-05.parquet
  size:    1.6 MB
  rows:    82,471
  symbols: 2,992

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-05 04:00:00	AAPL	Stock	41.0	41.0	40.9375	41.0	35036.0
2017-09-05 04:30:00	AAPL	Stock	41.01	41.01	41.0	41.0	17936.0
2017-09-05 05:00:00	AAPL	Stock	40.9825	41.0	40.9825	41.0	7580.0
2017-09-05 05:30:00	AAPL	Stock	41.02	41.02	41.02	41.02	400.0
2017-09-05 06:00:00	AAPL	Stock	40.955	40.955	40.9125	40.9125	15304.0
2017-09-05 06:30:00	AAPL	Stock	40.8925	40.8925	40.8925	40.8925	2704.0
2017-09-05 07:00:00	AAPL	Stock	40.8925	40.955	40.8925	40.945	27160.0
2017-09-05 07:30:00	AAPL	Stock	40.96	40.9625	40.9375	40.9475	20880.0
2017-09-05 08:00:00	AAPL	Stock	40.9375	41.0975	40.7875	40.8	340544.0
2017-09-05 08:30:00	AAPL	Stock	40.8075	40.9375	40.8075	40.855	129228.0
2017-09-05 09:00:00	AAPL	Stock	40.8625	40.9675	40.83	40.9675	114444.0
2017-09-05 09:30:00	AAPL	Stock	40.92	41.0625	40.8442	41.0125	13120748.0
2017-09-05 10:00:00	AAPL	Stock	41.0125	41.0425	40.9275	40.9888	7333896.0
2017-09-05 10:30:00	AAPL	Stock	40.9875	40.9875	40.8912	40.91	6085168.0
2017-09-05 11:00:00	AAPL	Stock	40.91	40.913	40.66	40.74	8161028.0
2017-09-05 11:30:00	AAPL	Stock	40.7425	40.8125	40.703	40.7262	4085588.0
2017-09-05 12:00:00	AAPL	Stock	40.725	40.725	40.3675	40.39	12268836.0
2017-09-05 12:30:00	AAPL	Stock	40.3925	40.395	40.15	40.2975	12630536.0
2017-09-05 13:00:00	AAPL	Stock	40.2925	40.3575	40.14	40.35	8214784.0
2017-09-05 13:30:00	AAPL	Stock	40.35	40.495	40.295	40.4875	5598280.0
2017-09-05 14:00:00	AAPL	Stock	40.485	40.555	40.4427	40.531	5141156.0
2017-09-05 14:30:00	AAPL	Stock	40.531	40.57	40.4525	40.485	4068564.0
2017-09-05 15:00:00	AAPL	Stock	40.4825	40.535	40.4	40.5125	5202888.0
2017-09-05 15:30:00	AAPL	Stock	40.5125	40.5675	40.4588	40.52	8567072.0
2017-09-05 16:00:00	AAPL	Stock	40.52	40.575	40.52	40.575	6192332.0
2017-09-05 16:30:00	AAPL	Stock	40.575	40.5875	40.5525	40.58	41488.0
2017-09-05 17:00:00	AAPL	Stock	40.56	40.5725	40.55	40.55	42468.0
2017-09-05 17:30:00	AAPL	Stock	40.55	40.55	40.5025	40.52	54612.0
2017-09-05 18:00:00	AAPL	Stock	40.5375	40.545	40.505	40.505	28624.0
2017-09-05 18:30:00	AAPL	Stock	40.52	40.525	40.51	40.5125	17996.0
2017-09-05 19:00:00	AAPL	Stock	40.5225	40.5225	40.5075	40.5125	13456.0
2017-09-05 19:30:00	AAPL	Stock	40.5225	40.5225	40.505	40.5075	41272.0
2017-09-05 04:00:00	MSFT	Stock	73.78	73.78	73.58	73.58	334.0
2017-09-05 04:30:00	MSFT	Stock	74.33	74.33	73.88	73.88	358.0
2017-09-05 06:00:00	MSFT	Stock	73.82	73.82	73.82	73.82	2779.0
2017-09-05 07:00:00	MSFT	Stock	73.73	73.8	73.73	73.75	1457.0
2017-09-05 07:30:00	MSFT	Stock	73.73	73.73	73.73	73.73	129.0
2017-09-05 08:00:00	MSFT	Stock	73.75	73.75	73.62	73.68	4173.0
2017-09-05 08:30:00	MSFT	Stock	73.68	73.75	73.68	73.7	4685.0
2017-09-05 09:00:00	MSFT	Stock	73.68	73.7	73.22	73.39	98159.0
2017-09-05 09:30:00	MSFT	Stock	73.34	73.89	73.314	73.84	3166301.0
2017-09-05 10:00:00	MSFT	Stock	73.84	73.89	73.625	73.655	1602859.0
2017-09-05 10:30:00	MSFT	Stock	73.65	73.68	73.511	73.605	1274851.0
2017-09-05 11:00:00	MSFT	Stock	73.61	73.61	73.455	73.515	913622.0
2017-09-05 11:30:00	MSFT	Stock	73.51	73.7	73.495	73.65	744950.0
2017-09-05 12:00:00	MSFT	Stock	73.66	73.66	73.225	73.253	1664367.0
2017-09-05 12:30:00	MSFT	Stock	73.254	73.32	73.02	73.29	1285901.0
2017-09-05 13:00:00	MSFT	Stock	73.28	73.28	72.98	73.171	1111705.0
2017-09-05 13:30:00	MSFT	Stock	73.17	73.35	73.135	73.35	705156.0
2017-09-05 14:00:00	MSFT	Stock	73.35	73.55	73.32	73.5	698502.0

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

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