PREVIEW / stock_5min / 2017-04-11

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-04-11.parquet
  size:    5.4 MB
  rows:    355,715
  symbols: 3,066

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-04-11 05:45:00	AAPL	Stock	35.725	35.725	35.705	35.705	2060.0
2017-04-11 05:50:00	AAPL	Stock	35.7025	35.725	35.7025	35.725	2880.0
2017-04-11 05:55:00	AAPL	Stock	35.725	35.725	35.725	35.725	6000.0
2017-04-11 06:10:00	AAPL	Stock	35.75	35.75	35.75	35.75	1200.0
2017-04-11 06:35:00	AAPL	Stock	35.7625	35.7625	35.7625	35.7625	800.0
2017-04-11 06:40:00	AAPL	Stock	35.75	35.75	35.75	35.75	1600.0
2017-04-11 06:50:00	AAPL	Stock	35.775	35.775	35.775	35.775	800.0
2017-04-11 06:55:00	AAPL	Stock	35.775	35.775	35.7525	35.7525	848.0
2017-04-11 07:00:00	AAPL	Stock	35.775	35.775	35.775	35.775	1600.0
2017-04-11 07:05:00	AAPL	Stock	35.775	35.775	35.775	35.775	2320.0
2017-04-11 07:10:00	AAPL	Stock	35.775	35.775	35.775	35.775	2200.0
2017-04-11 07:15:00	AAPL	Stock	35.775	35.775	35.755	35.775	3200.0
2017-04-11 07:20:00	AAPL	Stock	35.775	35.775	35.775	35.775	1200.0
2017-04-11 07:30:00	AAPL	Stock	35.775	35.775	35.775	35.775	400.0
2017-04-11 07:35:00	AAPL	Stock	35.7725	35.7725	35.7725	35.7725	412.0
2017-04-11 07:40:00	AAPL	Stock	35.7725	35.775	35.7725	35.775	9952.0
2017-04-11 07:55:00	AAPL	Stock	35.775	35.775	35.775	35.775	2400.0
2017-04-11 08:00:00	AAPL	Stock	35.775	35.785	35.7575	35.78	23420.0
2017-04-11 08:05:00	AAPL	Stock	35.7875	35.81	35.7875	35.79	11488.0
2017-04-11 08:10:00	AAPL	Stock	35.81	35.81	35.7925	35.7925	800.0
2017-04-11 08:15:00	AAPL	Stock	35.78	35.78	35.78	35.78	1140.0
2017-04-11 08:20:00	AAPL	Stock	35.78	35.78	35.765	35.765	10396.0
2017-04-11 08:25:00	AAPL	Stock	35.7675	35.775	35.75	35.75	17792.0
2017-04-11 08:30:00	AAPL	Stock	35.7525	35.7525	35.7525	35.7525	1200.0
2017-04-11 08:35:00	AAPL	Stock	35.7525	35.77	35.7525	35.7525	13260.0
2017-04-11 08:40:00	AAPL	Stock	35.7525	35.7825	35.7525	35.78	5200.0
2017-04-11 08:45:00	AAPL	Stock	35.785	35.7925	35.785	35.7925	2000.0
2017-04-11 08:50:00	AAPL	Stock	35.7975	35.7975	35.7975	35.7975	19980.0
2017-04-11 08:55:00	AAPL	Stock	35.7875	35.8	35.7875	35.795	17216.0
2017-04-11 09:05:00	AAPL	Stock	35.775	35.775	35.775	35.775	3600.0
2017-04-11 09:10:00	AAPL	Stock	35.75	35.7875	35.75	35.7875	7460.0
2017-04-11 09:15:00	AAPL	Stock	35.7675	35.7675	35.7675	35.7675	400.0
2017-04-11 09:20:00	AAPL	Stock	35.7875	35.7875	35.7625	35.765	17008.0
2017-04-11 09:25:00	AAPL	Stock	35.75	35.7875	35.705	35.725	59784.0
2017-04-11 09:30:00	AAPL	Stock	35.735	35.8375	35.6905	35.7922	3359124.0
2017-04-11 09:35:00	AAPL	Stock	35.79	35.8175	35.655	35.6985	1825980.0
2017-04-11 09:40:00	AAPL	Stock	35.6992	35.6992	35.55	35.5585	2755448.0
2017-04-11 09:45:00	AAPL	Stock	35.5575	35.585	35.5025	35.5725	2313244.0
2017-04-11 09:50:00	AAPL	Stock	35.57	35.5725	35.5175	35.5375	1503264.0
2017-04-11 09:55:00	AAPL	Stock	35.535	35.55	35.4182	35.505	3205876.0
2017-04-11 10:00:00	AAPL	Stock	35.5062	35.5062	35.4152	35.4825	2462984.0
2017-04-11 10:05:00	AAPL	Stock	35.4825	35.51	35.4575	35.4963	1847964.0
2017-04-11 10:10:00	AAPL	Stock	35.495	35.525	35.4025	35.4048	2131624.0
2017-04-11 10:15:00	AAPL	Stock	35.4025	35.4175	35.335	35.4005	2285956.0
2017-04-11 10:20:00	AAPL	Stock	35.3978	35.4	35.2875	35.32	2071412.0
2017-04-11 10:25:00	AAPL	Stock	35.3175	35.3175	35.125	35.2358	5536024.0
2017-04-11 10:30:00	AAPL	Stock	35.2345	35.2425	35.0325	35.0325	3877792.0
2017-04-11 10:35:00	AAPL	Stock	35.0325	35.185	35.015	35.1825	3512144.0
2017-04-11 10:40:00	AAPL	Stock	35.1838	35.21	35.125	35.205	2436124.0
2017-04-11 10:45:00	AAPL	Stock	35.205	35.2175	35.1475	35.1475	1927196.0

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

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