PREVIEW / stock_30min / 2015-04-08

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-04-08.parquet
  size:    1.6 MB
  rows:    81,502
  symbols: 3,496

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
2015-04-08 04:00:00	AAPL	Stock	32.5	32.5	31.3325	31.3325	107076.0
2015-04-08 04:30:00	AAPL	Stock	31.3475	31.3475	31.3375	31.3375	22528.0
2015-04-08 05:00:00	AAPL	Stock	31.345	31.3875	31.3375	31.375	32236.0
2015-04-08 05:30:00	AAPL	Stock	31.375	31.39	31.3125	31.3475	48572.0
2015-04-08 06:00:00	AAPL	Stock	31.3075	31.4125	31.2775	31.375	42744.0
2015-04-08 06:30:00	AAPL	Stock	31.365	31.3925	31.325	31.3475	48876.0
2015-04-08 07:00:00	AAPL	Stock	31.3375	31.39	31.32	31.365	106272.0
2015-04-08 07:30:00	AAPL	Stock	31.37	31.45	31.37	31.45	109180.0
2015-04-08 08:00:00	AAPL	Stock	31.44	31.4775	31.32	31.42	630536.0
2015-04-08 08:30:00	AAPL	Stock	31.42	31.425	31.4	31.42	153280.0
2015-04-08 09:00:00	AAPL	Stock	31.4225	31.5	31.4175	31.4525	476316.0
2015-04-08 09:30:00	AAPL	Stock	31.4625	31.6	31.2775	31.4938	26611460.0
2015-04-08 10:00:00	AAPL	Stock	31.495	31.575	31.44	31.46	14154216.0
2015-04-08 10:30:00	AAPL	Stock	31.46	31.4612	31.2425	31.3325	16729324.0
2015-04-08 11:00:00	AAPL	Stock	31.335	31.435	31.305	31.3888	7824916.0
2015-04-08 11:30:00	AAPL	Stock	31.3888	31.42	31.355	31.42	5075992.0
2015-04-08 12:00:00	AAPL	Stock	31.4225	31.5275	31.415	31.44	7972280.0
2015-04-08 12:30:00	AAPL	Stock	31.44	31.475	31.365	31.375	4876404.0
2015-04-08 13:00:00	AAPL	Stock	31.3775	31.415	31.3125	31.3712	7186340.0
2015-04-08 13:30:00	AAPL	Stock	31.3725	31.445	31.34	31.41	4569924.0
2015-04-08 14:00:00	AAPL	Stock	31.4125	31.5188	31.2962	31.445	13059536.0
2015-04-08 14:30:00	AAPL	Stock	31.445	31.4825	31.315	31.3732	6374004.0
2015-04-08 15:00:00	AAPL	Stock	31.375	31.4125	31.31	31.325	5949848.0
2015-04-08 15:30:00	AAPL	Stock	31.3238	31.4	31.3	31.4	12577312.0
2015-04-08 16:00:00	AAPL	Stock	31.3975	31.43	31.3975	31.4225	5035908.0
2015-04-08 16:30:00	AAPL	Stock	31.4225	31.435	31.3862	31.435	71468.0
2015-04-08 17:00:00	AAPL	Stock	31.43	31.465	31.43	31.46	149928.0
2015-04-08 17:30:00	AAPL	Stock	31.4625	31.47	31.4375	31.465	43092.0
2015-04-08 18:00:00	AAPL	Stock	31.4698	31.4725	31.4575	31.47	74016.0
2015-04-08 18:30:00	AAPL	Stock	31.47	31.47	31.4575	31.4575	24372.0
2015-04-08 19:00:00	AAPL	Stock	31.4575	31.4625	31.4575	31.4625	2980.0
2015-04-08 19:30:00	AAPL	Stock	31.4575	31.4625	31.4425	31.45	25516.0
2015-04-08 05:00:00	MSFT	Stock	41.42	41.42	41.42	41.42	100.0
2015-04-08 08:00:00	MSFT	Stock	41.57	41.57	41.57	41.57	3000.0
2015-04-08 08:30:00	MSFT	Stock	41.55	41.56	41.519	41.519	1600.0
2015-04-08 09:00:00	MSFT	Stock	41.52	41.52	41.4	41.43	13250.0
2015-04-08 09:30:00	MSFT	Stock	41.46	41.69	41.33	41.65	2989293.0
2015-04-08 10:00:00	MSFT	Stock	41.65	41.677	41.35	41.353	2272998.0
2015-04-08 10:30:00	MSFT	Stock	41.35	41.38	41.16	41.28	1870529.0
2015-04-08 11:00:00	MSFT	Stock	41.28	41.39	41.28	41.34	1187681.0
2015-04-08 11:30:00	MSFT	Stock	41.34	41.37	41.25	41.273	1126924.0
2015-04-08 12:00:00	MSFT	Stock	41.274	41.29	41.16	41.186	1096141.0
2015-04-08 12:30:00	MSFT	Stock	41.18	41.3	41.16	41.26	1149478.0
2015-04-08 13:00:00	MSFT	Stock	41.264	41.28	41.18	41.19	715556.0
2015-04-08 13:30:00	MSFT	Stock	41.19	41.23	41.17	41.2	1061498.0
2015-04-08 14:00:00	MSFT	Stock	41.2	41.43	41.04	41.29	2303623.0
2015-04-08 14:30:00	MSFT	Stock	41.3	41.33	41.14	41.21	1247407.0
2015-04-08 15:00:00	MSFT	Stock	41.21	41.29	41.18	41.236	1201555.0
2015-04-08 15:30:00	MSFT	Stock	41.234	41.44	41.22	41.42	3461407.0
2015-04-08 16:00:00	MSFT	Stock	41.42	41.43	40.98	41.43	1582904.0

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

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