PREVIEW / stock_5min / 2019-06-14

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-06-14.parquet
  size:    5.4 MB
  rows:    347,670
  symbols: 2,597

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-06-14 04:00:00	AAPL	Stock	48.1625	48.1625	48.0025	48.0225	2824.0
2019-06-14 04:05:00	AAPL	Stock	48.05	48.05	48.05	48.05	400.0
2019-06-14 04:10:00	AAPL	Stock	48.065	48.065	48.065	48.065	3432.0
2019-06-14 04:15:00	AAPL	Stock	48.0225	48.0225	47.96	47.96	6232.0
2019-06-14 04:20:00	AAPL	Stock	47.9175	47.96	47.9175	47.96	1580.0
2019-06-14 04:40:00	AAPL	Stock	47.8975	47.905	47.895	47.895	4356.0
2019-06-14 04:45:00	AAPL	Stock	47.85	47.85	47.85	47.85	1200.0
2019-06-14 04:50:00	AAPL	Stock	47.85	47.85	47.85	47.85	1200.0
2019-06-14 04:55:00	AAPL	Stock	47.875	47.875	47.7925	47.7925	3748.0
2019-06-14 05:00:00	AAPL	Stock	47.7925	47.7925	47.6875	47.6875	5580.0
2019-06-14 05:05:00	AAPL	Stock	47.675	47.71	47.6625	47.6625	13036.0
2019-06-14 05:10:00	AAPL	Stock	47.6675	47.6675	47.6675	47.6675	400.0
2019-06-14 05:15:00	AAPL	Stock	47.675	47.675	47.675	47.675	7940.0
2019-06-14 05:20:00	AAPL	Stock	47.7225	47.735	47.7225	47.735	3200.0
2019-06-14 05:25:00	AAPL	Stock	47.73	47.7375	47.675	47.675	2400.0
2019-06-14 05:30:00	AAPL	Stock	47.7325	47.7325	47.7325	47.7325	4000.0
2019-06-14 05:40:00	AAPL	Stock	47.6875	47.725	47.6875	47.725	1908.0
2019-06-14 05:45:00	AAPL	Stock	47.67	47.71	47.67	47.71	1616.0
2019-06-14 05:50:00	AAPL	Stock	47.735	47.775	47.735	47.775	5452.0
2019-06-14 06:05:00	AAPL	Stock	47.7625	47.7625	47.75	47.75	2000.0
2019-06-14 06:10:00	AAPL	Stock	47.75	47.75	47.655	47.665	6864.0
2019-06-14 06:15:00	AAPL	Stock	47.6625	47.6625	47.6175	47.625	4400.0
2019-06-14 06:20:00	AAPL	Stock	47.625	47.625	47.625	47.625	800.0
2019-06-14 06:25:00	AAPL	Stock	47.6125	47.6125	47.585	47.585	4800.0
2019-06-14 06:30:00	AAPL	Stock	47.5825	47.5825	47.5625	47.5625	4644.0
2019-06-14 06:35:00	AAPL	Stock	47.5625	47.5625	47.53	47.53	2000.0
2019-06-14 06:40:00	AAPL	Stock	47.5625	47.625	47.5525	47.625	4740.0
2019-06-14 06:50:00	AAPL	Stock	47.72	47.72	47.635	47.635	1924.0
2019-06-14 06:55:00	AAPL	Stock	47.6675	47.6675	47.6675	47.6675	3400.0
2019-06-14 07:00:00	AAPL	Stock	47.72	47.8425	47.72	47.8225	44416.0
2019-06-14 07:05:00	AAPL	Stock	47.82	47.875	47.8125	47.875	28308.0
2019-06-14 07:10:00	AAPL	Stock	47.91	47.9925	47.89	47.94	146796.0
2019-06-14 07:15:00	AAPL	Stock	47.9975	48.06	47.965	47.9675	66388.0
2019-06-14 07:20:00	AAPL	Stock	47.9725	47.985	47.9075	47.9075	10124.0
2019-06-14 07:25:00	AAPL	Stock	47.92	47.95	47.92	47.95	2200.0
2019-06-14 07:30:00	AAPL	Stock	47.9375	47.9375	47.9	47.9075	12580.0
2019-06-14 07:35:00	AAPL	Stock	47.9075	47.9625	47.8825	47.9625	9704.0
2019-06-14 07:40:00	AAPL	Stock	47.95	47.9725	47.9125	47.935	19308.0
2019-06-14 07:45:00	AAPL	Stock	47.9325	48.0225	47.9325	48.0225	16876.0
2019-06-14 07:50:00	AAPL	Stock	48.0	48.075	48.0	48.0625	14924.0
2019-06-14 07:55:00	AAPL	Stock	48.075	48.1	48.0625	48.0775	8400.0
2019-06-14 08:00:00	AAPL	Stock	47.8125	48.07	47.685	48.03	72708.0
2019-06-14 08:05:00	AAPL	Stock	48.07	48.0875	48.0	48.0375	72404.0
2019-06-14 08:10:00	AAPL	Stock	48.0025	48.0025	47.9325	47.9325	14248.0
2019-06-14 08:15:00	AAPL	Stock	47.945	47.9725	47.9225	47.9425	14048.0
2019-06-14 08:20:00	AAPL	Stock	47.9525	47.99	47.9525	47.99	18344.0
2019-06-14 08:25:00	AAPL	Stock	47.9925	48.055	47.9925	48.04	18084.0
2019-06-14 08:30:00	AAPL	Stock	48.04	48.075	47.9575	47.9575	64108.0
2019-06-14 08:35:00	AAPL	Stock	47.9625	47.99	47.925	47.9325	27520.0
2019-06-14 08:40:00	AAPL	Stock	47.9525	48.015	47.94	48.005	16072.0

> showing 50 of 347,670 rows — these rows as CSV

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