PREVIEW / stock_30min / 2015-04-01

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-04-01.parquet
  size:    1.6 MB
  rows:    83,420
  symbols: 3,504

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-04-01 04:00:00	AAPL	Stock	31.075	31.1025	31.075	31.09	6800.0
2015-04-01 04:30:00	AAPL	Stock	31.08	31.0825	31.08	31.0825	1200.0
2015-04-01 05:30:00	AAPL	Stock	31.12	31.125	31.1075	31.1075	32668.0
2015-04-01 06:00:00	AAPL	Stock	31.11	31.1675	31.1075	31.16	27364.0
2015-04-01 06:30:00	AAPL	Stock	31.1575	31.1625	31.1375	31.1625	16004.0
2015-04-01 07:00:00	AAPL	Stock	31.15	31.175	31.0575	31.0675	95668.0
2015-04-01 07:30:00	AAPL	Stock	31.05	31.06	31.0175	31.06	30184.0
2015-04-01 08:00:00	AAPL	Stock	31.075	31.1725	31.0175	31.1025	550772.0
2015-04-01 08:30:00	AAPL	Stock	31.09	31.2125	31.09	31.2025	337872.0
2015-04-01 09:00:00	AAPL	Stock	31.2075	31.2375	31.1075	31.1925	577828.0
2015-04-01 09:30:00	AAPL	Stock	31.195	31.28	30.7775	30.8675	30651984.0
2015-04-01 10:00:00	AAPL	Stock	30.8675	31.0225	30.775	30.935	19136168.0
2015-04-01 10:30:00	AAPL	Stock	30.9375	31.045	30.855	30.9875	12021472.0
2015-04-01 11:00:00	AAPL	Stock	30.985	31.1275	30.92	31.03	11357872.0
2015-04-01 11:30:00	AAPL	Stock	31.0325	31.0975	30.97	31.02	7607468.0
2015-04-01 12:00:00	AAPL	Stock	31.0175	31.0575	30.925	31.0225	5910272.0
2015-04-01 12:30:00	AAPL	Stock	31.025	31.03	30.9312	30.9625	4377848.0
2015-04-01 13:00:00	AAPL	Stock	30.9625	31.02	30.9225	31.015	4664004.0
2015-04-01 13:30:00	AAPL	Stock	31.0175	31.1725	31.01	31.1055	9478888.0
2015-04-01 14:00:00	AAPL	Stock	31.1075	31.1222	30.9625	30.985	8133612.0
2015-04-01 14:30:00	AAPL	Stock	30.985	31.07	30.935	31.019	6926716.0
2015-04-01 15:00:00	AAPL	Stock	31.02	31.0288	30.945	30.9525	7065272.0
2015-04-01 15:30:00	AAPL	Stock	30.95	31.0625	30.9125	31.0575	14713020.0
2015-04-01 16:00:00	AAPL	Stock	31.0625	31.1225	31.003	31.1025	7509196.0
2015-04-01 16:30:00	AAPL	Stock	31.1025	31.1175	30.9938	31.105	73028.0
2015-04-01 17:00:00	AAPL	Stock	31.1125	31.1125	31.0625	31.11	180240.0
2015-04-01 17:30:00	AAPL	Stock	31.1075	31.135	31.0132	31.135	234628.0
2015-04-01 18:00:00	AAPL	Stock	31.1375	31.18	31.135	31.1725	195420.0
2015-04-01 18:30:00	AAPL	Stock	31.17	31.185	31.1525	31.1675	75732.0
2015-04-01 19:00:00	AAPL	Stock	31.1675	31.1775	31.16	31.1625	35056.0
2015-04-01 19:30:00	AAPL	Stock	31.1625	31.1625	31.115	31.135	59392.0
2015-04-01 04:00:00	MSFT	Stock	40.6	40.6	40.59	40.59	215.0
2015-04-01 06:00:00	MSFT	Stock	40.73	40.73	40.73	40.73	100.0
2015-04-01 07:00:00	MSFT	Stock	40.73	40.73	40.43	40.5	12901.0
2015-04-01 07:30:00	MSFT	Stock	40.5	40.5	40.41	40.41	2800.0
2015-04-01 08:00:00	MSFT	Stock	40.47	40.655	40.47	40.52	18502.0
2015-04-01 08:30:00	MSFT	Stock	40.57	40.655	40.57	40.61	14985.0
2015-04-01 09:00:00	MSFT	Stock	40.655	40.67	40.57	40.63	43767.0
2015-04-01 09:30:00	MSFT	Stock	40.61	40.76	40.31	40.43	6350751.0
2015-04-01 10:00:00	MSFT	Stock	40.42	40.58	40.38	40.48	2484720.0
2015-04-01 10:30:00	MSFT	Stock	40.49	40.67	40.43	40.605	2889459.0
2015-04-01 11:00:00	MSFT	Stock	40.6	40.665	40.53	40.56	1907150.0
2015-04-01 11:30:00	MSFT	Stock	40.555	40.64	40.51	40.54	1952460.0
2015-04-01 12:00:00	MSFT	Stock	40.54	40.59	40.5	40.55	1589201.0
2015-04-01 12:30:00	MSFT	Stock	40.55	40.61	40.5	40.57	1870713.0
2015-04-01 13:00:00	MSFT	Stock	40.57	40.64	40.56	40.616	1160694.0
2015-04-01 13:30:00	MSFT	Stock	40.61	40.69	40.56	40.67	1363309.0
2015-04-01 14:00:00	MSFT	Stock	40.675	40.716	40.64	40.676	2535622.0
2015-04-01 14:30:00	MSFT	Stock	40.675	40.69	40.61	40.646	1623444.0
2015-04-01 15:00:00	MSFT	Stock	40.645	40.66	40.59	40.61	2690940.0

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

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