PREVIEW / stock_1min / 2017-07-20

all stock 1-min files

  file:    by_date/stock_1min/2017/2017-07-20.parquet
  size:    13.7 MB
  rows:    996,570
  symbols: 2,469

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
2017-07-20 04:01:00	AAPL	Stock	37.7625	37.7625	37.7625	37.7625	560.0
2017-07-20 04:03:00	AAPL	Stock	37.7625	37.7625	37.7625	37.7625	400.0
2017-07-20 04:04:00	AAPL	Stock	37.7625	37.7625	37.7625	37.7625	400.0
2017-07-20 04:07:00	AAPL	Stock	37.75	37.75	37.75	37.75	400.0
2017-07-20 04:09:00	AAPL	Stock	37.7275	37.7275	37.7275	37.7275	400.0
2017-07-20 05:02:00	AAPL	Stock	37.755	37.755	37.755	37.755	800.0
2017-07-20 05:07:00	AAPL	Stock	37.75	37.75	37.75	37.75	400.0
2017-07-20 05:08:00	AAPL	Stock	37.7375	37.7375	37.7375	37.7375	400.0
2017-07-20 05:14:00	AAPL	Stock	37.6625	37.6625	37.65	37.65	1128.0
2017-07-20 06:13:00	AAPL	Stock	37.675	37.675	37.675	37.675	400.0
2017-07-20 06:27:00	AAPL	Stock	37.745	37.745	37.745	37.745	400.0
2017-07-20 06:33:00	AAPL	Stock	37.7375	37.7375	37.7375	37.7375	800.0
2017-07-20 06:46:00	AAPL	Stock	37.7375	37.7375	37.7375	37.7375	400.0
2017-07-20 07:01:00	AAPL	Stock	37.7375	37.7375	37.7375	37.7375	600.0
2017-07-20 07:23:00	AAPL	Stock	37.7275	37.7275	37.7275	37.7275	400.0
2017-07-20 07:33:00	AAPL	Stock	37.775	37.775	37.775	37.775	2560.0
2017-07-20 07:35:00	AAPL	Stock	37.7725	37.8	37.7725	37.8	19456.0
2017-07-20 07:36:00	AAPL	Stock	37.775	37.775	37.775	37.775	400.0
2017-07-20 07:37:00	AAPL	Stock	37.8	37.8	37.8	37.8	800.0
2017-07-20 07:47:00	AAPL	Stock	37.785	37.785	37.785	37.785	400.0
2017-07-20 07:48:00	AAPL	Stock	37.8475	37.8475	37.8275	37.8325	1960.0
2017-07-20 07:52:00	AAPL	Stock	37.8225	37.8225	37.8225	37.8225	400.0
2017-07-20 08:00:00	AAPL	Stock	37.795	37.8275	37.795	37.8275	4880.0
2017-07-20 08:01:00	AAPL	Stock	37.845	37.8475	37.845	37.8475	6400.0
2017-07-20 08:02:00	AAPL	Stock	37.8475	37.8475	37.845	37.845	2708.0
2017-07-20 08:03:00	AAPL	Stock	37.8325	37.855	37.8325	37.855	11912.0
2017-07-20 08:04:00	AAPL	Stock	37.8375	37.85	37.8375	37.85	1200.0
2017-07-20 08:05:00	AAPL	Stock	37.86	37.86	37.86	37.86	1736.0
2017-07-20 08:07:00	AAPL	Stock	37.85	37.85	37.85	37.85	2800.0
2017-07-20 08:08:00	AAPL	Stock	37.845	37.845	37.84	37.84	4800.0
2017-07-20 08:09:00	AAPL	Stock	37.84	37.84	37.8375	37.84	7600.0
2017-07-20 08:10:00	AAPL	Stock	37.8375	37.8375	37.835	37.835	2600.0
2017-07-20 08:12:00	AAPL	Stock	37.835	37.835	37.835	37.835	10240.0
2017-07-20 08:14:00	AAPL	Stock	37.8375	37.8375	37.8375	37.8375	1884.0
2017-07-20 08:17:00	AAPL	Stock	37.8525	37.8525	37.8525	37.8525	600.0
2017-07-20 08:18:00	AAPL	Stock	37.8625	37.8625	37.8625	37.8625	9200.0
2017-07-20 08:19:00	AAPL	Stock	37.8625	37.8625	37.8625	37.8625	400.0
2017-07-20 08:20:00	AAPL	Stock	37.855	37.875	37.855	37.875	5100.0
2017-07-20 08:21:00	AAPL	Stock	37.855	37.855	37.855	37.855	3200.0
2017-07-20 08:24:00	AAPL	Stock	37.8525	37.8525	37.8475	37.8475	6000.0
2017-07-20 08:26:00	AAPL	Stock	37.85	37.85	37.85	37.85	400.0
2017-07-20 08:30:00	AAPL	Stock	37.85	37.8625	37.8475	37.8475	12196.0
2017-07-20 08:32:00	AAPL	Stock	37.85	37.85	37.85	37.85	400.0
2017-07-20 08:34:00	AAPL	Stock	37.855	37.855	37.855	37.855	400.0
2017-07-20 08:35:00	AAPL	Stock	37.8575	37.8575	37.8575	37.8575	400.0
2017-07-20 08:36:00	AAPL	Stock	37.86	37.86	37.8275	37.8275	7600.0
2017-07-20 08:38:00	AAPL	Stock	37.8375	37.845	37.8375	37.845	816.0
2017-07-20 08:39:00	AAPL	Stock	37.83	37.83	37.83	37.83	540.0
2017-07-20 08:40:00	AAPL	Stock	37.84	37.84	37.825	37.825	6136.0
2017-07-20 08:41:00	AAPL	Stock	37.8225	37.8225	37.8225	37.8225	2400.0

> showing 50 of 996,570 rows — these rows as CSV

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