PREVIEW / stock_30min / 2015-01-29

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-01-29.parquet
  size:    1.6 MB
  rows:    83,506
  symbols: 3,513

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-01-29 04:00:00	AAPL	Stock	28.9275	29.0875	28.9275	29.0625	4800.0
2015-01-29 04:30:00	AAPL	Stock	29.05	29.05	29.05	29.05	6640.0
2015-01-29 05:00:00	AAPL	Stock	29.05	29.05	29.0	29.05	21136.0
2015-01-29 05:30:00	AAPL	Stock	29.05	29.05	29.0	29.0	23900.0
2015-01-29 06:00:00	AAPL	Stock	29.0475	29.05	29.025	29.05	56972.0
2015-01-29 06:30:00	AAPL	Stock	29.045	29.05	29.0375	29.0425	123536.0
2015-01-29 07:00:00	AAPL	Stock	29.0475	29.125	29.0475	29.075	246384.0
2015-01-29 07:30:00	AAPL	Stock	29.075	29.0875	29.005	29.0175	95144.0
2015-01-29 08:00:00	AAPL	Stock	29.025	29.115	28.775	29.0625	831816.0
2015-01-29 08:30:00	AAPL	Stock	29.06	29.11	29.03	29.075	730712.0
2015-01-29 09:00:00	AAPL	Stock	29.08	29.1025	29.0525	29.085	814912.0
2015-01-29 09:30:00	AAPL	Stock	29.09	29.2475	28.89	29.235	43981304.0
2015-01-29 10:00:00	AAPL	Stock	29.235	29.3262	29.1875	29.315	32705552.0
2015-01-29 10:30:00	AAPL	Stock	29.3175	29.33	29.065	29.215	23144744.0
2015-01-29 11:00:00	AAPL	Stock	29.215	29.3275	29.18	29.2075	16654592.0
2015-01-29 11:30:00	AAPL	Stock	29.21	29.3675	29.1612	29.325	19247156.0
2015-01-29 12:00:00	AAPL	Stock	29.3252	29.3725	29.27	29.305	15662768.0
2015-01-29 12:30:00	AAPL	Stock	29.3028	29.3275	29.2525	29.315	8702716.0
2015-01-29 13:00:00	AAPL	Stock	29.3128	29.385	29.275	29.3748	11405984.0
2015-01-29 13:30:00	AAPL	Stock	29.375	29.53	29.355	29.49	22005128.0
2015-01-29 14:00:00	AAPL	Stock	29.4925	29.6425	29.4575	29.64	24535516.0
2015-01-29 14:30:00	AAPL	Stock	29.6375	29.7375	29.5925	29.735	25556732.0
2015-01-29 15:00:00	AAPL	Stock	29.735	29.77	29.6475	29.75	25465036.0
2015-01-29 15:30:00	AAPL	Stock	29.751	29.7975	29.5472	29.735	29945924.0
2015-01-29 16:00:00	AAPL	Stock	29.725	29.7675	29.0842	29.725	9408972.0
2015-01-29 16:30:00	AAPL	Stock	29.725	29.765	29.3798	29.7475	579828.0
2015-01-29 17:00:00	AAPL	Stock	29.7475	29.775	29.7475	29.775	325840.0
2015-01-29 17:30:00	AAPL	Stock	29.775	29.7975	29.765	29.7875	320420.0
2015-01-29 18:00:00	AAPL	Stock	29.795	29.8325	29.725	29.8225	401608.0
2015-01-29 18:30:00	AAPL	Stock	29.8225	29.8225	29.735	29.8025	193580.0
2015-01-29 19:00:00	AAPL	Stock	29.8025	29.8025	29.7475	29.7475	102108.0
2015-01-29 19:30:00	AAPL	Stock	29.7475	29.7675	29.73	29.7625	119144.0
2015-01-29 04:00:00	MSFT	Stock	41.11	41.14	41.01	41.01	950.0
2015-01-29 04:30:00	MSFT	Stock	41.1	41.15	40.95	41.15	3600.0
2015-01-29 05:00:00	MSFT	Stock	41.01	41.08	41.01	41.01	1194.0
2015-01-29 05:30:00	MSFT	Stock	41.04	41.15	41.04	41.15	800.0
2015-01-29 06:00:00	MSFT	Stock	41.1	41.14	41.1	41.1	1700.0
2015-01-29 06:30:00	MSFT	Stock	41.14	41.25	41.13	41.25	2700.0
2015-01-29 07:00:00	MSFT	Stock	41.19	41.2	41.17	41.18	2760.0
2015-01-29 07:30:00	MSFT	Stock	41.22	41.22	41.22	41.22	2598.0
2015-01-29 08:00:00	MSFT	Stock	41.24	41.25	41.16	41.18	22183.0
2015-01-29 08:30:00	MSFT	Stock	41.18	41.2	41.1	41.14	29231.0
2015-01-29 09:00:00	MSFT	Stock	41.15	41.2	40.88	40.9	83333.0
2015-01-29 09:30:00	MSFT	Stock	40.93	41.35	40.79	41.31	10179868.0
2015-01-29 10:00:00	MSFT	Stock	41.3	41.38	41.07	41.32	4617074.0
2015-01-29 10:30:00	MSFT	Stock	41.31	41.435	41.04	41.19	4749171.0
2015-01-29 11:00:00	MSFT	Stock	41.18	41.23	40.99	41.035	3367763.0
2015-01-29 11:30:00	MSFT	Stock	41.035	41.315	41.03	41.16	2525590.0
2015-01-29 12:00:00	MSFT	Stock	41.17	41.375	41.17	41.215	2024345.0
2015-01-29 12:30:00	MSFT	Stock	41.22	41.27	41.1	41.255	2073694.0

> showing 50 of 83,506 rows — these rows as CSV

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