PREVIEW / stock_5min / 2017-03-07

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-03-07.parquet
  size:    5.3 MB
  rows:    349,777
  symbols: 3,074

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-03-07 05:35:00	AAPL	Stock	34.7625	34.7625	34.7625	34.7625	2156.0
2017-03-07 06:05:00	AAPL	Stock	34.765	34.765	34.765	34.765	432.0
2017-03-07 07:00:00	AAPL	Stock	34.775	34.775	34.7675	34.775	22200.0
2017-03-07 07:05:00	AAPL	Stock	34.775	34.775	34.775	34.775	800.0
2017-03-07 07:15:00	AAPL	Stock	34.78	34.78	34.7775	34.7775	11028.0
2017-03-07 07:20:00	AAPL	Stock	34.78	34.78	34.765	34.765	10964.0
2017-03-07 07:25:00	AAPL	Stock	34.78	34.78	34.78	34.78	400.0
2017-03-07 07:30:00	AAPL	Stock	34.78	34.78	34.78	34.78	4800.0
2017-03-07 07:35:00	AAPL	Stock	34.78	34.78	34.78	34.78	6000.0
2017-03-07 08:00:00	AAPL	Stock	34.8	34.8	34.775	34.7875	13264.0
2017-03-07 08:10:00	AAPL	Stock	34.7825	34.7825	34.78	34.78	7368.0
2017-03-07 08:15:00	AAPL	Stock	34.78	34.7875	34.78	34.7875	4800.0
2017-03-07 08:20:00	AAPL	Stock	34.78	34.78	34.78	34.78	3996.0
2017-03-07 08:25:00	AAPL	Stock	34.775	34.775	34.7525	34.775	20056.0
2017-03-07 08:30:00	AAPL	Stock	34.775	34.775	34.775	34.775	8060.0
2017-03-07 08:35:00	AAPL	Stock	34.775	34.775	34.775	34.775	4912.0
2017-03-07 08:40:00	AAPL	Stock	34.775	34.775	34.77	34.77	1172.0
2017-03-07 08:45:00	AAPL	Stock	34.765	34.77	34.765	34.77	3060.0
2017-03-07 08:50:00	AAPL	Stock	34.7725	34.775	34.7725	34.775	12800.0
2017-03-07 08:55:00	AAPL	Stock	34.7775	34.785	34.7775	34.78	20820.0
2017-03-07 09:00:00	AAPL	Stock	34.78	34.78	34.78	34.78	10220.0
2017-03-07 09:05:00	AAPL	Stock	34.795	34.795	34.765	34.775	12972.0
2017-03-07 09:10:00	AAPL	Stock	34.775	34.7975	34.775	34.795	9600.0
2017-03-07 09:15:00	AAPL	Stock	34.7875	34.7875	34.7775	34.7775	5800.0
2017-03-07 09:20:00	AAPL	Stock	34.7775	34.79	34.7775	34.7825	6196.0
2017-03-07 09:25:00	AAPL	Stock	34.79	34.79	34.7525	34.7775	43192.0
2017-03-07 09:30:00	AAPL	Stock	34.765	34.8775	34.7575	34.8598	3080568.0
2017-03-07 09:35:00	AAPL	Stock	34.8575	34.86	34.7125	34.7425	1904272.0
2017-03-07 09:40:00	AAPL	Stock	34.7425	34.75	34.6975	34.7035	1681544.0
2017-03-07 09:45:00	AAPL	Stock	34.705	34.79	34.705	34.7675	1284596.0
2017-03-07 09:50:00	AAPL	Stock	34.7675	34.7688	34.7375	34.7575	1016180.0
2017-03-07 09:55:00	AAPL	Stock	34.76	34.78	34.755	34.7725	1073688.0
2017-03-07 10:00:00	AAPL	Stock	34.771	34.8125	34.76	34.7988	1035100.0
2017-03-07 10:05:00	AAPL	Stock	34.7975	34.8475	34.7925	34.8345	924656.0
2017-03-07 10:10:00	AAPL	Stock	34.8345	34.8475	34.81	34.8325	961352.0
2017-03-07 10:15:00	AAPL	Stock	34.8325	34.8825	34.8325	34.8725	936848.0
2017-03-07 10:20:00	AAPL	Stock	34.875	34.9725	34.8675	34.965	1804784.0
2017-03-07 10:25:00	AAPL	Stock	34.9665	34.9788	34.9475	34.955	1313764.0
2017-03-07 10:30:00	AAPL	Stock	34.9575	34.995	34.9528	34.9725	1656780.0
2017-03-07 10:35:00	AAPL	Stock	34.97	34.9875	34.9625	34.97	600316.0
2017-03-07 10:40:00	AAPL	Stock	34.9712	34.985	34.9588	34.9625	928812.0
2017-03-07 10:45:00	AAPL	Stock	34.9625	34.9675	34.93	34.965	1227028.0
2017-03-07 10:50:00	AAPL	Stock	34.9625	34.9725	34.9375	34.9425	661344.0
2017-03-07 10:55:00	AAPL	Stock	34.9412	34.9522	34.9275	34.935	603176.0
2017-03-07 11:00:00	AAPL	Stock	34.935	34.9375	34.89	34.91	902964.0
2017-03-07 11:05:00	AAPL	Stock	34.9088	34.91	34.8775	34.904	707868.0
2017-03-07 11:10:00	AAPL	Stock	34.9075	34.925	34.8975	34.9182	582660.0
2017-03-07 11:15:00	AAPL	Stock	34.9185	34.94	34.9125	34.932	596004.0
2017-03-07 11:20:00	AAPL	Stock	34.93	34.93	34.8975	34.9075	436836.0
2017-03-07 11:25:00	AAPL	Stock	34.908	34.9165	34.9025	34.91	736856.0

> showing 50 of 349,777 rows — these rows as CSV

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