PREVIEW / stock_30min / 2018-02-13

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-02-13.parquet
  size:    1.6 MB
  rows:    82,863
  symbols: 2,882

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
2018-02-13 04:00:00	AAPL	Stock	40.6625	40.6625	40.525	40.625	14172.0
2018-02-13 04:30:00	AAPL	Stock	40.5775	40.5775	40.495	40.51	9708.0
2018-02-13 05:00:00	AAPL	Stock	40.5625	40.5625	40.475	40.475	1888.0
2018-02-13 05:30:00	AAPL	Stock	40.5475	40.5475	40.48	40.5375	12292.0
2018-02-13 06:00:00	AAPL	Stock	40.5075	40.5075	40.425	40.425	25192.0
2018-02-13 06:30:00	AAPL	Stock	40.425	40.5	40.425	40.5	12224.0
2018-02-13 07:00:00	AAPL	Stock	40.525	40.5275	40.4125	40.5275	98100.0
2018-02-13 07:30:00	AAPL	Stock	40.5075	40.565	40.4175	40.55	159992.0
2018-02-13 08:00:00	AAPL	Stock	40.45	40.575	40.4125	40.525	200960.0
2018-02-13 08:30:00	AAPL	Stock	40.525	40.58	40.4125	40.4175	199524.0
2018-02-13 09:00:00	AAPL	Stock	40.4225	40.4825	40.3575	40.475	342732.0
2018-02-13 09:30:00	AAPL	Stock	40.4875	40.8175	40.4125	40.63	18581884.0
2018-02-13 10:00:00	AAPL	Stock	40.615	40.7675	40.565	40.69	9613496.0
2018-02-13 10:30:00	AAPL	Stock	40.69	40.945	40.62	40.9025	8534412.0
2018-02-13 11:00:00	AAPL	Stock	40.9025	40.905	40.73	40.7375	7390536.0
2018-02-13 11:30:00	AAPL	Stock	40.7375	40.7925	40.62	40.7425	5167176.0
2018-02-13 12:00:00	AAPL	Stock	40.745	40.7775	40.6575	40.7125	4464696.0
2018-02-13 12:30:00	AAPL	Stock	40.7075	40.7525	40.615	40.69	4407660.0
2018-02-13 13:00:00	AAPL	Stock	40.6908	41.055	40.6875	40.9325	7937420.0
2018-02-13 13:30:00	AAPL	Stock	40.93	40.985	40.815	40.8675	4974472.0
2018-02-13 14:00:00	AAPL	Stock	40.8675	41.0475	40.8475	41.0275	6406564.0
2018-02-13 14:30:00	AAPL	Stock	41.0275	41.105	40.9425	41.0725	6284800.0
2018-02-13 15:00:00	AAPL	Stock	41.0725	41.1425	40.95	41.1225	8062016.0
2018-02-13 15:30:00	AAPL	Stock	41.125	41.1875	41.05	41.0862	12248648.0
2018-02-13 16:00:00	AAPL	Stock	41.085	41.0925	40.7388	41.0875	5095852.0
2018-02-13 16:30:00	AAPL	Stock	41.0625	41.0925	40.9542	41.055	708444.0
2018-02-13 17:00:00	AAPL	Stock	41.0525	41.0525	40.9625	40.9875	67732.0
2018-02-13 17:30:00	AAPL	Stock	41.0	41.0	40.95	40.9875	25072.0
2018-02-13 18:00:00	AAPL	Stock	40.9875	41.005	40.975	40.995	9688.0
2018-02-13 18:30:00	AAPL	Stock	41.0	41.0425	41.0	41.0125	5776.0
2018-02-13 19:00:00	AAPL	Stock	41.025	41.025	41.0125	41.0175	5868.0
2018-02-13 19:30:00	AAPL	Stock	41.0125	41.0625	41.0125	41.025	24788.0
2018-02-13 04:00:00	MSFT	Stock	88.67	88.67	88.67	88.67	800.0
2018-02-13 06:30:00	MSFT	Stock	88.84	88.85	88.84	88.85	609.0
2018-02-13 07:00:00	MSFT	Stock	88.98	88.99	88.84	88.99	2429.0
2018-02-13 07:30:00	MSFT	Stock	88.85	88.97	88.84	88.85	2570.0
2018-02-13 08:00:00	MSFT	Stock	88.825	88.93	88.8	88.84	11553.0
2018-02-13 08:30:00	MSFT	Stock	88.83	88.87	88.5	88.79	20681.0
2018-02-13 09:00:00	MSFT	Stock	88.76	88.76	88.4	88.4	26961.0
2018-02-13 09:30:00	MSFT	Stock	88.93	88.93	87.8	88.348	3380085.0
2018-02-13 10:00:00	MSFT	Stock	88.33	89.04	88.33	88.84	1974594.0
2018-02-13 10:30:00	MSFT	Stock	88.85	89.11	88.64	88.887	1494481.0
2018-02-13 11:00:00	MSFT	Stock	88.885	88.99	88.55	88.705	1366457.0
2018-02-13 11:30:00	MSFT	Stock	88.7	88.92	88.49	88.9	1012080.0
2018-02-13 12:00:00	MSFT	Stock	88.9	89.15	88.84	88.86	992186.0
2018-02-13 12:30:00	MSFT	Stock	88.85	88.98	88.68	88.86	743266.0
2018-02-13 13:00:00	MSFT	Stock	88.85	89.67	88.85	89.5	1438433.0
2018-02-13 13:30:00	MSFT	Stock	89.49	89.755	89.42	89.53	1157119.0
2018-02-13 14:00:00	MSFT	Stock	89.53	89.83	89.475	89.6	985143.0
2018-02-13 14:30:00	MSFT	Stock	89.59	89.73	89.36	89.68	1308162.0

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

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