PREVIEW / stock_30min / 2018-03-13

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-03-13.parquet
  size:    1.7 MB
  rows:    83,678
  symbols: 2,864

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-03-13 04:00:00	AAPL	Stock	45.375	45.3875	45.375	45.375	3136.0
2018-03-13 04:30:00	AAPL	Stock	45.375	45.4	45.375	45.4	2000.0
2018-03-13 05:00:00	AAPL	Stock	45.4	45.4025	45.375	45.375	18056.0
2018-03-13 05:30:00	AAPL	Stock	45.4025	45.4025	45.4025	45.4025	884.0
2018-03-13 06:00:00	AAPL	Stock	45.4125	45.45	45.4125	45.45	14864.0
2018-03-13 06:30:00	AAPL	Stock	45.45	45.45	45.4375	45.45	15204.0
2018-03-13 07:00:00	AAPL	Stock	45.4625	45.525	45.4625	45.5	135540.0
2018-03-13 07:30:00	AAPL	Stock	45.505	45.505	45.465	45.4925	69360.0
2018-03-13 08:00:00	AAPL	Stock	45.475	45.53	45.4375	45.49	270936.0
2018-03-13 08:30:00	AAPL	Stock	45.4975	45.6375	45.475	45.575	633036.0
2018-03-13 09:00:00	AAPL	Stock	45.5775	45.6475	45.535	45.6375	283756.0
2018-03-13 09:30:00	AAPL	Stock	45.6425	45.825	45.5525	45.7925	14206208.0
2018-03-13 10:00:00	AAPL	Stock	45.7925	45.875	45.7152	45.7825	8850520.0
2018-03-13 10:30:00	AAPL	Stock	45.7825	45.785	45.6275	45.675	7388324.0
2018-03-13 11:00:00	AAPL	Stock	45.6825	45.6925	45.425	45.4738	10726860.0
2018-03-13 11:30:00	AAPL	Stock	45.4725	45.5825	45.335	45.48	8469204.0
2018-03-13 12:00:00	AAPL	Stock	45.48	45.5075	45.2025	45.465	6806108.0
2018-03-13 12:30:00	AAPL	Stock	45.4625	45.5535	45.38	45.4975	3877980.0
2018-03-13 13:00:00	AAPL	Stock	45.4975	45.635	45.4975	45.55	4349460.0
2018-03-13 13:30:00	AAPL	Stock	45.5495	45.59	45.335	45.355	4809932.0
2018-03-13 14:00:00	AAPL	Stock	45.3575	45.43	45.245	45.3125	4963852.0
2018-03-13 14:30:00	AAPL	Stock	45.3112	45.395	45.115	45.2275	7507452.0
2018-03-13 15:00:00	AAPL	Stock	45.2275	45.29	44.915	44.9575	10036268.0
2018-03-13 15:30:00	AAPL	Stock	44.9598	45.045	44.81	44.9875	14411792.0
2018-03-13 16:00:00	AAPL	Stock	44.995	45.035	44.975	45.0	6463244.0
2018-03-13 16:30:00	AAPL	Stock	45.0	45.03	44.9125	44.955	124964.0
2018-03-13 17:00:00	AAPL	Stock	44.9225	44.9625	44.7525	44.79	158108.0
2018-03-13 17:30:00	AAPL	Stock	44.8	44.8375	44.7725	44.8025	76092.0
2018-03-13 18:00:00	AAPL	Stock	44.8025	44.935	44.775	44.8875	68204.0
2018-03-13 18:30:00	AAPL	Stock	44.8875	45.0	44.8875	44.9625	108376.0
2018-03-13 19:00:00	AAPL	Stock	44.93	44.95	44.925	44.9275	28616.0
2018-03-13 19:30:00	AAPL	Stock	44.9275	44.975	44.9275	44.955	29712.0
2018-03-13 04:00:00	MSFT	Stock	96.79	96.79	96.79	96.79	540.0
2018-03-13 05:00:00	MSFT	Stock	96.65	96.67	96.65	96.67	5500.0
2018-03-13 07:00:00	MSFT	Stock	96.65	96.78	96.65	96.78	6024.0
2018-03-13 07:30:00	MSFT	Stock	96.71	96.71	96.61	96.69	4470.0
2018-03-13 08:00:00	MSFT	Stock	96.69	97.0	96.55	96.66	7808.0
2018-03-13 08:30:00	MSFT	Stock	96.77	97.09	96.74	97.0	34933.0
2018-03-13 09:00:00	MSFT	Stock	96.98	97.08	96.88	97.0	43359.0
2018-03-13 09:30:00	MSFT	Stock	97.04	97.24	96.64	96.79	2462174.0
2018-03-13 10:00:00	MSFT	Stock	96.79	96.88	96.5	96.51	2592968.0
2018-03-13 10:30:00	MSFT	Stock	96.52	96.535	96.02	96.14	2088267.0
2018-03-13 11:00:00	MSFT	Stock	96.14	96.16	95.23	95.38	2531969.0
2018-03-13 11:30:00	MSFT	Stock	95.38	95.55	95.15	95.226	2119210.0
2018-03-13 12:00:00	MSFT	Stock	95.22	95.29	94.57	95.11	1797718.0
2018-03-13 12:30:00	MSFT	Stock	95.12	95.27	94.96	95.075	1200445.0
2018-03-13 13:00:00	MSFT	Stock	95.075	95.17	94.92	94.99	1161184.0
2018-03-13 13:30:00	MSFT	Stock	94.985	95.19	94.75	94.775	1571390.0
2018-03-13 14:00:00	MSFT	Stock	94.77	94.95	94.436	94.49	1363375.0
2018-03-13 14:30:00	MSFT	Stock	94.51	94.83	94.406	94.62	1389224.0

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

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