PREVIEW / stock_5min / 2018-09-28

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-09-28.parquet
  size:    5.6 MB
  rows:    355,904
  symbols: 2,797

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-09-28 04:00:00	AAPL	Stock	56.125	56.125	56.125	56.125	3980.0
2018-09-28 04:10:00	AAPL	Stock	56.125	56.125	56.125	56.125	1400.0
2018-09-28 04:40:00	AAPL	Stock	56.1275	56.1275	56.1275	56.1275	564.0
2018-09-28 05:20:00	AAPL	Stock	56.2	56.2	56.2	56.2	800.0
2018-09-28 05:40:00	AAPL	Stock	56.125	56.125	56.115	56.115	2400.0
2018-09-28 05:55:00	AAPL	Stock	56.18	56.18	56.18	56.18	400.0
2018-09-28 06:00:00	AAPL	Stock	56.1975	56.1975	56.1975	56.1975	2000.0
2018-09-28 06:10:00	AAPL	Stock	56.1	56.1	56.1	56.1	2000.0
2018-09-28 06:15:00	AAPL	Stock	56.08	56.08	56.08	56.08	400.0
2018-09-28 06:20:00	AAPL	Stock	56.0575	56.0575	56.0575	56.0575	400.0
2018-09-28 06:25:00	AAPL	Stock	56.0875	56.0875	56.0375	56.0375	3704.0
2018-09-28 06:30:00	AAPL	Stock	56.005	56.005	56.005	56.005	400.0
2018-09-28 06:40:00	AAPL	Stock	56.0	56.0	56.0	56.0	1364.0
2018-09-28 06:45:00	AAPL	Stock	56.0	56.0625	56.0	56.0625	3600.0
2018-09-28 06:50:00	AAPL	Stock	56.025	56.025	56.0125	56.0125	2616.0
2018-09-28 06:55:00	AAPL	Stock	56.015	56.015	56.0	56.0	3956.0
2018-09-28 07:00:00	AAPL	Stock	56.0	56.055	56.0	56.055	25452.0
2018-09-28 07:05:00	AAPL	Stock	56.0625	56.0625	55.9625	55.9625	16104.0
2018-09-28 07:10:00	AAPL	Stock	55.955	55.9975	55.955	55.9925	7560.0
2018-09-28 07:15:00	AAPL	Stock	55.9975	55.9975	55.9775	55.9775	1080.0
2018-09-28 07:20:00	AAPL	Stock	55.95	55.95	55.94	55.95	9696.0
2018-09-28 07:25:00	AAPL	Stock	55.9625	55.9625	55.95	55.9625	3600.0
2018-09-28 07:30:00	AAPL	Stock	55.9925	56.0375	55.985	56.0	29904.0
2018-09-28 07:35:00	AAPL	Stock	56.0	56.0	55.9625	55.9875	10972.0
2018-09-28 07:40:00	AAPL	Stock	55.995	55.995	55.9625	55.9625	5640.0
2018-09-28 07:45:00	AAPL	Stock	55.98	55.98	55.905	55.9425	20148.0
2018-09-28 07:50:00	AAPL	Stock	55.9575	55.96	55.9175	55.9375	4356.0
2018-09-28 07:55:00	AAPL	Stock	55.9525	55.98	55.95	55.98	2800.0
2018-09-28 08:00:00	AAPL	Stock	55.9775	56.0575	55.9	56.0125	132432.0
2018-09-28 08:05:00	AAPL	Stock	56.025	56.0725	56.025	56.07	41600.0
2018-09-28 08:10:00	AAPL	Stock	56.055	56.1725	56.05	56.125	68504.0
2018-09-28 08:15:00	AAPL	Stock	56.125	56.125	56.0375	56.0375	33688.0
2018-09-28 08:20:00	AAPL	Stock	56.0375	56.07	56.02	56.0375	44732.0
2018-09-28 08:25:00	AAPL	Stock	56.0375	56.085	56.025	56.0825	47448.0
2018-09-28 08:30:00	AAPL	Stock	56.085	56.125	56.0825	56.125	32948.0
2018-09-28 08:35:00	AAPL	Stock	56.1075	56.1225	56.065	56.085	62660.0
2018-09-28 08:40:00	AAPL	Stock	56.1	56.1325	56.0975	56.1125	24140.0
2018-09-28 08:45:00	AAPL	Stock	56.1125	56.15	56.1125	56.15	48304.0
2018-09-28 08:50:00	AAPL	Stock	56.1475	56.16	56.13	56.1425	31936.0
2018-09-28 08:55:00	AAPL	Stock	56.1425	56.1875	56.14	56.175	45616.0
2018-09-28 09:00:00	AAPL	Stock	56.1625	56.1675	56.15	56.1625	18348.0
2018-09-28 09:05:00	AAPL	Stock	56.1625	56.1825	56.1525	56.1825	17884.0
2018-09-28 09:10:00	AAPL	Stock	56.1825	56.2	56.1275	56.1675	61180.0
2018-09-28 09:15:00	AAPL	Stock	56.15	56.15	56.1	56.125	54872.0
2018-09-28 09:20:00	AAPL	Stock	56.14	56.14	56.1025	56.1375	15880.0
2018-09-28 09:25:00	AAPL	Stock	56.125	56.2025	56.115	56.2025	60376.0
2018-09-28 09:30:00	AAPL	Stock	56.1975	56.3725	56.11	56.122	3584420.0
2018-09-28 09:35:00	AAPL	Stock	56.125	56.345	56.005	56.2662	2470756.0
2018-09-28 09:40:00	AAPL	Stock	56.255	56.3198	56.1725	56.2275	1253040.0
2018-09-28 09:45:00	AAPL	Stock	56.2275	56.2275	56.065	56.1725	1635124.0

> showing 50 of 355,904 rows — these rows as CSV

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