PREVIEW / stock_30min / 2019-04-26

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-04-26.parquet
  size:    1.7 MB
  rows:    82,685
  symbols: 2,604

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-04-26 04:00:00	AAPL	Stock	51.2475	51.2475	51.125	51.125	7924.0
2019-04-26 04:30:00	AAPL	Stock	51.1475	51.1575	51.0125	51.0375	25568.0
2019-04-26 05:00:00	AAPL	Stock	51.015	51.0175	51.015	51.0175	2000.0
2019-04-26 05:30:00	AAPL	Stock	51.04	51.065	51.0325	51.0325	6360.0
2019-04-26 06:00:00	AAPL	Stock	51.1025	51.1025	51.0375	51.0875	2184.0
2019-04-26 06:30:00	AAPL	Stock	51.1225	51.125	51.1	51.125	4448.0
2019-04-26 07:00:00	AAPL	Stock	51.175	51.225	51.1125	51.1625	18924.0
2019-04-26 07:30:00	AAPL	Stock	51.1725	51.185	51.09	51.09	23212.0
2019-04-26 08:00:00	AAPL	Stock	51.1175	51.225	51.07	51.14	216216.0
2019-04-26 08:30:00	AAPL	Stock	51.1375	51.2675	51.1	51.2175	204236.0
2019-04-26 09:00:00	AAPL	Stock	51.2175	51.3	51.1825	51.22	159540.0
2019-04-26 09:30:00	AAPL	Stock	51.2075	51.25	50.53	50.82	12163876.0
2019-04-26 10:00:00	AAPL	Stock	50.82	51.085	50.7375	51.0475	6166884.0
2019-04-26 10:30:00	AAPL	Stock	51.0475	51.1375	50.9662	50.97	4568904.0
2019-04-26 11:00:00	AAPL	Stock	50.9725	51.1325	50.895	51.11	3399816.0
2019-04-26 11:30:00	AAPL	Stock	51.1075	51.19	51.0825	51.12	2968280.0
2019-04-26 12:00:00	AAPL	Stock	51.1175	51.1925	51.09	51.1675	2390628.0
2019-04-26 12:30:00	AAPL	Stock	51.1675	51.2025	51.0425	51.0525	1909992.0
2019-04-26 13:00:00	AAPL	Stock	51.0525	51.0575	50.9688	51.0125	2119840.0
2019-04-26 13:30:00	AAPL	Stock	51.0112	51.015	50.925	50.96	2557336.0
2019-04-26 14:00:00	AAPL	Stock	50.9625	50.9625	50.8775	50.9268	2837492.0
2019-04-26 14:30:00	AAPL	Stock	50.9275	50.9325	50.8375	50.8925	3290620.0
2019-04-26 15:00:00	AAPL	Stock	50.895	51.0975	50.8925	51.07	4119940.0
2019-04-26 15:30:00	AAPL	Stock	51.07	51.1625	50.935	51.0725	9256420.0
2019-04-26 16:00:00	AAPL	Stock	51.075	51.125	51.07	51.0925	7119880.0
2019-04-26 16:30:00	AAPL	Stock	51.0915	51.1125	51.075	51.095	39616.0
2019-04-26 17:00:00	AAPL	Stock	51.1125	51.1125	51.105	51.105	14148.0
2019-04-26 17:30:00	AAPL	Stock	51.1125	51.1125	51.0075	51.0075	41144.0
2019-04-26 18:00:00	AAPL	Stock	51.0125	51.0525	51.0125	51.03	11932.0
2019-04-26 18:30:00	AAPL	Stock	51.03	51.0625	51.03	51.0425	8376.0
2019-04-26 19:00:00	AAPL	Stock	51.05	51.1	51.05	51.1	24292.0
2019-04-26 19:30:00	AAPL	Stock	51.075	51.095	51.0625	51.0875	13588.0
2019-04-26 04:00:00	MSFT	Stock	129.1	129.1	129.1	129.1	100.0
2019-04-26 04:30:00	MSFT	Stock	129.07	129.14	129.07	129.14	327.0
2019-04-26 05:00:00	MSFT	Stock	129.12	129.12	129.12	129.12	563.0
2019-04-26 05:30:00	MSFT	Stock	129.1	129.15	129.1	129.15	1944.0
2019-04-26 06:30:00	MSFT	Stock	129.19	129.2	129.18	129.18	300.0
2019-04-26 07:00:00	MSFT	Stock	129.33	129.33	129.0	129.0	11094.0
2019-04-26 07:30:00	MSFT	Stock	129.13	129.13	129.0	129.0	7323.0
2019-04-26 08:00:00	MSFT	Stock	129.39	129.7	128.82	129.69	39720.0
2019-04-26 08:30:00	MSFT	Stock	129.6	129.98	129.42	129.58	60399.0
2019-04-26 09:00:00	MSFT	Stock	129.57	129.79	129.5	129.74	69047.0
2019-04-26 09:30:00	MSFT	Stock	129.74	130.515	129.08	129.3	4243404.0
2019-04-26 10:00:00	MSFT	Stock	129.305	129.36	129.02	129.34	1453031.0
2019-04-26 10:30:00	MSFT	Stock	129.34	129.63	129.17	129.45	1589954.0
2019-04-26 11:00:00	MSFT	Stock	129.455	129.73	129.235	129.6	1111973.0
2019-04-26 11:30:00	MSFT	Stock	129.59	130.04	129.515	129.78	1171252.0
2019-04-26 12:00:00	MSFT	Stock	129.78	130.026	129.73	129.895	875658.0
2019-04-26 12:30:00	MSFT	Stock	129.9	129.98	129.66	129.684	633705.0
2019-04-26 13:00:00	MSFT	Stock	129.68	129.7	129.52	129.68	606665.0

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

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