PREVIEW / stock_30min / 2019-01-08

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-01-08.parquet
  size:    1.7 MB
  rows:    84,251
  symbols: 2,696

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-01-08 04:00:00	AAPL	Stock	37.125	37.15	37.1	37.125	14228.0
2019-01-08 04:30:00	AAPL	Stock	37.1375	37.1375	37.0275	37.125	7424.0
2019-01-08 05:00:00	AAPL	Stock	37.0525	37.0525	36.9975	36.9975	3872.0
2019-01-08 05:30:00	AAPL	Stock	37.05	37.05	37.05	37.05	38000.0
2019-01-08 06:00:00	AAPL	Stock	37.0875	37.125	37.075	37.1125	17348.0
2019-01-08 06:30:00	AAPL	Stock	37.0875	37.1375	37.0875	37.125	34284.0
2019-01-08 07:00:00	AAPL	Stock	37.11	37.1875	37.11	37.1425	97944.0
2019-01-08 07:30:00	AAPL	Stock	37.135	37.175	37.0775	37.1325	148824.0
2019-01-08 08:00:00	AAPL	Stock	37.1625	37.1875	37.0675	37.12	314000.0
2019-01-08 08:30:00	AAPL	Stock	37.1	37.24	37.095	37.24	339652.0
2019-01-08 09:00:00	AAPL	Stock	37.24	37.3975	37.1075	37.3975	503856.0
2019-01-08 09:30:00	AAPL	Stock	37.335	37.5125	37.2225	37.2525	25183548.0
2019-01-08 10:00:00	AAPL	Stock	37.255	37.4325	37.13	37.246	12280184.0
2019-01-08 10:30:00	AAPL	Stock	37.2475	37.3575	37.1458	37.2225	10032044.0
2019-01-08 11:00:00	AAPL	Stock	37.2275	37.555	37.205	37.39	9785872.0
2019-01-08 11:30:00	AAPL	Stock	37.3875	37.465	37.3122	37.379	5509236.0
2019-01-08 12:00:00	AAPL	Stock	37.3802	37.68	37.3575	37.6175	9682884.0
2019-01-08 12:30:00	AAPL	Stock	37.62	37.6625	37.47	37.4975	6341960.0
2019-01-08 13:00:00	AAPL	Stock	37.5012	37.7825	37.4375	37.7675	9710748.0
2019-01-08 13:30:00	AAPL	Stock	37.768	37.86	37.6325	37.825	7845620.0
2019-01-08 14:00:00	AAPL	Stock	37.8225	37.84	37.6875	37.7395	5636920.0
2019-01-08 14:30:00	AAPL	Stock	37.7375	37.955	37.72	37.855	7099184.0
2019-01-08 15:00:00	AAPL	Stock	37.855	37.8575	37.7025	37.785	7774240.0
2019-01-08 15:30:00	AAPL	Stock	37.7875	37.82	37.64	37.6925	12804996.0
2019-01-08 16:00:00	AAPL	Stock	37.6875	37.6875	37.64	37.6575	9558524.0
2019-01-08 16:30:00	AAPL	Stock	37.6525	37.725	37.6118	37.6875	623348.0
2019-01-08 17:00:00	AAPL	Stock	37.6875	37.6875	37.645	37.6525	122156.0
2019-01-08 17:30:00	AAPL	Stock	37.6525	37.7115	37.65	37.6875	67356.0
2019-01-08 18:00:00	AAPL	Stock	37.675	37.7475	37.675	37.745	179864.0
2019-01-08 18:30:00	AAPL	Stock	37.7175	37.8	37.7125	37.77	134120.0
2019-01-08 19:00:00	AAPL	Stock	37.7575	37.7825	37.7075	37.7825	85020.0
2019-01-08 19:30:00	AAPL	Stock	37.7825	37.7875	37.7125	37.7875	133896.0
2019-01-08 04:00:00	MSFT	Stock	102.45	102.45	102.45	102.45	100.0
2019-01-08 04:30:00	MSFT	Stock	102.61	102.61	102.61	102.61	100.0
2019-01-08 05:30:00	MSFT	Stock	102.73	102.73	102.73	102.73	100.0
2019-01-08 06:00:00	MSFT	Stock	102.83	102.95	102.71	102.8	4425.0
2019-01-08 06:30:00	MSFT	Stock	102.98	103.2	102.98	103.2	1883.0
2019-01-08 07:00:00	MSFT	Stock	103.09	103.19	102.8	102.85	10133.0
2019-01-08 07:30:00	MSFT	Stock	102.92	102.95	102.65	102.71	12827.0
2019-01-08 08:00:00	MSFT	Stock	102.95	103.2	102.3	102.93	58151.0
2019-01-08 08:30:00	MSFT	Stock	102.95	103.1	102.93	103.08	26653.0
2019-01-08 09:00:00	MSFT	Stock	103.1	103.19	102.93	103.15	51257.0
2019-01-08 09:30:00	MSFT	Stock	103.09	103.97	102.89	103.063	4793646.0
2019-01-08 10:00:00	MSFT	Stock	103.07	103.39	102.45	102.54	2464794.0
2019-01-08 10:30:00	MSFT	Stock	102.54	102.71	101.8	101.99	2290062.0
2019-01-08 11:00:00	MSFT	Stock	102.0	102.51	101.92	102.14	1671538.0
2019-01-08 11:30:00	MSFT	Stock	102.14	102.28	101.713	102.24	1466943.0
2019-01-08 12:00:00	MSFT	Stock	102.24	102.68	102.09	102.52	1138017.0
2019-01-08 12:30:00	MSFT	Stock	102.515	102.727	102.15	102.385	1152346.0
2019-01-08 13:00:00	MSFT	Stock	102.38	102.66	102.165	102.56	961367.0

> showing 50 of 84,251 rows — these rows as CSV

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