PREVIEW / stock_30min / 2014-08-15

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-08-15.parquet
  size:    1.6 MB
  rows:    81,396
  symbols: 3,564

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-08-15 04:00:00	AAPL	Stock	24.385	24.385	24.38	24.38	2000.0
2014-08-15 04:30:00	AAPL	Stock	24.4	24.4	24.4	24.4	4784.0
2014-08-15 05:00:00	AAPL	Stock	24.3825	24.4	24.3825	24.4	4400.0
2014-08-15 05:30:00	AAPL	Stock	24.4	24.405	24.4	24.405	6400.0
2014-08-15 06:30:00	AAPL	Stock	24.4125	24.4125	24.4075	24.4075	800.0
2014-08-15 07:00:00	AAPL	Stock	24.43	24.45	24.425	24.45	12956.0
2014-08-15 07:30:00	AAPL	Stock	24.44	24.44	24.4	24.41	51360.0
2014-08-15 08:00:00	AAPL	Stock	24.415	24.4475	24.4	24.42	216760.0
2014-08-15 08:30:00	AAPL	Stock	24.42	24.4325	24.415	24.4175	185344.0
2014-08-15 09:00:00	AAPL	Stock	24.4175	24.5125	24.3925	24.4725	1500232.0
2014-08-15 09:30:00	AAPL	Stock	24.475	24.4975	24.3625	24.445	38407336.0
2014-08-15 10:00:00	AAPL	Stock	24.445	24.5475	24.4358	24.5425	18739096.0
2014-08-15 10:30:00	AAPL	Stock	24.5475	24.5475	24.3375	24.3988	20372736.0
2014-08-15 11:00:00	AAPL	Stock	24.4	24.46	24.3425	24.355	14098784.0
2014-08-15 11:30:00	AAPL	Stock	24.3575	24.36	24.215	24.28	19866600.0
2014-08-15 12:00:00	AAPL	Stock	24.28	24.3125	24.235	24.2925	8531536.0
2014-08-15 12:30:00	AAPL	Stock	24.295	24.3725	24.2725	24.34	6628368.0
2014-08-15 13:00:00	AAPL	Stock	24.3375	24.38	24.3	24.375	5308004.0
2014-08-15 13:30:00	AAPL	Stock	24.3725	24.39	24.3325	24.35	5373684.0
2014-08-15 14:00:00	AAPL	Stock	24.3525	24.4225	24.3375	24.4225	7840436.0
2014-08-15 14:30:00	AAPL	Stock	24.4225	24.44	24.405	24.4225	6795868.0
2014-08-15 15:00:00	AAPL	Stock	24.4225	24.43	24.38	24.414	6406068.0
2014-08-15 15:30:00	AAPL	Stock	24.4142	24.5	24.4125	24.495	20036504.0
2014-08-15 16:00:00	AAPL	Stock	24.495	24.5375	24.47	24.4875	4013336.0
2014-08-15 16:30:00	AAPL	Stock	24.4925	24.5	24.47	24.4775	228432.0
2014-08-15 17:00:00	AAPL	Stock	24.4775	24.48	24.465	24.465	128956.0
2014-08-15 17:30:00	AAPL	Stock	24.4675	24.4875	24.4675	24.4875	55400.0
2014-08-15 18:00:00	AAPL	Stock	24.4875	24.4975	24.485	24.49	127224.0
2014-08-15 18:30:00	AAPL	Stock	24.4925	24.4975	24.4875	24.495	82188.0
2014-08-15 19:00:00	AAPL	Stock	24.495	24.4975	24.49	24.4975	68480.0
2014-08-15 19:30:00	AAPL	Stock	24.4975	24.5	24.49	24.4975	90376.0
2014-08-15 08:00:00	MSFT	Stock	44.31	44.46	44.31	44.4	2288.0
2014-08-15 09:00:00	MSFT	Stock	44.32	44.72	44.32	44.62	378795.0
2014-08-15 09:30:00	MSFT	Stock	44.58	44.78	44.48	44.62	9785039.0
2014-08-15 10:00:00	MSFT	Stock	44.62	44.73	44.54	44.705	2936306.0
2014-08-15 10:30:00	MSFT	Stock	44.71	44.72	44.48	44.615	3795904.0
2014-08-15 11:00:00	MSFT	Stock	44.61	44.65	44.44	44.54	2975009.0
2014-08-15 11:30:00	MSFT	Stock	44.53	44.64	44.41	44.49	2990183.0
2014-08-15 12:00:00	MSFT	Stock	44.49	44.58	44.4	44.559	1620460.0
2014-08-15 12:30:00	MSFT	Stock	44.56	44.62	44.49	44.535	1022161.0
2014-08-15 13:00:00	MSFT	Stock	44.54	44.58	44.455	44.57	914052.0
2014-08-15 13:30:00	MSFT	Stock	44.57	44.67	44.55	44.595	1775526.0
2014-08-15 14:00:00	MSFT	Stock	44.597	44.73	44.51	44.7	1819359.0
2014-08-15 14:30:00	MSFT	Stock	44.7	44.84	44.68	44.7	1624164.0
2014-08-15 15:00:00	MSFT	Stock	44.71	44.73	44.63	44.715	1599894.0
2014-08-15 15:30:00	MSFT	Stock	44.715	44.895	44.71	44.79	4991468.0
2014-08-15 16:00:00	MSFT	Stock	44.79	44.85	44.645	44.8	2141098.0
2014-08-15 16:30:00	MSFT	Stock	44.82	44.82	44.7	44.7	4016.0
2014-08-15 17:00:00	MSFT	Stock	44.79	44.88	44.79	44.88	62416.0
2014-08-15 17:30:00	MSFT	Stock	44.86	44.86	44.86	44.86	100.0

> showing 50 of 81,396 rows — these rows as CSV

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