PREVIEW / stock_30min / 2018-07-25

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-07-25.parquet
  size:    1.7 MB
  rows:    83,146
  symbols: 2,808

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-25 06:00:00	AAPL	Stock	48.2525	48.2525	48.2525	48.2525	536.0
2018-07-25 06:30:00	AAPL	Stock	48.2225	48.2225	48.2225	48.2225	624.0
2018-07-25 07:00:00	AAPL	Stock	48.225	48.225	48.225	48.225	5200.0
2018-07-25 07:30:00	AAPL	Stock	48.2125	48.225	48.1275	48.1775	25500.0
2018-07-25 08:00:00	AAPL	Stock	48.25	48.2975	48.1475	48.1875	25000.0
2018-07-25 08:30:00	AAPL	Stock	48.1875	48.2125	48.175	48.2125	17856.0
2018-07-25 09:00:00	AAPL	Stock	48.2025	48.2325	48.19	48.2325	35648.0
2018-07-25 09:30:00	AAPL	Stock	48.265	48.4125	48.215	48.3125	6662956.0
2018-07-25 10:00:00	AAPL	Stock	48.3075	48.325	48.1625	48.2275	3754900.0
2018-07-25 10:30:00	AAPL	Stock	48.23	48.2975	48.1075	48.185	3433852.0
2018-07-25 11:00:00	AAPL	Stock	48.1825	48.265	48.1425	48.2625	2432700.0
2018-07-25 11:30:00	AAPL	Stock	48.2625	48.37	48.2475	48.37	3732684.0
2018-07-25 12:00:00	AAPL	Stock	48.37	48.49	48.36	48.4825	3687156.0
2018-07-25 12:30:00	AAPL	Stock	48.4825	48.5025	48.4375	48.4525	3240696.0
2018-07-25 13:00:00	AAPL	Stock	48.4525	48.475	48.355	48.3865	1879672.0
2018-07-25 13:30:00	AAPL	Stock	48.3862	48.4775	48.38	48.4538	1766812.0
2018-07-25 14:00:00	AAPL	Stock	48.455	48.495	48.4025	48.4325	2454284.0
2018-07-25 14:30:00	AAPL	Stock	48.435	48.4775	48.4225	48.43	2152128.0
2018-07-25 15:00:00	AAPL	Stock	48.4275	48.4425	48.3825	48.4335	2188820.0
2018-07-25 15:30:00	AAPL	Stock	48.435	48.7125	48.405	48.705	13658204.0
2018-07-25 16:00:00	AAPL	Stock	48.705	48.705	48.4625	48.55	7545808.0
2018-07-25 16:30:00	AAPL	Stock	48.5275	48.6075	48.5275	48.6	64128.0
2018-07-25 17:00:00	AAPL	Stock	48.6	48.61	48.425	48.44	78348.0
2018-07-25 17:30:00	AAPL	Stock	48.44	48.49	47.925	48.1225	402668.0
2018-07-25 18:00:00	AAPL	Stock	48.155	48.3675	48.15	48.25	277920.0
2018-07-25 18:30:00	AAPL	Stock	48.225	48.2625	48.215	48.23	211260.0
2018-07-25 19:00:00	AAPL	Stock	48.23	48.3	48.2125	48.27	42764.0
2018-07-25 19:30:00	AAPL	Stock	48.275	48.3	48.2125	48.2125	52032.0
2018-07-25 05:00:00	MSFT	Stock	107.64	107.64	107.64	107.64	566.0
2018-07-25 06:00:00	MSFT	Stock	107.64	107.64	107.64	107.64	100.0
2018-07-25 07:00:00	MSFT	Stock	107.63	107.63	107.6	107.6	400.0
2018-07-25 07:30:00	MSFT	Stock	107.6	107.6	107.4	107.41	1588.0
2018-07-25 08:00:00	MSFT	Stock	107.622	107.9	107.41	107.85	17320.0
2018-07-25 08:30:00	MSFT	Stock	107.66	107.75	107.6	107.75	2802.0
2018-07-25 09:00:00	MSFT	Stock	107.77	107.97	107.6	107.97	9139.0
2018-07-25 09:30:00	MSFT	Stock	107.92	108.25	107.6	108.17	2410535.0
2018-07-25 10:00:00	MSFT	Stock	108.16	108.32	107.91	108.25	1384056.0
2018-07-25 10:30:00	MSFT	Stock	108.25	108.59	108.25	108.4	1451488.0
2018-07-25 11:00:00	MSFT	Stock	108.41	109.03	108.36	109.007	1846821.0
2018-07-25 11:30:00	MSFT	Stock	109.01	109.22	108.86	109.04	1639027.0
2018-07-25 12:00:00	MSFT	Stock	109.04	109.24	108.88	109.18	1156176.0
2018-07-25 12:30:00	MSFT	Stock	109.18	109.55	109.17	109.445	1280774.0
2018-07-25 13:00:00	MSFT	Stock	109.445	109.51	109.2	109.27	810619.0
2018-07-25 13:30:00	MSFT	Stock	109.27	109.55	109.215	109.536	1368807.0
2018-07-25 14:00:00	MSFT	Stock	109.53	109.76	109.5	109.65	1304994.0
2018-07-25 14:30:00	MSFT	Stock	109.65	109.95	109.1	109.92	1824066.0
2018-07-25 15:00:00	MSFT	Stock	109.912	110.2	109.75	110.06	2389391.0
2018-07-25 15:30:00	MSFT	Stock	110.06	111.15	109.99	110.82	6320415.0
2018-07-25 16:00:00	MSFT	Stock	110.83	110.83	108.985	110.54	2991359.0
2018-07-25 16:30:00	MSFT	Stock	110.3	110.6	110.3	110.5	15987.0

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

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