PREVIEW / stock_30min / 2019-09-11

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-09-11.parquet
  size:    1.7 MB
  rows:    86,616
  symbols: 2,565

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-09-11 04:00:00	AAPL	Stock	54.2975	54.415	54.25	54.25	30740.0
2019-09-11 04:30:00	AAPL	Stock	54.295	54.3425	54.2625	54.2625	10780.0
2019-09-11 05:00:00	AAPL	Stock	54.1925	54.1925	54.1325	54.175	8648.0
2019-09-11 05:30:00	AAPL	Stock	54.2	54.2475	54.155	54.2475	32460.0
2019-09-11 06:00:00	AAPL	Stock	54.22	54.2875	54.205	54.2875	6564.0
2019-09-11 06:30:00	AAPL	Stock	54.275	54.275	54.21	54.21	8488.0
2019-09-11 07:00:00	AAPL	Stock	54.25	54.3375	54.21	54.335	125284.0
2019-09-11 07:30:00	AAPL	Stock	54.325	54.37	54.2875	54.35	224548.0
2019-09-11 08:00:00	AAPL	Stock	54.35	54.4125	54.2275	54.3975	415472.0
2019-09-11 08:30:00	AAPL	Stock	54.41	54.4425	54.3675	54.425	265584.0
2019-09-11 09:00:00	AAPL	Stock	54.425	54.5625	54.175	54.505	734348.0
2019-09-11 09:30:00	AAPL	Stock	54.53	55.1975	54.4325	55.025	34392704.0
2019-09-11 10:00:00	AAPL	Stock	55.0212	55.21	54.9625	55.0075	13716044.0
2019-09-11 10:30:00	AAPL	Stock	55.005	55.1875	54.9825	55.095	8184396.0
2019-09-11 11:00:00	AAPL	Stock	55.0975	55.2425	55.05	55.2138	6659548.0
2019-09-11 11:30:00	AAPL	Stock	55.215	55.625	55.215	55.553	14660664.0
2019-09-11 12:00:00	AAPL	Stock	55.5525	55.7375	55.52	55.5848	8479436.0
2019-09-11 12:30:00	AAPL	Stock	55.5855	55.75	55.5812	55.6625	6344404.0
2019-09-11 13:00:00	AAPL	Stock	55.665	55.79	55.6075	55.6125	7292728.0
2019-09-11 13:30:00	AAPL	Stock	55.6162	55.6825	55.5275	55.603	6413688.0
2019-09-11 14:00:00	AAPL	Stock	55.607	55.65	55.515	55.545	4406680.0
2019-09-11 14:30:00	AAPL	Stock	55.545	55.575	55.43	55.5675	5572836.0
2019-09-11 15:00:00	AAPL	Stock	55.5675	55.67	55.5625	55.625	5427032.0
2019-09-11 15:30:00	AAPL	Stock	55.6262	55.91	55.6225	55.8968	16634928.0
2019-09-11 16:00:00	AAPL	Stock	55.8975	55.9325	55.3578	55.925	8346848.0
2019-09-11 16:30:00	AAPL	Stock	55.925	55.97	55.8975	55.95	339888.0
2019-09-11 17:00:00	AAPL	Stock	55.95	55.9625	55.9125	55.92	54576.0
2019-09-11 17:30:00	AAPL	Stock	55.915	55.95	55.915	55.9375	20700.0
2019-09-11 18:00:00	AAPL	Stock	55.9375	55.975	55.93	55.975	41972.0
2019-09-11 18:30:00	AAPL	Stock	55.965	55.985	55.9375	55.965	38256.0
2019-09-11 19:00:00	AAPL	Stock	55.95	56.25	55.94	56.25	401360.0
2019-09-11 19:30:00	AAPL	Stock	56.2275	56.42	56.1675	56.4075	459364.0
2019-09-11 04:00:00	MSFT	Stock	136.14	136.5	136.14	136.34	1402.0
2019-09-11 05:00:00	MSFT	Stock	136.23	136.23	136.0	136.0	400.0
2019-09-11 05:30:00	MSFT	Stock	136.09	136.2	136.08	136.2	1011.0
2019-09-11 06:00:00	MSFT	Stock	136.38	136.38	136.38	136.38	278.0
2019-09-11 06:30:00	MSFT	Stock	136.24	136.24	136.24	136.24	100.0
2019-09-11 07:00:00	MSFT	Stock	136.1	136.4	136.1	136.4	3004.0
2019-09-11 07:30:00	MSFT	Stock	136.45	136.55	136.4	136.55	7268.0
2019-09-11 08:00:00	MSFT	Stock	136.18	136.59	136.0	136.54	21970.0
2019-09-11 08:30:00	MSFT	Stock	136.52	136.52	136.29	136.45	8394.0
2019-09-11 09:00:00	MSFT	Stock	136.4	136.57	135.59	135.89	102678.0
2019-09-11 09:30:00	MSFT	Stock	135.89	136.22	135.11	135.84	2981085.0
2019-09-11 10:00:00	MSFT	Stock	135.84	136.11	135.57	135.75	1576196.0
2019-09-11 10:30:00	MSFT	Stock	135.75	136.0	135.175	135.27	1160107.0
2019-09-11 11:00:00	MSFT	Stock	135.28	135.53	135.09	135.48	985773.0
2019-09-11 11:30:00	MSFT	Stock	135.49	135.69	135.45	135.515	1272062.0
2019-09-11 12:00:00	MSFT	Stock	135.515	135.74	135.47	135.51	1115985.0
2019-09-11 12:30:00	MSFT	Stock	135.505	135.68	135.16	135.58	970844.0
2019-09-11 13:00:00	MSFT	Stock	135.58	135.84	135.49	135.71	614197.0

> showing 50 of 86,616 rows — these rows as CSV

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