PREVIEW / stock_5min / 2019-07-25

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-07-25.parquet
  size:    5.6 MB
  rows:    355,792
  symbols: 2,552

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-25 04:00:00	AAPL	Stock	52.15	52.15	52.15	52.15	5436.0
2019-07-25 04:25:00	AAPL	Stock	52.21	52.21	52.21	52.21	468.0
2019-07-25 04:45:00	AAPL	Stock	52.1925	52.1925	52.1925	52.1925	796.0
2019-07-25 05:15:00	AAPL	Stock	52.175	52.175	52.175	52.175	400.0
2019-07-25 05:20:00	AAPL	Stock	52.175	52.175	52.1675	52.1675	3032.0
2019-07-25 05:25:00	AAPL	Stock	52.1575	52.1675	52.1575	52.1675	5092.0
2019-07-25 05:30:00	AAPL	Stock	52.165	52.1675	52.165	52.1675	5440.0
2019-07-25 06:00:00	AAPL	Stock	52.175	52.175	52.175	52.175	400.0
2019-07-25 06:25:00	AAPL	Stock	52.0775	52.0775	52.0575	52.0575	2008.0
2019-07-25 06:30:00	AAPL	Stock	52.03	52.03	52.03	52.03	800.0
2019-07-25 06:40:00	AAPL	Stock	52.07	52.0875	52.07	52.0825	2800.0
2019-07-25 06:45:00	AAPL	Stock	52.085	52.0875	52.085	52.0875	1600.0
2019-07-25 07:00:00	AAPL	Stock	52.0875	52.15	52.0875	52.15	14816.0
2019-07-25 07:10:00	AAPL	Stock	52.1325	52.1325	52.1325	52.1325	752.0
2019-07-25 07:15:00	AAPL	Stock	52.13	52.15	52.13	52.15	3064.0
2019-07-25 07:20:00	AAPL	Stock	52.145	52.145	52.1325	52.1375	5564.0
2019-07-25 07:25:00	AAPL	Stock	52.15	52.1525	52.15	52.1525	4400.0
2019-07-25 07:30:00	AAPL	Stock	52.1325	52.15	52.1325	52.1475	6272.0
2019-07-25 07:35:00	AAPL	Stock	52.145	52.15	52.13	52.13	5552.0
2019-07-25 07:40:00	AAPL	Stock	52.145	52.1475	52.145	52.1475	10444.0
2019-07-25 07:45:00	AAPL	Stock	52.15	52.25	52.15	52.25	8868.0
2019-07-25 07:50:00	AAPL	Stock	52.25	52.25	52.2	52.205	5200.0
2019-07-25 07:55:00	AAPL	Stock	52.2325	52.25	52.2325	52.24	3400.0
2019-07-25 08:00:00	AAPL	Stock	52.125	52.29	52.0375	52.2875	69932.0
2019-07-25 08:05:00	AAPL	Stock	52.2925	52.3125	52.2925	52.3125	15752.0
2019-07-25 08:10:00	AAPL	Stock	52.3125	52.3125	52.2875	52.2875	4800.0
2019-07-25 08:15:00	AAPL	Stock	52.295	52.325	52.2775	52.2775	6872.0
2019-07-25 08:25:00	AAPL	Stock	52.3075	52.32	52.285	52.2875	3516.0
2019-07-25 08:30:00	AAPL	Stock	52.3075	52.3075	52.265	52.3075	7484.0
2019-07-25 08:35:00	AAPL	Stock	52.3075	52.3325	52.3075	52.3325	35416.0
2019-07-25 08:40:00	AAPL	Stock	52.325	52.33	52.2775	52.2775	51596.0
2019-07-25 08:45:00	AAPL	Stock	52.2875	52.305	52.2775	52.28	47848.0
2019-07-25 08:50:00	AAPL	Stock	52.29	52.2925	52.25	52.2575	19960.0
2019-07-25 09:00:00	AAPL	Stock	52.27	52.27	52.13	52.135	40304.0
2019-07-25 09:05:00	AAPL	Stock	52.1325	52.155	52.06	52.1375	55772.0
2019-07-25 09:10:00	AAPL	Stock	52.165	52.18	52.1425	52.17	23508.0
2019-07-25 09:15:00	AAPL	Stock	52.1525	52.1875	52.1525	52.165	18852.0
2019-07-25 09:20:00	AAPL	Stock	52.1775	52.1875	52.1775	52.18	12000.0
2019-07-25 09:25:00	AAPL	Stock	52.18	52.18	52.1775	52.1775	4440.0
2019-07-25 09:30:00	AAPL	Stock	52.18	52.31	52.0575	52.1458	2899668.0
2019-07-25 09:35:00	AAPL	Stock	52.1445	52.16	52.069	52.09	1000932.0
2019-07-25 09:40:00	AAPL	Stock	52.0875	52.1	51.9525	51.9715	1346824.0
2019-07-25 09:45:00	AAPL	Stock	51.97	52.0325	51.9325	52.0028	1021920.0
2019-07-25 09:50:00	AAPL	Stock	52.0025	52.0375	51.97	52.0075	931792.0
2019-07-25 09:55:00	AAPL	Stock	52.0075	52.09	51.975	52.0825	833364.0
2019-07-25 10:00:00	AAPL	Stock	52.0875	52.16	52.04	52.155	979108.0
2019-07-25 10:05:00	AAPL	Stock	52.155	52.1675	52.0925	52.101	736944.0
2019-07-25 10:10:00	AAPL	Stock	52.1075	52.1375	52.0525	52.07	479492.0
2019-07-25 10:15:00	AAPL	Stock	52.0682	52.145	52.055	52.115	394252.0
2019-07-25 10:20:00	AAPL	Stock	52.1125	52.135	52.0575	52.0638	428564.0

> showing 50 of 355,792 rows — these rows as CSV

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