PREVIEW / stock_5min / 2016-08-22

all stock 5-min files

  file:    by_date/stock_5min/2016/2016-08-22.parquet
  size:    5.2 MB
  rows:    346,230
  symbols: 3,258

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
2016-08-22 04:00:00	AAPL	Stock	27.25	27.25	27.25	27.25	408.0
2016-08-22 05:55:00	AAPL	Stock	27.4125	27.4125	27.4125	27.4125	400.0
2016-08-22 06:10:00	AAPL	Stock	27.3875	27.3875	27.3775	27.3775	2800.0
2016-08-22 06:20:00	AAPL	Stock	27.365	27.365	27.365	27.365	400.0
2016-08-22 06:25:00	AAPL	Stock	27.365	27.365	27.365	27.365	1700.0
2016-08-22 06:55:00	AAPL	Stock	27.31	27.31	27.31	27.31	2400.0
2016-08-22 07:00:00	AAPL	Stock	27.3125	27.3125	27.3125	27.3125	4000.0
2016-08-22 07:05:00	AAPL	Stock	27.305	27.305	27.2975	27.2975	1680.0
2016-08-22 07:15:00	AAPL	Stock	27.325	27.345	27.325	27.345	3388.0
2016-08-22 07:45:00	AAPL	Stock	27.3125	27.3125	27.3125	27.3125	2000.0
2016-08-22 07:50:00	AAPL	Stock	27.325	27.34	27.325	27.34	6220.0
2016-08-22 07:55:00	AAPL	Stock	27.3475	27.3475	27.3475	27.3475	400.0
2016-08-22 08:00:00	AAPL	Stock	27.3375	27.3375	27.3125	27.3375	16800.0
2016-08-22 08:05:00	AAPL	Stock	27.325	27.325	27.325	27.325	4036.0
2016-08-22 08:15:00	AAPL	Stock	27.3425	27.35	27.3425	27.35	6864.0
2016-08-22 08:20:00	AAPL	Stock	27.345	27.3475	27.345	27.345	5924.0
2016-08-22 08:25:00	AAPL	Stock	27.3425	27.3425	27.335	27.335	8208.0
2016-08-22 08:30:00	AAPL	Stock	27.3275	27.3375	27.325	27.3375	6888.0
2016-08-22 08:35:00	AAPL	Stock	27.3375	27.3375	27.3375	27.3375	4000.0
2016-08-22 08:50:00	AAPL	Stock	27.32	27.3325	27.3	27.3	22828.0
2016-08-22 08:55:00	AAPL	Stock	27.2925	27.2925	27.2675	27.2725	54560.0
2016-08-22 09:00:00	AAPL	Stock	27.2725	27.28	27.2725	27.2725	13428.0
2016-08-22 09:05:00	AAPL	Stock	27.2775	27.28	27.265	27.275	27836.0
2016-08-22 09:10:00	AAPL	Stock	27.275	27.275	27.2675	27.275	1800.0
2016-08-22 09:15:00	AAPL	Stock	27.275	27.2875	27.275	27.275	12600.0
2016-08-22 09:20:00	AAPL	Stock	27.275	27.275	27.2725	27.275	2800.0
2016-08-22 09:25:00	AAPL	Stock	27.265	27.265	27.22	27.22	149268.0
2016-08-22 09:30:00	AAPL	Stock	27.215	27.25	27.1725	27.1875	4238396.0
2016-08-22 09:35:00	AAPL	Stock	27.185	27.22	27.1575	27.2112	2195504.0
2016-08-22 09:40:00	AAPL	Stock	27.2102	27.235	27.1925	27.2175	2024936.0
2016-08-22 09:45:00	AAPL	Stock	27.2175	27.26	27.2	27.2125	1851796.0
2016-08-22 09:50:00	AAPL	Stock	27.21	27.2175	27.165	27.17	2167580.0
2016-08-22 09:55:00	AAPL	Stock	27.17	27.195	27.1662	27.19	1208896.0
2016-08-22 10:00:00	AAPL	Stock	27.1878	27.19	27.1238	27.14	2280568.0
2016-08-22 10:05:00	AAPL	Stock	27.1375	27.1518	27.125	27.135	1190568.0
2016-08-22 10:10:00	AAPL	Stock	27.1335	27.1525	27.1275	27.1425	1198816.0
2016-08-22 10:15:00	AAPL	Stock	27.1438	27.235	27.1425	27.215	2256240.0
2016-08-22 10:20:00	AAPL	Stock	27.2175	27.2225	27.18	27.195	1472472.0
2016-08-22 10:25:00	AAPL	Stock	27.1925	27.2188	27.1875	27.2085	1441576.0
2016-08-22 10:30:00	AAPL	Stock	27.2075	27.2125	27.1888	27.21	1266264.0
2016-08-22 10:35:00	AAPL	Stock	27.2112	27.22	27.18	27.1825	1041104.0
2016-08-22 10:40:00	AAPL	Stock	27.1825	27.195	27.1625	27.1925	977176.0
2016-08-22 10:45:00	AAPL	Stock	27.19	27.1922	27.15	27.16	1124420.0
2016-08-22 10:50:00	AAPL	Stock	27.16	27.1738	27.1525	27.1698	889460.0
2016-08-22 10:55:00	AAPL	Stock	27.1698	27.1725	27.1425	27.1475	818208.0
2016-08-22 11:00:00	AAPL	Stock	27.1462	27.16	27.1275	27.1415	915272.0
2016-08-22 11:05:00	AAPL	Stock	27.1425	27.1475	27.1275	27.1275	859228.0
2016-08-22 11:10:00	AAPL	Stock	27.1275	27.1525	27.1275	27.1425	658464.0
2016-08-22 11:15:00	AAPL	Stock	27.1425	27.144	27.075	27.0775	1887924.0
2016-08-22 11:20:00	AAPL	Stock	27.0775	27.0875	27.0275	27.045	2276740.0

> showing 50 of 346,230 rows — these rows as CSV

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