PREVIEW / stock_30min / 2018-05-08

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-05-08.parquet
  size:    1.7 MB
  rows:    83,258
  symbols: 2,846

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-08 04:00:00	AAPL	Stock	46.29	46.29	46.29	46.29	600.0
2018-05-08 04:30:00	AAPL	Stock	46.1725	46.1725	46.1625	46.1625	2000.0
2018-05-08 05:00:00	AAPL	Stock	46.0875	46.0875	46.0875	46.0875	1600.0
2018-05-08 05:30:00	AAPL	Stock	46.0875	46.1125	46.05	46.1125	9200.0
2018-05-08 06:00:00	AAPL	Stock	46.075	46.0875	46.065	46.0875	16400.0
2018-05-08 06:30:00	AAPL	Stock	46.08	46.1025	46.08	46.1025	2400.0
2018-05-08 07:00:00	AAPL	Stock	46.0875	46.1075	46.04	46.1025	110648.0
2018-05-08 07:30:00	AAPL	Stock	46.12	46.235	46.1125	46.2	109900.0
2018-05-08 08:00:00	AAPL	Stock	46.1625	46.2525	46.04	46.2525	310840.0
2018-05-08 08:30:00	AAPL	Stock	46.2525	46.2975	46.23	46.2975	203952.0
2018-05-08 09:00:00	AAPL	Stock	46.3	46.315	46.2025	46.2425	319172.0
2018-05-08 09:30:00	AAPL	Stock	46.2475	46.27	45.9162	46.0948	14886636.0
2018-05-08 10:00:00	AAPL	Stock	46.095	46.3025	46.0775	46.2375	8746300.0
2018-05-08 10:30:00	AAPL	Stock	46.2362	46.4125	46.23	46.291	7772492.0
2018-05-08 11:00:00	AAPL	Stock	46.2878	46.555	46.24	46.38	8098768.0
2018-05-08 11:30:00	AAPL	Stock	46.38	46.448	46.255	46.3025	5041576.0
2018-05-08 12:00:00	AAPL	Stock	46.3	46.4	46.25	46.375	3434420.0
2018-05-08 12:30:00	AAPL	Stock	46.3725	46.4075	46.215	46.2825	3565344.0
2018-05-08 13:00:00	AAPL	Stock	46.28	46.3725	46.26	46.355	2998776.0
2018-05-08 13:30:00	AAPL	Stock	46.3525	46.3625	46.25	46.265	3493584.0
2018-05-08 14:00:00	AAPL	Stock	46.265	46.4575	46.2525	46.3488	6159084.0
2018-05-08 14:30:00	AAPL	Stock	46.3525	46.3638	46.115	46.2425	7197644.0
2018-05-08 15:00:00	AAPL	Stock	46.24	46.42	46.1612	46.3787	5757028.0
2018-05-08 15:30:00	AAPL	Stock	46.38	46.5175	46.365	46.51	9302008.0
2018-05-08 16:00:00	AAPL	Stock	46.5125	46.5125	46.16	46.5125	13580992.0
2018-05-08 16:30:00	AAPL	Stock	46.4925	46.5125	46.4875	46.5075	34424.0
2018-05-08 17:00:00	AAPL	Stock	46.495	46.5125	46.4875	46.495	31916.0
2018-05-08 17:30:00	AAPL	Stock	46.4875	46.51	46.485	46.49	11408.0
2018-05-08 18:00:00	AAPL	Stock	46.4875	46.5175	46.4875	46.5175	93692.0
2018-05-08 18:30:00	AAPL	Stock	46.515	46.52	46.5	46.52	13360.0
2018-05-08 19:00:00	AAPL	Stock	46.505	46.505	46.49	46.505	24808.0
2018-05-08 19:30:00	AAPL	Stock	46.5125	46.525	46.49	46.5	29256.0
2018-05-08 04:00:00	MSFT	Stock	96.03	96.03	96.03	96.03	100.0
2018-05-08 05:00:00	MSFT	Stock	96.01	96.01	96.01	96.01	661.0
2018-05-08 06:00:00	MSFT	Stock	96.01	96.01	96.01	96.01	100.0
2018-05-08 06:30:00	MSFT	Stock	96.1	96.1	95.9	95.9	300.0
2018-05-08 07:00:00	MSFT	Stock	95.99	96.0	95.72	95.72	1656.0
2018-05-08 07:30:00	MSFT	Stock	95.92	95.92	95.92	95.92	200.0
2018-05-08 08:00:00	MSFT	Stock	95.78	96.41	95.78	95.92	19443.0
2018-05-08 08:30:00	MSFT	Stock	95.91	96.13	95.9	96.12	7332.0
2018-05-08 09:00:00	MSFT	Stock	96.12	96.15	95.87	95.87	14379.0
2018-05-08 09:30:00	MSFT	Stock	95.87	96.09	95.21	95.45	2366709.0
2018-05-08 10:00:00	MSFT	Stock	95.455	95.66	95.36	95.44	1179818.0
2018-05-08 10:30:00	MSFT	Stock	95.43	95.95	95.42	95.637	1248559.0
2018-05-08 11:00:00	MSFT	Stock	95.64	96.16	95.51	95.82	1264722.0
2018-05-08 11:30:00	MSFT	Stock	95.825	95.83	95.51	95.635	1143975.0
2018-05-08 12:00:00	MSFT	Stock	95.64	95.72	95.47	95.54	743340.0
2018-05-08 12:30:00	MSFT	Stock	95.54	95.57	95.12	95.21	856234.0
2018-05-08 13:00:00	MSFT	Stock	95.2	95.64	95.145	95.62	971357.0
2018-05-08 13:30:00	MSFT	Stock	95.63	95.75	95.48	95.565	853058.0

> showing 50 of 83,258 rows — these rows as CSV

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