PREVIEW / stock_30min / 2018-05-21

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-05-21.parquet
  size:    1.7 MB
  rows:    83,305
  symbols: 2,849

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-05-21 04:00:00	AAPL	Stock	46.8025	46.925	46.8025	46.9125	21632.0
2018-05-21 04:30:00	AAPL	Stock	46.9225	46.9225	46.9225	46.9225	400.0
2018-05-21 05:00:00	AAPL	Stock	46.9075	46.9275	46.9075	46.9225	3000.0
2018-05-21 05:30:00	AAPL	Stock	46.93	46.93	46.93	46.93	1200.0
2018-05-21 06:00:00	AAPL	Stock	46.93	46.93	46.85	46.905	4592.0
2018-05-21 06:30:00	AAPL	Stock	46.9	46.9475	46.9	46.9025	7600.0
2018-05-21 07:00:00	AAPL	Stock	46.935	46.9675	46.8925	46.965	70472.0
2018-05-21 07:30:00	AAPL	Stock	46.9725	46.9875	46.9525	46.9875	51820.0
2018-05-21 08:00:00	AAPL	Stock	46.975	46.995	46.93	46.9725	187884.0
2018-05-21 08:30:00	AAPL	Stock	46.97	47.0175	46.97	47.01	201792.0
2018-05-21 09:00:00	AAPL	Stock	47.01	47.025	46.945	46.9725	148836.0
2018-05-21 09:30:00	AAPL	Stock	47.0	47.3175	46.9775	47.2475	13138664.0
2018-05-21 10:00:00	AAPL	Stock	47.25	47.3175	47.1175	47.1725	7340168.0
2018-05-21 10:30:00	AAPL	Stock	47.1775	47.2525	47.085	47.145	4490968.0
2018-05-21 11:00:00	AAPL	Stock	47.1442	47.175	46.8425	46.89	5378744.0
2018-05-21 11:30:00	AAPL	Stock	46.89	46.94	46.775	46.9025	4639248.0
2018-05-21 12:00:00	AAPL	Stock	46.905	47.0175	46.8875	46.9625	2855588.0
2018-05-21 12:30:00	AAPL	Stock	46.9625	46.99	46.9275	46.96	1672996.0
2018-05-21 13:00:00	AAPL	Stock	46.9625	47.065	46.9525	46.9825	2460452.0
2018-05-21 13:30:00	AAPL	Stock	46.985	46.9925	46.935	46.965	1631516.0
2018-05-21 14:00:00	AAPL	Stock	46.9662	46.9685	46.8175	46.8425	2699040.0
2018-05-21 14:30:00	AAPL	Stock	46.8425	46.8625	46.7278	46.83	2737500.0
2018-05-21 15:00:00	AAPL	Stock	46.83	46.8875	46.785	46.8142	3120444.0
2018-05-21 15:30:00	AAPL	Stock	46.815	47.07	46.77	46.9025	6381336.0
2018-05-21 16:00:00	AAPL	Stock	46.9075	46.9325	46.8525	46.9325	5971048.0
2018-05-21 16:30:00	AAPL	Stock	46.895	46.91	46.8875	46.895	76436.0
2018-05-21 17:00:00	AAPL	Stock	46.9	46.9	46.895	46.895	4400.0
2018-05-21 17:30:00	AAPL	Stock	46.8975	46.9125	46.8975	46.9075	22580.0
2018-05-21 18:00:00	AAPL	Stock	46.9075	46.9075	46.905	46.905	1604.0
2018-05-21 18:30:00	AAPL	Stock	46.9	46.9125	46.9	46.9125	13200.0
2018-05-21 19:00:00	AAPL	Stock	46.9	46.92	46.8975	46.9	11752.0
2018-05-21 19:30:00	AAPL	Stock	46.91	46.9125	46.8975	46.8975	5728.0
2018-05-21 04:30:00	MSFT	Stock	97.36	97.36	97.32	97.32	1100.0
2018-05-21 05:00:00	MSFT	Stock	97.5	97.67	97.5	97.67	204.0
2018-05-21 06:30:00	MSFT	Stock	97.49	97.49	97.49	97.49	224.0
2018-05-21 07:00:00	MSFT	Stock	97.15	97.15	96.8	97.14	5763.0
2018-05-21 07:30:00	MSFT	Stock	97.05	97.12	97.0	97.12	815.0
2018-05-21 08:00:00	MSFT	Stock	97.13	97.17	97.0	97.17	4602.0
2018-05-21 08:30:00	MSFT	Stock	97.14	97.2	97.09	97.2	5466.0
2018-05-21 09:00:00	MSFT	Stock	97.11	97.18	96.95	96.95	11550.0
2018-05-21 09:30:00	MSFT	Stock	96.95	97.8	96.93	97.75	2677820.0
2018-05-21 10:00:00	MSFT	Stock	97.76	97.85	97.42	97.44	882873.0
2018-05-21 10:30:00	MSFT	Stock	97.45	98.01	97.45	97.9	1124114.0
2018-05-21 11:00:00	MSFT	Stock	97.9	97.99	97.03	97.14	958210.0
2018-05-21 11:30:00	MSFT	Stock	97.13	97.29	96.8	97.29	859682.0
2018-05-21 12:00:00	MSFT	Stock	97.29	97.59	97.22	97.54	784623.0
2018-05-21 12:30:00	MSFT	Stock	97.54	97.64	97.48	97.55	607703.0
2018-05-21 13:00:00	MSFT	Stock	97.55	97.775	97.51	97.73	906854.0
2018-05-21 13:30:00	MSFT	Stock	97.73	97.75	97.57	97.685	412877.0
2018-05-21 14:00:00	MSFT	Stock	97.68	97.69	97.36	97.41	529966.0

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

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