PREVIEW / stock_30min / 2018-05-30

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-05-30.parquet
  size:    1.7 MB
  rows:    84,544
  symbols: 2,821

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-05-30 04:00:00	AAPL	Stock	47.05	47.1375	47.05	47.1375	3356.0
2018-05-30 05:00:00	AAPL	Stock	47.0275	47.1175	47.0275	47.1175	5832.0
2018-05-30 05:30:00	AAPL	Stock	47.1375	47.14	47.1375	47.14	4656.0
2018-05-30 06:00:00	AAPL	Stock	47.13	47.13	47.125	47.125	4900.0
2018-05-30 06:30:00	AAPL	Stock	47.125	47.155	47.1075	47.1075	9456.0
2018-05-30 07:00:00	AAPL	Stock	47.105	47.145	46.9525	46.9525	138428.0
2018-05-30 07:30:00	AAPL	Stock	46.99	47.0475	46.9675	46.9875	78088.0
2018-05-30 08:00:00	AAPL	Stock	47.1	47.125	46.9525	47.0	188872.0
2018-05-30 08:30:00	AAPL	Stock	47.0025	47.0025	46.9025	46.91	135288.0
2018-05-30 09:00:00	AAPL	Stock	46.9075	46.95	46.84	46.905	145776.0
2018-05-30 09:30:00	AAPL	Stock	46.91	47.0	46.765	46.78	8841200.0
2018-05-30 10:00:00	AAPL	Stock	46.78	46.845	46.695	46.73	6226096.0
2018-05-30 10:30:00	AAPL	Stock	46.7325	46.8525	46.7	46.765	5214312.0
2018-05-30 11:00:00	AAPL	Stock	46.7675	46.8225	46.705	46.71	3448716.0
2018-05-30 11:30:00	AAPL	Stock	46.7088	46.8025	46.7025	46.7775	3741168.0
2018-05-30 12:00:00	AAPL	Stock	46.7775	46.885	46.7525	46.85	3984456.0
2018-05-30 12:30:00	AAPL	Stock	46.8478	46.86	46.7825	46.805	3108096.0
2018-05-30 13:00:00	AAPL	Stock	46.8068	46.85	46.7425	46.83	3613284.0
2018-05-30 13:30:00	AAPL	Stock	46.8312	46.8775	46.815	46.835	2413332.0
2018-05-30 14:00:00	AAPL	Stock	46.8425	46.875	46.8275	46.85	2556596.0
2018-05-30 14:30:00	AAPL	Stock	46.85	46.8975	46.84	46.885	2876752.0
2018-05-30 15:00:00	AAPL	Stock	46.885	46.9175	46.8025	46.8112	3235764.0
2018-05-30 15:30:00	AAPL	Stock	46.8125	46.9275	46.775	46.875	8321012.0
2018-05-30 16:00:00	AAPL	Stock	46.86	46.875	46.8425	46.855	4835140.0
2018-05-30 16:30:00	AAPL	Stock	46.8575	46.875	46.8375	46.8375	67932.0
2018-05-30 17:00:00	AAPL	Stock	46.8375	46.8625	46.825	46.8375	24228.0
2018-05-30 18:00:00	AAPL	Stock	46.8175	46.845	46.7675	46.77	32864.0
2018-05-30 18:30:00	AAPL	Stock	46.775	46.8	46.775	46.8	2740.0
2018-05-30 19:00:00	AAPL	Stock	46.8	46.8	46.765	46.8	23184.0
2018-05-30 19:30:00	AAPL	Stock	46.795	46.8	46.7875	46.7925	8072.0
2018-05-30 04:00:00	MSFT	Stock	98.5	98.5	98.5	98.5	259.0
2018-05-30 05:30:00	MSFT	Stock	98.6	98.6	98.6	98.6	300.0
2018-05-30 06:30:00	MSFT	Stock	98.53	98.6	98.52	98.6	1003.0
2018-05-30 07:00:00	MSFT	Stock	98.51	98.74	98.45	98.6	4518.0
2018-05-30 07:30:00	MSFT	Stock	98.6	98.6	98.5	98.5	800.0
2018-05-30 08:00:00	MSFT	Stock	98.79	98.79	98.42	98.51	3829.0
2018-05-30 08:30:00	MSFT	Stock	98.48	98.5	98.4	98.4	11527.0
2018-05-30 09:00:00	MSFT	Stock	98.45	98.5	98.31	98.4	27544.0
2018-05-30 09:30:00	MSFT	Stock	98.31	99.25	98.3	98.46	3129327.0
2018-05-30 10:00:00	MSFT	Stock	98.46	98.46	97.91	98.04	2270032.0
2018-05-30 10:30:00	MSFT	Stock	98.04	98.59	98.04	98.51	1539218.0
2018-05-30 11:00:00	MSFT	Stock	98.505	98.67	98.42	98.46	1097613.0
2018-05-30 11:30:00	MSFT	Stock	98.46	98.86	98.45	98.796	904018.0
2018-05-30 12:00:00	MSFT	Stock	98.8	98.93	98.74	98.84	830100.0
2018-05-30 12:30:00	MSFT	Stock	98.83	98.88	98.66	98.8	631417.0
2018-05-30 13:00:00	MSFT	Stock	98.8	99.039	98.65	98.92	994939.0
2018-05-30 13:30:00	MSFT	Stock	98.91	98.98	98.79	98.865	675877.0
2018-05-30 14:00:00	MSFT	Stock	98.87	98.98	98.81	98.94	839610.0
2018-05-30 14:30:00	MSFT	Stock	98.94	99.06	98.81	98.845	836679.0
2018-05-30 15:00:00	MSFT	Stock	98.85	98.93	98.81	98.906	785501.0

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

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