PREVIEW / stock_30min / 2018-09-20

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-09-20.parquet
  size:    1.7 MB
  rows:    85,369
  symbols: 2,802

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-09-20 04:00:00	AAPL	Stock	54.75	54.7625	54.75	54.7625	4244.0
2018-09-20 04:30:00	AAPL	Stock	54.7625	54.7625	54.7375	54.7375	1684.0
2018-09-20 05:00:00	AAPL	Stock	54.7375	54.7375	54.7375	54.7375	2000.0
2018-09-20 06:30:00	AAPL	Stock	54.75	54.8775	54.75	54.8775	11804.0
2018-09-20 07:00:00	AAPL	Stock	54.8775	54.9	54.7575	54.85	105052.0
2018-09-20 07:30:00	AAPL	Stock	54.85	54.9625	54.85	54.95	150408.0
2018-09-20 08:00:00	AAPL	Stock	54.8725	55.125	54.785	55.0125	474824.0
2018-09-20 08:30:00	AAPL	Stock	55.0125	55.1725	55.0125	55.1425	268636.0
2018-09-20 09:00:00	AAPL	Stock	55.15	55.1525	55.0375	55.0825	274068.0
2018-09-20 09:30:00	AAPL	Stock	55.08	55.425	54.7875	55.3125	16418604.0
2018-09-20 10:00:00	AAPL	Stock	55.3125	55.57	55.3045	55.4325	9872776.0
2018-09-20 10:30:00	AAPL	Stock	55.435	55.4625	55.215	55.245	6479720.0
2018-09-20 11:00:00	AAPL	Stock	55.25	55.37	55.1338	55.24	4925124.0
2018-09-20 11:30:00	AAPL	Stock	55.2375	55.4225	55.2288	55.3225	4455988.0
2018-09-20 12:00:00	AAPL	Stock	55.3212	55.326	55.15	55.2275	3512168.0
2018-09-20 12:30:00	AAPL	Stock	55.23	55.315	55.155	55.29	2975384.0
2018-09-20 13:00:00	AAPL	Stock	55.29	55.325	55.21	55.245	2889508.0
2018-09-20 13:30:00	AAPL	Stock	55.245	55.295	55.11	55.1875	3661656.0
2018-09-20 14:00:00	AAPL	Stock	55.1875	55.22	55.0175	55.07	3857600.0
2018-09-20 14:30:00	AAPL	Stock	55.0675	55.1725	55.0415	55.1088	3167352.0
2018-09-20 15:00:00	AAPL	Stock	55.1088	55.1975	55.0675	55.16	3855372.0
2018-09-20 15:30:00	AAPL	Stock	55.155	55.19	54.9975	55.01	11728380.0
2018-09-20 16:00:00	AAPL	Stock	55.01	55.05	54.975	55.05	12193836.0
2018-09-20 16:30:00	AAPL	Stock	55.06	55.1775	55.0075	55.1075	574880.0
2018-09-20 17:00:00	AAPL	Stock	55.1475	55.1625	55.02	55.045	101004.0
2018-09-20 17:30:00	AAPL	Stock	55.0625	55.065	55.0075	55.0625	271564.0
2018-09-20 18:00:00	AAPL	Stock	55.0625	55.0625	55.0225	55.0375	11636.0
2018-09-20 18:30:00	AAPL	Stock	55.02	55.0375	54.98	55.0025	31740.0
2018-09-20 19:00:00	AAPL	Stock	55.0025	55.035	55.0025	55.0225	29072.0
2018-09-20 19:30:00	AAPL	Stock	55.0325	55.0475	55.0	55.0475	24160.0
2018-09-20 07:00:00	MSFT	Stock	112.16	112.16	112.01	112.14	300.0
2018-09-20 07:30:00	MSFT	Stock	112.14	112.25	112.14	112.19	1043.0
2018-09-20 08:00:00	MSFT	Stock	112.18	112.48	111.99	112.32	11969.0
2018-09-20 08:30:00	MSFT	Stock	112.32	112.47	112.32	112.4	8072.0
2018-09-20 09:00:00	MSFT	Stock	112.42	112.42	112.22	112.27	17415.0
2018-09-20 09:30:00	MSFT	Stock	112.29	113.14	111.93	113.14	3185236.0
2018-09-20 10:00:00	MSFT	Stock	113.15	113.72	113.105	113.53	2047900.0
2018-09-20 10:30:00	MSFT	Stock	113.525	113.8	113.41	113.575	1567578.0
2018-09-20 11:00:00	MSFT	Stock	113.58	113.73	113.515	113.68	915002.0
2018-09-20 11:30:00	MSFT	Stock	113.69	113.8	113.42	113.5	1067384.0
2018-09-20 12:00:00	MSFT	Stock	113.505	113.515	113.26	113.475	716405.0
2018-09-20 12:30:00	MSFT	Stock	113.48	113.53	113.38	113.4	628906.0
2018-09-20 13:00:00	MSFT	Stock	113.405	113.49	113.35	113.44	617468.0
2018-09-20 13:30:00	MSFT	Stock	113.44	113.49	113.27	113.38	661369.0
2018-09-20 14:00:00	MSFT	Stock	113.39	113.42	113.33	113.41	537934.0
2018-09-20 14:30:00	MSFT	Stock	113.41	113.5	113.365	113.48	691533.0
2018-09-20 15:00:00	MSFT	Stock	113.48	113.71	113.435	113.71	1256269.0
2018-09-20 15:30:00	MSFT	Stock	113.7	113.77	113.55	113.58	3386292.0
2018-09-20 16:00:00	MSFT	Stock	113.57	113.78	113.57	113.66	3570047.0
2018-09-20 16:30:00	MSFT	Stock	113.7	113.7	113.61	113.62	873.0

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

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