PREVIEW / stock_5min / 2019-04-04

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-04-04.parquet
  size:    5.6 MB
  rows:    354,679
  symbols: 2,635

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-04 04:00:00	AAPL	Stock	48.91	48.9275	48.91	48.91	10076.0
2019-04-04 04:05:00	AAPL	Stock	48.925	48.925	48.925	48.925	400.0
2019-04-04 04:15:00	AAPL	Stock	48.9175	48.9175	48.9125	48.9125	3708.0
2019-04-04 04:30:00	AAPL	Stock	48.9175	48.9175	48.9175	48.9175	648.0
2019-04-04 04:40:00	AAPL	Stock	48.9125	48.9125	48.9125	48.9125	800.0
2019-04-04 04:45:00	AAPL	Stock	48.9125	48.9125	48.905	48.905	12960.0
2019-04-04 04:55:00	AAPL	Stock	48.8925	48.8925	48.8725	48.8725	1200.0
2019-04-04 05:30:00	AAPL	Stock	48.87	48.87	48.87	48.87	3180.0
2019-04-04 05:35:00	AAPL	Stock	48.87	48.87	48.87	48.87	996.0
2019-04-04 05:45:00	AAPL	Stock	48.87	48.875	48.87	48.87	1584.0
2019-04-04 05:50:00	AAPL	Stock	48.9	48.9	48.9	48.9	400.0
2019-04-04 06:00:00	AAPL	Stock	48.9	48.9	48.9	48.9	4000.0
2019-04-04 06:15:00	AAPL	Stock	48.875	48.9475	48.875	48.9475	2792.0
2019-04-04 06:35:00	AAPL	Stock	48.885	48.885	48.885	48.885	400.0
2019-04-04 07:00:00	AAPL	Stock	48.895	48.895	48.865	48.895	5888.0
2019-04-04 07:05:00	AAPL	Stock	48.9	48.9125	48.875	48.875	5800.0
2019-04-04 07:15:00	AAPL	Stock	48.8775	48.91	48.8775	48.91	7600.0
2019-04-04 07:20:00	AAPL	Stock	48.8825	48.8825	48.8825	48.8825	600.0
2019-04-04 07:25:00	AAPL	Stock	48.9	48.9075	48.9	48.9075	1080.0
2019-04-04 07:30:00	AAPL	Stock	48.9025	48.9225	48.9	48.9	2412.0
2019-04-04 07:35:00	AAPL	Stock	48.9025	48.9025	48.875	48.875	14584.0
2019-04-04 07:40:00	AAPL	Stock	48.875	48.875	48.875	48.875	9212.0
2019-04-04 07:45:00	AAPL	Stock	48.875	48.875	48.86	48.875	11428.0
2019-04-04 07:50:00	AAPL	Stock	48.8525	48.8525	48.85	48.85	5312.0
2019-04-04 07:55:00	AAPL	Stock	48.8525	48.8525	48.8125	48.8125	18728.0
2019-04-04 08:00:00	AAPL	Stock	48.8775	48.9228	48.8125	48.825	74996.0
2019-04-04 08:05:00	AAPL	Stock	48.815	48.8325	48.8025	48.8125	14356.0
2019-04-04 08:10:00	AAPL	Stock	48.8275	48.8275	48.775	48.775	16084.0
2019-04-04 08:15:00	AAPL	Stock	48.775	48.795	48.7525	48.755	19176.0
2019-04-04 08:20:00	AAPL	Stock	48.755	48.7875	48.75	48.7875	12772.0
2019-04-04 08:25:00	AAPL	Stock	48.7675	48.8125	48.765	48.765	14616.0
2019-04-04 08:30:00	AAPL	Stock	48.7625	48.7625	48.7225	48.7375	61340.0
2019-04-04 08:35:00	AAPL	Stock	48.7375	48.75	48.725	48.7475	26600.0
2019-04-04 08:40:00	AAPL	Stock	48.75	48.775	48.75	48.7625	17564.0
2019-04-04 08:45:00	AAPL	Stock	48.76	48.76	48.705	48.705	24440.0
2019-04-04 08:50:00	AAPL	Stock	48.745	48.75	48.725	48.725	15600.0
2019-04-04 08:55:00	AAPL	Stock	48.7092	48.7375	48.7092	48.7375	1600.0
2019-04-04 09:00:00	AAPL	Stock	48.725	48.7325	48.7025	48.725	21624.0
2019-04-04 09:05:00	AAPL	Stock	48.7275	48.75	48.715	48.7175	25024.0
2019-04-04 09:10:00	AAPL	Stock	48.7425	48.775	48.69	48.7	50804.0
2019-04-04 09:15:00	AAPL	Stock	48.6875	48.6875	48.6425	48.6875	41588.0
2019-04-04 09:20:00	AAPL	Stock	48.6875	48.6875	48.65	48.685	37172.0
2019-04-04 09:25:00	AAPL	Stock	48.6725	48.6925	48.66	48.675	32124.0
2019-04-04 09:30:00	AAPL	Stock	48.6975	48.955	48.6902	48.9405	3192272.0
2019-04-04 09:35:00	AAPL	Stock	48.9372	49.0475	48.925	49.0325	1982056.0
2019-04-04 09:40:00	AAPL	Stock	49.039	49.0475	48.9188	48.9525	1252124.0
2019-04-04 09:45:00	AAPL	Stock	48.9625	49.0075	48.87	48.9425	1079352.0
2019-04-04 09:50:00	AAPL	Stock	48.945	49.005	48.9425	48.99	1202168.0
2019-04-04 09:55:00	AAPL	Stock	48.995	49.0475	48.945	48.9862	1187112.0
2019-04-04 10:00:00	AAPL	Stock	48.9875	49.0325	48.9725	49.015	732480.0

> showing 50 of 354,679 rows — these rows as CSV

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