PREVIEW / stock_30min / 2017-09-13

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-09-13.parquet
  size:    1.6 MB
  rows:    81,778
  symbols: 2,965

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-13 04:00:00	AAPL	Stock	40.1025	40.15	40.025	40.125	28672.0
2017-09-13 04:30:00	AAPL	Stock	40.15	40.15	40.025	40.045	24424.0
2017-09-13 05:00:00	AAPL	Stock	40.045	40.125	40.045	40.0625	24444.0
2017-09-13 05:30:00	AAPL	Stock	40.07	40.07	39.975	39.975	27232.0
2017-09-13 06:00:00	AAPL	Stock	39.9975	39.9975	39.925	39.98	57204.0
2017-09-13 06:30:00	AAPL	Stock	39.97	39.9925	39.925	39.925	59332.0
2017-09-13 07:00:00	AAPL	Stock	39.925	40.0525	39.925	39.9575	199056.0
2017-09-13 07:30:00	AAPL	Stock	39.945	40.0475	39.935	40.02	158852.0
2017-09-13 08:00:00	AAPL	Stock	39.9375	40.1	39.925	40.07	465548.0
2017-09-13 08:30:00	AAPL	Stock	40.0575	40.075	39.955	39.975	342236.0
2017-09-13 09:00:00	AAPL	Stock	39.97	40.0	39.925	39.9775	693584.0
2017-09-13 09:30:00	AAPL	Stock	39.9675	39.99	39.6625	39.7835	33221700.0
2017-09-13 10:00:00	AAPL	Stock	39.785	39.8475	39.6	39.6725	21620936.0
2017-09-13 10:30:00	AAPL	Stock	39.6772	39.725	39.4775	39.5875	19326908.0
2017-09-13 11:00:00	AAPL	Stock	39.59	39.77	39.5775	39.7325	11584896.0
2017-09-13 11:30:00	AAPL	Stock	39.735	39.7675	39.5625	39.57	9339128.0
2017-09-13 12:00:00	AAPL	Stock	39.57	39.795	39.5625	39.77	10666976.0
2017-09-13 12:30:00	AAPL	Stock	39.7715	39.8575	39.7	39.7038	6916176.0
2017-09-13 13:00:00	AAPL	Stock	39.7025	39.7975	39.69	39.7685	5026952.0
2017-09-13 13:30:00	AAPL	Stock	39.769	39.7825	39.7075	39.7375	4084204.0
2017-09-13 14:00:00	AAPL	Stock	39.74	39.8075	39.7275	39.7425	4287864.0
2017-09-13 14:30:00	AAPL	Stock	39.7425	39.76	39.7	39.7125	3727544.0
2017-09-13 15:00:00	AAPL	Stock	39.7125	39.7675	39.7	39.7588	4819304.0
2017-09-13 15:30:00	AAPL	Stock	39.7575	39.915	39.7575	39.905	16432360.0
2017-09-13 16:00:00	AAPL	Stock	39.9025	39.915	39.865	39.9	10153048.0
2017-09-13 16:30:00	AAPL	Stock	39.89	39.9125	39.875	39.9025	166392.0
2017-09-13 17:00:00	AAPL	Stock	39.9	39.9075	39.8875	39.9075	26136.0
2017-09-13 17:30:00	AAPL	Stock	39.9	39.9	39.875	39.88	31548.0
2017-09-13 18:00:00	AAPL	Stock	39.88	39.88	39.85	39.86	25556.0
2017-09-13 18:30:00	AAPL	Stock	39.85	39.8975	39.8375	39.8775	19520.0
2017-09-13 19:00:00	AAPL	Stock	39.86	39.895	39.86	39.88	24780.0
2017-09-13 19:30:00	AAPL	Stock	39.88	39.8875	39.8575	39.86	40724.0
2017-09-13 07:00:00	MSFT	Stock	74.68	74.68	74.65	74.65	1957.0
2017-09-13 09:00:00	MSFT	Stock	74.6	75.0	74.57	74.93	29550.0
2017-09-13 09:30:00	MSFT	Stock	74.93	75.18	74.55	75.05	1538356.0
2017-09-13 10:00:00	MSFT	Stock	75.057	75.057	74.68	74.68	674583.0
2017-09-13 10:30:00	MSFT	Stock	74.685	75.03	74.68	75.018	899167.0
2017-09-13 11:00:00	MSFT	Stock	75.02	75.1	74.95	74.95	726973.0
2017-09-13 11:30:00	MSFT	Stock	74.96	74.98	74.82	74.87	438851.0
2017-09-13 12:00:00	MSFT	Stock	74.87	74.95	74.85	74.915	278783.0
2017-09-13 12:30:00	MSFT	Stock	74.915	75.015	74.9	74.915	402936.0
2017-09-13 13:00:00	MSFT	Stock	74.92	75.04	74.84	75.014	580124.0
2017-09-13 13:30:00	MSFT	Stock	75.015	75.11	75.005	75.085	555029.0
2017-09-13 14:00:00	MSFT	Stock	75.085	75.136	75.02	75.1	553184.0
2017-09-13 14:30:00	MSFT	Stock	75.1	75.14	75.07	75.095	724904.0
2017-09-13 15:00:00	MSFT	Stock	75.09	75.109	75.0	75.055	613127.0
2017-09-13 15:30:00	MSFT	Stock	75.055	75.23	75.03	75.2	2363620.0
2017-09-13 16:00:00	MSFT	Stock	75.19	75.22	75.04	75.18	1830606.0
2017-09-13 16:30:00	MSFT	Stock	75.18	75.18	75.15	75.15	464.0
2017-09-13 17:00:00	MSFT	Stock	75.17	75.17	75.17	75.17	100.0

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

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