PREVIEW / stock_30min / 2019-10-30

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-10-30.parquet
  size:    1.7 MB
  rows:    84,207
  symbols: 2,503

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-10-30 04:00:00	AAPL	Stock	60.9575	60.9575	60.7525	60.835	13444.0
2019-10-30 04:30:00	AAPL	Stock	60.875	60.88	60.8725	60.8725	3756.0
2019-10-30 05:00:00	AAPL	Stock	60.8725	60.8725	60.8725	60.8725	400.0
2019-10-30 05:30:00	AAPL	Stock	60.8675	60.9575	60.8475	60.9575	15064.0
2019-10-30 06:00:00	AAPL	Stock	60.95	61.0	60.95	61.0	800.0
2019-10-30 06:30:00	AAPL	Stock	61.03	61.04	61.0	61.0	9684.0
2019-10-30 07:00:00	AAPL	Stock	60.975	61.0125	60.975	61.0125	49200.0
2019-10-30 07:30:00	AAPL	Stock	61.0375	61.25	61.0	61.2125	178564.0
2019-10-30 08:00:00	AAPL	Stock	61.0	61.245	60.9725	61.2	198396.0
2019-10-30 08:30:00	AAPL	Stock	61.2225	61.3425	61.1875	61.32	265288.0
2019-10-30 09:00:00	AAPL	Stock	61.325	61.3975	61.1425	61.2375	440080.0
2019-10-30 09:30:00	AAPL	Stock	61.1925	61.325	60.5775	60.89	15871840.0
2019-10-30 10:00:00	AAPL	Stock	60.885	60.9975	60.625	60.765	6210580.0
2019-10-30 10:30:00	AAPL	Stock	60.7625	60.83	60.6648	60.75	4227456.0
2019-10-30 11:00:00	AAPL	Stock	60.7525	60.81	60.59	60.6398	5129520.0
2019-10-30 11:30:00	AAPL	Stock	60.64	60.6475	60.3025	60.5125	6416900.0
2019-10-30 12:00:00	AAPL	Stock	60.5125	60.6575	60.4325	60.6325	4194092.0
2019-10-30 12:30:00	AAPL	Stock	60.6325	60.7425	60.525	60.5725	4015768.0
2019-10-30 13:00:00	AAPL	Stock	60.5725	60.6125	60.4525	60.4875	3263512.0
2019-10-30 13:30:00	AAPL	Stock	60.49	60.5975	60.385	60.415	3837552.0
2019-10-30 14:00:00	AAPL	Stock	60.405	60.7125	60.325	60.57	5751000.0
2019-10-30 14:30:00	AAPL	Stock	60.57	60.6825	60.4625	60.67	5522200.0
2019-10-30 15:00:00	AAPL	Stock	60.67	60.9375	60.645	60.9225	7190584.0
2019-10-30 15:30:00	AAPL	Stock	60.9225	60.9225	60.7525	60.8225	12829432.0
2019-10-30 16:00:00	AAPL	Stock	60.815	61.2875	60.815	61.25	4907428.0
2019-10-30 16:30:00	AAPL	Stock	61.27	63.125	61.06	61.5625	9585248.0
2019-10-30 17:00:00	AAPL	Stock	61.5675	62.185	61.5	61.85	2239268.0
2019-10-30 17:30:00	AAPL	Stock	61.8525	62.1	61.75	62.05	771380.0
2019-10-30 18:00:00	AAPL	Stock	62.065	62.065	61.875	61.925	281696.0
2019-10-30 18:30:00	AAPL	Stock	61.9125	61.9625	61.9125	61.9375	152164.0
2019-10-30 19:00:00	AAPL	Stock	61.9375	61.96	61.9	61.96	138864.0
2019-10-30 19:30:00	AAPL	Stock	61.9525	62.0625	61.925	62.0475	218992.0
2019-10-30 04:00:00	MSFT	Stock	142.9	142.9	142.9	142.9	460.0
2019-10-30 05:00:00	MSFT	Stock	143.08	143.08	143.08	143.08	123.0
2019-10-30 05:30:00	MSFT	Stock	143.25	143.25	143.19	143.19	200.0
2019-10-30 06:30:00	MSFT	Stock	143.19	143.2	143.19	143.2	1106.0
2019-10-30 07:00:00	MSFT	Stock	143.29	143.29	142.94	143.1	781.0
2019-10-30 07:30:00	MSFT	Stock	143.1	143.12	143.02	143.02	1175.0
2019-10-30 08:00:00	MSFT	Stock	143.15	143.18	142.61	142.9	16682.0
2019-10-30 08:30:00	MSFT	Stock	142.93	143.1	142.93	143.05	3176.0
2019-10-30 09:00:00	MSFT	Stock	143.01	143.69	143.01	143.52	35290.0
2019-10-30 09:30:00	MSFT	Stock	143.45	143.72	143.07	143.32	1969676.0
2019-10-30 10:00:00	MSFT	Stock	143.315	143.6	142.79	143.54	1627804.0
2019-10-30 10:30:00	MSFT	Stock	143.54	143.89	143.28	143.8	936182.0
2019-10-30 11:00:00	MSFT	Stock	143.79	143.86	143.5	143.63	923075.0
2019-10-30 11:30:00	MSFT	Stock	143.629	143.754	143.564	143.629	613018.0
2019-10-30 12:00:00	MSFT	Stock	143.63	143.88	143.55	143.72	499165.0
2019-10-30 12:30:00	MSFT	Stock	143.73	143.91	143.7	143.715	440912.0
2019-10-30 13:00:00	MSFT	Stock	143.715	143.84	143.61	143.72	440745.0
2019-10-30 13:30:00	MSFT	Stock	143.72	143.85	143.39	143.46	569421.0

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

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