PREVIEW / stock_1min / 2019-06-24

all stock 1-min files

  file:    by_date/stock_1min/2019/2019-06-24.parquet
  size:    15.7 MB
  rows:    1,108,583
  symbols: 2,195

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-24 04:00:00	AAPL	Stock	49.825	49.825	49.825	49.825	4004.0
2019-06-24 04:09:00	AAPL	Stock	49.8125	49.8125	49.8125	49.8125	7600.0
2019-06-24 04:10:00	AAPL	Stock	49.8125	49.8125	49.8125	49.8125	400.0
2019-06-24 04:12:00	AAPL	Stock	49.8025	49.8025	49.8	49.8	800.0
2019-06-24 04:14:00	AAPL	Stock	49.8	49.8	49.8	49.8	400.0
2019-06-24 04:16:00	AAPL	Stock	49.7675	49.7675	49.7675	49.7675	400.0
2019-06-24 04:19:00	AAPL	Stock	49.8125	49.8125	49.8125	49.8125	1200.0
2019-06-24 04:22:00	AAPL	Stock	49.8	49.8	49.8	49.8	1200.0
2019-06-24 04:40:00	AAPL	Stock	49.77	49.77	49.77	49.77	400.0
2019-06-24 04:44:00	AAPL	Stock	49.8125	49.8125	49.8125	49.8125	2000.0
2019-06-24 04:45:00	AAPL	Stock	49.8125	49.8125	49.8125	49.8125	4000.0
2019-06-24 04:46:00	AAPL	Stock	49.825	49.825	49.825	49.825	1516.0
2019-06-24 04:47:00	AAPL	Stock	49.8125	49.8125	49.8	49.8	5760.0
2019-06-24 04:57:00	AAPL	Stock	49.8125	49.8125	49.8125	49.8125	400.0
2019-06-24 05:08:00	AAPL	Stock	49.8	49.8	49.8	49.8	4000.0
2019-06-24 05:09:00	AAPL	Stock	49.8	49.8	49.8	49.8	656.0
2019-06-24 05:14:00	AAPL	Stock	49.79	49.79	49.79	49.79	852.0
2019-06-24 05:15:00	AAPL	Stock	49.79	49.79	49.79	49.79	1148.0
2019-06-24 05:16:00	AAPL	Stock	49.79	49.79	49.79	49.79	800.0
2019-06-24 05:21:00	AAPL	Stock	49.8	49.8	49.8	49.8	3192.0
2019-06-24 05:42:00	AAPL	Stock	49.825	49.825	49.825	49.825	400.0
2019-06-24 06:07:00	AAPL	Stock	49.825	49.825	49.825	49.825	400.0
2019-06-24 06:48:00	AAPL	Stock	49.8	49.8	49.8	49.8	432.0
2019-06-24 06:52:00	AAPL	Stock	49.7625	49.7625	49.7625	49.7625	1112.0
2019-06-24 06:54:00	AAPL	Stock	49.7625	49.7625	49.7625	49.7625	4688.0
2019-06-24 07:00:00	AAPL	Stock	49.7275	49.77	49.695	49.725	9016.0
2019-06-24 07:02:00	AAPL	Stock	49.725	49.725	49.725	49.725	1200.0
2019-06-24 07:03:00	AAPL	Stock	49.7	49.7	49.7	49.7	3500.0
2019-06-24 07:07:00	AAPL	Stock	49.6875	49.6875	49.6875	49.6875	1600.0
2019-06-24 07:08:00	AAPL	Stock	49.685	49.685	49.685	49.685	400.0
2019-06-24 07:09:00	AAPL	Stock	49.67	49.675	49.67	49.675	2400.0
2019-06-24 07:10:00	AAPL	Stock	49.695	49.695	49.695	49.695	2000.0
2019-06-24 07:11:00	AAPL	Stock	49.6875	49.6875	49.6875	49.6875	400.0
2019-06-24 07:12:00	AAPL	Stock	49.6875	49.6875	49.6875	49.6875	1240.0
2019-06-24 07:13:00	AAPL	Stock	49.675	49.69	49.65	49.65	11100.0
2019-06-24 07:14:00	AAPL	Stock	49.6525	49.6525	49.65	49.65	3000.0
2019-06-24 07:15:00	AAPL	Stock	49.6525	49.6525	49.6	49.6	10524.0
2019-06-24 07:16:00	AAPL	Stock	49.575	49.575	49.575	49.575	1200.0
2019-06-24 07:17:00	AAPL	Stock	49.5875	49.5875	49.5875	49.5875	4000.0
2019-06-24 07:18:00	AAPL	Stock	49.5875	49.5875	49.5875	49.5875	400.0
2019-06-24 07:21:00	AAPL	Stock	49.6	49.6	49.6	49.6	400.0
2019-06-24 07:22:00	AAPL	Stock	49.6	49.6	49.5875	49.6	2000.0
2019-06-24 07:23:00	AAPL	Stock	49.605	49.6125	49.6	49.6125	4400.0
2019-06-24 07:27:00	AAPL	Stock	49.6125	49.6125	49.605	49.605	2000.0
2019-06-24 07:28:00	AAPL	Stock	49.625	49.625	49.625	49.625	400.0
2019-06-24 07:33:00	AAPL	Stock	49.63	49.63	49.63	49.63	400.0
2019-06-24 07:35:00	AAPL	Stock	49.645	49.645	49.59	49.59	21008.0
2019-06-24 07:36:00	AAPL	Stock	49.5775	49.5775	49.5775	49.5775	400.0
2019-06-24 07:37:00	AAPL	Stock	49.575	49.59	49.575	49.59	5516.0
2019-06-24 07:39:00	AAPL	Stock	49.59	49.59	49.59	49.59	5072.0

> showing 50 of 1,108,583 rows — these rows as CSV

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