PREVIEW / stock_30min / 2016-02-25

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-02-25.parquet
  size:    1.5 MB
  rows:    80,924
  symbols: 3,331

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-02-25 04:00:00	AAPL	Stock	23.97	24.005	23.97	23.9875	6800.0
2016-02-25 04:30:00	AAPL	Stock	23.975	23.975	23.975	23.975	4000.0
2016-02-25 05:00:00	AAPL	Stock	23.975	24.0	23.975	24.0	2400.0
2016-02-25 05:30:00	AAPL	Stock	24.02	24.02	24.0	24.02	4000.0
2016-02-25 06:00:00	AAPL	Stock	23.975	23.975	23.975	23.975	5600.0
2016-02-25 06:30:00	AAPL	Stock	23.9975	24.035	23.9975	24.035	11604.0
2016-02-25 07:00:00	AAPL	Stock	24.0	24.0375	24.0	24.025	13252.0
2016-02-25 07:30:00	AAPL	Stock	24.0	24.0225	23.9875	24.0	25684.0
2016-02-25 08:00:00	AAPL	Stock	24.0	24.0	23.965	23.985	154948.0
2016-02-25 08:30:00	AAPL	Stock	24.0	24.045	23.985	24.03	128676.0
2016-02-25 09:00:00	AAPL	Stock	24.03	24.0475	24.0125	24.0475	194624.0
2016-02-25 09:30:00	AAPL	Stock	24.0125	24.0625	23.8125	23.8825	15792328.0
2016-02-25 10:00:00	AAPL	Stock	23.8825	23.9825	23.825	23.95	8342520.0
2016-02-25 10:30:00	AAPL	Stock	23.9475	24.1075	23.8795	24.0025	8370424.0
2016-02-25 11:00:00	AAPL	Stock	24.0025	24.05	23.94	24.015	5763752.0
2016-02-25 11:30:00	AAPL	Stock	24.015	24.05	23.9125	23.9575	6366860.0
2016-02-25 12:00:00	AAPL	Stock	23.9575	23.9775	23.9125	23.9425	3768148.0
2016-02-25 12:30:00	AAPL	Stock	23.9425	23.9525	23.9	23.9325	3822032.0
2016-02-25 13:00:00	AAPL	Stock	23.9325	24.02	23.925	24.0162	4276676.0
2016-02-25 13:30:00	AAPL	Stock	24.0153	24.1	24.0075	24.0775	6103500.0
2016-02-25 14:00:00	AAPL	Stock	24.075	24.0875	24.035	24.0662	5442616.0
2016-02-25 14:30:00	AAPL	Stock	24.0662	24.07	23.9625	23.995	5023604.0
2016-02-25 15:00:00	AAPL	Stock	23.9925	24.0995	23.9925	24.0512	6162172.0
2016-02-25 15:30:00	AAPL	Stock	24.0502	24.19	24.02	24.19	13526196.0
2016-02-25 16:00:00	AAPL	Stock	24.19	24.1925	23.8672	24.15	6921748.0
2016-02-25 16:30:00	AAPL	Stock	24.1575	24.1575	24.1425	24.1425	88712.0
2016-02-25 17:00:00	AAPL	Stock	24.1375	24.1475	24.125	24.145	16580.0
2016-02-25 17:30:00	AAPL	Stock	24.1275	24.1525	24.1275	24.1475	23044.0
2016-02-25 18:00:00	AAPL	Stock	24.1475	24.1475	24.1275	24.1275	53432.0
2016-02-25 18:30:00	AAPL	Stock	24.13	24.1475	24.1275	24.1375	23616.0
2016-02-25 19:00:00	AAPL	Stock	24.1375	24.1575	24.1375	24.155	24356.0
2016-02-25 19:30:00	AAPL	Stock	24.15	24.1575	24.15	24.155	7916.0
2016-02-25 04:00:00	MSFT	Stock	51.46	51.46	51.46	51.46	300.0
2016-02-25 06:00:00	MSFT	Stock	51.5	51.5	51.5	51.5	100.0
2016-02-25 07:30:00	MSFT	Stock	51.74	51.76	51.74	51.75	1100.0
2016-02-25 08:00:00	MSFT	Stock	51.65	51.65	51.59	51.61	1860.0
2016-02-25 08:30:00	MSFT	Stock	51.6	51.64	51.53	51.64	6179.0
2016-02-25 09:00:00	MSFT	Stock	51.64	51.84	51.6	51.77	24993.0
2016-02-25 09:30:00	MSFT	Stock	51.78	51.78	50.61	50.69	3880375.0
2016-02-25 10:00:00	MSFT	Stock	50.69	51.26	50.64	51.25	1576038.0
2016-02-25 10:30:00	MSFT	Stock	51.25	51.27	51.1	51.1	2217013.0
2016-02-25 11:00:00	MSFT	Stock	51.11	51.14	50.98	51.052	1269287.0
2016-02-25 11:30:00	MSFT	Stock	51.05	51.43	51.03	51.39	1359319.0
2016-02-25 12:00:00	MSFT	Stock	51.395	51.41	51.21	51.28	1432435.0
2016-02-25 12:30:00	MSFT	Stock	51.27	51.28	51.036	51.155	934636.0
2016-02-25 13:00:00	MSFT	Stock	51.155	51.34	51.13	51.315	1032210.0
2016-02-25 13:30:00	MSFT	Stock	51.315	51.56	51.31	51.53	962364.0
2016-02-25 14:00:00	MSFT	Stock	51.53	52.01	51.44	51.53	1349375.0
2016-02-25 14:30:00	MSFT	Stock	51.54	51.555	51.35	51.445	1093824.0
2016-02-25 15:00:00	MSFT	Stock	51.44	51.6	51.42	51.55	1859440.0

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

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