PREVIEW / stock_30min / 2016-07-25

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-07-25.parquet
  size:    1.6 MB
  rows:    81,540
  symbols: 3,268

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
2016-07-25 04:00:00	AAPL	Stock	24.665	24.665	24.63	24.63	1292.0
2016-07-25 04:30:00	AAPL	Stock	24.665	24.665	24.665	24.665	400.0
2016-07-25 05:00:00	AAPL	Stock	24.655	24.655	24.655	24.655	880.0
2016-07-25 05:30:00	AAPL	Stock	24.665	24.675	24.625	24.625	5376.0
2016-07-25 06:00:00	AAPL	Stock	24.625	24.625	24.595	24.595	4000.0
2016-07-25 07:00:00	AAPL	Stock	24.6	24.6225	24.6	24.6175	8940.0
2016-07-25 07:30:00	AAPL	Stock	24.6	24.625	24.5875	24.6	21228.0
2016-07-25 08:00:00	AAPL	Stock	24.6	24.625	24.5625	24.6075	88276.0
2016-07-25 08:30:00	AAPL	Stock	24.61	24.6175	24.6	24.6125	107960.0
2016-07-25 09:00:00	AAPL	Stock	24.6	24.625	24.5625	24.5625	525940.0
2016-07-25 09:30:00	AAPL	Stock	24.5625	24.71	24.54	24.581	22928440.0
2016-07-25 10:00:00	AAPL	Stock	24.581	24.595	24.4725	24.495	12776856.0
2016-07-25 10:30:00	AAPL	Stock	24.495	24.5325	24.4625	24.5118	8634228.0
2016-07-25 11:00:00	AAPL	Stock	24.51	24.56	24.5025	24.5475	5964100.0
2016-07-25 11:30:00	AAPL	Stock	24.5475	24.555	24.4925	24.4998	5756688.0
2016-07-25 12:00:00	AAPL	Stock	24.5	24.51	24.355	24.3825	13679448.0
2016-07-25 12:30:00	AAPL	Stock	24.3825	24.3925	24.3325	24.345	10411092.0
2016-07-25 13:00:00	AAPL	Stock	24.3425	24.3575	24.3075	24.348	8291244.0
2016-07-25 13:30:00	AAPL	Stock	24.35	24.3575	24.2925	24.304	6066548.0
2016-07-25 14:00:00	AAPL	Stock	24.304	24.3525	24.3	24.305	6133880.0
2016-07-25 14:30:00	AAPL	Stock	24.305	24.3212	24.2575	24.26	7359828.0
2016-07-25 15:00:00	AAPL	Stock	24.2618	24.28	24.23	24.2625	9936444.0
2016-07-25 15:30:00	AAPL	Stock	24.2625	24.335	24.2575	24.33	17193332.0
2016-07-25 16:00:00	AAPL	Stock	24.335	24.365	24.261	24.3525	8605308.0
2016-07-25 16:30:00	AAPL	Stock	24.3525	24.4	24.33	24.355	219920.0
2016-07-25 17:00:00	AAPL	Stock	24.355	24.3725	24.335	24.335	128528.0
2016-07-25 17:30:00	AAPL	Stock	24.3275	24.3375	24.3125	24.325	31376.0
2016-07-25 18:00:00	AAPL	Stock	24.3125	24.325	24.27	24.2775	45388.0
2016-07-25 18:30:00	AAPL	Stock	24.2825	24.3	24.2675	24.27	36264.0
2016-07-25 19:00:00	AAPL	Stock	24.2875	24.2875	24.2775	24.285	10000.0
2016-07-25 19:30:00	AAPL	Stock	24.2775	24.2925	24.24	24.285	136432.0
2016-07-25 04:00:00	MSFT	Stock	56.6	56.6	56.6	56.6	200.0
2016-07-25 06:00:00	MSFT	Stock	56.7	56.7	56.68	56.68	200.0
2016-07-25 07:00:00	MSFT	Stock	56.44	56.5	56.4	56.4	6005.0
2016-07-25 08:00:00	MSFT	Stock	56.33	56.56	56.33	56.5	3600.0
2016-07-25 08:30:00	MSFT	Stock	56.5	56.5	56.49	56.49	481.0
2016-07-25 09:00:00	MSFT	Stock	56.53	56.53	56.41	56.41	7668.0
2016-07-25 09:30:00	MSFT	Stock	56.41	56.69	56.4	56.435	3516123.0
2016-07-25 10:00:00	MSFT	Stock	56.44	56.5	56.31	56.425	1689656.0
2016-07-25 10:30:00	MSFT	Stock	56.42	56.48	56.36	56.37	1178035.0
2016-07-25 11:00:00	MSFT	Stock	56.37	56.39	56.28	56.32	980996.0
2016-07-25 11:30:00	MSFT	Stock	56.316	56.355	56.255	56.34	914193.0
2016-07-25 12:00:00	MSFT	Stock	56.34	56.44	56.33	56.427	1495765.0
2016-07-25 12:30:00	MSFT	Stock	56.43	56.49	56.41	56.44	828688.0
2016-07-25 13:00:00	MSFT	Stock	56.44	56.48	56.375	56.46	1058638.0
2016-07-25 13:30:00	MSFT	Stock	56.46	56.5	56.42	56.475	1077850.0
2016-07-25 14:00:00	MSFT	Stock	56.47	56.53	56.4	56.414	1066920.0
2016-07-25 14:30:00	MSFT	Stock	56.415	56.52	56.41	56.49	925698.0
2016-07-25 15:00:00	MSFT	Stock	56.49	56.535	56.465	56.53	1360845.0
2016-07-25 15:30:00	MSFT	Stock	56.525	56.74	56.51	56.73	4083864.0

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

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