PREVIEW / stock_30min / 2019-12-17

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-12-17.parquet
  size:    1.8 MB
  rows:    87,626
  symbols: 2,524

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
2019-12-17 04:00:00	AAPL	Stock	70.075	70.075	69.9	69.9025	4540.0
2019-12-17 04:30:00	AAPL	Stock	69.9175	69.9425	69.8725	69.9125	3908.0
2019-12-17 05:00:00	AAPL	Stock	69.9375	70.0	69.92	70.0	11544.0
2019-12-17 05:30:00	AAPL	Stock	70.03	70.03	69.9625	69.9675	19900.0
2019-12-17 06:00:00	AAPL	Stock	69.965	70.1475	69.895	70.025	33392.0
2019-12-17 06:30:00	AAPL	Stock	70.025	70.025	69.6	69.645	63332.0
2019-12-17 07:00:00	AAPL	Stock	69.67	69.8225	69.625	69.775	186308.0
2019-12-17 07:30:00	AAPL	Stock	69.775	69.8225	69.75	69.775	109160.0
2019-12-17 08:00:00	AAPL	Stock	69.6875	69.865	69.65	69.8125	241612.0
2019-12-17 08:30:00	AAPL	Stock	69.8175	69.97	69.78	69.9525	230112.0
2019-12-17 09:00:00	AAPL	Stock	69.9525	69.975	69.8325	69.95	325272.0
2019-12-17 09:30:00	AAPL	Stock	69.8925	70.231	69.815	70.045	17806656.0
2019-12-17 10:00:00	AAPL	Stock	70.045	70.3875	69.9875	70.295	9886736.0
2019-12-17 10:30:00	AAPL	Stock	70.2968	70.4425	70.2	70.2125	6298860.0
2019-12-17 11:00:00	AAPL	Stock	70.211	70.365	70.2108	70.26	5834044.0
2019-12-17 11:30:00	AAPL	Stock	70.2575	70.27	69.7	70.14	8948248.0
2019-12-17 12:00:00	AAPL	Stock	70.143	70.2475	70.14	70.2425	3636856.0
2019-12-17 12:30:00	AAPL	Stock	70.2405	70.3125	70.205	70.2725	2753656.0
2019-12-17 13:00:00	AAPL	Stock	70.275	70.2775	70.165	70.1708	2166092.0
2019-12-17 13:30:00	AAPL	Stock	70.17	70.25	70.1625	70.2125	2290592.0
2019-12-17 14:00:00	AAPL	Stock	70.215	70.2425	70.0375	70.0575	3043436.0
2019-12-17 14:30:00	AAPL	Stock	70.0597	70.1975	70.0562	70.1798	2364040.0
2019-12-17 15:00:00	AAPL	Stock	70.1775	70.197	70.105	70.105	2957440.0
2019-12-17 15:30:00	AAPL	Stock	70.1062	70.14	70.0425	70.105	7623736.0
2019-12-17 16:00:00	AAPL	Stock	70.1025	70.1325	70.0775	70.0775	13880520.0
2019-12-17 16:30:00	AAPL	Stock	70.0775	70.1025	70.05	70.065	28368.0
2019-12-17 17:00:00	AAPL	Stock	70.0625	70.075	70.0075	70.0245	31956.0
2019-12-17 17:30:00	AAPL	Stock	70.01	70.0625	70.0075	70.0625	29980.0
2019-12-17 18:00:00	AAPL	Stock	70.06	70.0675	70.045	70.0525	17208.0
2019-12-17 18:30:00	AAPL	Stock	70.0675	70.0675	70.0475	70.05	54508.0
2019-12-17 19:00:00	AAPL	Stock	70.045	70.0875	70.045	70.075	31920.0
2019-12-17 19:30:00	AAPL	Stock	70.085	70.095	70.06	70.09	39884.0
2019-12-17 04:00:00	MSFT	Stock	155.6	155.6	155.45	155.45	688.0
2019-12-17 04:30:00	MSFT	Stock	155.5	155.5	155.5	155.5	421.0
2019-12-17 05:00:00	MSFT	Stock	155.55	155.63	155.55	155.63	200.0
2019-12-17 05:30:00	MSFT	Stock	155.55	155.57	155.55	155.57	700.0
2019-12-17 06:00:00	MSFT	Stock	155.46	155.59	155.42	155.59	5751.0
2019-12-17 06:30:00	MSFT	Stock	155.49	155.59	155.49	155.59	4809.0
2019-12-17 07:00:00	MSFT	Stock	155.63	155.63	155.5	155.5	6964.0
2019-12-17 07:30:00	MSFT	Stock	155.5	155.58	155.32	155.49	6616.0
2019-12-17 08:00:00	MSFT	Stock	155.499	155.65	155.35	155.63	16387.0
2019-12-17 08:30:00	MSFT	Stock	155.63	155.81	155.6	155.7	8404.0
2019-12-17 09:00:00	MSFT	Stock	155.7	155.85	155.35	155.67	18704.0
2019-12-17 09:30:00	MSFT	Stock	155.45	155.72	154.67	154.79	3012939.0
2019-12-17 10:00:00	MSFT	Stock	154.8	155.43	154.45	155.39	1347839.0
2019-12-17 10:30:00	MSFT	Stock	155.39	155.41	155.015	155.03	898792.0
2019-12-17 11:00:00	MSFT	Stock	155.03	155.225	155.03	155.225	606864.0
2019-12-17 11:30:00	MSFT	Stock	155.23	155.33	155.075	155.17	799849.0
2019-12-17 12:00:00	MSFT	Stock	155.18	155.24	155.04	155.213	555165.0
2019-12-17 12:30:00	MSFT	Stock	155.218	155.23	154.82	154.855	760363.0

> showing 50 of 87,626 rows — these rows as CSV

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