PREVIEW / stock_30min / 2020-05-15

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-05-15.parquet
  size:    1.8 MB
  rows:    92,814
  symbols: 2,354

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
2020-05-15 04:00:00	AAPL	Stock	77.775	77.8125	77.6075	77.6075	16036.0
2020-05-15 04:30:00	AAPL	Stock	77.6075	77.6075	77.455	77.455	1788.0
2020-05-15 05:00:00	AAPL	Stock	77.66	77.725	77.66	77.7075	7084.0
2020-05-15 05:30:00	AAPL	Stock	77.7475	77.7625	77.5925	77.5925	6220.0
2020-05-15 06:00:00	AAPL	Stock	77.5525	77.625	77.55	77.6025	13280.0
2020-05-15 06:30:00	AAPL	Stock	77.44	77.44	76.8	76.8	74832.0
2020-05-15 07:00:00	AAPL	Stock	76.875	76.9625	75.375	75.7325	684360.0
2020-05-15 07:30:00	AAPL	Stock	75.75	75.875	75.1875	75.3125	558280.0
2020-05-15 08:00:00	AAPL	Stock	75.3125	76.95	74.9375	75.3775	1217720.0
2020-05-15 08:30:00	AAPL	Stock	75.3525	75.4075	75.1472	75.3025	592564.0
2020-05-15 09:00:00	AAPL	Stock	75.3025	75.4675	74.95	75.0625	1362464.0
2020-05-15 09:30:00	AAPL	Stock	75.0875	76.1112	75.0525	75.995	26227060.0
2020-05-15 10:00:00	AAPL	Stock	76.01	76.53	75.91	76.2275	12792980.0
2020-05-15 10:30:00	AAPL	Stock	76.23	76.4648	75.955	76.0265	8955884.0
2020-05-15 11:00:00	AAPL	Stock	76.0225	76.0225	75.5725	75.7982	8582992.0
2020-05-15 11:30:00	AAPL	Stock	75.7925	75.8575	75.615	75.7712	5250556.0
2020-05-15 12:00:00	AAPL	Stock	75.7712	76.25	75.72	76.175	8022440.0
2020-05-15 12:30:00	AAPL	Stock	76.175	76.34	75.9725	76.2375	6801568.0
2020-05-15 13:00:00	AAPL	Stock	76.2325	76.5275	76.2175	76.4077	7188776.0
2020-05-15 13:30:00	AAPL	Stock	76.4	76.4575	76.16	76.375	5419300.0
2020-05-15 14:00:00	AAPL	Stock	76.3725	76.86	76.35	76.8025	7799064.0
2020-05-15 14:30:00	AAPL	Stock	76.8025	76.8375	76.3675	76.52	7268316.0
2020-05-15 15:00:00	AAPL	Stock	76.525	76.79	76.416	76.7125	8397508.0
2020-05-15 15:30:00	AAPL	Stock	76.71	76.975	76.555	76.935	13161048.0
2020-05-15 16:00:00	AAPL	Stock	76.9275	76.945	76.2053	76.605	5955376.0
2020-05-15 16:30:00	AAPL	Stock	76.6675	76.9275	76.65	76.7875	1096916.0
2020-05-15 17:00:00	AAPL	Stock	76.805	76.8625	76.765	76.775	58920.0
2020-05-15 17:30:00	AAPL	Stock	76.7675	76.8	76.765	76.78	13608.0
2020-05-15 18:00:00	AAPL	Stock	76.785	76.8	76.68	76.705	30476.0
2020-05-15 18:30:00	AAPL	Stock	76.68	76.7125	76.6275	76.6825	15552.0
2020-05-15 19:00:00	AAPL	Stock	76.7	76.7475	76.6375	76.665	18132.0
2020-05-15 19:30:00	AAPL	Stock	76.67	76.715	76.625	76.655	17620.0
2020-05-15 04:00:00	MSFT	Stock	181.52	181.85	181.52	181.83	2141.0
2020-05-15 04:30:00	MSFT	Stock	181.54	181.72	181.01	181.01	2358.0
2020-05-15 05:00:00	MSFT	Stock	181.46	181.61	181.46	181.61	2000.0
2020-05-15 05:30:00	MSFT	Stock	181.47	181.6	181.46	181.58	1486.0
2020-05-15 06:00:00	MSFT	Stock	181.25	181.6	181.22	181.6	1465.0
2020-05-15 06:30:00	MSFT	Stock	181.26	181.26	179.66	179.98	10830.0
2020-05-15 07:00:00	MSFT	Stock	180.21	180.21	178.49	179.54	35673.0
2020-05-15 07:30:00	MSFT	Stock	179.52	179.52	178.11	178.36	33832.0
2020-05-15 08:00:00	MSFT	Stock	179.1	179.85	178.04	178.8	39804.0
2020-05-15 08:30:00	MSFT	Stock	178.7	178.9	178.04	178.71	64386.0
2020-05-15 09:00:00	MSFT	Stock	178.8	180.64	178.21	179.1	295804.0
2020-05-15 09:30:00	MSFT	Stock	179.11	180.134	178.38	179.31	4647734.0
2020-05-15 10:00:00	MSFT	Stock	179.29	179.76	178.463	178.615	2039715.0
2020-05-15 10:30:00	MSFT	Stock	178.62	179.04	177.44	177.555	2068469.0
2020-05-15 11:00:00	MSFT	Stock	177.55	178.2	177.0	177.899	1864438.0
2020-05-15 11:30:00	MSFT	Stock	177.89	178.06	177.4	178.045	1499503.0
2020-05-15 12:00:00	MSFT	Stock	178.04	179.927	177.945	179.862	1942596.0
2020-05-15 12:30:00	MSFT	Stock	179.875	180.36	179.59	180.27	1829002.0

> showing 50 of 92,814 rows — these rows as CSV

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