PREVIEW / stock_30min / 2019-06-25

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-06-25.parquet
  size:    1.7 MB
  rows:    84,507
  symbols: 2,612

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-06-25 04:00:00	AAPL	Stock	49.5625	49.5625	49.465	49.465	800.0
2019-06-25 04:30:00	AAPL	Stock	49.4	49.4	49.4	49.4	2000.0
2019-06-25 05:00:00	AAPL	Stock	49.395	49.4925	49.395	49.4575	12088.0
2019-06-25 05:30:00	AAPL	Stock	49.4375	49.4725	49.4375	49.4725	3120.0
2019-06-25 06:00:00	AAPL	Stock	49.4175	49.4175	49.41	49.41	2396.0
2019-06-25 06:30:00	AAPL	Stock	49.4725	49.4725	49.4725	49.4725	400.0
2019-06-25 07:00:00	AAPL	Stock	49.4725	49.615	49.4725	49.5275	17912.0
2019-06-25 07:30:00	AAPL	Stock	49.5525	49.5525	49.5125	49.5375	22240.0
2019-06-25 08:00:00	AAPL	Stock	49.55	49.625	49.4725	49.6075	48532.0
2019-06-25 08:30:00	AAPL	Stock	49.6025	49.6875	49.6025	49.6675	50680.0
2019-06-25 09:00:00	AAPL	Stock	49.6875	49.695	49.5625	49.615	48260.0
2019-06-25 09:30:00	AAPL	Stock	49.65	49.815	49.5825	49.6275	7991632.0
2019-06-25 10:00:00	AAPL	Stock	49.6325	49.67	49.41	49.56	5998228.0
2019-06-25 10:30:00	AAPL	Stock	49.5575	49.5875	49.45	49.5625	4175144.0
2019-06-25 11:00:00	AAPL	Stock	49.5625	49.605	49.43	49.435	3753768.0
2019-06-25 11:30:00	AAPL	Stock	49.435	49.5225	49.4	49.445	2250532.0
2019-06-25 12:00:00	AAPL	Stock	49.4412	49.5225	49.3925	49.4775	2299432.0
2019-06-25 12:30:00	AAPL	Stock	49.4775	49.505	49.2525	49.3412	2962196.0
2019-06-25 13:00:00	AAPL	Stock	49.3425	49.375	49.1625	49.3468	3682224.0
2019-06-25 13:30:00	AAPL	Stock	49.3475	49.4425	49.305	49.315	2431324.0
2019-06-25 14:00:00	AAPL	Stock	49.3138	49.3625	49.2575	49.2675	2236816.0
2019-06-25 14:30:00	AAPL	Stock	49.2625	49.2725	49.0075	49.0675	4206696.0
2019-06-25 15:00:00	AAPL	Stock	49.07	49.105	48.8375	48.92	4998524.0
2019-06-25 15:30:00	AAPL	Stock	48.9175	49.05	48.8225	48.8925	9187972.0
2019-06-25 16:00:00	AAPL	Stock	48.8925	49.0	48.8925	48.9625	8047252.0
2019-06-25 16:30:00	AAPL	Stock	48.9625	49.0	48.8925	48.9875	51684.0
2019-06-25 17:00:00	AAPL	Stock	49.0	49.0275	48.9975	48.9975	24208.0
2019-06-25 17:30:00	AAPL	Stock	49.0	49.0	48.955	48.9875	13480.0
2019-06-25 18:00:00	AAPL	Stock	48.9875	49.0225	48.9625	48.9625	28796.0
2019-06-25 18:30:00	AAPL	Stock	48.9725	48.9725	48.9375	48.945	10488.0
2019-06-25 19:00:00	AAPL	Stock	48.965	48.965	48.91	48.91	17136.0
2019-06-25 19:30:00	AAPL	Stock	48.91	48.9425	48.8925	48.905	27072.0
2019-06-25 04:00:00	MSFT	Stock	137.5	137.5	137.35	137.35	3939.0
2019-06-25 04:30:00	MSFT	Stock	137.45	137.45	137.45	137.45	610.0
2019-06-25 05:00:00	MSFT	Stock	137.3	137.3	137.3	137.3	100.0
2019-06-25 05:30:00	MSFT	Stock	137.3	137.5	137.3	137.5	1338.0
2019-06-25 06:00:00	MSFT	Stock	137.49	137.49	137.35	137.35	600.0
2019-06-25 06:30:00	MSFT	Stock	137.2	137.41	137.2	137.41	2292.0
2019-06-25 07:00:00	MSFT	Stock	137.45	137.51	137.2	137.3	10378.0
2019-06-25 07:30:00	MSFT	Stock	137.37	137.54	137.31	137.53	12827.0
2019-06-25 08:00:00	MSFT	Stock	137.35	137.65	137.27	137.31	13778.0
2019-06-25 08:30:00	MSFT	Stock	137.31	137.5	137.15	137.37	18466.0
2019-06-25 09:00:00	MSFT	Stock	137.35	137.41	137.19	137.37	25546.0
2019-06-25 09:30:00	MSFT	Stock	137.25	137.59	136.06	136.22	3173298.0
2019-06-25 10:00:00	MSFT	Stock	136.23	136.28	135.36	135.6	2465067.0
2019-06-25 10:30:00	MSFT	Stock	135.61	135.76	134.575	134.655	2695277.0
2019-06-25 11:00:00	MSFT	Stock	134.66	135.21	134.47	134.89	1791174.0
2019-06-25 11:30:00	MSFT	Stock	134.9	134.95	134.51	134.53	1017367.0
2019-06-25 12:00:00	MSFT	Stock	134.527	134.77	134.49	134.54	1163584.0
2019-06-25 12:30:00	MSFT	Stock	134.54	134.58	133.71	133.94	2088242.0

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

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