PREVIEW / stock_30min / 2015-01-16

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-01-16.parquet
  size:    1.6 MB
  rows:    83,420
  symbols: 3,521

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-16 04:00:00	AAPL	Stock	26.65	26.65	26.5875	26.6	10000.0
2015-01-16 04:30:00	AAPL	Stock	26.56	26.56	26.5	26.5	26928.0
2015-01-16 05:00:00	AAPL	Stock	26.53	26.53	26.53	26.53	2356.0
2015-01-16 05:30:00	AAPL	Stock	26.5525	26.595	26.425	26.5825	46820.0
2015-01-16 06:00:00	AAPL	Stock	26.5625	26.6225	26.5625	26.6175	74240.0
2015-01-16 06:30:00	AAPL	Stock	26.6175	26.675	26.6175	26.675	27908.0
2015-01-16 07:00:00	AAPL	Stock	26.68	26.68	26.5725	26.5975	78224.0
2015-01-16 07:30:00	AAPL	Stock	26.5925	26.625	26.5925	26.6	55316.0
2015-01-16 08:00:00	AAPL	Stock	26.5625	26.65	26.5625	26.645	269140.0
2015-01-16 08:30:00	AAPL	Stock	26.65	26.7975	26.6475	26.76	478888.0
2015-01-16 09:00:00	AAPL	Stock	26.7625	26.7875	26.7275	26.7775	333120.0
2015-01-16 09:30:00	AAPL	Stock	26.7575	26.895	26.4775	26.55	41950664.0
2015-01-16 10:00:00	AAPL	Stock	26.55	26.685	26.4675	26.655	20720892.0
2015-01-16 10:30:00	AAPL	Stock	26.655	26.7218	26.49	26.6175	16131728.0
2015-01-16 11:00:00	AAPL	Stock	26.6175	26.7175	26.48	26.506	12976220.0
2015-01-16 11:30:00	AAPL	Stock	26.5075	26.5425	26.3125	26.3762	19763284.0
2015-01-16 12:00:00	AAPL	Stock	26.3762	26.4325	26.3	26.3648	15048776.0
2015-01-16 12:30:00	AAPL	Stock	26.365	26.52	26.335	26.4575	13057208.0
2015-01-16 13:00:00	AAPL	Stock	26.4575	26.485	26.32	26.375	11320188.0
2015-01-16 13:30:00	AAPL	Stock	26.3738	26.465	26.3675	26.4625	8594920.0
2015-01-16 14:00:00	AAPL	Stock	26.4625	26.49	26.4275	26.4775	10175364.0
2015-01-16 14:30:00	AAPL	Stock	26.4822	26.4825	26.385	26.4512	13158976.0
2015-01-16 15:00:00	AAPL	Stock	26.45	26.46	26.335	26.3448	14685284.0
2015-01-16 15:30:00	AAPL	Stock	26.345	26.5	26.325	26.495	34153772.0
2015-01-16 16:00:00	AAPL	Stock	26.4975	26.7688	26.4525	26.5	16864932.0
2015-01-16 16:30:00	AAPL	Stock	26.5	26.51	26.488	26.5	410452.0
2015-01-16 17:00:00	AAPL	Stock	26.51	26.51	26.495	26.495	129856.0
2015-01-16 17:30:00	AAPL	Stock	26.495	26.5	26.495	26.495	32676.0
2015-01-16 18:00:00	AAPL	Stock	26.4975	26.5	26.495	26.5	62944.0
2015-01-16 18:30:00	AAPL	Stock	26.505	26.5075	26.495	26.5	27452.0
2015-01-16 19:00:00	AAPL	Stock	26.5	26.525	26.5	26.5125	40496.0
2015-01-16 19:30:00	AAPL	Stock	26.505	26.51	26.4975	26.5	33848.0
2015-01-16 04:30:00	MSFT	Stock	45.18	45.18	45.1	45.1	200.0
2015-01-16 05:00:00	MSFT	Stock	45.19	45.19	45.19	45.19	600.0
2015-01-16 06:00:00	MSFT	Stock	45.4	45.4	45.4	45.4	100.0
2015-01-16 07:00:00	MSFT	Stock	45.27	45.27	45.27	45.27	497.0
2015-01-16 07:30:00	MSFT	Stock	45.26	45.26	45.26	45.26	1297.0
2015-01-16 08:00:00	MSFT	Stock	45.22	45.29	45.17	45.17	4249.0
2015-01-16 08:30:00	MSFT	Stock	45.2	45.47	45.2	45.4	6600.0
2015-01-16 09:00:00	MSFT	Stock	45.4	45.49	45.31	45.31	85356.0
2015-01-16 09:30:00	MSFT	Stock	45.31	45.8	45.17	45.51	6982702.0
2015-01-16 10:00:00	MSFT	Stock	45.52	45.72	45.385	45.59	2592235.0
2015-01-16 10:30:00	MSFT	Stock	45.585	45.88	45.56	45.796	2079397.0
2015-01-16 11:00:00	MSFT	Stock	45.79	45.94	45.715	45.76	1482148.0
2015-01-16 11:30:00	MSFT	Stock	45.76	45.856	45.7	45.83	1396742.0
2015-01-16 12:00:00	MSFT	Stock	45.835	45.89	45.73	45.775	1118329.0
2015-01-16 12:30:00	MSFT	Stock	45.775	46.13	45.77	46.024	1722820.0
2015-01-16 13:00:00	MSFT	Stock	46.025	46.04	45.805	45.88	1344090.0
2015-01-16 13:30:00	MSFT	Stock	45.88	46.03	45.85	45.975	1002478.0
2015-01-16 14:00:00	MSFT	Stock	45.975	46.0	45.84	45.92	1274046.0

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

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