PREVIEW / stock_5min / 2018-08-17

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-08-17.parquet
  size:    5.3 MB
  rows:    338,653
  symbols: 2,786

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-08-17 04:00:00	AAPL	Stock	53.375	53.375	53.375	53.375	428.0
2018-08-17 04:05:00	AAPL	Stock	53.4125	53.4875	53.4125	53.4875	7652.0
2018-08-17 04:35:00	AAPL	Stock	53.4875	53.4875	53.4875	53.4875	400.0
2018-08-17 04:45:00	AAPL	Stock	53.5	53.5	53.5	53.5	1000.0
2018-08-17 04:50:00	AAPL	Stock	53.4875	53.4875	53.4375	53.45	3200.0
2018-08-17 05:15:00	AAPL	Stock	53.425	53.425	53.425	53.425	1808.0
2018-08-17 05:20:00	AAPL	Stock	53.425	53.45	53.425	53.45	3600.0
2018-08-17 05:25:00	AAPL	Stock	53.425	53.425	53.425	53.425	2000.0
2018-08-17 05:30:00	AAPL	Stock	53.425	53.425	53.425	53.425	1892.0
2018-08-17 05:35:00	AAPL	Stock	53.4	53.4	53.3775	53.3775	6520.0
2018-08-17 05:40:00	AAPL	Stock	53.37	53.375	53.37	53.375	1000.0
2018-08-17 05:45:00	AAPL	Stock	53.35	53.35	53.35	53.35	2056.0
2018-08-17 05:50:00	AAPL	Stock	53.28	53.28	53.28	53.28	776.0
2018-08-17 06:05:00	AAPL	Stock	53.28	53.28	53.275	53.275	3600.0
2018-08-17 06:10:00	AAPL	Stock	53.2725	53.275	53.2725	53.275	6508.0
2018-08-17 06:15:00	AAPL	Stock	53.295	53.31	53.295	53.31	8504.0
2018-08-17 06:20:00	AAPL	Stock	53.3125	53.3125	53.3125	53.3125	1600.0
2018-08-17 06:30:00	AAPL	Stock	53.3125	53.3125	53.3125	53.3125	400.0
2018-08-17 06:45:00	AAPL	Stock	53.3225	53.33	53.32	53.33	8688.0
2018-08-17 06:55:00	AAPL	Stock	53.33	53.335	53.33	53.335	1840.0
2018-08-17 07:00:00	AAPL	Stock	53.3475	53.37	53.32	53.3375	16136.0
2018-08-17 07:05:00	AAPL	Stock	53.35	53.3775	53.35	53.3775	12112.0
2018-08-17 07:15:00	AAPL	Stock	53.3475	53.35	53.32	53.32	7888.0
2018-08-17 07:20:00	AAPL	Stock	53.32	53.32	53.32	53.32	400.0
2018-08-17 07:25:00	AAPL	Stock	53.3475	53.35	53.345	53.3475	6996.0
2018-08-17 07:30:00	AAPL	Stock	53.3475	53.3475	53.3375	53.3375	4400.0
2018-08-17 07:35:00	AAPL	Stock	53.33	53.335	53.33	53.335	3600.0
2018-08-17 07:40:00	AAPL	Stock	53.3125	53.325	53.3125	53.325	2780.0
2018-08-17 07:45:00	AAPL	Stock	53.3125	53.3125	53.3125	53.3125	1200.0
2018-08-17 07:55:00	AAPL	Stock	53.325	53.325	53.3	53.3	7812.0
2018-08-17 08:00:00	AAPL	Stock	53.3625	53.375	53.275	53.275	114232.0
2018-08-17 08:05:00	AAPL	Stock	53.2725	53.2725	53.2	53.2525	27752.0
2018-08-17 08:10:00	AAPL	Stock	53.2525	53.2525	53.2025	53.2025	23000.0
2018-08-17 08:15:00	AAPL	Stock	53.2175	53.2475	53.2	53.205	14400.0
2018-08-17 08:20:00	AAPL	Stock	53.2125	53.2125	53.2125	53.2125	400.0
2018-08-17 08:25:00	AAPL	Stock	53.22	53.22	53.2125	53.22	3460.0
2018-08-17 08:30:00	AAPL	Stock	53.225	53.2325	53.225	53.2325	7000.0
2018-08-17 08:35:00	AAPL	Stock	53.235	53.2375	53.2325	53.2375	18656.0
2018-08-17 08:40:00	AAPL	Stock	53.2425	53.245	53.2425	53.2425	12200.0
2018-08-17 08:45:00	AAPL	Stock	53.245	53.2525	53.245	53.2525	25500.0
2018-08-17 08:50:00	AAPL	Stock	53.2625	53.265	53.2525	53.26	23344.0
2018-08-17 08:55:00	AAPL	Stock	53.2825	53.2825	53.265	53.265	7100.0
2018-08-17 09:00:00	AAPL	Stock	53.2725	53.2725	53.25	53.2525	19524.0
2018-08-17 09:05:00	AAPL	Stock	53.2625	53.2625	53.245	53.26	32112.0
2018-08-17 09:10:00	AAPL	Stock	53.26	53.265	53.26	53.2625	9252.0
2018-08-17 09:15:00	AAPL	Stock	53.27	53.27	53.2475	53.2475	14768.0
2018-08-17 09:20:00	AAPL	Stock	53.2375	53.2625	53.2375	53.2625	18400.0
2018-08-17 09:25:00	AAPL	Stock	53.2525	53.365	53.24	53.355	44120.0
2018-08-17 09:30:00	AAPL	Stock	53.36	53.5875	53.29	53.465	6785612.0
2018-08-17 09:35:00	AAPL	Stock	53.4692	53.6575	53.425	53.645	2943392.0

> showing 50 of 338,653 rows — these rows as CSV

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