PREVIEW / stock_5min / 2019-07-24

all stock 5-min files

  file:    by_date/stock_5min/2019/2019-07-24.parquet
  size:    5.7 MB
  rows:    359,952
  symbols: 2,591

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
2019-07-24 04:00:00	AAPL	Stock	51.95	51.95	51.95	51.95	400.0
2019-07-24 04:10:00	AAPL	Stock	51.8875	51.8875	51.8875	51.8875	400.0
2019-07-24 04:20:00	AAPL	Stock	51.85	51.85	51.85	51.85	400.0
2019-07-24 04:30:00	AAPL	Stock	51.85	51.85	51.85	51.85	3996.0
2019-07-24 04:45:00	AAPL	Stock	51.7475	51.755	51.7475	51.755	800.0
2019-07-24 05:00:00	AAPL	Stock	51.8225	51.8225	51.775	51.775	2000.0
2019-07-24 05:05:00	AAPL	Stock	51.77	51.8275	51.77	51.8275	932.0
2019-07-24 05:10:00	AAPL	Stock	51.885	51.885	51.8375	51.8375	7400.0
2019-07-24 05:30:00	AAPL	Stock	51.8675	51.8675	51.84	51.84	920.0
2019-07-24 05:35:00	AAPL	Stock	51.825	51.825	51.795	51.795	8768.0
2019-07-24 05:40:00	AAPL	Stock	51.785	51.785	51.77	51.77	3040.0
2019-07-24 05:45:00	AAPL	Stock	51.77	51.77	51.77	51.77	4392.0
2019-07-24 06:10:00	AAPL	Stock	51.83	51.83	51.8075	51.8075	5600.0
2019-07-24 06:30:00	AAPL	Stock	51.875	51.875	51.875	51.875	400.0
2019-07-24 06:35:00	AAPL	Stock	51.9225	51.9875	51.9225	51.9875	2004.0
2019-07-24 06:40:00	AAPL	Stock	51.925	51.925	51.925	51.925	800.0
2019-07-24 06:55:00	AAPL	Stock	51.97	51.97	51.93	51.93	1048.0
2019-07-24 07:00:00	AAPL	Stock	51.945	51.975	51.9225	51.9225	17352.0
2019-07-24 07:05:00	AAPL	Stock	51.9325	51.9375	51.9	51.9	3068.0
2019-07-24 07:10:00	AAPL	Stock	51.9375	51.9375	51.9375	51.9375	400.0
2019-07-24 07:15:00	AAPL	Stock	51.9375	51.975	51.9375	51.975	12388.0
2019-07-24 07:20:00	AAPL	Stock	51.995	52.03	51.995	52.0075	15200.0
2019-07-24 07:25:00	AAPL	Stock	52.0075	52.035	52.0075	52.035	6144.0
2019-07-24 07:30:00	AAPL	Stock	51.9875	51.9875	51.9875	51.9875	3420.0
2019-07-24 07:35:00	AAPL	Stock	52.0225	52.025	52.005	52.005	2000.0
2019-07-24 07:40:00	AAPL	Stock	52.005	52.005	52.0	52.0	800.0
2019-07-24 07:45:00	AAPL	Stock	52.0	52.0	51.975	51.975	6132.0
2019-07-24 07:50:00	AAPL	Stock	51.975	51.975	51.95	51.95	12312.0
2019-07-24 07:55:00	AAPL	Stock	51.955	51.9625	51.955	51.9625	1400.0
2019-07-24 08:00:00	AAPL	Stock	51.8925	52.03	51.8925	52.0	71236.0
2019-07-24 08:05:00	AAPL	Stock	52.0	52.0	51.9875	51.9875	2400.0
2019-07-24 08:10:00	AAPL	Stock	51.975	51.9875	51.9075	51.9075	28920.0
2019-07-24 08:15:00	AAPL	Stock	51.925	51.925	51.8975	51.91	27800.0
2019-07-24 08:20:00	AAPL	Stock	51.9125	52.0225	51.905	52.0225	67136.0
2019-07-24 08:25:00	AAPL	Stock	52.0175	52.02	51.9575	52.0	16400.0
2019-07-24 08:30:00	AAPL	Stock	51.98	52.0125	51.9625	52.0125	11344.0
2019-07-24 08:35:00	AAPL	Stock	51.9975	51.9975	51.9975	51.9975	400.0
2019-07-24 08:40:00	AAPL	Stock	52.02	52.02	51.995	52.0125	5688.0
2019-07-24 08:45:00	AAPL	Stock	52.02	52.02	51.95	51.95	9280.0
2019-07-24 08:50:00	AAPL	Stock	51.95	51.9675	51.9375	51.9375	9948.0
2019-07-24 08:55:00	AAPL	Stock	51.9375	51.9375	51.9125	51.9375	4384.0
2019-07-24 09:00:00	AAPL	Stock	51.93	51.95	51.925	51.95	11000.0
2019-07-24 09:05:00	AAPL	Stock	51.955	51.975	51.9265	51.9265	12484.0
2019-07-24 09:10:00	AAPL	Stock	51.97	51.975	51.88	51.88	41028.0
2019-07-24 09:15:00	AAPL	Stock	51.88	51.9225	51.88	51.9	10408.0
2019-07-24 09:20:00	AAPL	Stock	51.9175	51.9625	51.9015	51.9575	15988.0
2019-07-24 09:25:00	AAPL	Stock	51.9575	52.21	51.845	51.9175	129640.0
2019-07-24 09:30:00	AAPL	Stock	51.9175	52.275	51.9175	52.275	3402288.0
2019-07-24 09:35:00	AAPL	Stock	52.2725	52.2875	52.085	52.1	1508644.0
2019-07-24 09:40:00	AAPL	Stock	52.1	52.16	52.1	52.16	812788.0

> showing 50 of 359,952 rows — these rows as CSV

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