PREVIEW / stock_30min / 2014-12-11

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-12-11.parquet
  size:    1.6 MB
  rows:    85,100
  symbols: 3,571

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-12-11 04:00:00	AAPL	Stock	28.05	28.06	28.015	28.0375	24584.0
2014-12-11 04:30:00	AAPL	Stock	28.0375	28.0475	28.0375	28.0475	3864.0
2014-12-11 05:00:00	AAPL	Stock	28.0525	28.07	28.0375	28.05	47200.0
2014-12-11 05:30:00	AAPL	Stock	28.055	28.075	28.04	28.04	17040.0
2014-12-11 06:00:00	AAPL	Stock	28.04	28.0575	28.0375	28.0375	5000.0
2014-12-11 06:30:00	AAPL	Stock	28.03	28.03	27.9675	27.9675	11064.0
2014-12-11 07:00:00	AAPL	Stock	27.975	28.015	27.9375	28.015	51988.0
2014-12-11 07:30:00	AAPL	Stock	28.01	28.11	28.0075	28.085	104772.0
2014-12-11 08:00:00	AAPL	Stock	28.0825	28.1075	27.97	28.0825	241692.0
2014-12-11 08:30:00	AAPL	Stock	28.0875	28.1475	28.0675	28.1175	328956.0
2014-12-11 09:00:00	AAPL	Stock	28.1125	28.125	28.0625	28.075	356068.0
2014-12-11 09:30:00	AAPL	Stock	28.065	28.2975	28.0325	28.2275	22563524.0
2014-12-11 10:00:00	AAPL	Stock	28.2225	28.365	28.19	28.359	18270640.0
2014-12-11 10:30:00	AAPL	Stock	28.36	28.4325	28.3375	28.3725	11582980.0
2014-12-11 11:00:00	AAPL	Stock	28.37	28.4025	28.2875	28.355	8796624.0
2014-12-11 11:30:00	AAPL	Stock	28.35	28.45	28.3402	28.3938	6818256.0
2014-12-11 12:00:00	AAPL	Stock	28.3925	28.4325	28.3488	28.3925	4898508.0
2014-12-11 12:30:00	AAPL	Stock	28.39	28.4	28.3288	28.345	4157940.0
2014-12-11 13:00:00	AAPL	Stock	28.345	28.3625	28.295	28.3102	5221268.0
2014-12-11 13:30:00	AAPL	Stock	28.3125	28.355	28.275	28.28	5096024.0
2014-12-11 14:00:00	AAPL	Stock	28.28	28.2875	28.1815	28.2	8564836.0
2014-12-11 14:30:00	AAPL	Stock	28.2	28.2275	27.975	27.9838	13219136.0
2014-12-11 15:00:00	AAPL	Stock	27.9825	28.14	27.98	28.1	11536932.0
2014-12-11 15:30:00	AAPL	Stock	28.0975	28.1725	27.835	27.9075	22806936.0
2014-12-11 16:00:00	AAPL	Stock	27.905	28.19	27.8375	27.85	8459408.0
2014-12-11 16:30:00	AAPL	Stock	27.8625	28.3908	27.785	27.8	333484.0
2014-12-11 17:00:00	AAPL	Stock	27.8	27.905	27.7938	27.85	236540.0
2014-12-11 17:30:00	AAPL	Stock	27.84	27.905	27.825	27.8425	85176.0
2014-12-11 18:00:00	AAPL	Stock	27.8425	27.8725	27.8425	27.855	26284.0
2014-12-11 18:30:00	AAPL	Stock	27.85	27.885	27.85	27.8725	65248.0
2014-12-11 19:00:00	AAPL	Stock	27.87	27.87	27.8425	27.85	45988.0
2014-12-11 19:30:00	AAPL	Stock	27.8575	27.8625	27.825	27.8325	23520.0
2014-12-11 06:00:00	MSFT	Stock	46.92	46.92	46.92	46.92	100.0
2014-12-11 08:00:00	MSFT	Stock	47.0	47.05	47.0	47.05	300.0
2014-12-11 08:30:00	MSFT	Stock	47.05	47.1	47.04	47.1	5742.0
2014-12-11 09:00:00	MSFT	Stock	47.05	47.05	47.04	47.05	1500.0
2014-12-11 09:30:00	MSFT	Stock	47.08	47.1	46.68	47.005	4446648.0
2014-12-11 10:00:00	MSFT	Stock	47.0	47.4	46.925	47.34	2831214.0
2014-12-11 10:30:00	MSFT	Stock	47.34	47.5	47.31	47.43	2601973.0
2014-12-11 11:00:00	MSFT	Stock	47.44	47.62	47.42	47.57	1489378.0
2014-12-11 11:30:00	MSFT	Stock	47.57	47.74	47.53	47.73	1348140.0
2014-12-11 12:00:00	MSFT	Stock	47.73	47.74	47.53	47.59	730838.0
2014-12-11 12:30:00	MSFT	Stock	47.595	47.64	47.56	47.63	869986.0
2014-12-11 13:00:00	MSFT	Stock	47.63	47.635	47.522	47.58	823424.0
2014-12-11 13:30:00	MSFT	Stock	47.575	47.69	47.553	47.61	1120566.0
2014-12-11 14:00:00	MSFT	Stock	47.61	47.655	47.48	47.49	1187953.0
2014-12-11 14:30:00	MSFT	Stock	47.49	47.515	47.27	47.316	1559950.0
2014-12-11 15:00:00	MSFT	Stock	47.315	47.51	47.3	47.46	1449206.0
2014-12-11 15:30:00	MSFT	Stock	47.46	47.53	47.06	47.18	3822751.0
2014-12-11 16:00:00	MSFT	Stock	47.16	47.505	47.03	47.445	2272957.0

> showing 50 of 85,100 rows — these rows as CSV

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