PREVIEW / stock_30min / 2019-02-27

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-02-27.parquet
  size:    1.7 MB
  rows:    83,963
  symbols: 2,656

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-02-27 04:00:00	AAPL	Stock	43.415	43.4175	43.415	43.4175	2052.0
2019-02-27 04:30:00	AAPL	Stock	43.4475	43.4475	43.4475	43.4475	1276.0
2019-02-27 05:00:00	AAPL	Stock	43.4225	43.4225	43.42	43.42	1024.0
2019-02-27 05:30:00	AAPL	Stock	43.3975	43.445	43.3925	43.445	3856.0
2019-02-27 06:00:00	AAPL	Stock	43.445	43.445	43.445	43.445	800.0
2019-02-27 06:30:00	AAPL	Stock	43.445	43.445	43.4	43.405	3604.0
2019-02-27 07:00:00	AAPL	Stock	43.465	43.5275	43.45	43.475	11676.0
2019-02-27 07:30:00	AAPL	Stock	43.505	43.5225	43.47	43.475	29332.0
2019-02-27 08:00:00	AAPL	Stock	43.4875	43.69	43.4	43.45	83552.0
2019-02-27 08:30:00	AAPL	Stock	43.4625	43.5825	43.415	43.415	513156.0
2019-02-27 09:00:00	AAPL	Stock	43.4225	43.485	43.315	43.3375	143032.0
2019-02-27 09:30:00	AAPL	Stock	43.315	43.725	43.3025	43.51	9492976.0
2019-02-27 10:00:00	AAPL	Stock	43.5125	43.5612	43.2128	43.265	8155776.0
2019-02-27 10:30:00	AAPL	Stock	43.27	43.3575	43.1825	43.2725	5333628.0
2019-02-27 11:00:00	AAPL	Stock	43.2738	43.435	43.22	43.3982	4313052.0
2019-02-27 11:30:00	AAPL	Stock	43.3978	43.5175	43.3875	43.4732	3167292.0
2019-02-27 12:00:00	AAPL	Stock	43.4738	43.56	43.4525	43.555	2746768.0
2019-02-27 12:30:00	AAPL	Stock	43.5562	43.59	43.52	43.585	2196944.0
2019-02-27 13:00:00	AAPL	Stock	43.585	43.67	43.5475	43.6085	2469516.0
2019-02-27 13:30:00	AAPL	Stock	43.61	43.6325	43.5525	43.605	1979644.0
2019-02-27 14:00:00	AAPL	Stock	43.606	43.6825	43.5972	43.6575	2083948.0
2019-02-27 14:30:00	AAPL	Stock	43.6562	43.7375	43.6375	43.66	3153000.0
2019-02-27 15:00:00	AAPL	Stock	43.6625	43.75	43.64	43.71	3280580.0
2019-02-27 15:30:00	AAPL	Stock	43.71	43.74	43.605	43.72	7003172.0
2019-02-27 16:00:00	AAPL	Stock	43.7175	43.72	43.5605	43.695	13737168.0
2019-02-27 16:30:00	AAPL	Stock	43.7	43.75	43.69	43.735	37848.0
2019-02-27 17:00:00	AAPL	Stock	43.725	43.745	43.72	43.7275	12588.0
2019-02-27 17:30:00	AAPL	Stock	43.7125	43.7275	43.7	43.725	26888.0
2019-02-27 18:00:00	AAPL	Stock	43.725	43.7275	43.7025	43.705	6144.0
2019-02-27 18:30:00	AAPL	Stock	43.7025	43.7175	43.7025	43.705	12228.0
2019-02-27 19:00:00	AAPL	Stock	43.6875	43.6875	43.675	43.68	7112.0
2019-02-27 19:30:00	AAPL	Stock	43.6675	43.7	43.6675	43.6875	5600.0
2019-02-27 04:00:00	MSFT	Stock	112.17	112.17	111.81	111.81	1899.0
2019-02-27 04:30:00	MSFT	Stock	112.06	112.06	112.01	112.01	400.0
2019-02-27 06:30:00	MSFT	Stock	112.06	112.06	112.06	112.06	200.0
2019-02-27 07:00:00	MSFT	Stock	112.23	112.25	112.0	112.08	4902.0
2019-02-27 07:30:00	MSFT	Stock	112.01	112.1	111.87	111.91	6657.0
2019-02-27 08:00:00	MSFT	Stock	112.0	112.1	111.75	111.76	17478.0
2019-02-27 08:30:00	MSFT	Stock	111.84	112.03	111.73	111.89	15008.0
2019-02-27 09:00:00	MSFT	Stock	111.79	111.95	111.66	111.7	28888.0
2019-02-27 09:30:00	MSFT	Stock	111.68	112.18	111.47	111.6	2218793.0
2019-02-27 10:00:00	MSFT	Stock	111.61	111.695	110.88	111.084	1996318.0
2019-02-27 10:30:00	MSFT	Stock	111.09	111.59	111.05	111.39	1163599.0
2019-02-27 11:00:00	MSFT	Stock	111.39	111.84	111.38	111.71	909860.0
2019-02-27 11:30:00	MSFT	Stock	111.713	112.2	111.65	112.127	976125.0
2019-02-27 12:00:00	MSFT	Stock	112.125	112.27	112.09	112.163	561702.0
2019-02-27 12:30:00	MSFT	Stock	112.16	112.345	112.12	112.15	523272.0
2019-02-27 13:00:00	MSFT	Stock	112.15	112.21	111.97	112.025	1497361.0
2019-02-27 13:30:00	MSFT	Stock	112.02	112.04	111.75	111.98	1062652.0
2019-02-27 14:00:00	MSFT	Stock	111.985	112.14	111.92	112.069	817285.0

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

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