PREVIEW / stock_5min / 2019-06-17

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-06-17.parquet
  size:    5.6 MB
  rows:    356,506
  symbols: 2,574

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-06-17 04:00:00	AAPL	Stock	48.375	48.375	48.16	48.16	1000.0
2019-06-17 04:25:00	AAPL	Stock	48.3375	48.3375	48.2925	48.2925	1600.0
2019-06-17 04:35:00	AAPL	Stock	48.29	48.29	48.29	48.29	400.0
2019-06-17 04:50:00	AAPL	Stock	48.2625	48.2625	48.2625	48.2625	400.0
2019-06-17 05:00:00	AAPL	Stock	48.2925	48.2925	48.2925	48.2925	1600.0
2019-06-17 05:05:00	AAPL	Stock	48.25	48.25	48.25	48.25	400.0
2019-06-17 05:15:00	AAPL	Stock	48.25	48.25	48.25	48.25	400.0
2019-06-17 05:45:00	AAPL	Stock	48.25	48.25	48.25	48.25	2600.0
2019-06-17 06:10:00	AAPL	Stock	48.2	48.2	48.1875	48.1875	800.0
2019-06-17 06:15:00	AAPL	Stock	48.2475	48.2475	48.2475	48.2475	1500.0
2019-06-17 06:30:00	AAPL	Stock	48.175	48.225	48.175	48.225	2780.0
2019-06-17 06:35:00	AAPL	Stock	48.225	48.225	48.225	48.225	2052.0
2019-06-17 06:40:00	AAPL	Stock	48.225	48.225	48.225	48.225	3600.0
2019-06-17 06:45:00	AAPL	Stock	48.25	48.25	48.25	48.25	400.0
2019-06-17 06:50:00	AAPL	Stock	48.225	48.225	48.225	48.225	2600.0
2019-06-17 06:55:00	AAPL	Stock	48.225	48.25	48.225	48.225	11444.0
2019-06-17 07:00:00	AAPL	Stock	48.225	48.315	48.225	48.3075	17708.0
2019-06-17 07:05:00	AAPL	Stock	48.2825	48.2825	48.225	48.25	12588.0
2019-06-17 07:10:00	AAPL	Stock	48.2725	48.28	48.2725	48.275	1600.0
2019-06-17 07:15:00	AAPL	Stock	48.3	48.3375	48.3	48.325	3376.0
2019-06-17 07:20:00	AAPL	Stock	48.345	48.345	48.345	48.345	400.0
2019-06-17 07:25:00	AAPL	Stock	48.3375	48.3375	48.3375	48.3375	400.0
2019-06-17 07:30:00	AAPL	Stock	48.325	48.325	48.325	48.325	2000.0
2019-06-17 07:35:00	AAPL	Stock	48.3125	48.3125	48.3125	48.3125	2000.0
2019-06-17 07:40:00	AAPL	Stock	48.3	48.3	48.3	48.3	2080.0
2019-06-17 07:45:00	AAPL	Stock	48.3375	48.3375	48.3375	48.3375	6060.0
2019-06-17 07:50:00	AAPL	Stock	48.3425	48.3425	48.3075	48.3075	14344.0
2019-06-17 07:55:00	AAPL	Stock	48.375	48.38	48.375	48.38	15344.0
2019-06-17 08:00:00	AAPL	Stock	48.3125	48.3625	48.25	48.3475	33940.0
2019-06-17 08:10:00	AAPL	Stock	48.37	48.37	48.3125	48.3125	1000.0
2019-06-17 08:15:00	AAPL	Stock	48.3125	48.3125	48.3125	48.3125	5000.0
2019-06-17 08:20:00	AAPL	Stock	48.35	48.35	48.35	48.35	1600.0
2019-06-17 08:25:00	AAPL	Stock	48.3425	48.3575	48.3425	48.3575	1200.0
2019-06-17 08:30:00	AAPL	Stock	48.315	48.3175	48.2925	48.293	16144.0
2019-06-17 08:35:00	AAPL	Stock	48.36	48.36	48.295	48.345	3960.0
2019-06-17 08:40:00	AAPL	Stock	48.295	48.3075	48.295	48.3	6040.0
2019-06-17 08:45:00	AAPL	Stock	48.2925	48.3075	48.2925	48.3075	3600.0
2019-06-17 08:50:00	AAPL	Stock	48.305	48.3375	48.2925	48.2925	12800.0
2019-06-17 08:55:00	AAPL	Stock	48.3125	48.3125	48.225	48.25	25296.0
2019-06-17 09:00:00	AAPL	Stock	48.25	48.3	48.25	48.2875	14264.0
2019-06-17 09:05:00	AAPL	Stock	48.3325	48.3475	48.2875	48.2875	4000.0
2019-06-17 09:10:00	AAPL	Stock	48.32	48.32	48.32	48.32	884.0
2019-06-17 09:15:00	AAPL	Stock	48.29	48.29	48.27	48.27	7916.0
2019-06-17 09:20:00	AAPL	Stock	48.3075	48.3125	48.25	48.2675	47072.0
2019-06-17 09:25:00	AAPL	Stock	48.2675	48.2675	48.194	48.195	14424.0
2019-06-17 09:30:00	AAPL	Stock	48.225	48.3175	48.0425	48.2412	3042200.0
2019-06-17 09:35:00	AAPL	Stock	48.235	48.38	48.229	48.36	1623264.0
2019-06-17 09:40:00	AAPL	Stock	48.3562	48.53	48.3562	48.4725	1616164.0
2019-06-17 09:45:00	AAPL	Stock	48.4725	48.5725	48.4318	48.54	1272288.0
2019-06-17 09:50:00	AAPL	Stock	48.5475	48.6475	48.498	48.6308	1278424.0

> showing 50 of 356,506 rows — these rows as CSV

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