PREVIEW / stock_5min / 2019-04-23

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-04-23.parquet
  size:    5.8 MB
  rows:    365,873
  symbols: 2,632

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-23 04:10:00	AAPL	Stock	51.155	51.155	51.155	51.155	3796.0
2019-04-23 04:35:00	AAPL	Stock	51.1	51.1	51.0	51.0	12964.0
2019-04-23 04:40:00	AAPL	Stock	51.04	51.04	51.0075	51.0075	4208.0
2019-04-23 05:10:00	AAPL	Stock	51.05	51.05	51.0275	51.0275	4340.0
2019-04-23 05:30:00	AAPL	Stock	51.075	51.075	51.075	51.075	400.0
2019-04-23 05:35:00	AAPL	Stock	51.01	51.01	51.01	51.01	400.0
2019-04-23 06:15:00	AAPL	Stock	51.0525	51.0525	51.0525	51.0525	400.0
2019-04-23 06:20:00	AAPL	Stock	51.06	51.06	51.06	51.06	1656.0
2019-04-23 06:30:00	AAPL	Stock	51.0575	51.0725	51.0575	51.0725	3192.0
2019-04-23 06:35:00	AAPL	Stock	51.05	51.075	51.05	51.075	6384.0
2019-04-23 06:40:00	AAPL	Stock	51.0725	51.075	50.825	50.825	15368.0
2019-04-23 06:45:00	AAPL	Stock	50.78	50.9875	50.615	50.8775	66968.0
2019-04-23 06:50:00	AAPL	Stock	50.88	50.9375	50.88	50.905	47584.0
2019-04-23 06:55:00	AAPL	Stock	50.9075	50.92	50.9075	50.9125	20500.0
2019-04-23 07:00:00	AAPL	Stock	50.93	50.9675	50.93	50.9675	8372.0
2019-04-23 07:05:00	AAPL	Stock	50.975	50.99	50.9625	50.965	7860.0
2019-04-23 07:10:00	AAPL	Stock	50.96	50.965	50.94	50.945	15096.0
2019-04-23 07:15:00	AAPL	Stock	50.94	50.9425	50.8875	50.93	14832.0
2019-04-23 07:20:00	AAPL	Stock	50.965	50.975	50.9225	50.925	12300.0
2019-04-23 07:25:00	AAPL	Stock	50.9475	50.9625	50.9	50.9625	31772.0
2019-04-23 07:30:00	AAPL	Stock	50.935	50.9625	50.925	50.9625	17356.0
2019-04-23 07:35:00	AAPL	Stock	50.975	50.985	50.9625	50.975	10240.0
2019-04-23 07:40:00	AAPL	Stock	50.975	51.05	50.975	51.0025	24468.0
2019-04-23 07:45:00	AAPL	Stock	51.025	51.05	51.02	51.05	8400.0
2019-04-23 07:50:00	AAPL	Stock	51.05	51.1075	51.05	51.0775	19968.0
2019-04-23 07:55:00	AAPL	Stock	51.0925	51.0925	51.0925	51.0925	800.0
2019-04-23 08:00:00	AAPL	Stock	50.9175	51.2625	50.88	51.0625	92592.0
2019-04-23 08:05:00	AAPL	Stock	51.095	51.1625	51.095	51.1375	32468.0
2019-04-23 08:10:00	AAPL	Stock	51.15	51.15	51.11	51.125	22400.0
2019-04-23 08:15:00	AAPL	Stock	51.1325	51.15	51.12	51.12	9984.0
2019-04-23 08:20:00	AAPL	Stock	51.135	51.145	51.135	51.145	3520.0
2019-04-23 08:25:00	AAPL	Stock	51.1175	51.1175	51.0375	51.06	32444.0
2019-04-23 08:30:00	AAPL	Stock	51.06	51.0625	51.0475	51.0475	7560.0
2019-04-23 08:35:00	AAPL	Stock	51.0425	51.05	51.015	51.045	19092.0
2019-04-23 08:40:00	AAPL	Stock	51.0375	51.045	51.025	51.0375	14024.0
2019-04-23 08:45:00	AAPL	Stock	51.0375	51.045	51.005	51.025	46644.0
2019-04-23 08:50:00	AAPL	Stock	51.02	51.0325	50.985	51.0325	47556.0
2019-04-23 08:55:00	AAPL	Stock	51.0075	51.0175	50.9775	50.995	39092.0
2019-04-23 09:00:00	AAPL	Stock	51.0125	51.0225	50.98	50.9825	26436.0
2019-04-23 09:05:00	AAPL	Stock	50.9825	51.0125	50.97	51.0125	47392.0
2019-04-23 09:10:00	AAPL	Stock	51.0125	51.075	51.0125	51.0475	11788.0
2019-04-23 09:15:00	AAPL	Stock	51.0475	51.0875	51.0475	51.0775	29360.0
2019-04-23 09:20:00	AAPL	Stock	51.0625	51.1	51.0625	51.0725	28444.0
2019-04-23 09:25:00	AAPL	Stock	51.08	51.125	51.015	51.1	68104.0
2019-04-23 09:30:00	AAPL	Stock	51.1075	51.1875	50.975	51.12	4313184.0
2019-04-23 09:35:00	AAPL	Stock	51.1175	51.25	51.0075	51.2275	2024728.0
2019-04-23 09:40:00	AAPL	Stock	51.23	51.365	51.18	51.3475	2864764.0
2019-04-23 09:45:00	AAPL	Stock	51.3475	51.365	51.2825	51.335	1530844.0
2019-04-23 09:50:00	AAPL	Stock	51.3375	51.3475	51.2775	51.3225	1144480.0
2019-04-23 09:55:00	AAPL	Stock	51.3225	51.385	51.3225	51.348	1289892.0

> showing 50 of 365,873 rows — these rows as CSV

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