PREVIEW / stock_30min / 2019-10-23

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-10-23.parquet
  size:    1.7 MB
  rows:    83,314
  symbols: 2,499

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-10-23 04:00:00	AAPL	Stock	59.91	60.05	59.875	60.05	27180.0
2019-10-23 04:30:00	AAPL	Stock	60.05	60.0825	60.0275	60.0825	5260.0
2019-10-23 05:00:00	AAPL	Stock	60.12	60.255	60.12	60.2425	13980.0
2019-10-23 05:30:00	AAPL	Stock	60.23	60.475	60.23	60.3975	37292.0
2019-10-23 06:00:00	AAPL	Stock	60.375	60.4	60.3125	60.3125	26716.0
2019-10-23 06:30:00	AAPL	Stock	60.305	60.3575	60.175	60.235	46584.0
2019-10-23 07:00:00	AAPL	Stock	60.235	60.285	60.105	60.2	119244.0
2019-10-23 07:30:00	AAPL	Stock	60.125	60.325	60.1075	60.2775	66684.0
2019-10-23 08:00:00	AAPL	Stock	60.28	60.3725	59.8425	60.3725	251308.0
2019-10-23 08:30:00	AAPL	Stock	60.3625	60.38	60.325	60.38	193480.0
2019-10-23 09:00:00	AAPL	Stock	60.385	60.55	59.99	60.55	454628.0
2019-10-23 09:30:00	AAPL	Stock	60.525	60.795	60.3425	60.4628	16338516.0
2019-10-23 10:00:00	AAPL	Stock	60.4625	60.5475	60.305	60.47	5261796.0
2019-10-23 10:30:00	AAPL	Stock	60.48	60.705	60.3358	60.655	5438528.0
2019-10-23 11:00:00	AAPL	Stock	60.6525	60.73	60.5925	60.63	4051456.0
2019-10-23 11:30:00	AAPL	Stock	60.63	60.7175	60.5925	60.6265	3017032.0
2019-10-23 12:00:00	AAPL	Stock	60.625	60.645	60.5	60.6175	3179680.0
2019-10-23 12:30:00	AAPL	Stock	60.6175	60.6872	60.5925	60.6685	2066344.0
2019-10-23 13:00:00	AAPL	Stock	60.665	60.6775	60.525	60.6142	1989496.0
2019-10-23 13:30:00	AAPL	Stock	60.6192	60.67	60.5862	60.66	1965880.0
2019-10-23 14:00:00	AAPL	Stock	60.6625	60.6625	60.455	60.572	3530548.0
2019-10-23 14:30:00	AAPL	Stock	60.57	60.625	60.535	60.6175	2413324.0
2019-10-23 15:00:00	AAPL	Stock	60.6175	60.6625	60.56	60.625	3062156.0
2019-10-23 15:30:00	AAPL	Stock	60.625	60.81	60.615	60.785	7251264.0
2019-10-23 16:00:00	AAPL	Stock	60.795	60.805	60.5025	60.75	5088768.0
2019-10-23 16:30:00	AAPL	Stock	60.7625	60.8	60.75	60.795	198264.0
2019-10-23 17:00:00	AAPL	Stock	60.795	60.8725	60.77	60.855	52648.0
2019-10-23 17:30:00	AAPL	Stock	60.875	60.9375	60.85	60.8875	78020.0
2019-10-23 18:00:00	AAPL	Stock	60.8875	60.9875	60.885	60.9375	181656.0
2019-10-23 18:30:00	AAPL	Stock	60.975	60.985	60.9375	60.97	61840.0
2019-10-23 19:00:00	AAPL	Stock	60.975	60.98	60.95	60.965	21960.0
2019-10-23 19:30:00	AAPL	Stock	60.965	61.0625	60.9575	61.0275	103212.0
2019-10-23 04:00:00	MSFT	Stock	136.25	136.62	136.25	136.55	4134.0
2019-10-23 04:30:00	MSFT	Stock	136.6	136.6	136.6	136.6	300.0
2019-10-23 05:00:00	MSFT	Stock	136.6	136.6	136.36	136.43	4732.0
2019-10-23 05:30:00	MSFT	Stock	136.42	136.45	136.42	136.45	613.0
2019-10-23 06:00:00	MSFT	Stock	136.45	136.85	136.45	136.65	5082.0
2019-10-23 06:30:00	MSFT	Stock	136.7	136.7	136.05	136.3	7394.0
2019-10-23 07:00:00	MSFT	Stock	136.33	136.51	136.1	136.19	16697.0
2019-10-23 07:30:00	MSFT	Stock	136.19	136.43	136.11	136.36	7412.0
2019-10-23 08:00:00	MSFT	Stock	136.36	136.94	136.15	136.94	35719.0
2019-10-23 08:30:00	MSFT	Stock	136.93	136.94	136.62	136.66	22984.0
2019-10-23 09:00:00	MSFT	Stock	136.66	136.85	136.37	136.72	24707.0
2019-10-23 09:30:00	MSFT	Stock	136.7	136.985	135.81	136.4	3450876.0
2019-10-23 10:00:00	MSFT	Stock	136.4	136.469	135.61	135.955	1755155.0
2019-10-23 10:30:00	MSFT	Stock	135.955	136.24	135.72	135.94	1390997.0
2019-10-23 11:00:00	MSFT	Stock	135.94	136.366	135.92	136.3	1284975.0
2019-10-23 11:30:00	MSFT	Stock	136.3	136.38	136.02	136.045	972978.0
2019-10-23 12:00:00	MSFT	Stock	136.04	136.05	135.82	135.92	1235056.0
2019-10-23 12:30:00	MSFT	Stock	135.91	136.21	135.86	136.14	1001033.0

> showing 50 of 83,314 rows — these rows as CSV

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