PREVIEW / stock_30min / 2017-02-28

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-02-28.parquet
  size:    1.6 MB
  rows:    82,738
  symbols: 3,103

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-02-28 04:00:00	AAPL	Stock	34.2675	34.2675	34.21	34.21	2000.0
2017-02-28 05:00:00	AAPL	Stock	34.2875	34.325	34.285	34.285	29736.0
2017-02-28 05:30:00	AAPL	Stock	34.3125	34.3175	34.3125	34.3175	3596.0
2017-02-28 06:00:00	AAPL	Stock	34.3175	34.325	34.3175	34.325	12916.0
2017-02-28 06:30:00	AAPL	Stock	34.3	34.3075	34.2875	34.3075	5940.0
2017-02-28 07:00:00	AAPL	Stock	34.3	34.3	34.285	34.29	40836.0
2017-02-28 07:30:00	AAPL	Stock	34.29	34.3025	34.275	34.2975	28316.0
2017-02-28 08:00:00	AAPL	Stock	34.305	34.3075	34.2375	34.2725	260120.0
2017-02-28 08:30:00	AAPL	Stock	34.265	34.265	34.2375	34.25	162692.0
2017-02-28 09:00:00	AAPL	Stock	34.24	34.3	34.2375	34.2725	231608.0
2017-02-28 09:30:00	AAPL	Stock	34.275	34.3525	34.2075	34.2375	11568796.0
2017-02-28 10:00:00	AAPL	Stock	34.2375	34.345	34.225	34.3225	5850572.0
2017-02-28 10:30:00	AAPL	Stock	34.325	34.3588	34.2975	34.3062	4318004.0
2017-02-28 11:00:00	AAPL	Stock	34.3062	34.345	34.2725	34.3212	3876408.0
2017-02-28 11:30:00	AAPL	Stock	34.32	34.355	34.31	34.3225	2898804.0
2017-02-28 12:00:00	AAPL	Stock	34.3212	34.325	34.1962	34.21	5863040.0
2017-02-28 12:30:00	AAPL	Stock	34.21	34.2775	34.195	34.2488	4035228.0
2017-02-28 13:00:00	AAPL	Stock	34.25	34.285	34.2425	34.265	3266112.0
2017-02-28 13:30:00	AAPL	Stock	34.265	34.3108	34.2525	34.305	2963632.0
2017-02-28 14:00:00	AAPL	Stock	34.3062	34.31	34.24	34.2475	3415596.0
2017-02-28 14:30:00	AAPL	Stock	34.25	34.2525	34.23	34.245	2670304.0
2017-02-28 15:00:00	AAPL	Stock	34.245	34.2525	34.2175	34.2188	4366796.0
2017-02-28 15:30:00	AAPL	Stock	34.22	34.2675	34.175	34.2475	10813096.0
2017-02-28 16:00:00	AAPL	Stock	34.245	34.2525	34.225	34.25	14318136.0
2017-02-28 16:30:00	AAPL	Stock	34.2475	34.25	34.23	34.2475	146356.0
2017-02-28 17:00:00	AAPL	Stock	34.2475	34.2475	34.23	34.2325	4252.0
2017-02-28 17:30:00	AAPL	Stock	34.235	34.245	34.2325	34.245	12952.0
2017-02-28 18:00:00	AAPL	Stock	34.245	34.245	34.2275	34.23	44160.0
2017-02-28 18:30:00	AAPL	Stock	34.225	34.245	34.225	34.2375	20732.0
2017-02-28 19:00:00	AAPL	Stock	34.2375	34.255	34.23	34.25	44976.0
2017-02-28 19:30:00	AAPL	Stock	34.25	34.2625	34.25	34.2625	16520.0
2017-02-28 07:00:00	MSFT	Stock	64.1	64.1	64.1	64.1	2000.0
2017-02-28 08:00:00	MSFT	Stock	64.13	64.13	64.13	64.13	100.0
2017-02-28 08:30:00	MSFT	Stock	64.12	64.12	64.08	64.08	200.0
2017-02-28 09:00:00	MSFT	Stock	64.1	64.12	64.03	64.11	31705.0
2017-02-28 09:30:00	MSFT	Stock	64.08	64.2	63.92	64.06	2469248.0
2017-02-28 10:00:00	MSFT	Stock	64.06	64.18	63.99	63.995	1160411.0
2017-02-28 10:30:00	MSFT	Stock	63.995	64.05	63.93	64.025	928464.0
2017-02-28 11:00:00	MSFT	Stock	64.025	64.08	64.0	64.045	772582.0
2017-02-28 11:30:00	MSFT	Stock	64.05	64.05	63.92	63.985	1122874.0
2017-02-28 12:00:00	MSFT	Stock	63.985	64.02	63.82	63.9	1003508.0
2017-02-28 12:30:00	MSFT	Stock	63.9	63.905	63.8	63.805	1335030.0
2017-02-28 13:00:00	MSFT	Stock	63.81	63.84	63.76	63.815	1251299.0
2017-02-28 13:30:00	MSFT	Stock	63.82	63.86	63.79	63.86	1342766.0
2017-02-28 14:00:00	MSFT	Stock	63.87	63.88	63.775	63.82	907467.0
2017-02-28 14:30:00	MSFT	Stock	63.82	63.86	63.8	63.85	673479.0
2017-02-28 15:00:00	MSFT	Stock	63.86	63.95	63.83	63.91	1281352.0
2017-02-28 15:30:00	MSFT	Stock	63.904	64.0	63.87	63.98	2996546.0
2017-02-28 16:00:00	MSFT	Stock	63.98	64.01	63.922	63.98	3926863.0
2017-02-28 16:30:00	MSFT	Stock	64.0	64.03	63.972	64.03	33935.0

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

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