PREVIEW / stock_30min / 2019-01-11

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-01-11.parquet
  size:    1.7 MB
  rows:    82,203
  symbols: 2,669

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-01-11 04:00:00	AAPL	Stock	38.635	38.635	38.56	38.56	2084.0
2019-01-11 04:30:00	AAPL	Stock	38.62	38.635	38.575	38.575	9120.0
2019-01-11 05:00:00	AAPL	Stock	38.625	38.6325	38.5275	38.5875	20676.0
2019-01-11 05:30:00	AAPL	Stock	38.5275	38.5275	38.45	38.5225	9012.0
2019-01-11 06:00:00	AAPL	Stock	38.565	38.62	38.4625	38.49	16056.0
2019-01-11 06:30:00	AAPL	Stock	38.48	38.565	38.475	38.495	16664.0
2019-01-11 07:00:00	AAPL	Stock	38.5125	38.5125	38.4125	38.4625	48368.0
2019-01-11 07:30:00	AAPL	Stock	38.4625	38.48	38.325	38.3275	50776.0
2019-01-11 08:00:00	AAPL	Stock	38.5	38.55	38.1675	38.225	295640.0
2019-01-11 08:30:00	AAPL	Stock	38.25	38.295	38.1875	38.2375	218480.0
2019-01-11 09:00:00	AAPL	Stock	38.2475	38.285	38.1875	38.1875	161940.0
2019-01-11 09:30:00	AAPL	Stock	38.2025	38.425	38.1875	38.2775	11238812.0
2019-01-11 10:00:00	AAPL	Stock	38.2725	38.375	38.0175	38.0525	9433740.0
2019-01-11 10:30:00	AAPL	Stock	38.055	38.24	38.0075	38.2075	7067824.0
2019-01-11 11:00:00	AAPL	Stock	38.2075	38.2475	37.96	38.0025	8115484.0
2019-01-11 11:30:00	AAPL	Stock	38.005	38.1	37.975	38.093	4724224.0
2019-01-11 12:00:00	AAPL	Stock	38.0925	38.17	38.08	38.115	4009884.0
2019-01-11 12:30:00	AAPL	Stock	38.1175	38.1675	38.05	38.1075	3901720.0
2019-01-11 13:00:00	AAPL	Stock	38.11	38.1125	37.915	37.9605	5686588.0
2019-01-11 13:30:00	AAPL	Stock	37.96	38.0	37.8775	37.9125	5632504.0
2019-01-11 14:00:00	AAPL	Stock	37.91	38.0225	37.8812	37.9862	4309124.0
2019-01-11 14:30:00	AAPL	Stock	37.9875	38.0775	37.9675	38.0342	4293224.0
2019-01-11 15:00:00	AAPL	Stock	38.0325	38.0825	38.0	38.03	4259272.0
2019-01-11 15:30:00	AAPL	Stock	38.0312	38.1475	38.01	38.07	11407236.0
2019-01-11 16:00:00	AAPL	Stock	38.0725	38.125	38.025	38.0675	12549996.0
2019-01-11 16:30:00	AAPL	Stock	38.065	38.0725	38.0625	38.065	65136.0
2019-01-11 17:00:00	AAPL	Stock	38.0625	38.0825	38.0625	38.0725	25920.0
2019-01-11 17:30:00	AAPL	Stock	38.0675	38.075	38.0525	38.0725	11440.0
2019-01-11 18:00:00	AAPL	Stock	38.0625	38.0625	38.03	38.0325	14944.0
2019-01-11 18:30:00	AAPL	Stock	38.03	38.0625	38.03	38.06	12440.0
2019-01-11 19:00:00	AAPL	Stock	38.05	38.0725	38.05	38.0725	37836.0
2019-01-11 19:30:00	AAPL	Stock	38.075	38.0875	38.0625	38.0875	27572.0
2019-01-11 04:30:00	MSFT	Stock	103.65	103.65	103.65	103.65	600.0
2019-01-11 05:00:00	MSFT	Stock	103.5	103.5	103.5	103.5	679.0
2019-01-11 05:30:00	MSFT	Stock	103.31	103.31	103.25	103.25	1098.0
2019-01-11 06:00:00	MSFT	Stock	103.5	103.5	103.5	103.5	800.0
2019-01-11 06:30:00	MSFT	Stock	103.48	103.48	103.48	103.48	130.0
2019-01-11 07:00:00	MSFT	Stock	103.5	103.59	103.12	103.34	6557.0
2019-01-11 07:30:00	MSFT	Stock	103.35	103.35	103.22	103.22	5890.0
2019-01-11 08:00:00	MSFT	Stock	103.32	103.32	103.0	103.0	7716.0
2019-01-11 08:30:00	MSFT	Stock	103.0	103.17	102.85	102.99	5666.0
2019-01-11 09:00:00	MSFT	Stock	103.13	103.24	102.95	103.0	28695.0
2019-01-11 09:30:00	MSFT	Stock	102.94	103.44	101.94	102.41	3323097.0
2019-01-11 10:00:00	MSFT	Stock	102.4	102.71	102.06	102.06	2120783.0
2019-01-11 10:30:00	MSFT	Stock	102.06	102.52	102.0	102.485	1443655.0
2019-01-11 11:00:00	MSFT	Stock	102.48	102.54	101.92	101.975	1594452.0
2019-01-11 11:30:00	MSFT	Stock	101.98	102.31	101.92	102.25	1462025.0
2019-01-11 12:00:00	MSFT	Stock	102.24	102.41	102.1	102.16	1090471.0
2019-01-11 12:30:00	MSFT	Stock	102.16	102.27	101.97	102.035	991698.0
2019-01-11 13:00:00	MSFT	Stock	102.03	102.06	101.64	101.852	1383022.0

> showing 50 of 82,203 rows — these rows as CSV

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