PREVIEW / stock_30min / 2014-12-30

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-12-30.parquet
  size:    1.6 MB
  rows:    83,076
  symbols: 3,523

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-30 04:00:00	AAPL	Stock	28.36	28.375	28.34	28.375	26852.0
2014-12-30 04:30:00	AAPL	Stock	28.3425	28.3725	28.3425	28.3625	24400.0
2014-12-30 05:00:00	AAPL	Stock	28.3625	28.3625	28.3625	28.3625	8000.0
2014-12-30 05:30:00	AAPL	Stock	28.375	28.41	28.375	28.4	10000.0
2014-12-30 06:00:00	AAPL	Stock	28.395	28.4025	28.395	28.4025	13716.0
2014-12-30 06:30:00	AAPL	Stock	28.4025	28.4075	28.4025	28.4075	3280.0
2014-12-30 07:00:00	AAPL	Stock	28.4075	28.4275	28.3975	28.4	26560.0
2014-12-30 07:30:00	AAPL	Stock	28.4025	28.435	28.395	28.42	61092.0
2014-12-30 08:00:00	AAPL	Stock	28.4	28.4475	28.4	28.445	113980.0
2014-12-30 08:30:00	AAPL	Stock	28.4325	28.4425	28.4	28.415	233912.0
2014-12-30 09:00:00	AAPL	Stock	28.425	28.4325	28.375	28.39	242752.0
2014-12-30 09:30:00	AAPL	Stock	28.3975	28.48	28.2775	28.335	13370532.0
2014-12-30 10:00:00	AAPL	Stock	28.3375	28.3425	28.225	28.2925	11353024.0
2014-12-30 10:30:00	AAPL	Stock	28.2925	28.3875	28.2628	28.3725	7580312.0
2014-12-30 11:00:00	AAPL	Stock	28.3725	28.3725	28.265	28.2975	5831760.0
2014-12-30 11:30:00	AAPL	Stock	28.2975	28.325	28.2875	28.31	3383040.0
2014-12-30 12:00:00	AAPL	Stock	28.31	28.3125	28.2325	28.2412	4411096.0
2014-12-30 12:30:00	AAPL	Stock	28.24	28.25	28.1275	28.19	9836228.0
2014-12-30 13:00:00	AAPL	Stock	28.1875	28.215	28.1475	28.1988	5932092.0
2014-12-30 13:30:00	AAPL	Stock	28.1975	28.2425	28.065	28.08	9170416.0
2014-12-30 14:00:00	AAPL	Stock	28.0775	28.125	28.0275	28.105	9250780.0
2014-12-30 14:30:00	AAPL	Stock	28.1025	28.16	28.0875	28.1545	5689568.0
2014-12-30 15:00:00	AAPL	Stock	28.1525	28.1875	28.085	28.11	4987488.0
2014-12-30 15:30:00	AAPL	Stock	28.11	28.1562	28.0675	28.145	10570128.0
2014-12-30 16:00:00	AAPL	Stock	28.13	28.3792	28.115	28.1325	6442824.0
2014-12-30 16:30:00	AAPL	Stock	28.13	28.15	28.1075	28.1075	477884.0
2014-12-30 17:00:00	AAPL	Stock	28.1125	28.13	28.1	28.1075	43952.0
2014-12-30 17:30:00	AAPL	Stock	28.1125	28.4975	28.1	28.4975	1406204.0
2014-12-30 18:00:00	AAPL	Stock	28.13	28.4975	28.1025	28.1025	132304.0
2014-12-30 18:30:00	AAPL	Stock	28.1025	28.135	28.1	28.115	55316.0
2014-12-30 19:00:00	AAPL	Stock	28.1325	28.1325	28.125	28.1325	10244.0
2014-12-30 19:30:00	AAPL	Stock	28.125	28.14	28.125	28.1375	28492.0
2014-12-30 06:30:00	MSFT	Stock	47.38	47.38	47.38	47.38	500.0
2014-12-30 07:00:00	MSFT	Stock	47.38	47.38	47.38	47.38	500.0
2014-12-30 07:30:00	MSFT	Stock	47.49	47.49	47.4	47.4	1200.0
2014-12-30 08:00:00	MSFT	Stock	47.4	47.55	47.4	47.55	1878.0
2014-12-30 08:30:00	MSFT	Stock	47.5	47.5	47.35	47.35	2018.0
2014-12-30 09:00:00	MSFT	Stock	47.48	47.48	47.32	47.41	9900.0
2014-12-30 09:30:00	MSFT	Stock	47.41	47.62	47.37	47.46	1556759.0
2014-12-30 10:00:00	MSFT	Stock	47.46	47.48	47.29	47.31	1091863.0
2014-12-30 10:30:00	MSFT	Stock	47.31	47.35	47.26	47.309	628605.0
2014-12-30 11:00:00	MSFT	Stock	47.31	47.37	47.29	47.35	752061.0
2014-12-30 11:30:00	MSFT	Stock	47.35	47.35	47.235	47.3	737407.0
2014-12-30 12:00:00	MSFT	Stock	47.295	47.32	47.25	47.255	820185.0
2014-12-30 12:30:00	MSFT	Stock	47.26	47.26	47.11	47.13	832996.0
2014-12-30 13:00:00	MSFT	Stock	47.13	47.13	47.02	47.075	1074034.0
2014-12-30 13:30:00	MSFT	Stock	47.07	47.08	46.84	46.936	1322799.0
2014-12-30 14:00:00	MSFT	Stock	46.93	47.0	46.885	46.92	666263.0
2014-12-30 14:30:00	MSFT	Stock	46.925	47.05	46.92	46.995	620002.0
2014-12-30 15:00:00	MSFT	Stock	46.99	47.05	46.98	46.995	820160.0

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

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