PREVIEW / stock_5min / 2018-03-14

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-03-14.parquet
  size:    5.5 MB
  rows:    358,992
  symbols: 2,865

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-03-14 04:00:00	AAPL	Stock	45.0125	45.0125	44.875	44.875	1892.0
2018-03-14 04:20:00	AAPL	Stock	45.125	45.125	45.125	45.125	4000.0
2018-03-14 04:35:00	AAPL	Stock	45.2025	45.2175	45.2025	45.205	2800.0
2018-03-14 04:40:00	AAPL	Stock	45.1625	45.1625	45.1625	45.1625	800.0
2018-03-14 04:45:00	AAPL	Stock	45.1575	45.1575	45.0525	45.0525	880.0
2018-03-14 05:10:00	AAPL	Stock	45.2225	45.225	45.2225	45.225	7200.0
2018-03-14 05:15:00	AAPL	Stock	45.225	45.225	45.225	45.225	1200.0
2018-03-14 05:25:00	AAPL	Stock	45.2225	45.225	45.2225	45.225	4000.0
2018-03-14 05:55:00	AAPL	Stock	45.225	45.225	45.225	45.225	400.0
2018-03-14 06:20:00	AAPL	Stock	45.21	45.21	45.21	45.21	400.0
2018-03-14 06:35:00	AAPL	Stock	45.225	45.225	45.225	45.225	4000.0
2018-03-14 06:50:00	AAPL	Stock	45.215	45.215	45.2	45.2	2800.0
2018-03-14 06:55:00	AAPL	Stock	45.2	45.2	45.1875	45.1875	1424.0
2018-03-14 07:00:00	AAPL	Stock	45.1525	45.27	45.1525	45.25	52840.0
2018-03-14 07:05:00	AAPL	Stock	45.25	45.2525	45.24	45.25	14000.0
2018-03-14 07:10:00	AAPL	Stock	45.26	45.2625	45.205	45.205	23480.0
2018-03-14 07:15:00	AAPL	Stock	45.2225	45.225	45.2025	45.2025	7812.0
2018-03-14 07:20:00	AAPL	Stock	45.2175	45.25	45.215	45.2475	30528.0
2018-03-14 07:25:00	AAPL	Stock	45.2225	45.2225	45.205	45.205	1948.0
2018-03-14 07:30:00	AAPL	Stock	45.2225	45.2225	45.2125	45.2175	11952.0
2018-03-14 07:35:00	AAPL	Stock	45.2225	45.24	45.2225	45.225	2148.0
2018-03-14 07:40:00	AAPL	Stock	45.2375	45.2425	45.225	45.225	8408.0
2018-03-14 07:45:00	AAPL	Stock	45.225	45.2325	45.225	45.2325	11092.0
2018-03-14 07:50:00	AAPL	Stock	45.235	45.235	45.2325	45.2325	4844.0
2018-03-14 07:55:00	AAPL	Stock	45.235	45.2475	45.235	45.2475	5340.0
2018-03-14 08:00:00	AAPL	Stock	45.2325	45.2525	45.1575	45.175	97236.0
2018-03-14 08:05:00	AAPL	Stock	45.1675	45.1875	45.1325	45.15	38348.0
2018-03-14 08:10:00	AAPL	Stock	45.14	45.14	45.1125	45.12	66168.0
2018-03-14 08:15:00	AAPL	Stock	45.12	45.165	45.1125	45.1375	26280.0
2018-03-14 08:20:00	AAPL	Stock	45.15	45.17	45.1475	45.17	21424.0
2018-03-14 08:25:00	AAPL	Stock	45.17	45.17	45.125	45.155	33672.0
2018-03-14 08:30:00	AAPL	Stock	45.1675	45.2225	45.125	45.2	47972.0
2018-03-14 08:35:00	AAPL	Stock	45.2	45.2125	45.175	45.1975	19000.0
2018-03-14 08:40:00	AAPL	Stock	45.19	45.1925	45.165	45.1925	9200.0
2018-03-14 08:45:00	AAPL	Stock	45.1875	45.2125	45.18	45.2	30424.0
2018-03-14 08:50:00	AAPL	Stock	45.2125	45.2125	45.1725	45.2	32124.0
2018-03-14 08:55:00	AAPL	Stock	45.1875	45.1875	45.14	45.14	12500.0
2018-03-14 09:00:00	AAPL	Stock	45.1325	45.175	45.125	45.15	40772.0
2018-03-14 09:05:00	AAPL	Stock	45.1375	45.15	45.1175	45.1375	8500.0
2018-03-14 09:10:00	AAPL	Stock	45.125	45.125	45.08	45.08	44508.0
2018-03-14 09:15:00	AAPL	Stock	45.0875	45.115	45.075	45.0875	58284.0
2018-03-14 09:20:00	AAPL	Stock	45.075	45.0875	45.075	45.0875	100500.0
2018-03-14 09:25:00	AAPL	Stock	45.0675	45.125	45.065	45.0875	107336.0
2018-03-14 09:30:00	AAPL	Stock	45.08	45.13	44.85	44.87	4741652.0
2018-03-14 09:35:00	AAPL	Stock	44.87	44.8775	44.72	44.7275	3422840.0
2018-03-14 09:40:00	AAPL	Stock	44.7225	44.8225	44.64	44.8	3591628.0
2018-03-14 09:45:00	AAPL	Stock	44.8	44.8725	44.7225	44.7488	2503332.0
2018-03-14 09:50:00	AAPL	Stock	44.7412	44.81	44.73	44.7775	1673064.0
2018-03-14 09:55:00	AAPL	Stock	44.775	44.7925	44.7	44.755	1556024.0
2018-03-14 10:00:00	AAPL	Stock	44.7575	44.95	44.7575	44.915	2208400.0

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

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