PREVIEW / stock_5min / 2019-09-25

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-09-25.parquet
  size:    5.6 MB
  rows:    355,490
  symbols: 2,529

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-25 04:00:00	AAPL	Stock	54.28	54.28	54.2	54.2025	3600.0
2019-09-25 04:05:00	AAPL	Stock	54.2225	54.2225	54.2225	54.2225	532.0
2019-09-25 04:10:00	AAPL	Stock	54.275	54.275	54.275	54.275	400.0
2019-09-25 04:15:00	AAPL	Stock	54.2175	54.2175	54.2175	54.2175	804.0
2019-09-25 04:30:00	AAPL	Stock	54.2125	54.225	54.2125	54.225	6000.0
2019-09-25 04:35:00	AAPL	Stock	54.275	54.275	54.275	54.275	868.0
2019-09-25 04:45:00	AAPL	Stock	54.1925	54.1925	54.175	54.175	8400.0
2019-09-25 05:05:00	AAPL	Stock	54.1375	54.1375	54.1375	54.1375	1200.0
2019-09-25 05:20:00	AAPL	Stock	54.1825	54.1825	54.1825	54.1825	400.0
2019-09-25 05:30:00	AAPL	Stock	54.085	54.085	54.075	54.075	3812.0
2019-09-25 05:50:00	AAPL	Stock	54.125	54.1875	54.125	54.15	2668.0
2019-09-25 06:10:00	AAPL	Stock	54.225	54.275	54.225	54.275	6400.0
2019-09-25 06:15:00	AAPL	Stock	54.275	54.275	54.275	54.275	1620.0
2019-09-25 06:20:00	AAPL	Stock	54.2975	54.3	54.2975	54.2975	2312.0
2019-09-25 06:25:00	AAPL	Stock	54.255	54.255	54.255	54.255	456.0
2019-09-25 06:35:00	AAPL	Stock	54.25	54.2525	54.25	54.25	3664.0
2019-09-25 06:40:00	AAPL	Stock	54.2525	54.2525	54.25	54.2525	11644.0
2019-09-25 06:45:00	AAPL	Stock	54.25	54.25	54.25	54.25	1600.0
2019-09-25 06:55:00	AAPL	Stock	54.3	54.3	54.3	54.3	800.0
2019-09-25 07:00:00	AAPL	Stock	54.2825	54.3775	54.2825	54.36	53096.0
2019-09-25 07:05:00	AAPL	Stock	54.3625	54.4125	54.3625	54.375	8560.0
2019-09-25 07:10:00	AAPL	Stock	54.34	54.34	54.25	54.25	30340.0
2019-09-25 07:15:00	AAPL	Stock	54.2875	54.2875	54.275	54.275	8800.0
2019-09-25 07:20:00	AAPL	Stock	54.275	54.275	54.26	54.26	2400.0
2019-09-25 07:30:00	AAPL	Stock	54.325	54.325	54.3225	54.325	3076.0
2019-09-25 07:35:00	AAPL	Stock	54.295	54.295	54.295	54.295	400.0
2019-09-25 07:40:00	AAPL	Stock	54.2925	54.2925	54.25	54.25	15780.0
2019-09-25 07:45:00	AAPL	Stock	54.2875	54.2875	54.2625	54.2625	23628.0
2019-09-25 07:50:00	AAPL	Stock	54.275	54.275	54.255	54.255	1460.0
2019-09-25 07:55:00	AAPL	Stock	54.3	54.325	54.3	54.325	1200.0
2019-09-25 08:00:00	AAPL	Stock	54.4125	54.4125	54.255	54.2875	58912.0
2019-09-25 08:05:00	AAPL	Stock	54.3	54.4375	54.3	54.425	23788.0
2019-09-25 08:10:00	AAPL	Stock	54.4325	54.54	54.425	54.4875	38872.0
2019-09-25 08:15:00	AAPL	Stock	54.5075	54.55	54.495	54.525	19100.0
2019-09-25 08:20:00	AAPL	Stock	54.55	54.55	54.5	54.5025	16996.0
2019-09-25 08:25:00	AAPL	Stock	54.5075	54.53	54.505	54.5275	11160.0
2019-09-25 08:30:00	AAPL	Stock	54.545	54.5875	54.5125	54.575	29236.0
2019-09-25 08:35:00	AAPL	Stock	54.5575	54.5875	54.535	54.54	14232.0
2019-09-25 08:40:00	AAPL	Stock	54.575	54.6	54.5425	54.5425	12940.0
2019-09-25 08:45:00	AAPL	Stock	54.5425	54.5825	54.54	54.57	58640.0
2019-09-25 08:50:00	AAPL	Stock	54.575	54.595	54.5525	54.595	7364.0
2019-09-25 08:55:00	AAPL	Stock	54.6	54.675	54.57	54.675	36940.0
2019-09-25 09:00:00	AAPL	Stock	54.6975	54.7125	54.6125	54.6125	91156.0
2019-09-25 09:05:00	AAPL	Stock	54.6125	54.6375	54.5975	54.605	12400.0
2019-09-25 09:10:00	AAPL	Stock	54.6075	54.6125	54.59	54.59	11596.0
2019-09-25 09:15:00	AAPL	Stock	54.5925	54.635	54.5775	54.59	25968.0
2019-09-25 09:20:00	AAPL	Stock	54.6	54.6075	54.54	54.545	32748.0
2019-09-25 09:25:00	AAPL	Stock	54.565	54.7	54.54	54.69	25628.0
2019-09-25 09:30:00	AAPL	Stock	54.6875	54.92	54.62	54.77	3761936.0
2019-09-25 09:35:00	AAPL	Stock	54.785	54.82	54.6775	54.6988	1639472.0

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

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