PREVIEW / stock_30min / 2014-11-10

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-11-10.parquet
  size:    1.6 MB
  rows:    82,433
  symbols: 3,561

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
2014-11-10 04:00:00	AAPL	Stock	27.2525	27.275	27.25	27.25	7872.0
2014-11-10 04:30:00	AAPL	Stock	27.2375	27.25	27.2375	27.25	2400.0
2014-11-10 05:00:00	AAPL	Stock	27.25	27.25	27.225	27.225	4520.0
2014-11-10 05:30:00	AAPL	Stock	27.27	27.2725	27.27	27.2725	1600.0
2014-11-10 06:00:00	AAPL	Stock	27.2625	27.2625	27.2625	27.2625	400.0
2014-11-10 06:30:00	AAPL	Stock	27.25	27.26	27.25	27.25	8000.0
2014-11-10 07:00:00	AAPL	Stock	27.25	27.3225	27.25	27.3125	36684.0
2014-11-10 07:30:00	AAPL	Stock	27.305	27.305	27.275	27.3025	61384.0
2014-11-10 08:00:00	AAPL	Stock	27.3	27.3225	27.0075	27.2975	167920.0
2014-11-10 08:30:00	AAPL	Stock	27.2975	27.31	27.28	27.2875	162040.0
2014-11-10 09:00:00	AAPL	Stock	27.285	27.29	27.2425	27.255	370528.0
2014-11-10 09:30:00	AAPL	Stock	27.255	27.31	27.225	27.2525	15439484.0
2014-11-10 10:00:00	AAPL	Stock	27.255	27.3075	27.2275	27.305	9096344.0
2014-11-10 10:30:00	AAPL	Stock	27.305	27.3325	27.265	27.2888	10117048.0
2014-11-10 11:00:00	AAPL	Stock	27.29	27.2975	27.26	27.2775	6427468.0
2014-11-10 11:30:00	AAPL	Stock	27.28	27.28	27.17	27.2212	8987192.0
2014-11-10 12:00:00	AAPL	Stock	27.221	27.25	27.2162	27.2335	5036752.0
2014-11-10 12:30:00	AAPL	Stock	27.2325	27.2725	27.2325	27.2475	4314716.0
2014-11-10 13:00:00	AAPL	Stock	27.2475	27.255	27.225	27.235	3668596.0
2014-11-10 13:30:00	AAPL	Stock	27.235	27.25	27.2328	27.24	2900704.0
2014-11-10 14:00:00	AAPL	Stock	27.24	27.26	27.2325	27.249	4087748.0
2014-11-10 14:30:00	AAPL	Stock	27.2488	27.265	27.23	27.2588	4603716.0
2014-11-10 15:00:00	AAPL	Stock	27.2575	27.285	27.225	27.245	6153036.0
2014-11-10 15:30:00	AAPL	Stock	27.2438	27.2475	27.1675	27.205	11688888.0
2014-11-10 16:00:00	AAPL	Stock	27.2075	27.2518	27.1875	27.195	4609088.0
2014-11-10 16:30:00	AAPL	Stock	27.1925	27.2025	27.1925	27.2025	86028.0
2014-11-10 17:00:00	AAPL	Stock	27.2025	27.2485	27.195	27.2025	30100.0
2014-11-10 17:30:00	AAPL	Stock	27.2	27.2	27.1775	27.1775	8652.0
2014-11-10 18:00:00	AAPL	Stock	27.1825	27.2075	27.1675	27.175	177512.0
2014-11-10 18:30:00	AAPL	Stock	27.1725	27.2075	27.17	27.175	248448.0
2014-11-10 19:00:00	AAPL	Stock	27.19	27.1975	27.18	27.1825	31648.0
2014-11-10 19:30:00	AAPL	Stock	27.1825	27.1825	27.1625	27.165	42708.0
2014-11-10 04:30:00	MSFT	Stock	48.7	48.73	48.7	48.7	1800.0
2014-11-10 05:00:00	MSFT	Stock	48.9	48.9	48.9	48.9	600.0
2014-11-10 05:30:00	MSFT	Stock	48.9	48.9	48.9	48.9	100.0
2014-11-10 06:00:00	MSFT	Stock	48.78	48.78	48.78	48.78	500.0
2014-11-10 06:30:00	MSFT	Stock	48.75	48.75	48.74	48.74	600.0
2014-11-10 07:30:00	MSFT	Stock	48.8	48.8	48.8	48.8	650.0
2014-11-10 08:00:00	MSFT	Stock	48.87	48.87	48.76	48.76	2290.0
2014-11-10 08:30:00	MSFT	Stock	48.76	48.76	48.73	48.73	1000.0
2014-11-10 09:00:00	MSFT	Stock	48.73	48.74	48.65	48.65	26031.0
2014-11-10 09:30:00	MSFT	Stock	48.65	48.74	48.56	48.615	3348533.0
2014-11-10 10:00:00	MSFT	Stock	48.615	48.649	48.55	48.59	1593104.0
2014-11-10 10:30:00	MSFT	Stock	48.59	48.87	48.555	48.785	4888899.0
2014-11-10 11:00:00	MSFT	Stock	48.79	49.047	48.78	49.047	3340324.0
2014-11-10 11:30:00	MSFT	Stock	49.05	49.15	49.0	49.11	3232516.0
2014-11-10 12:00:00	MSFT	Stock	49.1	49.11	49.03	49.05	1753308.0
2014-11-10 12:30:00	MSFT	Stock	49.055	49.06	48.95	48.97	955294.0
2014-11-10 13:00:00	MSFT	Stock	48.97	48.989	48.84	48.89	1511210.0
2014-11-10 13:30:00	MSFT	Stock	48.89	48.92	48.82	48.84	1669504.0

> showing 50 of 82,433 rows — these rows as CSV

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