PREVIEW / stock_30min / 2016-03-24

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-03-24.parquet
  size:    1.5 MB
  rows:    80,151
  symbols: 3,309

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-03-24 04:00:00	AAPL	Stock	26.505	26.505	26.48	26.48	800.0
2016-03-24 05:00:00	AAPL	Stock	26.4375	26.4375	26.4375	26.4375	1996.0
2016-03-24 06:00:00	AAPL	Stock	26.4325	26.4375	26.3825	26.4325	8000.0
2016-03-24 06:30:00	AAPL	Stock	26.42	26.42	26.42	26.42	400.0
2016-03-24 07:00:00	AAPL	Stock	26.42	26.425	26.41	26.42	7652.0
2016-03-24 07:30:00	AAPL	Stock	26.4175	26.42	26.4	26.4	25920.0
2016-03-24 08:00:00	AAPL	Stock	26.41	26.4375	26.41	26.4375	36848.0
2016-03-24 08:30:00	AAPL	Stock	26.4275	26.4475	26.4	26.4175	88264.0
2016-03-24 09:00:00	AAPL	Stock	26.4175	26.4375	26.375	26.375	160668.0
2016-03-24 09:30:00	AAPL	Stock	26.3675	26.5625	26.3538	26.4075	13678716.0
2016-03-24 10:00:00	AAPL	Stock	26.4075	26.43	26.2575	26.26	10324156.0
2016-03-24 10:30:00	AAPL	Stock	26.2585	26.3025	26.2225	26.2898	11875572.0
2016-03-24 11:00:00	AAPL	Stock	26.2912	26.375	26.2912	26.3125	6661216.0
2016-03-24 11:30:00	AAPL	Stock	26.315	26.3975	26.3125	26.3975	4856864.0
2016-03-24 12:00:00	AAPL	Stock	26.395	26.43	26.33	26.3575	4942636.0
2016-03-24 12:30:00	AAPL	Stock	26.3575	26.365	26.3	26.355	4066380.0
2016-03-24 13:00:00	AAPL	Stock	26.355	26.3975	26.35	26.3575	3574600.0
2016-03-24 13:30:00	AAPL	Stock	26.3575	26.3975	26.3275	26.3712	3184616.0
2016-03-24 14:00:00	AAPL	Stock	26.3725	26.3975	26.3325	26.3825	4074768.0
2016-03-24 14:30:00	AAPL	Stock	26.385	26.447	26.3725	26.4225	4671428.0
2016-03-24 15:00:00	AAPL	Stock	26.4238	26.4625	26.4	26.455	4801752.0
2016-03-24 15:30:00	AAPL	Stock	26.455	26.46	26.39	26.415	9181680.0
2016-03-24 16:00:00	AAPL	Stock	26.4175	26.4175	26.3675	26.4	8136004.0
2016-03-24 16:30:00	AAPL	Stock	26.4	26.425	26.4	26.405	36884.0
2016-03-24 17:00:00	AAPL	Stock	26.4125	26.425	26.4075	26.425	5600.0
2016-03-24 17:30:00	AAPL	Stock	26.4175	26.425	26.4175	26.42	6400.0
2016-03-24 18:00:00	AAPL	Stock	26.42	26.42	26.4075	26.4175	16600.0
2016-03-24 18:30:00	AAPL	Stock	26.4175	26.425	26.4125	26.4125	10312.0
2016-03-24 19:00:00	AAPL	Stock	26.4225	26.4225	26.4075	26.4225	16432.0
2016-03-24 19:30:00	AAPL	Stock	26.4125	26.425	26.4125	26.4225	26924.0
2016-03-24 08:00:00	MSFT	Stock	53.79	53.79	53.57	53.57	298.0
2016-03-24 08:30:00	MSFT	Stock	53.57	53.57	53.52	53.52	1800.0
2016-03-24 09:00:00	MSFT	Stock	53.57	53.8	53.57	53.75	8722.0
2016-03-24 09:30:00	MSFT	Stock	53.84	54.18	53.73	54.17	2524576.0
2016-03-24 10:00:00	MSFT	Stock	54.17	54.205	53.94	54.1	927431.0
2016-03-24 10:30:00	MSFT	Stock	54.09	54.32	54.06	54.295	1101065.0
2016-03-24 11:00:00	MSFT	Stock	54.28	54.33	54.15	54.155	834892.0
2016-03-24 11:30:00	MSFT	Stock	54.155	54.28	54.13	54.275	931151.0
2016-03-24 12:00:00	MSFT	Stock	54.27	54.33	54.02	54.02	956817.0
2016-03-24 12:30:00	MSFT	Stock	54.02	54.1	53.93	54.08	778467.0
2016-03-24 13:00:00	MSFT	Stock	54.07	54.155	54.044	54.08	774396.0
2016-03-24 13:30:00	MSFT	Stock	54.09	54.21	54.08	54.136	667564.0
2016-03-24 14:00:00	MSFT	Stock	54.13	54.17	54.06	54.13	731911.0
2016-03-24 14:30:00	MSFT	Stock	54.13	54.22	54.09	54.16	1113688.0
2016-03-24 15:00:00	MSFT	Stock	54.16	54.19	54.1	54.19	839871.0
2016-03-24 15:30:00	MSFT	Stock	54.185	54.23	54.12	54.21	1926438.0
2016-03-24 16:00:00	MSFT	Stock	54.21	54.21	54.19	54.19	2464120.0
2016-03-24 16:30:00	MSFT	Stock	54.28	54.29	54.2	54.29	1200.0
2016-03-24 17:30:00	MSFT	Stock	54.22	54.22	54.22	54.22	1000.0
2016-03-24 18:00:00	MSFT	Stock	54.22	54.28	54.21	54.28	733.0

> showing 50 of 80,151 rows — these rows as CSV

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