PREVIEW / stock_30min / 2015-01-12

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-01-12.parquet
  size:    1.6 MB
  rows:    84,211
  symbols: 3,545

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-01-12 04:30:00	AAPL	Stock	28.1	28.3	28.1	28.3	10488.0
2015-01-12 05:00:00	AAPL	Stock	28.15	28.15	28.1375	28.1375	9000.0
2015-01-12 05:30:00	AAPL	Stock	28.175	28.175	28.1625	28.1625	8200.0
2015-01-12 06:00:00	AAPL	Stock	28.1625	28.18	28.1625	28.1625	18608.0
2015-01-12 06:30:00	AAPL	Stock	28.15	28.1525	28.1325	28.1325	28416.0
2015-01-12 07:00:00	AAPL	Stock	28.1525	28.175	28.1375	28.1375	67712.0
2015-01-12 07:30:00	AAPL	Stock	28.1525	28.16	28.1225	28.1275	61860.0
2015-01-12 08:00:00	AAPL	Stock	28.1325	28.175	28.05	28.0525	646004.0
2015-01-12 08:30:00	AAPL	Stock	28.0525	28.0625	28.0025	28.0325	343592.0
2015-01-12 09:00:00	AAPL	Stock	28.0375	28.1525	28.035	28.145	180196.0
2015-01-12 09:30:00	AAPL	Stock	28.1575	28.16	27.61	27.63	28612960.0
2015-01-12 10:00:00	AAPL	Stock	27.6325	27.6375	27.34	27.495	26450628.0
2015-01-12 10:30:00	AAPL	Stock	27.495	27.675	27.45	27.6562	14346388.0
2015-01-12 11:00:00	AAPL	Stock	27.6575	27.6825	27.5775	27.6025	10159440.0
2015-01-12 11:30:00	AAPL	Stock	27.6025	27.6225	27.455	27.5125	9456096.0
2015-01-12 12:00:00	AAPL	Stock	27.5125	27.615	27.5025	27.5875	6379148.0
2015-01-12 12:30:00	AAPL	Stock	27.5875	27.6075	27.425	27.4325	8540596.0
2015-01-12 13:00:00	AAPL	Stock	27.4348	27.4425	27.2275	27.2425	14958132.0
2015-01-12 13:30:00	AAPL	Stock	27.245	27.36	27.2332	27.295	8748416.0
2015-01-12 14:00:00	AAPL	Stock	27.295	27.355	27.225	27.23	8326368.0
2015-01-12 14:30:00	AAPL	Stock	27.2278	27.3175	27.2	27.3175	9867444.0
2015-01-12 15:00:00	AAPL	Stock	27.3175	27.3712	27.2475	27.2975	10026356.0
2015-01-12 15:30:00	AAPL	Stock	27.2975	27.415	27.205	27.315	22100672.0
2015-01-12 16:00:00	AAPL	Stock	27.3125	28.1095	27.2925	27.335	5611856.0
2015-01-12 16:30:00	AAPL	Stock	27.335	27.3425	27.3075	27.3425	120552.0
2015-01-12 17:00:00	AAPL	Stock	27.3425	27.3425	27.3325	27.335	73752.0
2015-01-12 17:30:00	AAPL	Stock	27.325	27.335	27.3125	27.325	35956.0
2015-01-12 18:00:00	AAPL	Stock	27.3325	27.36	27.3125	27.36	72156.0
2015-01-12 18:30:00	AAPL	Stock	27.36	27.36	27.3125	27.33	88172.0
2015-01-12 19:00:00	AAPL	Stock	27.3375	27.35	27.325	27.3325	57372.0
2015-01-12 19:30:00	AAPL	Stock	27.3275	27.3475	27.325	27.33	53368.0
2015-01-12 04:00:00	MSFT	Stock	47.4	47.4	47.38	47.38	2600.0
2015-01-12 04:30:00	MSFT	Stock	47.48	47.5	47.48	47.48	1626.0
2015-01-12 05:00:00	MSFT	Stock	47.51	47.51	47.51	47.51	300.0
2015-01-12 06:00:00	MSFT	Stock	47.52	47.52	47.52	47.52	938.0
2015-01-12 06:30:00	MSFT	Stock	47.5	47.5	47.48	47.48	800.0
2015-01-12 07:00:00	MSFT	Stock	47.51	47.51	47.4	47.4	4293.0
2015-01-12 07:30:00	MSFT	Stock	47.5	47.5	47.4	47.4	631.0
2015-01-12 08:00:00	MSFT	Stock	47.32	47.38	47.3	47.3	6065.0
2015-01-12 08:30:00	MSFT	Stock	47.35	47.35	47.3	47.3	600.0
2015-01-12 09:00:00	MSFT	Stock	47.35	47.47	47.32	47.39	14873.0
2015-01-12 09:30:00	MSFT	Stock	47.42	47.54	46.51	46.73	2746988.0
2015-01-12 10:00:00	MSFT	Stock	46.73	46.96	46.59	46.74	2194453.0
2015-01-12 10:30:00	MSFT	Stock	46.75	46.84	46.63	46.8	1424466.0
2015-01-12 11:00:00	MSFT	Stock	46.81	46.85	46.704	46.78	1071306.0
2015-01-12 11:30:00	MSFT	Stock	46.78	46.81	46.585	46.639	1023928.0
2015-01-12 12:00:00	MSFT	Stock	46.64	46.86	46.63	46.825	1016340.0
2015-01-12 12:30:00	MSFT	Stock	46.82	46.855	46.62	46.69	718823.0
2015-01-12 13:00:00	MSFT	Stock	46.69	46.75	46.63	46.633	745437.0
2015-01-12 13:30:00	MSFT	Stock	46.63	46.75	46.61	46.685	1123039.0

> showing 50 of 84,211 rows — these rows as CSV

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