PREVIEW / stock_30min / 2018-08-23

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-08-23.parquet
  size:    1.6 MB
  rows:    81,370
  symbols: 2,787

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-08-23 04:00:00	AAPL	Stock	53.8125	53.8125	53.7725	53.7725	1384.0
2018-08-23 05:30:00	AAPL	Stock	53.8725	53.8725	53.8625	53.8625	3524.0
2018-08-23 06:00:00	AAPL	Stock	53.8475	53.8475	53.8175	53.82	5200.0
2018-08-23 06:30:00	AAPL	Stock	53.7675	53.8425	53.7675	53.8175	4000.0
2018-08-23 07:00:00	AAPL	Stock	53.82	53.85	53.7575	53.7575	65348.0
2018-08-23 07:30:00	AAPL	Stock	53.76	53.7875	53.76	53.7875	15900.0
2018-08-23 08:00:00	AAPL	Stock	53.8468	53.8468	53.7125	53.7425	120440.0
2018-08-23 08:30:00	AAPL	Stock	53.725	53.745	53.6875	53.73	66152.0
2018-08-23 09:00:00	AAPL	Stock	53.7325	53.77	53.65	53.65	116716.0
2018-08-23 09:30:00	AAPL	Stock	53.68	54.2625	53.65	54.19	10882516.0
2018-08-23 10:00:00	AAPL	Stock	54.19	54.2425	54.06	54.2125	5970376.0
2018-08-23 10:30:00	AAPL	Stock	54.215	54.2175	53.9825	53.9885	3941912.0
2018-08-23 11:00:00	AAPL	Stock	53.9875	54.0178	53.7775	53.845	5207528.0
2018-08-23 11:30:00	AAPL	Stock	53.8475	53.945	53.7825	53.86	3583388.0
2018-08-23 12:00:00	AAPL	Stock	53.8625	54.105	53.8475	54.0875	4297628.0
2018-08-23 12:30:00	AAPL	Stock	54.0885	54.1125	53.985	54.0075	2610480.0
2018-08-23 13:00:00	AAPL	Stock	54.0075	54.065	53.9625	54.0552	1938128.0
2018-08-23 13:30:00	AAPL	Stock	54.0562	54.0575	53.9675	53.9898	1714828.0
2018-08-23 14:00:00	AAPL	Stock	53.9875	54.1712	53.9875	54.1375	3173816.0
2018-08-23 14:30:00	AAPL	Stock	54.1355	54.1525	54.08	54.125	2619676.0
2018-08-23 15:00:00	AAPL	Stock	54.125	54.1375	54.06	54.095	2287984.0
2018-08-23 15:30:00	AAPL	Stock	54.0975	54.115	53.7875	53.895	9209284.0
2018-08-23 16:00:00	AAPL	Stock	53.8925	53.935	53.8725	53.8825	7825704.0
2018-08-23 16:30:00	AAPL	Stock	53.89	53.9125	53.8825	53.9125	25060.0
2018-08-23 17:00:00	AAPL	Stock	53.9025	53.925	53.9	53.9225	56956.0
2018-08-23 17:30:00	AAPL	Stock	53.9075	53.925	53.9075	53.925	2628.0
2018-08-23 18:00:00	AAPL	Stock	53.9125	53.94	53.9	53.9375	9912.0
2018-08-23 18:30:00	AAPL	Stock	53.9025	53.95	53.9025	53.95	3200.0
2018-08-23 19:00:00	AAPL	Stock	53.945	53.945	53.9425	53.9425	2404.0
2018-08-23 19:30:00	AAPL	Stock	53.9425	53.975	53.925	53.925	23700.0
2018-08-23 04:00:00	MSFT	Stock	107.01	107.01	107.01	107.01	100.0
2018-08-23 07:00:00	MSFT	Stock	107.05	107.05	107.05	107.05	300.0
2018-08-23 07:30:00	MSFT	Stock	107.0	107.06	106.92	107.05	10751.0
2018-08-23 08:00:00	MSFT	Stock	107.01	107.07	107.0	107.01	8914.0
2018-08-23 08:30:00	MSFT	Stock	107.01	107.02	106.82	106.9	6099.0
2018-08-23 09:00:00	MSFT	Stock	106.9	107.09	106.74	107.09	25313.0
2018-08-23 09:30:00	MSFT	Stock	107.15	108.08	106.87	107.98	2390602.0
2018-08-23 10:00:00	MSFT	Stock	107.99	108.18	107.81	108.13	1257265.0
2018-08-23 10:30:00	MSFT	Stock	108.13	108.18	107.83	107.89	846006.0
2018-08-23 11:00:00	MSFT	Stock	107.89	107.935	107.19	107.38	1178966.0
2018-08-23 11:30:00	MSFT	Stock	107.39	107.525	107.09	107.29	834631.0
2018-08-23 12:00:00	MSFT	Stock	107.29	107.72	107.29	107.695	659486.0
2018-08-23 12:30:00	MSFT	Stock	107.69	107.81	107.59	107.645	478146.0
2018-08-23 13:00:00	MSFT	Stock	107.645	107.83	107.575	107.825	487402.0
2018-08-23 13:30:00	MSFT	Stock	107.829	108.049	107.73	108.02	620945.0
2018-08-23 14:00:00	MSFT	Stock	108.03	108.18	107.982	108.025	1005708.0
2018-08-23 14:30:00	MSFT	Stock	108.025	108.04	107.82	107.925	633581.0
2018-08-23 15:00:00	MSFT	Stock	107.92	107.98	107.78	107.885	602061.0
2018-08-23 15:30:00	MSFT	Stock	107.89	107.91	107.345	107.56	2521341.0
2018-08-23 16:00:00	MSFT	Stock	107.56	107.808	107.0	107.12	2402775.0

> showing 50 of 81,370 rows — these rows as CSV

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