PREVIEW / stock_5min / 2019-09-04

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-09-04.parquet
  size:    5.6 MB
  rows:    354,073
  symbols: 2,562

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-09-04 04:00:00	AAPL	Stock	52.225	52.295	52.1975	52.295	16836.0
2019-09-04 04:05:00	AAPL	Stock	52.275	52.3	52.25	52.25	2400.0
2019-09-04 04:10:00	AAPL	Stock	52.255	52.255	52.255	52.255	1600.0
2019-09-04 04:15:00	AAPL	Stock	52.245	52.275	52.245	52.275	2400.0
2019-09-04 04:20:00	AAPL	Stock	52.25	52.25	52.25	52.25	1200.0
2019-09-04 04:35:00	AAPL	Stock	52.1425	52.1425	52.1425	52.1425	728.0
2019-09-04 04:40:00	AAPL	Stock	52.1525	52.2125	52.1525	52.2125	2772.0
2019-09-04 04:55:00	AAPL	Stock	52.245	52.25	52.185	52.185	3220.0
2019-09-04 05:30:00	AAPL	Stock	52.1825	52.1825	52.1825	52.1825	568.0
2019-09-04 05:35:00	AAPL	Stock	52.16	52.16	52.11	52.11	1680.0
2019-09-04 05:45:00	AAPL	Stock	52.12	52.12	52.115	52.115	3588.0
2019-09-04 06:05:00	AAPL	Stock	52.0575	52.0575	52.0575	52.0575	1600.0
2019-09-04 06:30:00	AAPL	Stock	52.1175	52.1175	52.025	52.025	2744.0
2019-09-04 06:35:00	AAPL	Stock	52.005	52.005	52.005	52.005	692.0
2019-09-04 06:55:00	AAPL	Stock	52.08	52.08	52.08	52.08	800.0
2019-09-04 07:00:00	AAPL	Stock	52.1125	52.1225	52.05	52.0625	13644.0
2019-09-04 07:05:00	AAPL	Stock	52.085	52.11	52.0625	52.0625	2756.0
2019-09-04 07:15:00	AAPL	Stock	52.04	52.075	52.0375	52.075	20868.0
2019-09-04 07:20:00	AAPL	Stock	52.05	52.1	52.0425	52.1	18940.0
2019-09-04 07:25:00	AAPL	Stock	52.1	52.1125	52.055	52.0575	19308.0
2019-09-04 07:30:00	AAPL	Stock	52.0875	52.1	52.075	52.1	4800.0
2019-09-04 07:35:00	AAPL	Stock	52.0875	52.1625	52.0875	52.1625	23468.0
2019-09-04 07:40:00	AAPL	Stock	52.16	52.175	52.14	52.1425	4480.0
2019-09-04 07:45:00	AAPL	Stock	52.14	52.14	52.125	52.1375	3596.0
2019-09-04 07:50:00	AAPL	Stock	52.125	52.125	52.1125	52.125	18376.0
2019-09-04 07:55:00	AAPL	Stock	52.125	52.1375	52.1125	52.1225	10268.0
2019-09-04 08:00:00	AAPL	Stock	52.1	52.1625	52.05	52.1	101224.0
2019-09-04 08:05:00	AAPL	Stock	52.1075	52.14	52.08	52.1375	23500.0
2019-09-04 08:10:00	AAPL	Stock	52.1125	52.15	52.1125	52.15	20824.0
2019-09-04 08:15:00	AAPL	Stock	52.16	52.1675	52.1375	52.15	7144.0
2019-09-04 08:20:00	AAPL	Stock	52.1675	52.1675	52.0875	52.0975	16328.0
2019-09-04 08:25:00	AAPL	Stock	52.115	52.125	52.0875	52.09	3756.0
2019-09-04 08:30:00	AAPL	Stock	52.11	52.175	52.11	52.14	15408.0
2019-09-04 08:35:00	AAPL	Stock	52.145	52.145	52.1	52.1	3576.0
2019-09-04 08:40:00	AAPL	Stock	52.1	52.1	52.075	52.075	15588.0
2019-09-04 08:45:00	AAPL	Stock	52.1125	52.125	52.065	52.065	31948.0
2019-09-04 08:50:00	AAPL	Stock	52.0525	52.1	52.045	52.0875	18316.0
2019-09-04 08:55:00	AAPL	Stock	52.0625	52.075	52.045	52.045	14200.0
2019-09-04 09:00:00	AAPL	Stock	52.04	52.08	52.04	52.0625	5200.0
2019-09-04 09:05:00	AAPL	Stock	52.0625	52.1225	52.0625	52.0625	47660.0
2019-09-04 09:10:00	AAPL	Stock	52.0725	52.0725	52.06	52.0645	8708.0
2019-09-04 09:15:00	AAPL	Stock	52.06	52.0625	52.0075	52.025	84568.0
2019-09-04 09:20:00	AAPL	Stock	52.015	52.025	51.9625	52.0	86232.0
2019-09-04 09:25:00	AAPL	Stock	51.9975	52.0975	51.9825	52.095	52148.0
2019-09-04 09:30:00	AAPL	Stock	52.0975	52.1825	52.0	52.06	3727316.0
2019-09-04 09:35:00	AAPL	Stock	52.0725	52.1175	51.9925	52.0308	1522536.0
2019-09-04 09:40:00	AAPL	Stock	52.035	52.0625	51.945	52.0325	1567236.0
2019-09-04 09:45:00	AAPL	Stock	52.0375	52.115	51.95	51.9572	1606896.0
2019-09-04 09:50:00	AAPL	Stock	51.9542	51.98	51.8975	51.92	1083892.0
2019-09-04 09:55:00	AAPL	Stock	51.9275	51.9475	51.885	51.93	815660.0

> showing 50 of 354,073 rows — these rows as CSV

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