PREVIEW / stock_30min / 2016-04-25

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-04-25.parquet
  size:    1.6 MB
  rows:    80,925
  symbols: 3,320

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-04-25 04:00:00	AAPL	Stock	26.305	26.305	26.305	26.305	5616.0
2016-04-25 04:30:00	AAPL	Stock	26.375	26.375	26.375	26.375	400.0
2016-04-25 05:00:00	AAPL	Stock	26.3025	26.3025	26.3025	26.3025	1992.0
2016-04-25 05:30:00	AAPL	Stock	26.33	26.37	26.33	26.37	6212.0
2016-04-25 06:00:00	AAPL	Stock	26.375	26.375	26.3625	26.3625	3608.0
2016-04-25 06:30:00	AAPL	Stock	26.3625	26.3625	26.36	26.3625	41004.0
2016-04-25 07:00:00	AAPL	Stock	26.3625	26.365	26.285	26.285	63836.0
2016-04-25 07:30:00	AAPL	Stock	26.2525	26.2525	26.19	26.2425	89196.0
2016-04-25 08:00:00	AAPL	Stock	26.2275	26.3625	26.2175	26.25	151904.0
2016-04-25 08:30:00	AAPL	Stock	26.2625	26.2925	26.25	26.2675	82752.0
2016-04-25 09:00:00	AAPL	Stock	26.27	26.295	26.225	26.225	271892.0
2016-04-25 09:30:00	AAPL	Stock	26.2275	26.4125	26.2	26.2582	14464284.0
2016-04-25 10:00:00	AAPL	Stock	26.26	26.285	26.2	26.2375	7952008.0
2016-04-25 10:30:00	AAPL	Stock	26.2362	26.275	26.145	26.163	8628216.0
2016-04-25 11:00:00	AAPL	Stock	26.1625	26.2575	26.1275	26.25	7328572.0
2016-04-25 11:30:00	AAPL	Stock	26.2525	26.255	26.1925	26.2235	5549240.0
2016-04-25 12:00:00	AAPL	Stock	26.2238	26.2625	26.21	26.2355	5095456.0
2016-04-25 12:30:00	AAPL	Stock	26.2375	26.2825	26.1975	26.2725	5557556.0
2016-04-25 13:00:00	AAPL	Stock	26.275	26.3282	26.24	26.3028	5844996.0
2016-04-25 13:30:00	AAPL	Stock	26.3038	26.345	26.27	26.3375	6180352.0
2016-04-25 14:00:00	AAPL	Stock	26.3398	26.345	26.2695	26.3175	4464972.0
2016-04-25 14:30:00	AAPL	Stock	26.3175	26.3475	26.2775	26.2925	5446276.0
2016-04-25 15:00:00	AAPL	Stock	26.295	26.3075	26.2288	26.2362	6543724.0
2016-04-25 15:30:00	AAPL	Stock	26.2362	26.275	26.22	26.27	12645008.0
2016-04-25 16:00:00	AAPL	Stock	26.27	26.2875	26.2258	26.2725	7206800.0
2016-04-25 16:30:00	AAPL	Stock	26.28	26.3325	26.27	26.29	110692.0
2016-04-25 17:00:00	AAPL	Stock	26.2925	26.31	26.2875	26.2875	29200.0
2016-04-25 17:30:00	AAPL	Stock	26.2925	26.31	26.29	26.29	18840.0
2016-04-25 18:00:00	AAPL	Stock	26.3125	26.3125	26.29	26.29	13504.0
2016-04-25 18:30:00	AAPL	Stock	26.29	26.29	26.2875	26.2875	3264.0
2016-04-25 19:00:00	AAPL	Stock	26.2875	26.2875	26.275	26.2825	22828.0
2016-04-25 19:30:00	AAPL	Stock	26.2825	26.2975	26.275	26.2775	19128.0
2016-04-25 04:00:00	MSFT	Stock	51.78	51.78	51.6	51.6	599.0
2016-04-25 04:30:00	MSFT	Stock	51.7	51.7	51.7	51.7	100.0
2016-04-25 06:00:00	MSFT	Stock	51.76	51.76	51.76	51.76	1900.0
2016-04-25 06:30:00	MSFT	Stock	51.88	51.88	51.88	51.88	148.0
2016-04-25 07:00:00	MSFT	Stock	51.69	51.69	51.67	51.68	2410.0
2016-04-25 07:30:00	MSFT	Stock	51.69	51.78	51.61	51.61	9865.0
2016-04-25 08:00:00	MSFT	Stock	51.67	51.7	51.49	51.49	54744.0
2016-04-25 08:30:00	MSFT	Stock	51.52	51.74	51.5	51.65	26899.0
2016-04-25 09:00:00	MSFT	Stock	51.65	51.78	51.5	51.78	32113.0
2016-04-25 09:30:00	MSFT	Stock	51.78	52.0	51.63	52.0	4818344.0
2016-04-25 10:00:00	MSFT	Stock	51.995	52.1	51.82	51.91	3283005.0
2016-04-25 10:30:00	MSFT	Stock	51.91	52.01	51.6	51.83	3126752.0
2016-04-25 11:00:00	MSFT	Stock	51.829	51.96	51.7	51.954	2143001.0
2016-04-25 11:30:00	MSFT	Stock	51.96	51.97	51.81	51.84	1609437.0
2016-04-25 12:00:00	MSFT	Stock	51.841	51.88	51.78	51.8	1315519.0
2016-04-25 12:30:00	MSFT	Stock	51.81	52.015	51.795	51.944	1563590.0
2016-04-25 13:00:00	MSFT	Stock	51.95	51.96	51.84	51.905	1286591.0
2016-04-25 13:30:00	MSFT	Stock	51.91	51.91	51.84	51.88	1121241.0

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

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