PREVIEW / stock_30min / 2018-06-27

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-06-27.parquet
  size:    1.7 MB
  rows:    84,965
  symbols: 2,815

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-06-27 04:00:00	AAPL	Stock	45.9725	45.9725	45.625	45.625	39840.0
2018-06-27 04:30:00	AAPL	Stock	45.625	45.6325	45.625	45.625	10360.0
2018-06-27 05:00:00	AAPL	Stock	45.7	45.8075	45.7	45.8	7292.0
2018-06-27 05:30:00	AAPL	Stock	45.8	45.92	45.8	45.92	13184.0
2018-06-27 06:00:00	AAPL	Stock	45.85	45.8625	45.85	45.8625	4272.0
2018-06-27 06:30:00	AAPL	Stock	45.8575	45.925	45.8575	45.875	28264.0
2018-06-27 07:00:00	AAPL	Stock	45.9125	45.965	45.825	45.8725	64988.0
2018-06-27 07:30:00	AAPL	Stock	45.825	46.28	45.8	46.1975	191940.0
2018-06-27 08:00:00	AAPL	Stock	46.22	46.48	45.8	46.2725	338652.0
2018-06-27 08:30:00	AAPL	Stock	46.2875	46.44	46.205	46.205	162008.0
2018-06-27 09:00:00	AAPL	Stock	46.2275	46.375	46.2275	46.31	94548.0
2018-06-27 09:30:00	AAPL	Stock	46.307	46.61	46.295	46.59	9316144.0
2018-06-27 10:00:00	AAPL	Stock	46.585	46.71	46.505	46.6675	5776096.0
2018-06-27 10:30:00	AAPL	Stock	46.6678	46.82	46.655	46.6675	5435960.0
2018-06-27 11:00:00	AAPL	Stock	46.6725	46.78	46.5525	46.635	6643552.0
2018-06-27 11:30:00	AAPL	Stock	46.6375	46.735	46.5825	46.6975	4334564.0
2018-06-27 12:00:00	AAPL	Stock	46.69	46.735	46.565	46.5725	3233720.0
2018-06-27 12:30:00	AAPL	Stock	46.5725	46.59	46.31	46.3125	5265096.0
2018-06-27 13:00:00	AAPL	Stock	46.3175	46.3725	46.09	46.2575	6731676.0
2018-06-27 13:30:00	AAPL	Stock	46.255	46.3425	46.1225	46.255	4520304.0
2018-06-27 14:00:00	AAPL	Stock	46.25	46.3575	46.1625	46.2325	4226124.0
2018-06-27 14:30:00	AAPL	Stock	46.2275	46.395	46.1728	46.23	4091636.0
2018-06-27 15:00:00	AAPL	Stock	46.235	46.355	46.125	46.3275	6070336.0
2018-06-27 15:30:00	AAPL	Stock	46.3262	46.36	46.0075	46.0412	13511436.0
2018-06-27 16:00:00	AAPL	Stock	46.04	46.2	46.04	46.045	8626392.0
2018-06-27 16:30:00	AAPL	Stock	46.035	46.928	46.015	46.928	468748.0
2018-06-27 17:00:00	AAPL	Stock	46.045	46.0775	46.025	46.04	16244.0
2018-06-27 17:30:00	AAPL	Stock	46.0475	46.0975	46.0475	46.0925	6544.0
2018-06-27 18:00:00	AAPL	Stock	46.075	46.075	46.04	46.0625	6392.0
2018-06-27 18:30:00	AAPL	Stock	46.09	46.1325	46.05	46.065	50708.0
2018-06-27 19:00:00	AAPL	Stock	46.0975	46.1	46.085	46.1	8812.0
2018-06-27 19:30:00	AAPL	Stock	46.0975	46.16	46.075	46.16	29964.0
2018-06-27 04:00:00	MSFT	Stock	99.0	99.0	98.3	98.3	2034.0
2018-06-27 05:00:00	MSFT	Stock	97.81	97.81	97.7	97.7	301.0
2018-06-27 07:00:00	MSFT	Stock	98.58	98.61	98.31	98.6	14659.0
2018-06-27 07:30:00	MSFT	Stock	98.5	99.46	98.5	99.1	4835.0
2018-06-27 08:00:00	MSFT	Stock	98.5	99.57	98.45	99.15	11613.0
2018-06-27 08:30:00	MSFT	Stock	99.3	99.482	99.13	99.15	14438.0
2018-06-27 09:00:00	MSFT	Stock	99.22	99.6	99.22	99.33	51440.0
2018-06-27 09:30:00	MSFT	Stock	99.33	99.94	99.32	99.61	2625362.0
2018-06-27 10:00:00	MSFT	Stock	99.6	99.61	99.15	99.47	1613949.0
2018-06-27 10:30:00	MSFT	Stock	99.48	99.89	99.45	99.61	1525596.0
2018-06-27 11:00:00	MSFT	Stock	99.62	100.02	99.34	99.49	2290375.0
2018-06-27 11:30:00	MSFT	Stock	99.48	99.6	99.28	99.406	1088355.0
2018-06-27 12:00:00	MSFT	Stock	99.41	99.55	99.24	99.24	864051.0
2018-06-27 12:30:00	MSFT	Stock	99.25	99.27	98.8	98.801	962291.0
2018-06-27 13:00:00	MSFT	Stock	98.807	98.99	98.251	98.545	1358680.0
2018-06-27 13:30:00	MSFT	Stock	98.54	98.74	98.03	98.25	1278671.0
2018-06-27 14:00:00	MSFT	Stock	98.25	98.47	98.02	98.21	1096672.0
2018-06-27 14:30:00	MSFT	Stock	98.21	98.575	98.03	98.1	1113984.0

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

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