PREVIEW / stock_30min / 2019-04-02

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-04-02.parquet
  size:    1.7 MB
  rows:    85,030
  symbols: 2,640

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-04-02 04:30:00	AAPL	Stock	47.7025	47.7025	47.64	47.6425	3400.0
2019-04-02 05:30:00	AAPL	Stock	47.6975	47.6975	47.6975	47.6975	4000.0
2019-04-02 06:00:00	AAPL	Stock	47.7025	47.7025	47.67	47.7025	8384.0
2019-04-02 06:30:00	AAPL	Stock	47.7025	47.705	47.7	47.7	2520.0
2019-04-02 07:00:00	AAPL	Stock	47.7375	47.79	47.73	47.75	20484.0
2019-04-02 07:30:00	AAPL	Stock	47.745	47.785	47.7375	47.7525	10464.0
2019-04-02 08:00:00	AAPL	Stock	47.7375	47.9275	47.7025	47.75	95664.0
2019-04-02 08:30:00	AAPL	Stock	47.75	47.77	47.7	47.725	41568.0
2019-04-02 09:00:00	AAPL	Stock	47.7125	47.765	47.7	47.765	80516.0
2019-04-02 09:30:00	AAPL	Stock	47.7725	48.27	47.7625	47.925	15041416.0
2019-04-02 10:00:00	AAPL	Stock	47.9225	48.2475	47.8825	48.205	6948852.0
2019-04-02 10:30:00	AAPL	Stock	48.205	48.2075	48.1125	48.1925	4608204.0
2019-04-02 11:00:00	AAPL	Stock	48.1925	48.2125	48.0275	48.1	4856056.0
2019-04-02 11:30:00	AAPL	Stock	48.1025	48.1775	48.0875	48.145	3073640.0
2019-04-02 12:00:00	AAPL	Stock	48.1475	48.22	48.1275	48.2162	3075692.0
2019-04-02 12:30:00	AAPL	Stock	48.217	48.255	48.1725	48.2092	2725072.0
2019-04-02 13:00:00	AAPL	Stock	48.2075	48.2675	48.165	48.265	2430064.0
2019-04-02 13:30:00	AAPL	Stock	48.265	48.4538	48.25	48.42	5630268.0
2019-04-02 14:00:00	AAPL	Stock	48.42	48.46	48.33	48.3825	4204916.0
2019-04-02 14:30:00	AAPL	Stock	48.38	48.495	48.375	48.4925	3384620.0
2019-04-02 15:00:00	AAPL	Stock	48.4925	48.5725	48.475	48.4975	5219380.0
2019-04-02 15:30:00	AAPL	Stock	48.4975	48.615	48.495	48.51	10115408.0
2019-04-02 16:00:00	AAPL	Stock	48.505	48.555	48.4175	48.45	7270488.0
2019-04-02 16:30:00	AAPL	Stock	48.4275	48.505	48.405	48.42	126344.0
2019-04-02 17:00:00	AAPL	Stock	48.4375	48.45	48.42	48.42	20800.0
2019-04-02 17:30:00	AAPL	Stock	48.4192	48.45	48.4175	48.4175	12924.0
2019-04-02 18:00:00	AAPL	Stock	48.425	48.45	48.415	48.415	41396.0
2019-04-02 18:30:00	AAPL	Stock	48.425	48.43	48.415	48.43	9828.0
2019-04-02 19:00:00	AAPL	Stock	48.43	48.45	48.4	48.425	14656.0
2019-04-02 19:30:00	AAPL	Stock	48.425	48.425	48.3775	48.3775	55160.0
2019-04-02 05:00:00	MSFT	Stock	118.82	118.82	118.82	118.82	400.0
2019-04-02 06:30:00	MSFT	Stock	119.12	119.19	119.12	119.19	400.0
2019-04-02 07:00:00	MSFT	Stock	119.19	119.19	119.0	119.1	5259.0
2019-04-02 07:30:00	MSFT	Stock	118.97	118.97	118.97	118.97	420.0
2019-04-02 08:00:00	MSFT	Stock	119.1	119.19	119.1	119.18	1213.0
2019-04-02 08:30:00	MSFT	Stock	119.12	119.12	119.0	119.1	2624.0
2019-04-02 09:00:00	MSFT	Stock	119.12	119.19	118.69	118.69	13627.0
2019-04-02 09:30:00	MSFT	Stock	119.12	119.28	118.56	118.66	2151190.0
2019-04-02 10:00:00	MSFT	Stock	118.65	118.96	118.52	118.95	1188442.0
2019-04-02 10:30:00	MSFT	Stock	118.951	119.03	118.725	118.99	800595.0
2019-04-02 11:00:00	MSFT	Stock	118.99	119.0	118.7	118.92	721019.0
2019-04-02 11:30:00	MSFT	Stock	118.92	119.12	118.88	119.08	640339.0
2019-04-02 12:00:00	MSFT	Stock	119.085	119.171	118.97	119.12	714605.0
2019-04-02 12:30:00	MSFT	Stock	119.12	119.3	119.11	119.195	684837.0
2019-04-02 13:00:00	MSFT	Stock	119.194	119.26	119.1	119.17	464662.0
2019-04-02 13:30:00	MSFT	Stock	119.17	119.25	119.11	119.17	427980.0
2019-04-02 14:00:00	MSFT	Stock	119.174	119.18	119.05	119.09	516255.0
2019-04-02 14:30:00	MSFT	Stock	119.09	119.32	119.08	119.273	653699.0
2019-04-02 15:00:00	MSFT	Stock	119.27	119.38	119.24	119.285	734507.0
2019-04-02 15:30:00	MSFT	Stock	119.29	119.48	119.14	119.18	1871149.0

> showing 50 of 85,030 rows — these rows as CSV

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