PREVIEW / stock_5min / 2019-04-01

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-04-01.parquet
  size:    5.9 MB
  rows:    374,694
  symbols: 2,639

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
2019-04-01 04:00:00	AAPL	Stock	47.885	48.07	47.885	48.07	17804.0
2019-04-01 04:05:00	AAPL	Stock	48.0075	48.0075	47.99	47.99	2144.0
2019-04-01 04:10:00	AAPL	Stock	47.905	47.905	47.905	47.905	3808.0
2019-04-01 04:40:00	AAPL	Stock	48.025	48.025	48.025	48.025	576.0
2019-04-01 04:45:00	AAPL	Stock	48.0	48.0675	48.0	48.0	1600.0
2019-04-01 04:50:00	AAPL	Stock	47.9975	47.9975	47.9975	47.9975	1200.0
2019-04-01 04:55:00	AAPL	Stock	47.995	48.0125	47.995	48.0125	15176.0
2019-04-01 05:10:00	AAPL	Stock	48.0	48.0	48.0	48.0	3200.0
2019-04-01 05:25:00	AAPL	Stock	47.955	47.955	47.955	47.955	540.0
2019-04-01 05:30:00	AAPL	Stock	47.975	47.9775	47.975	47.9775	848.0
2019-04-01 05:35:00	AAPL	Stock	48.035	48.0375	48.0	48.0	2352.0
2019-04-01 05:40:00	AAPL	Stock	48.02	48.02	48.02	48.02	400.0
2019-04-01 05:50:00	AAPL	Stock	47.9775	47.9775	47.9775	47.9775	420.0
2019-04-01 06:15:00	AAPL	Stock	48.0	48.0	48.0	48.0	1040.0
2019-04-01 06:20:00	AAPL	Stock	47.9775	47.9775	47.955	47.955	1336.0
2019-04-01 06:35:00	AAPL	Stock	47.985	47.985	47.985	47.985	400.0
2019-04-01 06:50:00	AAPL	Stock	47.965	47.965	47.965	47.965	1520.0
2019-04-01 06:55:00	AAPL	Stock	47.9975	48.035	47.9975	48.035	12364.0
2019-04-01 07:00:00	AAPL	Stock	48.005	48.0375	47.9125	47.9125	18648.0
2019-04-01 07:05:00	AAPL	Stock	47.93	47.975	47.925	47.975	15240.0
2019-04-01 07:10:00	AAPL	Stock	47.9775	47.9775	47.95	47.9775	12020.0
2019-04-01 07:15:00	AAPL	Stock	47.9775	47.9775	47.89	47.975	9716.0
2019-04-01 07:20:00	AAPL	Stock	47.9725	47.9725	47.925	47.925	2400.0
2019-04-01 07:25:00	AAPL	Stock	47.9475	47.9475	47.9475	47.9475	800.0
2019-04-01 07:30:00	AAPL	Stock	47.925	47.9375	47.925	47.9375	9356.0
2019-04-01 07:35:00	AAPL	Stock	47.895	47.9075	47.895	47.9075	1336.0
2019-04-01 07:40:00	AAPL	Stock	47.925	47.95	47.91	47.95	9964.0
2019-04-01 07:45:00	AAPL	Stock	47.9475	47.965	47.9475	47.95	18920.0
2019-04-01 07:50:00	AAPL	Stock	47.9375	47.9375	47.925	47.925	800.0
2019-04-01 07:55:00	AAPL	Stock	47.9275	47.9375	47.925	47.9375	11836.0
2019-04-01 08:00:00	AAPL	Stock	47.95	48.0	47.8875	47.935	118928.0
2019-04-01 08:05:00	AAPL	Stock	47.9375	47.945	47.6075	47.9375	15748.0
2019-04-01 08:10:00	AAPL	Stock	47.9275	47.9275	47.9025	47.9025	31940.0
2019-04-01 08:15:00	AAPL	Stock	47.9215	47.9215	47.8975	47.905	21668.0
2019-04-01 08:20:00	AAPL	Stock	47.9025	47.92	47.8875	47.9125	14296.0
2019-04-01 08:25:00	AAPL	Stock	47.9	47.9125	47.8625	47.9	46296.0
2019-04-01 08:30:00	AAPL	Stock	47.8875	47.8875	47.84	47.8625	41788.0
2019-04-01 08:35:00	AAPL	Stock	47.8725	47.925	47.8625	47.9125	30328.0
2019-04-01 08:40:00	AAPL	Stock	47.8825	47.925	47.875	47.8775	14220.0
2019-04-01 08:45:00	AAPL	Stock	47.8875	47.9125	47.8875	47.8875	9528.0
2019-04-01 08:50:00	AAPL	Stock	47.8925	47.8925	47.8625	47.8725	21300.0
2019-04-01 08:55:00	AAPL	Stock	47.855	47.8725	47.8525	47.86	13148.0
2019-04-01 09:00:00	AAPL	Stock	47.837	47.875	47.837	47.8525	46292.0
2019-04-01 09:05:00	AAPL	Stock	47.87	47.875	47.8668	47.87	39044.0
2019-04-01 09:10:00	AAPL	Stock	47.87	47.8775	47.86	47.8625	32376.0
2019-04-01 09:15:00	AAPL	Stock	47.875	47.9175	47.875	47.9065	229224.0
2019-04-01 09:20:00	AAPL	Stock	47.9025	47.9075	47.8625	47.8925	38296.0
2019-04-01 09:25:00	AAPL	Stock	47.8975	47.9125	47.88	47.91	28516.0
2019-04-01 09:30:00	AAPL	Stock	47.91	47.92	47.6325	47.69	4018000.0
2019-04-01 09:35:00	AAPL	Stock	47.6912	47.745	47.5725	47.5875	2392700.0

> showing 50 of 374,694 rows — these rows as CSV

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