PREVIEW / stock_5min / 2019-07-09

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-07-09.parquet
  size:    5.5 MB
  rows:    351,186
  symbols: 2,599

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-07-09 04:00:00	AAPL	Stock	49.4	49.6	49.4	49.5	25576.0
2019-07-09 04:05:00	AAPL	Stock	49.5	49.5025	49.4175	49.4275	2800.0
2019-07-09 04:10:00	AAPL	Stock	49.495	49.5875	49.495	49.5875	6616.0
2019-07-09 04:15:00	AAPL	Stock	49.5375	49.5375	49.5375	49.5375	4000.0
2019-07-09 04:20:00	AAPL	Stock	49.52	49.52	49.5025	49.5025	2200.0
2019-07-09 04:25:00	AAPL	Stock	49.5425	49.5625	49.5275	49.5275	4456.0
2019-07-09 04:30:00	AAPL	Stock	49.575	49.575	49.575	49.575	2000.0
2019-07-09 04:35:00	AAPL	Stock	49.5275	49.5275	49.5275	49.5275	616.0
2019-07-09 04:40:00	AAPL	Stock	49.5275	49.5275	49.51	49.51	8400.0
2019-07-09 04:45:00	AAPL	Stock	49.5	49.5	49.4825	49.4825	3200.0
2019-07-09 04:50:00	AAPL	Stock	49.5	49.5325	49.4825	49.4825	2988.0
2019-07-09 04:55:00	AAPL	Stock	49.5125	49.5125	49.5125	49.5125	2000.0
2019-07-09 05:00:00	AAPL	Stock	49.555	49.575	49.555	49.575	3040.0
2019-07-09 05:05:00	AAPL	Stock	49.575	49.675	49.575	49.66	27680.0
2019-07-09 05:10:00	AAPL	Stock	49.6625	49.6625	49.625	49.625	2000.0
2019-07-09 05:20:00	AAPL	Stock	49.65	49.65	49.65	49.65	2000.0
2019-07-09 05:25:00	AAPL	Stock	49.655	49.695	49.655	49.695	6400.0
2019-07-09 05:30:00	AAPL	Stock	49.65	49.65	49.65	49.65	4600.0
2019-07-09 05:35:00	AAPL	Stock	49.65	49.7425	49.65	49.6925	5200.0
2019-07-09 05:40:00	AAPL	Stock	49.6925	49.73	49.6925	49.73	3764.0
2019-07-09 05:50:00	AAPL	Stock	49.7	49.7325	49.7	49.7325	800.0
2019-07-09 05:55:00	AAPL	Stock	49.74	49.85	49.74	49.85	5352.0
2019-07-09 06:00:00	AAPL	Stock	49.8375	49.8375	49.7775	49.7775	7048.0
2019-07-09 06:05:00	AAPL	Stock	49.78	49.785	49.78	49.785	1600.0
2019-07-09 06:10:00	AAPL	Stock	49.845	49.8475	49.845	49.845	2004.0
2019-07-09 06:15:00	AAPL	Stock	49.8325	49.8475	49.8325	49.8475	4988.0
2019-07-09 06:20:00	AAPL	Stock	49.825	49.8525	49.825	49.8525	1600.0
2019-07-09 06:25:00	AAPL	Stock	49.8	49.8025	49.7875	49.79	3600.0
2019-07-09 06:30:00	AAPL	Stock	49.7925	49.8	49.7775	49.8	7896.0
2019-07-09 06:35:00	AAPL	Stock	49.8	49.8	49.8	49.8	1600.0
2019-07-09 06:45:00	AAPL	Stock	49.8	49.84	49.8	49.84	11644.0
2019-07-09 06:50:00	AAPL	Stock	49.835	49.835	49.7625	49.7775	19880.0
2019-07-09 06:55:00	AAPL	Stock	49.7775	49.795	49.7775	49.795	3600.0
2019-07-09 07:00:00	AAPL	Stock	49.8125	49.835	49.7625	49.765	5044.0
2019-07-09 07:05:00	AAPL	Stock	49.8125	49.875	49.8125	49.875	7348.0
2019-07-09 07:10:00	AAPL	Stock	49.8775	49.915	49.8775	49.8775	15212.0
2019-07-09 07:15:00	AAPL	Stock	49.9175	49.9175	49.875	49.875	4284.0
2019-07-09 07:20:00	AAPL	Stock	49.875	49.875	49.875	49.875	832.0
2019-07-09 07:25:00	AAPL	Stock	49.8775	49.98	49.875	49.9725	11520.0
2019-07-09 07:30:00	AAPL	Stock	49.975	50.0475	49.9625	50.0475	37904.0
2019-07-09 07:35:00	AAPL	Stock	50.015	50.0525	49.9625	49.9675	29496.0
2019-07-09 07:40:00	AAPL	Stock	49.9875	50.0375	49.9875	50.0375	4920.0
2019-07-09 07:45:00	AAPL	Stock	50.02	50.0925	50.0125	50.0575	15560.0
2019-07-09 07:50:00	AAPL	Stock	50.0575	50.0975	50.0575	50.095	24252.0
2019-07-09 07:55:00	AAPL	Stock	50.1025	50.1025	50.0625	50.075	16728.0
2019-07-09 08:00:00	AAPL	Stock	49.7625	50.13	49.7625	50.1075	82480.0
2019-07-09 08:05:00	AAPL	Stock	50.125	50.125	50.055	50.0952	22720.0
2019-07-09 08:10:00	AAPL	Stock	50.0625	50.0925	50.06	50.0825	9588.0
2019-07-09 08:15:00	AAPL	Stock	50.07	50.0775	50.01	50.0675	23384.0
2019-07-09 08:20:00	AAPL	Stock	50.0625	50.0675	50.015	50.0325	15068.0

> showing 50 of 351,186 rows — these rows as CSV

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