PREVIEW / stock_30min / 2019-04-23

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-04-23.parquet
  size:    1.7 MB
  rows:    85,234
  symbols: 2,632

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-23 04:00:00	AAPL	Stock	51.155	51.155	51.155	51.155	3796.0
2019-04-23 04:30:00	AAPL	Stock	51.1	51.1	51.0	51.0075	17172.0
2019-04-23 05:00:00	AAPL	Stock	51.05	51.05	51.0275	51.0275	4340.0
2019-04-23 05:30:00	AAPL	Stock	51.075	51.075	51.01	51.01	800.0
2019-04-23 06:00:00	AAPL	Stock	51.0525	51.06	51.0525	51.06	2056.0
2019-04-23 06:30:00	AAPL	Stock	51.0575	51.075	50.615	50.9125	159996.0
2019-04-23 07:00:00	AAPL	Stock	50.93	50.99	50.8875	50.9625	90232.0
2019-04-23 07:30:00	AAPL	Stock	50.935	51.1075	50.925	51.0925	81232.0
2019-04-23 08:00:00	AAPL	Stock	50.9175	51.2625	50.88	51.06	193408.0
2019-04-23 08:30:00	AAPL	Stock	51.06	51.0625	50.9775	50.995	173968.0
2019-04-23 09:00:00	AAPL	Stock	51.0125	51.125	50.97	51.1	211524.0
2019-04-23 09:30:00	AAPL	Stock	51.1075	51.385	50.975	51.348	13167892.0
2019-04-23 10:00:00	AAPL	Stock	51.3525	51.48	51.2775	51.455	7620432.0
2019-04-23 10:30:00	AAPL	Stock	51.455	51.4975	51.3625	51.4925	4849308.0
2019-04-23 11:00:00	AAPL	Stock	51.49	51.625	51.4225	51.6175	5306732.0
2019-04-23 11:30:00	AAPL	Stock	51.6175	51.69	51.5975	51.6612	4188360.0
2019-04-23 12:00:00	AAPL	Stock	51.661	51.79	51.6425	51.76	4431084.0
2019-04-23 12:30:00	AAPL	Stock	51.76	51.885	51.7165	51.8325	4276080.0
2019-04-23 13:00:00	AAPL	Stock	51.8325	51.8525	51.79	51.8168	2185456.0
2019-04-23 13:30:00	AAPL	Stock	51.8168	51.8575	51.7275	51.745	3069680.0
2019-04-23 14:00:00	AAPL	Stock	51.7488	51.7758	51.72	51.7575	2827932.0
2019-04-23 14:30:00	AAPL	Stock	51.7575	51.8975	51.7325	51.8825	3256552.0
2019-04-23 15:00:00	AAPL	Stock	51.8825	51.9375	51.8575	51.8787	4911128.0
2019-04-23 15:30:00	AAPL	Stock	51.88	51.905	51.75	51.8775	8448972.0
2019-04-23 16:00:00	AAPL	Stock	51.87	51.9075	51.815	51.9075	11264048.0
2019-04-23 16:30:00	AAPL	Stock	51.9	51.9	51.8825	51.8875	18416.0
2019-04-23 17:00:00	AAPL	Stock	51.8975	51.8975	51.8625	51.8625	32124.0
2019-04-23 17:30:00	AAPL	Stock	51.8625	51.8875	51.855	51.88	21476.0
2019-04-23 18:00:00	AAPL	Stock	51.87	51.885	51.8675	51.8675	4516.0
2019-04-23 18:30:00	AAPL	Stock	51.87	51.8875	51.87	51.88	4380.0
2019-04-23 19:00:00	AAPL	Stock	51.87	51.8875	51.8375	51.8375	16216.0
2019-04-23 19:30:00	AAPL	Stock	51.8375	51.89	51.8375	51.89	24736.0
2019-04-23 04:00:00	MSFT	Stock	123.85	123.99	123.85	123.98	2084.0
2019-04-23 05:30:00	MSFT	Stock	123.98	123.98	123.9	123.97	1236.0
2019-04-23 06:00:00	MSFT	Stock	123.95	123.95	123.9	123.9	600.0
2019-04-23 06:30:00	MSFT	Stock	123.87	123.88	123.78	123.78	980.0
2019-04-23 07:00:00	MSFT	Stock	123.84	123.94	123.69	123.82	12807.0
2019-04-23 07:30:00	MSFT	Stock	123.62	123.8	123.62	123.8	4418.0
2019-04-23 08:00:00	MSFT	Stock	123.82	124.1	123.69	124.08	26723.0
2019-04-23 08:30:00	MSFT	Stock	124.08	124.09	123.85	123.91	22691.0
2019-04-23 09:00:00	MSFT	Stock	124.0	124.17	123.84	124.17	24403.0
2019-04-23 09:30:00	MSFT	Stock	124.18	124.995	123.83	124.84	2960554.0
2019-04-23 10:00:00	MSFT	Stock	124.845	125.25	124.48	124.8	2296374.0
2019-04-23 10:30:00	MSFT	Stock	124.79	124.82	124.372	124.44	1200399.0
2019-04-23 11:00:00	MSFT	Stock	124.445	124.78	124.122	124.765	1373885.0
2019-04-23 11:30:00	MSFT	Stock	124.76	124.88	124.57	124.84	940177.0
2019-04-23 12:00:00	MSFT	Stock	124.835	125.03	124.77	124.865	1093388.0
2019-04-23 12:30:00	MSFT	Stock	124.86	125.04	124.782	125.03	709483.0
2019-04-23 13:00:00	MSFT	Stock	125.03	125.068	124.94	124.94	742265.0
2019-04-23 13:30:00	MSFT	Stock	124.94	124.99	124.895	124.938	711437.0

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

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