PREVIEW / stock_30min / 2019-07-16

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-07-16.parquet
  size:    1.7 MB
  rows:    84,001
  symbols: 2,598

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-16 04:00:00	AAPL	Stock	51.25	51.36	51.25	51.275	6160.0
2019-07-16 05:30:00	AAPL	Stock	51.2625	51.295	51.2625	51.295	5980.0
2019-07-16 06:30:00	AAPL	Stock	51.2475	51.285	51.2475	51.275	10344.0
2019-07-16 07:00:00	AAPL	Stock	51.285	51.345	51.285	51.3375	61040.0
2019-07-16 07:30:00	AAPL	Stock	51.36	51.38	51.3275	51.35	34604.0
2019-07-16 08:00:00	AAPL	Stock	51.38	51.3825	51.2775	51.3325	90448.0
2019-07-16 08:30:00	AAPL	Stock	51.3175	51.3225	51.2725	51.2725	56196.0
2019-07-16 09:00:00	AAPL	Stock	51.285	51.3025	51.035	51.185	199808.0
2019-07-16 09:30:00	AAPL	Stock	51.185	51.5275	51.0025	51.4975	8924840.0
2019-07-16 10:00:00	AAPL	Stock	51.4975	51.5075	51.365	51.4575	3837076.0
2019-07-16 10:30:00	AAPL	Stock	51.459	51.493	51.3625	51.4175	2449992.0
2019-07-16 11:00:00	AAPL	Stock	51.4175	51.4325	51.239	51.265	3282228.0
2019-07-16 11:30:00	AAPL	Stock	51.265	51.2975	51.205	51.2175	2383952.0
2019-07-16 12:00:00	AAPL	Stock	51.2165	51.2175	50.875	50.9475	5467876.0
2019-07-16 12:30:00	AAPL	Stock	50.9525	51.0325	50.945	51.0	2685408.0
2019-07-16 13:00:00	AAPL	Stock	51.0	51.1375	50.9963	51.0788	2735940.0
2019-07-16 13:30:00	AAPL	Stock	51.0775	51.09	50.925	50.9338	2467596.0
2019-07-16 14:00:00	AAPL	Stock	50.9325	51.03	50.93	51.014	2272956.0
2019-07-16 14:30:00	AAPL	Stock	51.015	51.0975	50.9662	51.075	2587656.0
2019-07-16 15:00:00	AAPL	Stock	51.075	51.215	51.0625	51.15	3584844.0
2019-07-16 15:30:00	AAPL	Stock	51.145	51.2325	51.06	51.1225	5703520.0
2019-07-16 16:00:00	AAPL	Stock	51.125	51.125	51.0375	51.085	3719792.0
2019-07-16 16:30:00	AAPL	Stock	51.085	51.125	51.0375	51.0375	19952.0
2019-07-16 17:00:00	AAPL	Stock	51.0375	51.0575	51.0375	51.0575	2796.0
2019-07-16 17:30:00	AAPL	Stock	51.05	51.05	51.05	51.05	3464.0
2019-07-16 18:00:00	AAPL	Stock	51.0125	51.15	51.0125	51.0775	32084.0
2019-07-16 18:30:00	AAPL	Stock	51.06	51.075	51.05	51.075	7128.0
2019-07-16 19:00:00	AAPL	Stock	51.075	51.075	51.0625	51.0625	7860.0
2019-07-16 19:30:00	AAPL	Stock	51.0625	51.0625	51.0475	51.0475	16456.0
2019-07-16 05:00:00	MSFT	Stock	139.0	139.0	139.0	139.0	100.0
2019-07-16 05:30:00	MSFT	Stock	139.0	139.0	139.0	139.0	1200.0
2019-07-16 06:00:00	MSFT	Stock	139.22	139.22	139.11	139.11	250.0
2019-07-16 06:30:00	MSFT	Stock	139.11	139.11	139.11	139.11	100.0
2019-07-16 07:00:00	MSFT	Stock	139.05	139.08	138.96	139.06	7704.0
2019-07-16 07:30:00	MSFT	Stock	139.06	139.17	139.0	139.17	6827.0
2019-07-16 08:00:00	MSFT	Stock	139.01	139.24	139.01	139.08	9770.0
2019-07-16 08:30:00	MSFT	Stock	139.08	139.23	139.0	139.09	11920.0
2019-07-16 09:00:00	MSFT	Stock	139.0	139.09	138.69	138.88	30682.0
2019-07-16 09:30:00	MSFT	Stock	138.88	139.05	138.42	138.505	2162396.0
2019-07-16 10:00:00	MSFT	Stock	138.51	138.535	137.305	137.735	2243118.0
2019-07-16 10:30:00	MSFT	Stock	137.735	137.835	137.525	137.59	1332418.0
2019-07-16 11:00:00	MSFT	Stock	137.6	137.63	137.09	137.144	1559498.0
2019-07-16 11:30:00	MSFT	Stock	137.14	137.311	137.07	137.094	936068.0
2019-07-16 12:00:00	MSFT	Stock	137.09	137.18	136.52	136.91	1692438.0
2019-07-16 12:30:00	MSFT	Stock	136.91	137.274	136.85	137.21	883320.0
2019-07-16 13:00:00	MSFT	Stock	137.21	137.46	137.21	137.283	772019.0
2019-07-16 13:30:00	MSFT	Stock	137.28	137.45	136.79	136.82	707607.0
2019-07-16 14:00:00	MSFT	Stock	136.815	137.06	136.66	136.72	1094767.0
2019-07-16 14:30:00	MSFT	Stock	136.72	137.03	136.59	136.935	924112.0
2019-07-16 15:00:00	MSFT	Stock	136.93	137.05	136.9	136.95	1091193.0

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

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