PREVIEW / stock_5min / 2018-06-05

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-06-05.parquet
  size:    5.7 MB
  rows:    370,758
  symbols: 2,851

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-06-05 04:00:00	AAPL	Stock	48.0525	48.0525	48.0525	48.0525	1800.0
2018-06-05 04:10:00	AAPL	Stock	48.11	48.11	48.11	48.11	3700.0
2018-06-05 04:15:00	AAPL	Stock	48.11	48.11	48.11	48.11	4000.0
2018-06-05 04:30:00	AAPL	Stock	48.1375	48.145	48.1375	48.145	2400.0
2018-06-05 04:35:00	AAPL	Stock	48.1675	48.1675	48.1675	48.1675	1600.0
2018-06-05 04:55:00	AAPL	Stock	48.185	48.1875	48.185	48.1875	2752.0
2018-06-05 05:00:00	AAPL	Stock	48.1875	48.1875	48.1875	48.1875	800.0
2018-06-05 05:20:00	AAPL	Stock	48.1875	48.1975	48.1875	48.1975	3056.0
2018-06-05 05:40:00	AAPL	Stock	48.2	48.2075	48.2	48.2075	916.0
2018-06-05 05:45:00	AAPL	Stock	48.2125	48.2125	48.2125	48.2125	8424.0
2018-06-05 05:55:00	AAPL	Stock	48.1775	48.21	48.17	48.21	2756.0
2018-06-05 06:05:00	AAPL	Stock	48.1675	48.175	48.1675	48.1675	3000.0
2018-06-05 06:15:00	AAPL	Stock	48.1675	48.1675	48.1325	48.1325	8020.0
2018-06-05 06:20:00	AAPL	Stock	48.1375	48.1625	48.1325	48.1625	7444.0
2018-06-05 06:30:00	AAPL	Stock	48.13	48.13	48.13	48.13	400.0
2018-06-05 06:35:00	AAPL	Stock	48.125	48.13	48.125	48.13	2368.0
2018-06-05 06:40:00	AAPL	Stock	48.1475	48.15	48.1475	48.15	2800.0
2018-06-05 06:45:00	AAPL	Stock	48.1375	48.14	48.1375	48.14	800.0
2018-06-05 06:50:00	AAPL	Stock	48.1625	48.1675	48.1625	48.1675	1200.0
2018-06-05 07:00:00	AAPL	Stock	48.165	48.1925	48.15	48.1925	79004.0
2018-06-05 07:05:00	AAPL	Stock	48.1875	48.1975	48.1825	48.1875	19896.0
2018-06-05 07:10:00	AAPL	Stock	48.1925	48.205	48.1925	48.2	22884.0
2018-06-05 07:15:00	AAPL	Stock	48.2	48.25	48.2	48.2375	44152.0
2018-06-05 07:20:00	AAPL	Stock	48.2425	48.3125	48.2425	48.3	82740.0
2018-06-05 07:25:00	AAPL	Stock	48.2875	48.295	48.275	48.2875	7456.0
2018-06-05 07:30:00	AAPL	Stock	48.2825	48.2825	48.2525	48.2525	9448.0
2018-06-05 07:35:00	AAPL	Stock	48.2675	48.275	48.2625	48.275	9980.0
2018-06-05 07:40:00	AAPL	Stock	48.2825	48.2825	48.2825	48.2825	500.0
2018-06-05 07:45:00	AAPL	Stock	48.275	48.295	48.275	48.29	34688.0
2018-06-05 07:50:00	AAPL	Stock	48.285	48.29	48.27	48.27	21796.0
2018-06-05 07:55:00	AAPL	Stock	48.265	48.2875	48.265	48.2875	4000.0
2018-06-05 08:00:00	AAPL	Stock	48.1975	48.325	48.1525	48.2525	162264.0
2018-06-05 08:05:00	AAPL	Stock	48.275	48.2925	48.2375	48.2375	68688.0
2018-06-05 08:10:00	AAPL	Stock	48.2275	48.2625	48.2125	48.23	62712.0
2018-06-05 08:15:00	AAPL	Stock	48.2325	48.24	48.1875	48.1875	32220.0
2018-06-05 08:20:00	AAPL	Stock	48.19	48.2125	48.1875	48.1975	18172.0
2018-06-05 08:25:00	AAPL	Stock	48.195	48.225	48.185	48.1875	56324.0
2018-06-05 08:30:00	AAPL	Stock	48.185	48.205	48.1525	48.1625	71948.0
2018-06-05 08:35:00	AAPL	Stock	48.17	48.175	48.125	48.15	23852.0
2018-06-05 08:40:00	AAPL	Stock	48.15	48.1725	48.14	48.17	8984.0
2018-06-05 08:45:00	AAPL	Stock	48.1825	48.1825	48.1525	48.1775	19964.0
2018-06-05 08:50:00	AAPL	Stock	48.1875	48.195	48.1825	48.1875	19280.0
2018-06-05 08:55:00	AAPL	Stock	48.195	48.195	48.15	48.15	16776.0
2018-06-05 09:00:00	AAPL	Stock	48.1375	48.165	48.13	48.165	20676.0
2018-06-05 09:05:00	AAPL	Stock	48.1725	48.195	48.1625	48.195	12888.0
2018-06-05 09:10:00	AAPL	Stock	48.195	48.2125	47.9575	48.21	25748.0
2018-06-05 09:15:00	AAPL	Stock	48.1925	48.21	48.175	48.175	27772.0
2018-06-05 09:20:00	AAPL	Stock	48.175	48.2125	48.175	48.2125	25288.0
2018-06-05 09:25:00	AAPL	Stock	48.2225	48.2825	48.19	48.27	88416.0
2018-06-05 09:30:00	AAPL	Stock	48.23	48.3525	48.175	48.285	4407000.0

> showing 50 of 370,758 rows — these rows as CSV

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