PREVIEW / stock_30min / 2019-04-05

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-04-05.parquet
  size:    1.7 MB
  rows:    83,799
  symbols: 2,651

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-05 04:00:00	AAPL	Stock	49.05	49.17	49.05	49.075	2532.0
2019-04-05 04:30:00	AAPL	Stock	49.075	49.075	49.075	49.075	1600.0
2019-04-05 05:00:00	AAPL	Stock	49.075	49.075	49.075	49.075	3548.0
2019-04-05 05:30:00	AAPL	Stock	49.1125	49.205	49.075	49.075	6668.0
2019-04-05 06:00:00	AAPL	Stock	49.02	49.02	49.02	49.02	400.0
2019-04-05 07:00:00	AAPL	Stock	49.0625	49.0625	49.0	49.0275	76616.0
2019-04-05 07:30:00	AAPL	Stock	49.025	49.025	49.0	49.0175	12772.0
2019-04-05 08:00:00	AAPL	Stock	49.06	49.06	48.98	49.0325	65092.0
2019-04-05 08:30:00	AAPL	Stock	49.0325	49.175	49.0325	49.1225	125016.0
2019-04-05 09:00:00	AAPL	Stock	49.1028	49.1725	49.0925	49.1025	83824.0
2019-04-05 09:30:00	AAPL	Stock	49.1125	49.275	48.9825	49.1525	13883560.0
2019-04-05 10:00:00	AAPL	Stock	49.155	49.205	49.0325	49.0962	5924236.0
2019-04-05 10:30:00	AAPL	Stock	49.1	49.1672	49.0175	49.1025	4395396.0
2019-04-05 11:00:00	AAPL	Stock	49.1075	49.13	49.035	49.072	3664632.0
2019-04-05 11:30:00	AAPL	Stock	49.07	49.1438	49.055	49.1225	3232624.0
2019-04-05 12:00:00	AAPL	Stock	49.125	49.23	49.12	49.21	2878680.0
2019-04-05 12:30:00	AAPL	Stock	49.21	49.2125	49.0918	49.1325	3496500.0
2019-04-05 13:00:00	AAPL	Stock	49.1358	49.165	49.1213	49.1425	2185260.0
2019-04-05 13:30:00	AAPL	Stock	49.1425	49.1725	49.1075	49.1725	1695824.0
2019-04-05 14:00:00	AAPL	Stock	49.1725	49.225	49.15	49.2	2940880.0
2019-04-05 14:30:00	AAPL	Stock	49.2	49.24	49.1675	49.18	2898636.0
2019-04-05 15:00:00	AAPL	Stock	49.1775	49.24	49.1625	49.2325	3044872.0
2019-04-05 15:30:00	AAPL	Stock	49.23	49.2675	49.2092	49.2425	7278776.0
2019-04-05 16:00:00	AAPL	Stock	49.26	49.2625	49.21	49.235	6619260.0
2019-04-05 16:30:00	AAPL	Stock	49.2348	49.2375	49.215	49.2375	65612.0
2019-04-05 17:00:00	AAPL	Stock	49.2375	49.2375	49.2225	49.23	26220.0
2019-04-05 17:30:00	AAPL	Stock	49.23	49.25	49.23	49.2375	45836.0
2019-04-05 18:00:00	AAPL	Stock	49.2375	49.25	49.2375	49.25	18324.0
2019-04-05 18:30:00	AAPL	Stock	49.25	49.25	49.23	49.2475	25036.0
2019-04-05 19:00:00	AAPL	Stock	49.23	49.2375	49.225	49.23	10988.0
2019-04-05 19:30:00	AAPL	Stock	49.2225	49.25	49.2225	49.225	33732.0
2019-04-05 04:00:00	MSFT	Stock	119.5	119.5	119.5	119.5	300.0
2019-04-05 06:30:00	MSFT	Stock	119.5	119.5	119.5	119.5	100.0
2019-04-05 07:00:00	MSFT	Stock	119.6	119.6	119.5	119.58	4927.0
2019-04-05 07:30:00	MSFT	Stock	119.58	119.58	119.58	119.58	100.0
2019-04-05 08:00:00	MSFT	Stock	119.57	119.58	119.53	119.54	1867.0
2019-04-05 08:30:00	MSFT	Stock	119.55	119.95	119.55	119.85	9955.0
2019-04-05 09:00:00	MSFT	Stock	119.76	119.86	119.2	119.47	38228.0
2019-04-05 09:30:00	MSFT	Stock	119.39	120.091	119.37	119.95	2568149.0
2019-04-05 10:00:00	MSFT	Stock	119.95	120.23	119.94	119.98	1215045.0
2019-04-05 10:30:00	MSFT	Stock	119.98	120.075	119.75	119.88	863291.0
2019-04-05 11:00:00	MSFT	Stock	119.88	119.99	119.68	119.97	893554.0
2019-04-05 11:30:00	MSFT	Stock	119.98	120.04	119.865	119.877	857138.0
2019-04-05 12:00:00	MSFT	Stock	119.87	120.03	119.845	119.998	439096.0
2019-04-05 12:30:00	MSFT	Stock	119.99	120.015	119.71	119.78	496959.0
2019-04-05 13:00:00	MSFT	Stock	119.775	119.86	119.73	119.78	342403.0
2019-04-05 13:30:00	MSFT	Stock	119.78	119.82	119.67	119.74	403915.0
2019-04-05 14:00:00	MSFT	Stock	119.73	119.77	119.53	119.575	425341.0
2019-04-05 14:30:00	MSFT	Stock	119.575	119.735	119.53	119.675	604151.0
2019-04-05 15:00:00	MSFT	Stock	119.68	119.98	119.675	119.94	627956.0

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

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