PREVIEW / stock_5min / 2019-03-28

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-03-28.parquet
  size:    5.7 MB
  rows:    365,128
  symbols: 2,639

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-03-28 05:25:00	AAPL	Stock	47.1175	47.1175	47.1175	47.1175	804.0
2019-03-28 05:55:00	AAPL	Stock	47.1	47.1	47.07	47.07	3740.0
2019-03-28 06:00:00	AAPL	Stock	47.1225	47.1225	47.1225	47.1225	400.0
2019-03-28 06:30:00	AAPL	Stock	47.195	47.195	47.195	47.195	1764.0
2019-03-28 06:40:00	AAPL	Stock	47.0925	47.0925	47.0925	47.0925	1600.0
2019-03-28 07:00:00	AAPL	Stock	47.1575	47.1575	47.045	47.0975	23916.0
2019-03-28 07:05:00	AAPL	Stock	47.09	47.09	47.025	47.025	11792.0
2019-03-28 07:10:00	AAPL	Stock	47.05	47.05	47.025	47.025	10216.0
2019-03-28 07:15:00	AAPL	Stock	47.0425	47.05	47.025	47.025	11152.0
2019-03-28 07:20:00	AAPL	Stock	47.035	47.035	47.035	47.035	800.0
2019-03-28 07:25:00	AAPL	Stock	47.025	47.025	47.0125	47.0125	1600.0
2019-03-28 07:30:00	AAPL	Stock	47.0225	47.0225	47.0225	47.0225	1200.0
2019-03-28 07:35:00	AAPL	Stock	47.0025	47.0025	46.97	46.97	4708.0
2019-03-28 07:40:00	AAPL	Stock	46.9775	46.98	46.9625	46.98	2000.0
2019-03-28 07:45:00	AAPL	Stock	47.0	47.0	47.0	47.0	18224.0
2019-03-28 07:50:00	AAPL	Stock	47.0	47.01	47.0	47.01	1072.0
2019-03-28 07:55:00	AAPL	Stock	47.025	47.0375	47.005	47.0275	6444.0
2019-03-28 08:00:00	AAPL	Stock	47.0275	47.2375	46.9325	47.095	72348.0
2019-03-28 08:05:00	AAPL	Stock	47.0875	47.15	47.0875	47.1225	13900.0
2019-03-28 08:10:00	AAPL	Stock	47.165	47.17	47.11	47.11	29188.0
2019-03-28 08:15:00	AAPL	Stock	47.13	47.1625	47.1275	47.15	8048.0
2019-03-28 08:20:00	AAPL	Stock	47.1475	47.15	47.1125	47.1225	24004.0
2019-03-28 08:25:00	AAPL	Stock	47.125	47.1475	47.065	47.075	20800.0
2019-03-28 08:30:00	AAPL	Stock	47.075	47.085	47.0375	47.04	15280.0
2019-03-28 08:35:00	AAPL	Stock	47.025	47.025	46.915	46.975	27708.0
2019-03-28 08:40:00	AAPL	Stock	46.9925	47.0	46.98	46.99	49852.0
2019-03-28 08:45:00	AAPL	Stock	46.9975	47.03	46.9975	47.015	22676.0
2019-03-28 08:50:00	AAPL	Stock	47.03	47.09	47.03	47.0875	33116.0
2019-03-28 08:55:00	AAPL	Stock	47.09	47.09	47.0425	47.07	7800.0
2019-03-28 09:00:00	AAPL	Stock	47.0825	47.0825	47.006	47.006	8608.0
2019-03-28 09:05:00	AAPL	Stock	47.0575	47.1	47.03	47.0975	11528.0
2019-03-28 09:10:00	AAPL	Stock	47.0575	47.075	47.005	47.0225	6660.0
2019-03-28 09:15:00	AAPL	Stock	47.025	47.1075	47.025	47.1075	10072.0
2019-03-28 09:20:00	AAPL	Stock	47.1175	47.1175	47.035	47.1025	10744.0
2019-03-28 09:25:00	AAPL	Stock	47.1275	47.2275	47.1	47.2275	31116.0
2019-03-28 09:30:00	AAPL	Stock	47.2325	47.3898	47.0475	47.155	3096200.0
2019-03-28 09:35:00	AAPL	Stock	47.1595	47.2888	47.1275	47.1825	1514504.0
2019-03-28 09:40:00	AAPL	Stock	47.1875	47.33	47.115	47.2975	1487756.0
2019-03-28 09:45:00	AAPL	Stock	47.3025	47.31	47.215	47.2425	1273152.0
2019-03-28 09:50:00	AAPL	Stock	47.2425	47.2675	47.0	47.06	2153868.0
2019-03-28 09:55:00	AAPL	Stock	47.0675	47.1725	47.0575	47.1525	1114744.0
2019-03-28 10:00:00	AAPL	Stock	47.16	47.2375	47.03	47.1878	1815076.0
2019-03-28 10:05:00	AAPL	Stock	47.1925	47.22	47.1275	47.1975	992688.0
2019-03-28 10:10:00	AAPL	Stock	47.1975	47.2025	47.055	47.078	1048640.0
2019-03-28 10:15:00	AAPL	Stock	47.08	47.12	46.985	47.03	1062636.0
2019-03-28 10:20:00	AAPL	Stock	47.03	47.075	46.98	47.0225	1103412.0
2019-03-28 10:25:00	AAPL	Stock	47.0205	47.035	46.955	47.02	1155384.0
2019-03-28 10:30:00	AAPL	Stock	47.02	47.1225	47.0075	47.0988	1537492.0
2019-03-28 10:35:00	AAPL	Stock	47.1	47.145	47.0875	47.1025	918696.0
2019-03-28 10:40:00	AAPL	Stock	47.105	47.175	47.0875	47.155	1051284.0

> showing 50 of 365,128 rows — these rows as CSV

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