PREVIEW / stock_5min / 2018-07-13

all stock 5-min files

  file:    by_date/stock_5min/2018/2018-07-13.parquet
  size:    5.4 MB
  rows:    346,568
  symbols: 2,796

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-07-13 04:30:00	AAPL	Stock	47.8	47.8	47.8	47.8	660.0
2018-07-13 05:10:00	AAPL	Stock	47.875	47.875	47.875	47.875	2240.0
2018-07-13 05:30:00	AAPL	Stock	47.7575	47.7575	47.7575	47.7575	400.0
2018-07-13 05:45:00	AAPL	Stock	47.7125	47.7125	47.7125	47.7125	848.0
2018-07-13 06:40:00	AAPL	Stock	47.75	47.75	47.75	47.75	1600.0
2018-07-13 06:50:00	AAPL	Stock	47.785	47.7875	47.785	47.7875	7544.0
2018-07-13 07:00:00	AAPL	Stock	47.8	47.845	47.8	47.845	23640.0
2018-07-13 07:05:00	AAPL	Stock	47.8525	47.87	47.8525	47.87	12192.0
2018-07-13 07:15:00	AAPL	Stock	47.805	47.82	47.775	47.82	9460.0
2018-07-13 07:20:00	AAPL	Stock	47.82	47.82	47.82	47.82	800.0
2018-07-13 07:25:00	AAPL	Stock	47.775	47.775	47.75	47.75	20308.0
2018-07-13 07:30:00	AAPL	Stock	47.75	47.75	47.75	47.75	1940.0
2018-07-13 07:35:00	AAPL	Stock	47.725	47.725	47.72	47.72	1400.0
2018-07-13 07:40:00	AAPL	Stock	47.72	47.72	47.7175	47.72	12400.0
2018-07-13 07:45:00	AAPL	Stock	47.72	47.72	47.72	47.72	9200.0
2018-07-13 07:55:00	AAPL	Stock	47.775	47.7825	47.775	47.7825	6664.0
2018-07-13 08:00:00	AAPL	Stock	47.8525	47.8525	47.72	47.8125	74432.0
2018-07-13 08:05:00	AAPL	Stock	47.7575	47.7625	47.7575	47.7575	8996.0
2018-07-13 08:10:00	AAPL	Stock	47.7575	47.7575	47.7525	47.7525	916.0
2018-07-13 08:15:00	AAPL	Stock	47.7575	47.7575	47.755	47.7575	42380.0
2018-07-13 08:20:00	AAPL	Stock	47.7525	47.7575	47.745	47.7575	7560.0
2018-07-13 08:25:00	AAPL	Stock	47.75	47.75	47.7475	47.75	6800.0
2018-07-13 08:30:00	AAPL	Stock	47.735	47.75	47.735	47.74	14880.0
2018-07-13 08:35:00	AAPL	Stock	47.7375	47.7375	47.7275	47.735	23076.0
2018-07-13 08:40:00	AAPL	Stock	47.7375	47.7375	47.7	47.725	14548.0
2018-07-13 08:45:00	AAPL	Stock	47.7175	47.7325	47.7175	47.7325	1600.0
2018-07-13 08:50:00	AAPL	Stock	47.7325	47.735	47.7325	47.735	968.0
2018-07-13 08:55:00	AAPL	Stock	47.7225	47.7225	47.7225	47.7225	800.0
2018-07-13 09:00:00	AAPL	Stock	47.7275	47.7275	47.7275	47.7275	1800.0
2018-07-13 09:05:00	AAPL	Stock	47.7275	47.735	47.7275	47.7275	10564.0
2018-07-13 09:10:00	AAPL	Stock	47.7275	47.7275	47.7275	47.7275	1176.0
2018-07-13 09:15:00	AAPL	Stock	47.7375	47.7375	47.7375	47.7375	1204.0
2018-07-13 09:20:00	AAPL	Stock	47.725	47.7375	47.725	47.725	1600.0
2018-07-13 09:25:00	AAPL	Stock	47.735	47.77	47.725	47.7575	29460.0
2018-07-13 09:30:00	AAPL	Stock	47.7575	47.875	47.725	47.7825	2050548.0
2018-07-13 09:35:00	AAPL	Stock	47.7925	47.8525	47.7575	47.815	1203740.0
2018-07-13 09:40:00	AAPL	Stock	47.815	47.96	47.815	47.8925	1535852.0
2018-07-13 09:45:00	AAPL	Stock	47.8925	47.9562	47.8575	47.94	1110124.0
2018-07-13 09:50:00	AAPL	Stock	47.94	47.945	47.815	47.8425	787396.0
2018-07-13 09:55:00	AAPL	Stock	47.845	47.8925	47.7925	47.8	1031404.0
2018-07-13 10:00:00	AAPL	Stock	47.7975	47.8575	47.7825	47.8475	611424.0
2018-07-13 10:05:00	AAPL	Stock	47.8502	47.9175	47.81	47.9108	872068.0
2018-07-13 10:10:00	AAPL	Stock	47.9125	47.95	47.9	47.905	666704.0
2018-07-13 10:15:00	AAPL	Stock	47.9075	47.93	47.845	47.88	638624.0
2018-07-13 10:20:00	AAPL	Stock	47.8822	47.8975	47.8325	47.89	504120.0
2018-07-13 10:25:00	AAPL	Stock	47.89	47.905	47.8725	47.885	407396.0
2018-07-13 10:30:00	AAPL	Stock	47.8875	47.9325	47.8725	47.897	580252.0
2018-07-13 10:35:00	AAPL	Stock	47.895	47.92	47.875	47.9175	377320.0
2018-07-13 10:40:00	AAPL	Stock	47.92	47.94	47.8775	47.9015	379428.0
2018-07-13 10:45:00	AAPL	Stock	47.8975	47.9045	47.85	47.8525	378112.0

> showing 50 of 346,568 rows — these rows as CSV

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