PREVIEW / stock_30min / 2018-09-19

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-09-19.parquet
  size:    1.7 MB
  rows:    84,180
  symbols: 2,773

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-09-19 04:00:00	AAPL	Stock	54.625	54.6825	54.625	54.6825	9904.0
2018-09-19 04:30:00	AAPL	Stock	54.6625	54.6625	54.6625	54.6625	400.0
2018-09-19 05:30:00	AAPL	Stock	54.6475	54.6475	54.6475	54.6475	1200.0
2018-09-19 06:00:00	AAPL	Stock	54.65	54.71	54.64	54.64	17144.0
2018-09-19 06:30:00	AAPL	Stock	54.6725	54.6725	54.6725	54.6725	464.0
2018-09-19 07:00:00	AAPL	Stock	54.685	54.71	54.5925	54.6	79536.0
2018-09-19 07:30:00	AAPL	Stock	54.6	54.6	54.525	54.525	16480.0
2018-09-19 08:00:00	AAPL	Stock	54.6725	54.6725	54.4625	54.5375	184368.0
2018-09-19 08:30:00	AAPL	Stock	54.5425	54.625	54.525	54.625	121412.0
2018-09-19 09:00:00	AAPL	Stock	54.625	54.6875	54.5775	54.605	154340.0
2018-09-19 09:30:00	AAPL	Stock	54.625	54.905	54.0515	54.0888	15564924.0
2018-09-19 10:00:00	AAPL	Stock	54.0898	54.22	53.825	54.0432	14356552.0
2018-09-19 10:30:00	AAPL	Stock	54.0475	54.1875	53.9775	54.0575	6572252.0
2018-09-19 11:00:00	AAPL	Stock	54.0625	54.4875	54.0075	54.4035	8314052.0
2018-09-19 11:30:00	AAPL	Stock	54.4	54.5275	54.2775	54.5225	5524700.0
2018-09-19 12:00:00	AAPL	Stock	54.5175	54.575	54.3938	54.505	5243012.0
2018-09-19 12:30:00	AAPL	Stock	54.505	54.54	54.375	54.4988	3257400.0
2018-09-19 13:00:00	AAPL	Stock	54.4975	54.5	54.38	54.4185	2642852.0
2018-09-19 13:30:00	AAPL	Stock	54.415	54.495	54.375	54.45	2906116.0
2018-09-19 14:00:00	AAPL	Stock	54.4475	54.515	54.3825	54.4828	3025876.0
2018-09-19 14:30:00	AAPL	Stock	54.4838	54.495	54.3275	54.3475	3199016.0
2018-09-19 15:00:00	AAPL	Stock	54.3475	54.6225	54.345	54.5625	4220232.0
2018-09-19 15:30:00	AAPL	Stock	54.5625	54.695	54.5525	54.585	8421700.0
2018-09-19 16:00:00	AAPL	Stock	54.595	54.75	54.5925	54.6875	8115488.0
2018-09-19 16:30:00	AAPL	Stock	54.5925	54.775	54.5925	54.7125	447084.0
2018-09-19 17:00:00	AAPL	Stock	54.685	54.6875	54.6625	54.665	13512.0
2018-09-19 17:30:00	AAPL	Stock	54.6575	54.675	54.6275	54.675	16736.0
2018-09-19 18:00:00	AAPL	Stock	54.6875	54.6975	54.635	54.655	30184.0
2018-09-19 18:30:00	AAPL	Stock	54.655	54.6975	54.655	54.695	8600.0
2018-09-19 19:00:00	AAPL	Stock	54.6625	54.6925	54.65	54.6675	9800.0
2018-09-19 19:30:00	AAPL	Stock	54.6625	54.72	54.64	54.7	37076.0
2018-09-19 04:00:00	MSFT	Stock	113.09	113.09	112.99	113.0	3700.0
2018-09-19 04:30:00	MSFT	Stock	113.0	113.0	112.96	113.0	792.0
2018-09-19 05:00:00	MSFT	Stock	113.0	113.0	112.75	112.75	2062.0
2018-09-19 06:00:00	MSFT	Stock	112.76	112.76	112.48	112.48	3287.0
2018-09-19 06:30:00	MSFT	Stock	112.45	112.45	112.13	112.25	1973.0
2018-09-19 07:00:00	MSFT	Stock	112.44	112.45	112.21	112.37	8391.0
2018-09-19 07:30:00	MSFT	Stock	112.38	112.38	112.15	112.25	24034.0
2018-09-19 08:00:00	MSFT	Stock	112.45	113.49	112.18	112.45	27462.0
2018-09-19 08:30:00	MSFT	Stock	112.43	112.7	112.38	112.63	11649.0
2018-09-19 09:00:00	MSFT	Stock	112.64	113.1	112.55	113.1	22070.0
2018-09-19 09:30:00	MSFT	Stock	113.05	113.32	111.74	111.87	2986856.0
2018-09-19 10:00:00	MSFT	Stock	111.865	112.11	111.5	111.79	2136143.0
2018-09-19 10:30:00	MSFT	Stock	111.79	112.0	111.501	111.63	1284394.0
2018-09-19 11:00:00	MSFT	Stock	111.64	112.265	111.52	112.06	1344819.0
2018-09-19 11:30:00	MSFT	Stock	112.05	112.06	111.605	111.88	885047.0
2018-09-19 12:00:00	MSFT	Stock	111.87	111.89	111.465	111.475	868144.0
2018-09-19 12:30:00	MSFT	Stock	111.47	111.5	111.05	111.27	1220647.0
2018-09-19 13:00:00	MSFT	Stock	111.26	111.3	111.035	111.235	866183.0
2018-09-19 13:30:00	MSFT	Stock	111.23	111.571	111.22	111.555	664541.0

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

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