PREVIEW / stock_30min / 2019-05-24

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-05-24.parquet
  size:    1.6 MB
  rows:    81,569
  symbols: 2,590

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-05-24 04:00:00	AAPL	Stock	45.125	45.31	45.1175	45.25	5092.0
2019-05-24 04:30:00	AAPL	Stock	45.2825	45.2875	45.25	45.265	15412.0
2019-05-24 05:00:00	AAPL	Stock	45.25	45.275	45.25	45.2525	4292.0
2019-05-24 05:30:00	AAPL	Stock	45.2425	45.2425	45.175	45.175	1040.0
2019-05-24 06:00:00	AAPL	Stock	45.235	45.2675	45.225	45.2675	8364.0
2019-05-24 06:30:00	AAPL	Stock	45.2375	45.2375	45.18	45.2025	18756.0
2019-05-24 07:00:00	AAPL	Stock	45.1875	45.2475	45.1325	45.245	47172.0
2019-05-24 07:30:00	AAPL	Stock	45.24	45.25	44.88	45.02	195824.0
2019-05-24 08:00:00	AAPL	Stock	44.98	45.245	44.855	44.9975	268548.0
2019-05-24 08:30:00	AAPL	Stock	45.0025	45.0375	44.925	45.025	138164.0
2019-05-24 09:00:00	AAPL	Stock	45.025	45.1118	45.0	45.06	229556.0
2019-05-24 09:30:00	AAPL	Stock	45.0725	45.535	45.0325	45.3475	15513676.0
2019-05-24 10:00:00	AAPL	Stock	45.3425	45.4525	45.13	45.145	8925360.0
2019-05-24 10:30:00	AAPL	Stock	45.1475	45.215	44.9875	45.0475	5572344.0
2019-05-24 11:00:00	AAPL	Stock	45.0475	45.095	44.9125	44.9975	4840812.0
2019-05-24 11:30:00	AAPL	Stock	45.0	45.0675	44.97	45.0	4134860.0
2019-05-24 12:00:00	AAPL	Stock	45.0	45.0682	44.9275	45.0625	3669416.0
2019-05-24 12:30:00	AAPL	Stock	45.0625	45.125	45.045	45.1052	3132436.0
2019-05-24 13:00:00	AAPL	Stock	45.1125	45.1325	44.9575	44.9675	2894292.0
2019-05-24 13:30:00	AAPL	Stock	44.9675	45.045	44.895	44.91	2933368.0
2019-05-24 14:00:00	AAPL	Stock	44.91	44.9242	44.78	44.82	4857284.0
2019-05-24 14:30:00	AAPL	Stock	44.825	44.8762	44.8	44.8475	3127444.0
2019-05-24 15:00:00	AAPL	Stock	44.845	44.9397	44.805	44.935	4017716.0
2019-05-24 15:30:00	AAPL	Stock	44.9325	44.9325	44.655	44.765	11800508.0
2019-05-24 16:00:00	AAPL	Stock	44.7775	44.7775	44.6675	44.7175	6122568.0
2019-05-24 16:30:00	AAPL	Stock	44.72	44.75	44.715	44.7422	38236.0
2019-05-24 17:00:00	AAPL	Stock	44.7375	44.7425	44.7125	44.72	81884.0
2019-05-24 17:30:00	AAPL	Stock	44.7125	44.72	44.6625	44.6625	38888.0
2019-05-24 18:00:00	AAPL	Stock	44.65	44.6875	44.61	44.6875	21096.0
2019-05-24 18:30:00	AAPL	Stock	44.66	44.7125	44.66	44.7125	16112.0
2019-05-24 19:00:00	AAPL	Stock	44.64	44.64	44.64	44.64	400.0
2019-05-24 19:30:00	AAPL	Stock	44.6975	44.6975	44.5725	44.585	22092.0
2019-05-24 04:00:00	MSFT	Stock	127.6	127.6	127.21	127.21	300.0
2019-05-24 04:30:00	MSFT	Stock	127.21	127.3	127.2	127.3	2300.0
2019-05-24 05:30:00	MSFT	Stock	127.07	127.07	127.0	127.0	1400.0
2019-05-24 06:00:00	MSFT	Stock	127.2	127.3	127.17	127.3	1722.0
2019-05-24 06:30:00	MSFT	Stock	127.29	127.29	127.29	127.29	185.0
2019-05-24 07:00:00	MSFT	Stock	127.07	127.15	127.07	127.15	4890.0
2019-05-24 07:30:00	MSFT	Stock	127.15	127.15	126.78	126.78	12544.0
2019-05-24 08:00:00	MSFT	Stock	127.175	127.2	126.61	126.82	20389.0
2019-05-24 08:30:00	MSFT	Stock	126.88	126.91	126.64	126.88	12628.0
2019-05-24 09:00:00	MSFT	Stock	126.88	127.11	126.88	127.0	20463.0
2019-05-24 09:30:00	MSFT	Stock	126.93	127.415	126.62	126.84	2009860.0
2019-05-24 10:00:00	MSFT	Stock	126.85	126.98	126.48	126.49	963038.0
2019-05-24 10:30:00	MSFT	Stock	126.51	126.715	126.15	126.265	980160.0
2019-05-24 11:00:00	MSFT	Stock	126.28	126.565	126.24	126.41	725323.0
2019-05-24 11:30:00	MSFT	Stock	126.44	126.72	126.4	126.52	500807.0
2019-05-24 12:00:00	MSFT	Stock	126.52	126.74	126.4	126.73	558324.0
2019-05-24 12:30:00	MSFT	Stock	126.73	126.99	126.72	126.87	680222.0
2019-05-24 13:00:00	MSFT	Stock	126.88	126.93	126.53	126.55	417516.0

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

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