PREVIEW / stock_30min / 2018-09-27

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-09-27.parquet
  size:    1.7 MB
  rows:    83,719
  symbols: 2,775

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-09-27 04:00:00	AAPL	Stock	55.37	55.455	55.37	55.455	1200.0
2018-09-27 04:30:00	AAPL	Stock	55.495	55.6125	55.495	55.6125	7960.0
2018-09-27 05:00:00	AAPL	Stock	55.625	55.69	55.6	55.6025	24740.0
2018-09-27 05:30:00	AAPL	Stock	55.6625	55.6925	55.6025	55.6925	12932.0
2018-09-27 06:00:00	AAPL	Stock	55.65	55.72	55.6275	55.71	30836.0
2018-09-27 06:30:00	AAPL	Stock	55.71	55.75	55.71	55.7175	20072.0
2018-09-27 07:00:00	AAPL	Stock	55.725	55.875	55.65	55.8375	253620.0
2018-09-27 07:30:00	AAPL	Stock	55.8375	55.9475	55.7825	55.94	294696.0
2018-09-27 08:00:00	AAPL	Stock	55.9375	55.975	55.66	55.91	627720.0
2018-09-27 08:30:00	AAPL	Stock	55.9125	55.9675	55.8275	55.95	325780.0
2018-09-27 09:00:00	AAPL	Stock	55.9375	55.99	55.84	55.9475	513624.0
2018-09-27 09:30:00	AAPL	Stock	55.9475	56.47	55.885	56.275	22108488.0
2018-09-27 10:00:00	AAPL	Stock	56.2798	56.485	56.25	56.305	8822796.0
2018-09-27 10:30:00	AAPL	Stock	56.3025	56.37	56.225	56.335	6516884.0
2018-09-27 11:00:00	AAPL	Stock	56.3375	56.42	56.2275	56.2975	4899204.0
2018-09-27 11:30:00	AAPL	Stock	56.29	56.3665	56.2525	56.3375	2767620.0
2018-09-27 12:00:00	AAPL	Stock	56.3325	56.4075	56.275	56.3975	3171464.0
2018-09-27 12:30:00	AAPL	Stock	56.3975	56.46	56.3325	56.4575	3122196.0
2018-09-27 13:00:00	AAPL	Stock	56.4578	56.535	56.415	56.53	4533044.0
2018-09-27 13:30:00	AAPL	Stock	56.53	56.61	56.4625	56.515	4191360.0
2018-09-27 14:00:00	AAPL	Stock	56.5152	56.52	56.3275	56.34	4034440.0
2018-09-27 14:30:00	AAPL	Stock	56.3435	56.3625	56.2325	56.2605	4869424.0
2018-09-27 15:00:00	AAPL	Stock	56.2625	56.31	56.2338	56.25	5171904.0
2018-09-27 15:30:00	AAPL	Stock	56.2532	56.375	56.155	56.2725	12837960.0
2018-09-27 16:00:00	AAPL	Stock	56.29	56.29	56.18	56.1875	12630324.0
2018-09-27 16:30:00	AAPL	Stock	56.1775	56.2375	56.175	56.2175	60576.0
2018-09-27 17:00:00	AAPL	Stock	56.2125	56.2225	56.1925	56.1975	22616.0
2018-09-27 17:30:00	AAPL	Stock	56.2	56.2175	56.1825	56.21	14080.0
2018-09-27 18:00:00	AAPL	Stock	56.205	56.2225	56.1775	56.2125	48956.0
2018-09-27 18:30:00	AAPL	Stock	56.2225	56.2225	56.1875	56.1875	23364.0
2018-09-27 19:00:00	AAPL	Stock	56.2125	56.225	56.18	56.2	72648.0
2018-09-27 19:30:00	AAPL	Stock	56.225	56.235	56.1875	56.2	35560.0
2018-09-27 04:00:00	MSFT	Stock	114.04	114.04	114.04	114.04	108.0
2018-09-27 06:30:00	MSFT	Stock	114.01	114.02	114.01	114.01	923.0
2018-09-27 07:00:00	MSFT	Stock	114.08	114.22	114.05	114.1	3110.0
2018-09-27 07:30:00	MSFT	Stock	114.2	114.2	114.1	114.12	3365.0
2018-09-27 08:00:00	MSFT	Stock	114.2	114.3	114.11	114.13	12501.0
2018-09-27 08:30:00	MSFT	Stock	114.13	114.5	114.06	114.29	14737.0
2018-09-27 09:00:00	MSFT	Stock	114.35	114.7	114.29	114.69	11698.0
2018-09-27 09:30:00	MSFT	Stock	114.78	114.889	114.2	114.545	1729548.0
2018-09-27 10:00:00	MSFT	Stock	114.55	114.83	114.52	114.54	1191909.0
2018-09-27 10:30:00	MSFT	Stock	114.535	114.69	114.38	114.69	841307.0
2018-09-27 11:00:00	MSFT	Stock	114.69	114.9	114.591	114.627	954641.0
2018-09-27 11:30:00	MSFT	Stock	114.63	114.76	114.57	114.748	459800.0
2018-09-27 12:00:00	MSFT	Stock	114.745	114.82	114.59	114.81	413031.0
2018-09-27 12:30:00	MSFT	Stock	114.81	114.815	114.7	114.719	501252.0
2018-09-27 13:00:00	MSFT	Stock	114.71	114.74	114.6	114.72	360097.0
2018-09-27 13:30:00	MSFT	Stock	114.73	114.79	114.65	114.78	447017.0
2018-09-27 14:00:00	MSFT	Stock	114.775	114.91	114.66	114.82	561382.0
2018-09-27 14:30:00	MSFT	Stock	114.825	114.87	114.6	114.62	714896.0

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

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