PREVIEW / stock_5min / 2017-12-22

all stock 5-min files

  file:    by_date/stock_5min/2017/2017-12-22.parquet
  size:    5.4 MB
  rows:    354,975
  symbols: 2,902

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-12-22 04:00:00	AAPL	Stock	43.795	43.795	43.7	43.7	1200.0
2017-12-22 06:20:00	AAPL	Stock	43.74	43.74	43.74	43.74	1736.0
2017-12-22 06:25:00	AAPL	Stock	43.74	43.74	43.74	43.74	1300.0
2017-12-22 06:35:00	AAPL	Stock	43.7425	43.7425	43.7425	43.7425	468.0
2017-12-22 06:40:00	AAPL	Stock	43.7425	43.7425	43.7225	43.7225	2760.0
2017-12-22 06:50:00	AAPL	Stock	43.7225	43.7225	43.7225	43.7225	1828.0
2017-12-22 07:00:00	AAPL	Stock	43.73	43.74	43.725	43.725	2876.0
2017-12-22 07:05:00	AAPL	Stock	43.7375	43.7625	43.7375	43.7625	6040.0
2017-12-22 07:10:00	AAPL	Stock	43.7525	43.7525	43.75	43.75	3600.0
2017-12-22 07:15:00	AAPL	Stock	43.75	43.75	43.75	43.75	1500.0
2017-12-22 07:25:00	AAPL	Stock	43.75	43.77	43.75	43.77	888.0
2017-12-22 07:30:00	AAPL	Stock	43.75	43.7525	43.75	43.75	5992.0
2017-12-22 07:35:00	AAPL	Stock	43.745	43.745	43.7425	43.7425	5048.0
2017-12-22 07:40:00	AAPL	Stock	43.74	43.74	43.74	43.74	14132.0
2017-12-22 07:50:00	AAPL	Stock	43.74	43.74	43.74	43.74	800.0
2017-12-22 07:55:00	AAPL	Stock	43.72	43.72	43.72	43.72	1712.0
2017-12-22 08:00:00	AAPL	Stock	43.73	43.7725	43.6675	43.695	27964.0
2017-12-22 08:05:00	AAPL	Stock	43.7025	43.7025	43.7025	43.7025	3980.0
2017-12-22 08:10:00	AAPL	Stock	43.7125	43.7125	43.69	43.695	38108.0
2017-12-22 08:15:00	AAPL	Stock	43.695	43.695	43.675	43.675	3888.0
2017-12-22 08:20:00	AAPL	Stock	43.675	43.675	43.665	43.665	3960.0
2017-12-22 08:25:00	AAPL	Stock	43.665	43.675	43.6625	43.675	5956.0
2017-12-22 08:30:00	AAPL	Stock	43.68	43.6875	43.6625	43.675	18036.0
2017-12-22 08:35:00	AAPL	Stock	43.6775	43.6775	43.675	43.675	2000.0
2017-12-22 08:40:00	AAPL	Stock	43.68	43.7	43.68	43.69	10184.0
2017-12-22 08:45:00	AAPL	Stock	43.69	43.69	43.69	43.69	1804.0
2017-12-22 08:50:00	AAPL	Stock	43.6875	43.6875	43.6725	43.675	42176.0
2017-12-22 08:55:00	AAPL	Stock	43.675	43.675	43.645	43.6625	36620.0
2017-12-22 09:00:00	AAPL	Stock	43.6875	43.6875	43.6625	43.675	8940.0
2017-12-22 09:05:00	AAPL	Stock	43.67	43.7	43.67	43.675	8716.0
2017-12-22 09:10:00	AAPL	Stock	43.675	43.675	43.675	43.675	1200.0
2017-12-22 09:15:00	AAPL	Stock	43.6875	43.7125	43.6875	43.7125	14400.0
2017-12-22 09:20:00	AAPL	Stock	43.69	43.7225	43.69	43.7125	13028.0
2017-12-22 09:25:00	AAPL	Stock	43.725	43.725	43.65	43.6775	25248.0
2017-12-22 09:30:00	AAPL	Stock	43.6775	43.856	43.625	43.81	4489860.0
2017-12-22 09:35:00	AAPL	Stock	43.81	43.8425	43.7175	43.7375	1462452.0
2017-12-22 09:40:00	AAPL	Stock	43.7375	43.7975	43.7325	43.7625	1278312.0
2017-12-22 09:45:00	AAPL	Stock	43.7675	43.815	43.7525	43.7812	949884.0
2017-12-22 09:50:00	AAPL	Stock	43.7775	43.8125	43.75	43.795	700676.0
2017-12-22 09:55:00	AAPL	Stock	43.7965	43.8212	43.765	43.8	773236.0
2017-12-22 10:00:00	AAPL	Stock	43.7988	43.8	43.735	43.7595	792964.0
2017-12-22 10:05:00	AAPL	Stock	43.7625	43.7828	43.7225	43.7625	659540.0
2017-12-22 10:10:00	AAPL	Stock	43.7575	43.77	43.715	43.7412	602244.0
2017-12-22 10:15:00	AAPL	Stock	43.74	43.7975	43.74	43.7775	634128.0
2017-12-22 10:20:00	AAPL	Stock	43.7775	43.7825	43.7125	43.78	917184.0
2017-12-22 10:25:00	AAPL	Stock	43.7775	43.7875	43.745	43.7537	474960.0
2017-12-22 10:30:00	AAPL	Stock	43.7525	43.775	43.7375	43.7525	399936.0
2017-12-22 10:35:00	AAPL	Stock	43.75	43.75	43.72	43.734	359944.0
2017-12-22 10:40:00	AAPL	Stock	43.7325	43.78	43.7325	43.7625	452916.0
2017-12-22 10:45:00	AAPL	Stock	43.7625	43.78	43.7525	43.7708	377076.0

> showing 50 of 354,975 rows — these rows as CSV

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