PREVIEW / stock_30min / 2018-02-07

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-02-07.parquet
  size:    1.7 MB
  rows:    85,326
  symbols: 2,901

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-02-07 04:00:00	AAPL	Stock	40.4125	40.45	40.325	40.45	23060.0
2018-02-07 04:30:00	AAPL	Stock	40.39	40.39	40.315	40.315	800.0
2018-02-07 05:00:00	AAPL	Stock	40.375	40.4925	40.375	40.43	16448.0
2018-02-07 05:30:00	AAPL	Stock	40.4425	40.4675	40.365	40.4125	19208.0
2018-02-07 06:00:00	AAPL	Stock	40.4075	40.475	40.25	40.475	9648.0
2018-02-07 06:30:00	AAPL	Stock	40.4625	40.59	40.4625	40.5625	54940.0
2018-02-07 07:00:00	AAPL	Stock	40.56	40.6475	40.55	40.645	175012.0
2018-02-07 07:30:00	AAPL	Stock	40.6475	40.6875	40.605	40.63	177568.0
2018-02-07 08:00:00	AAPL	Stock	40.5438	40.7375	40.3325	40.6375	271012.0
2018-02-07 08:30:00	AAPL	Stock	40.6375	40.6625	40.59	40.6625	229608.0
2018-02-07 09:00:00	AAPL	Stock	40.6575	40.8475	40.605	40.7825	318184.0
2018-02-07 09:30:00	AAPL	Stock	40.7712	40.85	40.2775	40.4903	27695460.0
2018-02-07 10:00:00	AAPL	Stock	40.49	40.655	40.39	40.4338	15108884.0
2018-02-07 10:30:00	AAPL	Stock	40.4362	40.615	40.3375	40.4975	9984212.0
2018-02-07 11:00:00	AAPL	Stock	40.5	40.5975	40.3875	40.3975	9240556.0
2018-02-07 11:30:00	AAPL	Stock	40.3975	40.5075	40.3175	40.4138	10837676.0
2018-02-07 12:00:00	AAPL	Stock	40.4225	40.455	40.2825	40.355	7408568.0
2018-02-07 12:30:00	AAPL	Stock	40.36	40.375	40.0275	40.1225	12242644.0
2018-02-07 13:00:00	AAPL	Stock	40.125	40.2075	39.767	40.13	15599932.0
2018-02-07 13:30:00	AAPL	Stock	40.13	40.3475	40.085	40.2875	9491996.0
2018-02-07 14:00:00	AAPL	Stock	40.2925	40.355	40.1	40.3425	7584212.0
2018-02-07 14:30:00	AAPL	Stock	40.3425	40.3475	39.9578	40.11	10543400.0
2018-02-07 15:00:00	AAPL	Stock	40.12	40.325	40.0625	40.2675	8995584.0
2018-02-07 15:30:00	AAPL	Stock	40.26	40.3175	39.88	39.88	19707776.0
2018-02-07 16:00:00	AAPL	Stock	39.88	40.4242	39.7525	39.78	10807056.0
2018-02-07 16:30:00	AAPL	Stock	39.7875	39.885	39.69	39.7125	137528.0
2018-02-07 17:00:00	AAPL	Stock	39.75	39.8125	39.73	39.7775	152476.0
2018-02-07 17:30:00	AAPL	Stock	39.775	39.795	39.7525	39.79	62964.0
2018-02-07 18:00:00	AAPL	Stock	39.79	39.795	39.7125	39.7275	173356.0
2018-02-07 18:30:00	AAPL	Stock	39.75	39.78	39.69	39.7075	78512.0
2018-02-07 19:00:00	AAPL	Stock	39.725	39.75	39.7	39.7225	70676.0
2018-02-07 19:30:00	AAPL	Stock	39.7475	39.78	39.725	39.725	54756.0
2018-02-07 04:00:00	MSFT	Stock	91.14	91.14	90.3	90.4	1448.0
2018-02-07 05:30:00	MSFT	Stock	90.15	90.4	89.75	90.31	3494.0
2018-02-07 06:00:00	MSFT	Stock	90.49	90.49	90.32	90.32	1050.0
2018-02-07 06:30:00	MSFT	Stock	90.49	90.61	90.49	90.61	5990.0
2018-02-07 07:00:00	MSFT	Stock	90.61	90.99	90.61	90.7	10306.0
2018-02-07 07:30:00	MSFT	Stock	90.86	90.9	90.5	90.7	11279.0
2018-02-07 08:00:00	MSFT	Stock	90.84	90.95	90.5	90.64	13805.0
2018-02-07 08:30:00	MSFT	Stock	90.64	90.82	90.5	90.79	5288.0
2018-02-07 09:00:00	MSFT	Stock	90.77	90.99	90.42	90.42	24801.0
2018-02-07 09:30:00	MSFT	Stock	90.42	90.93	89.88	90.51	5618614.0
2018-02-07 10:00:00	MSFT	Stock	90.5	91.1	90.375	90.76	2599462.0
2018-02-07 10:30:00	MSFT	Stock	90.76	91.425	90.54	91.216	2140192.0
2018-02-07 11:00:00	MSFT	Stock	91.23	91.77	91.17	91.575	2453913.0
2018-02-07 11:30:00	MSFT	Stock	91.57	91.57	90.95	91.294	1968916.0
2018-02-07 12:00:00	MSFT	Stock	91.3	91.3	90.82	91.03	1485837.0
2018-02-07 12:30:00	MSFT	Stock	91.035	91.07	90.17	90.47	2000972.0
2018-02-07 13:00:00	MSFT	Stock	90.47	90.74	89.48	89.97	2716439.0
2018-02-07 13:30:00	MSFT	Stock	89.96	90.69	89.72	90.365	2779355.0

> showing 50 of 85,326 rows — these rows as CSV

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