PREVIEW / stock_5min / 2019-07-05

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-07-05.parquet
  size:    5.3 MB
  rows:    339,232
  symbols: 2,553

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-05 04:00:00	AAPL	Stock	51.1025	51.1375	51.1025	51.1375	896.0
2019-07-05 04:05:00	AAPL	Stock	51.0875	51.0875	51.0775	51.0775	3508.0
2019-07-05 04:25:00	AAPL	Stock	50.98	50.98	50.98	50.98	448.0
2019-07-05 04:50:00	AAPL	Stock	50.98	50.9875	50.895	50.895	1708.0
2019-07-05 05:05:00	AAPL	Stock	50.9175	51.0	50.9175	51.0	2540.0
2019-07-05 05:55:00	AAPL	Stock	50.95	50.95	50.95	50.95	3000.0
2019-07-05 06:10:00	AAPL	Stock	50.9675	50.9675	50.9675	50.9675	400.0
2019-07-05 06:15:00	AAPL	Stock	50.97	50.97	50.9625	50.9625	3200.0
2019-07-05 06:20:00	AAPL	Stock	50.97	51.0	50.97	51.0	1400.0
2019-07-05 06:30:00	AAPL	Stock	50.9625	50.9625	50.9625	50.9625	1628.0
2019-07-05 06:55:00	AAPL	Stock	50.9625	50.9625	50.9625	50.9625	400.0
2019-07-05 07:00:00	AAPL	Stock	50.95	51.0225	50.95	51.0075	4796.0
2019-07-05 07:05:00	AAPL	Stock	51.025	51.025	51.0	51.0	2128.0
2019-07-05 07:10:00	AAPL	Stock	51.0	51.0225	51.0	51.0225	7192.0
2019-07-05 07:15:00	AAPL	Stock	51.0175	51.0225	51.0175	51.0225	4696.0
2019-07-05 07:20:00	AAPL	Stock	51.005	51.005	51.0	51.0	3592.0
2019-07-05 07:30:00	AAPL	Stock	51.01	51.0225	51.01	51.0225	4064.0
2019-07-05 07:35:00	AAPL	Stock	51.025	51.0275	51.025	51.025	2976.0
2019-07-05 07:45:00	AAPL	Stock	51.025	51.025	51.025	51.025	800.0
2019-07-05 07:50:00	AAPL	Stock	51.025	51.025	51.025	51.025	2328.0
2019-07-05 08:00:00	AAPL	Stock	51.01	51.0475	50.9775	51.02	40060.0
2019-07-05 08:05:00	AAPL	Stock	50.9875	50.9875	50.9875	50.9875	600.0
2019-07-05 08:10:00	AAPL	Stock	51.02	51.02	51.02	51.02	800.0
2019-07-05 08:15:00	AAPL	Stock	51.0	51.0125	51.0	51.0	4456.0
2019-07-05 08:20:00	AAPL	Stock	51.0125	51.0125	51.0125	51.0125	4656.0
2019-07-05 08:25:00	AAPL	Stock	51.0125	51.0225	51.0	51.0	10924.0
2019-07-05 08:30:00	AAPL	Stock	51.0	51.075	50.9675	50.9675	69000.0
2019-07-05 08:35:00	AAPL	Stock	50.9875	51.0	50.925	50.9375	52444.0
2019-07-05 08:40:00	AAPL	Stock	50.9375	50.9375	50.8125	50.8125	61108.0
2019-07-05 08:45:00	AAPL	Stock	50.8025	50.8925	50.7475	50.8925	46804.0
2019-07-05 08:50:00	AAPL	Stock	50.8825	50.8925	50.8375	50.8375	37400.0
2019-07-05 08:55:00	AAPL	Stock	50.825	50.8635	50.795	50.825	34676.0
2019-07-05 09:00:00	AAPL	Stock	50.8525	50.855	50.83	50.851	9800.0
2019-07-05 09:05:00	AAPL	Stock	50.8275	50.85	50.79	50.79	46284.0
2019-07-05 09:10:00	AAPL	Stock	50.7875	50.7875	50.7575	50.76	23156.0
2019-07-05 09:15:00	AAPL	Stock	50.7825	50.805	50.75	50.7775	18720.0
2019-07-05 09:20:00	AAPL	Stock	50.7875	50.8	50.75	50.8	39936.0
2019-07-05 09:25:00	AAPL	Stock	50.8	50.895	50.7325	50.8025	55300.0
2019-07-05 09:30:00	AAPL	Stock	50.8375	51.0825	50.725	51.0225	3637656.0
2019-07-05 09:35:00	AAPL	Stock	51.0275	51.075	50.945	51.0588	1441344.0
2019-07-05 09:40:00	AAPL	Stock	51.0575	51.0902	51.01	51.0175	927624.0
2019-07-05 09:45:00	AAPL	Stock	51.0125	51.115	50.9525	51.1025	1311952.0
2019-07-05 09:50:00	AAPL	Stock	51.1025	51.1075	51.069	51.069	676264.0
2019-07-05 09:55:00	AAPL	Stock	51.0675	51.1025	50.965	50.9875	1133524.0
2019-07-05 10:00:00	AAPL	Stock	50.99	51.0375	50.945	51.0188	1004260.0
2019-07-05 10:05:00	AAPL	Stock	51.0175	51.1	51.0075	51.0875	795748.0
2019-07-05 10:10:00	AAPL	Stock	51.0875	51.105	51.06	51.08	857292.0
2019-07-05 10:15:00	AAPL	Stock	51.0725	51.115	51.0015	51.05	811012.0
2019-07-05 10:20:00	AAPL	Stock	51.0525	51.0625	50.955	50.99	731396.0
2019-07-05 10:25:00	AAPL	Stock	50.9875	51.0	50.925	50.9525	792612.0

> showing 50 of 339,232 rows — these rows as CSV

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