PREVIEW / stock_30min / 2018-02-14

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-02-14.parquet
  size:    1.7 MB
  rows:    84,396
  symbols: 2,892

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-14 04:00:00	AAPL	Stock	41.25	41.25	41.25	41.25	1200.0
2018-02-14 04:30:00	AAPL	Stock	41.25	41.25	41.225	41.235	6236.0
2018-02-14 05:00:00	AAPL	Stock	41.2475	41.3075	41.2275	41.3075	5208.0
2018-02-14 05:30:00	AAPL	Stock	41.25	41.25	41.225	41.225	1200.0
2018-02-14 06:00:00	AAPL	Stock	41.2475	41.2475	41.2375	41.2475	15396.0
2018-02-14 06:30:00	AAPL	Stock	41.2	41.27	41.2	41.2425	32316.0
2018-02-14 07:00:00	AAPL	Stock	41.2175	41.325	41.1875	41.2975	204088.0
2018-02-14 07:30:00	AAPL	Stock	41.295	41.3125	41.2	41.215	107104.0
2018-02-14 08:00:00	AAPL	Stock	41.225	41.315	41.175	41.2575	202928.0
2018-02-14 08:30:00	AAPL	Stock	41.235	41.2575	40.4475	40.75	1410460.0
2018-02-14 09:00:00	AAPL	Stock	40.7525	40.9025	40.6875	40.765	572088.0
2018-02-14 09:30:00	AAPL	Stock	40.7675	41.0775	40.72	40.9112	22072808.0
2018-02-14 10:00:00	AAPL	Stock	40.9125	41.246	40.84	41.215	13961004.0
2018-02-14 10:30:00	AAPL	Stock	41.2175	41.3875	41.1075	41.3398	12014880.0
2018-02-14 11:00:00	AAPL	Stock	41.3352	41.4325	41.235	41.3825	9749148.0
2018-02-14 11:30:00	AAPL	Stock	41.38	41.4525	41.2925	41.298	7484388.0
2018-02-14 12:00:00	AAPL	Stock	41.3002	41.3775	41.2375	41.3325	5763272.0
2018-02-14 12:30:00	AAPL	Stock	41.33	41.4938	41.315	41.4738	5932068.0
2018-02-14 13:00:00	AAPL	Stock	41.475	41.54	41.4112	41.425	7003148.0
2018-02-14 13:30:00	AAPL	Stock	41.425	41.55	41.4238	41.52	5651068.0
2018-02-14 14:00:00	AAPL	Stock	41.5195	41.65	41.5175	41.615	7156280.0
2018-02-14 14:30:00	AAPL	Stock	41.6162	41.825	41.595	41.805	8971340.0
2018-02-14 15:00:00	AAPL	Stock	41.8025	41.88	41.755	41.8	9520392.0
2018-02-14 15:30:00	AAPL	Stock	41.8	41.885	41.78	41.84	13230260.0
2018-02-14 16:00:00	AAPL	Stock	41.8425	41.9425	41.8	41.9375	8289472.0
2018-02-14 16:30:00	AAPL	Stock	41.9375	41.97	41.93	41.955	174640.0
2018-02-14 17:00:00	AAPL	Stock	41.9675	42.115	41.8425	42.07	756440.0
2018-02-14 17:30:00	AAPL	Stock	42.0725	42.1125	42.0625	42.1075	203452.0
2018-02-14 18:00:00	AAPL	Stock	42.105	42.1125	42.0775	42.08	53636.0
2018-02-14 18:30:00	AAPL	Stock	42.08	42.22	42.08	42.1875	130048.0
2018-02-14 19:00:00	AAPL	Stock	42.2	42.2125	42.135	42.185	102116.0
2018-02-14 19:30:00	AAPL	Stock	42.1875	42.2325	42.1875	42.2325	120292.0
2018-02-14 04:00:00	MSFT	Stock	90.2	90.22	90.2	90.21	5000.0
2018-02-14 04:30:00	MSFT	Stock	90.45	90.45	90.45	90.45	300.0
2018-02-14 05:00:00	MSFT	Stock	90.18	90.18	90.18	90.18	100.0
2018-02-14 05:30:00	MSFT	Stock	90.01	90.01	90.0	90.0	600.0
2018-02-14 06:00:00	MSFT	Stock	90.0	90.12	90.0	90.02	3459.0
2018-02-14 06:30:00	MSFT	Stock	90.05	90.1	90.05	90.05	400.0
2018-02-14 07:00:00	MSFT	Stock	90.0	90.06	89.82	89.99	10590.0
2018-02-14 07:30:00	MSFT	Stock	89.99	90.08	89.95	89.95	1200.0
2018-02-14 08:00:00	MSFT	Stock	89.9	90.0	89.87	90.0	18017.0
2018-02-14 08:30:00	MSFT	Stock	89.99	89.99	87.9	88.5	143238.0
2018-02-14 09:00:00	MSFT	Stock	88.48	88.65	88.25	88.58	148093.0
2018-02-14 09:30:00	MSFT	Stock	88.51	89.25	88.41	88.6	4661660.0
2018-02-14 10:00:00	MSFT	Stock	88.61	89.8	88.54	89.74	3061322.0
2018-02-14 10:30:00	MSFT	Stock	89.74	90.0	89.36	89.68	2109285.0
2018-02-14 11:00:00	MSFT	Stock	89.67	89.92	89.56	89.865	1432607.0
2018-02-14 11:30:00	MSFT	Stock	89.87	90.01	89.57	89.65	1667924.0
2018-02-14 12:00:00	MSFT	Stock	89.67	89.84	89.3	89.65	1216273.0
2018-02-14 12:30:00	MSFT	Stock	89.63	90.13	89.574	90.05	1319645.0

> showing 50 of 84,396 rows — these rows as CSV

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