PREVIEW / stock_5min / 2019-10-14

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-10-14.parquet
  size:    5.3 MB
  rows:    336,445
  symbols: 2,497

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-10-14 04:00:00	AAPL	Stock	59.1625	59.1625	59.0375	59.0375	3804.0
2019-10-14 04:05:00	AAPL	Stock	59.005	59.005	59.005	59.005	400.0
2019-10-14 04:35:00	AAPL	Stock	59.1	59.1	59.1	59.1	400.0
2019-10-14 04:40:00	AAPL	Stock	59.08	59.1	59.08	59.1	4544.0
2019-10-14 05:20:00	AAPL	Stock	59.0325	59.0325	58.8425	58.895	7364.0
2019-10-14 05:25:00	AAPL	Stock	58.875	58.875	58.875	58.875	2000.0
2019-10-14 05:30:00	AAPL	Stock	58.81	58.81	58.75	58.75	25344.0
2019-10-14 05:35:00	AAPL	Stock	58.79	58.79	58.7325	58.7325	10632.0
2019-10-14 05:40:00	AAPL	Stock	58.66	58.685	58.5925	58.5925	14756.0
2019-10-14 05:45:00	AAPL	Stock	58.5	58.625	58.45	58.5	19496.0
2019-10-14 05:50:00	AAPL	Stock	58.5125	58.675	58.4875	58.625	10744.0
2019-10-14 05:55:00	AAPL	Stock	58.6025	58.625	58.5925	58.5925	12208.0
2019-10-14 06:00:00	AAPL	Stock	58.6025	58.6025	58.5875	58.5875	1600.0
2019-10-14 06:05:00	AAPL	Stock	58.54	58.5925	58.54	58.5925	2856.0
2019-10-14 06:20:00	AAPL	Stock	58.65	58.65	58.65	58.65	4000.0
2019-10-14 06:25:00	AAPL	Stock	58.625	58.625	58.625	58.625	3960.0
2019-10-14 06:30:00	AAPL	Stock	58.625	58.625	58.625	58.625	1600.0
2019-10-14 06:35:00	AAPL	Stock	58.65	58.6825	58.65	58.6825	4592.0
2019-10-14 06:40:00	AAPL	Stock	58.6575	58.6575	58.6575	58.6575	776.0
2019-10-14 06:45:00	AAPL	Stock	58.675	58.7	58.675	58.7	2540.0
2019-10-14 06:50:00	AAPL	Stock	58.7	58.7	58.7	58.7	3444.0
2019-10-14 06:55:00	AAPL	Stock	58.725	58.75	58.725	58.75	6716.0
2019-10-14 07:00:00	AAPL	Stock	58.68	58.7875	58.68	58.7575	69124.0
2019-10-14 07:05:00	AAPL	Stock	58.7625	58.7875	58.75	58.7875	28376.0
2019-10-14 07:10:00	AAPL	Stock	58.7875	58.8425	58.7825	58.8425	9932.0
2019-10-14 07:15:00	AAPL	Stock	58.85	58.85	58.825	58.825	8052.0
2019-10-14 07:20:00	AAPL	Stock	58.825	58.8625	58.7975	58.86	23364.0
2019-10-14 07:25:00	AAPL	Stock	58.865	58.925	58.86	58.89	21512.0
2019-10-14 07:30:00	AAPL	Stock	58.8875	58.9625	58.8875	58.9125	22320.0
2019-10-14 07:35:00	AAPL	Stock	58.9425	58.96	58.925	58.9475	12140.0
2019-10-14 07:40:00	AAPL	Stock	58.955	58.9875	58.95	58.955	10088.0
2019-10-14 07:45:00	AAPL	Stock	58.955	58.955	58.925	58.95	9884.0
2019-10-14 07:50:00	AAPL	Stock	58.95	58.985	58.95	58.985	4956.0
2019-10-14 07:55:00	AAPL	Stock	58.9875	59.055	58.975	59.055	38960.0
2019-10-14 08:00:00	AAPL	Stock	58.9545	59.075	58.725	59.07	129140.0
2019-10-14 08:05:00	AAPL	Stock	59.05	59.075	58.9625	58.9775	65508.0
2019-10-14 08:10:00	AAPL	Stock	58.9775	59.07	58.975	59.045	30248.0
2019-10-14 08:15:00	AAPL	Stock	59.025	59.025	59.0	59.005	14224.0
2019-10-14 08:20:00	AAPL	Stock	59.005	59.0375	58.9775	58.9875	29612.0
2019-10-14 08:25:00	AAPL	Stock	59.0	59.0025	58.97	59.0	15892.0
2019-10-14 08:30:00	AAPL	Stock	59.0	59.0025	58.9675	58.9988	9584.0
2019-10-14 08:35:00	AAPL	Stock	58.9775	59.025	58.965	59.0225	33620.0
2019-10-14 08:40:00	AAPL	Stock	58.9875	58.9875	58.955	58.955	23260.0
2019-10-14 08:45:00	AAPL	Stock	58.97	58.975	58.925	58.945	34304.0
2019-10-14 08:50:00	AAPL	Stock	58.95	58.95	58.9175	58.92	14172.0
2019-10-14 08:55:00	AAPL	Stock	58.9252	58.9625	58.9252	58.9625	4000.0
2019-10-14 09:00:00	AAPL	Stock	58.9625	58.98	58.95	58.95	10636.0
2019-10-14 09:05:00	AAPL	Stock	58.98	58.9875	58.95	58.95	8896.0
2019-10-14 09:10:00	AAPL	Stock	58.95	58.98	58.95	58.9575	13440.0
2019-10-14 09:15:00	AAPL	Stock	58.9575	58.9875	58.95	58.95	14244.0

> showing 50 of 336,445 rows — these rows as CSV

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