PREVIEW / stock_30min / 2018-09-05

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-09-05.parquet
  size:    1.7 MB
  rows:    83,226
  symbols: 2,782

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-09-05 04:00:00	AAPL	Stock	57.0625	57.125	56.9625	57.025	23156.0
2018-09-05 04:30:00	AAPL	Stock	57.0225	57.05	57.0	57.05	9820.0
2018-09-05 05:00:00	AAPL	Stock	57.0475	57.05	57.0	57.0	10884.0
2018-09-05 05:30:00	AAPL	Stock	56.975	56.975	56.9475	56.9625	22060.0
2018-09-05 06:00:00	AAPL	Stock	56.9625	56.9625	56.9	56.9625	19772.0
2018-09-05 06:30:00	AAPL	Stock	56.9725	57.0175	56.9725	57.0125	5448.0
2018-09-05 07:00:00	AAPL	Stock	57.02	57.0825	57.0	57.0425	85680.0
2018-09-05 07:30:00	AAPL	Stock	57.05	57.08	57.05	57.0625	31884.0
2018-09-05 08:00:00	AAPL	Stock	57.025	57.225	56.9875	57.0025	132796.0
2018-09-05 08:30:00	AAPL	Stock	56.9975	57.135	56.98	57.1125	142156.0
2018-09-05 09:00:00	AAPL	Stock	57.1125	57.25	57.0875	57.25	287748.0
2018-09-05 09:30:00	AAPL	Stock	57.2475	57.4175	56.5908	56.6052	18507800.0
2018-09-05 10:00:00	AAPL	Stock	56.61	56.72	56.28	56.436	14370968.0
2018-09-05 10:30:00	AAPL	Stock	56.435	56.75	56.275	56.6592	10920412.0
2018-09-05 11:00:00	AAPL	Stock	56.66	56.705	56.415	56.59	7072740.0
2018-09-05 11:30:00	AAPL	Stock	56.59	56.89	56.5775	56.7975	6379976.0
2018-09-05 12:00:00	AAPL	Stock	56.8	57.175	56.7975	57.135	7344064.0
2018-09-05 12:30:00	AAPL	Stock	57.135	57.2425	56.9875	57.0025	6499088.0
2018-09-05 13:00:00	AAPL	Stock	57.0025	57.2175	56.965	57.1325	4599540.0
2018-09-05 13:30:00	AAPL	Stock	57.1325	57.1775	56.9962	57.045	2952544.0
2018-09-05 14:00:00	AAPL	Stock	57.045	57.09	56.7875	56.88	5229216.0
2018-09-05 14:30:00	AAPL	Stock	56.88	56.93	56.71	56.795	3541768.0
2018-09-05 15:00:00	AAPL	Stock	56.7925	56.8575	56.655	56.755	5057352.0
2018-09-05 15:30:00	AAPL	Stock	56.7525	56.795	56.48	56.7175	11244120.0
2018-09-05 16:00:00	AAPL	Stock	56.7175	56.78	56.69	56.7175	8814872.0
2018-09-05 16:30:00	AAPL	Stock	56.7175	56.7325	56.7175	56.7325	654776.0
2018-09-05 17:00:00	AAPL	Stock	56.7325	56.745	56.7225	56.725	28116.0
2018-09-05 17:30:00	AAPL	Stock	56.725	56.75	56.725	56.75	16864.0
2018-09-05 18:00:00	AAPL	Stock	56.7325	56.735	56.7175	56.735	29804.0
2018-09-05 18:30:00	AAPL	Stock	56.7275	56.735	56.7	56.7025	27512.0
2018-09-05 19:00:00	AAPL	Stock	56.7025	56.735	56.7025	56.735	26052.0
2018-09-05 19:30:00	AAPL	Stock	56.73	56.73	56.6625	56.67	40052.0
2018-09-05 04:30:00	MSFT	Stock	111.44	111.44	111.44	111.44	400.0
2018-09-05 05:00:00	MSFT	Stock	111.37	111.37	111.37	111.37	100.0
2018-09-05 06:30:00	MSFT	Stock	111.43	111.43	111.43	111.43	100.0
2018-09-05 07:00:00	MSFT	Stock	111.51	111.7	111.51	111.68	1470.0
2018-09-05 07:30:00	MSFT	Stock	111.65	111.75	111.6	111.6	8100.0
2018-09-05 08:00:00	MSFT	Stock	111.5	111.76	111.41	111.5	3549.0
2018-09-05 08:30:00	MSFT	Stock	111.48	111.64	111.42	111.64	8103.0
2018-09-05 09:00:00	MSFT	Stock	111.478	111.71	111.01	111.01	105995.0
2018-09-05 09:30:00	MSFT	Stock	111.02	111.42	110.28	110.37	2300922.0
2018-09-05 10:00:00	MSFT	Stock	110.37	110.51	108.82	109.18	3475705.0
2018-09-05 10:30:00	MSFT	Stock	109.19	109.279	108.525	109.18	3231568.0
2018-09-05 11:00:00	MSFT	Stock	109.175	109.26	108.1	108.48	2433387.0
2018-09-05 11:30:00	MSFT	Stock	108.47	108.805	108.355	108.575	1312415.0
2018-09-05 12:00:00	MSFT	Stock	108.58	109.25	108.576	109.155	1576124.0
2018-09-05 12:30:00	MSFT	Stock	109.16	109.354	108.81	108.87	1369842.0
2018-09-05 13:00:00	MSFT	Stock	108.87	109.28	108.72	109.24	1055475.0
2018-09-05 13:30:00	MSFT	Stock	109.235	109.35	108.974	109.11	1064607.0
2018-09-05 14:00:00	MSFT	Stock	109.12	109.18	108.9	108.955	1043267.0

> showing 50 of 83,226 rows — these rows as CSV

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