PREVIEW / stock_30min / 2018-10-15

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-10-15.parquet
  size:    1.7 MB
  rows:    84,332
  symbols: 2,767

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-10-15 04:00:00	AAPL	Stock	55.195	55.195	54.925	54.925	11676.0
2018-10-15 04:30:00	AAPL	Stock	54.9025	54.9625	54.825	54.825	7740.0
2018-10-15 05:00:00	AAPL	Stock	55.0	55.0375	55.0	55.0375	4520.0
2018-10-15 05:30:00	AAPL	Stock	55.05	55.05	55.0	55.0	8028.0
2018-10-15 06:00:00	AAPL	Stock	55.0625	55.1	55.0025	55.0025	18560.0
2018-10-15 06:30:00	AAPL	Stock	54.98	54.9825	54.92	54.9575	30712.0
2018-10-15 07:00:00	AAPL	Stock	54.9575	55.315	54.93	55.315	195432.0
2018-10-15 07:30:00	AAPL	Stock	55.295	55.4475	55.2375	55.3375	251404.0
2018-10-15 08:00:00	AAPL	Stock	54.9325	55.4475	54.9312	55.41	309216.0
2018-10-15 08:30:00	AAPL	Stock	55.4475	55.4475	55.2025	55.28	300776.0
2018-10-15 09:00:00	AAPL	Stock	55.3	55.355	55.1525	55.2875	340956.0
2018-10-15 09:30:00	AAPL	Stock	55.29	55.4575	54.6825	54.78	14761672.0
2018-10-15 10:00:00	AAPL	Stock	54.7825	54.86	54.43	54.77	9924028.0
2018-10-15 10:30:00	AAPL	Stock	54.7625	55.0075	54.5925	54.794	7446480.0
2018-10-15 11:00:00	AAPL	Stock	54.795	55.0125	54.65	54.96	6536720.0
2018-10-15 11:30:00	AAPL	Stock	54.9625	55.0	54.4652	54.5292	6317432.0
2018-10-15 12:00:00	AAPL	Stock	54.525	54.6375	54.3175	54.6338	5452800.0
2018-10-15 12:30:00	AAPL	Stock	54.634	54.725	54.54	54.6688	3341512.0
2018-10-15 13:00:00	AAPL	Stock	54.67	54.7775	54.415	54.478	4383960.0
2018-10-15 13:30:00	AAPL	Stock	54.4775	54.8428	54.43	54.745	4350344.0
2018-10-15 14:00:00	AAPL	Stock	54.7575	54.7775	54.42	54.4425	4032636.0
2018-10-15 14:30:00	AAPL	Stock	54.445	54.8775	54.3975	54.795	5690072.0
2018-10-15 15:00:00	AAPL	Stock	54.7975	54.96	54.555	54.5675	6128208.0
2018-10-15 15:30:00	AAPL	Stock	54.565	54.6475	54.32	54.32	11247172.0
2018-10-15 16:00:00	AAPL	Stock	54.3175	54.4475	54.26	54.3325	10878904.0
2018-10-15 16:30:00	AAPL	Stock	54.305	54.34	54.2525	54.2525	129460.0
2018-10-15 17:00:00	AAPL	Stock	54.2525	54.275	54.2525	54.2575	63656.0
2018-10-15 17:30:00	AAPL	Stock	54.255	54.275	54.25	54.255	35388.0
2018-10-15 18:00:00	AAPL	Stock	54.27	54.27	54.205	54.25	84136.0
2018-10-15 18:30:00	AAPL	Stock	54.225	54.34	54.225	54.2525	46148.0
2018-10-15 19:00:00	AAPL	Stock	54.2275	54.375	54.205	54.3325	115004.0
2018-10-15 19:30:00	AAPL	Stock	54.35	54.4875	54.35	54.475	54764.0
2018-10-15 04:00:00	MSFT	Stock	108.5	108.5	108.5	108.5	1331.0
2018-10-15 04:30:00	MSFT	Stock	108.56	108.56	108.2	108.2	4202.0
2018-10-15 05:00:00	MSFT	Stock	108.5	108.69	108.5	108.69	601.0
2018-10-15 05:30:00	MSFT	Stock	108.66	108.66	108.66	108.66	101.0
2018-10-15 06:00:00	MSFT	Stock	108.7	109.02	108.7	108.98	4900.0
2018-10-15 06:30:00	MSFT	Stock	108.8	108.97	108.8	108.97	1292.0
2018-10-15 07:00:00	MSFT	Stock	108.95	109.29	108.9	109.29	23862.0
2018-10-15 07:30:00	MSFT	Stock	109.29	109.5	109.05	109.33	13798.0
2018-10-15 08:00:00	MSFT	Stock	108.935	109.43	108.85	109.15	68974.0
2018-10-15 08:30:00	MSFT	Stock	109.2	109.24	109.0	109.18	15241.0
2018-10-15 09:00:00	MSFT	Stock	109.21	109.28	108.92	109.0	20138.0
2018-10-15 09:30:00	MSFT	Stock	108.93	109.21	107.71	108.25	3573820.0
2018-10-15 10:00:00	MSFT	Stock	108.25	108.29	106.947	107.36	3426203.0
2018-10-15 10:30:00	MSFT	Stock	107.36	108.228	107.28	108.19	1724639.0
2018-10-15 11:00:00	MSFT	Stock	108.19	109.48	108.13	109.4	2413450.0
2018-10-15 11:30:00	MSFT	Stock	109.41	109.445	108.26	108.31	1557913.0
2018-10-15 12:00:00	MSFT	Stock	108.31	108.51	107.965	108.42	1460947.0
2018-10-15 12:30:00	MSFT	Stock	108.425	108.91	108.37	108.76	938458.0

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

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