PREVIEW / stock_30min / 2019-07-25

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-07-25.parquet
  size:    1.7 MB
  rows:    84,101
  symbols: 2,552

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-07-25 04:00:00	AAPL	Stock	52.15	52.21	52.15	52.21	5904.0
2019-07-25 04:30:00	AAPL	Stock	52.1925	52.1925	52.1925	52.1925	796.0
2019-07-25 05:00:00	AAPL	Stock	52.175	52.175	52.1575	52.1675	8524.0
2019-07-25 05:30:00	AAPL	Stock	52.165	52.1675	52.165	52.1675	5440.0
2019-07-25 06:00:00	AAPL	Stock	52.175	52.175	52.0575	52.0575	2408.0
2019-07-25 06:30:00	AAPL	Stock	52.03	52.0875	52.03	52.0875	5200.0
2019-07-25 07:00:00	AAPL	Stock	52.0875	52.1525	52.0875	52.1525	28596.0
2019-07-25 07:30:00	AAPL	Stock	52.1325	52.25	52.13	52.24	39736.0
2019-07-25 08:00:00	AAPL	Stock	52.125	52.325	52.0375	52.2875	100872.0
2019-07-25 08:30:00	AAPL	Stock	52.3075	52.3325	52.25	52.2575	162304.0
2019-07-25 09:00:00	AAPL	Stock	52.27	52.27	52.06	52.1775	154876.0
2019-07-25 09:30:00	AAPL	Stock	52.18	52.31	51.9325	52.0825	8034500.0
2019-07-25 10:00:00	AAPL	Stock	52.0875	52.1675	52.0168	52.11	3428628.0
2019-07-25 10:30:00	AAPL	Stock	52.1225	52.2225	52.106	52.134	3069324.0
2019-07-25 11:00:00	AAPL	Stock	52.1275	52.1725	51.9825	52.0225	2566448.0
2019-07-25 11:30:00	AAPL	Stock	52.0235	52.0975	51.9725	52.0865	1955288.0
2019-07-25 12:00:00	AAPL	Stock	52.0888	52.09	51.985	52.0115	1646732.0
2019-07-25 12:30:00	AAPL	Stock	52.0112	52.0375	51.83	51.88	3209168.0
2019-07-25 13:00:00	AAPL	Stock	51.875	51.8775	51.78	51.8438	1759708.0
2019-07-25 13:30:00	AAPL	Stock	51.8425	51.9035	51.805	51.82	2331416.0
2019-07-25 14:00:00	AAPL	Stock	51.815	51.958	51.815	51.9038	1935164.0
2019-07-25 14:30:00	AAPL	Stock	51.905	51.92	51.7925	51.805	1670056.0
2019-07-25 15:00:00	AAPL	Stock	51.8025	51.84	51.7	51.8225	2599012.0
2019-07-25 15:30:00	AAPL	Stock	51.8225	51.839	51.6825	51.7625	6038092.0
2019-07-25 16:00:00	AAPL	Stock	51.755	51.84	51.755	51.7875	5574660.0
2019-07-25 16:30:00	AAPL	Stock	51.7825	51.7925	51.675	51.75	69104.0
2019-07-25 17:00:00	AAPL	Stock	51.755	51.765	51.725	51.7525	55808.0
2019-07-25 17:30:00	AAPL	Stock	51.7525	51.78	51.725	51.775	74680.0
2019-07-25 18:00:00	AAPL	Stock	51.775	51.8	51.7575	51.8	12484.0
2019-07-25 18:30:00	AAPL	Stock	51.7875	51.815	51.7775	51.78	11072.0
2019-07-25 19:00:00	AAPL	Stock	51.8225	51.835	51.8225	51.835	800.0
2019-07-25 19:30:00	AAPL	Stock	51.795	51.815	51.79	51.7925	45460.0
2019-07-25 04:00:00	MSFT	Stock	140.99	141.0	140.91	141.0	1400.0
2019-07-25 05:30:00	MSFT	Stock	141.1	141.11	141.04	141.04	450.0
2019-07-25 06:00:00	MSFT	Stock	141.09	141.09	140.6	140.6	1170.0
2019-07-25 06:30:00	MSFT	Stock	140.58	140.6	140.49	140.6	1963.0
2019-07-25 07:00:00	MSFT	Stock	140.6	140.62	140.46	140.62	6844.0
2019-07-25 07:30:00	MSFT	Stock	140.71	141.0	140.68	140.96	14044.0
2019-07-25 08:00:00	MSFT	Stock	140.61	140.98	140.55	140.95	17859.0
2019-07-25 08:30:00	MSFT	Stock	140.93	140.95	140.73	140.87	8724.0
2019-07-25 09:00:00	MSFT	Stock	140.88	140.89	140.1	140.21	37046.0
2019-07-25 09:30:00	MSFT	Stock	140.43	140.47	139.322	139.752	2745138.0
2019-07-25 10:00:00	MSFT	Stock	139.76	140.09	139.67	139.87	1316524.0
2019-07-25 10:30:00	MSFT	Stock	139.89	140.595	139.885	140.44	1212814.0
2019-07-25 11:00:00	MSFT	Stock	140.43	140.61	140.13	140.335	877278.0
2019-07-25 11:30:00	MSFT	Stock	140.34	140.53	140.11	140.33	658533.0
2019-07-25 12:00:00	MSFT	Stock	140.33	140.49	140.153	140.3	568212.0
2019-07-25 12:30:00	MSFT	Stock	140.305	140.34	139.538	139.81	1337119.0
2019-07-25 13:00:00	MSFT	Stock	139.82	139.96	139.71	139.955	535600.0
2019-07-25 13:30:00	MSFT	Stock	139.97	140.28	139.95	139.98	638375.0

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

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