PREVIEW / stock_30min / 2019-08-27

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-08-27.parquet
  size:    1.7 MB
  rows:    84,649
  symbols: 2,575

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-08-27 04:00:00	AAPL	Stock	51.47	51.5	51.4275	51.5	2800.0
2019-08-27 05:00:00	AAPL	Stock	51.495	51.625	51.495	51.5125	14892.0
2019-08-27 05:30:00	AAPL	Stock	51.5825	51.6725	51.5825	51.6725	4544.0
2019-08-27 06:00:00	AAPL	Stock	51.6225	51.7225	51.6225	51.7225	5716.0
2019-08-27 06:30:00	AAPL	Stock	51.71	51.71	51.71	51.71	824.0
2019-08-27 07:00:00	AAPL	Stock	51.715	51.8375	51.6375	51.775	41820.0
2019-08-27 07:30:00	AAPL	Stock	51.7825	51.795	51.7425	51.775	48996.0
2019-08-27 08:00:00	AAPL	Stock	51.7325	51.9725	51.6525	51.9375	215172.0
2019-08-27 08:30:00	AAPL	Stock	51.955	51.9875	51.875	51.9625	201604.0
2019-08-27 09:00:00	AAPL	Stock	51.9625	51.9875	51.91	51.9725	233376.0
2019-08-27 09:30:00	AAPL	Stock	51.9775	52.1375	51.6675	51.7325	11341140.0
2019-08-27 10:00:00	AAPL	Stock	51.7312	51.795	51.49	51.4975	5989656.0
2019-08-27 10:30:00	AAPL	Stock	51.4925	51.5675	51.37	51.4125	4461836.0
2019-08-27 11:00:00	AAPL	Stock	51.415	51.4725	51.0585	51.1462	5715768.0
2019-08-27 11:30:00	AAPL	Stock	51.1425	51.3225	51.1325	51.1975	3631628.0
2019-08-27 12:00:00	AAPL	Stock	51.195	51.2725	51.1025	51.1402	3263136.0
2019-08-27 12:30:00	AAPL	Stock	51.1375	51.2125	50.92	50.9362	4196576.0
2019-08-27 13:00:00	AAPL	Stock	50.93	51.0725	50.8825	51.0425	3153948.0
2019-08-27 13:30:00	AAPL	Stock	51.0425	51.32	51.005	51.283	3719572.0
2019-08-27 14:00:00	AAPL	Stock	51.28	51.3575	51.1375	51.17	2235356.0
2019-08-27 14:30:00	AAPL	Stock	51.17	51.3925	51.0988	51.3668	3676392.0
2019-08-27 15:00:00	AAPL	Stock	51.37	51.5	51.1975	51.2025	3869768.0
2019-08-27 15:30:00	AAPL	Stock	51.205	51.3325	51.0125	51.035	10657844.0
2019-08-27 16:00:00	AAPL	Stock	51.0325	51.0925	50.995	51.0675	19485740.0
2019-08-27 16:30:00	AAPL	Stock	51.065	51.0875	51.01	51.085	89496.0
2019-08-27 17:00:00	AAPL	Stock	51.0875	51.1425	51.05	51.05	21300.0
2019-08-27 17:30:00	AAPL	Stock	51.075	51.075	51.075	51.075	19668.0
2019-08-27 18:00:00	AAPL	Stock	51.085	51.235	51.085	51.165	29172.0
2019-08-27 18:30:00	AAPL	Stock	51.2175	51.2625	51.1875	51.195	31284.0
2019-08-27 19:00:00	AAPL	Stock	51.18	51.1825	51.175	51.175	7072.0
2019-08-27 19:30:00	AAPL	Stock	51.195	51.24	51.1625	51.24	26020.0
2019-08-27 04:00:00	MSFT	Stock	135.47	135.47	135.0	135.36	1000.0
2019-08-27 04:30:00	MSFT	Stock	135.11	135.11	135.11	135.11	100.0
2019-08-27 06:30:00	MSFT	Stock	135.69	135.7	135.65	135.65	518.0
2019-08-27 07:00:00	MSFT	Stock	135.84	135.93	135.63	135.7	23906.0
2019-08-27 07:30:00	MSFT	Stock	135.77	135.77	135.47	135.65	11066.0
2019-08-27 08:00:00	MSFT	Stock	135.7	136.25	135.54	136.0	35309.0
2019-08-27 08:30:00	MSFT	Stock	135.91	136.25	135.85	136.1	19097.0
2019-08-27 09:00:00	MSFT	Stock	136.1	136.5	136.1	136.4	35867.0
2019-08-27 09:30:00	MSFT	Stock	136.38	136.715	136.08	136.52	2255716.0
2019-08-27 10:00:00	MSFT	Stock	136.53	136.72	136.09	136.12	1081070.0
2019-08-27 10:30:00	MSFT	Stock	136.13	136.42	136.03	136.07	750506.0
2019-08-27 11:00:00	MSFT	Stock	136.09	136.255	135.23	135.49	909037.0
2019-08-27 11:30:00	MSFT	Stock	135.49	135.95	135.46	135.66	854437.0
2019-08-27 12:00:00	MSFT	Stock	135.67	135.8	135.36	135.58	685777.0
2019-08-27 12:30:00	MSFT	Stock	135.57	135.64	134.78	134.83	910557.0
2019-08-27 13:00:00	MSFT	Stock	134.8	135.18	134.66	135.12	682190.0
2019-08-27 13:30:00	MSFT	Stock	135.12	135.83	135.03	135.825	862221.0
2019-08-27 14:00:00	MSFT	Stock	135.825	135.96	135.36	135.56	609266.0
2019-08-27 14:30:00	MSFT	Stock	135.56	136.12	135.41	136.026	643496.0

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

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