PREVIEW / stock_30min / 2015-03-26

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-03-26.parquet
  size:    1.6 MB
  rows:    83,161
  symbols: 3,495

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-03-26 04:00:00	AAPL	Stock	30.7375	30.7375	30.2	30.475	381856.0
2015-03-26 04:30:00	AAPL	Stock	30.5225	30.55	30.3775	30.4	68652.0
2015-03-26 05:00:00	AAPL	Stock	30.3775	30.4625	30.3275	30.3625	94884.0
2015-03-26 05:30:00	AAPL	Stock	30.3625	30.4125	30.3375	30.4	104012.0
2015-03-26 06:00:00	AAPL	Stock	30.4	30.4875	30.375	30.4875	92344.0
2015-03-26 06:30:00	AAPL	Stock	30.485	30.4875	30.425	30.475	44200.0
2015-03-26 07:00:00	AAPL	Stock	30.475	30.5725	30.4625	30.5625	244124.0
2015-03-26 07:30:00	AAPL	Stock	30.555	30.5875	30.5125	30.5125	134100.0
2015-03-26 08:00:00	AAPL	Stock	30.51	30.605	30.3875	30.5975	866076.0
2015-03-26 08:30:00	AAPL	Stock	30.5925	30.74	30.56	30.6875	562364.0
2015-03-26 09:00:00	AAPL	Stock	30.68	30.8125	30.6775	30.69	850256.0
2015-03-26 09:30:00	AAPL	Stock	30.695	31.125	30.65	30.9825	35994144.0
2015-03-26 10:00:00	AAPL	Stock	30.9825	31.04	30.8025	30.88	20124116.0
2015-03-26 10:30:00	AAPL	Stock	30.88	31.07	30.86	31.0662	15106620.0
2015-03-26 11:00:00	AAPL	Stock	31.065	31.0875	30.9375	31.055	10732144.0
2015-03-26 11:30:00	AAPL	Stock	31.0538	31.205	31.0325	31.1912	11538320.0
2015-03-26 12:00:00	AAPL	Stock	31.195	31.22	31.1025	31.1088	9671548.0
2015-03-26 12:30:00	AAPL	Stock	31.1075	31.14	31.0275	31.125	6451496.0
2015-03-26 13:00:00	AAPL	Stock	31.125	31.13	30.9525	31.01	7562548.0
2015-03-26 13:30:00	AAPL	Stock	31.01	31.1475	30.99	31.1125	7899504.0
2015-03-26 14:00:00	AAPL	Stock	31.1125	31.1475	31.03	31.0725	7168964.0
2015-03-26 14:30:00	AAPL	Stock	31.0725	31.185	31.0675	31.1025	7079516.0
2015-03-26 15:00:00	AAPL	Stock	31.1	31.1225	31.0125	31.0262	9231892.0
2015-03-26 15:30:00	AAPL	Stock	31.0252	31.1725	31.01	31.0625	15401936.0
2015-03-26 16:00:00	AAPL	Stock	31.06	31.105	31.0412	31.0675	9859160.0
2015-03-26 16:30:00	AAPL	Stock	31.0775	31.0825	31.06	31.08	32724.0
2015-03-26 17:00:00	AAPL	Stock	31.0825	31.1025	31.075	31.075	52164.0
2015-03-26 17:30:00	AAPL	Stock	31.065	31.0875	31.06	31.08	52564.0
2015-03-26 18:00:00	AAPL	Stock	31.085	31.1	31.06	31.085	228112.0
2015-03-26 18:30:00	AAPL	Stock	31.0775	31.0975	31.06	31.0925	212244.0
2015-03-26 19:00:00	AAPL	Stock	31.0975	31.105	31.0825	31.095	64004.0
2015-03-26 19:30:00	AAPL	Stock	31.08	31.13	31.08	31.125	80036.0
2015-03-26 04:00:00	MSFT	Stock	41.16	41.21	41.16	41.21	300.0
2015-03-26 04:30:00	MSFT	Stock	41.2	41.2	41.16	41.16	3100.0
2015-03-26 05:00:00	MSFT	Stock	41.05	41.05	41.05	41.05	1000.0
2015-03-26 05:30:00	MSFT	Stock	41.04	41.04	41.04	41.04	400.0
2015-03-26 06:00:00	MSFT	Stock	41.05	41.06	41.05	41.06	600.0
2015-03-26 06:30:00	MSFT	Stock	41.1	41.18	41.1	41.18	3600.0
2015-03-26 07:00:00	MSFT	Stock	41.14	41.19	41.1	41.19	4000.0
2015-03-26 07:30:00	MSFT	Stock	41.16	41.2	41.16	41.17	5044.0
2015-03-26 08:00:00	MSFT	Stock	41.18	41.24	41.11	41.16	10284.0
2015-03-26 08:30:00	MSFT	Stock	41.16	41.29	41.12	41.29	7804.0
2015-03-26 09:00:00	MSFT	Stock	41.24	41.46	41.2	41.2	25432.0
2015-03-26 09:30:00	MSFT	Stock	41.23	41.42	41.04	41.08	4832632.0
2015-03-26 10:00:00	MSFT	Stock	41.08	41.11	40.92	41.045	3962712.0
2015-03-26 10:30:00	MSFT	Stock	41.04	41.26	40.98	41.24	3348756.0
2015-03-26 11:00:00	MSFT	Stock	41.24	41.32	41.18	41.29	2251176.0
2015-03-26 11:30:00	MSFT	Stock	41.29	41.52	41.264	41.514	2148951.0
2015-03-26 12:00:00	MSFT	Stock	41.52	41.565	41.32	41.33	1880290.0
2015-03-26 12:30:00	MSFT	Stock	41.335	41.46	41.31	41.41	2006553.0

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

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