PREVIEW / stock_30min / 2018-07-19

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-07-19.parquet
  size:    1.7 MB
  rows:    83,089
  symbols: 2,812

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-07-19 06:00:00	AAPL	Stock	47.55	47.5525	47.475	47.5	25956.0
2018-07-19 06:30:00	AAPL	Stock	47.4875	47.4875	47.4875	47.4875	3400.0
2018-07-19 07:00:00	AAPL	Stock	47.5375	47.625	47.5375	47.5625	118676.0
2018-07-19 07:30:00	AAPL	Stock	47.55	47.5975	47.5	47.5	156572.0
2018-07-19 08:00:00	AAPL	Stock	47.5188	47.5975	47.4375	47.4375	55448.0
2018-07-19 08:30:00	AAPL	Stock	47.4725	47.5025	47.4375	47.4525	98292.0
2018-07-19 09:00:00	AAPL	Stock	47.445	47.4925	47.425	47.425	90616.0
2018-07-19 09:30:00	AAPL	Stock	47.425	48.045	47.4225	47.8847	11853092.0
2018-07-19 10:00:00	AAPL	Stock	47.885	47.885	47.7525	47.8475	4179528.0
2018-07-19 10:30:00	AAPL	Stock	47.845	47.93	47.755	47.9175	3641580.0
2018-07-19 11:00:00	AAPL	Stock	47.9125	48.0825	47.9075	48.0475	5635308.0
2018-07-19 11:30:00	AAPL	Stock	48.05	48.1375	48.0425	48.12	4574096.0
2018-07-19 12:00:00	AAPL	Stock	48.1175	48.125	47.9903	48.0425	2872944.0
2018-07-19 12:30:00	AAPL	Stock	48.04	48.06	47.92	47.9912	2606556.0
2018-07-19 13:00:00	AAPL	Stock	47.99	48.125	47.94	48.085	3793456.0
2018-07-19 13:30:00	AAPL	Stock	48.0875	48.1325	48.0325	48.085	2077260.0
2018-07-19 14:00:00	AAPL	Stock	48.0875	48.125	48.0325	48.0425	2325692.0
2018-07-19 14:30:00	AAPL	Stock	48.0425	48.105	47.9825	48.0275	2831652.0
2018-07-19 15:00:00	AAPL	Stock	48.0275	48.0425	47.93	48.0225	2806552.0
2018-07-19 15:30:00	AAPL	Stock	48.0225	48.0775	47.9125	47.9925	6949644.0
2018-07-19 16:00:00	AAPL	Stock	47.99	48.0125	47.9375	47.9925	11695120.0
2018-07-19 16:30:00	AAPL	Stock	47.9975	48.08	47.97	48.025	114396.0
2018-07-19 17:00:00	AAPL	Stock	48.05	48.0625	48.03	48.0625	31792.0
2018-07-19 17:30:00	AAPL	Stock	48.04	48.04	48.005	48.01	20528.0
2018-07-19 18:00:00	AAPL	Stock	48.0375	48.05	47.99	48.0175	74904.0
2018-07-19 18:30:00	AAPL	Stock	48.0425	48.0475	48.0	48.0475	30740.0
2018-07-19 19:00:00	AAPL	Stock	48.0375	48.0475	48.025	48.0475	24396.0
2018-07-19 19:30:00	AAPL	Stock	48.05	48.0625	48.0225	48.045	13276.0
2018-07-19 04:00:00	MSFT	Stock	105.4	105.4	104.75	104.75	1700.0
2018-07-19 04:30:00	MSFT	Stock	105.2	105.2	105.05	105.15	2384.0
2018-07-19 05:30:00	MSFT	Stock	105.15	105.25	105.15	105.15	2346.0
2018-07-19 06:00:00	MSFT	Stock	105.15	105.15	105.0	105.0	2665.0
2018-07-19 06:30:00	MSFT	Stock	104.82	104.82	104.65	104.65	9131.0
2018-07-19 07:00:00	MSFT	Stock	104.88	104.95	104.8	104.89	13949.0
2018-07-19 07:30:00	MSFT	Stock	104.92	105.07	104.57	104.65	23022.0
2018-07-19 08:00:00	MSFT	Stock	104.94	105.35	104.56	104.71	40780.0
2018-07-19 08:30:00	MSFT	Stock	104.7	104.86	104.67	104.86	6800.0
2018-07-19 09:00:00	MSFT	Stock	104.85	105.2	104.75	105.0	77445.0
2018-07-19 09:30:00	MSFT	Stock	104.93	105.31	104.18	104.48	4246051.0
2018-07-19 10:00:00	MSFT	Stock	104.485	104.71	104.28	104.57	1838275.0
2018-07-19 10:30:00	MSFT	Stock	104.56	105.03	104.43	104.925	1892137.0
2018-07-19 11:00:00	MSFT	Stock	104.94	105.07	104.85	104.99	1524715.0
2018-07-19 11:30:00	MSFT	Stock	104.99	105.23	104.87	105.125	1394500.0
2018-07-19 12:00:00	MSFT	Stock	105.13	105.17	104.67	104.69	1287080.0
2018-07-19 12:30:00	MSFT	Stock	104.694	104.84	104.355	104.517	1360781.0
2018-07-19 13:00:00	MSFT	Stock	104.51	104.82	104.39	104.67	1460005.0
2018-07-19 13:30:00	MSFT	Stock	104.68	104.84	104.64	104.645	1010349.0
2018-07-19 14:00:00	MSFT	Stock	104.646	104.7	104.37	104.49	1430609.0
2018-07-19 14:30:00	MSFT	Stock	104.5	104.61	104.21	104.24	1481923.0
2018-07-19 15:00:00	MSFT	Stock	104.24	104.29	103.89	104.09	2634447.0

> showing 50 of 83,089 rows — these rows as CSV

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