PREVIEW / stock_5min / 2018-05-21

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-05-21.parquet
  size:    5.6 MB
  rows:    356,193
  symbols: 2,849

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-05-21 04:00:00	AAPL	Stock	46.8025	46.9	46.8025	46.9	12580.0
2018-05-21 04:05:00	AAPL	Stock	46.925	46.925	46.9125	46.9125	8136.0
2018-05-21 04:20:00	AAPL	Stock	46.885	46.9125	46.885	46.9125	916.0
2018-05-21 04:55:00	AAPL	Stock	46.9225	46.9225	46.9225	46.9225	400.0
2018-05-21 05:00:00	AAPL	Stock	46.9075	46.9225	46.9075	46.9225	2000.0
2018-05-21 05:05:00	AAPL	Stock	46.9275	46.9275	46.9225	46.9225	1000.0
2018-05-21 05:50:00	AAPL	Stock	46.93	46.93	46.93	46.93	1200.0
2018-05-21 06:00:00	AAPL	Stock	46.93	46.93	46.85	46.85	2992.0
2018-05-21 06:25:00	AAPL	Stock	46.905	46.905	46.9	46.905	1600.0
2018-05-21 06:30:00	AAPL	Stock	46.9	46.9	46.9	46.9	2400.0
2018-05-21 06:40:00	AAPL	Stock	46.9475	46.9475	46.9475	46.9475	800.0
2018-05-21 06:45:00	AAPL	Stock	46.9475	46.9475	46.9475	46.9475	400.0
2018-05-21 06:55:00	AAPL	Stock	46.9075	46.9075	46.9025	46.9025	4000.0
2018-05-21 07:00:00	AAPL	Stock	46.935	46.965	46.9	46.925	35140.0
2018-05-21 07:05:00	AAPL	Stock	46.9	46.9	46.8925	46.8925	3408.0
2018-05-21 07:10:00	AAPL	Stock	46.91	46.91	46.9	46.91	1200.0
2018-05-21 07:15:00	AAPL	Stock	46.9225	46.925	46.9125	46.925	15524.0
2018-05-21 07:20:00	AAPL	Stock	46.92	46.92	46.92	46.92	400.0
2018-05-21 07:25:00	AAPL	Stock	46.9425	46.9675	46.9425	46.965	14800.0
2018-05-21 07:30:00	AAPL	Stock	46.9725	46.9725	46.97	46.97	7600.0
2018-05-21 07:35:00	AAPL	Stock	46.965	46.965	46.9575	46.965	3740.0
2018-05-21 07:40:00	AAPL	Stock	46.9625	46.9675	46.955	46.9675	9380.0
2018-05-21 07:45:00	AAPL	Stock	46.9575	46.965	46.9525	46.965	13128.0
2018-05-21 07:50:00	AAPL	Stock	46.965	46.97	46.96	46.96	7224.0
2018-05-21 07:55:00	AAPL	Stock	46.9675	46.9875	46.9625	46.9875	10748.0
2018-05-21 08:00:00	AAPL	Stock	46.975	46.995	46.965	46.975	23428.0
2018-05-21 08:05:00	AAPL	Stock	46.975	46.975	46.94	46.97	79244.0
2018-05-21 08:10:00	AAPL	Stock	46.945	46.95	46.9375	46.9375	30788.0
2018-05-21 08:15:00	AAPL	Stock	46.9375	46.9375	46.93	46.93	2200.0
2018-05-21 08:20:00	AAPL	Stock	46.93	46.95	46.93	46.95	38408.0
2018-05-21 08:25:00	AAPL	Stock	46.9625	46.975	46.9375	46.9725	13816.0
2018-05-21 08:30:00	AAPL	Stock	46.97	46.9875	46.97	46.985	28616.0
2018-05-21 08:35:00	AAPL	Stock	46.9775	46.985	46.975	46.985	30920.0
2018-05-21 08:40:00	AAPL	Stock	46.98	46.9975	46.98	46.99	16400.0
2018-05-21 08:45:00	AAPL	Stock	46.995	46.995	46.975	46.98	49572.0
2018-05-21 08:50:00	AAPL	Stock	46.9875	47.0	46.9875	47.0	32252.0
2018-05-21 08:55:00	AAPL	Stock	47.0075	47.0175	47.0	47.01	44032.0
2018-05-21 09:00:00	AAPL	Stock	47.01	47.01	46.9775	46.99	21880.0
2018-05-21 09:05:00	AAPL	Stock	46.995	46.9975	46.9525	46.975	22580.0
2018-05-21 09:10:00	AAPL	Stock	46.975	46.995	46.975	46.975	12616.0
2018-05-21 09:15:00	AAPL	Stock	46.965	46.975	46.95	46.96	13464.0
2018-05-21 09:20:00	AAPL	Stock	46.9575	46.9825	46.9575	46.9825	26704.0
2018-05-21 09:25:00	AAPL	Stock	46.965	47.025	46.945	46.9725	51592.0
2018-05-21 09:30:00	AAPL	Stock	47.0	47.2	46.9775	47.1375	4011476.0
2018-05-21 09:35:00	AAPL	Stock	47.135	47.265	47.12	47.255	2632632.0
2018-05-21 09:40:00	AAPL	Stock	47.2575	47.3075	47.16	47.2972	2000528.0
2018-05-21 09:45:00	AAPL	Stock	47.2925	47.3175	47.22	47.23	1556044.0
2018-05-21 09:50:00	AAPL	Stock	47.2325	47.25	47.185	47.19	1291444.0
2018-05-21 09:55:00	AAPL	Stock	47.1925	47.2512	47.16	47.2475	1646540.0
2018-05-21 10:00:00	AAPL	Stock	47.25	47.3175	47.2275	47.2762	1853380.0

> showing 50 of 356,193 rows — these rows as CSV

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