PREVIEW / stock_30min / 2018-08-14

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-08-14.parquet
  size:    1.7 MB
  rows:    82,983
  symbols: 2,816

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-08-14 04:00:00	AAPL	Stock	52.5025	52.5875	52.5025	52.5825	2408.0
2018-08-14 04:30:00	AAPL	Stock	52.5075	52.5075	52.5	52.5	4368.0
2018-08-14 05:00:00	AAPL	Stock	52.5375	52.5375	52.5375	52.5375	476.0
2018-08-14 05:30:00	AAPL	Stock	52.5	52.5	52.5	52.5	400.0
2018-08-14 06:00:00	AAPL	Stock	52.55	52.5625	52.5	52.5625	1736.0
2018-08-14 06:30:00	AAPL	Stock	52.585	52.6075	52.55	52.575	44532.0
2018-08-14 07:00:00	AAPL	Stock	52.555	52.56	52.525	52.56	57996.0
2018-08-14 07:30:00	AAPL	Stock	52.5275	52.5275	52.465	52.5025	32472.0
2018-08-14 08:00:00	AAPL	Stock	52.55	52.5625	52.4425	52.4575	164096.0
2018-08-14 08:30:00	AAPL	Stock	52.475	52.5125	52.4625	52.485	76680.0
2018-08-14 09:00:00	AAPL	Stock	52.4725	52.55	52.45	52.545	194212.0
2018-08-14 09:30:00	AAPL	Stock	52.5388	52.64	52.2125	52.3025	13133528.0
2018-08-14 10:00:00	AAPL	Stock	52.3075	52.375	52.065	52.35	7793860.0
2018-08-14 10:30:00	AAPL	Stock	52.3525	52.4625	52.3125	52.41	5947104.0
2018-08-14 11:00:00	AAPL	Stock	52.41	52.4125	52.2512	52.3098	5315956.0
2018-08-14 11:30:00	AAPL	Stock	52.3088	52.3925	52.26	52.32	4001936.0
2018-08-14 12:00:00	AAPL	Stock	52.3225	52.4425	52.3225	52.425	2906108.0
2018-08-14 12:30:00	AAPL	Stock	52.425	52.4375	52.275	52.31	2784088.0
2018-08-14 13:00:00	AAPL	Stock	52.3088	52.37	52.295	52.325	1962144.0
2018-08-14 13:30:00	AAPL	Stock	52.325	52.3975	52.31	52.3875	1834256.0
2018-08-14 14:00:00	AAPL	Stock	52.3925	52.42	52.34	52.4075	2341012.0
2018-08-14 14:30:00	AAPL	Stock	52.41	52.455	52.3975	52.4125	2845172.0
2018-08-14 15:00:00	AAPL	Stock	52.41	52.4425	52.3825	52.4112	2819436.0
2018-08-14 15:30:00	AAPL	Stock	52.4112	52.45	52.3825	52.44	5277472.0
2018-08-14 16:00:00	AAPL	Stock	52.415	52.4625	52.415	52.4475	5498676.0
2018-08-14 16:30:00	AAPL	Stock	52.45	52.4625	52.4375	52.46	39316.0
2018-08-14 17:00:00	AAPL	Stock	52.46	52.4925	52.4425	52.4625	42232.0
2018-08-14 17:30:00	AAPL	Stock	52.475	52.4875	52.475	52.4875	29284.0
2018-08-14 18:00:00	AAPL	Stock	52.4875	52.49	52.425	52.425	83880.0
2018-08-14 18:30:00	AAPL	Stock	52.4	52.435	52.4	52.435	22548.0
2018-08-14 19:00:00	AAPL	Stock	52.435	52.4375	52.425	52.4375	56868.0
2018-08-14 19:30:00	AAPL	Stock	52.4325	52.4625	52.4325	52.4625	56468.0
2018-08-14 04:00:00	MSFT	Stock	109.0	109.0	109.0	109.0	2050.0
2018-08-14 05:30:00	MSFT	Stock	108.98	108.99	108.97	108.97	759.0
2018-08-14 06:00:00	MSFT	Stock	109.0	109.0	108.73	109.0	1988.0
2018-08-14 06:30:00	MSFT	Stock	108.82	108.82	108.54	108.54	1308.0
2018-08-14 07:00:00	MSFT	Stock	108.78	108.78	108.76	108.76	400.0
2018-08-14 07:30:00	MSFT	Stock	108.75	108.75	108.65	108.75	615.0
2018-08-14 08:00:00	MSFT	Stock	108.8	108.8	108.65	108.72	3762.0
2018-08-14 08:30:00	MSFT	Stock	108.72	108.75	108.55	108.72	4317.0
2018-08-14 09:00:00	MSFT	Stock	108.63	108.78	108.59	108.6	3267.0
2018-08-14 09:30:00	MSFT	Stock	108.56	108.78	108.17	108.29	1954606.0
2018-08-14 10:00:00	MSFT	Stock	108.29	108.57	108.04	108.56	1001880.0
2018-08-14 10:30:00	MSFT	Stock	108.56	109.175	108.52	109.16	1249967.0
2018-08-14 11:00:00	MSFT	Stock	109.165	109.445	109.16	109.31	1231421.0
2018-08-14 11:30:00	MSFT	Stock	109.31	109.52	109.11	109.265	855999.0
2018-08-14 12:00:00	MSFT	Stock	109.27	109.47	109.27	109.43	645585.0
2018-08-14 12:30:00	MSFT	Stock	109.43	109.47	109.21	109.305	520736.0
2018-08-14 13:00:00	MSFT	Stock	109.305	109.445	109.28	109.36	641510.0
2018-08-14 13:30:00	MSFT	Stock	109.36	109.5	109.345	109.49	607998.0

> showing 50 of 82,983 rows — these rows as CSV

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