PREVIEW / stock_5min / 2020-03-09

all stock 5-min files

  file:    by_date/stock_5min/2020/2020-03-09.parquet
  size:    6.6 MB
  rows:    416,332
  symbols: 2,441

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
2020-03-09 04:00:00	AAPL	Stock	67.8325	67.975	67.075	67.1875	108568.0
2020-03-09 04:05:00	AAPL	Stock	67.1875	67.9475	67.125	67.9475	16792.0
2020-03-09 04:10:00	AAPL	Stock	67.5775	67.6	67.15	67.15	22032.0
2020-03-09 04:15:00	AAPL	Stock	67.1525	67.1525	66.875	66.875	10488.0
2020-03-09 04:20:00	AAPL	Stock	67.03	67.1	67.0	67.0	5532.0
2020-03-09 04:25:00	AAPL	Stock	66.875	66.875	66.675	66.84	4136.0
2020-03-09 04:30:00	AAPL	Stock	66.885	67.0	66.875	66.9275	20660.0
2020-03-09 04:35:00	AAPL	Stock	66.9275	67.0	66.9275	66.95	9752.0
2020-03-09 04:40:00	AAPL	Stock	66.9625	66.9625	66.625	66.625	53584.0
2020-03-09 04:45:00	AAPL	Stock	66.8625	66.97	66.7875	66.97	10696.0
2020-03-09 04:50:00	AAPL	Stock	66.9875	67.125	66.8825	67.0	15604.0
2020-03-09 04:55:00	AAPL	Stock	66.9975	67.125	66.9975	67.0	18616.0
2020-03-09 05:00:00	AAPL	Stock	67.0425	67.125	67.0425	67.125	4660.0
2020-03-09 05:05:00	AAPL	Stock	67.0925	67.35	67.0925	67.34	22100.0
2020-03-09 05:10:00	AAPL	Stock	67.34	67.45	67.25	67.35	13996.0
2020-03-09 05:15:00	AAPL	Stock	67.35	67.725	67.3	67.6425	36080.0
2020-03-09 05:20:00	AAPL	Stock	67.6375	68.0	67.61	67.9875	21252.0
2020-03-09 05:25:00	AAPL	Stock	68.0	68.025	67.75	67.875	15596.0
2020-03-09 05:30:00	AAPL	Stock	67.8	68.0	67.73	68.0	20384.0
2020-03-09 05:35:00	AAPL	Stock	68.0	68.15	67.975	67.975	16008.0
2020-03-09 05:40:00	AAPL	Stock	68.0	68.0025	68.0	68.0	5156.0
2020-03-09 05:45:00	AAPL	Stock	68.0	68.1275	68.0	68.075	27828.0
2020-03-09 05:50:00	AAPL	Stock	68.095	68.125	67.9925	68.025	29224.0
2020-03-09 05:55:00	AAPL	Stock	68.0	68.0	67.875	67.9	12568.0
2020-03-09 06:00:00	AAPL	Stock	67.875	68.1	67.8475	68.1	9256.0
2020-03-09 06:05:00	AAPL	Stock	68.0125	68.0125	67.85	67.85	4876.0
2020-03-09 06:10:00	AAPL	Stock	67.775	67.775	67.6875	67.7075	5940.0
2020-03-09 06:15:00	AAPL	Stock	67.7075	67.7075	67.6	67.6	6544.0
2020-03-09 06:20:00	AAPL	Stock	67.695	67.8425	67.695	67.82	4368.0
2020-03-09 06:25:00	AAPL	Stock	67.85	68.075	67.85	67.97	32568.0
2020-03-09 06:30:00	AAPL	Stock	67.9875	68.1225	67.9525	67.9775	17924.0
2020-03-09 06:35:00	AAPL	Stock	68.045	68.11	67.925	67.95	26908.0
2020-03-09 06:40:00	AAPL	Stock	67.95	67.955	67.8675	67.8675	6364.0
2020-03-09 06:45:00	AAPL	Stock	67.875	68.1	67.7875	68.035	100064.0
2020-03-09 06:50:00	AAPL	Stock	67.98	67.98	67.705	67.75	31796.0
2020-03-09 06:55:00	AAPL	Stock	67.69	67.7425	67.58	67.7425	10016.0
2020-03-09 07:00:00	AAPL	Stock	67.6925	68.1075	67.625	67.75	104512.0
2020-03-09 07:05:00	AAPL	Stock	67.8475	68.0	67.5625	67.6	74860.0
2020-03-09 07:10:00	AAPL	Stock	67.57	67.6	67.22	67.3	94456.0
2020-03-09 07:15:00	AAPL	Stock	67.275	67.45	67.25	67.45	38668.0
2020-03-09 07:20:00	AAPL	Stock	67.35	67.35	67.2025	67.2075	38960.0
2020-03-09 07:25:00	AAPL	Stock	67.2075	67.245	67.13	67.145	39288.0
2020-03-09 07:30:00	AAPL	Stock	67.1625	67.18	67.0925	67.1375	76904.0
2020-03-09 07:35:00	AAPL	Stock	67.1275	67.1275	67.0425	67.125	83980.0
2020-03-09 07:40:00	AAPL	Stock	67.1325	67.435	67.125	67.37	70812.0
2020-03-09 07:45:00	AAPL	Stock	67.35	67.35	67.19	67.3	33208.0
2020-03-09 07:50:00	AAPL	Stock	67.3475	67.3875	67.15	67.3425	44920.0
2020-03-09 07:55:00	AAPL	Stock	67.3	67.3725	67.2525	67.275	30164.0
2020-03-09 08:00:00	AAPL	Stock	67.875	68.05	67.05	67.2725	472752.0
2020-03-09 08:05:00	AAPL	Stock	67.2725	67.275	66.9575	66.9575	159184.0

> showing 50 of 416,332 rows — these rows as CSV

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