PREVIEW / stock_5min / 2020-07-17

all stock 5-min files

  file:    by_date/stock_5min/2020/2020-07-17.parquet
  size:    6.5 MB
  rows:    406,235
  symbols: 2,446

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
2020-07-17 04:00:00	AAPL	Stock	96.2875	96.2875	96.255	96.255	1116.0
2020-07-17 04:15:00	AAPL	Stock	96.495	96.5125	96.495	96.5125	4640.0
2020-07-17 04:30:00	AAPL	Stock	96.615	96.615	96.615	96.615	400.0
2020-07-17 05:00:00	AAPL	Stock	96.6325	96.6325	96.5025	96.5025	4400.0
2020-07-17 05:35:00	AAPL	Stock	96.75	96.75	96.75	96.75	4548.0
2020-07-17 05:45:00	AAPL	Stock	96.67	96.67	96.67	96.67	720.0
2020-07-17 05:50:00	AAPL	Stock	96.7875	96.7875	96.6825	96.6825	1600.0
2020-07-17 05:55:00	AAPL	Stock	96.6825	96.6825	96.6525	96.6525	2192.0
2020-07-17 06:00:00	AAPL	Stock	96.6525	96.6525	96.6525	96.6525	400.0
2020-07-17 06:20:00	AAPL	Stock	96.6375	96.6375	96.6375	96.6375	400.0
2020-07-17 06:35:00	AAPL	Stock	96.7	96.7	96.7	96.7	2800.0
2020-07-17 07:00:00	AAPL	Stock	96.6525	96.825	96.64	96.75	40952.0
2020-07-17 07:05:00	AAPL	Stock	96.7075	96.7075	96.675	96.675	10328.0
2020-07-17 07:15:00	AAPL	Stock	96.6675	96.7125	96.6275	96.7125	8800.0
2020-07-17 07:20:00	AAPL	Stock	96.655	96.655	96.65	96.65	3904.0
2020-07-17 07:25:00	AAPL	Stock	96.705	96.7375	96.7	96.7125	8424.0
2020-07-17 07:30:00	AAPL	Stock	96.7	96.7	96.5925	96.69	6636.0
2020-07-17 07:35:00	AAPL	Stock	96.685	96.6875	96.685	96.6875	1628.0
2020-07-17 07:40:00	AAPL	Stock	96.65	96.6575	96.625	96.65	10920.0
2020-07-17 07:45:00	AAPL	Stock	96.6475	96.65	96.6475	96.65	1144.0
2020-07-17 07:50:00	AAPL	Stock	96.7	96.7	96.6875	96.7	4968.0
2020-07-17 07:55:00	AAPL	Stock	96.7	96.8	96.7	96.7775	6868.0
2020-07-17 08:00:00	AAPL	Stock	96.75	96.875	96.6028	96.81	136540.0
2020-07-17 08:05:00	AAPL	Stock	96.8325	96.875	96.7875	96.8625	24148.0
2020-07-17 08:10:00	AAPL	Stock	96.8625	96.9675	96.84	96.9475	32784.0
2020-07-17 08:15:00	AAPL	Stock	96.9375	96.9975	96.915	96.945	34268.0
2020-07-17 08:20:00	AAPL	Stock	96.99	96.995	96.905	96.95	38956.0
2020-07-17 08:25:00	AAPL	Stock	96.9125	96.9365	96.9125	96.93	6572.0
2020-07-17 08:30:00	AAPL	Stock	96.9125	96.9625	96.875	96.95	9144.0
2020-07-17 08:35:00	AAPL	Stock	96.975	96.9868	96.9275	96.935	9932.0
2020-07-17 08:40:00	AAPL	Stock	96.9675	96.975	96.9125	96.9125	12668.0
2020-07-17 08:45:00	AAPL	Stock	96.9	96.925	96.8775	96.905	28960.0
2020-07-17 08:50:00	AAPL	Stock	96.9	96.9225	96.9	96.9225	16512.0
2020-07-17 08:55:00	AAPL	Stock	96.9225	96.9225	96.875	96.9225	9908.0
2020-07-17 09:00:00	AAPL	Stock	96.875	96.91	96.75	96.9075	47312.0
2020-07-17 09:05:00	AAPL	Stock	96.9075	96.93	96.8525	96.9	13488.0
2020-07-17 09:10:00	AAPL	Stock	96.9175	97.155	96.9175	97.155	93424.0
2020-07-17 09:15:00	AAPL	Stock	97.125	97.125	97.0375	97.0725	50768.0
2020-07-17 09:20:00	AAPL	Stock	97.0725	97.1175	96.9525	97.075	46140.0
2020-07-17 09:25:00	AAPL	Stock	97.15	97.2475	96.8325	96.8325	284132.0
2020-07-17 09:30:00	AAPL	Stock	96.9875	97.1475	96.725	96.885	6006104.0
2020-07-17 09:35:00	AAPL	Stock	96.88	96.9675	96.7375	96.79	1451212.0
2020-07-17 09:40:00	AAPL	Stock	96.7575	96.7875	96.3878	96.5325	2085320.0
2020-07-17 09:45:00	AAPL	Stock	96.515	96.6675	96.225	96.3375	1438564.0
2020-07-17 09:50:00	AAPL	Stock	96.3588	96.5805	96.3588	96.465	1554480.0
2020-07-17 09:55:00	AAPL	Stock	96.4662	96.7098	96.3975	96.5965	1182128.0
2020-07-17 10:00:00	AAPL	Stock	96.59	96.6238	96.34	96.45	1304992.0
2020-07-17 10:05:00	AAPL	Stock	96.455	96.65	96.45	96.5425	961372.0
2020-07-17 10:10:00	AAPL	Stock	96.535	96.6112	96.425	96.5325	775184.0
2020-07-17 10:15:00	AAPL	Stock	96.535	96.575	96.265	96.293	806068.0

> showing 50 of 406,235 rows — these rows as CSV

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