PREVIEW / stock_30min / 2019-03-04

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-03-04.parquet
  size:    1.7 MB
  rows:    85,893
  symbols: 2,653

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-03-04 04:00:00	AAPL	Stock	43.8875	43.975	43.8775	43.925	17024.0
2019-03-04 04:30:00	AAPL	Stock	43.9275	43.9275	43.925	43.925	3464.0
2019-03-04 05:00:00	AAPL	Stock	43.88	43.9425	43.8775	43.9025	3552.0
2019-03-04 05:30:00	AAPL	Stock	43.9425	43.9425	43.9025	43.935	2800.0
2019-03-04 06:00:00	AAPL	Stock	43.9375	43.9425	43.9375	43.9425	11456.0
2019-03-04 06:30:00	AAPL	Stock	43.94	43.945	43.9375	43.945	5640.0
2019-03-04 07:00:00	AAPL	Stock	43.9375	43.9875	43.9	43.95	64944.0
2019-03-04 07:30:00	AAPL	Stock	43.9525	43.9625	43.9375	43.955	29348.0
2019-03-04 08:00:00	AAPL	Stock	43.9698	44.0	43.9375	43.985	200352.0
2019-03-04 08:30:00	AAPL	Stock	43.985	44.0	43.9225	43.9425	123168.0
2019-03-04 09:00:00	AAPL	Stock	43.9625	44.025	43.9	43.915	278684.0
2019-03-04 09:30:00	AAPL	Stock	43.9175	44.415	43.91	44.369	16266168.0
2019-03-04 10:00:00	AAPL	Stock	44.3725	44.4375	44.1625	44.3375	9798948.0
2019-03-04 10:30:00	AAPL	Stock	44.34	44.35	44.155	44.1775	6119752.0
2019-03-04 11:00:00	AAPL	Stock	44.175	44.1888	43.98	44.0818	7521172.0
2019-03-04 11:30:00	AAPL	Stock	44.0825	44.1075	43.6908	43.8	8440532.0
2019-03-04 12:00:00	AAPL	Stock	43.7988	43.875	43.4925	43.6325	7051832.0
2019-03-04 12:30:00	AAPL	Stock	43.628	43.7025	43.5675	43.695	5393980.0
2019-03-04 13:00:00	AAPL	Stock	43.6925	43.825	43.6025	43.8025	3780088.0
2019-03-04 13:30:00	AAPL	Stock	43.805	43.875	43.7625	43.8545	3858748.0
2019-03-04 14:00:00	AAPL	Stock	43.8525	43.93	43.805	43.9125	3431352.0
2019-03-04 14:30:00	AAPL	Stock	43.915	43.9275	43.83	43.87	3511672.0
2019-03-04 15:00:00	AAPL	Stock	43.865	43.8925	43.8075	43.835	3461012.0
2019-03-04 15:30:00	AAPL	Stock	43.8375	43.9925	43.82	43.965	9661360.0
2019-03-04 16:00:00	AAPL	Stock	43.965	44.01	43.94	43.95	9204048.0
2019-03-04 16:30:00	AAPL	Stock	43.95	43.95	43.9275	43.9375	31800.0
2019-03-04 17:00:00	AAPL	Stock	43.9425	43.9425	43.9	43.9	12500.0
2019-03-04 17:30:00	AAPL	Stock	43.925	43.93	43.925	43.93	2600.0
2019-03-04 18:00:00	AAPL	Stock	43.9125	43.9125	43.85	43.8825	19128.0
2019-03-04 18:30:00	AAPL	Stock	43.8875	43.8875	43.88	43.88	8368.0
2019-03-04 19:00:00	AAPL	Stock	43.89	43.9125	43.85	43.89	11888.0
2019-03-04 19:30:00	AAPL	Stock	43.9125	43.9625	43.8875	43.8875	24916.0
2019-03-04 04:00:00	MSFT	Stock	112.82	113.05	112.82	113.05	1400.0
2019-03-04 05:30:00	MSFT	Stock	113.12	113.12	113.08	113.08	1100.0
2019-03-04 06:00:00	MSFT	Stock	113.15	113.15	113.15	113.15	2100.0
2019-03-04 06:30:00	MSFT	Stock	113.15	113.15	113.0	113.0	5149.0
2019-03-04 07:00:00	MSFT	Stock	112.95	113.15	112.85	113.14	7365.0
2019-03-04 07:30:00	MSFT	Stock	113.06	113.06	112.98	113.0	12479.0
2019-03-04 08:00:00	MSFT	Stock	112.95	113.15	112.95	113.1	28619.0
2019-03-04 08:30:00	MSFT	Stock	113.11	113.15	113.05	113.05	7348.0
2019-03-04 09:00:00	MSFT	Stock	113.06	113.2	112.75	112.94	24923.0
2019-03-04 09:30:00	MSFT	Stock	113.0	113.25	112.745	113.155	2740462.0
2019-03-04 10:00:00	MSFT	Stock	113.15	113.2	112.725	112.86	1769168.0
2019-03-04 10:30:00	MSFT	Stock	112.87	112.915	112.22	112.23	1361925.0
2019-03-04 11:00:00	MSFT	Stock	112.23	112.32	111.76	111.78	1587828.0
2019-03-04 11:30:00	MSFT	Stock	111.775	111.8	111.05	111.235	2022025.0
2019-03-04 12:00:00	MSFT	Stock	111.23	111.58	110.85	111.16	1672961.0
2019-03-04 12:30:00	MSFT	Stock	111.16	111.29	110.8	111.09	883790.0
2019-03-04 13:00:00	MSFT	Stock	111.09	111.525	110.9	111.46	931953.0
2019-03-04 13:30:00	MSFT	Stock	111.47	111.79	111.38	111.705	933018.0

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

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