PREVIEW / stock_30min / 2018-01-30

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-01-30.parquet
  size:    1.7 MB
  rows:    86,627
  symbols: 2,895

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-01-30 04:00:00	AAPL	Stock	42.0	42.0	41.8025	41.805	1200.0
2018-01-30 04:30:00	AAPL	Stock	41.775	41.8	41.775	41.8	4392.0
2018-01-30 05:00:00	AAPL	Stock	41.775	41.775	41.6825	41.6825	34492.0
2018-01-30 05:30:00	AAPL	Stock	41.685	41.6875	41.52	41.575	32020.0
2018-01-30 06:00:00	AAPL	Stock	41.595	41.6	41.5075	41.55	41156.0
2018-01-30 06:30:00	AAPL	Stock	41.55	41.66	41.53	41.6425	67020.0
2018-01-30 07:00:00	AAPL	Stock	41.6225	41.6675	41.525	41.5375	134808.0
2018-01-30 07:30:00	AAPL	Stock	41.53	41.53	41.375	41.425	253560.0
2018-01-30 08:00:00	AAPL	Stock	41.475	41.6975	41.3775	41.52	815748.0
2018-01-30 08:30:00	AAPL	Stock	41.5125	41.5725	41.4275	41.445	341828.0
2018-01-30 09:00:00	AAPL	Stock	41.4725	41.5	41.3425	41.3625	883908.0
2018-01-30 09:30:00	AAPL	Stock	41.3888	41.7325	41.175	41.6775	36117340.0
2018-01-30 10:00:00	AAPL	Stock	41.675	41.8125	41.465	41.7938	16928680.0
2018-01-30 10:30:00	AAPL	Stock	41.7925	41.8325	41.5725	41.7625	10986680.0
2018-01-30 11:00:00	AAPL	Stock	41.765	41.8425	41.6525	41.68	10139580.0
2018-01-30 11:30:00	AAPL	Stock	41.68	41.6925	41.436	41.475	8999652.0
2018-01-30 12:00:00	AAPL	Stock	41.475	41.5725	41.465	41.54	6019184.0
2018-01-30 12:30:00	AAPL	Stock	41.5388	41.6125	41.47	41.5	5056408.0
2018-01-30 13:00:00	AAPL	Stock	41.4975	41.5	41.2875	41.3075	17201000.0
2018-01-30 13:30:00	AAPL	Stock	41.31	41.5575	41.275	41.5075	7413064.0
2018-01-30 14:00:00	AAPL	Stock	41.5075	41.6625	41.4925	41.595	7368248.0
2018-01-30 14:30:00	AAPL	Stock	41.595	41.6638	41.4875	41.5812	5953356.0
2018-01-30 15:00:00	AAPL	Stock	41.58	41.699	41.5575	41.6875	7217152.0
2018-01-30 15:30:00	AAPL	Stock	41.6875	41.765	41.6425	41.74	13784012.0
2018-01-30 16:00:00	AAPL	Stock	41.7425	41.7875	41.72	41.77	6754432.0
2018-01-30 16:30:00	AAPL	Stock	41.7525	41.805	41.7125	41.77	233668.0
2018-01-30 17:00:00	AAPL	Stock	41.7525	41.795	41.7425	41.7575	528052.0
2018-01-30 17:30:00	AAPL	Stock	41.79	41.8	41.7625	41.8	43608.0
2018-01-30 18:00:00	AAPL	Stock	41.7875	41.8275	41.7575	41.8225	27908.0
2018-01-30 18:30:00	AAPL	Stock	41.8225	41.835	41.7825	41.805	73620.0
2018-01-30 19:00:00	AAPL	Stock	41.8125	41.82	41.775	41.775	99136.0
2018-01-30 19:30:00	AAPL	Stock	41.7775	41.8125	41.7625	41.77	42764.0
2018-01-30 04:00:00	MSFT	Stock	93.2	93.2	93.0	93.19	3284.0
2018-01-30 04:30:00	MSFT	Stock	93.19	93.2	93.19	93.2	520.0
2018-01-30 05:00:00	MSFT	Stock	93.39	93.39	93.39	93.39	900.0
2018-01-30 05:30:00	MSFT	Stock	93.2	93.2	93.1	93.2	2606.0
2018-01-30 06:00:00	MSFT	Stock	93.19	93.22	93.05	93.05	1503.0
2018-01-30 06:30:00	MSFT	Stock	93.04	93.37	93.04	93.37	3156.0
2018-01-30 07:00:00	MSFT	Stock	93.36	93.37	93.12	93.21	8485.0
2018-01-30 07:30:00	MSFT	Stock	93.28	93.79	93.1	93.5	38228.0
2018-01-30 08:00:00	MSFT	Stock	93.21	94.12	93.13	93.45	47679.0
2018-01-30 08:30:00	MSFT	Stock	93.44	93.65	93.3	93.5	77856.0
2018-01-30 09:00:00	MSFT	Stock	93.42	93.7	93.22	93.64	102488.0
2018-01-30 09:30:00	MSFT	Stock	93.3	93.66	92.25	92.34	5232430.0
2018-01-30 10:00:00	MSFT	Stock	92.32	92.94	92.1	92.88	2996796.0
2018-01-30 10:30:00	MSFT	Stock	92.88	93.3	92.64	93.255	2613780.0
2018-01-30 11:00:00	MSFT	Stock	93.26	93.48	93.0	93.06	1706558.0
2018-01-30 11:30:00	MSFT	Stock	93.065	93.37	92.961	93.06	1448302.0
2018-01-30 12:00:00	MSFT	Stock	93.06	93.175	92.93	93.03	987106.0
2018-01-30 12:30:00	MSFT	Stock	93.03	93.13	92.7	92.805	1345194.0

> showing 50 of 86,627 rows — these rows as CSV

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