PREVIEW / stock_5min / 2018-09-25

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-09-25.parquet
  size:    5.6 MB
  rows:    358,059
  symbols: 2,781

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-25 04:00:00	AAPL	Stock	55.375	55.3975	55.375	55.3975	9088.0
2018-09-25 04:05:00	AAPL	Stock	55.375	55.375	55.375	55.375	800.0
2018-09-25 04:20:00	AAPL	Stock	55.3	55.31	55.3	55.31	1396.0
2018-09-25 04:45:00	AAPL	Stock	55.3075	55.3075	55.3075	55.3075	420.0
2018-09-25 05:10:00	AAPL	Stock	55.245	55.245	55.245	55.245	400.0
2018-09-25 05:20:00	AAPL	Stock	55.3	55.3	55.3	55.3	7768.0
2018-09-25 05:25:00	AAPL	Stock	55.3	55.3	55.2875	55.2875	1800.0
2018-09-25 05:30:00	AAPL	Stock	55.2875	55.3	55.2875	55.3	7800.0
2018-09-25 06:00:00	AAPL	Stock	55.3	55.3	55.3	55.3	800.0
2018-09-25 06:05:00	AAPL	Stock	55.3	55.3	55.3	55.3	2200.0
2018-09-25 06:15:00	AAPL	Stock	55.3	55.3075	55.3	55.3075	2000.0
2018-09-25 06:20:00	AAPL	Stock	55.275	55.275	55.275	55.275	2400.0
2018-09-25 06:30:00	AAPL	Stock	55.3225	55.335	55.3225	55.335	14832.0
2018-09-25 06:35:00	AAPL	Stock	55.3225	55.3225	55.2975	55.3025	11036.0
2018-09-25 06:40:00	AAPL	Stock	55.325	55.325	55.3225	55.3225	2596.0
2018-09-25 06:45:00	AAPL	Stock	55.325	55.325	55.3	55.3	2372.0
2018-09-25 06:50:00	AAPL	Stock	55.3175	55.3325	55.3	55.3325	10200.0
2018-09-25 06:55:00	AAPL	Stock	55.305	55.305	55.3	55.3	2656.0
2018-09-25 07:00:00	AAPL	Stock	55.32	55.35	55.315	55.3175	46956.0
2018-09-25 07:05:00	AAPL	Stock	55.325	55.335	55.285	55.335	25624.0
2018-09-25 07:10:00	AAPL	Stock	55.335	55.3625	55.335	55.3625	42840.0
2018-09-25 07:15:00	AAPL	Stock	55.3675	55.3675	55.3225	55.33	37072.0
2018-09-25 07:20:00	AAPL	Stock	55.335	55.35	55.335	55.35	8276.0
2018-09-25 07:25:00	AAPL	Stock	55.325	55.3475	55.325	55.3475	2088.0
2018-09-25 07:30:00	AAPL	Stock	55.3475	55.35	55.3375	55.35	9888.0
2018-09-25 07:35:00	AAPL	Stock	55.35	55.35	55.31	55.31	31564.0
2018-09-25 07:40:00	AAPL	Stock	55.3125	55.3125	55.285	55.285	14000.0
2018-09-25 07:45:00	AAPL	Stock	55.2675	55.2775	55.2175	55.265	26496.0
2018-09-25 07:50:00	AAPL	Stock	55.2675	55.2675	55.235	55.235	12248.0
2018-09-25 07:55:00	AAPL	Stock	55.2225	55.25	55.2125	55.25	55288.0
2018-09-25 08:00:00	AAPL	Stock	55.3125	55.35	55.235	55.275	98332.0
2018-09-25 08:05:00	AAPL	Stock	55.275	55.275	55.26	55.275	6516.0
2018-09-25 08:10:00	AAPL	Stock	55.275	55.275	55.2625	55.2725	8616.0
2018-09-25 08:15:00	AAPL	Stock	55.265	55.265	55.23	55.2475	17264.0
2018-09-25 08:20:00	AAPL	Stock	55.2325	55.2325	55.07	55.13	68696.0
2018-09-25 08:25:00	AAPL	Stock	55.13	55.1725	55.1125	55.1375	38268.0
2018-09-25 08:30:00	AAPL	Stock	55.14	55.16	54.8375	54.9025	67816.0
2018-09-25 08:35:00	AAPL	Stock	54.905	55.0	54.895	54.9875	49224.0
2018-09-25 08:40:00	AAPL	Stock	54.99	54.99	54.9	54.965	81164.0
2018-09-25 08:45:00	AAPL	Stock	54.965	54.9875	54.9375	54.985	29068.0
2018-09-25 08:50:00	AAPL	Stock	54.9725	55.0375	54.965	55.0125	55276.0
2018-09-25 08:55:00	AAPL	Stock	55.0025	55.0825	55.0	55.0825	31720.0
2018-09-25 09:00:00	AAPL	Stock	55.0825	55.0975	55.0525	55.085	19772.0
2018-09-25 09:05:00	AAPL	Stock	55.0575	55.075	54.875	54.925	173344.0
2018-09-25 09:10:00	AAPL	Stock	54.9175	54.925	54.88	54.9	47952.0
2018-09-25 09:15:00	AAPL	Stock	54.8925	54.895	54.8125	54.835	85768.0
2018-09-25 09:20:00	AAPL	Stock	54.835	54.91	54.835	54.9075	48300.0
2018-09-25 09:25:00	AAPL	Stock	54.905	54.94	54.89	54.94	185084.0
2018-09-25 09:30:00	AAPL	Stock	54.9375	55.235	54.925	55.0375	4914604.0
2018-09-25 09:35:00	AAPL	Stock	55.03	55.2225	55.0225	55.2075	1721488.0

> showing 50 of 358,059 rows — these rows as CSV

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