PREVIEW / stock_30min / 2019-02-15

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-02-15.parquet
  size:    1.7 MB
  rows:    84,589
  symbols: 2,667

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-15 04:00:00	AAPL	Stock	42.37	42.37	42.2925	42.2925	5320.0
2019-02-15 04:30:00	AAPL	Stock	42.3275	42.3525	42.325	42.325	24820.0
2019-02-15 05:00:00	AAPL	Stock	42.3625	42.3625	42.3625	42.3625	800.0
2019-02-15 05:30:00	AAPL	Stock	42.4675	42.5175	42.4675	42.5175	3200.0
2019-02-15 06:00:00	AAPL	Stock	42.5475	42.615	42.515	42.525	6560.0
2019-02-15 06:30:00	AAPL	Stock	42.5	42.5	42.4575	42.4575	9748.0
2019-02-15 07:00:00	AAPL	Stock	42.46	42.565	42.45	42.5325	28252.0
2019-02-15 07:30:00	AAPL	Stock	42.5	42.6175	42.4825	42.5375	81064.0
2019-02-15 08:00:00	AAPL	Stock	42.455	42.5525	42.4075	42.435	171652.0
2019-02-15 08:30:00	AAPL	Stock	42.45	42.6175	42.415	42.6025	281112.0
2019-02-15 09:00:00	AAPL	Stock	42.5975	42.965	42.575	42.8075	992780.0
2019-02-15 09:30:00	AAPL	Stock	42.805	42.925	42.4375	42.615	21099748.0
2019-02-15 10:00:00	AAPL	Stock	42.6225	42.75	42.5275	42.7175	7301428.0
2019-02-15 10:30:00	AAPL	Stock	42.7225	42.7975	42.59	42.61	6892480.0
2019-02-15 11:00:00	AAPL	Stock	42.61	42.66	42.465	42.5462	5880664.0
2019-02-15 11:30:00	AAPL	Stock	42.5425	42.5822	42.46	42.5325	3624708.0
2019-02-15 12:00:00	AAPL	Stock	42.5325	42.6575	42.4875	42.6425	3336868.0
2019-02-15 12:30:00	AAPL	Stock	42.6412	42.6412	42.4975	42.507	2882528.0
2019-02-15 13:00:00	AAPL	Stock	42.505	42.5475	42.4825	42.495	3178104.0
2019-02-15 13:30:00	AAPL	Stock	42.4975	42.525	42.4925	42.515	2275052.0
2019-02-15 14:00:00	AAPL	Stock	42.515	42.5725	42.5125	42.54	2677380.0
2019-02-15 14:30:00	AAPL	Stock	42.5375	42.62	42.5275	42.605	3086540.0
2019-02-15 15:00:00	AAPL	Stock	42.6	42.605	42.515	42.575	3782228.0
2019-02-15 15:30:00	AAPL	Stock	42.5775	42.64	42.4675	42.595	11559004.0
2019-02-15 16:00:00	AAPL	Stock	42.595	42.61	42.5525	42.6	8424280.0
2019-02-15 16:30:00	AAPL	Stock	42.6	42.61	42.595	42.595	76620.0
2019-02-15 17:00:00	AAPL	Stock	42.595	42.6075	42.59	42.605	21144.0
2019-02-15 17:30:00	AAPL	Stock	42.5975	42.6	42.5975	42.6	5332.0
2019-02-15 18:00:00	AAPL	Stock	42.5975	42.625	42.59	42.625	30700.0
2019-02-15 18:30:00	AAPL	Stock	42.6075	42.625	42.6025	42.625	8600.0
2019-02-15 19:00:00	AAPL	Stock	42.6	42.605	42.59	42.605	23128.0
2019-02-15 19:30:00	AAPL	Stock	42.6	42.625	42.5925	42.625	13072.0
2019-02-15 04:30:00	MSFT	Stock	106.61	106.7	106.61	106.7	1647.0
2019-02-15 05:30:00	MSFT	Stock	106.8	107.01	106.8	107.01	1396.0
2019-02-15 06:00:00	MSFT	Stock	107.0	107.17	106.9	107.17	2032.0
2019-02-15 07:00:00	MSFT	Stock	106.91	106.99	106.9	106.99	2838.0
2019-02-15 07:30:00	MSFT	Stock	107.0	107.29	107.0	107.18	12578.0
2019-02-15 08:00:00	MSFT	Stock	107.08	107.33	107.08	107.16	11045.0
2019-02-15 08:30:00	MSFT	Stock	107.16	107.4	107.11	107.32	13025.0
2019-02-15 09:00:00	MSFT	Stock	107.25	108.08	107.2	107.8	359679.0
2019-02-15 09:30:00	MSFT	Stock	107.82	108.3	107.615	107.73	6825686.0
2019-02-15 10:00:00	MSFT	Stock	107.74	108.23	107.64	108.16	1805419.0
2019-02-15 10:30:00	MSFT	Stock	108.165	108.29	107.76	107.81	1695807.0
2019-02-15 11:00:00	MSFT	Stock	107.815	107.95	107.362	107.68	1442667.0
2019-02-15 11:30:00	MSFT	Stock	107.68	107.77	107.42	107.625	878216.0
2019-02-15 12:00:00	MSFT	Stock	107.63	107.82	107.54	107.71	625505.0
2019-02-15 12:30:00	MSFT	Stock	107.713	107.77	107.56	107.65	639387.0
2019-02-15 13:00:00	MSFT	Stock	107.645	107.72	107.52	107.54	530067.0
2019-02-15 13:30:00	MSFT	Stock	107.54	107.72	107.53	107.655	711662.0
2019-02-15 14:00:00	MSFT	Stock	107.65	107.93	107.65	107.87	951849.0

> showing 50 of 84,589 rows — these rows as CSV

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