PREVIEW / stock_5min / 2019-07-02

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-07-02.parquet
  size:    5.6 MB
  rows:    357,799
  symbols: 2,610

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-02 04:15:00	AAPL	Stock	50.3075	50.3075	50.3075	50.3075	800.0
2019-07-02 04:20:00	AAPL	Stock	50.3075	50.3075	50.3075	50.3075	800.0
2019-07-02 04:25:00	AAPL	Stock	50.3075	50.3075	50.3075	50.3075	756.0
2019-07-02 04:40:00	AAPL	Stock	50.2725	50.2725	50.26	50.26	1088.0
2019-07-02 04:45:00	AAPL	Stock	50.2275	50.2275	50.22	50.22	800.0
2019-07-02 04:50:00	AAPL	Stock	50.3	50.3	50.3	50.3	760.0
2019-07-02 04:55:00	AAPL	Stock	50.205	50.205	50.205	50.205	560.0
2019-07-02 05:10:00	AAPL	Stock	50.25	50.25	50.25	50.25	1400.0
2019-07-02 05:15:00	AAPL	Stock	50.25	50.25	50.25	50.25	400.0
2019-07-02 05:25:00	AAPL	Stock	50.25	50.25	50.25	50.25	1832.0
2019-07-02 05:35:00	AAPL	Stock	50.25	50.25	50.25	50.25	2400.0
2019-07-02 05:40:00	AAPL	Stock	50.2475	50.25	50.2475	50.25	1600.0
2019-07-02 05:45:00	AAPL	Stock	50.25	50.25	50.2425	50.2425	5024.0
2019-07-02 05:50:00	AAPL	Stock	50.2175	50.2175	50.2175	50.2175	1360.0
2019-07-02 06:00:00	AAPL	Stock	50.19	50.19	50.125	50.125	2200.0
2019-07-02 06:30:00	AAPL	Stock	50.1825	50.1825	50.1825	50.1825	400.0
2019-07-02 06:45:00	AAPL	Stock	50.2	50.2	50.2	50.2	1600.0
2019-07-02 07:00:00	AAPL	Stock	50.245	50.3	50.245	50.3	6260.0
2019-07-02 07:05:00	AAPL	Stock	50.26	50.2925	50.25	50.25	20780.0
2019-07-02 07:10:00	AAPL	Stock	50.275	50.275	50.25	50.25	6400.0
2019-07-02 07:15:00	AAPL	Stock	50.25	50.25	50.2475	50.2475	16152.0
2019-07-02 07:20:00	AAPL	Stock	50.23	50.2325	50.205	50.2175	3196.0
2019-07-02 07:25:00	AAPL	Stock	50.205	50.205	50.2025	50.2025	1892.0
2019-07-02 07:30:00	AAPL	Stock	50.2025	50.2025	50.2025	50.2025	800.0
2019-07-02 07:35:00	AAPL	Stock	50.2225	50.2225	50.2225	50.2225	400.0
2019-07-02 07:40:00	AAPL	Stock	50.215	50.215	50.2025	50.2025	10800.0
2019-07-02 07:45:00	AAPL	Stock	50.225	50.225	50.21	50.21	1616.0
2019-07-02 07:50:00	AAPL	Stock	50.225	50.2325	50.225	50.2325	888.0
2019-07-02 07:55:00	AAPL	Stock	50.2475	50.25	50.2475	50.25	1840.0
2019-07-02 08:00:00	AAPL	Stock	50.25	50.31	50.2	50.245	21980.0
2019-07-02 08:05:00	AAPL	Stock	50.2125	50.2488	50.2125	50.2488	4800.0
2019-07-02 08:10:00	AAPL	Stock	50.245	50.25	50.2138	50.2138	2160.0
2019-07-02 08:15:00	AAPL	Stock	50.2275	50.2275	50.225	50.225	1380.0
2019-07-02 08:20:00	AAPL	Stock	50.2425	50.25	50.2125	50.25	6132.0
2019-07-02 08:25:00	AAPL	Stock	50.25	50.2722	50.25	50.2675	14980.0
2019-07-02 08:35:00	AAPL	Stock	50.2875	50.2975	50.2775	50.2975	4600.0
2019-07-02 08:40:00	AAPL	Stock	50.2875	50.2975	50.2875	50.2975	4400.0
2019-07-02 08:45:00	AAPL	Stock	50.295	50.295	50.27	50.27	1296.0
2019-07-02 08:50:00	AAPL	Stock	50.2875	50.2875	50.25	50.2525	12720.0
2019-07-02 08:55:00	AAPL	Stock	50.28	50.2975	50.275	50.275	10100.0
2019-07-02 09:00:00	AAPL	Stock	50.275	50.297	50.275	50.297	10820.0
2019-07-02 09:05:00	AAPL	Stock	50.275	50.29	50.275	50.2875	1796.0
2019-07-02 09:10:00	AAPL	Stock	50.2975	50.2975	50.2975	50.2975	1420.0
2019-07-02 09:15:00	AAPL	Stock	50.2875	50.3	50.28	50.2825	26312.0
2019-07-02 09:20:00	AAPL	Stock	50.2825	50.315	50.28	50.3125	32800.0
2019-07-02 09:25:00	AAPL	Stock	50.335	50.3525	50.2875	50.325	24308.0
2019-07-02 09:30:00	AAPL	Stock	50.3675	50.6175	50.34	50.53	3656320.0
2019-07-02 09:35:00	AAPL	Stock	50.536	50.6175	50.415	50.5025	1957828.0
2019-07-02 09:40:00	AAPL	Stock	50.5062	50.555	50.4175	50.4925	1196100.0
2019-07-02 09:45:00	AAPL	Stock	50.4963	50.57	50.4775	50.525	940672.0

> showing 50 of 357,799 rows — these rows as CSV

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