PREVIEW / stock_5min / 2018-11-12

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-11-12.parquet
  size:    5.6 MB
  rows:    351,644
  symbols: 2,738

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
2018-11-12 04:00:00	AAPL	Stock	50.975	51.0525	50.975	51.0525	800.0
2018-11-12 04:05:00	AAPL	Stock	51.0775	51.0775	51.0775	51.0775	428.0
2018-11-12 04:20:00	AAPL	Stock	51.085	51.085	51.085	51.085	808.0
2018-11-12 04:40:00	AAPL	Stock	51.04	51.04	51.0375	51.0375	2400.0
2018-11-12 04:45:00	AAPL	Stock	51.0	51.0	51.0	51.0	400.0
2018-11-12 05:05:00	AAPL	Stock	50.995	50.995	50.995	50.995	400.0
2018-11-12 05:15:00	AAPL	Stock	50.9275	50.9275	50.9275	50.9275	800.0
2018-11-12 05:35:00	AAPL	Stock	50.9875	51.0	50.9875	50.9875	15200.0
2018-11-12 05:40:00	AAPL	Stock	50.99	51.0	50.98	51.0	2120.0
2018-11-12 05:45:00	AAPL	Stock	51.0575	51.0575	51.0575	51.0575	400.0
2018-11-12 06:05:00	AAPL	Stock	50.9625	50.9975	50.9625	50.9975	2372.0
2018-11-12 06:55:00	AAPL	Stock	50.93	50.93	50.8275	50.875	11576.0
2018-11-12 07:00:00	AAPL	Stock	50.89	50.89	50.8	50.83	52264.0
2018-11-12 07:05:00	AAPL	Stock	50.8425	50.865	50.825	50.825	16560.0
2018-11-12 07:10:00	AAPL	Stock	50.825	50.8475	50.7325	50.775	66772.0
2018-11-12 07:15:00	AAPL	Stock	50.775	50.82	50.75	50.775	10992.0
2018-11-12 07:20:00	AAPL	Stock	50.795	50.8	50.7525	50.7875	26336.0
2018-11-12 07:25:00	AAPL	Stock	50.7525	50.7525	50.7	50.705	17492.0
2018-11-12 07:30:00	AAPL	Stock	50.705	50.775	50.705	50.76	17164.0
2018-11-12 07:35:00	AAPL	Stock	50.74	50.74	50.725	50.725	1200.0
2018-11-12 07:40:00	AAPL	Stock	50.75	50.7925	50.7375	50.775	17712.0
2018-11-12 07:45:00	AAPL	Stock	50.7875	50.7875	50.75	50.775	3136.0
2018-11-12 07:50:00	AAPL	Stock	50.7725	50.7875	50.735	50.735	17660.0
2018-11-12 07:55:00	AAPL	Stock	50.7125	50.76	50.6775	50.6775	8696.0
2018-11-12 08:00:00	AAPL	Stock	50.7005	50.8675	50.1625	50.295	277176.0
2018-11-12 08:05:00	AAPL	Stock	50.2925	50.3325	50.04	50.1125	168652.0
2018-11-12 08:10:00	AAPL	Stock	50.1648	50.1648	49.9625	50.0	261668.0
2018-11-12 08:15:00	AAPL	Stock	49.9975	50.1875	49.9875	50.095	139844.0
2018-11-12 08:20:00	AAPL	Stock	50.0825	50.135	50.05	50.075	89572.0
2018-11-12 08:25:00	AAPL	Stock	50.0725	50.0725	49.8675	49.875	294348.0
2018-11-12 08:30:00	AAPL	Stock	49.8675	49.9375	49.86	49.9	229420.0
2018-11-12 08:35:00	AAPL	Stock	49.9	49.9375	49.7	49.775	376728.0
2018-11-12 08:40:00	AAPL	Stock	49.7625	49.8125	49.75	49.75	94760.0
2018-11-12 08:45:00	AAPL	Stock	49.775	49.9475	49.755	49.9	206440.0
2018-11-12 08:50:00	AAPL	Stock	49.92	49.99	49.8675	49.875	163668.0
2018-11-12 08:55:00	AAPL	Stock	49.875	49.88	49.8	49.8575	98364.0
2018-11-12 09:00:00	AAPL	Stock	49.8675	49.9825	49.8675	49.91	179080.0
2018-11-12 09:05:00	AAPL	Stock	49.935	49.975	49.875	49.8875	82076.0
2018-11-12 09:10:00	AAPL	Stock	49.885	49.885	49.75	49.82	115728.0
2018-11-12 09:15:00	AAPL	Stock	49.8225	49.9775	49.8175	49.95	80852.0
2018-11-12 09:20:00	AAPL	Stock	49.9475	49.95	49.775	49.7875	152172.0
2018-11-12 09:25:00	AAPL	Stock	49.7975	49.7975	49.7125	49.7525	318368.0
2018-11-12 09:30:00	AAPL	Stock	49.725	49.9625	49.3975	49.41	9034852.0
2018-11-12 09:35:00	AAPL	Stock	49.4075	49.4375	49.09	49.1385	6780944.0
2018-11-12 09:40:00	AAPL	Stock	49.1388	49.225	49.03	49.22	5478968.0
2018-11-12 09:45:00	AAPL	Stock	49.2175	49.2525	49.1385	49.2025	3644656.0
2018-11-12 09:50:00	AAPL	Stock	49.2005	49.22	49.1075	49.1775	2720700.0
2018-11-12 09:55:00	AAPL	Stock	49.1775	49.2975	49.155	49.1925	2806888.0
2018-11-12 10:00:00	AAPL	Stock	49.185	49.22	48.925	48.9475	3710140.0
2018-11-12 10:05:00	AAPL	Stock	48.9525	49.0525	48.9075	48.978	3198888.0

> showing 50 of 351,644 rows — these rows as CSV

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