PREVIEW / stock_5min / 2019-09-12

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-09-12.parquet
  size:    5.8 MB
  rows:    368,160
  symbols: 2,558

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-12 04:00:00	AAPL	Stock	56.3275	56.3275	56.175	56.175	30928.0
2019-09-12 04:05:00	AAPL	Stock	56.1475	56.15	56.125	56.125	2192.0
2019-09-12 04:15:00	AAPL	Stock	56.11	56.11	56.1	56.1	2280.0
2019-09-12 04:20:00	AAPL	Stock	56.09	56.1025	56.06	56.1025	3192.0
2019-09-12 04:25:00	AAPL	Stock	56.1375	56.1375	56.1375	56.1375	2800.0
2019-09-12 04:30:00	AAPL	Stock	56.125	56.125	56.125	56.125	400.0
2019-09-12 04:45:00	AAPL	Stock	56.105	56.105	56.105	56.105	400.0
2019-09-12 04:50:00	AAPL	Stock	56.0875	56.0875	56.0525	56.0525	3128.0
2019-09-12 04:55:00	AAPL	Stock	56.0125	56.0125	56.0	56.0	800.0
2019-09-12 05:00:00	AAPL	Stock	55.97	56.0075	55.95	56.0075	15340.0
2019-09-12 05:05:00	AAPL	Stock	55.9975	55.9975	55.9975	55.9975	2000.0
2019-09-12 05:10:00	AAPL	Stock	56.015	56.05	56.015	56.0175	1952.0
2019-09-12 05:15:00	AAPL	Stock	56.015	56.015	56.01	56.01	4736.0
2019-09-12 05:20:00	AAPL	Stock	56.0025	56.0025	56.0025	56.0025	2380.0
2019-09-12 05:35:00	AAPL	Stock	56.0175	56.0175	56.0175	56.0175	960.0
2019-09-12 05:40:00	AAPL	Stock	56.02	56.075	56.015	56.015	13280.0
2019-09-12 05:45:00	AAPL	Stock	56.015	56.015	56.015	56.015	12872.0
2019-09-12 05:55:00	AAPL	Stock	55.975	55.9775	55.975	55.975	4800.0
2019-09-12 06:00:00	AAPL	Stock	55.975	56.0	55.975	56.0	5084.0
2019-09-12 06:05:00	AAPL	Stock	56.02	56.02	56.0125	56.0125	4400.0
2019-09-12 06:15:00	AAPL	Stock	56.0475	56.0475	56.0	56.0	1592.0
2019-09-12 06:20:00	AAPL	Stock	56.0	56.0	56.0	56.0	5200.0
2019-09-12 06:25:00	AAPL	Stock	55.9775	55.9825	55.95	55.95	2396.0
2019-09-12 06:30:00	AAPL	Stock	56.0	56.0	56.0	56.0	400.0
2019-09-12 06:40:00	AAPL	Stock	55.9975	55.9975	55.9975	55.9975	1000.0
2019-09-12 06:50:00	AAPL	Stock	55.9975	55.9975	55.9975	55.9975	1032.0
2019-09-12 06:55:00	AAPL	Stock	55.985	55.99	55.985	55.99	1600.0
2019-09-12 07:00:00	AAPL	Stock	55.995	56.12	55.9875	56.1	71012.0
2019-09-12 07:05:00	AAPL	Stock	56.105	56.1875	56.085	56.1625	105776.0
2019-09-12 07:10:00	AAPL	Stock	56.175	56.18	56.125	56.125	25396.0
2019-09-12 07:15:00	AAPL	Stock	56.125	56.1375	56.1125	56.1375	18256.0
2019-09-12 07:20:00	AAPL	Stock	56.1275	56.17	56.1275	56.17	8208.0
2019-09-12 07:25:00	AAPL	Stock	56.16	56.17	56.15	56.16	4336.0
2019-09-12 07:30:00	AAPL	Stock	56.1625	56.2025	56.1625	56.2	43096.0
2019-09-12 07:35:00	AAPL	Stock	56.2125	56.2125	56.1725	56.1875	29276.0
2019-09-12 07:40:00	AAPL	Stock	56.1975	56.205	56.1675	56.1675	24756.0
2019-09-12 07:45:00	AAPL	Stock	56.1675	56.3	56.0825	56.225	157916.0
2019-09-12 07:50:00	AAPL	Stock	56.225	56.24	56.175	56.1825	26964.0
2019-09-12 07:55:00	AAPL	Stock	56.1825	56.1875	56.1375	56.1875	41888.0
2019-09-12 08:00:00	AAPL	Stock	56.12	56.2625	56.0275	56.2175	165524.0
2019-09-12 08:05:00	AAPL	Stock	56.235	56.245	56.2	56.2125	23184.0
2019-09-12 08:10:00	AAPL	Stock	56.2175	56.2225	56.13	56.1775	76068.0
2019-09-12 08:15:00	AAPL	Stock	56.1875	56.2125	56.1675	56.205	24436.0
2019-09-12 08:20:00	AAPL	Stock	56.2125	56.225	56.175	56.2	30752.0
2019-09-12 08:25:00	AAPL	Stock	56.2	56.2	56.1275	56.1625	36236.0
2019-09-12 08:30:00	AAPL	Stock	56.185	56.2	56.1825	56.1875	22172.0
2019-09-12 08:35:00	AAPL	Stock	56.19	56.225	56.1825	56.205	29432.0
2019-09-12 08:40:00	AAPL	Stock	56.22	56.2775	56.2	56.27	100848.0
2019-09-12 08:45:00	AAPL	Stock	56.2825	56.2825	56.25	56.2748	38480.0
2019-09-12 08:50:00	AAPL	Stock	56.275	56.275	56.2	56.205	48728.0

> showing 50 of 368,160 rows — these rows as CSV

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