PREVIEW / stock_5min / 2017-01-06

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-01-06.parquet
  size:    5.3 MB
  rows:    349,408
  symbols: 3,136

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
2017-01-06 06:00:00	AAPL	Stock	29.1425	29.1425	29.1425	29.1425	568.0
2017-01-06 06:30:00	AAPL	Stock	29.1425	29.1425	29.1425	29.1425	424.0
2017-01-06 07:00:00	AAPL	Stock	29.1525	29.1525	29.1525	29.1525	844.0
2017-01-06 07:10:00	AAPL	Stock	29.175	29.175	29.175	29.175	1824.0
2017-01-06 07:15:00	AAPL	Stock	29.1675	29.1675	29.1675	29.1675	800.0
2017-01-06 07:20:00	AAPL	Stock	29.1975	29.2025	29.1975	29.2025	3200.0
2017-01-06 07:35:00	AAPL	Stock	29.2	29.2	29.2	29.2	400.0
2017-01-06 07:40:00	AAPL	Stock	29.1875	29.1875	29.1875	29.1875	400.0
2017-01-06 07:55:00	AAPL	Stock	29.175	29.175	29.175	29.175	1000.0
2017-01-06 08:00:00	AAPL	Stock	29.1525	29.2025	29.1525	29.175	12600.0
2017-01-06 08:05:00	AAPL	Stock	29.175	29.175	29.1275	29.1275	9476.0
2017-01-06 08:10:00	AAPL	Stock	29.1275	29.17	29.0	29.17	156912.0
2017-01-06 08:15:00	AAPL	Stock	29.1375	29.1375	29.1375	29.1375	1144.0
2017-01-06 08:20:00	AAPL	Stock	29.135	29.1475	29.135	29.1475	4540.0
2017-01-06 08:25:00	AAPL	Stock	29.1475	29.165	29.1475	29.1525	7600.0
2017-01-06 08:30:00	AAPL	Stock	29.125	29.2175	29.125	29.2175	60280.0
2017-01-06 08:35:00	AAPL	Stock	29.2	29.2	29.175	29.175	14600.0
2017-01-06 08:40:00	AAPL	Stock	29.13	29.1525	29.13	29.15	15200.0
2017-01-06 08:45:00	AAPL	Stock	29.15	29.175	29.1475	29.1475	9208.0
2017-01-06 08:50:00	AAPL	Stock	29.15	29.15	29.1375	29.15	11128.0
2017-01-06 08:55:00	AAPL	Stock	29.15	29.15	29.1375	29.1375	11688.0
2017-01-06 09:00:00	AAPL	Stock	29.1525	29.1675	29.1525	29.1675	800.0
2017-01-06 09:05:00	AAPL	Stock	29.1625	29.1688	29.16	29.1688	81304.0
2017-01-06 09:10:00	AAPL	Stock	29.1675	29.175	29.155	29.1575	89504.0
2017-01-06 09:15:00	AAPL	Stock	29.165	29.165	29.155	29.16	7428.0
2017-01-06 09:20:00	AAPL	Stock	29.165	29.165	29.1525	29.1525	7076.0
2017-01-06 09:25:00	AAPL	Stock	29.1575	29.2025	29.15	29.195	19476.0
2017-01-06 09:30:00	AAPL	Stock	29.195	29.3312	29.1175	29.2968	7512332.0
2017-01-06 09:35:00	AAPL	Stock	29.2962	29.3375	29.2575	29.3185	3655784.0
2017-01-06 09:40:00	AAPL	Stock	29.32	29.38	29.31	29.35	6214364.0
2017-01-06 09:45:00	AAPL	Stock	29.3488	29.375	29.2725	29.3025	2416176.0
2017-01-06 09:50:00	AAPL	Stock	29.3075	29.3775	29.295	29.355	3179040.0
2017-01-06 09:55:00	AAPL	Stock	29.3538	29.425	29.335	29.42	3573624.0
2017-01-06 10:00:00	AAPL	Stock	29.42	29.4475	29.3925	29.4238	2563848.0
2017-01-06 10:05:00	AAPL	Stock	29.4238	29.4425	29.3925	29.425	2452112.0
2017-01-06 10:10:00	AAPL	Stock	29.425	29.435	29.3975	29.415	1726440.0
2017-01-06 10:15:00	AAPL	Stock	29.4125	29.425	29.38	29.3988	1361152.0
2017-01-06 10:20:00	AAPL	Stock	29.4	29.4025	29.382	29.3825	1129960.0
2017-01-06 10:25:00	AAPL	Stock	29.3825	29.3875	29.3625	29.3828	1320904.0
2017-01-06 10:30:00	AAPL	Stock	29.385	29.3875	29.35	29.3862	931208.0
2017-01-06 10:35:00	AAPL	Stock	29.3872	29.395	29.3575	29.3625	860420.0
2017-01-06 10:40:00	AAPL	Stock	29.365	29.4175	29.36	29.4132	1328564.0
2017-01-06 10:45:00	AAPL	Stock	29.415	29.435	29.4138	29.434	1819404.0
2017-01-06 10:50:00	AAPL	Stock	29.4338	29.4475	29.4175	29.4315	1582212.0
2017-01-06 10:55:00	AAPL	Stock	29.43	29.4475	29.4	29.405	1164316.0
2017-01-06 11:00:00	AAPL	Stock	29.4062	29.4175	29.38	29.38	839052.0
2017-01-06 11:05:00	AAPL	Stock	29.3825	29.4075	29.375	29.4	864936.0
2017-01-06 11:10:00	AAPL	Stock	29.3992	29.435	29.3875	29.4325	855212.0
2017-01-06 11:15:00	AAPL	Stock	29.4325	29.455	29.43	29.4425	1468676.0
2017-01-06 11:20:00	AAPL	Stock	29.4425	29.47	29.4375	29.4635	922176.0

> showing 50 of 349,408 rows — these rows as CSV

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