PREVIEW / stock_30min / 2018-12-28

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-12-28.parquet
  size:    1.7 MB
  rows:    86,903
  symbols: 2,737

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-12-28 04:00:00	AAPL	Stock	38.75	39.2425	38.75	39.2425	6460.0
2018-12-28 04:30:00	AAPL	Stock	39.2	39.25	39.2	39.25	10688.0
2018-12-28 05:00:00	AAPL	Stock	39.3125	39.3475	39.3125	39.3475	2188.0
2018-12-28 05:30:00	AAPL	Stock	39.345	39.3625	39.34	39.3575	23292.0
2018-12-28 06:00:00	AAPL	Stock	39.3125	39.435	39.2875	39.435	26336.0
2018-12-28 06:30:00	AAPL	Stock	39.4375	39.45	39.3425	39.3425	8248.0
2018-12-28 07:00:00	AAPL	Stock	39.305	39.375	39.25	39.3375	47444.0
2018-12-28 07:30:00	AAPL	Stock	39.3	39.3375	39.125	39.285	88004.0
2018-12-28 08:00:00	AAPL	Stock	39.1875	39.3705	39.1875	39.255	314768.0
2018-12-28 08:30:00	AAPL	Stock	39.2725	39.33	39.25	39.31	201244.0
2018-12-28 09:00:00	AAPL	Stock	39.3075	39.375	39.2525	39.37	410892.0
2018-12-28 09:30:00	AAPL	Stock	39.37	39.4125	38.7975	39.1825	21122056.0
2018-12-28 10:00:00	AAPL	Stock	39.1862	39.21	38.79	38.817	13678156.0
2018-12-28 10:30:00	AAPL	Stock	38.8158	38.9975	38.6375	38.8262	10872592.0
2018-12-28 11:00:00	AAPL	Stock	38.83	39.055	38.75	39.0208	9302788.0
2018-12-28 11:30:00	AAPL	Stock	39.0175	39.298	38.9675	39.23	9196112.0
2018-12-28 12:00:00	AAPL	Stock	39.2312	39.3075	39.05	39.1692	7945392.0
2018-12-28 12:30:00	AAPL	Stock	39.1675	39.23	39.0075	39.0525	6024816.0
2018-12-28 13:00:00	AAPL	Stock	39.0543	39.105	38.8525	38.927	5950204.0
2018-12-28 13:30:00	AAPL	Stock	38.92	39.06	38.8175	39.0075	5254832.0
2018-12-28 14:00:00	AAPL	Stock	39.0125	39.395	39.0125	39.3225	8665568.0
2018-12-28 14:30:00	AAPL	Stock	39.3235	39.63	39.26	39.6025	10213588.0
2018-12-28 15:00:00	AAPL	Stock	39.6	39.6275	39.0575	39.1358	10966740.0
2018-12-28 15:30:00	AAPL	Stock	39.1347	39.1775	38.9175	39.0575	15272244.0
2018-12-28 16:00:00	AAPL	Stock	39.0575	39.1125	39.0575	39.1	9341104.0
2018-12-28 16:30:00	AAPL	Stock	39.0875	39.125	39.0875	39.125	43816.0
2018-12-28 17:00:00	AAPL	Stock	39.0925	39.125	39.0925	39.125	9660.0
2018-12-28 17:30:00	AAPL	Stock	39.125	39.1375	39.12	39.1225	33984.0
2018-12-28 18:00:00	AAPL	Stock	39.125	39.1375	39.0575	39.135	1943732.0
2018-12-28 18:30:00	AAPL	Stock	39.1375	39.15	39.005	39.0825	187068.0
2018-12-28 19:00:00	AAPL	Stock	39.0825	39.0875	39.05	39.0875	5628.0
2018-12-28 19:30:00	AAPL	Stock	39.0925	39.095	39.06	39.095	15856.0
2018-12-28 04:00:00	MSFT	Stock	101.15	101.45	101.15	101.45	440.0
2018-12-28 04:30:00	MSFT	Stock	101.63	101.72	101.6	101.6	400.0
2018-12-28 05:00:00	MSFT	Stock	101.79	101.99	101.74	101.99	5659.0
2018-12-28 05:30:00	MSFT	Stock	102.07	102.07	101.99	101.99	200.0
2018-12-28 06:00:00	MSFT	Stock	101.98	102.29	101.89	102.29	10408.0
2018-12-28 06:30:00	MSFT	Stock	102.13	102.29	102.1	102.1	1865.0
2018-12-28 07:00:00	MSFT	Stock	102.0	102.17	101.8	102.0	14495.0
2018-12-28 07:30:00	MSFT	Stock	101.85	102.08	101.46	101.69	9287.0
2018-12-28 08:00:00	MSFT	Stock	102.252	102.252	101.52	101.7	26621.0
2018-12-28 08:30:00	MSFT	Stock	101.65	101.84	101.57	101.84	18741.0
2018-12-28 09:00:00	MSFT	Stock	101.85	102.07	101.64	102.06	103110.0
2018-12-28 09:30:00	MSFT	Stock	102.06	102.41	100.5	101.15	4592923.0
2018-12-28 10:00:00	MSFT	Stock	101.141	101.22	99.99	100.1	3086894.0
2018-12-28 10:30:00	MSFT	Stock	100.08	100.7	99.52	100.11	2525594.0
2018-12-28 11:00:00	MSFT	Stock	100.11	100.7	99.768	100.61	2533487.0
2018-12-28 11:30:00	MSFT	Stock	100.61	101.1	100.43	100.9	1770047.0
2018-12-28 12:00:00	MSFT	Stock	100.91	101.285	100.524	100.865	1513179.0
2018-12-28 12:30:00	MSFT	Stock	100.87	101.21	100.65	100.75	1155464.0

> showing 50 of 86,903 rows — these rows as CSV

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