PREVIEW / stock_1min / 2018-03-26

all stock 1-min files

  file:    by_date/stock_1min/2018/2018-03-26.parquet
  size:    15.8 MB
  rows:    1,125,498
  symbols: 2,397

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-26 04:00:00	AAPL	Stock	41.7125	41.88	41.7125	41.88	13836.0
2018-03-26 04:01:00	AAPL	Stock	41.915	41.9825	41.915	41.9825	3392.0
2018-03-26 04:02:00	AAPL	Stock	42.0725	42.0725	42.07	42.07	2400.0
2018-03-26 04:03:00	AAPL	Stock	42.055	42.055	42.055	42.055	400.0
2018-03-26 04:05:00	AAPL	Stock	42.125	42.125	42.125	42.125	1600.0
2018-03-26 04:12:00	AAPL	Stock	42.12	42.12	42.12	42.12	624.0
2018-03-26 04:14:00	AAPL	Stock	42.0625	42.12	42.0625	42.12	10000.0
2018-03-26 04:22:00	AAPL	Stock	42.155	42.155	42.155	42.155	2800.0
2018-03-26 04:23:00	AAPL	Stock	42.125	42.125	42.125	42.125	756.0
2018-03-26 04:38:00	AAPL	Stock	42.175	42.175	42.175	42.175	592.0
2018-03-26 05:36:00	AAPL	Stock	42.105	42.125	42.105	42.1225	5392.0
2018-03-26 05:44:00	AAPL	Stock	42.1475	42.1475	42.1475	42.1475	480.0
2018-03-26 05:47:00	AAPL	Stock	42.1475	42.16	42.1475	42.16	2660.0
2018-03-26 05:52:00	AAPL	Stock	42.14	42.1475	42.14	42.1475	800.0
2018-03-26 05:55:00	AAPL	Stock	42.1575	42.1875	42.1575	42.1875	15200.0
2018-03-26 05:58:00	AAPL	Stock	42.1625	42.1625	42.1625	42.1625	1200.0
2018-03-26 06:01:00	AAPL	Stock	42.165	42.165	42.1625	42.1625	3944.0
2018-03-26 06:04:00	AAPL	Stock	42.165	42.165	42.165	42.165	2400.0
2018-03-26 06:05:00	AAPL	Stock	42.2225	42.2225	42.2225	42.2225	3312.0
2018-03-26 06:10:00	AAPL	Stock	42.1875	42.1875	42.1875	42.1875	400.0
2018-03-26 06:13:00	AAPL	Stock	42.175	42.2175	42.175	42.2	2000.0
2018-03-26 06:14:00	AAPL	Stock	42.1925	42.1925	42.1925	42.1925	2560.0
2018-03-26 06:19:00	AAPL	Stock	42.125	42.175	42.125	42.125	2000.0
2018-03-26 06:21:00	AAPL	Stock	42.125	42.125	42.125	42.125	1600.0
2018-03-26 06:23:00	AAPL	Stock	42.1	42.125	42.1	42.125	1820.0
2018-03-26 06:24:00	AAPL	Stock	42.125	42.125	42.125	42.125	400.0
2018-03-26 06:25:00	AAPL	Stock	42.1225	42.1225	42.1	42.1	2400.0
2018-03-26 06:30:00	AAPL	Stock	42.1425	42.1425	42.1425	42.1425	400.0
2018-03-26 06:35:00	AAPL	Stock	42.0775	42.11	42.0775	42.11	2800.0
2018-03-26 06:36:00	AAPL	Stock	42.0775	42.1075	42.075	42.1075	5568.0
2018-03-26 06:38:00	AAPL	Stock	42.0975	42.0975	42.0975	42.0975	800.0
2018-03-26 06:39:00	AAPL	Stock	42.0975	42.1	42.07	42.1	6000.0
2018-03-26 06:44:00	AAPL	Stock	42.1025	42.1025	42.075	42.075	1032.0
2018-03-26 06:48:00	AAPL	Stock	42.0975	42.1	42.0975	42.0975	8368.0
2018-03-26 06:50:00	AAPL	Stock	42.1	42.1	42.0975	42.0975	3600.0
2018-03-26 06:53:00	AAPL	Stock	42.0975	42.0975	42.0975	42.0975	800.0
2018-03-26 06:54:00	AAPL	Stock	42.1125	42.1125	42.1125	42.1125	800.0
2018-03-26 06:56:00	AAPL	Stock	42.1	42.1	42.1	42.1	1800.0
2018-03-26 06:59:00	AAPL	Stock	42.1575	42.1575	42.1575	42.1575	4000.0
2018-03-26 07:00:00	AAPL	Stock	42.1575	42.1575	42.0275	42.15	28580.0
2018-03-26 07:01:00	AAPL	Stock	42.1225	42.1225	42.075	42.075	3920.0
2018-03-26 07:02:00	AAPL	Stock	42.075	42.115	42.075	42.115	7600.0
2018-03-26 07:03:00	AAPL	Stock	42.0875	42.0875	42.075	42.085	4816.0
2018-03-26 07:04:00	AAPL	Stock	42.0875	42.0875	42.0625	42.065	1680.0
2018-03-26 07:05:00	AAPL	Stock	42.0675	42.0675	42.0675	42.0675	400.0
2018-03-26 07:06:00	AAPL	Stock	42.075	42.075	42.075	42.075	2400.0
2018-03-26 07:07:00	AAPL	Stock	42.0675	42.075	42.065	42.065	4640.0
2018-03-26 07:08:00	AAPL	Stock	42.0675	42.0675	42.0625	42.0625	9952.0
2018-03-26 07:09:00	AAPL	Stock	42.065	42.065	42.055	42.065	47520.0
2018-03-26 07:10:00	AAPL	Stock	42.065	42.085	42.065	42.075	14400.0

> showing 50 of 1,125,498 rows — these rows as CSV

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