PREVIEW / stock_30min / 2017-05-31

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-05-31.parquet
  size:    1.6 MB
  rows:    81,449
  symbols: 3,038

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
2017-05-31 04:00:00	AAPL	Stock	38.4375	38.4375	38.4375	38.4375	600.0
2017-05-31 05:30:00	AAPL	Stock	38.4125	38.4125	38.4125	38.4125	3548.0
2017-05-31 06:00:00	AAPL	Stock	38.4425	38.4825	38.4425	38.4825	8104.0
2017-05-31 06:30:00	AAPL	Stock	38.4725	38.485	38.4725	38.475	11100.0
2017-05-31 07:00:00	AAPL	Stock	38.4625	38.525	38.4625	38.4875	42276.0
2017-05-31 07:30:00	AAPL	Stock	38.475	38.51	38.47	38.5	33376.0
2017-05-31 08:00:00	AAPL	Stock	38.485	38.525	38.46	38.52	99652.0
2017-05-31 08:30:00	AAPL	Stock	38.52	38.5225	38.5025	38.505	40468.0
2017-05-31 09:00:00	AAPL	Stock	38.5125	38.55	38.47	38.4825	73824.0
2017-05-31 09:30:00	AAPL	Stock	38.4925	38.5425	38.24	38.25	10488800.0
2017-05-31 10:00:00	AAPL	Stock	38.245	38.2575	38.095	38.1675	10033596.0
2017-05-31 10:30:00	AAPL	Stock	38.165	38.2625	38.13	38.2325	5249316.0
2017-05-31 11:00:00	AAPL	Stock	38.23	38.3125	38.2175	38.2725	5095748.0
2017-05-31 11:30:00	AAPL	Stock	38.2725	38.3025	38.2275	38.2988	3017076.0
2017-05-31 12:00:00	AAPL	Stock	38.3	38.35	38.2675	38.285	3233704.0
2017-05-31 12:30:00	AAPL	Stock	38.285	38.3125	38.23	38.2362	2390636.0
2017-05-31 13:00:00	AAPL	Stock	38.24	38.3125	38.2375	38.2512	2192160.0
2017-05-31 13:30:00	AAPL	Stock	38.25	38.2625	38.2025	38.2375	2064196.0
2017-05-31 14:00:00	AAPL	Stock	38.24	38.25	38.115	38.2025	4071360.0
2017-05-31 14:30:00	AAPL	Stock	38.2	38.2	38.15	38.1725	2856372.0
2017-05-31 15:00:00	AAPL	Stock	38.175	38.2375	38.155	38.2075	3385484.0
2017-05-31 15:30:00	AAPL	Stock	38.21	38.23	38.135	38.1925	11296008.0
2017-05-31 16:00:00	AAPL	Stock	38.1925	38.225	38.155	38.225	19755452.0
2017-05-31 16:30:00	AAPL	Stock	38.19	38.225	38.19	38.2225	70424.0
2017-05-31 17:00:00	AAPL	Stock	38.225	38.225	38.2125	38.225	6028.0
2017-05-31 17:30:00	AAPL	Stock	38.2125	38.235	38.205	38.205	12956.0
2017-05-31 18:00:00	AAPL	Stock	38.205	38.2225	38.2	38.2	2600.0
2017-05-31 18:30:00	AAPL	Stock	38.23	38.2325	38.23	38.23	6392.0
2017-05-31 19:00:00	AAPL	Stock	38.225	38.2325	38.2125	38.2125	9760.0
2017-05-31 19:30:00	AAPL	Stock	38.235	38.235	38.205	38.2125	22596.0
2017-05-31 06:00:00	MSFT	Stock	70.5	70.5	70.5	70.5	179.0
2017-05-31 06:30:00	MSFT	Stock	70.5	70.5	70.5	70.5	600.0
2017-05-31 07:00:00	MSFT	Stock	70.6	70.6	70.6	70.6	343.0
2017-05-31 07:30:00	MSFT	Stock	70.7	70.7	70.7	70.7	300.0
2017-05-31 08:00:00	MSFT	Stock	70.73	70.73	70.6	70.7	5534.0
2017-05-31 08:30:00	MSFT	Stock	70.61	70.63	70.6	70.63	10284.0
2017-05-31 09:00:00	MSFT	Stock	70.62	70.7	70.53	70.53	23911.0
2017-05-31 09:30:00	MSFT	Stock	70.52	70.74	70.32	70.34	2863706.0
2017-05-31 10:00:00	MSFT	Stock	70.34	70.44	70.13	70.28	1843624.0
2017-05-31 10:30:00	MSFT	Stock	70.287	70.3	69.97	70.15	2313003.0
2017-05-31 11:00:00	MSFT	Stock	70.15	70.27	70.005	70.05	1739739.0
2017-05-31 11:30:00	MSFT	Stock	70.05	70.06	69.865	69.99	1046738.0
2017-05-31 12:00:00	MSFT	Stock	69.99	70.12	69.966	70.05	1052138.0
2017-05-31 12:30:00	MSFT	Stock	70.045	70.06	69.92	69.98	643462.0
2017-05-31 13:00:00	MSFT	Stock	69.98	70.12	69.98	70.1	558422.0
2017-05-31 13:30:00	MSFT	Stock	70.09	70.13	70.02	70.06	488273.0
2017-05-31 14:00:00	MSFT	Stock	70.07	70.07	69.83	69.97	1349381.0
2017-05-31 14:30:00	MSFT	Stock	69.97	70.03	69.905	69.92	1040400.0
2017-05-31 15:00:00	MSFT	Stock	69.92	69.99	69.89	69.95	990705.0
2017-05-31 15:30:00	MSFT	Stock	69.95	70.04	69.81	69.87	4257067.0

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

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